public void BindGrid()
{
try
{
ReceiptPaymentBL objReceiptPaymentBL = new ReceiptPaymentBL();
ReceiptPaymentBO objReceiptPaymentBO = new ReceiptPaymentBO();
ApplicationResult objResultSelectAll = new ApplicationResult();
objResultSelectAll = objReceiptPaymentBL.ReceiptPayment_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]), Session[ApplicationSession.ACCOUNTFROMDATE].ToString(), Session[ApplicationSession.ACCOUNTTODATE].ToString(), "Payment");
if (objResultSelectAll != null)
{
DataTable dtSelectAll = new DataTable();
dtSelectAll = objResultSelectAll.resultDT;
gvPayments.DataSource = dtSelectAll;
gvPayments.DataBind();
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
ReceiptPaymentBL objReceiptPaymentBL = new ReceiptPaymentBL();
ReceiptPaymentBO objReceiptPaymentBO = new ReceiptPaymentBO();
ApplicationResult objResultInsert = new ApplicationResult();
ApplicationResult objResultUpdate = new ApplicationResult();
DataTable dtResult = new DataTable();
double dbSum = 0.0;
DateTime dtFromDate = Convert.ToDateTime(Session[ApplicationSession.ACCOUNTFROMDATE].ToString());
DateTime dtToDate = Convert.ToDateTime(Session[ApplicationSession.ACCOUNTTODATE].ToString());
DateTime dtCurrentDate = Convert.ToDateTime(txtDate.Text);
if (ViewState["Mode"].ToString() == "Save")
{
int intvalidate = 0;
for (int i = 0; i < gvPaymentsEntry.Rows.Count; i++)
{
string ddlVal = ((DropDownList)(gvPaymentsEntry.Rows[i].Cells[0].FindControl("ddlAccountName"))).SelectedItem.Value;
string strDebitAmt = ((TextBox)(gvPaymentsEntry.Rows[i].Cells[1].FindControl("txtDebitAmount"))).Text;
if (strDebitAmt != "")
{
if (ddlVal == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>");
return;
}
}
else
{
intvalidate = intvalidate + 1;
}
if (gvPaymentsEntry.Rows.Count == intvalidate)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>");
return;
}
}
if (txtDate.Text == "" || txtDate.Text == " ")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Date First.');</script>");
}
else if (ddlReceiptMode.SelectedValue == "-1" || ddlGeneralLedger.SelectedValue == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please select mode of Payment and General Ledger.');</script>");
}
else
{
objReceiptPaymentBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objReceiptPaymentBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objReceiptPaymentBO.ReceiptPaymentDate = dtCurrentDate.ToShortDateString();
objReceiptPaymentBO.Year = Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]);
objReceiptPaymentBO.TransactionType = "Payment";
objReceiptPaymentBO.GeneralLedger = Convert.ToInt32(ddlGeneralLedger.SelectedValue);
objReceiptPaymentBO.Narration = txtNarration.Text;
objReceiptPaymentBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objReceiptPaymentBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy");
objReceiptPaymentBO.IsDeleted = 0;
objReceiptPaymentBO.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy");
objReceiptPaymentBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
if (dtFromDate <= dtCurrentDate && dtCurrentDate <= dtToDate)
{
if (ddlReceiptMode.SelectedValue == "Cash")
{
objReceiptPaymentBO.TransactionMode = "Cash";
}
else if (ddlReceiptMode.SelectedValue == "Bank" || ddlReceiptMode.SelectedValue == "ODCC")
{
objReceiptPaymentBO.TransactionMode = ddlReceiptMode.SelectedValue;
if (txtChequeNo.Text.Length > 0)
{
objReceiptPaymentBO.ChequeNo = Convert.ToInt32(txtChequeNo.Text);
}
}
for (int j = 0; j < gvPaymentsEntry.Rows.Count; j++)
{
GridViewRow row = gvPaymentsEntry.Rows[j];
TextBox txtCrAmount = (TextBox)row.FindControl("txtDebitAmount");
DropDownList ddlAccName = (DropDownList)row.FindControl("ddlAccountName");
if (txtCrAmount.Text == "" && ddlAccName.SelectedValue == "-1")
{
continue;
}
else if (txtCrAmount.Text == "" || ddlAccName.SelectedValue == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Account Name or Amount');</script>");
break;
}
else
{
objReceiptPaymentBO.LedgerID = Convert.ToInt32(ddlAccName.SelectedValue);
dbSum = Convert.ToDouble(txtCrAmount.Text);
objReceiptPaymentBO.Amount = dbSum;
}
objResultInsert = objReceiptPaymentBL.ReceiptPayment_Insert(objReceiptPaymentBO);
if (j == 0)
{
if (objResultInsert != null)
{
dtResult = objResultInsert.resultDT;
if (dtResult.Rows.Count > 0)
{
if (dtResult.Rows[0][0].ToString() == "0")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Initialize Receipt Start No. For This Year.');</script>");
goto Exit;
}
else
{
ViewState["ReceiptNo"] = Convert.ToInt32(dtResult.Rows[0][0]);
ViewState["ReceiptCode"] = dtResult.Rows[0][1].ToString();
objReceiptPaymentBO.ReceiptPaymentNo = Convert.ToInt32(ViewState["ReceiptNo"]);
objReceiptPaymentBO.ReceiptPaymentCode = ViewState["ReceiptCode"].ToString();
}
}
}
}
else
{
objReceiptPaymentBO.ReceiptPaymentNo = Convert.ToInt32(ViewState["ReceiptNo"]);
objReceiptPaymentBO.ReceiptPaymentCode = ViewState["ReceiptCode"].ToString();
}
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Payment Saved Successfully. Payment No is " + ViewState["ReceiptCode"].ToString() + "');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Date according to your Accounting Period.');</script>");
}
}
BindGrid();
clear();
PanelVisibility(1);
}
else
{
int intvalidate = 0;
for (int i = 0; i < gvPaymentsEntry.Rows.Count; i++)
{
string ddlVal = ((DropDownList)(gvPaymentsEntry.Rows[i].Cells[0].FindControl("ddlAccountName"))).SelectedItem.Value;
string strDebitAmt = ((TextBox)(gvPaymentsEntry.Rows[i].Cells[1].FindControl("txtDebitAmount"))).Text;
if (strDebitAmt != "")
{
if (ddlVal == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>");
return;
}
}
else
{
intvalidate = intvalidate + 1;
}
if (gvPaymentsEntry.Rows.Count == intvalidate)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>");
return;
}
}
ApplicationResult objResultDelete = new ApplicationResult();
if (txtDate.Text == "" || txtDate.Text == " ")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Select Date First.');</script>");
}
else if (ddlReceiptMode.SelectedValue == "-1" || ddlGeneralLedger.SelectedValue == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Please select mode of Payment and General Ledger.');</script>");
}
else
{
objReceiptPaymentBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objReceiptPaymentBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objReceiptPaymentBO.ReceiptPaymentDate = dtCurrentDate.ToShortDateString();
objReceiptPaymentBO.Year = Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]);
objReceiptPaymentBO.TransactionType = "Payment";
objReceiptPaymentBO.GeneralLedger = Convert.ToInt32(ddlGeneralLedger.SelectedValue);
objReceiptPaymentBO.Narration = txtNarration.Text;
objReceiptPaymentBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objReceiptPaymentBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy");
objReceiptPaymentBO.IsDeleted = 0;
objReceiptPaymentBO.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy");
objReceiptPaymentBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objReceiptPaymentBO.ReceiptPaymentNo =
Convert.ToInt32(txtVoucherCode.Text.Substring(6, txtVoucherCode.Text.Length - 6));
;
objReceiptPaymentBO.ReceiptPaymentCode = txtVoucherCode.Text;
if (dtFromDate <= dtCurrentDate && dtCurrentDate <= dtToDate)
{
if (ddlReceiptMode.SelectedValue == "Cash")
{
objReceiptPaymentBO.TransactionMode = "Cash";
}
else if (ddlReceiptMode.SelectedValue == "Bank" || ddlReceiptMode.SelectedValue == "ODCC")
{
objReceiptPaymentBO.TransactionMode = ddlReceiptMode.SelectedValue;
if (txtChequeNo.Text.Length > 0)
{
objReceiptPaymentBO.ChequeNo = Convert.ToInt32(txtChequeNo.Text);
}
}
DatabaseTransaction.OpenConnectionTransation();
objResultDelete = objReceiptPaymentBL.ReceiptPayment_Delete_Transaction(txtVoucherCode.Text, "Payment");
for (int j = 0; j < gvPaymentsEntry.Rows.Count; j++)
{
GridViewRow row = gvPaymentsEntry.Rows[j];
TextBox txtCrAmount = (TextBox)row.FindControl("txtDebitAmount");
DropDownList ddlAccName = (DropDownList)row.FindControl("ddlAccountName");
if (txtCrAmount.Text == "" && ddlAccName.SelectedValue == "-1")
{
continue;
}
else if (txtCrAmount.Text == "" || ddlAccName.SelectedValue == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Select Account Name or Amount');</script>");
break;
}
else
{
objReceiptPaymentBO.LedgerID = Convert.ToInt32(ddlAccName.SelectedValue);
dbSum = Convert.ToDouble(txtCrAmount.Text);
objReceiptPaymentBO.Amount = dbSum;
}
objResultUpdate = objReceiptPaymentBL.ReceiptPayment_Update(objReceiptPaymentBO);
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Payment Updated Successfully. Receipt No is " + ViewState["ReceiptCode"].ToString() + "');</script>");
DatabaseTransaction.CommitTransation();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Select Date according to your Accounting Period.');</script>");
}
}
BindGrid();
clear();
PanelVisibility(1);
}
Exit :;
}
catch (Exception ex)
{
if (ViewState["Mode"].ToString() == "Edit")
{
DatabaseTransaction.RollbackTransation();
}
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
finally
{
DatabaseTransaction.connection.Close();
}
}
protected void gvPayments_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ReceiptPaymentBL objReceiptPaymentBL = new ReceiptPaymentBL();
ReceiptPaymentBO objReceiptPaymentBO = new ReceiptPaymentBO();
ApplicationResult objResultSelect = new ApplicationResult();
ViewState["ReceiptCode"] = e.CommandArgument.ToString();
if (e.CommandName.ToString() == "Edit1")
{
gvPayments.SelectedIndex = -1;
objResultSelect = objReceiptPaymentBL.ReceiptPayment_Select(ViewState["ReceiptCode"].ToString(), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect != null)
{
DataTable dtSelect = new DataTable();
dtSelect = objResultSelect.resultDT;
if (dtSelect.Rows.Count > 0)
{
ViewState["ReceiptRow"] = dtSelect.Rows.Count;
DataTable dt = new DataTable();
dt.Columns.Add("Number");
dt.Columns.Add("ReceiptPaymentID");
for (int i = 1; i <= Convert.ToInt32(ViewState["ReceiptRow"]); i++)
{
dt.Rows.Add(i.ToString(), "0");
}
ViewState["ADDRow"] = dt;
gvPaymentsEntry.DataSource = dt;
gvPaymentsEntry.DataBind();
BindAccountGroup();
txtDate.Text = dtSelect.Rows[0]["ReceiptPaymentDate"].ToString();
ddlReceiptMode.SelectedValue = dtSelect.Rows[0]["TransactionMode"].ToString();
ddlReceiptMode_SelectedIndexChanged(sender, e);
ddlGeneralLedger.SelectedValue = dtSelect.Rows[0]["GeneralLedger"].ToString();
txtVoucherCode.Text = ViewState["ReceiptCode"].ToString();
txtChequeNo.Text = dtSelect.Rows[0]["ChequeNo"].ToString();
txtNarration.Text = dtSelect.Rows[0]["Narration"].ToString();
for (int i = 0; i < dtSelect.Rows.Count; i++)
{
gvPaymentsEntry.Rows[i].Cells[0].Text = dtSelect.Rows[i][0].ToString();
((DropDownList)gvPaymentsEntry.Rows[i].Cells[1].FindControl("ddlAccountName")).SelectedValue = dtSelect.Rows[i]["LedgerID"].ToString();
((TextBox)gvPaymentsEntry.Rows[i].Cells[2].FindControl("txtDebitAmount")).Text = dtSelect.Rows[i]["Amount"].ToString();
}
PanelVisibility(2);
setControlScript();
getDebitCreditSum();
ViewState["Mode"] = "Edit";
fnOpeningBalance(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlGeneralLedger.SelectedValue), txtDate.Text);
}
}
}
else if (e.CommandName.ToString() == "Delete1")
{
ApplicationResult objResultDelete = new ApplicationResult();
objResultDelete = objReceiptPaymentBL.ReceiptPayment_Delete(e.CommandArgument.ToString(), "Payment");
if (objResultDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
BindGrid();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of ReceiptPayment in tbl_ReceiptPaymentDetail_M table
/// Created By : Viral, 10/22/2014
/// Modified By :
/// </summary>
/// <param name="objReceiptPaymentBO"></param>
/// <returns></returns>
public ApplicationResult ReceiptPayment_Update(ReceiptPaymentBO objReceiptPaymentBO)
{
try
{
pSqlParameter = new SqlParameter[20];
//pSqlParameter[0] = new SqlParameter("@ReceiptPaymentID",SqlDbType.Int);
//pSqlParameter[0].Direction = ParameterDirection.Input;
//pSqlParameter[0].Value = objReceiptPaymentBO.ReceiptPaymentID;
pSqlParameter[0] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objReceiptPaymentBO.TrustMID;
pSqlParameter[1] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objReceiptPaymentBO.SchoolMID;
pSqlParameter[2] = new SqlParameter("@ReceiptPaymentNo", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objReceiptPaymentBO.ReceiptPaymentNo;
pSqlParameter[3] = new SqlParameter("@ReceiptPaymentCode", SqlDbType.NVarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objReceiptPaymentBO.ReceiptPaymentCode;
pSqlParameter[4] = new SqlParameter("@ReceiptPaymentDate", SqlDbType.NVarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objReceiptPaymentBO.ReceiptPaymentDate;
pSqlParameter[5] = new SqlParameter("@Year", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objReceiptPaymentBO.Year;
pSqlParameter[6] = new SqlParameter("@TransactionMode", SqlDbType.NVarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objReceiptPaymentBO.TransactionMode;
pSqlParameter[7] = new SqlParameter("@TransactionType", SqlDbType.NVarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objReceiptPaymentBO.TransactionType;
pSqlParameter[8] = new SqlParameter("@GeneralLedger", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objReceiptPaymentBO.GeneralLedger;
pSqlParameter[9] = new SqlParameter("@LedgerID", SqlDbType.Int);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objReceiptPaymentBO.LedgerID;
pSqlParameter[10] = new SqlParameter("@Amount", SqlDbType.Float);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objReceiptPaymentBO.Amount;
pSqlParameter[11] = new SqlParameter("@BankName", SqlDbType.NVarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objReceiptPaymentBO.BankName;
pSqlParameter[12] = new SqlParameter("@BranchName", SqlDbType.NVarChar);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objReceiptPaymentBO.BranchName;
pSqlParameter[13] = new SqlParameter("@ChequeNo", SqlDbType.Int);
pSqlParameter[13].Direction = ParameterDirection.Input;
pSqlParameter[13].Value = objReceiptPaymentBO.ChequeNo;
pSqlParameter[14] = new SqlParameter("@Narration", SqlDbType.NChar);
pSqlParameter[14].Direction = ParameterDirection.Input;
pSqlParameter[14].Value = objReceiptPaymentBO.Narration;
pSqlParameter[15] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar);
pSqlParameter[15].Direction = ParameterDirection.Input;
pSqlParameter[15].Value = objReceiptPaymentBO.CreatedDate;
pSqlParameter[16] = new SqlParameter("@CreatedBy", SqlDbType.Int);
pSqlParameter[16].Direction = ParameterDirection.Input;
pSqlParameter[16].Value = objReceiptPaymentBO.CreatedBy;
pSqlParameter[17] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[17].Direction = ParameterDirection.Input;
pSqlParameter[17].Value = objReceiptPaymentBO.IsDeleted;
pSqlParameter[18] = new SqlParameter("@LastModifideUserID", SqlDbType.Int);
pSqlParameter[18].Direction = ParameterDirection.Input;
pSqlParameter[18].Value = objReceiptPaymentBO.LastModifideUserID;
pSqlParameter[19] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar);
pSqlParameter[19].Direction = ParameterDirection.Input;
pSqlParameter[19].Value = objReceiptPaymentBO.LastModifideDate;
sSql = "usp_tbl_ReceiptPaymentDetail_M_Update";
int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objReceiptPaymentBO = null;
}
}
