public DataSet GetOne(string empresaid, tb_tipimpto BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbTipimpto_SELECT", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; } 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_tipimpto BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbTipimpto_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Insert(string empresaid, tb_tipimpto BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbTipimpto_INSERT", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tipimptoid", SqlDbType.Char, 1).Value = BE.tipimptoid; cmd.Parameters.Add("@tipimptotasa", SqlDbType.Decimal).Value = BE.tipimptotasa; cmd.Parameters.Add("@status", SqlDbType.Bit).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 get_tipimptoid() { try { var BL = new tb_tipimptoBL(); var BE = new tb_tipimpto(); var dt = new DataTable(); BE.status = true; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { tipimptotasa.DataSource = dt; tipimptotasa.ValueMember = "tipimptoid"; tipimptotasa.DisplayMember = "tipimptotasa"; } else { MessageBox.Show("Active la tasa de impuesto", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private String get_tipimptotasa(String tipimptoid) { try { var BL = new tb_tipimptoBL(); var BE = new tb_tipimpto(); var dt = new DataTable(); BE.tipimptoid = tipimptoid.Trim(); dt = BL.GetOne(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { return Math.Round(Convert.ToDecimal(dt.Rows[0]["tipimptotasa"]), 0).ToString(); } else { return string.Empty; } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool Update(string empresaid, tb_tipimpto BE) { return tablaDA.Update(empresaid, BE); }
public bool Insert(string empresaid, tb_tipimpto BE) { return tablaDA.Insert(empresaid, BE); }
public DataSet GetOne(string empresaid, tb_tipimpto BE) { return tablaDA.GetOne(empresaid, BE); }
public bool Delete(string empresaid, tb_tipimpto BE) { return tablaDA.Delete(empresaid, BE); }
private void get_tipimptoid() { try { tb_tipimptoBL BL = new tb_tipimptoBL(); tb_tipimpto BE = new tb_tipimpto(); DataTable dt = new DataTable(); BE.status = true; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { //tipimptoid = dt.Rows[0]["tipimptoid"].ToString(); //igv = Convert.ToDecimal(dt.Rows[0]["tipimptotasa"]); //tipimptotasa.Text = dt.Rows[0]["tipimptotasa"].ToString() + "%"; tipimptotasa.DataSource = dt; tipimptotasa.DisplayMember = "tipimptotasa"; tipimptotasa.ValueMember = "tipimptoid"; tipimptotasa.SelectedIndex = 1; } else { MessageBox.Show("Active la tasa de impuesto", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }