public void SaveValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceSaveValidIdTest = new Invoice {
InvoiceId = 3
};
context.Add(invoiceSaveValidIdTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(3);
invoiceBE.BillingAddress = "234 Test Street";
invoiceBE.BillingCity = "TestCity 232";
invoiceBE.BillingCountry = "TestCountry 43534";
invoiceBE.BillingPostalCode = "TestPC23";
invoiceBE.BillingState = "TestState 2324";
invoiceBE.InvoiceDate = new DateTime(2020, 1, 1);
invoiceBE.Total = 10;
invoiceBE.Save();
InvoiceBE invoiceBE2 = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE2.Load(3);
Assert.IsTrue(invoiceBE2.BillingAddress == "234 Test Street");
Assert.IsTrue(invoiceBE2.BillingCity == "TestCity 232");
Assert.IsTrue(invoiceBE2.BillingCountry == "TestCountry 43534");
Assert.IsTrue(invoiceBE2.BillingPostalCode == "TestPC23");
Assert.IsTrue(invoiceBE2.BillingState == "TestState 2324");
Assert.IsTrue(DateTime.Compare(invoiceBE2.InvoiceDate, new DateTime(2020, 1, 1)) == 0);
Assert.IsTrue(invoiceBE2.Total == 10);
}
public void Elimina(InvoiceBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
//INSPECTION CERTIFICATE DETAIL
List <InvoiceDetailBE> lstInvoiceDetail = null;
lstInvoiceDetail = new InvoiceDetailDL().ListaTodosActivo(pItem.IdInvoice);
foreach (var item in lstInvoiceDetail)
{
InspectionCertificate.ActualizaSituacion(item.IdInspectionCertificate, 14);
InvoiceDetail.Elimina(item);
}
Invoice.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public void LoadValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customer = new Customer
{
CustomerId = 2,
FirstName = "TestFirstName",
LastName = "TestLastName",
Email = "*****@*****.**"
};
var invoiceLoadValidIdTest = new Invoice {
CustomerId = 2, InvoiceId = 2, BillingAddress = "123 Test Street"
};
context.Add(customer);
context.Add(invoiceLoadValidIdTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(2);
Assert.IsTrue(invoiceBE.Id == 2);
Assert.IsTrue(invoiceBE.BillingAddress == "123 Test Street");
Assert.IsTrue(invoiceBE.CustomerFirstName == "TestFirstName");
Assert.IsTrue(invoiceBE.CustomerLastName == "TestLastName");
}
public void GetInvoiceLinesTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceGetInvoiceLinesTest = new Invoice {
InvoiceId = 4
};
var invoiceGetInvoiceLinesTest2 = new Invoice {
InvoiceId = 1
};
var invoiceLineGetInvoiceLinesTest = new InvoiceLine {
InvoiceLineId = 1, InvoiceId = 4, Quantity = 10
};
context.Add(invoiceGetInvoiceLinesTest);
context.Add(invoiceGetInvoiceLinesTest2);
context.Add(invoiceLineGetInvoiceLinesTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
InvoiceBE invoiceBE2 = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(4);
invoiceBE2.Load(1);
var invoiceLineBECollection = invoiceBE.GetInvoiceLines();
Assert.IsTrue(invoiceLineBECollection.First().GetType() == typeof(InvoiceLineBE));
Assert.IsTrue(invoiceLineBECollection.First().Quantity == 10);
Assert.IsTrue(invoiceLineBECollection.First().Id == 1);
Assert.IsTrue(invoiceBE2.GetInvoiceLines().IsNullOrEmpty());
}
public void AddToInvoiceLineTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceAddToInvoiceLineTest = new Invoice {
InvoiceId = 5
};
var invoiceLineAddToInvoiceLineTest = new InvoiceLine {
InvoiceLineId = 2, Quantity = 20
};
context.Add(invoiceAddToInvoiceLineTest);
context.Add(invoiceLineAddToInvoiceLineTest);
context.SaveChanges();
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(5);
invoiceLineBE.Load(2);
invoiceBE.AddToInvoiceLine(invoiceLineBE);
invoiceLineBE.Save();
invoiceBE.Load(5);
var InvoiceLineBECollection = invoiceBE.GetInvoiceLines().Where(p => p.Id == 2);
Assert.IsTrue(InvoiceLineBECollection.First().Id == 2);
Assert.IsTrue(InvoiceLineBECollection.First().InvoiceId == 5);
}
public void InvoiceCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceInvoiceCountTest = new Invoice {
InvoiceId = 1, CustomerId = 1
};
var customerInvoiceCountTest = new Customer {
CustomerId = 1
};
context.Add(invoiceInvoiceCountTest);
context.Add(customerInvoiceCountTest);
context.SaveChanges();
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
customerBE.Load(1);
Assert.IsTrue(customerBE.InvoiceCount == 1);
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.New();
customerBE.AddToInvoice(invoiceBE);
invoiceBE.Save();
CustomerBE customerBE2 = new CustomerBE(cRUDTestDBContextProvider);
customerBE2.Load(1);
Assert.IsTrue(customerBE2.InvoiceCount == 2);
}
public void AddToInvoiceTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customerAddToInvoiceTest = new Customer {
CustomerId = 1
};
var invoiceAddToInvoiceTest = new Invoice {
InvoiceId = 1, Total = 20
};
context.Add(customerAddToInvoiceTest);
context.Add(invoiceAddToInvoiceTest);
context.SaveChanges();
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(1);
customerBE.Load(1);
customerBE.AddToInvoice(invoiceBE);
invoiceBE.Save();
customerBE.Load(1);
var InvoiceBECollection = customerBE.GetInvoices().Where(p => p.Id == 1);
Assert.IsTrue(InvoiceBECollection.First().Id == 1);
Assert.IsTrue(InvoiceBECollection.First().CustomerID == 1);
}
public Int32 Inserta(InvoiceBE pItem, List <InvoiceDetailBE> pListaInvoiceDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InspectionCertificateDL InspectionCertificate = new InspectionCertificateDL();
int IdInvoice = 0;
IdInvoice = Invoice.Inserta(pItem);
foreach (var item in pListaInvoiceDetail)
{
InspectionCertificate.ActualizaSituacion(item.IdInspectionCertificate, 15);
item.IdInvoice = IdInvoice;
InvoiceDetail.Inserta(item);
}
ts.Complete();
return(IdInvoice);
}
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(InvoiceBE pItem, List <InvoiceDetailBE> pListaInvoiceDetail)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
foreach (var item in pListaInvoiceDetail)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdInvoice = pItem.IdInvoice;
InvoiceDetail.Inserta(item);
}
else
{
InvoiceDetail.Actualiza(item);
}
}
Invoice.Actualiza(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public void InvoiceLineCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceInvoiceLineCountTest = new Invoice {
InvoiceId = 6
};
var invoiceLineInvoiceLineCountTest = new InvoiceLine {
InvoiceLineId = 3, InvoiceId = 6
};
context.Add(invoiceInvoiceLineCountTest);
context.Add(invoiceLineInvoiceLineCountTest);
context.SaveChanges();
InvoiceBE invoiceBe = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBe.Load(6);
Assert.IsTrue(invoiceBe.InvoiceLineCount == 1);
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
invoiceLineBE.New();
invoiceBe.AddToInvoiceLine(invoiceLineBE);
invoiceLineBE.Save();
InvoiceBE invoiceBe2 = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBe2.Load(6);
Assert.IsTrue(invoiceBe2.InvoiceLineCount == 2);
}
public List <InvoiceBE> ListaClientDate(int IdCompany, int IdClient, int IdStatus, DateTime DateFrom, DateTime DateTo)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Invoice_ListaClientDate");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient);
db.AddInParameter(dbCommand, "pIdStatus", DbType.Int32, IdStatus);
db.AddInParameter(dbCommand, "pDateFrom", DbType.DateTime, DateFrom);
db.AddInParameter(dbCommand, "pDateTo", DbType.DateTime, DateTo);
IDataReader reader = db.ExecuteReader(dbCommand);
List <InvoiceBE> Invoicelist = new List <InvoiceBE>();
InvoiceBE Invoice;
while (reader.Read())
{
Invoice = new InvoiceBE();
Invoice.IdInvoice = Int32.Parse(reader["IdInvoice"].ToString());
Invoice.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Invoice.NameCompany = reader["NameCompany"].ToString();
Invoice.NumberInvoice = reader["NumberInvoice"].ToString();
Invoice.IdClient = Int32.Parse(reader["IdClient"].ToString());
Invoice.NameClient = reader["NameClient"].ToString();
Invoice.IssueDate = DateTime.Parse(reader["IssueDate"].ToString());
Invoice.IdDestination = Int32.Parse(reader["IdDestination"].ToString());
Invoice.NameDestination = reader["NameDestination"].ToString();
Invoice.IdClientBrand = Int32.Parse(reader["IdClientBrand"].ToString());
Invoice.BrandCertificate = reader["BrandCertificate"].ToString();
Invoice.PercentComision = Decimal.Parse(reader["PercentComision"].ToString());
Invoice.AddressClient = reader["AddressClient"].ToString();
Invoice.Contac = reader["Contac"].ToString();
Invoice.Occupation = reader["Occupation"].ToString();
Invoice.NoteGeneral = reader["NoteGeneral"].ToString();
Invoice.IdBank = Int32.Parse(reader["IdBank"].ToString());
Invoice.NameBank = reader["NameBank"].ToString();
Invoice.NumberCtaCte = reader["NumberCtaCte"].ToString();
Invoice.Swift = reader["Swift"].ToString();
Invoice.CodeAba = reader["CodeAba"].ToString();
Invoice.AddressBank = reader["AddressBank"].ToString();
Invoice.Phone = reader["Phone"].ToString();
Invoice.Representative = reader["Representative"].ToString();
Invoice.IdCurrency = Int32.Parse(reader["IdCurrency"].ToString());
Invoice.NameCurrency = reader["NameCurrency"].ToString();
Invoice.TotalAmount = Decimal.Parse(reader["TotalAmount"].ToString());
Invoice.TotalComision = Decimal.Parse(reader["TotalComision"].ToString());
Invoice.TotalPieces = Decimal.Parse(reader["TotalPieces"].ToString());
Invoice.ComisionLetter = reader["ComisionLetter"].ToString();
Invoice.IdStatus = Int32.Parse(reader["IdStatus"].ToString());
Invoice.NameStatus = reader["NameStatus"].ToString();
Invoice.NameVendor = reader["NameVendor"].ToString();
Invoice.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Invoicelist.Add(Invoice);
}
reader.Close();
reader.Dispose();
return(Invoicelist);
}
public void SaveWithoutIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.New();
invoiceBE.Save();
Assert.IsTrue(invoiceBE.Id != default);
}
public InvoiceBE Selecciona(int IdInvoice)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceBE objEmp = Invoice.Selecciona(IdInvoice);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public InvoiceBE SeleccionaNumberInvoice(string NumberInvoice)
{
try
{
InvoiceDL Invoice = new InvoiceDL();
InvoiceBE objEmp = Invoice.SeleccionaNumberInvoice(NumberInvoice);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(InvoiceBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Invoice_Elimina");
db.AddInParameter(dbCommand, "pIdInvoice", DbType.Int32, pItem.IdInvoice);
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 TotalValidation()
{
CRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Total = 1.11M;
Assert.IsTrue(invoiceBE.IsValid());
invoiceBE.Total = 1.111M;
Assert.IsFalse(invoiceBE.IsValid());
invoiceBE.Total = 1.1M;
Assert.IsTrue(invoiceBE.IsValid());
invoiceBE.Total = 1M;
Assert.IsTrue(invoiceBE.IsValid());
invoiceBE.Total = 0.00M;
Assert.IsTrue(invoiceBE.IsValid());
invoiceBE.Total = -1.00M;
Assert.IsFalse(invoiceBE.IsValid());
}
public Int32 Inserta(InvoiceBE pItem)
{
int intIdInvoice = 0;
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Invoice_Inserta");
db.AddOutParameter(dbCommand, "pIdInvoice", DbType.Int32, pItem.IdInvoice);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pNumberInvoice", DbType.String, pItem.NumberInvoice);
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, pItem.IdClient);
db.AddInParameter(dbCommand, "pIssueDate", DbType.DateTime, pItem.IssueDate);
db.AddInParameter(dbCommand, "pIdDestination", DbType.Int32, pItem.IdDestination);
db.AddInParameter(dbCommand, "pIdClientBrand", DbType.Int32, pItem.IdClientBrand);
db.AddInParameter(dbCommand, "pPercentComision", DbType.Decimal, pItem.PercentComision);
db.AddInParameter(dbCommand, "pAddressClient", DbType.String, pItem.AddressClient);
db.AddInParameter(dbCommand, "pContac", DbType.String, pItem.Contac);
db.AddInParameter(dbCommand, "pOccupation", DbType.String, pItem.Occupation);
db.AddInParameter(dbCommand, "pNoteGeneral", DbType.String, pItem.NoteGeneral);
db.AddInParameter(dbCommand, "pIdBank", DbType.Int32, pItem.IdBank);
db.AddInParameter(dbCommand, "pNameBank", DbType.String, pItem.NameBank);
db.AddInParameter(dbCommand, "pNumberCtaCte", DbType.String, pItem.NumberCtaCte);
db.AddInParameter(dbCommand, "pSwift", DbType.String, pItem.Swift);
db.AddInParameter(dbCommand, "pCodeAba", DbType.String, pItem.CodeAba);
db.AddInParameter(dbCommand, "pAddressBank", DbType.String, pItem.AddressBank);
db.AddInParameter(dbCommand, "pPhone", DbType.String, pItem.Phone);
db.AddInParameter(dbCommand, "pRepresentative", DbType.String, pItem.Representative);
db.AddInParameter(dbCommand, "pIdCurrency", DbType.Int32, pItem.IdCurrency);
db.AddInParameter(dbCommand, "pTotalAmount", DbType.Decimal, pItem.TotalAmount);
db.AddInParameter(dbCommand, "pTotalComision", DbType.Decimal, pItem.TotalComision);
db.AddInParameter(dbCommand, "pTotalPieces", DbType.Decimal, pItem.TotalPieces);
db.AddInParameter(dbCommand, "pComisionLetter", DbType.String, pItem.ComisionLetter);
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);
intIdInvoice = (int)db.GetParameterValue(dbCommand, "pIdInvoice");
return(intIdInvoice);
}
public void ToStringTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceToStringTest = new Invoice {
InvoiceId = 1, CustomerId = 1, InvoiceDate = new DateTime(2020, 1, 1)
};
var customerToStringTest = new Customer {
CustomerId = 1, FirstName = "TestFirstName", LastName = "TestLastName"
};
context.Add(customerToStringTest);
context.Add(invoiceToStringTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(1);
Assert.IsTrue(invoiceBE.ToString().Equals("Invoice ID: 1 Customer Name:TestFirstName TestLastName Date:01/01/2020"));
}
public void InicializarModificar()
{
if (gvInvoice.RowCount > 0)
{
InvoiceBE objInvoice = new InvoiceBE();
objInvoice.IdInvoice = int.Parse(gvInvoice.GetFocusedRowCellValue("IdInvoice").ToString());
frmRegInvoiceEdit objManInvoiceEdit = new frmRegInvoiceEdit();
objManInvoiceEdit.pOperacion = frmRegInvoiceEdit.Operacion.Modificar;
objManInvoiceEdit.IdInvoice = objInvoice.IdInvoice;
objManInvoiceEdit.StartPosition = FormStartPosition.CenterParent;
objManInvoiceEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
private void frmRegInvoiceEdit_Load(object sender, EventArgs e)
{
BSUtils.LoaderLook(cboClient, new LoginClientDepartmentBL().ListaClient(Parametros.intUsuarioId), "NameClient", "IdClient", true);
cboClient.EditValue = IdClient;
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;
BSUtils.LoaderLook(cboDestination, new DestinationBL().ListaTodosActivo(Parametros.intEmpresaId), "NameDestination", "IdDestination", true);
cboDestination.EditValue = 1;
BSUtils.LoaderLook(cboCurrency, new CurrencyBL().ListaCombo(Parametros.intEmpresaId), "NameCurrency", "IdCurrency", true);
BSUtils.LoaderLook(cboBank, new BankBL().ListaTodosActivo(Parametros.intEmpresaId), "NameBank", "IdBank", true);
gvInvoiceDetail.Columns["IssueCertificate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
gvInvoiceDetail.Columns["IssueCertificate"].DisplayFormat.FormatString = "MM/dd/yyyy";
gvInvoiceDetail.Columns["IssueDateInvoice"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
gvInvoiceDetail.Columns["IssueDateInvoice"].DisplayFormat.FormatString = "MM/dd/yyyy";
deIssueDate.DateTime = DateTime.Now;
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Invoice - New";
intIdStatus = Parametros.intIVNActive;
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Invoice - Update";
InvoiceBE objE_Invoice = null;
objE_Invoice = new InvoiceBL().Selecciona(IdInvoice);
if (objE_Invoice != null)
{
IdInvoice = objE_Invoice.IdInvoice;
txtNumberInvoice.Text = objE_Invoice.NumberInvoice;
cboClient.EditValue = objE_Invoice.IdClient;
deIssueDate.DateTime = objE_Invoice.IssueDate;
cboDestination.EditValue = objE_Invoice.IdDestination;
cboClientBrand.EditValue = objE_Invoice.IdClientBrand;
txtPercentComision.EditValue = objE_Invoice.PercentComision;
txtAddress.Text = objE_Invoice.AddressClient;
txtContact.Text = objE_Invoice.Contac;
txtOccupation.Text = objE_Invoice.Occupation;
txtNotesGeneral.Text = objE_Invoice.NoteGeneral;
cboBank.EditValue = objE_Invoice.IdBank;
txtNumberCtaCte.Text = objE_Invoice.NumberCtaCte;
txtSwift.Text = objE_Invoice.Swift;
txtCodeAba.Text = objE_Invoice.CodeAba;
txtAddressBank.Text = objE_Invoice.AddressBank;
txtPhone.Text = objE_Invoice.Phone;
txtRepresentative.Text = objE_Invoice.Representative;
cboCurrency.EditValue = objE_Invoice.IdCurrency;
txtTotalAmount.EditValue = objE_Invoice.TotalAmount;
txtTotalComision.EditValue = objE_Invoice.TotalComision;
txtTotalPieces.EditValue = objE_Invoice.TotalPieces;
intIdStatus = objE_Invoice.IdStatus;
}
}
CargaInvoiceDetail();
CalculaTotales();
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
InvoiceBL objBL_Invoice = new InvoiceBL();
InvoiceBE objInvoice = new InvoiceBE();
objInvoice.NumberInvoice = txtNumberInvoice.Text;
objInvoice.IdClient = Convert.ToInt32(cboClient.EditValue);
objInvoice.IssueDate = Convert.ToDateTime(deIssueDate.DateTime.ToShortDateString());
objInvoice.IdDestination = Convert.ToInt32(cboDestination.EditValue);
objInvoice.IdClientBrand = Convert.ToInt32(cboClientBrand.EditValue);
objInvoice.PercentComision = Convert.ToDecimal(txtPercentComision.EditValue);
objInvoice.AddressClient = txtAddress.Text;
objInvoice.Contac = txtContact.Text;
objInvoice.Occupation = txtOccupation.Text;
objInvoice.NoteGeneral = txtNotesGeneral.Text;
objInvoice.IdBank = Convert.ToInt32(cboBank.EditValue);
objInvoice.NameBank = cboBank.Text;
objInvoice.NumberCtaCte = txtNumberCtaCte.Text;
objInvoice.Swift = txtSwift.Text;
objInvoice.CodeAba = txtCodeAba.Text;
objInvoice.AddressBank = txtAddressBank.Text;
objInvoice.Phone = txtPhone.Text;
objInvoice.Representative = txtRepresentative.Text;
objInvoice.IdCurrency = Convert.ToInt32(cboCurrency.EditValue);
objInvoice.TotalAmount = Convert.ToDecimal(txtTotalAmount.EditValue);
objInvoice.TotalComision = Convert.ToDecimal(txtTotalComision.EditValue);
objInvoice.TotalPieces = Convert.ToDecimal(txtTotalPieces.EditValue);
objInvoice.IdStatus = intIdStatus;
objInvoice.FlagState = true;
objInvoice.Login = Parametros.strUsuarioLogin;
objInvoice.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objInvoice.IdCompany = Parametros.intEmpresaId;
//DETAIL
List <InvoiceDetailBE> lstInvoiceDetail = new List <InvoiceDetailBE>();
foreach (var item in mListaInvoiceDetailOrigen)
{
InvoiceDetailBE objE_InvoiceDetail = new InvoiceDetailBE();
objE_InvoiceDetail.IdCompany = Parametros.intEmpresaId;
objE_InvoiceDetail.IdInvoice = IdInvoice;
objE_InvoiceDetail.IdInvoiceDetail = item.IdInvoiceDetail;
objE_InvoiceDetail.IdInspectionCertificate = item.IdInspectionCertificate;
objE_InvoiceDetail.NumberCertificate = item.NumberCertificate;
objE_InvoiceDetail.IssueCertificate = item.IssueCertificate;
objE_InvoiceDetail.NameVendor = item.NameVendor;
objE_InvoiceDetail.NumberInvoiceCertificate = item.NumberInvoiceCertificate;
objE_InvoiceDetail.IssueDateInvoice = item.IssueDateInvoice;
objE_InvoiceDetail.NameDivision = item.NameDivision;
objE_InvoiceDetail.Amount = item.Amount;
objE_InvoiceDetail.Comision = item.Comision;
objE_InvoiceDetail.Pieces = item.Pieces;
objE_InvoiceDetail.TipoOper = item.TipoOper;
objE_InvoiceDetail.FlagState = true;
objE_InvoiceDetail.Login = Parametros.strUsuarioLogin;
objE_InvoiceDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_InvoiceDetail.TipoOper = item.TipoOper;
lstInvoiceDetail.Add(objE_InvoiceDetail);
}
int tam_var = txtTotalComision.Text.Length;
String strDecimal = txtTotalComision.Text.Substring((tam_var - 2), 2);
decimal decNumero = Math.Truncate(Convert.ToDecimal(txtTotalComision.EditValue));
String strComisionLetter = IntegerToWords(Convert.ToInt32(decNumero)) + " AND " + strDecimal + "/100" + " US$";
objInvoice.ComisionLetter = strComisionLetter.ToUpper();
if (pOperacion == Operacion.Nuevo)
{
objBL_Invoice.Inserta(objInvoice, lstInvoiceDetail);
Application.DoEvents();
}
else
{
objInvoice.IdInvoice = IdInvoice;
objBL_Invoice.Actualiza(objInvoice, lstInvoiceDetail);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
