public bool Delete(string empresaid, tb_vendedor_corporativo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbVendedorCorporativo_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll(string empresaid, tb_vendedor_corporativo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbVendedorCorporativo_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid;
cmd.Parameters.Add("@vendorname", SqlDbType.VarChar, 100).Value = BE.vendorname;
cmd.Parameters.Add("@docuidentid", SqlDbType.Char, 1).Value = BE.docuidentid;
cmd.Parameters.Add("@vendordni", SqlDbType.Char, 11).Value = BE.vendordni;
cmd.Parameters.Add("@vendordire", SqlDbType.VarChar, 100).Value = BE.vendordire;
cmd.Parameters.Add("@vendortelef", SqlDbType.VarChar, 15).Value = BE.vendortelef;
cmd.Parameters.Add("@userweb", SqlDbType.VarChar, 15).Value = BE.userweb;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
cmd.Parameters.Add("@status", SqlDbType.Char, 15).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void ValidaVendedor(String xvendedorid, Boolean retrn)
{
if (xvendedorid.Trim().Length > 0)
{
var BL = new tb_vendedor_corporativoBL();
var BE = new tb_vendedor_corporativo();
var dt = new DataTable();
BE.vendorid = xvendedorid.Trim().PadLeft(4, '0');
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
vendperid.Text = dt.Rows[0]["vendorid"].ToString().Trim();
vendpername.Text = dt.Rows[0]["vendorname"].ToString().Trim();
}
else
{
if (!retrn)
{
vendperid.Text = string.Empty;
vendpername.Text = string.Empty;
vendperid.Focus();
}
}
}
}
public bool Update(string empresaid, tb_vendedor_corporativo BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbVendedorCorporativo_UPDATE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@vendorid", SqlDbType.Char, 4).Value = BE.vendorid;
cmd.Parameters.Add("@vendorname", SqlDbType.VarChar, 100).Value = BE.vendorname;
cmd.Parameters.Add("@docuidentid", SqlDbType.Char, 1).Value = BE.docuidentid;
cmd.Parameters.Add("@vendordni", SqlDbType.Char, 11).Value = BE.vendordni;
cmd.Parameters.Add("@vendordire", SqlDbType.VarChar, 100).Value = BE.vendordire;
cmd.Parameters.Add("@vendorfeing", SqlDbType.DateTime).Value = BE.vendorfeing;
cmd.Parameters.Add("@vendortelef", SqlDbType.VarChar, 15).Value = BE.vendortelef;
cmd.Parameters.Add("@userweb", SqlDbType.VarChar, 15).Value = BE.userweb;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private BindingSource NewMethodov()
{
var BL = new vendedor_corporativoBL();
var BE = new tb_vendedor_corporativo();
var table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
var rows = table.Rows;
object[] cell;
var dic = new Dictionary<string, string>();
var binding = new BindingSource();
foreach (DataRow item in rows)
{
cell = item.ItemArray;
dic.Add(cell[0].ToString(), cell[0].ToString() + " - " + cell[1].ToString());
cell = null;
}
binding.DataSource = dic;
return binding;
}
private void LllenarVendedor()
{
try
{
var BE = new tb_vendedor_corporativo();
BE.vendorid = null;
BE.vendorname = null;
cboVendedor.DataSource = NewMethodov();
cboVendedor.DisplayMember = "Value";
cboVendedor.ValueMember = "Key";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Update(string empresaid, tb_vendedor_corporativo BE)
{
return tablaDA.Update(empresaid, BE);
}
public bool Insert(string empresaid, tb_vendedor_corporativo BE)
{
return tablaDA.Insert(empresaid, BE);
}
public DataSet GetAll(string empresaid, tb_vendedor_corporativo BE)
{
return tablaDA.GetAll(empresaid, BE);
}
