public List <Ytbl_ProgCorteModels> SelectYtbl_ProgCorte() { conn = new Connection(); OleDbConnection objConn = conn.Conn(); string commText = "select * from YTBL_PROGCORTE order by id desc"; objConn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = objConn; cmd.CommandText = commText; cmd.CommandType = CommandType.Text; OleDbDataReader myReader = cmd.ExecuteReader(); int RecordCount = 0; List <Ytbl_ProgCorteModels> cortesProgramados = new List <Ytbl_ProgCorteModels>(); try { if (myReader.HasRows) { while (myReader.Read()) { Ytbl_ProgCorteModels ProgCorte = new Ytbl_ProgCorteModels(); RecordCount++; ProgCorte.Id = int.Parse(myReader.GetDecimal(0).ToString()); ProgCorte.Document_Name = myReader.GetString(1).ToString(); ProgCorte.Customer_Number_Upload = myReader.GetString(2).ToString(); ProgCorte.Nick_User = myReader.GetString(3).ToString(); ProgCorte.Date_Programed = DateTime.Parse(myReader.GetDateTime(4).ToString()); ProgCorte.Date_Upload = DateTime.Parse(myReader.GetDateTime(5).ToString()); ProgCorte.IsValid = myReader.GetString(6).ToString(); cortesProgramados.Add(ProgCorte); } } return(cortesProgramados); } catch (Exception ex) { myReader.Close(); objConn.Close(); Logs.WriteErrorLog("Error en la consulta de datos||" + ex.ToString()); return(cortesProgramados); } finally { myReader.Close(); objConn.Close(); } }
public bool UpdateYtbl_ProgCorte(Ytbl_ProgCorteModels model) { conn = new Connection(); OleDbConnection objConn = conn.Conn(); //----- try { conn = new Connection(); string commText = "YPKG_WEBCORTES.YPRD_UPDATEPROGCORTE"; objConn.Open(); OleDbCommand cmd = new OleDbCommand(commText, objConn); cmd.CommandType = CommandType.StoredProcedure; OleDbParameter IdProgCorte = new OleDbParameter("PN_IDPROGCORTE", OleDbType.BigInt); IdProgCorte.Direction = ParameterDirection.Input; IdProgCorte.Value = model.Id; cmd.Parameters.Add(IdProgCorte); OleDbParameter Cparty = new OleDbParameter("PV_ISVALID", OleDbType.VarChar); Cparty.Direction = ParameterDirection.Input; Cparty.Value = model.IsValid; cmd.Parameters.Add(Cparty); OleDbParameter Account = new OleDbParameter("PD_DATEPROGRAMED", OleDbType.Date); Account.Direction = ParameterDirection.Input; Account.Value = model.Date_Programed; cmd.Parameters.Add(Account); cmd.ExecuteNonQuery(); objConn.Close(); return(true); } catch (Exception ex) { Logs.WriteErrorLog("Error en insert: " + ex.ToString()); objConn.Close(); return(false); } finally { objConn.Close(); } }
public bool ExecuteSave(Ytbl_ProgCorteModels ListCorte) { Ytbl_DetalleProgCorteModels SaveDetalle = new Ytbl_DetalleProgCorteModels(); try { if (SaveYtbl_ProgCorte(ListCorte) == false) { return(false); } int idProgCorte = SelectMaxId(ListCorte.Document_Name); Parallel.For(0, DetalleCorte.Count, i => { Ytbl_DetalleProgCorteModels CorteDetalle = new Ytbl_DetalleProgCorteModels(); CorteDetalle.id_ProgCorte = idProgCorte; CorteDetalle.CpartyId = DetalleCorte[i].CpartyId; CorteDetalle.CpartyAccountId = DetalleCorte[i].CpartyAccountId; CorteDetalle.CitemId = DetalleCorte[i].CitemId; CorteDetalle.FormaPago = DetalleCorte[i].FormaPago; CorteDetalle.Ciudad = DetalleCorte[i].Ciudad; CorteDetalle.BancoId = DetalleCorte[i].BancoId; CorteDetalle.TipoNegocio = DetalleCorte[i].TipoNegocio; CorteDetalle.EmpresaFacturadora = DetalleCorte[i].EmpresaFacturadora; CorteDetalle.FieldV1 = DetalleCorte[i].FieldV1; CorteDetalle.FieldV2 = DetalleCorte[i].FieldV2; CorteDetalle.FieldN1 = DetalleCorte[i].FieldN1; CorteDetalle.FieldN2 = DetalleCorte[i].FieldN2; CorteDetalle.FieldD1 = DetalleCorte[i].FieldD1; CorteDetalle.Status = DetalleCorte[i].Status; SaveDetalle.SaveYtbl_DetalleProgCorte(CorteDetalle); }); /*foreach (var item in DetalleCorte) * { * Ytbl_DetalleProgCorteModels CorteDetalle = new Ytbl_DetalleProgCorteModels(); * * CorteDetalle.id_ProgCorte = idProgCorte; * CorteDetalle.CpartyId = item.CpartyId ; * CorteDetalle.CpartyAccountId = item.CpartyAccountId; * CorteDetalle.CitemId = item.CitemId; * CorteDetalle.FormaPago = item.FormaPago; * CorteDetalle.Ciudad = item.Ciudad; * CorteDetalle.BancoId = item.BancoId; * CorteDetalle.TipoNegocio = item.TipoNegocio; * CorteDetalle.EmpresaFacturadora = item.EmpresaFacturadora; * CorteDetalle.FieldV1 = item.FieldV1; * CorteDetalle.FieldV2 = item.FieldV2; * CorteDetalle.FieldN1 = item.FieldN1; * CorteDetalle.FieldN2 = item.FieldN2; * CorteDetalle.FieldD1 = item.FieldD1; * CorteDetalle.Status = item.Status; * * SaveDetalle.SaveYtbl_DetalleProgCorte(CorteDetalle); * * }*/ Ytbl_CorreoNotificacionesModels notificacion = new Ytbl_CorreoNotificacionesModels(); notificacion.SendMailNotification(idProgCorte); return(true); } catch (Exception ex) { Logs.WriteErrorLog("Error en ExecuteSave: " + ex.ToString()); return(false); } }
public bool SaveYtbl_ProgCorte(Ytbl_ProgCorteModels ProgCorte) { conn = new Connection(); OleDbConnection objConn = conn.Conn(); try { // Calling sp_processdata defined inside PKG PKG_MANAGER string commText = "YPKG_WEBCORTES.YPRD_INSERTPROGCORTE"; objConn.Open(); OleDbCommand cmd = new OleDbCommand(commText, objConn); cmd.CommandType = CommandType.StoredProcedure; OleDbParameter Document = new OleDbParameter("PN_DOCUMENT_NAME", OleDbType.VarChar); Document.Direction = ParameterDirection.Input; Document.Value = ProgCorte.Document_Name; cmd.Parameters.Add(Document); OleDbParameter Customers = new OleDbParameter("PN_CUSTOMES_NUMBER_UPLOAD", OleDbType.VarChar); Customers.Direction = ParameterDirection.Input; Customers.Value = ProgCorte.Customer_Number_Upload; cmd.Parameters.Add(Customers); OleDbParameter User = new OleDbParameter("PV_NICK_USER", OleDbType.VarChar); User.Direction = ParameterDirection.Input; User.Value = ProgCorte.Nick_User; cmd.Parameters.Add(User); OleDbParameter DateP = new OleDbParameter("PD_DATE_PROGRAMED", OleDbType.Date); DateP.Direction = ParameterDirection.Input; DateP.Value = ProgCorte.Date_Programed; cmd.Parameters.Add(DateP); OleDbParameter DateU = new OleDbParameter("PD_DATE_UPLOAD", OleDbType.Date); DateU.Direction = ParameterDirection.Input; DateU.Value = ProgCorte.Date_Upload; cmd.Parameters.Add(DateU); OleDbParameter IsValid = new OleDbParameter("PV_ISVALID", OleDbType.VarChar); IsValid.Direction = ParameterDirection.Input; IsValid.Value = ProgCorte.IsValid; cmd.Parameters.Add(IsValid); cmd.ExecuteNonQuery(); objConn.Close(); return(true); } catch (Exception ex) { Logs.WriteErrorLog("Error en insert: " + ex.ToString()); objConn.Close(); return(false); } finally { objConn.Close(); } }