private void eliminarVendorContactToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
int IdVendorContact = 0;
if (gvVendorContact.GetFocusedRowCellValue("IdVendorContact") != null)
{
IdVendorContact = int.Parse(gvVendorContact.GetFocusedRowCellValue("IdVendorContact").ToString());
}
VendorContactBE objBE_VendorContact = new VendorContactBE();
objBE_VendorContact.IdVendorContact = IdVendorContact;
objBE_VendorContact.IdCompany = Parametros.intEmpresaId;
objBE_VendorContact.Login = Parametros.strUsuarioLogin;
objBE_VendorContact.Machine = WindowsIdentity.GetCurrent().Name.ToString();
VendorContactBL objBL_VendorContact = new VendorContactBL();
objBL_VendorContact.Elimina(objBE_VendorContact);
gvVendorContact.DeleteRow(gvVendorContact.FocusedRowHandle);
gvVendorContact.RefreshData();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public VendorContactBE Selecciona(int IdVendorContact)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_VendorContact_Selecciona");
db.AddInParameter(dbCommand, "pidVendorContact", DbType.Int32, IdVendorContact);
IDataReader reader = db.ExecuteReader(dbCommand);
VendorContactBE VendorContact = null;
while (reader.Read())
{
VendorContact = new VendorContactBE();
VendorContact.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
VendorContact.IdVendor = Int32.Parse(reader["IdVendor"].ToString());
VendorContact.IdVendorContact = Int32.Parse(reader["idVendorContact"].ToString());
VendorContact.Name = reader["Name"].ToString();
VendorContact.FirstName = reader["FirtsName"].ToString();
VendorContact.Company = reader["Company"].ToString();
VendorContact.Occupation = reader["Occupation"].ToString();
VendorContact.IdDestination = Int32.Parse(reader["IdDestination"].ToString());
VendorContact.NameDestination = reader["NameDestination"].ToString();
VendorContact.Phone1 = reader["Phone1"].ToString();
VendorContact.Phone2 = reader["Phone2"].ToString();
VendorContact.CelPhone = reader["CelPhone"].ToString();
VendorContact.Fax = reader["Fax"].ToString();
VendorContact.Email = reader["Email"].ToString();
VendorContact.InformationAdditional = reader["InformationAdditional"].ToString();
VendorContact.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(VendorContact);
}
public void Elimina(VendorContactBE pItem)
{
try
{
VendorContactDL VendorContact = new VendorContactDL();
VendorContact.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(VendorContactBE pItem)
{
try
{
VendorContactDL VendorContact = new VendorContactDL();
VendorContact.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public VendorContactBE Selecciona(int IdVendorContact)
{
try
{
VendorContactDL VendorContact = new VendorContactDL();
VendorContactBE objEmp = VendorContact.Selecciona(IdVendorContact);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(VendorContactBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_VendorContact_Elimina");
db.AddInParameter(dbCommand, "pIdVendorContact", DbType.Int32, pItem.IdVendorContact);
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 List <VendorContactBE> ListaTodosActivo(int IdVendor)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_VendorContact_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdVendor", DbType.Int32, IdVendor);
IDataReader reader = db.ExecuteReader(dbCommand);
List <VendorContactBE> VendorContactlist = new List <VendorContactBE>();
VendorContactBE VendorContact;
while (reader.Read())
{
VendorContact = new VendorContactBE();
VendorContact.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
VendorContact.IdVendor = Int32.Parse(reader["IdVendor"].ToString());
VendorContact.IdVendorContact = Int32.Parse(reader["idVendorContact"].ToString());
VendorContact.Name = reader["Name"].ToString();
VendorContact.FirstName = reader["FirstName"].ToString();
VendorContact.Company = reader["Company"].ToString();
VendorContact.Occupation = reader["Occupation"].ToString();
VendorContact.IdDestination = Int32.Parse(reader["IdDestination"].ToString());
VendorContact.NameDestination = reader["NameDestination"].ToString();
VendorContact.Phone1 = reader["Phone1"].ToString();
VendorContact.Phone2 = reader["Phone2"].ToString();
VendorContact.CelPhone = reader["CelPhone"].ToString();
VendorContact.Fax = reader["Fax"].ToString();
VendorContact.Email = reader["Email"].ToString();
VendorContact.InformationAdditional = reader["InformationAdditional"].ToString();
VendorContact.FlagState = Boolean.Parse(reader["FlagState"].ToString());
VendorContact.TipoOper = 4; //CONSULTAR
VendorContactlist.Add(VendorContact);
}
reader.Close();
reader.Dispose();
return(VendorContactlist);
}
public void Actualiza(VendorContactBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_VendorContact_Actualiza");
db.AddInParameter(dbCommand, "pIdVendorContact", DbType.Int32, pItem.IdVendorContact);
db.AddInParameter(dbCommand, "pIdVendor", DbType.Int32, pItem.IdVendor);
db.AddInParameter(dbCommand, "pName", DbType.String, pItem.Name);
db.AddInParameter(dbCommand, "pFirstName", DbType.String, pItem.FirstName);
db.AddInParameter(dbCommand, "pCompany", DbType.String, pItem.Company);
db.AddInParameter(dbCommand, "pOccupation", DbType.String, pItem.Occupation);
db.AddInParameter(dbCommand, "pIdDestination", DbType.Int32, pItem.IdDestination);
db.AddInParameter(dbCommand, "pPhone1", DbType.String, pItem.Phone1);
db.AddInParameter(dbCommand, "pPhone2", DbType.String, pItem.Phone2);
db.AddInParameter(dbCommand, "pCelPhone", DbType.String, pItem.CelPhone);
db.AddInParameter(dbCommand, "pFax", DbType.String, pItem.Fax);
db.AddInParameter(dbCommand, "pEmail", DbType.String, pItem.Email);
db.AddInParameter(dbCommand, "pInformationAdditional", DbType.String, pItem.InformationAdditional);
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())
{
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);
}
}
