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();
}
}
