private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
InspectionCertificateBL objBL_InspectionCertificate = new InspectionCertificateBL();
List <InspectionCertificateBE> lstInspectionCertificate = new List <InspectionCertificateBE>();
int[] rows = gvInspectionCertificate.GetSelectedRows();
for (int i = 0; i < rows.Length; i++)
{
InspectionCertificateBE objE_InspectionCertificate = new InspectionCertificateBE();
objE_InspectionCertificate.IdInspectionCertificate = int.Parse(gvInspectionCertificate.GetRowCellValue(rows[i], gvInspectionCertificate.Columns.ColumnByFieldName("IdInspectionCertificate")).ToString());
objE_InspectionCertificate.IdStatus = Parametros.intICFinished;
lstInspectionCertificate.Add(objE_InspectionCertificate);
}
objBL_InspectionCertificate.ActualizaSituacionMasivo(lstInspectionCertificate);
XtraMessageBox.Show("The certificates finished correctly.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Actualiza(InspectionCertificateBE pItem, List <InspectionCertificateDetailBE> pListaInspectionCertificateDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
InspectionCertificateDetailDL InspectionCertificateDetail = new InspectionCertificateDetailDL();
foreach (var item in pListaInspectionCertificateDetail)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdInspectionCertificate = pItem.IdInspectionCertificate;
InspectionCertificateDetail.Inserta(item);
}
else
{
InspectionCertificateDetail.Actualiza(item);
}
}
InspectionCertificate.Actualiza(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(InspectionCertificateBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
InspectionCertificateDetailDL InspectionCertificateDetail = new InspectionCertificateDetailDL();
//INSPECTION CERTIFICATE DETAIL
List <InspectionCertificateDetailBE> lstInspectionCertificateDetail = null;
lstInspectionCertificateDetail = new InspectionCertificateDetailDL().ListaTodosActivo(pItem.IdInspectionCertificate);
foreach (var item in lstInspectionCertificateDetail)
{
InspectionCertificateDetail.Elimina(item);
}
InspectionCertificate.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public List <InspectionCertificateBE> ListaInvoiceDetail(int IdCompany, string NumberCertificate)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InspectionCertificate_ListaInvoiceDetail");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
db.AddInParameter(dbCommand, "pNumberCertificate", DbType.String, NumberCertificate);
IDataReader reader = db.ExecuteReader(dbCommand);
List <InspectionCertificateBE> InspectionCertificatelist = new List <InspectionCertificateBE>();
InspectionCertificateBE InspectionCertificate;
while (reader.Read())
{
InspectionCertificate = new InspectionCertificateBE();
InspectionCertificate.IdInspectionCertificate = Int32.Parse(reader["IdInspectionCertificate"].ToString());
InspectionCertificate.NumberCertificate = reader["NumberCertificate"].ToString();
InspectionCertificate.IssueDate = DateTime.Parse(reader["IssueDate"].ToString());
InspectionCertificate.NameVendor = reader["NameVendor"].ToString();
InspectionCertificate.NumberInvoice = reader["NumberInvoice"].ToString();
InspectionCertificate.IssueDateInvoice = DateTime.Parse(reader["IssueDateInvoice"].ToString());
InspectionCertificate.NameDivision = reader["NameDivision"].ToString();
InspectionCertificate.AmountCertificate = Decimal.Parse(reader["AmountCertificate"].ToString());
InspectionCertificate.Comision = Decimal.Parse(reader["Comision"].ToString());
InspectionCertificate.Pieces = Decimal.Parse(reader["Pieces"].ToString());
InspectionCertificatelist.Add(InspectionCertificate);
}
reader.Close();
reader.Dispose();
return(InspectionCertificatelist);
}
public Int32 Inserta(InspectionCertificateBE pItem, List <InspectionCertificateDetailBE> pListaInspectionCertificateDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
InspectionCertificateDetailDL InspectionCertificateDetail = new InspectionCertificateDetailDL();
int IdInspectionCertificate = 0;
IdInspectionCertificate = InspectionCertificate.Inserta(pItem);
foreach (var item in pListaInspectionCertificateDetail)
{
item.IdInspectionCertificate = IdInspectionCertificate;
InspectionCertificateDetail.Inserta(item);
}
ts.Complete();
return(IdInspectionCertificate);
}
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(InspectionCertificateBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InspectionCertificate_Actualiza");
db.AddInParameter(dbCommand, "pIdInspectionCertificate", DbType.Int32, pItem.IdInspectionCertificate);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pNumberCertificate", DbType.String, pItem.NumberCertificate);
db.AddInParameter(dbCommand, "pNumberPO", DbType.String, pItem.NumberPO);
db.AddInParameter(dbCommand, "pNumberOI", DbType.String, pItem.NumberOI);
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient);
db.AddInParameter(dbCommand, "pIdClientDepartment", DbType.Int32, pItem.IdClientDepartment);
db.AddInParameter(dbCommand, "pIdClientBrand", DbType.Int32, pItem.IdClientBrand);
db.AddInParameter(dbCommand, "pIdVendor", DbType.Int32, pItem.IdVendor);
db.AddInParameter(dbCommand, "pPaymentTerm", DbType.String, pItem.PaymentTerm);
db.AddInParameter(dbCommand, "pCartons", DbType.Int32, pItem.Cartons);
db.AddInParameter(dbCommand, "pIssueDate", DbType.DateTime, pItem.IssueDate);
db.AddInParameter(dbCommand, "pIdRepresentative", DbType.Int32, pItem.IdRepresentative);
db.AddInParameter(dbCommand, "pDescriptionStyle", DbType.String, pItem.DescriptionStyle);
db.AddInParameter(dbCommand, "pNumberInvoice", DbType.String, pItem.NumberInvoice);
db.AddInParameter(dbCommand, "pIssueDateInvoice", DbType.DateTime, pItem.IssueDateInvoice);
db.AddInParameter(dbCommand, "pIdCurrency", DbType.Int32, pItem.IdCurrency);
db.AddInParameter(dbCommand, "pAmount", DbType.Decimal, pItem.Amount);
db.AddInParameter(dbCommand, "pEtdDate", DbType.DateTime, pItem.EtdDate);
db.AddInParameter(dbCommand, "pIdTypeShipping", DbType.Int32, pItem.IdTypeShipping);
db.AddInParameter(dbCommand, "pBoardingWay", DbType.String, pItem.BoardingWay);
db.AddInParameter(dbCommand, "pIdStatus", DbType.Int32, pItem.IdStatus);
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.ExecuteNonQuery(dbCommand);
}
public List <InspectionCertificateBE> ListaVendorStatus(int IdCompany, int IdVendor, int IdStatus, int NumberIni, int NumberFin)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InspectionCertificate_ListaVendorStatus");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
db.AddInParameter(dbCommand, "pIdVendor", DbType.Int32, IdVendor);
db.AddInParameter(dbCommand, "pIdStatus", DbType.Int32, IdStatus);
db.AddInParameter(dbCommand, "pNumberIni", DbType.Int32, NumberIni);
db.AddInParameter(dbCommand, "pNumberFin", DbType.Int32, NumberFin);
IDataReader reader = db.ExecuteReader(dbCommand);
List <InspectionCertificateBE> InspectionCertificatelist = new List <InspectionCertificateBE>();
InspectionCertificateBE InspectionCertificate;
while (reader.Read())
{
InspectionCertificate = new InspectionCertificateBE();
InspectionCertificate.IdInspectionCertificate = Int32.Parse(reader["IdInspectionCertificate"].ToString());
InspectionCertificate.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
InspectionCertificate.NameCompany = reader["NameCompany"].ToString();
InspectionCertificate.NumberCertificate = reader["NumberCertificate"].ToString();
InspectionCertificate.NumberPO = reader["NumberPO"].ToString();
InspectionCertificate.NumberOI = reader["NumberOI"].ToString();
InspectionCertificate.IdClient = Int32.Parse(reader["IdClient"].ToString());
InspectionCertificate.NameClient = reader["NameClient"].ToString();
InspectionCertificate.IdClientDepartment = Int32.Parse(reader["IdClientDepartment"].ToString());
InspectionCertificate.NameDivision = reader["NameDivision"].ToString();
InspectionCertificate.IdClientBrand = Int32.Parse(reader["IdClientBrand"].ToString());
InspectionCertificate.BrandCertificate = reader["BrandCertificate"].ToString();
InspectionCertificate.IdVendor = Int32.Parse(reader["IdVendor"].ToString());
InspectionCertificate.NameVendor = reader["NameVendor"].ToString();
InspectionCertificate.PaymentTerm = reader["PaymentTerm"].ToString();
InspectionCertificate.Cartons = Int32.Parse(reader["Cartons"].ToString());
InspectionCertificate.IssueDate = DateTime.Parse(reader["IssueDate"].ToString());
InspectionCertificate.IdRepresentative = Int32.Parse(reader["IdRepresentative"].ToString());
InspectionCertificate.NameRepresentative = reader["NameRepresentative"].ToString();
InspectionCertificate.DescriptionStyle = reader["DescriptionStyle"].ToString();
InspectionCertificate.NumberInvoice = reader["NumberInvoice"].ToString();
InspectionCertificate.IssueDateInvoice = DateTime.Parse(reader["IssueDateInvoice"].ToString());
InspectionCertificate.IdCurrency = Int32.Parse(reader["IdCurrency"].ToString());
InspectionCertificate.NameCurrency = reader["NameCurrency"].ToString();
InspectionCertificate.Amount = Decimal.Parse(reader["Amount"].ToString());
InspectionCertificate.EtdDate = DateTime.Parse(reader["EtdDate"].ToString());
InspectionCertificate.IdTypeShipping = Int32.Parse(reader["IdTypeShipping"].ToString());
InspectionCertificate.NameTypeShipping = reader["NameTypeShipping"].ToString();
InspectionCertificate.BoardingWay = reader["BoardingWay"].ToString();
InspectionCertificate.IdStatus = Int32.Parse(reader["IdStatus"].ToString());
InspectionCertificate.NameStatus = reader["NameStatus"].ToString();
InspectionCertificate.FlagState = Boolean.Parse(reader["FlagState"].ToString());
InspectionCertificatelist.Add(InspectionCertificate);
}
reader.Close();
reader.Dispose();
return(InspectionCertificatelist);
}
public InspectionCertificateBE SeleccionaNumberInvoice(string NumberInvoice)
{
try
{
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
InspectionCertificateBE objEmp = InspectionCertificate.SeleccionaNumberInvoice(NumberInvoice);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public InspectionCertificateBE Selecciona(int IdInspectionCertificate)
{
try
{
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
InspectionCertificateBE objEmp = InspectionCertificate.Selecciona(IdInspectionCertificate);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(InspectionCertificateBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InspectionCertificate_Elimina");
db.AddInParameter(dbCommand, "pIdInspectionCertificate", DbType.Int32, pItem.IdInspectionCertificate);
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 InicializarModificar()
{
if (gvInspectionCertificate.RowCount > 0)
{
InspectionCertificateBE objInspectionCertificate = new InspectionCertificateBE();
objInspectionCertificate.IdInspectionCertificate = int.Parse(gvInspectionCertificate.GetFocusedRowCellValue("IdInspectionCertificate").ToString());
frmRegInspectionCertificateEdit objManInspectionCertificateEdit = new frmRegInspectionCertificateEdit();
objManInspectionCertificateEdit.pOperacion = frmRegInspectionCertificateEdit.Operacion.Modificar;
objManInspectionCertificateEdit.IdInspectionCertificate = objInspectionCertificate.IdInspectionCertificate;
objManInspectionCertificateEdit.StartPosition = FormStartPosition.CenterParent;
objManInspectionCertificateEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
private bool ValidarIngreso()
{
bool flag = false;
string strMensaje = "Could not register:\n";
if (txtNumberCertificate.Text == "")
{
strMensaje = strMensaje + "- You must enter the Number Certificate.\n";
flag = true;
}
if (txtNumberInvoice.Text == "")
{
strMensaje = strMensaje + "- You must enter the Number Invoice.\n";
flag = true;
}
if (mListaInspectionCertificateDetailOrigen.Count == 0)
{
strMensaje = strMensaje + "- You must enter list terms.\n";
flag = true;
}
InspectionCertificateBE objE_InspectionCertificate = null;
objE_InspectionCertificate = new InspectionCertificateBL().SeleccionaNumberInvoice(txtNumberInvoice.Text.Trim());
if (objE_InspectionCertificate != null && pOperacion == Operacion.Nuevo)
{
strMensaje = strMensaje + "The Number Invoice already exists\n Please Verify.";
flag = true;
}
if (flag)
{
XtraMessageBox.Show(strMensaje, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Cursor = Cursors.Default;
}
return(flag);
}
private void frmRegInspectionCertificateEdit_Load(object sender, EventArgs e)
{
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(cboRepresentative, new EmployeeBL().ListaCombo(Parametros.intEmpresaId), "FullName", "IdEmployee", true);
BSUtils.LoaderLook(cboCurrency, new CurrencyBL().ListaCombo(Parametros.intEmpresaId), "NameCurrency", "IdCurrency", true);
BSUtils.LoaderLook(cboTypeShipping, new ElementTabletBL().ListaTodosActivo(Parametros.intEmpresaId, Parametros.intTblTypeShipping), "NameElementTablet", "IdElementTablet", true);
deIssueDate.Properties.Mask.Culture = new System.Globalization.CultureInfo("en-US");
deIssueDate.Properties.Mask.EditMask = "MM/dd/yyyy";
deIssueDate.Properties.Mask.UseMaskAsDisplayFormat = true;
deIssueDate.Properties.CharacterCasing = CharacterCasing.Upper;
deIssueDateInvoice.Properties.Mask.Culture = new System.Globalization.CultureInfo("en-US");
deIssueDateInvoice.Properties.Mask.EditMask = "MM/dd/yyyy";
deIssueDateInvoice.Properties.Mask.UseMaskAsDisplayFormat = true;
deIssueDateInvoice.Properties.CharacterCasing = CharacterCasing.Upper;
deEtdDate.Properties.Mask.Culture = new System.Globalization.CultureInfo("en-US");
deEtdDate.Properties.Mask.EditMask = "MM/dd/yyyy";
deEtdDate.Properties.Mask.UseMaskAsDisplayFormat = true;
deEtdDate.Properties.CharacterCasing = CharacterCasing.Upper;
deIssueDate.DateTime = DateTime.Now;
deIssueDateInvoice.DateTime = DateTime.Now;
deEtdDate.DateTime = DateTime.Now;
LlenarPaymentTerm();
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Inspection Certificate - New";
intIdStatus = Parametros.intICActive;
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Inspection Certificate - Update";
InspectionCertificateBE objE_InspectionCertificate = null;
objE_InspectionCertificate = new InspectionCertificateBL().Selecciona(IdInspectionCertificate);
if (objE_InspectionCertificate != null)
{
IdInspectionCertificate = objE_InspectionCertificate.IdInspectionCertificate;
txtNumberCertificate.Text = objE_InspectionCertificate.NumberCertificate;
cboClient.EditValue = objE_InspectionCertificate.IdClient;
cboDivision.EditValue = objE_InspectionCertificate.IdClientDepartment;
cboClientBrand.EditValue = objE_InspectionCertificate.IdClientBrand;
cboVendor.EditValue = objE_InspectionCertificate.IdVendor;
cboPaymentTerm.Text = objE_InspectionCertificate.PaymentTerm;
txtCartons.EditValue = objE_InspectionCertificate.Cartons;
deIssueDate.DateTime = objE_InspectionCertificate.IssueDate;
cboRepresentative.EditValue = objE_InspectionCertificate.IdRepresentative;
txtDescriptionStyle.Text = objE_InspectionCertificate.DescriptionStyle;
txtNumberInvoice.Text = objE_InspectionCertificate.NumberInvoice;
deIssueDateInvoice.DateTime = objE_InspectionCertificate.IssueDateInvoice;
cboCurrency.EditValue = objE_InspectionCertificate.IdCurrency;
txtAmount.EditValue = objE_InspectionCertificate.Amount;
deEtdDate.DateTime = objE_InspectionCertificate.EtdDate;
cboTypeShipping.EditValue = objE_InspectionCertificate.IdTypeShipping;
txtBoardingWay.Text = objE_InspectionCertificate.BoardingWay;
intIdStatus = objE_InspectionCertificate.IdStatus;
}
}
CargaInspectionCertificateDetail();
gvInspectionCertificateDetail.OptionsView.ShowFooter = true;
gvInspectionCertificateDetail.Layout += new EventHandler(gvInspectionCertificateDetail_Layout);
AttachSummary();
GridGroupSummaryItem item = new GridGroupSummaryItem();
item.FieldName = "POOrder";
item.ShowInGroupColumnFooter = gvInspectionCertificateDetail.Columns["POOrder"];
item.SummaryType = DevExpress.Data.SummaryItemType.Sum;
item.DisplayFormat = "TOTAL = {0:n0}";
gvInspectionCertificateDetail.GroupSummary.Add(item);
GridGroupSummaryItem ItemPieces = new GridGroupSummaryItem();
ItemPieces.FieldName = "Pieces";
ItemPieces.ShowInGroupColumnFooter = gvInspectionCertificateDetail.Columns["Pieces"];
ItemPieces.SummaryType = DevExpress.Data.SummaryItemType.Sum;
ItemPieces.DisplayFormat = "TOTAL = {0:n0}";
gvInspectionCertificateDetail.GroupSummary.Add(ItemPieces);
GridGroupSummaryItem ItemPercent = new GridGroupSummaryItem();
ItemPercent.FieldName = "Percents";
ItemPercent.ShowInGroupColumnFooter = gvInspectionCertificateDetail.Columns["Percents"];
ItemPercent.SummaryType = DevExpress.Data.SummaryItemType.Average;
ItemPercent.DisplayFormat = "PERCENT = {0:n0}";
gvInspectionCertificateDetail.GroupSummary.Add(ItemPercent);
GridGroupSummaryItem ItemAmountCertificate = new GridGroupSummaryItem();
ItemAmountCertificate.FieldName = "AmountCertificate";
ItemAmountCertificate.ShowInGroupColumnFooter = gvInspectionCertificateDetail.Columns["AmountCertificate"];
ItemAmountCertificate.SummaryType = DevExpress.Data.SummaryItemType.Sum;
ItemAmountCertificate.DisplayFormat = "TOTAL = {0:n2}";
gvInspectionCertificateDetail.GroupSummary.Add(ItemAmountCertificate);
gvInspectionCertificateDetail.ExpandAllGroups();
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
InspectionCertificateBL objBL_InspectionCertificate = new InspectionCertificateBL();
InspectionCertificateBE objInspectionCertificate = new InspectionCertificateBE();
objInspectionCertificate.NumberCertificate = txtNumberCertificate.Text;
objInspectionCertificate.IdClient = Convert.ToInt32(cboClient.EditValue);
objInspectionCertificate.IdClientDepartment = Convert.ToInt32(cboDivision.EditValue);
objInspectionCertificate.IdClientBrand = Convert.ToInt32(cboClientBrand.EditValue);
objInspectionCertificate.IdVendor = Convert.ToInt32(cboVendor.EditValue);
objInspectionCertificate.PaymentTerm = cboPaymentTerm.Text;
objInspectionCertificate.Cartons = Convert.ToInt32(txtCartons.EditValue);
objInspectionCertificate.IssueDate = Convert.ToDateTime(deIssueDate.DateTime.ToShortDateString());
objInspectionCertificate.IdRepresentative = Convert.ToInt32(cboRepresentative.EditValue);
objInspectionCertificate.DescriptionStyle = txtDescriptionStyle.Text;
objInspectionCertificate.NumberInvoice = txtNumberInvoice.Text;
objInspectionCertificate.IssueDateInvoice = Convert.ToDateTime(deIssueDateInvoice.DateTime.ToShortDateString());
objInspectionCertificate.IdCurrency = Convert.ToInt32(cboCurrency.EditValue);
objInspectionCertificate.Amount = Convert.ToDecimal(txtAmount.EditValue);
objInspectionCertificate.EtdDate = Convert.ToDateTime(deEtdDate.DateTime.ToShortDateString());
objInspectionCertificate.IdTypeShipping = Convert.ToInt32(cboTypeShipping.EditValue);
objInspectionCertificate.BoardingWay = txtBoardingWay.Text;
objInspectionCertificate.IdStatus = intIdStatus;
objInspectionCertificate.FlagState = true;
objInspectionCertificate.Login = Parametros.strUsuarioLogin;
objInspectionCertificate.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objInspectionCertificate.IdCompany = Parametros.intEmpresaId;
//DETAIL
List <InspectionCertificateDetailBE> lstInspectionCertificateDetail = new List <InspectionCertificateDetailBE>();
foreach (var item in mListaInspectionCertificateDetailOrigen)
{
InspectionCertificateDetailBE objE_InspectionCertificateDetail = new InspectionCertificateDetailBE();
objE_InspectionCertificateDetail.IdCompany = Parametros.intEmpresaId;
objE_InspectionCertificateDetail.IdInspectionCertificate = IdInspectionCertificate;
objE_InspectionCertificateDetail.IdInspectionCertificateDetail = item.IdInspectionCertificateDetail;
objE_InspectionCertificateDetail.IdProgramProductionDetail = item.IdProgramProductionDetail;
objE_InspectionCertificateDetail.NumberPO = item.NumberPO;
objE_InspectionCertificateDetail.NumberOI = item.NumberOI;
objE_InspectionCertificateDetail.NameStyle = item.NameStyle;
objE_InspectionCertificateDetail.Description = item.Description;
objE_InspectionCertificateDetail.Dyelot = item.Dyelot;
objE_InspectionCertificateDetail.Item = item.Item;
objE_InspectionCertificateDetail.Color = item.Color;
objE_InspectionCertificateDetail.POOrder = item.POOrder;
objE_InspectionCertificateDetail.Pieces = item.Pieces;
objE_InspectionCertificateDetail.Fob = item.Fob;
objE_InspectionCertificateDetail.AmountCertificate = item.AmountCertificate;
objE_InspectionCertificateDetail.Percents = item.Percents;
objE_InspectionCertificateDetail.TipoOper = item.TipoOper;
objE_InspectionCertificateDetail.FlagState = true;
objE_InspectionCertificateDetail.Login = Parametros.strUsuarioLogin;
objE_InspectionCertificateDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_InspectionCertificateDetail.TipoOper = item.TipoOper;
lstInspectionCertificateDetail.Add(objE_InspectionCertificateDetail);
//NUMBER PO
if (lstNumberPO.Count == 0)
{
lstNumberPO.Add(item.NumberPO);
}
else
{
int intIndex = 0;
intIndex = lstNumberPO.LastIndexOf(item.NumberPO);
if (intIndex < 0)
{
lstNumberPO.Add(item.NumberPO);
}
}
//NUMBER O/I
if (lstNumberOI.Count == 0)
{
lstNumberOI.Add(item.NumberOI);
}
else
{
int intIndex = 0;
intIndex = lstNumberOI.LastIndexOf(item.NumberOI);
if (intIndex < 0)
{
lstNumberOI.Add(item.NumberOI);
}
}
}
string strNumberPO = string.Join(",", lstNumberPO);
string strNumberOI = string.Join(",", lstNumberOI);
if (pOperacion == Operacion.Nuevo)
{
objInspectionCertificate.NumberPO = strNumberPO;
objInspectionCertificate.NumberOI = strNumberOI;
objBL_InspectionCertificate.Inserta(objInspectionCertificate, lstInspectionCertificateDetail);
Application.DoEvents();
}
else
{
objInspectionCertificate.NumberPO = strNumberPO;
objInspectionCertificate.NumberOI = strNumberOI;
objInspectionCertificate.IdInspectionCertificate = IdInspectionCertificate;
objBL_InspectionCertificate.Actualiza(objInspectionCertificate, lstInspectionCertificateDetail);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
