public decimal ReceiptMasterEdit(ReceiptMasterInfo receiptmasterinfo)
{
decimal decResult = 0;
try
{
decResult = spReceiptMaster.ReceiptMasterEdit(receiptmasterinfo);
}
catch (Exception)
{
throw;
}
return decResult;
}
public decimal ReceiptMasterAdd(ReceiptMasterInfo receiptmasterinfo)
{
decimal decRecieptMasterId = 0;
try
{
ReceiptMasterSP spReceiptMaster = new ReceiptMasterSP();
decRecieptMasterId = spReceiptMaster.ReceiptMasterAdd(receiptmasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("RD7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return decRecieptMasterId;
}
/// <summary>
/// Function to insert values to ReceiptMaster Table
/// </summary>
/// <param name="receiptmasterinfo"></param>
/// <returns></returns>
public decimal ReceiptMasterAdd(ReceiptMasterInfo receiptmasterinfo)
{
decimal decRecieptMasterId = 0;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ReceiptMasterAdd", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar);
sprmparam.Value = receiptmasterinfo.VoucherNo;
sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar);
sprmparam.Value = receiptmasterinfo.InvoiceNo;
sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal);
sprmparam.Value = receiptmasterinfo.SuffixPrefixId;
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = receiptmasterinfo.Date;
sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam.Value = receiptmasterinfo.LedgerId;
sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam.Value = receiptmasterinfo.TotalAmount;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = receiptmasterinfo.Narration;
sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal);
sprmparam.Value = receiptmasterinfo.VoucherTypeId;
sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal);
sprmparam.Value = receiptmasterinfo.UserId;
sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal);
sprmparam.Value = receiptmasterinfo.FinancialYearId;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = receiptmasterinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = receiptmasterinfo.Extra2;
decRecieptMasterId = Convert.ToDecimal(sccmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return decRecieptMasterId;
}
/// <summary>
/// Function to get particular values from eceiptMaster table based on the parameter
/// </summary>
/// <param name="decReceiptMastertId"></param>
/// <returns></returns>
public ReceiptMasterInfo ReceiptMasterViewByMasterId(decimal decReceiptMastertId)
{
ReceiptMasterInfo InfoReceiptMaster = new ReceiptMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ReceiptMasterViewByMasterId", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@receiptMasterId", SqlDbType.Decimal);
sprmparam.Value = decReceiptMastertId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
InfoReceiptMaster.VoucherNo = sdrreader["voucherNo"].ToString();
InfoReceiptMaster.InvoiceNo = sdrreader["invoiceNo"].ToString();
InfoReceiptMaster.SuffixPrefixId = decimal.Parse(sdrreader["suffixprefixId"].ToString());
InfoReceiptMaster.Date = DateTime.Parse(sdrreader["date"].ToString());
InfoReceiptMaster.LedgerId = decimal.Parse(sdrreader["ledgerId"].ToString());
InfoReceiptMaster.TotalAmount = decimal.Parse(sdrreader["totalAmount"].ToString());
InfoReceiptMaster.Narration = sdrreader["narration"].ToString();
InfoReceiptMaster.VoucherTypeId = decimal.Parse(sdrreader["voucherTypeId"].ToString());
InfoReceiptMaster.UserId = decimal.Parse(sdrreader["userId"].ToString());
InfoReceiptMaster.FinancialYearId = decimal.Parse(sdrreader["financialYearId"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return InfoReceiptMaster;
}
/// <summary>
/// Function to get particular values from ReceiptMaster table based on the parameter
/// </summary>
/// <param name="receiptMasterId"></param>
/// <returns></returns>
public ReceiptMasterInfo ReceiptMasterView(decimal receiptMasterId)
{
ReceiptMasterInfo receiptmasterinfo = new ReceiptMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ReceiptMasterView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@receiptMasterId", SqlDbType.Decimal);
sprmparam.Value = receiptMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
receiptmasterinfo.ReceiptMasterId = decimal.Parse(sdrreader[0].ToString());
receiptmasterinfo.VoucherNo = sdrreader[1].ToString();
receiptmasterinfo.InvoiceNo = sdrreader[2].ToString();
receiptmasterinfo.SuffixPrefixId = decimal.Parse(sdrreader[3].ToString());
receiptmasterinfo.Date = DateTime.Parse(sdrreader[4].ToString());
receiptmasterinfo.LedgerId = decimal.Parse(sdrreader[5].ToString());
receiptmasterinfo.TotalAmount = decimal.Parse(sdrreader[6].ToString());
receiptmasterinfo.Narration = sdrreader[7].ToString();
receiptmasterinfo.VoucherTypeId = decimal.Parse(sdrreader[8].ToString());
receiptmasterinfo.UserId = decimal.Parse(sdrreader[9].ToString());
receiptmasterinfo.FinancialYearId = decimal.Parse(sdrreader[10].ToString());
receiptmasterinfo.ExtraDate = DateTime.Parse(sdrreader[11].ToString());
receiptmasterinfo.Extra1 = sdrreader[12].ToString();
receiptmasterinfo.Extra2 = sdrreader[13].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return receiptmasterinfo;
}
public ReceiptMasterInfo ReceiptMasterViewByMasterId(decimal decReceiptMastertId)
{
ReceiptMasterInfo infoReceiptMaster = new ReceiptMasterInfo();
try
{
ReceiptMasterSP spReceiptMaster = new ReceiptMasterSP();
infoReceiptMaster = spReceiptMaster.ReceiptMasterViewByMasterId(decReceiptMastertId);
}
catch (Exception ex)
{
MessageBox.Show("RD11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return infoReceiptMaster;
}
