private void eliminarCommimentDetailToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
int IdCommimentDetail = 0;
if (gvCommimentDetail.GetFocusedRowCellValue("IdCommimentDetail") != null)
{
IdCommimentDetail = int.Parse(gvCommimentDetail.GetFocusedRowCellValue("IdCommimentDetail").ToString());
}
CommimentDetailBE objBE_CommimentDetail = new CommimentDetailBE();
objBE_CommimentDetail.IdCommimentDetail = IdCommimentDetail;
objBE_CommimentDetail.IdCompany = Parametros.intEmpresaId;
objBE_CommimentDetail.Login = Parametros.strUsuarioLogin;
objBE_CommimentDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
CommimentDetailBL objBL_CommimentDetail = new CommimentDetailBL();
objBL_CommimentDetail.Elimina(objBE_CommimentDetail);
gvCommimentDetail.DeleteRow(gvCommimentDetail.FocusedRowHandle);
gvCommimentDetail.RefreshData();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <CommimentDetailBE> ListaTodosActivo(int IdCommiment)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_CommimentDetail_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCommiment", DbType.Int32, IdCommiment);
IDataReader reader = db.ExecuteReader(dbCommand);
List <CommimentDetailBE> CommimentDetaillist = new List <CommimentDetailBE>();
CommimentDetailBE CommimentDetail;
while (reader.Read())
{
CommimentDetail = new CommimentDetailBE();
CommimentDetail.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
CommimentDetail.IdCommiment = Int32.Parse(reader["IdCommiment"].ToString());
CommimentDetail.IdCommimentDetail = Int32.Parse(reader["idCommimentDetail"].ToString());
CommimentDetail.IdStyle = Int32.Parse(reader["IdStyle"].ToString());
CommimentDetail.NameStyle = reader["NameStyle"].ToString();
CommimentDetail.Description = reader["Description"].ToString();
CommimentDetail.Quantity = Decimal.Parse(reader["Quantity"].ToString());
CommimentDetail.Fob = Decimal.Parse(reader["Fob"].ToString());
CommimentDetail.Total = Decimal.Parse(reader["Total"].ToString());
CommimentDetail.FlagState = Boolean.Parse(reader["FlagState"].ToString());
CommimentDetail.TipoOper = 4; //CONSULTAR
CommimentDetaillist.Add(CommimentDetail);
}
reader.Close();
reader.Dispose();
return(CommimentDetaillist);
}
public CommimentDetailBE Selecciona(int IdCommimentDetail)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_CommimentDetail_Selecciona");
db.AddInParameter(dbCommand, "pidCommimentDetail", DbType.Int32, IdCommimentDetail);
IDataReader reader = db.ExecuteReader(dbCommand);
CommimentDetailBE CommimentDetail = null;
while (reader.Read())
{
CommimentDetail = new CommimentDetailBE();
CommimentDetail.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
CommimentDetail.IdCommiment = Int32.Parse(reader["IdCommiment"].ToString());
CommimentDetail.IdCommimentDetail = Int32.Parse(reader["idCommimentDetail"].ToString());
CommimentDetail.IdStyle = Int32.Parse(reader["IdStyle"].ToString());
CommimentDetail.NameStyle = reader["NameStyle"].ToString();
CommimentDetail.Description = reader["Description"].ToString();
CommimentDetail.Quantity = Decimal.Parse(reader["Quantity"].ToString());
CommimentDetail.Fob = Decimal.Parse(reader["Fob"].ToString());
CommimentDetail.Total = Decimal.Parse(reader["Total"].ToString());
CommimentDetail.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(CommimentDetail);
}
public void Elimina(CommimentDetailBE pItem)
{
try
{
CommimentDetailDL CommimentDetail = new CommimentDetailDL();
CommimentDetail.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(CommimentDetailBE pItem)
{
try
{
CommimentDetailDL CommimentDetail = new CommimentDetailDL();
CommimentDetail.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public CommimentDetailBE Selecciona(int IdCommimentDetail)
{
try
{
CommimentDetailDL CommimentDetail = new CommimentDetailDL();
CommimentDetailBE objEmp = CommimentDetail.Selecciona(IdCommimentDetail);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(CommimentDetailBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_CommimentDetail_Elimina");
db.AddInParameter(dbCommand, "pIdCommimentDetail", DbType.Int32, pItem.IdCommimentDetail);
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(CommimentDetailBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_CommimentDetail_Actualiza");
db.AddInParameter(dbCommand, "pIdCommimentDetail", DbType.Int32, pItem.IdCommimentDetail);
db.AddInParameter(dbCommand, "pIdCommiment", DbType.Int32, pItem.IdCommiment);
db.AddInParameter(dbCommand, "pIdStyle", DbType.Int32, pItem.IdStyle);
db.AddInParameter(dbCommand, "pQuantity", DbType.Decimal, pItem.Quantity);
db.AddInParameter(dbCommand, "pFob", DbType.Decimal, pItem.Fob);
db.AddInParameter(dbCommand, "pTotal", DbType.Decimal, pItem.Total);
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())
{
CommimentBL objBL_Commiment = new CommimentBL();
CommimentBE objCommiment = new CommimentBE();
objCommiment.IdCommiment = IdCommiment;
objCommiment.NumberCommiment = txtNumero.Text;
objCommiment.IdClient = Convert.ToInt32(cboClient.EditValue);
objCommiment.IdVendor = Convert.ToInt32(cboVendor.EditValue);
objCommiment.CommimentDate = Convert.ToDateTime(deCommimentDate.DateTime.ToShortDateString());
objCommiment.ContractShipDate = Convert.ToDateTime(deContractShipDate.DateTime.ToShortDateString());
objCommiment.RevisionDate = Convert.ToDateTime(deRevisionDate.DateTime.ToShortDateString());
objCommiment.NumberRevision = txtNumberRevision.Text;
objCommiment.IdOrigen = Convert.ToInt32(cboOrigin.EditValue);
objCommiment.IdDestination = Convert.ToInt32(cboDestination.EditValue);
objCommiment.IdCurrency = Convert.ToInt32(cboCurrency.EditValue);
objCommiment.FreightPaid = txtFreightPaid.Text;
objCommiment.Addionational = txtAddionational.Text;
objCommiment.FlagState = true;
objCommiment.Login = Parametros.strUsuarioLogin;
objCommiment.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objCommiment.IdCompany = Parametros.intEmpresaId;
//DETAIL
List <CommimentDetailBE> lstCommimentDetail = new List <CommimentDetailBE>();
foreach (var item in mListaCommimentDetailOrigen)
{
CommimentDetailBE objE_CommimentDetail = new CommimentDetailBE();
objE_CommimentDetail.IdCompany = Parametros.intEmpresaId;
objE_CommimentDetail.IdCommiment = IdCommiment;
objE_CommimentDetail.IdCommimentDetail = item.IdCommimentDetail;
objE_CommimentDetail.IdStyle = item.IdStyle;
objE_CommimentDetail.Quantity = item.Quantity;
objE_CommimentDetail.Fob = item.Fob;
objE_CommimentDetail.Total = item.Total;
objE_CommimentDetail.FlagState = true;
objE_CommimentDetail.Login = Parametros.strUsuarioLogin;
objE_CommimentDetail.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_CommimentDetail.TipoOper = item.TipoOper;
lstCommimentDetail.Add(objE_CommimentDetail);
}
if (pOperacion == Operacion.Nuevo)
{
int intNumero = 0;
string strNumero = "";
intNumero = objBL_Commiment.Inserta(objCommiment, lstCommimentDetail);
strNumero = FuncionBase.AgregarCaracter(intNumero.ToString(), "0", 10);
txtNumero.Text = strNumero;
//ActualizaNumero
CommimentBL objBCommiment = new CommimentBL();
objBCommiment.ActualizaNumero(intNumero, txtNumero.Text);
}
else
{
objBL_Commiment.Actualiza(objCommiment, lstCommimentDetail);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
