private void LoadConsolidatedOutstandingList()
{
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());
DateTime ToDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
DateTime FromDate = Convert.ToDateTime(txtToDate.Text.Split('/')[2] + "-" + txtToDate.Text.Split('/')[1] + "-" + txtToDate.Text.Split('/')[0]);
string MemberName = txtMemberName.Text.Trim();
string MemberCode = txtMemberCode.Text.Trim();
string MobileNo = txtMobileNo.Text.Trim();
BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment();
DataSet ds = objMemberPayment.GetOutstandingReportConsolidated(StateId, DistrictId, BlockId, CategoryId, ToDate, FromDate, MemberName, MemberCode, MobileNo, 0, 0);
dgvMemberOutstanding.DataSource = ds.Tables[0];
dgvMemberOutstanding.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
btnDownload.Visible = true;
}
else
{
btnDownload.Visible = false;
}
}
private void LoadConsolidatedOutstandingList()
{
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());
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]);
//string MemberName = txtMemberName.Text.Trim();
string MemberName = "";
int BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue); //14/10/19-business type fieldfor search
int ReportType = Convert.ToInt32(ddlReportType.SelectedValue.Trim());
BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment();
DataSet ds = objMemberPayment.GetOutstandingReportConsolidated(StateId, DistrictId, BlockId, CategoryId, ToDate, FromDate, MemberName, "", "", BusinessTypeId, ReportType);
dgvMemberOutstanding.DataSource = ds.Tables[0];
dgvMemberOutstanding.DataBind();
Label1.Text = ds.Tables[1].Rows[0]["GrandTotal"].ToString();
if (ds.Tables[0].Rows.Count > 0)
{
btnDownload.Visible = true;
btnSendEmail.Visible = true;
Label1.Text = "Grand Total : ";
Label2.Text = ds.Tables[1].Rows[0]["GrandTotal"].ToString();
}
else
{
btnDownload.Visible = false;
btnSendEmail.Visible = false;
Label1.Text = "Grand Total : ";
Label2.Text = "0.00";
}
}