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