private void eliminarProgramProductionDetailToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int IdProgramProductionDetail = 0;
if (gvProgramProductionDetail.GetFocusedRowCellValue("IdProgramProductionDetail") != null)
{
IdProgramProductionDetail = int.Parse(gvProgramProductionDetail.GetFocusedRowCellValue("IdProgramProductionDetail").ToString());
}
ProgramProductionDetailBE objBE_ProgramProductionDetail = new ProgramProductionDetailBE();
objBE_ProgramProductionDetail.IdProgramProductionDetail = IdProgramProductionDetail;
objBE_ProgramProductionDetail.IdCompany = Parametros.intEmpresaId;
objBE_ProgramProductionDetail.Login = Parametros.strUsuarioLogin;
objBE_ProgramProductionDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
ProgramProductionDetailBL objBL_ProgramProductionDetail = new ProgramProductionDetailBL();
objBL_ProgramProductionDetail.Elimina(objBE_ProgramProductionDetail);
gvProgramProductionDetail.DeleteRow(gvProgramProductionDetail.FocusedRowHandle);
gvProgramProductionDetail.RefreshData();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <ProgramProductionDetailBE> ListaNumberPO(int IdClient, string NumberPO)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDetail_ListaNumberPO");
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient);
db.AddInParameter(dbCommand, "pNumberPO", DbType.String, NumberPO);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ProgramProductionDetailBE> ProgramProductionDetaillist = new List <ProgramProductionDetailBE>();
ProgramProductionDetailBE ProgramProductionDetail;
while (reader.Read())
{
ProgramProductionDetail = new ProgramProductionDetailBE();
ProgramProductionDetail.IdProgramProductionDetail = Int32.Parse(reader["IdProgramProductionDetail"].ToString());
ProgramProductionDetail.NumberPO = reader["NumberPO"].ToString();
ProgramProductionDetail.NumeroOI = reader["NumeroOI"].ToString();
ProgramProductionDetail.NameStyle = reader["NameStyle"].ToString();
ProgramProductionDetail.Description = reader["Description"].ToString();
ProgramProductionDetail.Dyelot = reader["Dyelot"].ToString();
ProgramProductionDetail.Item = reader["Item"].ToString();
ProgramProductionDetail.Detail = reader["Detail"].ToString();
ProgramProductionDetail.Units = Decimal.Parse(reader["Units"].ToString());
ProgramProductionDetail.Fob = Decimal.Parse(reader["Fob"].ToString());
ProgramProductionDetaillist.Add(ProgramProductionDetail);
}
reader.Close();
reader.Dispose();
return(ProgramProductionDetaillist);
}
public ProgramProductionDetailBE Selecciona(int IdProgramProductionDetail)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDetail_Selecciona");
db.AddInParameter(dbCommand, "pidProgramProductionDetail", DbType.Int32, IdProgramProductionDetail);
IDataReader reader = db.ExecuteReader(dbCommand);
ProgramProductionDetailBE ProgramProductionDetail = null;
while (reader.Read())
{
ProgramProductionDetail = new ProgramProductionDetailBE();
ProgramProductionDetail.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ProgramProductionDetail.IdProgramProduction = Int32.Parse(reader["IdProgramProduction"].ToString());
ProgramProductionDetail.IdProgramProductionDetail = Int32.Parse(reader["idProgramProductionDetail"].ToString());
ProgramProductionDetail.IdStyle = Int32.Parse(reader["IdStyle"].ToString());
ProgramProductionDetail.NameStyle = reader["NameStyle"].ToString();
ProgramProductionDetail.Description = reader["Description"].ToString();
ProgramProductionDetail.Dyelot = reader["Dyelot"].ToString();
ProgramProductionDetail.Item = reader["Item"].ToString();
ProgramProductionDetail.Detail = reader["Detail"].ToString();
ProgramProductionDetail.Units = Decimal.Parse(reader["Units"].ToString());
ProgramProductionDetail.Fob = Decimal.Parse(reader["Fob"].ToString());
ProgramProductionDetail.Total = Decimal.Parse(reader["Total"].ToString());
ProgramProductionDetail.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(ProgramProductionDetail);
}
public List <ProgramProductionDetailBE> ListaTodosActivo(int IdProgramProduction)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDetail_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdProgramProduction", DbType.Int32, IdProgramProduction);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ProgramProductionDetailBE> ProgramProductionDetaillist = new List <ProgramProductionDetailBE>();
ProgramProductionDetailBE ProgramProductionDetail;
while (reader.Read())
{
ProgramProductionDetail = new ProgramProductionDetailBE();
ProgramProductionDetail.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ProgramProductionDetail.IdProgramProduction = Int32.Parse(reader["IdProgramProduction"].ToString());
ProgramProductionDetail.IdProgramProductionDetail = Int32.Parse(reader["idProgramProductionDetail"].ToString());
ProgramProductionDetail.IdStyle = Int32.Parse(reader["IdStyle"].ToString());
ProgramProductionDetail.NameStyle = reader["NameStyle"].ToString();
ProgramProductionDetail.Description = reader["Description"].ToString();
ProgramProductionDetail.Dyelot = reader["Dyelot"].ToString();
ProgramProductionDetail.Item = reader["Item"].ToString();
ProgramProductionDetail.Detail = reader["Detail"].ToString();
ProgramProductionDetail.Units = Decimal.Parse(reader["Units"].ToString());
ProgramProductionDetail.Fob = Decimal.Parse(reader["Fob"].ToString());
ProgramProductionDetail.Total = Decimal.Parse(reader["Total"].ToString());
ProgramProductionDetail.FlagState = Boolean.Parse(reader["FlagState"].ToString());
ProgramProductionDetail.TipoOper = 4; //CONSULTAR
ProgramProductionDetaillist.Add(ProgramProductionDetail);
}
reader.Close();
reader.Dispose();
return(ProgramProductionDetaillist);
}
public void Elimina(ProgramProductionDetailBE pItem)
{
try
{
ProgramProductionDetailDL ProgramProductionDetail = new ProgramProductionDetailDL();
ProgramProductionDetail.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public ProgramProductionDetailBE Selecciona(int IdProgramProductionDetail)
{
try
{
ProgramProductionDetailDL ProgramProductionDetail = new ProgramProductionDetailDL();
ProgramProductionDetailBE objEmp = ProgramProductionDetail.Selecciona(IdProgramProductionDetail);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(ProgramProductionDetailBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDetail_Elimina");
db.AddInParameter(dbCommand, "pIdProgramProductionDetail", DbType.Int32, pItem.IdProgramProductionDetail);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
}
public void Actualiza(ProgramProductionDetailBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDetail_Actualiza");
db.AddInParameter(dbCommand, "pIdProgramProductionDetail", DbType.Int32, pItem.IdProgramProductionDetail);
db.AddInParameter(dbCommand, "pIdProgramProduction", DbType.Int32, pItem.IdProgramProduction);
db.AddInParameter(dbCommand, "pIdStyle", DbType.Int32, pItem.IdStyle);
db.AddInParameter(dbCommand, "pDyelot", DbType.String, pItem.Dyelot);
db.AddInParameter(dbCommand, "pItem", DbType.String, pItem.Item);
db.AddInParameter(dbCommand, "pDetail", DbType.String, pItem.Detail);
db.AddInParameter(dbCommand, "pUnits", DbType.Decimal, pItem.Units);
db.AddInParameter(dbCommand, "pFob", DbType.Decimal, pItem.Fob);
db.AddInParameter(dbCommand, "pTotal", DbType.Decimal, pItem.Total);
db.AddInParameter(dbCommand, "pFlagState", DbType.Boolean, pItem.FlagState);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.ExecuteNonQuery(dbCommand);
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
ProgramProductionBL objBL_ProgramProduction = new ProgramProductionBL();
ProgramProductionBE objProgramProduction = new ProgramProductionBE();
objProgramProduction.NumberPP = txtNumero.Text;
objProgramProduction.IdClient = Convert.ToInt32(cboClient.EditValue);
objProgramProduction.IdClientDepartment = Convert.ToInt32(cboDivision.EditValue);
objProgramProduction.IdVendor = Convert.ToInt32(cboVendor.EditValue);
objProgramProduction.IdDestination = Convert.ToInt32(cboDestination.EditValue);
objProgramProduction.IdSeason = Convert.ToInt32(cboSeason.EditValue);
objProgramProduction.IdStyle = IdStyle;
objProgramProduction.IdTypeProduct = Convert.ToInt32(cboTypeProduct.EditValue);
objProgramProduction.NumberPO = txtNumberPO.Text;
objProgramProduction.NumberCommiment = txtNumberCommiment.Text;
objProgramProduction.XfDate = Convert.ToDateTime(deXfDate.DateTime.ToShortDateString());
objProgramProduction.IndcDate = Convert.ToDateTime(deIndcDate.DateTime.ToShortDateString());
objProgramProduction.IdShipMode = Convert.ToInt32(cboShipMode.EditValue);
objProgramProduction.Label = txtLabel.Text;
objProgramProduction.Addionational = txtAddionational.Text;
objProgramProduction.FlagState = true;
objProgramProduction.Login = Parametros.strUsuarioLogin;
objProgramProduction.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objProgramProduction.IdCompany = Parametros.intEmpresaId;
//DETAIL
List <ProgramProductionDetailBE> lstProgramProductionDetail = new List <ProgramProductionDetailBE>();
foreach (var item in mListaProgramProductionDetailOrigen)
{
ProgramProductionDetailBE objE_ProgramProductionDetail = new ProgramProductionDetailBE();
objE_ProgramProductionDetail.IdCompany = Parametros.intEmpresaId;
objE_ProgramProductionDetail.IdProgramProduction = IdProgramProduction;
objE_ProgramProductionDetail.IdProgramProductionDetail = item.IdProgramProductionDetail;
objE_ProgramProductionDetail.IdStyle = item.IdStyle;
objE_ProgramProductionDetail.Dyelot = item.Dyelot;
objE_ProgramProductionDetail.Item = item.Item;
objE_ProgramProductionDetail.Detail = item.Detail;
objE_ProgramProductionDetail.Units = item.Units;
objE_ProgramProductionDetail.Fob = item.Fob;
objE_ProgramProductionDetail.Total = item.Total;
objE_ProgramProductionDetail.FlagState = true;
objE_ProgramProductionDetail.Login = Parametros.strUsuarioLogin;
objE_ProgramProductionDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_ProgramProductionDetail.TipoOper = item.TipoOper;
lstProgramProductionDetail.Add(objE_ProgramProductionDetail);
}
if (pOperacion == Operacion.Nuevo)
{
var Buscar = lstProgramProduction.Where(oB => oB.NumberPO.ToUpper() == txtNumberPO.Text.ToUpper() && oB.IdVendor == Convert.ToInt32(cboVendor.EditValue) && oB.IdClientDepartment == Convert.ToInt32(cboDivision.EditValue)).ToList();
if (Buscar.Count > 0)
{
if (XtraMessageBox.Show("the Number #PO already exists.\n The record can be duplicated, do you want to continue?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
objProgramProduction.IdProgramProduction = 0;
int intNumero = 0;
string strNumero = "";
intNumero = objBL_ProgramProduction.Inserta(objProgramProduction, lstProgramProductionDetail);
strNumero = FuncionBase.AgregarCaracter(intNumero.ToString(), "0", 10);
txtNumero.Text = strNumero;
//ActualizaNumero
ProgramProductionBL objBProgramProduction = new ProgramProductionBL();
objBProgramProduction.ActualizaNumero(intNumero, txtNumero.Text);
Application.DoEvents();
}
}
else
{
objProgramProduction.IdProgramProduction = 0;
int intNumero = 0;
string strNumero = "";
intNumero = objBL_ProgramProduction.Inserta(objProgramProduction, lstProgramProductionDetail);
strNumero = FuncionBase.AgregarCaracter(intNumero.ToString(), "0", 10);
txtNumero.Text = strNumero;
//ActualizaNumero
ProgramProductionBL objBProgramProduction = new ProgramProductionBL();
objBProgramProduction.ActualizaNumero(intNumero, txtNumero.Text);
Application.DoEvents();
}
}
else
{
objProgramProduction.IdProgramProduction = IdProgramProduction;
objBL_ProgramProduction.Actualiza(objProgramProduction, lstProgramProductionDetail);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
