public bool Delete(string empresaid, tb_cxc_vendor BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCxcVendedor_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 GetAll2(string empresaid, tb_cxc_vendor BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCxcVendedor_SEARCH2", 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("@ddnni", SqlDbType.Char, 8).Value = BE.ddnni;
//cmd.Parameters.Add("@usuarweb", SqlDbType.Char, 15).Value = BE.usuarweb;
cmd.Parameters.Add("@parameters", SqlDbType.VarChar).Value = BE.parameters;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void form_cargar_datos(String posicion)
{
try
{
var BL = new tb_cxc_vendorBL();
var BE = new tb_cxc_vendor();
var dt = new DataTable();
BE.vendorid = txtvendorid.Text.Trim().PadLeft(4, '0');
BE.posicion = posicion.Trim();
dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
limpiar_documento();
ssModo = "EDIT";
txtvendorid.Text = dt.Rows[0]["grupoid"].ToString().Trim();
//gruponame.Text = dt.Rows[0]["gruponame"].ToString().Trim();
//ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
//ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
btn_editar.Enabled = true;
btn_eliminar.Enabled = true;
btn_imprimir.Enabled = true;
btn_log.Enabled = true;
btn_salir.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Delete()
{
try
{
if (txtvendorid.Text.Trim().Length != 4)
{
MessageBox.Show("Falta Codigo Vendedor !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new tb_cxc_vendorBL();
var BE = new tb_cxc_vendor();
BE.vendorid = txtvendorid.Text;
if (BL.Delete(EmpresaID, BE))
{
SEGURIDAD_LOG("E");
MessageBox.Show("Datos Eliminado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
NIVEL_FORMS();
limpiar_documento();
form_bloqueado(false);
data_TablaVendedor();
btn_nuevo.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_TablaVendedor()
{
if (TablaVendedor.Rows.Count > 0)
{
TablaVendedor.Rows.Clear();
}
var BL = new tb_cxc_vendorBL();
var BE = new tb_cxc_vendor();
BE.parameters = txtbusqueda.Text.Trim().ToUpper();
TablaVendedor = BL.GetAll(EmpresaID, BE).Tables[0];
if (TablaVendedor.Rows.Count > 0)
{
btn_imprimir.Enabled = true;
dgb_vendedores.DataSource = TablaVendedor;
dgb_vendedores.Rows[0].Selected = false;
}
}
public bool Update(string empresaid, tb_cxc_vendor BE)
{
return tablaDA.Update(empresaid, BE);
}
public bool Insert(string empresaid, tb_cxc_vendor BE)
{
return tablaDA.Insert(empresaid, BE);
}
private void data_gridVendedor()
{
tb_cxc_vendorBL BL = new tb_cxc_vendorBL();
tb_cxc_vendor BE = new tb_cxc_vendor();
switch (cbo_filtro.SelectedValue)
{
case "01":
BE.vendorid = txt_filter.Text.Trim().ToUpper();
break;
case "02":
BE.ddnni = txt_filter.Text.Trim().ToUpper();
break;
case "03":
BE.vendorname = txt_filter.Text.Trim().ToUpper();
break;
default:
//**
break;
}
try
{
//Eliminar Columnas Actuales(Opcional):
GridView1.Columns.Clear();
GridView1.Width = 550;
//Objeto Columna:
CommandField image;
//Crear Columna:
image = new CommandField();
image.ButtonType = ButtonType.Image;
image.SelectImageUrl = "~/Images/go-search.png";
image.ShowSelectButton = true;
image.ItemStyle.Width = 10;
image.ItemStyle.Wrap = true;
GridView1.Columns.Add(image);
BoundField DDNNI;
DDNNI = new BoundField();
DDNNI.DataField = "vendorid";
DDNNI.HeaderText = "CODIGO";
DDNNI.ItemStyle.Width = 80;
GridView1.Columns.Add(DDNNI);
BoundField APPAT;
APPAT = new BoundField();
APPAT.DataField = "ddnni";
APPAT.HeaderText = "DNI";
APPAT.ItemStyle.Width = 80;
GridView1.Columns.Add(APPAT);
BoundField NOMBR;
NOMBR = new BoundField();
NOMBR.DataField = "vendorname";
NOMBR.HeaderText = "NOMBRES";
NOMBR.ItemStyle.Width = 250;
GridView1.Columns.Add(NOMBR);
GridView1.DataSource = BL.GetAll(Session["ssEmpresaID"].ToString(), BE);
GridView1.DataBind();
GridView1.Visible = true;
}
catch (Exception ex)
{
ClientMessage(ex.Message);
}
}
public bool Delete(string empresaid, tb_cxc_vendor BE)
{
return tablaDA.Delete(empresaid, BE);
}
// VERIFICO COMO ESTOY INGRESANDO ( COMO QUE USUARIO ESTOY INGRESANDO )
void ValIngreso()
{
String xusu = Session["ssUsuar"].ToString().Trim(); tb_cxc_vendorBL BL = new tb_cxc_vendorBL();
tb_cxc_vendor BE = new tb_cxc_vendor();
DataTable dt = new DataTable();
BE.usuarweb = xusu;
dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0];
if (dt.Rows.Count > 0)
{
//txt_vendorname.Text = dt.Rows[0]["vendorname"].ToString();
Response.Redirect("~/Comercial/Listados/Lst_PedidosPend.aspx");
}
else
{
//txt_vendorname.Text = "VENDEDOR SIN PEDIDOS";
Response.Redirect("");
}
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
filtro = "PA";
switch (filtro)
{
case "PS":
tb_cxc_vendorBL PSBL = new tb_cxc_vendorBL();
tb_cxc_vendor PSBE = new tb_cxc_vendor();
DataTable PSDT = new DataTable();
PSBE.ddnni = GridView1.SelectedRow.Cells[2].Text;
PSDT = PSBL.GetAll(Session["ssEmpresaID"].ToString(), PSBE).Tables[0];
txt_vendorid.Text = PSDT.Rows[0]["vendorid"].ToString();
txt_vendorname.Text = PSDT.Rows[0]["vendorname"].ToString();
break;
case "PR":
String xctacte = GridView2.SelectedRow.Cells[1].Text;
ValidaCliente(xctacte);
break;
case "PA":
txt_articidold.Text = GridView2.SelectedRow.Cells[1].Text;
MetodoCargarLineal(txt_articidold.Text);
break;
}
}
catch (Exception ex)
{
//ClientMessage(ex.Message);
Response.Redirect("ErrorPage/Frm_PaginaError_405.aspx");
}
GridView2.SelectedRowStyle.CssClass = "SeRoSty alert-success";
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
filtro = "PR";
switch (filtro)
{
case "PS":
tb_cxc_vendorBL PSBL = new tb_cxc_vendorBL();
tb_cxc_vendor PSBE = new tb_cxc_vendor();
DataTable PSDT = new DataTable();
PSBE.ddnni = GridView1.SelectedRow.Cells[2].Text;
PSDT = PSBL.GetAll(Session["ssEmpresaID"].ToString(), PSBE).Tables[0];
txt_vendorid.Text = PSDT.Rows[0]["vendorid"].ToString();
txt_vendorname.Text = PSDT.Rows[0]["vendorname"].ToString();
break;
case "PR":
String xctacte = GridView1.SelectedRow.Cells[1].Text;
ValidaCliente(xctacte);
break;
case "PA":
txt_articidold.Text = GridView1.SelectedRow.Cells[1].Text;
MetodoCargarLineal("");
break;
}
//UpdatePanel2.Update();
//ModalPopupExtender2.Hide();
//data-dismiss="modal"
}
catch (Exception ex)
{
//ClientMessage(ex.Message);
Response.Redirect("ErrorPage/Frm_PaginaError_405.aspx");
}
}
public bool Update(string empresaid, tb_cxc_vendor BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCxcVendedor_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("@ddnni", SqlDbType.Char, 8).Value = BE.ddnni;
cmd.Parameters.Add("@nmruc", SqlDbType.Char, 11).Value = BE.nmruc;
cmd.Parameters.Add("@canalventaid", SqlDbType.Char, 3).Value = BE.canalventaid;
cmd.Parameters.Add("@direccion", SqlDbType.VarChar, 100).Value = BE.direccion;
cmd.Parameters.Add("@fech_ingre", SqlDbType.DateTime).Value = BE.fech_ingre;
cmd.Parameters.Add("@fech_cese", SqlDbType.DateTime).Value = BE.fech_cese;
cmd.Parameters.Add("@motivocese", SqlDbType.VarChar, 50).Value = BE.motivocese;
cmd.Parameters.Add("@telefonos", SqlDbType.VarChar, 20).Value = BE.telefono;
cmd.Parameters.Add("@usuarweb", SqlDbType.Char, 15).Value = BE.usuarweb;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void Update()
{
try
{
if (ValidaDatos())
{
var BL = new tb_cxc_vendorBL();
var BE = new tb_cxc_vendor();
BE.vendorid = txtvendorid.Text.Trim();
BE.vendorname = txtNombrelargo.Text.ToUpper();
BE.ddnni = txtdni.Text.Trim();
BE.nmruc = txtruc.Text.Trim();
BE.telefono = txttelefono.Text.Trim();
BE.canalventaid = txtcanalvtaid.Text;
BE.direccion = txtdireccion.Text.ToUpper();
if (fIngreso.Checked)
BE.fech_ingre = Convert.ToDateTime(fIngreso.Text);
if (fCese.Checked)
BE.fech_cese = Convert.ToDateTime(fCese.Text);
BE.motivocese = txtmotcese.Text;
BE.usuarweb = txtusuarweb.Text.ToUpper();
if (BL.Update(EmpresaID, BE))
{
SEGURIDAD_LOG("M");
MessageBox.Show("Datos Modificado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataSet GetAll2(string empresaid, tb_cxc_vendor BE)
{
return tablaDA.GetAll2(empresaid, BE);
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
switch (filtro)
{
case "PS":
tb_cxc_vendorBL PSBL = new tb_cxc_vendorBL();
tb_cxc_vendor PSBE = new tb_cxc_vendor();
DataTable PSDT = new DataTable();
PSBE.ddnni = GridView1.SelectedRow.Cells[2].Text;
PSDT = PSBL.GetAll(Session["ssEmpresaID"].ToString(), PSBE).Tables[0];
txt_vendorid.Text = PSDT.Rows[0]["vendorid"].ToString();
txt_vendorname.Text = PSDT.Rows[0]["vendorname"].ToString();
break;
case "PR":
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
DataTable dt = new DataTable();
BE.ctacte = GridView1.SelectedRow.Cells[1].Text;
dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0];
txt_ctacte.Text = dt.Rows[0]["ctacte"].ToString();
txt_ctactename.Text = dt.Rows[0]["ctactename"].ToString();
txt_ruc.Text = dt.Rows[0]["nmruc"].ToString();
direc_entrega.Text = dt.Rows[0]["direc"].ToString();
break;
case "PA":
txt_articidold.Text = GridView1.SelectedRow.Cells[1].Text;
MetodoCargarLineal();
break;
}
UpdatePanel2.Update();
ModalPopupExtender2.Hide();
}
catch (Exception ex)
{
ClientMessage(ex.Message);
}
}
public DataSet GetAll_paginacion(string empresaid, tb_cxc_vendor BE)
{
return tablaDA.GetAll_paginacion(empresaid, BE);
}
// PINTAMOS EL VENDEDOR DE DICHA
void Vendedor()
{
tb_cxc_vendorBL BL = new tb_cxc_vendorBL();
tb_cxc_vendor BE = new tb_cxc_vendor();
DataTable dt = new DataTable();
BE.usuarweb = Session["ssUsuar"].ToString().Trim();
dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0];
if (dt.Rows.Count > 0)
{
txt_vendorid.Text = dt.Rows[0]["vendorid"].ToString();
txt_vendorname.Text = dt.Rows[0]["vendorname"].ToString();
}
}
public DataSet GetAll_paginacion(string empresaid, tb_cxc_vendor BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPtColor_SEARCH_paginacion", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@colorid", SqlDbType.Char, 3).Value = BE.colorid;
//cmd.Parameters.Add("@posicion", SqlDbType.Char, 10).Value = BE.posicion;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
