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)
{
int intIdInspectionCertificate = int.Parse(gvInspectionCertificate.GetFocusedRowCellValue("IdInspectionCertificate").ToString());
int intIdStatus = int.Parse(gvInspectionCertificate.GetFocusedRowCellValue("IdStatus").ToString());
if (intIdStatus == Parametros.intICDeleted)
{
XtraMessageBox.Show("It can not be canceled.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
InspectionCertificateBL objBL_InspectionCertificate = new InspectionCertificateBL();
objBL_InspectionCertificate.ActualizaSituacion(intIdInspectionCertificate, Parametros.intICDeleted);
XtraMessageBox.Show("The Inspection Certificate was canceled correctly.", 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);
}
}
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);
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
frmBusCertificate frm = new frmBusCertificate();
frm.IdClient = Convert.ToInt32(cboClient.EditValue);
frm.ShowDialog();
if (frm.mListaCertificate.Count > 0)
{
foreach (string strCertificate in frm.mListaCertificate)
{
List <InspectionCertificateBE> lstInspectionCertificate = null;
lstInspectionCertificate = new InspectionCertificateBL().ListaInvoiceDetail(Parametros.intEmpresaId, strCertificate);
foreach (var item in lstInspectionCertificate)
{
CInvoiceDetail objE_InvoiceDetail = new CInvoiceDetail();
objE_InvoiceDetail.IdCompany = item.IdCompany;
objE_InvoiceDetail.IdInvoice = 0;
objE_InvoiceDetail.IdInvoiceDetail = 0;
objE_InvoiceDetail.IdInspectionCertificate = item.IdInspectionCertificate;
objE_InvoiceDetail.NumberCertificate = item.NumberCertificate;
objE_InvoiceDetail.IssueCertificate = item.IssueDate;
objE_InvoiceDetail.NameVendor = item.NameVendor;
objE_InvoiceDetail.NumberInvoiceCertificate = item.NumberInvoice;
objE_InvoiceDetail.IssueDateInvoice = item.IssueDateInvoice;
objE_InvoiceDetail.NameDivision = item.NameDivision;
objE_InvoiceDetail.Amount = item.AmountCertificate;
objE_InvoiceDetail.Comision = item.Comision;
objE_InvoiceDetail.Pieces = item.Pieces;
objE_InvoiceDetail.TipoOper = Convert.ToInt32(Operacion.Nuevo);
mListaInvoiceDetailOrigen.Add(objE_InvoiceDetail);
}
}
bsListadoInvoiceDetail.DataSource = mListaInvoiceDetailOrigen;
gcInvoiceDetail.DataSource = bsListadoInvoiceDetail;
gcInvoiceDetail.RefreshDataSource();
CalculaTotales();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void txtNumberCertificate_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
List <InspectionCertificateBE> lstInspectionCertificate = null;
lstInspectionCertificate = new InspectionCertificateBL().ListaInvoiceDetail(Parametros.intEmpresaId, txtNumberCertificate.Text.Trim());
foreach (var item in lstInspectionCertificate)
{
CInvoiceDetail objE_InvoiceDetail = new CInvoiceDetail();
objE_InvoiceDetail.IdCompany = item.IdCompany;
objE_InvoiceDetail.IdInvoice = 0;
objE_InvoiceDetail.IdInvoiceDetail = 0;
objE_InvoiceDetail.IdInspectionCertificate = item.IdInspectionCertificate;
objE_InvoiceDetail.NumberCertificate = item.NumberCertificate;
objE_InvoiceDetail.IssueCertificate = item.IssueDate;
objE_InvoiceDetail.NameVendor = item.NameVendor;
objE_InvoiceDetail.NumberInvoiceCertificate = item.NumberInvoice;
objE_InvoiceDetail.IssueDateInvoice = item.IssueDateInvoice;
objE_InvoiceDetail.NameDivision = item.NameDivision;
objE_InvoiceDetail.Amount = item.AmountCertificate;
objE_InvoiceDetail.Comision = item.Comision;
objE_InvoiceDetail.Pieces = item.Pieces;
objE_InvoiceDetail.TipoOper = Convert.ToInt32(Operacion.Nuevo);
mListaInvoiceDetailOrigen.Add(objE_InvoiceDetail);
}
bsListadoInvoiceDetail.DataSource = mListaInvoiceDetailOrigen;
gcInvoiceDetail.DataSource = bsListadoInvoiceDetail;
gcInvoiceDetail.RefreshDataSource();
CalculaTotales();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 string CreateNumberCertificate(int IdClient)
{
string strNumberCertificate = "";
try
{
Cursor = Cursors.WaitCursor;
string strAbrevClient = "";
int intNumero = 0;
string strNumero = "";
ClientBE objE_Client = null;
objE_Client = new ClientBL().Selecciona(IdClient);
if (objE_Client != null)
{
strAbrevClient = objE_Client.Certificate;
}
intNumero = new InspectionCertificateBL().SeleccionaBusquedaCount(Parametros.intEmpresaId, Convert.ToInt32(cboClient.EditValue));
strNumero = FuncionBase.AgregarCaracter(intNumero.ToString(), "0", 5);
strNumberCertificate = strAbrevClient + Parametros.intPeriodo.ToString().Substring(2, 2) + strNumero;
Cursor = Cursors.Default;
return(strNumberCertificate);
}
catch (Exception ex)
{
Cursor = Cursors.Default;
return(strNumberCertificate);
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}
