private void LoadMonthlyDevelopmentBill()
{
int StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
int BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
int CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
int Month = Convert.ToInt32(ddlMonth.SelectedValue);
int year = Convert.ToInt32(ddlYear.SelectedValue);
string MemberName = "";
BusinessLayer.Common.MemberBill objMemberBill = new BusinessLayer.Common.MemberBill();
DataTable dt = objMemberBill.MemberMonthlyDevelopmentBill(StateId, DistrictId, BlockId, CategoryId, Month, year, MemberName, 0);
if (dt != null)
{
dgvDevelopmentFee.DataSource = dt;
dgvDevelopmentFee.DataBind();
}
if (dt.Rows.Count > 0)
{
lblTotalMemberCount.Text = "Total Records: " + dt.Rows.Count.ToString();
btnSave.Visible = true;
}
else
{
btnSave.Visible = false;
}
}
public void MailToMember()
{
DateTime date = DateTime.Now.AddHours(12).AddMinutes(30);
int Month = date.Month;
int Year = date.Year;
BusinessLayer.Common.MemberBill objMemberBill = new BusinessLayer.Common.MemberBill();
DataTable dt = objMemberBill.MemberMonthlyDevelopmentBill(0, 0, 0, 0, Month, Year, "", 0);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string ToAddress = dt.Rows[i]["Email"].ToString();
string MobileNo = dt.Rows[i]["MobileNo"].ToString();
if (!string.IsNullOrEmpty(ToAddress))
{
string MessageContent = GetMessageContent(dt.Rows[i]);
SendEmail(ToAddress, MessageContent);
}
if (!string.IsNullOrEmpty(MobileNo))
{
string MessageContent = GetMobileMessageContent(dt.Rows[i]);
TriggerSMS(MobileNo, MessageContent);
}
}
}
}
protected void LoadMemberList()
{
string MemberName = txtMemberName.Text.Trim();
int StateId = Convert.ToInt32(ddlState.SelectedValue);
int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
int BlockId = Convert.ToInt32(ddlBlock.SelectedValue);
int MembershipCategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue);
BusinessLayer.Common.MemberBill objMember = new BusinessLayer.Common.MemberBill();
DataTable dt = objMember.RenewalAdjustmentDetails(MemberName, StateId, DistrictId, BlockId, MembershipCategoryId);
if (dt != null)
{
DataView dv = new DataView(dt);
dgvMemberMaster.DataSource = dv;
dgvMemberMaster.DataBind();
lblTotalMemberCount.Text = Server.HtmlDecode("<b>Total Member Count: " + dv.ToTable().Rows.Count.ToString() + "</b>");
}
if (dt.Rows.Count > 0)
{
btnDownload.Visible = true;
}
else
{
btnDownload.Visible = false;
}
}
protected void LoadDevelopmentFeeDetails()
{
int memberId = Convert.ToInt32(ddlMember.SelectedValue);
BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill();
DataTable dt = new DataTable();
dt = objBill.DevelopmentFeeBillGetAll(memberId);
if (dt != null)
{
dgvBill.DataSource = dt;
dgvBill.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill();
Entity.Common.MemberBill bill = new Entity.Common.MemberBill();
bill.Month = Convert.ToInt32(ddlMonth.SelectedValue);
bill.Year = Convert.ToInt32(ddlYear.SelectedValue);
bill.MemberId = Convert.ToInt32(ddlMember.SelectedValue);
bill.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
objBill.Generate(bill);
Message.IsSuccess = true;
Message.Text = "Bill Generated Successfully";
Message.Show = true;
}
protected void btnSave_Click(object sender, EventArgs e)
{
BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill();
Entity.Common.MemberBill bill = new Entity.Common.MemberBill();
bill.Month = Convert.ToInt32(ddlFromMonth.SelectedValue);
bill.MonthTo = Convert.ToInt32(ddlToMonth.SelectedValue);
bill.Year = Convert.ToInt32(ddlYear.SelectedValue);
bill.MemberId = Convert.ToInt32(ddlMember.SelectedValue);
bill.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
bill.Amount = Convert.ToInt32(txtAmount.Text);
//objBill.DevelopmentFeeGenerate(bill);
objBill.RenewalFeeUpdate(bill);
Message.IsSuccess = true;
Message.Text = "Bill Updated Successfully";
Message.Show = true;
//LoadDevelopmentFeeDetails();
}
private void LoadMonthlyBill()
{
int StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
int DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
int BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
int CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
int Month = Convert.ToInt32(ddlMonth.SelectedValue);
int year = Convert.ToInt32(ddlYear.SelectedValue);
string MemberName = "";
//DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
//DateTime FromDate = Convert.ToDateTime(txtFromDate.Text.Split('/')[2] + "-" + txtFromDate.Text.Split('/')[1] + "-" + txtFromDate.Text.Split('/')[0]);
BusinessLayer.Common.MemberBill objMemberBill = new BusinessLayer.Common.MemberBill();
DataTable dt = objMemberBill.MemberMonthlyBill(StateId, DistrictId, BlockId, CategoryId, Month, year, MemberName, 0);
dgvMemberMonthlyBill.DataSource = dt;
dgvMemberMonthlyBill.DataBind();
}
private void GoDevelopmentFeeGenerate()
{
DateTime dateTime = DateTime.Now.AddHours(12).AddMinutes(30);
Entity.Common.MemberBill bill = new Entity.Common.MemberBill();
bill.Month = dateTime.Month;
bill.Year = dateTime.Year;
bill.MemberId = 0;
bill.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); //Int32.Parse(Context.User.Identity.Name);
BusinessLayer.Common.MemberBill objBill = new BusinessLayer.Common.MemberBill();
bool IsGenerate = objBill.CheckingDevelopmentFeeGeneration(bill);
if (IsGenerate == false)
{
objBill.DevelopmentFeeGenerate(bill);
BusinessLayer.Common.FeeNotification notification = new BusinessLayer.Common.FeeNotification();
notification.MailToMember();
}
}
protected void LoadBillDetails()
{
BusinessLayer.Common.MemberBill objMemberBill = new BusinessLayer.Common.MemberBill();
DataTable dt = objMemberBill.MemberMonthlyBill(0, 0, 0, 0, 0, 0, "", BillId);
if (dt != null)
{
lblBillNo.Text = dt.Rows[0]["BillNo"].ToString().ToUpper();
lblBillDate.Text = "01/" + dt.Rows[0]["MonthNo"].ToString().ToUpper() + "/" + dt.Rows[0]["Year"].ToString().ToUpper();//DateTime.Now.Date.ToString("dd/MM/yyyy");
lblMemberName.Text = dt.Rows[0]["MemberName"].ToString();
lblAddress.Text = dt.Rows[0]["VillageOrStreet"].ToString().ToUpper() + "</br>" + dt.Rows[0]["DistrictName"].ToString().ToUpper() + ", " + dt.Rows[0]["PIN"].ToString().ToUpper();
lblMemberCode.Text = dt.Rows[0]["MemberCode"].ToString().ToUpper();
lblFinalAmount.Text = dt.Rows[0]["FinalAmount"].ToString().ToUpper();
lblMonthlyRate.Text = dt.Rows[0]["FinalAmount"].ToString().ToUpper();
// lblServiceTax.Text = (Convert.ToDecimal(dt.Rows[0]["FinalAmount"]) * 18 / 100).ToString(".00");
// lblTotal.Text = (Convert.ToDecimal(dt.Rows[0]["FinalAmount"]) + (Convert.ToDecimal(dt.Rows[0]["FinalAmount"]) * 18 / 100)).ToString(".00");
lblTotal.Text = (Convert.ToDecimal(dt.Rows[0]["FinalAmount"])).ToString(".00");
lblMonth.Text = dt.Rows[0]["Month"].ToString().ToUpper() + ", " + dt.Rows[0]["Year"].ToString().ToUpper();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgvDevelopmentFee.Rows.Count; i++)
{
GridViewRow row = dgvDevelopmentFee.Rows[i];
if (((CheckBox)row.FindControl("ChkSelect")).Checked)
{
int billId = Convert.ToInt32(dgvDevelopmentFee.DataKeys[i].Values[0]);
TextBox txtAmount = (TextBox)dgvDevelopmentFee.Rows[i].Cells[8].FindControl("txtBillAmount");
decimal Amount = (txtAmount.Text.Trim().Length > 0) ? Convert.ToDecimal(txtAmount.Text.Trim()) : 0;
BusinessLayer.Common.MemberBill objDevelopmentBill = new BusinessLayer.Common.MemberBill();
objDevelopmentBill.MonthlyDevelopmentBillUpdate(billId, Amount);
}
}
Message.IsSuccess = true;
Message.Text = "Development fee bill updated !!";
Message.Show = true;
LoadMonthlyDevelopmentBill();
}
protected void btnSave_Click(object sender, EventArgs e)
{
Message.Show = false;
FeesXml = "<NewDataSet>";
foreach (GridViewRow gvr in dgvMemberOutstanding.Rows)
{
if (gvr.RowType == DataControlRowType.DataRow)
{
FeesXml += "<Row";
FeesXml += " FeesHeadId = \"" + dgvMemberOutstanding.DataKeys[gvr.RowIndex].Values["FeesHeadId"].ToString() + "\"";
FeesXml += " FeesPaymentAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtFeesPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtFeesPaymentAmount")).Text.Trim()) + "\"";
FeesXml += " TaxPaymentAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) + "\"";
FeesXml += " />";
}
}
FeesXml += "</NewDataSet>";
BusinessLayer.Common.MemberBill objMemberBillAdjustment = new BusinessLayer.Common.MemberBill();
objMemberBillAdjustment.RenewalBillAdjustment(Convert.ToInt32(ddlMember.SelectedValue), Convert.ToInt32(Session["UserId"].ToString()), FeesXml);
LoadMemberOutstandingList();
Message.IsSuccess = true;
Message.Text = "Renewal fee is adjusted successfully";
Message.Show = true;
}
