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 LoadBillDetails()
{
BusinessLayer.Common.MemberBill objMemberBill = new BusinessLayer.Common.MemberBill();
DataTable dt = objMemberBill.MemberMonthlyDevelopmentBill(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 = "N/A";//(Convert.ToDecimal(dt.Rows[0]["FinalAmount"]) * 18 / 100).ToString(".00");
lblTotal.Text = dt.Rows[0]["FinalAmount"].ToString().ToUpper();
lblMonth.Text = dt.Rows[0]["Month"].ToString().ToUpper() + ", " + dt.Rows[0]["Year"].ToString().ToUpper();
lblTotalInWords.Text = dt.Rows[0]["FinalAmountInWords"].ToString().ToUpper();
}
}
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 = txtMemberName.Text.Trim();
//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.MemberMonthlyDevelopmentBill(StateId, DistrictId, BlockId, CategoryId, Month, year, MemberName, 0);
if (dt != null)
{
dgvMemberMonthlyBill.DataSource = dt;
dgvMemberMonthlyBill.DataBind();
}
}