public void FillGrid(string strCond, string AorB)
{
try
{
tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL();
DataSet dsdata = objtbl_MemberMasterBAL.GET_REGISTERED_MEMBER(strCond);
if (dsdata.Tables[0].Rows.Count > 0)
{
FieldLength = new int[] { 120, 0, 150, 0, 80, 0, 50, 0, 0 };
if (AorB == "A")
{
objGlobal.FillListView(LvwDetails_A, dsdata.Tables[0], FieldLength);
lblTotalCnt_A.Text = "Total : " + dsdata.Tables[0].Rows.Count;
}
else
{
objGlobal.FillListView(LvwDetails_B, dsdata.Tables[0], FieldLength);
lblTotalCnt_B.Text = "Total : " + dsdata.Tables[0].Rows.Count;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string strCond = "", Caste_Sel = "", Country_Sel = "", State_Sel = "", MaritalStatus_Sel = "";
if (rdbtnMale.Checked)
{
strCond += " AND MM.Gender=0 ";
}
else if (rdbtnFemale.Checked)
{
strCond += " AND MM.Gender=1 ";
}
for (int cnt = 0; cnt < LvwCaste.Items.Count; cnt++)
{
if (LvwCaste.Items[cnt].Checked)
{
if (Caste_Sel == "")
{
Caste_Sel = LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text;
}
else
{
Caste_Sel += "," + LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text;
}
}
}
if (Caste_Sel != "")
{
strCond += " AND MM.Caste in (" + Caste_Sel + ")";
}
if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue))
{
strCond += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.SelectedValue + " AND " + ddlPAgeTo.SelectedValue + " ";
}
for (int cnt = 1; cnt < LvwCountry.Items.Count; cnt++)
{
if (LvwCountry.Items[cnt].Checked)
{
if (Country_Sel == "")
{
Country_Sel = LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text;
}
else
{
Country_Sel += "," + LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text;
}
}
}
if (Country_Sel != "")
{
strCond += " AND MM.Country in (" + Country_Sel + ")";
}
for (int cnt = 1; cnt < LvwState.Items.Count; cnt++)
{
if (LvwState.Items[cnt].Checked)
{
if (State_Sel == "")
{
State_Sel = LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text;
}
else
{
State_Sel += "," + LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text;
}
}
}
if (State_Sel != "")
{
strCond += " AND MM.StateCity in (" + State_Sel + ")";
}
for (int cnt = 1; cnt < LvwMaritalStatus.Items.Count; cnt++)
{
if (LvwMaritalStatus.Items[cnt].Checked)
{
if (MaritalStatus_Sel == "")
{
MaritalStatus_Sel = LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text;
}
else
{
MaritalStatus_Sel += "," + LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text;
}
}
}
if (MaritalStatus_Sel != "")
{
strCond += " AND MM.MaritalStatus in (" + MaritalStatus_Sel + ")";
}
if (dtpFromDate.Value.ToShortDateString() != dtpToDate.Value.ToShortDateString())
{
strCond += " AND MM.RegisterDate BETWEEN '" + dtpFromDate.Value.ToString("dd/MMM/yyyy") + "' AND '" + dtpToDate.Value.ToString("dd/MMM/yyyy") + "'";
}
if (strCond == "")
{
MessageBox.Show("Please select Something", "Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL();
DataSet dsdata = objtbl_MemberMasterBAL.GET_REGISTERED_MEMBER(strCond);
if (dsdata.Tables[0].Rows.Count > 0)
{
frmReportViewer objReportViewer = new frmReportViewer();
ReportDocument cryRpt = new ReportDocument();
string strPath = "";
strPath = Application.StartupPath + @"\REPORTS\RegisterReport.rpt";
cryRpt.Load(strPath);
cryRpt.SetDataSource(dsdata.Tables[0]);
objReportViewer.RptViewer.ReportSource = cryRpt;
objReportViewer.RptViewer.Refresh();
objReportViewer.ShowDialog();
objReportViewer.Focus();
}
else
{
MessageBox.Show("No data found", "Data not found", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}