public void SalesBillTaxEditBySalesMasterIdAndTaxId(SalesBillTaxInfo salesbilltaxinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesBillTaxEditBySalesMasterIdAndTaxId", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam7 = new SqlParameter(); sprmparam7 = sccmd.Parameters.Add("@salesMasterId", SqlDbType.Decimal); sprmparam7.Value = salesbilltaxinfo.SalesMasterId; sprmparam7 = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal); sprmparam7.Value = salesbilltaxinfo.TaxId; sprmparam7 = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal); sprmparam7.Value = salesbilltaxinfo.TaxAmount; sprmparam7 = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam7.Value = salesbilltaxinfo.ExtraDate; sprmparam7 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam7.Value = salesbilltaxinfo.Extra1; sprmparam7 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam7.Value = salesbilltaxinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }
public void SalesBillTaxEditBySalesMasterIdAndTaxId(SalesBillTaxInfo salesbilltaxinfo) { try { SPSalesBillTax.SalesBillTaxEditBySalesMasterIdAndTaxId(salesbilltaxinfo); } catch (Exception ex) { MessageBox.Show("CB:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public decimal SalesBillTaxAdd(SalesBillTaxInfo salesbilltaxinfo) { decimal dcSalesBillTaxId = 0; try { dcSalesBillTaxId = SPSalesBillTax.SalesBillTaxAdd(salesbilltaxinfo); } catch (Exception ex) { MessageBox.Show("CN01:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return dcSalesBillTaxId; }
public decimal SalesBillTaxAdd(SalesBillTaxInfo salesbilltaxinfo) { decimal decCompanyId = 0; try { decCompanyId = SPSalesBillTax.SalesBillTaxAdd(salesbilltaxinfo); } catch (Exception ex) { MessageBox.Show("CB:9" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decCompanyId); }
public SalesBillTaxInfo SalesBillTaxView(decimal salesBillTaxId) { SalesBillTaxInfo salesbilltaxinfo = new SalesBillTaxInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesBillTaxView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@salesBillTaxId", SqlDbType.Decimal); sprmparam2.Value = salesBillTaxId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { salesbilltaxinfo.SalesBillTaxId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString()); salesbilltaxinfo.SalesMasterId = decimal.Parse(((DbDataReader)sdrreader)[1].ToString()); salesbilltaxinfo.TaxId = decimal.Parse(((DbDataReader)sdrreader)[2].ToString()); salesbilltaxinfo.TaxAmount = decimal.Parse(((DbDataReader)sdrreader)[3].ToString()); salesbilltaxinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[4].ToString()); salesbilltaxinfo.Extra1 = ((DbDataReader)sdrreader)[5].ToString(); salesbilltaxinfo.Extra2 = ((DbDataReader)sdrreader)[6].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(salesbilltaxinfo); }
/// <summary> /// Function to insert values to SalesBillTax Table /// </summary> /// <param name="salesbilltaxinfo"></param> /// <returns></returns> public decimal SalesBillTaxAdd(SalesBillTaxInfo salesbilltaxinfo) { decimal dcSalesBillTaxId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesBillTaxAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salesMasterId", SqlDbType.Decimal); sprmparam.Value = salesbilltaxinfo.SalesMasterId; sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal); sprmparam.Value = salesbilltaxinfo.TaxId; sprmparam = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal); sprmparam.Value = salesbilltaxinfo.TaxAmount; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = salesbilltaxinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = salesbilltaxinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = salesbilltaxinfo.Extra2; dcSalesBillTaxId = Convert.ToDecimal(sccmd.ExecuteScalar()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(dcSalesBillTaxId); }
/// <summary> /// Function to insert values to SalesBillTax Table /// </summary> /// <param name="salesbilltaxinfo"></param> /// <returns></returns> public decimal SalesBillTaxAdd(SalesBillTaxInfo salesbilltaxinfo) { decimal dcSalesBillTaxId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesBillTaxAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salesMasterId", SqlDbType.Decimal); sprmparam.Value = salesbilltaxinfo.SalesMasterId; sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal); sprmparam.Value = salesbilltaxinfo.TaxId; sprmparam = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal); sprmparam.Value = salesbilltaxinfo.TaxAmount; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = salesbilltaxinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = salesbilltaxinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = salesbilltaxinfo.Extra2; dcSalesBillTaxId = Convert.ToDecimal(sccmd.ExecuteScalar()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return dcSalesBillTaxId; }
/// <summary> /// Function to get particular values from SalesBillTax Table based on the parameter /// </summary> /// <param name="salesBillTaxId"></param> /// <returns></returns> public SalesBillTaxInfo SalesBillTaxView(decimal salesBillTaxId) { SalesBillTaxInfo salesbilltaxinfo = new SalesBillTaxInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesBillTaxView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salesBillTaxId", SqlDbType.Decimal); sprmparam.Value = salesBillTaxId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { salesbilltaxinfo.SalesBillTaxId = decimal.Parse(sdrreader[0].ToString()); salesbilltaxinfo.SalesMasterId = decimal.Parse(sdrreader[1].ToString()); salesbilltaxinfo.TaxId = decimal.Parse(sdrreader[2].ToString()); salesbilltaxinfo.TaxAmount = decimal.Parse(sdrreader[3].ToString()); salesbilltaxinfo.ExtraDate = DateTime.Parse(sdrreader[4].ToString()); salesbilltaxinfo.Extra1 = sdrreader[5].ToString(); salesbilltaxinfo.Extra2 = sdrreader[6].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return salesbilltaxinfo; }