private void tlbMenu_DeleteClick()
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!ValidarIngreso())
{
ProgramProductionBE objE_ProgramProduction = new ProgramProductionBE();
objE_ProgramProduction.IdProgramProduction = int.Parse(gvProgramProduction.GetFocusedRowCellValue("IdProgramProduction").ToString());
objE_ProgramProduction.Login = Parametros.strUsuarioLogin;
objE_ProgramProduction.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_ProgramProduction.IdCompany = Parametros.intEmpresaId;
ProgramProductionBL objBL_ProgramProduction = new ProgramProductionBL();
objBL_ProgramProduction.Elimina(objE_ProgramProduction);
XtraMessageBox.Show("The record was successfully deleted.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Cargar();
}
}
Cursor = Cursors.Default;
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Elimina(ProgramProductionBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ProgramProductionDL ProgramProduction = new ProgramProductionDL();
ProgramProductionDetailDL ProgramProductionDetail = new ProgramProductionDetailDL();
//Client SENSOR
List <ProgramProductionDetailBE> lstProgramProductionDetail = null;
lstProgramProductionDetail = new ProgramProductionDetailDL().ListaTodosActivo(pItem.IdProgramProduction);
foreach (var item in lstProgramProductionDetail)
{
ProgramProductionDetail.Elimina(item);
}
ProgramProduction.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(ProgramProductionBE pItem, List <ProgramProductionDetailBE> pListaProgramProductionDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ProgramProductionDL ProgramProduction = new ProgramProductionDL();
ProgramProductionDetailDL ProgramProductionDetail = new ProgramProductionDetailDL();
foreach (var item in pListaProgramProductionDetail)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdProgramProduction = pItem.IdProgramProduction;
ProgramProductionDetail.Inserta(item);
}
else
{
ProgramProductionDetail.Actualiza(item);
}
}
ProgramProduction.Actualiza(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public Int32 Inserta(ProgramProductionBE pItem, List <ProgramProductionDetailBE> pListaProgramProductionDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ProgramProductionDL ProgramProduction = new ProgramProductionDL();
ProgramProductionDetailDL ProgramProductionDetail = new ProgramProductionDetailDL();
int IdProgramProduction = 0;
IdProgramProduction = ProgramProduction.Inserta(pItem);
foreach (var item in pListaProgramProductionDetail)
{
item.IdProgramProduction = IdProgramProduction;
ProgramProductionDetail.Inserta(item);
}
ts.Complete();
return(IdProgramProduction);
}
}
catch (Exception ex)
{ throw ex; }
}
public ProgramProductionBE Selecciona(int IdProgramProduction)
{
try
{
ProgramProductionDL ProgramProduction = new ProgramProductionDL();
ProgramProductionBE objEmp = ProgramProduction.Selecciona(IdProgramProduction);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
private void nuevoCopyToolStripMenuItem_Click(object sender, EventArgs e)
{
if (gvProgramProduction.RowCount > 0)
{
ProgramProductionBE objProgramProduction = new ProgramProductionBE();
objProgramProduction.IdProgramProduction = int.Parse(gvProgramProduction.GetFocusedRowCellValue("IdProgramProduction").ToString());
frmRegProductionProgramEdit objManProgramProductionEdit = new frmRegProductionProgramEdit();
objManProgramProductionEdit.pOperacion = frmRegProductionProgramEdit.Operacion.Nuevo;
objManProgramProductionEdit.lstProgramProduction = mLista;
objManProgramProductionEdit.bCopy = true;
objManProgramProductionEdit.IdProgramProduction = objProgramProduction.IdProgramProduction;
objManProgramProductionEdit.StartPosition = FormStartPosition.CenterParent;
objManProgramProductionEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public void InicializarModificar()
{
if (gvProgramProduction.RowCount > 0)
{
ProgramProductionBE objProgramProduction = new ProgramProductionBE();
objProgramProduction.IdProgramProduction = int.Parse(gvProgramProduction.GetFocusedRowCellValue("IdProgramProduction").ToString());
frmRegProductionProgramEdit objManProgramProductionEdit = new frmRegProductionProgramEdit();
objManProgramProductionEdit.pOperacion = frmRegProductionProgramEdit.Operacion.Modificar;
objManProgramProductionEdit.bCopy = false;
objManProgramProductionEdit.IdProgramProduction = objProgramProduction.IdProgramProduction;
objManProgramProductionEdit.IdClient = Convert.ToInt32(cboClient.EditValue);
objManProgramProductionEdit.IdDivision = Convert.ToInt32(cboDivision.EditValue);
objManProgramProductionEdit.StartPosition = FormStartPosition.CenterParent;
objManProgramProductionEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
private void frmRegProductionProgramEdit_Load(object sender, EventArgs e)
{
if (IdClient != 7) //VINCE
{
gvProgramProductionDetail.Columns["Dyelot"].Visible = false;
}
BSUtils.LoaderLook(cboClient, new LoginClientDepartmentBL().ListaClient(Parametros.intUsuarioId), "NameClient", "IdClient", true);
cboClient.EditValue = IdClient;
BSUtils.LoaderLook(cboVendor, new VendorBL().ListaTodosActivo(Parametros.intEmpresaId), "NameVendor", "IdVendor", true);
BSUtils.LoaderLook(cboDestination, new DestinationBL().ListaTodosActivo(Parametros.intEmpresaId), "NameDestination", "IdDestination", true);
cboDestination.EditValue = 1;
BSUtils.LoaderLook(cboSeason, new SeasonBL().ListaTodosActivo(Parametros.intEmpresaId), "NameSeason", "IdSeason", true);
BSUtils.LoaderLook(cboTypeProduct, new TypeProductBL().ListaTodosActivo(Parametros.intEmpresaId), "NameTypeProduct", "IdTypeProduct", true);
BSUtils.LoaderLook(cboShipMode, new ShipModeBL().ListaTodosActivo(Parametros.intEmpresaId), "NameShipMode", "IdShipMode", true);
deXfDate.Properties.Mask.Culture = new System.Globalization.CultureInfo("en-US");
deXfDate.Properties.Mask.EditMask = "MM/dd/yyyy";
deXfDate.Properties.Mask.UseMaskAsDisplayFormat = true;
deXfDate.Properties.CharacterCasing = CharacterCasing.Upper;
deIndcDate.Properties.Mask.Culture = new System.Globalization.CultureInfo("en-US");
deIndcDate.Properties.Mask.EditMask = "MM/dd/yyyy";
deIndcDate.Properties.Mask.UseMaskAsDisplayFormat = true;
deIndcDate.Properties.CharacterCasing = CharacterCasing.Upper;
deXfDate.DateTime = DateTime.Now;
deIndcDate.DateTime = DateTime.Now;
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Production Program - New";
if (bCopy)
{
ProgramProductionBE objE_ProgramProduction = null;
objE_ProgramProduction = new ProgramProductionBL().Selecciona(IdProgramProduction);
if (objE_ProgramProduction != null)
{
cboClient.EditValue = objE_ProgramProduction.IdClient;
cboDivision.EditValue = objE_ProgramProduction.IdClientDepartment;
cboVendor.EditValue = objE_ProgramProduction.IdVendor;
cboDestination.EditValue = objE_ProgramProduction.IdDestination;
cboSeason.EditValue = objE_ProgramProduction.IdSeason;
IdStyle = objE_ProgramProduction.IdStyle;
cboTypeProduct.EditValue = objE_ProgramProduction.IdTypeProduct;
txtNumberPO.Text = objE_ProgramProduction.NumberPO;
txtNumberCommiment.Text = objE_ProgramProduction.NumberCommiment;
deXfDate.EditValue = objE_ProgramProduction.XfDate;
deIndcDate.EditValue = objE_ProgramProduction.IndcDate;
cboShipMode.EditValue = objE_ProgramProduction.IdShipMode;
txtLabel.Text = objE_ProgramProduction.Label;
txtAddionational.Text = objE_ProgramProduction.Addionational;
}
}
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Production Program - Update";
ProgramProductionBE objE_ProgramProduction = null;
objE_ProgramProduction = new ProgramProductionBL().Selecciona(IdProgramProduction);
if (objE_ProgramProduction != null)
{
IdProgramProduction = objE_ProgramProduction.IdProgramProduction;
txtNumero.Text = objE_ProgramProduction.NumberPP;
cboClient.EditValue = objE_ProgramProduction.IdClient;
cboDivision.EditValue = objE_ProgramProduction.IdClientDepartment;
cboVendor.EditValue = objE_ProgramProduction.IdVendor;
cboDestination.EditValue = objE_ProgramProduction.IdDestination;
cboSeason.EditValue = objE_ProgramProduction.IdSeason;
IdStyle = objE_ProgramProduction.IdStyle;
cboTypeProduct.EditValue = objE_ProgramProduction.IdTypeProduct;
txtNumberPO.Text = objE_ProgramProduction.NumberPO;
txtNumberCommiment.Text = objE_ProgramProduction.NumberCommiment;
deXfDate.EditValue = objE_ProgramProduction.XfDate;
deIndcDate.EditValue = objE_ProgramProduction.IndcDate;
cboShipMode.EditValue = objE_ProgramProduction.IdShipMode;
txtLabel.Text = objE_ProgramProduction.Label;
txtAddionational.Text = objE_ProgramProduction.Addionational;
}
}
CargaProgramProductionDetail();
if (mListaProgramProductionDetailOrigen.Count == 0)
{
this.nuevoProgramProductionDetailToolStripMenuItem_Click(sender, e);
}
}
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);
}
}
