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); }