/// <summary>
/// Function to get particular values from PurchaseMaster table based on the parameter
/// </summary>
/// <param name="purchaseMasterId"></param>
/// <returns></returns>
public PurchaseMasterInfo PurchaseMasterView(Decimal purchaseMasterId)
{
PurchaseMasterInfo purchasemasterinfo = new PurchaseMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("PurchaseMasterView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@purchaseMasterId", SqlDbType.Decimal);
sprmparam.Value = purchaseMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
purchasemasterinfo.PurchaseMasterId = decimal.Parse(sdrreader[0].ToString());
purchasemasterinfo.VoucherNo = sdrreader[1].ToString();
purchasemasterinfo.InvoiceNo = sdrreader[2].ToString();
purchasemasterinfo.SuffixPrefixId = decimal.Parse(sdrreader[3].ToString());
purchasemasterinfo.VoucherTypeId = decimal.Parse(sdrreader[4].ToString());
purchasemasterinfo.Date = DateTime.Parse(sdrreader[5].ToString());
purchasemasterinfo.LedgerId = decimal.Parse(sdrreader[6].ToString());
purchasemasterinfo.VendorInvoiceNo = sdrreader[7].ToString();
purchasemasterinfo.VendorInvoiceDate = DateTime.Parse(sdrreader[8].ToString());
purchasemasterinfo.CreditPeriod = sdrreader[9].ToString();
purchasemasterinfo.ExchangeRateId = decimal.Parse(sdrreader[10].ToString());
purchasemasterinfo.Narration = sdrreader[11].ToString();
purchasemasterinfo.PurchaseAccount = decimal.Parse(sdrreader[12].ToString());
purchasemasterinfo.PurchaseOrderMasterId = decimal.Parse(sdrreader[13].ToString());
purchasemasterinfo.MaterialReceiptMasterId = decimal.Parse(sdrreader[14].ToString());
purchasemasterinfo.AdditionalCost = decimal.Parse(sdrreader[15].ToString());
purchasemasterinfo.TotalTax = decimal.Parse(sdrreader[16].ToString());
purchasemasterinfo.BillDiscount = decimal.Parse(sdrreader[17].ToString());
purchasemasterinfo.GrandTotal = decimal.Parse(sdrreader[18].ToString());
purchasemasterinfo.TotalAmount = decimal.Parse(sdrreader[19].ToString());
purchasemasterinfo.UserId = decimal.Parse(sdrreader[20].ToString());
purchasemasterinfo.LrNo = sdrreader[21].ToString();
purchasemasterinfo.TransportationCompany = sdrreader[22].ToString();
purchasemasterinfo.FinancialYearId = decimal.Parse(sdrreader[23].ToString());
purchasemasterinfo.ExtraDate = DateTime.Parse(sdrreader[24].ToString());
purchasemasterinfo.Extra1 = sdrreader[25].ToString();
purchasemasterinfo.Extra2 = sdrreader[26].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(purchasemasterinfo);
}
/// <summary>
/// Function to insert values to PurchaseMaster Table
/// </summary>
/// <param name="purchasemasterinfo"></param>
/// <returns></returns>
public decimal PurchaseMasterAdd(PurchaseMasterInfo purchasemasterinfo)
{
decimal decPurchaseMasterId = 0;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("PurchaseMasterAdd", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.VoucherNo;
sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.InvoiceNo;
sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.SuffixPrefixId;
sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.VoucherTypeId;
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = purchasemasterinfo.Date;
sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.LedgerId;
sprmparam = sccmd.Parameters.Add("@vendorInvoiceNo", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.VendorInvoiceNo;
sprmparam = sccmd.Parameters.Add("@vendorInvoiceDate", SqlDbType.DateTime);
sprmparam.Value = purchasemasterinfo.VendorInvoiceDate;
sprmparam = sccmd.Parameters.Add("@creditPeriod", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.CreditPeriod;
sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.ExchangeRateId;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.Narration;
sprmparam = sccmd.Parameters.Add("@purchaseAccount", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.PurchaseAccount;
sprmparam = sccmd.Parameters.Add("@purchaseOrderMasterId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.PurchaseOrderMasterId;
sprmparam = sccmd.Parameters.Add("@materialReceiptMasterId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.MaterialReceiptMasterId;
sprmparam = sccmd.Parameters.Add("@additionalCost", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.AdditionalCost;
sprmparam = sccmd.Parameters.Add("@totalTax", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.TotalTax;
sprmparam = sccmd.Parameters.Add("@billDiscount", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.BillDiscount;
sprmparam = sccmd.Parameters.Add("@grandTotal", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.GrandTotal;
sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.TotalAmount;
sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.UserId;
sprmparam = sccmd.Parameters.Add("@lrNo", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.LrNo;
sprmparam = sccmd.Parameters.Add("@transportationCompany", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.TransportationCompany;
sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal);
sprmparam.Value = purchasemasterinfo.FinancialYearId;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = purchasemasterinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = purchasemasterinfo.Extra2;
decPurchaseMasterId = Convert.ToDecimal(sccmd.ExecuteScalar());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return(decPurchaseMasterId);
}