public SalesReturnMasterInfo SalesReturnMasterView(decimal salesReturnMasterId) { SalesReturnMasterInfo salesreturnmasterinfo = new SalesReturnMasterInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesReturnMasterView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@salesReturnMasterId", SqlDbType.Decimal); sprmparam2.Value = salesReturnMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { salesreturnmasterinfo.SalesReturnMasterId = decimal.Parse(((DbDataReader)sdrreader)["salesReturnMasterId"].ToString()); salesreturnmasterinfo.VoucherNo = ((DbDataReader)sdrreader)["voucherNo"].ToString(); salesreturnmasterinfo.InvoiceNo = ((DbDataReader)sdrreader)[2].ToString(); salesreturnmasterinfo.VoucherTypeId = decimal.Parse(((DbDataReader)sdrreader)["voucherTypeId"].ToString()); salesreturnmasterinfo.SuffixPrefixId = decimal.Parse(((DbDataReader)sdrreader)["suffixPrefixId"].ToString()); salesreturnmasterinfo.LedgerId = decimal.Parse(((DbDataReader)sdrreader)["ledgerId"].ToString()); salesreturnmasterinfo.SalesAccount = decimal.Parse(((DbDataReader)sdrreader)[6].ToString()); salesreturnmasterinfo.PricinglevelId = decimal.Parse(((DbDataReader)sdrreader)["pricinglevelId"].ToString()); salesreturnmasterinfo.EmployeeId = decimal.Parse(((DbDataReader)sdrreader)["employeeId"].ToString()); salesreturnmasterinfo.Narration = ((DbDataReader)sdrreader)[9].ToString(); salesreturnmasterinfo.ExchangeRateId = decimal.Parse(((DbDataReader)sdrreader)["exchangeRateId"].ToString()); salesreturnmasterinfo.TaxAmount = decimal.Parse(((DbDataReader)sdrreader)["taxAmount"].ToString()); salesreturnmasterinfo.UserId = decimal.Parse(((DbDataReader)sdrreader)["userId"].ToString()); salesreturnmasterinfo.LrNo = ((DbDataReader)sdrreader)[13].ToString(); salesreturnmasterinfo.TransportationCompany = ((DbDataReader)sdrreader)[14].ToString(); salesreturnmasterinfo.Date = DateTime.Parse(((DbDataReader)sdrreader)["date"].ToString()); salesreturnmasterinfo.TotalAmount = decimal.Parse(((DbDataReader)sdrreader)["totalAmount"].ToString()); salesreturnmasterinfo.grandTotal = decimal.Parse(((DbDataReader)sdrreader)["grandTotal"].ToString()); salesreturnmasterinfo.FinancialYearId = decimal.Parse(((DbDataReader)sdrreader)["financialYearId"].ToString()); salesreturnmasterinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)["extraDate"].ToString()); salesreturnmasterinfo.Extra1 = ((DbDataReader)sdrreader)["extra1"].ToString(); salesreturnmasterinfo.Extra2 = ((DbDataReader)sdrreader)[20].ToString(); salesreturnmasterinfo.Discount = decimal.Parse(((DbDataReader)sdrreader)["discount"].ToString()); salesreturnmasterinfo.SalesMasterId = decimal.Parse(((DbDataReader)sdrreader)["salesMasterId"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(salesreturnmasterinfo); }
public void SalesReturnMasterEdit(SalesReturnMasterInfo infoSalesReturnMaster) { try { spSalesReturnMaster.SalesReturnMasterEdit(infoSalesReturnMaster); } catch (Exception ex) { MessageBox.Show("AG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public decimal SalesReturnMasterAdd(SalesReturnMasterInfo infoSalesReturnMaster) { decimal decIdentity = 0; try { decIdentity = spSalesReturnMaster.SalesReturnMasterAdd(infoSalesReturnMaster); } catch (Exception ex) { MessageBox.Show("AG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decIdentity); }
public void SalesReturnMasterEdit(SalesReturnMasterInfo salesreturnmasterinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesReturnMasterEdit", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam24 = new SqlParameter(); sprmparam24 = sccmd.Parameters.Add("@salesReturnMasterId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.SalesReturnMasterId; sprmparam24 = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.VoucherNo; sprmparam24 = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.InvoiceNo; sprmparam24 = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.VoucherTypeId; sprmparam24 = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.SuffixPrefixId; sprmparam24 = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.LedgerId; sprmparam24 = sccmd.Parameters.Add("@salesMasterId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.SalesMasterId; sprmparam24 = sccmd.Parameters.Add("@salesAccount", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.SalesAccount; sprmparam24 = sccmd.Parameters.Add("@pricinglevelId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.PricinglevelId; sprmparam24 = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.EmployeeId; sprmparam24 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.Narration; sprmparam24 = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.ExchangeRateId; sprmparam24 = sccmd.Parameters.Add("@discount", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.Discount; sprmparam24 = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.TaxAmount; sprmparam24 = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.UserId; sprmparam24 = sccmd.Parameters.Add("@lrNo", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.LrNo; sprmparam24 = sccmd.Parameters.Add("@transportationCompany", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.TransportationCompany; sprmparam24 = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam24.Value = salesreturnmasterinfo.Date; sprmparam24 = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.TotalAmount; sprmparam24 = sccmd.Parameters.Add("@grandTotal", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.grandTotal; sprmparam24 = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam24.Value = salesreturnmasterinfo.FinancialYearId; sprmparam24 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.Extra1; sprmparam24 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam24.Value = salesreturnmasterinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }