private void eliminarInvoiceDetailToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; i < gvInvoiceDetail.SelectedRowsCount; i++)
{
int row = gvInvoiceDetail.GetSelectedRows()[i];
InvoiceDetailBE objBE_InvoiceDetail = new InvoiceDetailBE();
objBE_InvoiceDetail.IdInvoiceDetail = int.Parse(gvInvoiceDetail.GetRowCellValue(row, "IdInvoiceDetail").ToString());
objBE_InvoiceDetail.IdCompany = Parametros.intEmpresaId;
objBE_InvoiceDetail.Login = Parametros.strUsuarioLogin;
objBE_InvoiceDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
InvoiceDetailBL objBL_InvoiceDetail = new InvoiceDetailBL();
objBL_InvoiceDetail.Elimina(objBE_InvoiceDetail);
gvInvoiceDetail.DeleteRow(row);
gvInvoiceDetail.RefreshData();
}
CalculaTotales();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <InvoiceDetailBE> ListaTodosActivo(int IdInvoice)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InvoiceDetail_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdInvoice", DbType.Int32, IdInvoice);
IDataReader reader = db.ExecuteReader(dbCommand);
List <InvoiceDetailBE> InvoiceDetaillist = new List <InvoiceDetailBE>();
InvoiceDetailBE InvoiceDetail;
while (reader.Read())
{
InvoiceDetail = new InvoiceDetailBE();
InvoiceDetail.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
InvoiceDetail.IdInvoice = Int32.Parse(reader["IdInvoice"].ToString());
InvoiceDetail.IdInvoiceDetail = Int32.Parse(reader["idInvoiceDetail"].ToString());
InvoiceDetail.IdInspectionCertificate = Int32.Parse(reader["IdInspectionCertificate"].ToString());
InvoiceDetail.NumberCertificate = reader["NumberCertificate"].ToString();
InvoiceDetail.IssueCertificate = DateTime.Parse(reader["IssueCertificate"].ToString());
InvoiceDetail.NameVendor = reader["NameVendor"].ToString();
InvoiceDetail.NumberInvoiceCertificate = reader["NumberInvoiceCertificate"].ToString();
InvoiceDetail.IssueDateInvoice = DateTime.Parse(reader["IssueDateInvoice"].ToString());
InvoiceDetail.NameDivision = reader["NameDivision"].ToString();
InvoiceDetail.Amount = Decimal.Parse(reader["Amount"].ToString());
InvoiceDetail.Comision = Decimal.Parse(reader["Comision"].ToString());
InvoiceDetail.Pieces = Decimal.Parse(reader["Pieces"].ToString());
InvoiceDetail.FlagState = Boolean.Parse(reader["FlagState"].ToString());
InvoiceDetail.TipoOper = 4; //CONSULTAR
InvoiceDetaillist.Add(InvoiceDetail);
}
reader.Close();
reader.Dispose();
return(InvoiceDetaillist);
}
public InvoiceDetailBE Selecciona(int IdInvoiceDetail)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InvoiceDetail_Selecciona");
db.AddInParameter(dbCommand, "pidInvoiceDetail", DbType.Int32, IdInvoiceDetail);
IDataReader reader = db.ExecuteReader(dbCommand);
InvoiceDetailBE InvoiceDetail = null;
while (reader.Read())
{
InvoiceDetail = new InvoiceDetailBE();
InvoiceDetail.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
InvoiceDetail.IdInvoice = Int32.Parse(reader["IdInvoice"].ToString());
InvoiceDetail.IdInvoiceDetail = Int32.Parse(reader["idInvoiceDetail"].ToString());
InvoiceDetail.IdInspectionCertificate = Int32.Parse(reader["IdInspectionCertificate"].ToString());
InvoiceDetail.NumberCertificate = reader["NumberCertificate"].ToString();
InvoiceDetail.IssueCertificate = DateTime.Parse(reader["IssueCertificate"].ToString());
InvoiceDetail.NameVendor = reader["NameVendor"].ToString();
InvoiceDetail.NumberInvoiceCertificate = reader["NumberInvoiceCertificate"].ToString();
InvoiceDetail.IssueDateInvoice = DateTime.Parse(reader["IssueDateInvoice"].ToString());
InvoiceDetail.NameDivision = reader["NameDivision"].ToString();
InvoiceDetail.Amount = Decimal.Parse(reader["Amount"].ToString());
InvoiceDetail.Comision = Decimal.Parse(reader["Comision"].ToString());
InvoiceDetail.Pieces = Decimal.Parse(reader["Pieces"].ToString());
InvoiceDetail.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(InvoiceDetail);
}
public void Elimina(InvoiceDetailBE pItem)
{
try
{
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InvoiceDetail.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(InvoiceDetailBE pItem)
{
try
{
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InvoiceDetail.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public InvoiceDetailBE Selecciona(int IdInvoiceDetail)
{
try
{
InvoiceDetailDL InvoiceDetail = new InvoiceDetailDL();
InvoiceDetailBE objEmp = InvoiceDetail.Selecciona(IdInvoiceDetail);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(InvoiceDetailBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InvoiceDetail_Elimina");
db.AddInParameter(dbCommand, "pIdInvoiceDetail", DbType.Int32, pItem.IdInvoiceDetail);
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(InvoiceDetailBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_InvoiceDetail_Actualiza");
db.AddInParameter(dbCommand, "pIdInvoiceDetail", DbType.Int32, pItem.IdInvoiceDetail);
db.AddInParameter(dbCommand, "pIdInvoice", DbType.Int32, pItem.IdInvoice);
db.AddInParameter(dbCommand, "pIdInspectionCertificate", DbType.Int32, pItem.IdInspectionCertificate);
db.AddInParameter(dbCommand, "pNumberCertificate", DbType.String, pItem.NumberCertificate);
db.AddInParameter(dbCommand, "pIssueCertificate", DbType.DateTime, pItem.IssueCertificate);
db.AddInParameter(dbCommand, "pNameVendor", DbType.String, pItem.NameVendor);
db.AddInParameter(dbCommand, "pNumberInvoiceCertificate", DbType.String, pItem.NumberInvoiceCertificate);
db.AddInParameter(dbCommand, "pIssueDateInvoice", DbType.DateTime, pItem.IssueDateInvoice);
db.AddInParameter(dbCommand, "pNameDivision", DbType.String, pItem.NameDivision);
db.AddInParameter(dbCommand, "pAmount", DbType.Decimal, pItem.Amount);
db.AddInParameter(dbCommand, "pComision", DbType.Decimal, pItem.Comision);
db.AddInParameter(dbCommand, "pPieces", DbType.Decimal, pItem.Pieces);
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())
{
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);
}
}
