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); } }