public DataSet GetAll(string empresaid, tb_px_promociones BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPxPromocion_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@promoid", SqlDbType.Int).Value = BE.promoid;
cmd.Parameters.Add("@promoname", SqlDbType.VarChar, 50).Value = BE.promoname;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_paginacion(string empresaid, tb_px_promociones 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("@grupopromoid", SqlDbType.Int).Value = BE.grupopromoid;
// 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);
}
}
}
}
public bool Delete(string empresaid, tb_px_promociones BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPxPromocion_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@promoid", SqlDbType.Int).Value = BE.promoid;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update(string empresaid, tb_px_promociones BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPxPromocion_UPDATE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@promoid", SqlDbType.Int).Value = BE.promoid;
cmd.Parameters.Add("@prioridad", SqlDbType.Char).Value = BE.prioridad;
cmd.Parameters.Add("@status", SqlDbType.Char,1).Value = BE.status;
cmd.Parameters.Add("@exclusivo", SqlDbType.Char).Value = BE.exclusivo;
cmd.Parameters.Add("@promoname", SqlDbType.VarChar, 50).Value = BE.promoname;
cmd.Parameters.Add("@tiendalist", SqlDbType.Int).Value = BE.tiendalist;
cmd.Parameters.Add("@tarjgroupid", SqlDbType.Int).Value = BE.tarjgrupoid;
cmd.Parameters.Add("@tarjetaid", SqlDbType.Int).Value = BE.tarjetaid;
cmd.Parameters.Add("@percdscto", SqlDbType.Decimal).Value = BE.percdscto;
cmd.Parameters.Add("@alDocum", SqlDbType.Bit).Value = BE.al_docum;
cmd.Parameters.Add("@fechaini", SqlDbType.DateTime).Value = BE.fechaini;
cmd.Parameters.Add("@fechafin", SqlDbType.DateTime).Value = BE.fechafin;
cmd.Parameters.Add("@promotipoid", SqlDbType.Int).Value = BE.promotipoid;
cmd.Parameters.Add("@grupopromoid", SqlDbType.Int).Value = BE.grupopromoid;
cmd.Parameters.Add("@campaniaid", SqlDbType.Int).Value = BE.campaniaid;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
cmd.Parameters.Add("@fecre", SqlDbType.DateTime).Value = BE.fecre;
cmd.Parameters.Add("@feact", SqlDbType.DateTime).Value = BE.feact;
cmd.Parameters.Add("@usuarap", SqlDbType.Char, 15).Value = BE.usuarap;
cmd.Parameters.Add("@fechap", SqlDbType.DateTime).Value = BE.fechap;
cmd.Parameters.Add("@solodias", SqlDbType.Bit).Value = BE.solodias;
cmd.Parameters.Add("@dom", SqlDbType.Bit).Value = BE.dom;
cmd.Parameters.Add("@lun", SqlDbType.Bit).Value = BE.lun;
cmd.Parameters.Add("@mar", SqlDbType.Bit).Value = BE.mar;
cmd.Parameters.Add("@mie", SqlDbType.Bit).Value = BE.mie;
cmd.Parameters.Add("@jue", SqlDbType.Bit).Value = BE.jue;
cmd.Parameters.Add("@vie", SqlDbType.Bit).Value = BE.vie;
cmd.Parameters.Add("@sab", SqlDbType.Bit).Value = BE.sab;
cmd.Parameters.Add("@npack", SqlDbType.Int).Value = BE.npack;
cmd.Parameters.Add("@impopack", SqlDbType.Decimal).Value = BE.impopack;
cmd.Parameters.Add("@aplicini", SqlDbType.Int).Value = BE.aplicini;
cmd.Parameters.Add("@aplicfin", SqlDbType.Int).Value = BE.aplicfin;
cmd.Parameters.Add("@impodoc", SqlDbType.Decimal).Value = BE.impodoc;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update(string empresaid, tb_px_promociones BE)
{
return tablaDA.Update(empresaid, BE);
}
public DataSet GetFiltro(string empresaid, tb_px_promociones BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPxPromocion_FILTRO", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@fecha", SqlDbType.DateTime).Value = BE.fechaActual;
cmd.Parameters.Add("@filtro", SqlDbType.Int).Value = BE.filtro;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetFiltro(string empresaid, tb_px_promociones BE)
{
return tablaDA.GetFiltro(empresaid, BE);
}
public bool Insert(string empresaid, tb_px_promociones BE)
{
return tablaDA.Insert(empresaid, BE);
}
public DataSet GetAll_paginacion(string empresaid, tb_px_promociones BE)
{
return tablaDA.GetAll_paginacion(empresaid, BE);
}
private void Group_chks_SelectedIndexChanged(object sender, EventArgs e)
{
var BL = new tb_px_promocionesBL();
var BE = new tb_px_promociones();
BE.fechaActual = Convert.ToDateTime(DateTime.Today.ToShortDateString());
if (Group_chks.SelectedIndex == 0)
{
BE.filtro = Group_chks.SelectedIndex;
}
else
{
if (Group_chks.SelectedIndex == 1)
{
BE.filtro = Group_chks.SelectedIndex;
}
else
{
if (Group_chks.SelectedIndex == 2)
{
BE.filtro = Group_chks.SelectedIndex;
}
}
}
Tablapromo = BL.GetFiltro(EmpresaID, BE).Tables[0];
if (Tablapromo.Rows.Count > 0)
{
Mdi_dgv_promociones.DataSource = Tablapromo;
}
else
{
Mdi_dgv_promociones.DataSource = Tablapromo;
}
}
private void Delete()
{
try
{
if (promoid.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Codigo Lista !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new tb_px_promocionesBL();
var BE = new tb_px_promociones();
BE.promoid = Convert.ToInt32(promoid.Text.Trim());
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_Tablapromo();
CargarDetalle();
btn_nuevo.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_Tablapromo()
{
try
{
Tablapromo = new DataTable();
if (Tablapromo.Rows.Count > 0)
{
Tablapromo.Rows.Clear();
}
var BL = new tb_px_promocionesBL();
var BE = new tb_px_promociones();
Tablapromo = BL.GetAll(EmpresaID, BE).Tables[0];
if (Tablapromo.Rows.Count > 0)
{
btn_imprimir.Enabled = true;
Mdi_dgv_promociones.DataSource = Tablapromo;
}
else
{
Mdi_dgv_promociones.DataSource = Tablapromo;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Update()
{
try
{
if (promoid.Text.Trim().Length == 0)
{
MessageBox.Show("Falta Codigo de Promoción", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new tb_px_promocionesBL();
var BE = new tb_px_promociones();
BE.promoid = Convert.ToInt32(promoid.Text.Trim());
BE.prioridad = prioridad.Text.Trim();
var n = rdb_estado.SelectedIndex;
if (n == 0)
{
BE.status = "0";
}
else
{
BE.status = "9";
}
BE.exclusivo = exclusivo.Text.Trim();
BE.promoname = promoname.Text.Trim();
if (cmb_tiendalist.SelectedIndex != -1)
{
BE.tiendalist = Convert.ToInt32(cmb_tiendalist.SelectedValue.ToString().Trim());
}
if (cmb_tarjgrupoid.SelectedIndex != -1)
{
BE.tarjgrupoid = Convert.ToInt32(cmb_tarjgrupoid.SelectedValue.ToString().Trim());
}
BE.percdscto = Convert.ToDecimal(perdsctocab.Text.Trim());
BE.al_docum = chk_aldocum.Checked;
BE.fechaini = Convert.ToDateTime(fechaini.Text);
BE.fechafin = Convert.ToDateTime(fechafin.Text);
if (cmb_grupopromocion.SelectedIndex != -1)
{
BE.grupopromoid = Convert.ToInt32(cmb_grupopromocion.SelectedValue.ToString().Trim());
}
BE.usuar = VariablesPublicas.Usuar.Trim();
BE.fecre = Convert.ToDateTime(DateTime.Today.ToShortDateString());
BE.feact = Convert.ToDateTime(DateTime.Today.ToShortDateString());
BE.usuarap = VariablesPublicas.Usuar.Trim();
BE.fechap = Convert.ToDateTime(DateTime.Today.ToShortDateString());
BE.solodias = chk_solodias.Checked;
BE.dom = chk_dom.Checked;
BE.lun = chk_lun.Checked;
BE.mar = chk_mar.Checked;
BE.mie = chk_mie.Checked;
BE.jue = chk_jue.Checked;
BE.vie = chk_vie.Checked;
BE.sab = chk_sab.Checked;
BE.npack = Convert.ToInt32(npack.Text.Trim());
BE.impodoc = Convert.ToDecimal(impopack.Text.Trim());
BE.aplicini = Convert.ToInt32(aplicini.Text.Trim());
BE.aplicfin = Convert.ToInt32(aplicfin.Text.Trim());
BE.impodoc = Convert.ToDecimal(impodoc.Text.Trim());
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);
}
}
