private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string strCond = "", Caste_Sel = "", Country_Sel = "", State_Sel = "";
if (rbtnFree.Checked)
{
strCond = " and dbo.isYetMember(MM.MemberCode, 0) <= 0 ";
}
else
{
strCond = " and dbo.isYetMember(MM.MemberCode, 0) > 0 ";
}
if (dtpFromDate.Value.ToShortDateString() != dtpToDate.Value.ToShortDateString())
{
strCond += " AND MS.StartDate BETWEEN '" + dtpFromDate.Value.ToString("dd/MMM/yyyy") + "' AND '" + dtpToDate.Value.ToString("dd/MMM/yyyy") + "'";
//strCond += " AND MM.RegisterDate BETWEEN '" + dtpFromDate.Value.ToString("dd/MMM/yyyy") + "' AND '" + dtpToDate.Value.ToString("dd/MMM/yyyy") + "'";
}
if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue))
{
strCond += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.SelectedValue + " AND " + ddlPAgeTo.SelectedValue + " ";
}
if (rbtnMale.Checked)
{
strCond += " AND MM.Gender=0 ";
}
else if (rbtnFemale.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 + ")";
}
Country_Sel = "";
for (int cnt = 0; cnt < LvwCountry.Items.Count; cnt++)
{
if (LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text != "-1")
{
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 + ")";
}
State_Sel = "";
for (int cnt = 0; cnt < LvwState.Items.Count; cnt++)
{
if (LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text != "-1")
{
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 + ")";
}
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_PAID_MEMBERSHIP(strCond);
if (dsdata.Tables[0].Rows.Count > 0)
{
frmReportViewer objReportViewer = new frmReportViewer();
ReportDocument cryRpt = new ReportDocument();
string strPath = "";
strPath = Application.StartupPath + @"\REPORTS\PaidMembership.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);
}
}
