public ArrayList<ListaAlquiler> get_alquiler_byclientefecha(String condicion) {
Connection cnn = null;
CallableStatement cstmt = null;
ArrayList<ListaAlquiler> listAlquiler = new ArrayList<ListaAlquiler>();
try {
cnn = BD.getConnection();
String sql = "select * from get_alquiler_byclientefecha where " + condicion;
cstmt = cnn.prepareCall(sql);
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
ListaAlquiler a = new ListaAlquiler();
a.setIdCliente(rs.getInt("int_id"));
a.setVar_nombre_cliente(rs.getString("var_nombre_cliente"));
a.setVar_apepaterno(rs.getString("var_apepaterno"));
a.setVar_apematerno(rs.getString("var_apematerno"));
a.setVar_nombre_material(rs.getString("var_nombre_material"));
a.setDat_fechinicio(rs.getTimestamp("dat_fechinicio"));
a.setDat_fechfin(rs.getTimestamp("dat_fechfin"));
a.setInt_cantidad(rs.getInt("int_cantidad"));
a.setDec_monto(rs.getDouble("dec_monto"));
a.setDat_fechaRegistro(rs.getTimestamp("dat_fechaRegistro"));
a.setVar_numero(rs.getString("var_numero"));
listAlquiler.add(a);
}
cstmt.close();
cnn.close();
} catch (SQLException a) {
System.out.println("" + a);
}
return listAlquiler;
}
public ArrayList<DetalleFactura> buscar(Factura entidad) throws Exception {
ArrayList<DetalleFactura> lista = new ArrayList<DetalleFactura>();
try {
cnn = Conexion.getConexion();
CallableStatement cs = null;
cs = cnn.prepareCall("call uspListDetalleFactrua(?)");
cs.setInt(1, entidad.getIdFactura());
rs = cs.executeQuery();
while (rs.next()) {
DetalleFactura objeto = new DetalleFactura();
objeto.setIdDetalleFactura(rs.getInt("Iddetallefactura"));
objeto.setIdProducto(rs.getInt("Idproducto"));
objeto.setCantidad(rs.getInt("Cantidad"));
objeto.setPrecio(rs.getDouble("Precio"));
objeto.setSubTotal(rs.getDouble("Subtotal"));
objeto.setIdFactura(rs.getInt("Idfactura"));
objeto.setDProducto(rs.getString("DProducto"));
lista.add(objeto);
}
cnn.close();
cs.close();
} catch (SQLException ex) {
throw ex;
}
return lista;
}
public static Servicios ObtenerServicios(int IdServicio) throws Exception {
Servicios miServicio = null;
CallableStatement ObjProcedimiento;
Connection conector = estado();
try {
ObjProcedimiento = conector.prepareCall("{call ObtenerServicios(?)}");
ObjProcedimiento.setInt(1, IdServicio);
ResultSet respuesta = ObjProcedimiento.executeQuery();
miServicio = new Servicios();
while (respuesta.next()) {
miServicio.setIdServicio(respuesta.getInt(1));
miServicio.setNombre(respuesta.getString(2));
}
} catch (Exception pp) {
JOptionPane.showMessageDialog(
null,
"Error en Catalogo: ObtenerServicios " + pp.getMessage(),
"ATENCION",
JOptionPane.WARNING_MESSAGE);
} finally {
conector.close();
}
return miServicio;
}
public User getUser(String username) {
con = new DBConnection();
User objUser = null;
try {
cstmt = con.connection.prepareCall("{call getUser(?)}");
cstmt.setString(1, username);
ResultSet rsUser = cstmt.executeQuery();
if (rsUser.next()) {
objUser = new User();
objUser.setUserName(rsUser.getString("UserName"));
objUser.setPassword(rsUser.getString("Password"));
UserRole objUserRole = new UserRole();
objUserRole.setRole(rsUser.getString("Role"));
objUser.setUsertype(objUserRole);
}
} catch (Exception e) {
e.getMessage();
} finally {
con.closeConnection();
}
return objUser;
}
public static ArrayList<Servicios> ListadoServicios() throws Exception {
ArrayList<Servicios> lista = new ArrayList<Servicios>();
CallableStatement ObjProcedimiento;
Connection conector = estado();
try {
ObjProcedimiento = conector.prepareCall("{call ListarServicios()}");
ResultSet respuesta = ObjProcedimiento.executeQuery();
if (respuesta.next()) {
do {
Servicios miServicio = new Servicios(respuesta.getInt(1), respuesta.getString(2));
lista.add(miServicio);
} while (respuesta.next());
}
} catch (Exception pp) {
JOptionPane.showMessageDialog(
null,
"Error en Catalogo: ListadoServicios " + pp.getMessage(),
"ATENCION",
JOptionPane.WARNING_MESSAGE);
} finally {
conector.close();
}
return lista;
}
public static List<Pago> buscarPagos() {
ConnectionPool pool = ConnectionPool.getInstance();
Connection connection = pool.getConnection();
CallableStatement cs = null;
ResultSet rs = null;
try {
List<Pago> pagos = new ArrayList();
cs = connection.prepareCall("{ call listaPago() }");
rs = cs.executeQuery();
while (rs.next()) {
Pago pag = new Pago(rs.getInt("idMetodoPago"), rs.getString("nombreMetodoPago"));
pagos.add(pag);
}
return pagos;
} catch (Exception ex) {
ex.printStackTrace();
return null;
} finally {
DBUtil.closeResultSet(rs);
DBUtil.closeStatement(cs);
pool.freeConnection(connection);
}
}
public static int insertarVenta(Venta v) {
ConnectionPool pool = ConnectionPool.getInstance();
Connection connection = pool.getConnection();
CallableStatement cs = null;
ResultSet rs = null;
Venta ven = null;
try {
cs = connection.prepareCall("{ call insertVenta(?, ?, ?, ?) }");
cs.setInt(1, v.getUsuarioVenta().getId());
cs.setDouble(2, v.getSubtotal());
cs.setInt(3, v.getPagoVenta().getIdPago());
cs.setInt(4, v.getUsuarioVenta().getSucursal().getIdSucursal());
rs = cs.executeQuery();
while (rs.next()) {
ven = new Venta(rs.getInt("idVenta"));
}
return ven.getIdVenta();
} catch (Exception ex) {
ex.printStackTrace();
return 0;
} finally {
DBUtil.closeStatement(cs);
pool.freeConnection(connection);
}
}
public Guia obtener(int id) throws Exception {
Guia objeto = new Guia();
try {
cnn = Conexion.getConexion();
CallableStatement cs = null;
cs = cnn.prepareCall("call uspGetGuia(?)");
cs.setInt(1, id);
rs = cs.executeQuery();
while (rs.next()) {
objeto.setIdGuia(rs.getInt("Idguia"));
objeto.setPeriodo(rs.getString("Periodo"));
objeto.setNumero(rs.getString("Numero"));
objeto.setFecha(rs.getString("Fecha"));
objeto.setTipoCambio(rs.getDouble("Tipocambio"));
objeto.setSerie(rs.getString("Serie"));
objeto.setNumeroDocumento(rs.getString("Numerodocumento"));
objeto.setIdTipoMovimiento(rs.getInt("Idtipomovimiento"));
objeto.setReferencia(rs.getString("Referencia"));
objeto.setIdOrdenProduccion(rs.getInt("Idordenproduccion"));
objeto.setIdClienteProveedor(rs.getInt("Idclienteproveedor"));
objeto.setIdAlmacen(rs.getInt("Idalmacen"));
objeto.setObservaciones(rs.getString("Observaciones"));
objeto.setDOrdenProduccion(rs.getString("DOrdenProduccion"));
objeto.setDClienteProveedor(rs.getString("DClienteProveedor"));
}
cnn.close();
cs.close();
} catch (SQLException ex) {
throw ex;
}
return objeto;
}
public static List<Departamento> buscarDepartamentos() {
ConnectionPool pool = ConnectionPool.getInstance();
Connection connection = pool.getConnection();
CallableStatement cs = null;
ResultSet rs = null;
try {
List<Departamento> departamentos = new ArrayList();
cs = connection.prepareCall("{ call listaDepartamento() }");
rs = cs.executeQuery();
while (rs.next()) {
Departamento dpo =
new Departamento(rs.getInt("idDepartamento"), rs.getString("nombreDepartamento"));
departamentos.add(dpo);
}
return departamentos;
} catch (Exception ex) {
ex.printStackTrace();
return null;
} finally {
DBUtil.closeResultSet(rs);
DBUtil.closeStatement(cs);
pool.freeConnection(connection);
}
}
// ---------------combo para seleccionar el tipo d epersona
public static List<TipoPersona> getCargarComboTipoPersona() {
List<TipoPersona> arreglo = null;
TipoPersona obj = null;
Connection conexion = null;
ResultSet rs = null;
try {
conexion = ControladorBD.darConexionBD();
CallableStatement st = conexion.prepareCall("{call sp_combo_tipo_persona()}");
rs = st.executeQuery();
if (rs.next()) {
arreglo = new ArrayList<TipoPersona>();
do {
obj = new TipoPersona();
obj.setId_tipo_persona(rs.getInt("id_tipo_persona"));
obj.setNombre(rs.getString("nombre"));
arreglo.add(obj);
} while (rs.next());
}
rs.close();
st.close();
conexion.close();
} catch (Exception error) {
System.out.println("Error en el metodo por: " + error.getMessage());
error.printStackTrace();
}
return arreglo;
}
public FaqCategories selectById(int id) throws SQLException {
try {
connection = ConnectionFactory.getInstance().getConnection();
cs = connection.prepareCall("{call faq_categories_FindByPK(?)}");
cs.setInt(1, id);
resultSet = cs.executeQuery();
FaqCategories faqc = null;
while (resultSet.next()) {
faqc =
new FaqCategories(
resultSet.getInt("idFAQ_Categories"),
resultSet.getInt("idLanguage"),
resultSet.getString("category_name"),
resultSet.getString("category_description"));
}
return faqc;
} finally {
if (resultSet != null) {
resultSet.close();
}
if (cs != null) {
cs.close();
}
if (connection != null) {
connection.close();
}
}
}
public String getStatuses() {
ResultSet rs = null;
try (CallableStatement cs = conn.prepareCall("{call ti_getStatuses}")) {
rs = cs.executeQuery();
if (rs != null) {
ArrayList<Status> statuses = new ArrayList<>();
while (rs.next()) {
// (int status_id, String displayName, boolean isSystem, boolean isNotify, boolean
// isClosed, String notifyMsg)
statuses.add(
new Status(
rs.getInt("status_id"),
rs.getString("display_name"),
rs.getBoolean("isSystem"),
rs.getBoolean("isNotify"),
rs.getBoolean("isClosed"),
rs.getString("notify_msg")));
}
StatusList statusList = new StatusList(statuses);
return generateGson(statusList);
}
} catch (SQLException e) {
e.printStackTrace();
}
return "";
}
public boolean insertarAlquiler(
int idtrabajador,
int idCliente,
ArrayList<Detalle_Alquiler> lista_detalle,
int identificador) {
boolean resultado = false;
Connection cnn = null;
CallableStatement cstmt = null;
CallableStatement cstm1 = null;
CallableStatement cstm2 = null;
int id_alquiler = 0;
try {
cnn = BD.getConnection();
cnn.setAutoCommit(false);
String sql = "call spI_Alquiler (?,?,?,?);";
cstmt = cnn.prepareCall(sql);
cstmt.setInt(1, 2);
cstmt.setInt(2, idCliente);
cstmt.setInt(3, idtrabajador);
cstmt.setInt(4, identificador);
ResultSet rs = cstmt.executeQuery();
if (rs.next()) {
id_alquiler = rs.getInt("int_id");
}
for (int i = 0; i < lista_detalle.size(); i++) {
String sql1 = "call spI_DetalleAlquiler(?,?,?,?,?,?,?);";
cstm1 = cnn.prepareCall(sql1);
cstm1.setInt(1, id_alquiler);
cstm1.setInt(2, lista_detalle.get(i).getMaterial_id());
cstm1.setInt(3, lista_detalle.get(i).getInt_cantidad());
cstm1.setDouble(4, lista_detalle.get(i).getDec_monto());
cstm1.setTimestamp(5, lista_detalle.get(i).getDat_fechfin());
cstm1.setTimestamp(6, lista_detalle.get(i).getDat_fechinicio());
cstm1.setInt(7, lista_detalle.get(i).getInt_horas());
cstm1.execute();
}
// Registrar Pagos
String sql2 = "call spI_Pagos_ByAlquiler(?,?);";
cstm2 = cnn.prepareCall(sql2);
cstm2.setInt(1, 1); // es el codigo del usuario cambiar despues
cstm2.setInt(2, id_alquiler);
cstm2.execute();
cnn.commit();
resultado = true;
} catch (SQLException s) {
try {
cnn.rollback();
} catch (SQLException b) {
}
System.out.println("aquí es :/ " + s);
} finally {
try {
cstmt.close();
cnn.close();
} catch (SQLException ex) {
}
}
return resultado;
}
public List<TypeBean> TypeList() {
List<TypeBean> list = new ArrayList<TypeBean>();
Connection conn = null;
CallableStatement stmt = null;
ResultSet rs = null;
try {
conn = DbConnection.getConnection();
stmt = conn.prepareCall("{call product_type()}");
// String select = "select type_id,p_type FROM product_type";
// stmt.setString(1, "type_id");
// stmt.setString(2, "p_type");
// .executeQuery("CREATE PROCEDURE shopping_expo.product_type(IN type_id INT , IN p_type
// nvarchar(30)) BEGIN select type_id,p_type FROM product_type;END;");
System.out.println("Type Callable Executed");
rs = stmt.executeQuery();
while (rs.next()) {
lb = new TypeBean();
lb.setpType_Id(rs.getString("TYPE_ID"));
lb.setpType(rs.getString("P_TYPE"));
list.add(lb);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public List<TypeBean> list() {
List<TypeBean> list = new ArrayList<TypeBean>();
Connection conn = null;
CallableStatement stmt = null;
ResultSet rs = null;
try {
conn = DbConnection.getConnection();
stmt = conn.prepareCall("{CALL getAllTypeProcedure()}");
// String select = "select * from product_type";
rs = stmt.executeQuery();
while (rs.next()) {
lb = new TypeBean();
lb.setpType_Id(rs.getString("TYPE_ID"));
lb.setpType(rs.getString("P_TYPE"));
list.add(lb);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("Exception :" + e.getMessage() + e.getErrorCode());
e.printStackTrace();
}
return list;
}
public ArrayList getAllItems() {
con = new DBConnection();
ArrayList list = new ArrayList();
try {
cstmt = con.connection.prepareCall("{call getAllItemsForAdmin ()}");
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
Map objMap = new HashMap();
objMap.put("ItemID", rs.getInt("ItemID"));
objMap.put("ItemName", rs.getString("ItemName"));
objMap.put("TypeID", rs.getInt("TypeID"));
objMap.put("TypeName", rs.getString("TypeName"));
objMap.put("UserName", rs.getString("UserName"));
list.add(objMap);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return list;
}
public List<Area> getAllArea() {
List<Area> areaList = new ArrayList<Area>();
con = new DBConnection();
try {
cstmt = con.connection.prepareCall("{call getAllArea()}");
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
Area objArea = new Area();
objArea.setAreaID(rs.getInt("AreaID"));
objArea.setAreaName(rs.getString("AreaName"));
City c = new City();
c.setCityName(rs.getString("CityName"));
objArea.setCity(c);
areaList.add(objArea);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return areaList;
}
public List<ItemType> getAllItemType() {
List<ItemType> typeList = new ArrayList<ItemType>();
con = new DBConnection();
try {
cstmt = con.connection.prepareCall("{call getAllItemType()}");
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
ItemType objItemType = new ItemType();
objItemType.setTypeName(rs.getString("TypeName"));
objItemType.setTypeID(rs.getInt("TypeID"));
typeList.add(objItemType);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return typeList;
}
public ArrayList<FaqCategories> select() throws SQLException {
try {
connection = ConnectionFactory.getInstance().getConnection();
cs = connection.prepareCall("{Call faq_categories_FindAll}");
resultSet = cs.executeQuery();
ArrayList<FaqCategories> list = new ArrayList<FaqCategories>();
while (resultSet.next()) {
FaqCategories faqc =
new FaqCategories(
resultSet.getInt("idFAQ_Categories"),
resultSet.getInt("idLanguage"),
resultSet.getString("categoy_name"),
resultSet.getString("category_description"));
list.add(faqc);
}
return list;
} finally {
if (resultSet != null) {
resultSet.close();
}
if (cs != null) {
cs.close();
}
if (connection != null) {
connection.close();
}
}
}
@Override
public List<MaterialBean> buscarMateriales(int codTipoMaterial, String descripcion)
throws Exception {
Connection cn = MySqlDbConn.obtenerConexion();
CallableStatement st = cn.prepareCall("{ call pr_buscarMateriales(?, ?) }");
st.setInt(1, codTipoMaterial);
st.setString(2, descripcion);
ResultSet rs = st.executeQuery();
ArrayList<MaterialBean> arr = new ArrayList<MaterialBean>();
while (rs.next()) {
MaterialBean material = new MaterialBean();
material.setStrCodMaterial(rs.getString("cod_mat"));
material.setIntCodTipoMaterial(rs.getInt("cod_tip_mat"));
material.setStrTipoMaterial(rs.getString("tip_mat"));
material.setStrDescripMaterial(rs.getString("desc_mat"));
material.setStrUnidadMedida(rs.getString("und_med_mat"));
material.setBdPrecioUnitario(rs.getBigDecimal("prec_uni_mat"));
arr.add(material);
}
rs.close();
cn.close();
return arr;
}
@Override
public String lecturas(int periodo, int borrar) {
try {
Connection con = dao.getConnection();
String sql = "{call P_INT_LECTURAS(?,?,?)}";
CallableStatement statement = con.prepareCall(sql);
statement.setInt(1, periodo);
statement.setInt(2, borrar); // preguntar a javier
statement.registerOutParameter(3, Types.VARCHAR);
statement.executeQuery();
String error = statement.getString(3);
con.close();
return error;
} catch (SQLException ex) {
ex.printStackTrace();
Logger.getLogger(InterfazManagerImpl.class.getName()).log(Level.SEVERE, null, ex);
return "Error al ejecutar en la BD";
}
}
private void cargar() {
DefaultTableModel tabla = new DefaultTableModel();
try {
tabla.addColumn("CODIGO");
tabla.addColumn("NOMBRES");
tabla.addColumn("APELLIDOS");
tabla.addColumn("SEXO");
tabla.addColumn("DNI");
tabla.addColumn("TELEFONO");
tabla.addColumn("RUC");
tabla.addColumn("E_MAIL");
tabla.addColumn("DIRECCION");
cts = cn.prepareCall("{call mostrarclientes}");
r = cts.executeQuery();
while (r.next()) {
Object dato[] = new Object[9];
for (int i = 0; i < 9; i++) {
dato[i] = r.getString(i + 1);
}
tabla.addRow(dato);
}
this.jTable1.setModel(tabla);
jLabel2.setText("" + jTable1.getRowCount());
} catch (Exception e) {
}
}
@Override
public ResultSet ExecuteSproc(String sprocName, String[] parameters, int[] returnColumnTypes)
throws SQLException {
if (_conn.isClosed()) {
throw new SQLException("Connection was already closed");
}
try {
String paramsList = "";
int listSize = parameters.length;
for (int i = 0; i < listSize; i++) {
paramsList += parameters[i];
if (i != listSize - 1) {
paramsList += ", ";
}
}
CallableStatement statement =
_conn.prepareCall("{call " + sprocName + "(" + paramsList + ")}");
for (int i = 0; i < returnColumnTypes.length; i++) {
statement.registerOutParameter(i + 1, returnColumnTypes[i]);
}
return statement.executeQuery();
} catch (SQLException ex) {
throw ex;
}
}
public List<ClientListInfo> getClientsDataTable(
int startRecord, int recordsToShow, String clientNameKey) {
try {
Session session = sessionFactory.getCurrentSession();
CallableStatement cstmt =
session.connection().prepareCall("{call ADMIN_CLIENT_MANAGEMENT(?,?,?)}");
List<ClientListInfo> clientListInfo = new ArrayList<ClientListInfo>();
cstmt.setInt(1, startRecord);
cstmt.setInt(2, recordsToShow);
cstmt.setString(3, clientNameKey.trim());
ResultSet rs = cstmt.executeQuery();
if (rs != null) {
while (rs.next()) {
ClientListInfo clientInfo = new ClientListInfo();
clientInfo.setIndex(rs.getInt(1));
clientInfo.setClientId(rs.getInt(2));
clientInfo.setClientName(rs.getString(3));
clientInfo.setBusinessType(rs.getString(4));
clientInfo.setContactPerson(rs.getString(5));
clientInfo.setWorkPhone(rs.getString(6));
clientInfo.setMobileNumber(rs.getString(7));
clientInfo.setIsActive(rs.getBoolean(9));
clientInfo.setEdit(rs.getInt(2));
clientInfo.setDelete(rs.getInt(2));
clientInfo.setTotalRows(rs.getInt(10));
clientListInfo.add(clientInfo);
}
}
return clientListInfo;
} catch (Exception e) {
log.error("Exception in get Client Data Table : DAO :" + ExceptionUtils.getStackTrace(e));
}
return null;
}
public static List<Sucursal> buscarSucursales() {
ConnectionPool pool = ConnectionPool.getInstance();
Connection connection = pool.getConnection();
CallableStatement cs = null;
ResultSet rs = null;
try {
List<Sucursal> sucursales = new ArrayList();
cs = connection.prepareCall("{ call listaSucursal() }");
rs = cs.executeQuery();
while (rs.next()) {
Sucursal suc = new Sucursal(rs.getInt("idSucursal"), rs.getString("nombreSucursal"));
sucursales.add(suc);
}
return sucursales;
} catch (Exception ex) {
ex.printStackTrace();
return null;
} finally {
DBUtil.closeResultSet(rs);
DBUtil.closeStatement(cs);
pool.freeConnection(connection);
}
}
private void suivantButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_suivantButtonActionPerformed
pNumber++;
pageNumberLabel.setText(Integer.toString(pNumber));
GUI container = (GUI) SwingUtilities.getWindowAncestor(this); // on prend son grand pere
CallableStatement cs = null;
Connection conDB = container.getBeanbd().getConnexion();
ResultSet rs = null;
avisArea.setText("");
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getAvisFilm(?, ?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, filmID);
cs.setInt(3, pNumber);
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
while (rs.next()) {
avisArea.append("User : "******"\n");
avisArea.append("Avis : " + rs.getString(2) + "\n\n");
avisArea.append("---------------------------------\n\n");
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
} // GEN-LAST:event_suivantButtonActionPerformed
public static List<Usuario> buscarUsuarios() {
ConnectionPool pool = ConnectionPool.getInstance();
Connection connection = pool.getConnection();
CallableStatement cs = null;
ResultSet rs = null;
try {
List<Usuario> usuas = new ArrayList();
cs = connection.prepareCall("{ call cajeroReporte() }");
rs = cs.executeQuery();
while (rs.next()) {
Usuario usa =
new Usuario(
rs.getString("nombreUsuario"),
rs.getString("apellidoPaterno"),
rs.getInt("idUsuario"));
usuas.add(usa);
}
return usuas;
} catch (Exception ex) {
ex.printStackTrace();
return null;
} finally {
DBUtil.closeResultSet(rs);
DBUtil.closeStatement(cs);
pool.freeConnection(connection);
}
}
public static void reload() throws SQLException {
String query = "{call GetGift()}";
try (Connection conn = DBPoolConnection.getConnection();
CallableStatement cs = conn.prepareCall(query);
ResultSet rs = cs.executeQuery()) {
if (rs != null) {
while (rs.next()) {
int id = rs.getInt("GiftGameID");
String name = rs.getString("name");
String category = rs.getString("typeName");
String icon = rs.getString("icon");
String bigIcon = rs.getString("bigIcon");
long price = rs.getLong("price");
int giftTypeID = rs.getInt("giftTypeID");
String activeChat = rs.getString("activeChat");
String passiveChat = rs.getString("passiveChat");
GiftGameEntity ent =
new GiftGameEntity(
id, name, category, giftTypeID, icon, bigIcon, price, activeChat, passiveChat);
giftGames.put(ent.id, ent);
if (!giftType.containsKey(giftTypeID)) {
giftType.put(giftTypeID, category);
}
}
}
}
}
public static Couple<String, String> gift(
int giftGameID, long matchID, long uid, String uids, int number)
throws SQLException, SimpleException {
String query = "{call MakeGiftGame(?,?,?,?,?)}";
int res = 0;
try (Connection conn = DBPoolConnection.getConnection()) {
CallableStatement cs = conn.prepareCall(query);
cs.clearParameters();
cs.setLong(1, uid);
cs.setLong(2, matchID);
cs.setInt(3, number);
cs.setString(4, uids);
cs.setInt(5, giftGameID);
ResultSet rs = cs.executeQuery();
if (rs != null && rs.next()) {
res = rs.getInt("result");
}
}
if (res == 1) {
return giftGameChat(giftGameID);
} else {
throw new SimpleException("Không tặng được");
}
}
public ArrayList getVendorMenuDinner(String vendor) {
con = new DBConnection();
ArrayList list = new ArrayList();
try {
cstmt = con.connection.prepareCall("{call getVendorMenuDinner (?)}");
cstmt.setString(1, vendor);
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
Map objMap = new HashMap();
objMap.put("MenuID", rs.getInt("MenuID"));
objMap.put("UploadDateTime", rs.getDate("UploadDateTime"));
objMap.put("TiffinDescription", rs.getString("TiffinDescription"));
objMap.put("ItemID", rs.getInt("ItemID"));
objMap.put("ItemName", rs.getString("ItemName"));
objMap.put("TypeName", rs.getString("TypeName"));
objMap.put("Cost", rs.getInt("Cost"));
objMap.put("Quantity", rs.getInt("Quantity"));
list.add(objMap);
}
rs.close();
} catch (Exception ex) {
ex.getMessage();
} finally {
con.closeConnection();
}
return list;
}