public void Actualiza(VendorBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Vendor_Actualiza");
db.AddInParameter(dbCommand, "pIdVendor", DbType.Int32, pItem.IdVendor);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pFlagNational", DbType.Boolean, pItem.FlagNational);
db.AddInParameter(dbCommand, "pFlagForeigner", DbType.Boolean, pItem.FlagForeigner);
db.AddInParameter(dbCommand, "pRevenueDate", DbType.DateTime, pItem.RevenueDate);
db.AddInParameter(dbCommand, "pIdStatus", DbType.Int32, pItem.IdStatus);
db.AddInParameter(dbCommand, "pRuc", DbType.String, pItem.Ruc);
db.AddInParameter(dbCommand, "pNameVendor", DbType.String, pItem.NameVendor);
db.AddInParameter(dbCommand, "pIdEvaluation", DbType.Int32, pItem.IdEvaluation);
db.AddInParameter(dbCommand, "pCode", DbType.String, pItem.Code);
db.AddInParameter(dbCommand, "pCorporation", DbType.String, pItem.Corporation);
db.AddInParameter(dbCommand, "pCapacity", DbType.Decimal, pItem.Capacity);
db.AddInParameter(dbCommand, "pRepresentative", DbType.String, pItem.Representative);
db.AddInParameter(dbCommand, "pNumberEmployees", DbType.Int32, pItem.NumberEmployees);
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);
}
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)
{
if (!ValidarIngreso())
{
VendorBE objE_Vendor = new VendorBE();
objE_Vendor.IdVendor = int.Parse(gvVendor.GetFocusedRowCellValue("IdVendor").ToString());
objE_Vendor.Login = Parametros.strUsuarioLogin;
objE_Vendor.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Vendor.IdCompany = Parametros.intEmpresaId;
VendorBL objBL_Vendor = new VendorBL();
objBL_Vendor.Elimina(objE_Vendor);
XtraMessageBox.Show("The record was successfully deleted.", 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 frmRegVendorEdit_Load(object sender, EventArgs e)
{
BSUtils.LoaderLook(cboEvaluation, new EvaluationBL().ListaTodosActivo(Parametros.intEmpresaId), "NameEvaluation", "IdEvaluation", true);
cboEvaluation.EditValue = 0;
BSUtils.LoaderLook(cboStatus, new StatusBL().ListaTodosActivo(Parametros.intEmpresaId), "NameStatus", "IdStatus", true);
cboEvaluation.EditValue = 0;
deRevenueDate.DateTime = DateTime.Now;
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Vendor - New";
CargaVendorClassificationNuevo();
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Vendor - Update";
VendorBE objE_Vendor = null;
objE_Vendor = new VendorBL().Selecciona(IdVendor);
if (objE_Vendor != null)
{
IdVendor = objE_Vendor.IdVendor;
txtNameVendor.Text = objE_Vendor.NameVendor;
txtRuc.Text = objE_Vendor.Ruc;
cboStatus.EditValue = objE_Vendor.IdStatus;
cboEvaluation.EditValue = objE_Vendor.IdEvaluation;
deRevenueDate.EditValue = objE_Vendor.RevenueDate;
if (objE_Vendor.FlagNational)
{
chkNational.Checked = true;
}
else
{
chkNational.Checked = false;
}
if (objE_Vendor.FlagForeigner)
{
chkForeigner.Checked = true;
}
else
{
chkForeigner.Checked = false;
}
txtVendorCode.Text = objE_Vendor.Code;
txtCorporation.EditValue = objE_Vendor.Corporation;
txtRepresentative.EditValue = objE_Vendor.Representative;
txtCapacity.EditValue = objE_Vendor.Capacity;
txtNumberEmployees.EditValue = objE_Vendor.NumberEmployees;
txtSituation.Text = objE_Vendor.Situation;
CargaVendorClassificationModificar();
}
}
CargaVendorAddress();
CargaVendorContact();
txtNameVendor.Focus();
}
public void Actualiza(VendorBE pItem, List <VendorAddressBE> pListaVendorAddress, List <VendorContactBE> pListaVendorContact, List <VendorClassificationBE> pListaVendorClassification)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
VendorDL Vendor = new VendorDL();
VendorAddressDL VendorAddress = new VendorAddressDL();
VendorContactDL VendorContact = new VendorContactDL();
VendorClassificationDL VendorClassification = new VendorClassificationDL();
foreach (var item in pListaVendorAddress)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdVendor = pItem.IdVendor;
VendorAddress.Inserta(item);
}
else
{
VendorAddress.Actualiza(item);
}
}
foreach (var item in pListaVendorContact)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdVendor = pItem.IdVendor;
VendorContact.Inserta(item);
}
else
{
VendorContact.Actualiza(item);
}
}
foreach (var item in pListaVendorClassification)
{
if (item.TipoOper == Convert.ToInt32(Operacion.Nuevo)) //Nuevo
{
item.IdVendor = pItem.IdVendor;
VendorClassification.Inserta(item);
}
else
{
VendorClassification.Actualiza(item);
}
}
Vendor.Actualiza(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public VendorBE Selecciona(int IdVendor)
{
try
{
VendorDL Vendor = new VendorDL();
VendorBE objEmp = Vendor.Selecciona(IdVendor);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(VendorBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Vendor_Elimina");
db.AddInParameter(dbCommand, "pIdVendor", DbType.Int32, pItem.IdVendor);
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 Elimina(VendorBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
VendorDL Vendor = new VendorDL();
VendorAddressDL VendorAddress = new VendorAddressDL();
VendorContactDL VendorContact = new VendorContactDL();
VendorClassificationDL VendorClassification = new VendorClassificationDL();
List <VendorAddressBE> lstVendorAddress = null;
lstVendorAddress = new VendorAddressDL().ListaTodosActivo(pItem.IdVendor);
foreach (var item in lstVendorAddress)
{
VendorAddress.Elimina(item);
}
List <VendorContactBE> lstVendorContact = null;
lstVendorContact = new VendorContactDL().ListaTodosActivo(pItem.IdVendor);
foreach (var item in lstVendorContact)
{
VendorContact.Elimina(item);
}
List <VendorClassificationBE> lstVendorClassification = null;
lstVendorClassification = new VendorClassificationDL().ListaTodosActivo(pItem.IdVendor);
foreach (var item in lstVendorClassification)
{
VendorClassification.Elimina(item);
}
Vendor.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
public Int32 Inserta(VendorBE pItem, List <VendorAddressBE> pListaVendorAddress, List <VendorContactBE> pListaVendorContact, List <VendorClassificationBE> pListaVendorClassification)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
VendorDL Vendor = new VendorDL();
VendorAddressDL VendorAddress = new VendorAddressDL();
VendorContactDL VendorContact = new VendorContactDL();
VendorClassificationDL VendorClassification = new VendorClassificationDL();
int IdVendor = 0;
IdVendor = Vendor.Inserta(pItem);
foreach (var item in pListaVendorAddress)
{
item.IdVendor = IdVendor;
VendorAddress.Inserta(item);
}
foreach (var item in pListaVendorContact)
{
item.IdVendor = IdVendor;
VendorContact.Inserta(item);
}
foreach (var item in pListaVendorClassification)
{
item.IdVendor = IdVendor;
VendorClassification.Inserta(item);
}
ts.Complete();
return(IdVendor);
}
}
catch (Exception ex)
{ throw ex; }
}
public void InicializarModificar()
{
if (gvVendor.RowCount > 0)
{
VendorBE objVendor = new VendorBE();
objVendor.IdVendor = int.Parse(gvVendor.GetFocusedRowCellValue("IdVendor").ToString());
frmRegVendorEdit objManVendorEdit = new frmRegVendorEdit();
objManVendorEdit.pOperacion = frmRegVendorEdit.Operacion.Modificar;
objManVendorEdit.IdVendor = objVendor.IdVendor;
objManVendorEdit.StartPosition = FormStartPosition.CenterParent;
objManVendorEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public List <VendorBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Vendor_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <VendorBE> Vendorlist = new List <VendorBE>();
VendorBE Vendor;
while (reader.Read())
{
Vendor = new VendorBE();
Vendor.IdVendor = Int32.Parse(reader["IdVendor"].ToString());
Vendor.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Vendor.FlagNational = Boolean.Parse(reader["FlagNational"].ToString());
Vendor.FlagForeigner = Boolean.Parse(reader["FlagForeigner"].ToString());
Vendor.RevenueDate = DateTime.Parse(reader["RevenueDate"].ToString());
Vendor.NameVendor = reader["NameVendor"].ToString();
Vendor.IdStatus = Int32.Parse(reader["IdStatus"].ToString());
Vendor.NameStatus = reader["NameStatus"].ToString();
Vendor.Ruc = reader["Ruc"].ToString();
Vendor.NameVendor = reader["NameVendor"].ToString();
Vendor.IdEvaluation = Int32.Parse(reader["IdEvaluation"].ToString());
Vendor.NameEvaluation = reader["NameEvaluation"].ToString();
Vendor.Code = reader["Code"].ToString();
Vendor.Corporation = reader["Corporation"].ToString();
Vendor.Capacity = Decimal.Parse(reader["Capacity"].ToString());
Vendor.Representative = reader["Representative"].ToString();
Vendor.NumberEmployees = Int32.Parse(reader["NumberEmployees"].ToString());
Vendor.Situation = reader["Situation"].ToString();
Vendor.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Vendorlist.Add(Vendor);
}
reader.Close();
reader.Dispose();
return(Vendorlist);
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
VendorBE objVendor = new VendorBE();
VendorBL objBL_Vendor = new VendorBL();
objVendor.IdVendor = IdVendor;
objVendor.NameVendor = txtNameVendor.Text;
objVendor.FlagNational = (chkNational.Checked) ? true : false;
objVendor.FlagForeigner = (chkForeigner.Checked) ? true : false;
objVendor.RevenueDate = Convert.ToDateTime(deRevenueDate.DateTime.ToShortDateString());
objVendor.IdStatus = (int)cboStatus.EditValue;
objVendor.Ruc = txtRuc.Text;
objVendor.NameVendor = txtNameVendor.Text;
objVendor.IdEvaluation = (int)cboEvaluation.EditValue;
objVendor.Code = txtVendorCode.Text;
objVendor.Corporation = txtCorporation.Text;
objVendor.Capacity = Convert.ToDecimal(txtCapacity.EditValue);
objVendor.Representative = txtRepresentative.Text;
objVendor.NumberEmployees = Convert.ToInt32(txtNumberEmployees.EditValue);
objVendor.FlagState = true;
objVendor.Login = Parametros.strUsuarioLogin;
objVendor.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objVendor.IdCompany = Parametros.intEmpresaId;
//Vendor ADDRESS
List <VendorAddressBE> lstVendorAddress = new List <VendorAddressBE>();
foreach (var item in mListaVendorAddressOrigen)
{
VendorAddressBE objE_VendorAddress = new VendorAddressBE();
objE_VendorAddress.IdCompany = Parametros.intEmpresaId;
objE_VendorAddress.IdVendor = IdVendor;
objE_VendorAddress.IdVendorAddress = item.IdVendorAddress;
objE_VendorAddress.IdType = item.IdType;
objE_VendorAddress.Email = item.Email;
objE_VendorAddress.WebPage = item.WebPage;
objE_VendorAddress.Address = item.Address;
objE_VendorAddress.IdUbigeo = item.IdUbigeo;
objE_VendorAddress.City = item.City;
objE_VendorAddress.State = item.State;
objE_VendorAddress.IdCountry = item.IdCountry;
objE_VendorAddress.Phone1 = item.Phone1;
objE_VendorAddress.Phone2 = item.Phone2;
objE_VendorAddress.Fax = item.Fax;
objE_VendorAddress.Reference = item.Reference;
objE_VendorAddress.FlagState = true;
objE_VendorAddress.Login = Parametros.strUsuarioLogin;
objE_VendorAddress.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_VendorAddress.TipoOper = item.TipoOper;
lstVendorAddress.Add(objE_VendorAddress);
}
//Vendor CONTACT
List <VendorContactBE> lstVendorContact = new List <VendorContactBE>();
foreach (var item in mListaVendorContactOrigen)
{
VendorContactBE objE_VendorContact = new VendorContactBE();
objE_VendorContact.IdCompany = Parametros.intEmpresaId;
objE_VendorContact.IdVendor = IdVendor;
objE_VendorContact.IdVendorContact = item.IdVendorContact;
objE_VendorContact.Name = item.Name;
objE_VendorContact.FirstName = item.FirtsName;
objE_VendorContact.Company = item.Company;
objE_VendorContact.Occupation = item.Occupation;
objE_VendorContact.IdDestination = item.IdDestination;
objE_VendorContact.Phone1 = item.Phone1;
objE_VendorContact.Phone2 = item.Phone2;
objE_VendorContact.CelPhone = item.CelPhone;
objE_VendorContact.Fax = item.Fax;
objE_VendorContact.Email = item.Email;
objE_VendorContact.InformationAdditional = item.InformationAdditional;
objE_VendorContact.FlagState = true;
objE_VendorContact.Login = Parametros.strUsuarioLogin;
objE_VendorContact.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_VendorContact.TipoOper = item.TipoOper;
lstVendorContact.Add(objE_VendorContact);
}
//Vendor Classification
List <VendorClassificationBE> lstVendorClassification = new List <VendorClassificationBE>();
foreach (var item in mListaVendorClassificationOrigen)
{
VendorClassificationBE objE_VendorClassification = new VendorClassificationBE();
objE_VendorClassification.IdCompany = Parametros.intEmpresaId;
objE_VendorClassification.IdVendor = IdVendor;
objE_VendorClassification.IdVendorClassification = item.IdVendorClassification;
objE_VendorClassification.IdClassification = item.IdClassification;
objE_VendorClassification.NameClassification = item.NameClassification;
objE_VendorClassification.FlagActive = item.FlagActive;
objE_VendorClassification.FlagState = true;
objE_VendorClassification.Login = Parametros.strUsuarioLogin;
objE_VendorClassification.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_VendorClassification.TipoOper = item.TipoOper;
lstVendorClassification.Add(objE_VendorClassification);
}
if (pOperacion == Operacion.Nuevo)
{
objBL_Vendor.Inserta(objVendor, lstVendorAddress, lstVendorContact, lstVendorClassification);
XtraMessageBox.Show("the vendor record was created.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
objBL_Vendor.Actualiza(objVendor, lstVendorAddress, lstVendorContact, lstVendorClassification);
XtraMessageBox.Show("the vendor record was updated.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
