protected void dgvPaymentReport_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BusinessLayer.Common.SMSPayment ObjSMSPayment = new BusinessLayer.Common.SMSPayment();
int Id = Convert.ToInt32(dgvPaymentReport.DataKeys[e.RowIndex].Values["PaymentId"].ToString());
ObjSMSPayment.Delete(Id);
BindUploadList();
ShowMessage("Payment detail deleted successfully", true);
}
protected void dgvPaymentReport_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
BusinessLayer.Common.SMSPayment ObjSMSPayment = new BusinessLayer.Common.SMSPayment();
int Id = Convert.ToInt32(dgvPaymentReport.DataKeys[e.RowIndex].Values["PaymentId"].ToString());
ObjSMSPayment.Delete(Id);
LoadPaymentList();
Message.IsSuccess = true;
Message.Text = "Payment Deleted";
Message.Show = true;
}
protected void dgvPaymentReport_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Approve"))
{
BusinessLayer.Common.SMSPayment ObjSMSPayment = new BusinessLayer.Common.SMSPayment();
ObjSMSPayment.Approve(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session["UserId"].ToString()));
LoadPaymentList();
Message.IsSuccess = true;
Message.Text = "Payment Approved";
Message.Show = true;
}
}
private void LoadPaymentList()
{
string PaymentNo = txtPaymentNo.Text.Trim();
string PaymentMode = ddlPaymentMode.SelectedValue;
int CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue);
int SMSMemberId = Convert.ToInt32(ddlSMSMember.SelectedValue);
DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]);
DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dt = objSMSPayment.GetAll(PaymentNo, CashBankLedgerId, PaymentMode, FromDate, ToDate, SMSMemberId);
DataView dv = new DataView(dt);
if (Session["UserType"].ToString().Equals("Agent"))
{
dv.RowFilter = "CreatedBy = " + Session["UserId"].ToString() + " AND CreatedByUserType = 'Agent'";
}
else if (Session["UserType"].ToString().Equals("Member"))
{
dv.RowFilter = "CreatedBy = " + Session["UserId"].ToString() + " AND CreatedByUserType = 'Member'";
}
dt = dv.ToTable();
decimal TotalAmount = 0, TotalFeesAmount = 0, TotalTaxAmount = 0;
dt.AsEnumerable().ToList().ForEach(row =>
{
TotalAmount += Convert.ToDecimal(row["PaymentAmount"].ToString());
TotalFeesAmount += Convert.ToDecimal(row["ReadyBirdPriceSMSAmount"].ToString()); // +Convert.ToDecimal(row["NECCRateSMSAmount"].ToString());
TotalTaxAmount += Convert.ToDecimal(row["ReadyBirdPriceSMSTaxAmount"].ToString()); // +Convert.ToDecimal(row["NECCRateSMSTaxAmount"].ToString());
});
dgvPaymentReport.DataSource = dt;
dgvPaymentReport.DataBind();
if (dt.Rows.Count > 0)
{
dgvPaymentReport.FooterRow.Cells[7].Text = TotalFeesAmount.ToString("F2");
dgvPaymentReport.FooterRow.Cells[8].Text = TotalTaxAmount.ToString("F2");
dgvPaymentReport.FooterRow.Cells[9].Text = TotalAmount.ToString("F2");
btnDownload.Visible = true;
}
else
{
btnDownload.Visible = false;
}
}
protected void LoadReceipt(string VoucherNo)
{
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dt = objSMSPayment.GetAll(VoucherNo, 0, "All", DateTime.MinValue, DateTime.MinValue, 0);
if (dt != null)
{
lblSLNo.Text = VoucherNo.ToString().Split('/').Last();
lblDate.Text = Convert.ToDateTime(dt.Rows[0]["PaymentDate"]).ToString("dd/MM/yyyy");
lblMemberName.Text = dt.Rows[0]["MemberName"].ToString() + " / " + dt.Rows[0]["MobileNo"].ToString();
lblMessageRate.Text = dt.Rows[0]["ReadyBirdPriceSMSAmount"].ToString();
lblMessageTax.Text = dt.Rows[0]["ReadyBirdPriceSMSTaxAmount"].ToString();
lblMessageTotal.Text = Convert.ToDecimal(dt.Rows[0]["PaymentAmount"]).ToString();
lblPaymentMode.Text = dt.Rows[0]["PaymentMode"].ToString();
}
}
private void LoadSMSCategoryWiseDetail()
{
int SMSMemberId = Convert.ToInt32(ddlSMSMember.SelectedValue);
if (SMSMemberId != 0)
{
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dt = objSMSPayment.GetCategoryWiseDetail(SMSMemberId, PaymentId);
dgvSMS.DataSource = dt;
dgvSMS.DataBind();
}
else
{
dgvSMS.DataSource = null;
dgvSMS.DataBind();
}
}
private void LoadPaymentDetail()
{
BusinessLayer.Common.SMSPayment ObjSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dtPayment = ObjSMSPayment.GetAllById(PaymentId);
txtPaymentNo.Text = dtPayment.Rows[0]["PaymentNo"].ToString();
ddlSMSMember.SelectedValue = dtPayment.Rows[0]["SMSMemberId"].ToString();
ddlSMSMember.Enabled = false;
txtMobileNo.Enabled = false;
btnSearch.Enabled = false;
txtPaymentAmount.Text = dtPayment.Rows[0]["PaymentAmount"].ToString();
ddlPaymentMode.SelectedValue = dtPayment.Rows[0]["PaymentMode"].ToString();
txtPaymentDate.Text = Convert.ToDateTime(dtPayment.Rows[0]["PaymentDate"].ToString()).ToString("dd/MM/yyyy");
CalendarExtenderPaymentDate.Enabled = false;
txtSubscriptionEndDate.Text = Convert.ToDateTime(dtPayment.Rows[0]["SMSSubscriptionEndDate"].ToString()).ToString("dd/MM/yyyy");
ddlCashBankLedger.SelectedValue = dtPayment.Rows[0]["CashBankLedgerId"].ToString();
LoadLedgerOpeningBalance();
txtNarration.Text = dtPayment.Rows[0]["Narration"].ToString();
if (Session["UserType"].ToString().Equals("Admin"))
{
txtSubscriptionEndDate.Enabled = true;
}
else
{
txtSubscriptionEndDate.Enabled = false;
}
if (Session["UserType"].ToString().Equals("Agent") || Session["UserType"].ToString().Equals("Member"))
{
ddlPaymentMode.Enabled = false;
ddlCashBankLedger.Enabled = false;
}
else
{
ddlPaymentMode.Enabled = true;
ddlCashBankLedger.Enabled = true;
}
Message.Show = false;
}
protected void btnSearch_Click(object sender, EventArgs e)
{
int SMSCategoryId = Convert.ToInt32(ddlSMSCategory.SelectedValue);
DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]);
DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
BusinessLayer.Common.SMSPayment ObjSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dt = ObjSMSPayment.GetServiceTaxReport(SMSCategoryId, FromDate, ToDate);
dgvServiceTax.DataSource = dt;
dgvServiceTax.DataBind();
if (dt.Rows.Count > 0)
{
btnExport.Visible = true;
}
else
{
btnExport.Visible = false;
}
}
private void LoadPaymentList()
{
int AgentId = Convert.ToInt32(ddlAgent.SelectedValue);
DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]);
DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
bool?IsApproved = null;
if (ddlApprovalStatus.SelectedIndex == 1)
{
IsApproved = true;
}
else if (ddlApprovalStatus.SelectedIndex == 2)
{
IsApproved = false;
}
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dt = objSMSPayment.GetAgentWisePaymentReport(AgentId, FromDate, ToDate, IsApproved);
decimal TotalPaymentAmount = 0;
dt.AsEnumerable().ToList().ForEach(row =>
{
TotalPaymentAmount += Convert.ToDecimal(row["PaymentAmount"].ToString());
});
dgvPaymentReport.DataSource = dt;
dgvPaymentReport.DataBind();
if (dt.Rows.Count > 0)
{
dgvPaymentReport.FooterRow.Cells[6].Text = TotalPaymentAmount.ToString("F2");
btnDownload.Visible = true;
}
else
{
btnDownload.Visible = false;
}
}
private void BindUploadList()
{
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
DataTable dt = objSMSPayment.GetAll("", 0, "All", DateTime.MinValue, DateTime.MinValue, 0);
DataView dv = new DataView(dt);
dv.RowFilter = "IsExcelUpload = 'True'";
dtList = dv.ToTable();
dgvPaymentReport.DataSource = dtList;
dgvPaymentReport.DataBind();
BindFooter();
if (dtList.Rows.Count > 0)
{
btnDownload.Visible = true;
}
else
{
btnDownload.Visible = false;
}
}
private void Save(bool?IsApproved)
{
Message.Show = false;
FeesXml = "<NewDataSet>";
foreach (GridViewRow gvr in dgvSMS.Rows)
{
if (gvr.RowType == DataControlRowType.DataRow)
{
if (((CheckBox)gvr.FindControl("ChkSelect")).Checked)
{
FeesXml += "<Row";
FeesXml += " SMSCategoryId = \"" + dgvSMS.DataKeys[gvr.RowIndex].Values["SMSCategoryId"].ToString() + "\"";
FeesXml += " SMSAmount = \"" + gvr.Cells[2].Text + "\"";
//FeesXml += " TaxAmount = \"" + gvr.Cells[5].Text + "\"";
FeesXml += " TaxAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) + "\"";
FeesXml += " />";
}
}
}
FeesXml += "</NewDataSet>";
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
Entity.Common.SMSPayment payment = new Entity.Common.SMSPayment();
payment.PaymentId = PaymentId;
payment.SMSMemberId = Convert.ToInt32(ddlSMSMember.SelectedValue);
payment.PaymentMode = ddlPaymentMode.SelectedValue;
payment.PaymentDate = Convert.ToDateTime(txtPaymentDate.Text.Split('/')[2] + "-" + txtPaymentDate.Text.Split('/')[1] + "-" + txtPaymentDate.Text.Split('/')[0]);
payment.SMSEndDate = Convert.ToDateTime(txtSubscriptionEndDate.Text.Split('/')[2] + "-" + txtSubscriptionEndDate.Text.Split('/')[1] + "-" + txtSubscriptionEndDate.Text.Split('/')[0]);
payment.PaymentAmount = Convert.ToDecimal(txtPaymentAmount.Text.Trim());
payment.Narration = txtNarration.Text.Trim();
payment.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
payment.CreatedByUserType = Session["UserType"].ToString();
payment.CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue);
payment.FeesXml = FeesXml;
payment.IsExcelUpload = false;
if (IsApproved != null)
{
payment.IsApproved = true;
payment.ApprovedBy = Convert.ToInt32(Session["UserId"].ToString());
payment.ApprovedDate = DateTime.Now;
}
else
{
payment.IsApproved = null;
payment.ApprovedBy = null;
payment.ApprovedDate = null;
}
PaymentId = 0;
string strPaymentNo = objSMSPayment.Save(payment);
txtPaymentNo.Text = strPaymentNo;
LoadSMSCategoryWiseDetail();
txtPaymentAmount.Text = "0.00";
CalendarExtenderPaymentDate.Enabled = true;
txtNarration.Text = "";
LoadLedgerOpeningBalance();
Message.IsSuccess = true;
Message.Text = "Payment detail saved successfully";
Message.Show = true;
btnPrint.Visible = true;
if (Session["UserType"].ToString().Equals("Member") && ddlPaymentMode.SelectedItem.Text.ToUpper().Equals("ONLINE PAYMENT"))
{
Response.Redirect(@"https://www.onlinesbi.com/prelogin/icollecthome.htm?corpid=649959");
}
}
