public static void UpdateReceipt(PMSReceiptDetailBO OPMSDetails, DataTable argdt)
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = "DELETE FROM dbo.PMSReceiptTrans WHERE ReceiptId=" + PMSReceiptDetailBO.ReceiptId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "UPDATE dbo.PMSReceiptRegister SET ReceiptDate='" + PMSReceiptDetailBO.ReceiptDate + "',ReceiptNo='" + PMSReceiptDetailBO.ReceiptNo + "'," +
" ChequeNo='" + PMSReceiptDetailBO.ChequeNo + "',ChequeDate='" + PMSReceiptDetailBO.ChequeDate + "',BankName='" + PMSReceiptDetailBO.BankName + "'," +
" PaymentMode='" + PMSReceiptDetailBO.PaymentMode + "',CostCentreId=" + PMSReceiptDetailBO.CostCentreId + ",FlatId=" + PMSReceiptDetailBO.FlatId + "," +
" PaidAmount=" + PMSReceiptDetailBO.Amount + ",Narration='" + PMSReceiptDetailBO.Narration + "' WHERE ReceiptId=" + PMSReceiptDetailBO.ReceiptId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
for (int i = 0; i < argdt.Rows.Count; i++)
{
sSql = "INSERT INTO dbo.PMSReceiptTrans(ReceiptId,MaintenanceId,MainTransId,NetAmount,PaidAmount)VALUES " +
" ('" + PMSReceiptDetailBO.ReceiptId + "'," + argdt.Rows[i]["MaintenanceId"] + "," + argdt.Rows[i]["TransId"] + "," +
" " + argdt.Rows[i]["NetAmount"] + "," + argdt.Rows[i]["CurrentAmount"] + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "UPDATE dbo.MaintenanceSchTrans SET PaidAmount=" + argdt.Rows[i]["CurrentAmount"] + " WHERE TransId=" + argdt.Rows[i]["TransId"] + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
tran.Commit();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
public void UpdateReceipt()
{
try
{
oRptBO = new PMSReceiptDetailBO();
PMSReceiptDetailBO.ReceiptId = ReceiptId;
PMSReceiptDetailBO.ReceiptDate = String.Format("{0:dd-MMM-yyyy}", dateReceipt.EditValue); //dateReceipt
PMSReceiptDetailBO.ReceiptNo = CommFun.IsNullCheck(textReceiptNo.Text, CommFun.datatypes.vartypestring).ToString(); //textReceiptNo
PMSReceiptDetailBO.ChequeNo = CommFun.IsNullCheck(textChequeNo.Text, CommFun.datatypes.vartypestring).ToString(); //textChequeNo
PMSReceiptDetailBO.ChequeDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dateCheque.EditValue, CommFun.datatypes.VarTypeDate)); // String.Format("{0:dd-MMM-yyyy}", dateCheque.Text);// dateCheque
PMSReceiptDetailBO.BankName = CommFun.IsNullCheck(textBankName.Text, CommFun.datatypes.vartypestring).ToString(); //textBankName
PMSReceiptDetailBO.CostCentreId = Convert.ToInt32(CommFun.IsNullCheck(cboCostCentre.EditValue, CommFun.datatypes.vartypenumeric));
PMSReceiptDetailBO.FlatId = Convert.ToInt32(CommFun.IsNullCheck(cboFlatNo.EditValue, CommFun.datatypes.vartypenumeric));
PMSReceiptDetailBO.PaymentMode = CommFun.IsNullCheck(cboMode.EditValue, CommFun.datatypes.vartypestring).ToString();
PMSReceiptDetailBO.Amount = Convert.ToDecimal(CommFun.IsNullCheck(gridViewReceipt.Columns["CurrentAmount"].SummaryText, CommFun.datatypes.vartypenumeric));//textAmt
PMSReceiptDetailBO.Narration = CommFun.IsNullCheck(txtNarration.Text, CommFun.datatypes.vartypestring).ToString();
if (ReceiptId == 0)
{
PMSReceiptBL.InsertReceipt(oRptBO, dtReceipt);
//ReceiptDetailBL.InsertReceiptDetails(oRptBO, dtReceipt, m_sBussinessType, dtRecp, dtInfo, dtReceiptType, dtQualifier, m_tQualAbs);
//CommFun.InsertLog(DateTime.Now, "Receipt Register-Add", "N", "Add ExtraItem Register", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.UpdateMaxNo(26, oVType, 0, 0);
}
else
{
if (Convert.ToDateTime(PMSReceiptDetailBO.ReceiptDate) != Convert.ToDateTime(dateReceipt.EditValue))
{
oVType = new BsfGlobal.VoucherType();
if (oVType.PeriodWise == true)
{
if (BsfGlobal.CheckPeriodChange(Convert.ToDateTime(PMSReceiptDetailBO.ReceiptDate), Convert.ToDateTime(dateReceipt.EditValue)) == true)
{
oVType = BsfGlobal.GetVoucherNo(26, Convert.ToDateTime(dateReceipt.EditValue), 0, 0);
textReceiptNo.Text = oVType.VoucherNo;
BsfGlobal.UpdateMaxNo(26, oVType, 0, 0);
}
}
}
PMSReceiptBL.UpdateReceipt(oRptBO, dtReceipt);
//ReceiptDetailBL.UpdateReceiptDetails(oRptBO, dtReceipt, m_sBussinessType, dtInfo, dtReceiptType, dtQualifier, m_tQualAbs);
//CommFun.InsertLog(DateTime.Now, "Receipt Register-Edit", "E", "Edit ExtraItem Register", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName);
}
}
catch (Exception e)
{
throw e;
}
}
public static void InsertReceipt(PMSReceiptDetailBO OPMSDetails, DataTable argdt)
{
int iRepId = 0;
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = "INSERT INTO dbo.PMSReceiptRegister(ReceiptDate,ReceiptNo,ChequeNo,ChequeDate,BankName,PaymentMode,CostCentreId,FlatId,PaidAmount,Narration)VALUES " +
" ('" + PMSReceiptDetailBO.ReceiptDate + "','" + PMSReceiptDetailBO.ReceiptNo + "','" + PMSReceiptDetailBO.ChequeNo + "'," +
" '" + PMSReceiptDetailBO.ChequeDate + "','" + PMSReceiptDetailBO.BankName + "','" + PMSReceiptDetailBO.PaymentMode + "'," +
" " + PMSReceiptDetailBO.CostCentreId + "," + PMSReceiptDetailBO.FlatId + "," + PMSReceiptDetailBO.Amount + ",'" + PMSReceiptDetailBO.Narration + "')SELECT SCOPE_IDENTITY()";
cmd = new SqlCommand(sSql, conn, tran);
iRepId = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
for (int i = 0; i < argdt.Rows.Count; i++)
{
sSql = "INSERT INTO dbo.PMSReceiptTrans(ReceiptId,MaintenanceId,MainTransId,NetAmount,PaidAmount)VALUES " +
" (" + iRepId + "," + argdt.Rows[i]["MaintenanceId"] + "," + argdt.Rows[i]["TransId"] + "," +
" " + argdt.Rows[i]["NetAmount"] + "," + argdt.Rows[i]["CurrentAmount"] + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "UPDATE dbo.MaintenanceSchTrans SET PaidAmount=" + argdt.Rows[i]["CurrentAmount"] + " WHERE TransId=" + argdt.Rows[i]["TransId"] + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
tran.Commit();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
public static void UpdateReceipt(PMSReceiptDetailBO OPMSDetails, DataTable argdt)
{
PMSReceiptDL.UpdateReceipt(OPMSDetails, argdt);
}
public static void InsertReceipt(PMSReceiptDetailBO OPMSDetails, DataTable argdt)
{
PMSReceiptDL.InsertReceipt(OPMSDetails, argdt);
}
