protected void btnReset_Click(object sender, EventArgs e)
{
SearchDoctorVisit itmsearch = new SearchDoctorVisit();
itmsearch.months = "'" + gmonth + "'";
itmsearch.divs = "'eva'";
FetchReportdata(itmsearch, 0);
populatedropdowns();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
populatedropdowns();
SearchDoctorVisit itmsearch = new SearchDoctorVisit();
itmsearch.months = "'" + gmonth + "'";
itmsearch.divs = "'eva'";
FetchReportdata(itmsearch, 1000);
}
}
protected void btnsearch_Click(object sender, EventArgs e)
{
String separator = "";
String monthsearch = "";
String divsearch = "";
string rsmsearch = "";
string distsearch = "";
string empsearch = "";
string desigsearch = "";
string asmsearch = "";
string msrsearch = "";
foreach (ListItem itm in src_month4m.Items)
{
if (itm.Selected)
{
monthsearch = monthsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_div.Items)
{
if (itm.Selected)
{
divsearch = divsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_rsm.Items)
{
if (itm.Selected)
{
rsmsearch = rsmsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_district.Items)
{
if (itm.Selected)
{
distsearch = distsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_employee.Items)
{
if (itm.Selected)
{
empsearch = empsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_designation.Items)
{
if (itm.Selected)
{
desigsearch = desigsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_asm.Items)
{
if (itm.Selected)
{
asmsearch = asmsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
separator = "";
foreach (ListItem itm in src_mfso.Items)
{
if (itm.Selected)
{
msrsearch = msrsearch + separator + "'" + itm.Value + "'";
separator = ",";
}
}
SearchDoctorVisit itmsearch = new SearchDoctorVisit();
itmsearch.months = monthsearch;
itmsearch.divs = divsearch;
itmsearch.rsms = rsmsearch;
itmsearch.dists = distsearch;
itmsearch.emps = empsearch;
itmsearch.desigs = desigsearch;
itmsearch.asms = asmsearch;
itmsearch.msrs = msrsearch;
FetchReportdata(itmsearch, 0);
StaticData itmstat = (new RptDocVisitDL()).GetDropdownData(monthsearch);
src_rsm.DataSource = itmstat.lstrsm;
src_rsm.DataBind();
src_district.DataSource = itmstat.lstdistrict;
src_district.DataBind();
src_employee.DataSource = itmstat.lstemployee;
src_employee.DataBind();
src_designation.DataSource = itmstat.lstdesignation;
src_designation.DataBind();
src_asm.DataSource = itmstat.lstasm;
src_asm.DataBind();
src_mfso.DataSource = itmstat.lstmsr;
src_mfso.DataBind();
}
private void FetchReportdata(SearchDoctorVisit searchdoctorvisit, int rows)
{
DataSet ds = (new RptDocVisitDL()).GetDoctorVisitReportDataDynamic(searchdoctorvisit, rows);
//manage headers as per division
String disthead = "";
if (searchdoctorvisit.divs.ToLower().Contains("eva") || searchdoctorvisit.divs.ToLower().Contains("concord"))
{
disthead = "MFSO";
}
if (searchdoctorvisit.divs.ToLower().Contains("phoenix"))
{
if (disthead != "")
{
disthead = disthead + "_SO";
}
else
{
disthead = "SO";
}
}
if (searchdoctorvisit.divs.ToLower().Contains("mad"))
{
if (disthead != "")
{
disthead = disthead + "_MSR";
}
else
{
disthead = "MSR";
}
}
if (disthead != "")
{
disthead = disthead + "_HQ";
}
else
{
disthead = "MFSO_HQ";
}
ds.Tables[0].Columns["District"].ColumnName = disthead;
ds.Tables[0].Columns["AsmHQ"].ColumnName = "ASM_DSO_HQ";
ds.Tables[0].Columns.Remove("rptdoctorvisitID");
foreach (DataColumn col in ds.Tables[0].Columns)
{
col.ColumnName = col.ColumnName.ToUpper();
}
rpt_docvisit.ReportTitle = "Doctor Visit Report";
rpt_docvisit.ReportName = "DoctorVisitReport";
rpt_docvisit.DataBind(ds.Tables[0].Copy());
rpt_docvisit.Visible = true;
Session["tab"] = ds.Tables[0];
}
public DataSet GetDoctorVisitReportDataDynamic(SearchDoctorVisit itmsearch, int rows)
{
RptAgeingList lstAgeing = new RptAgeingList();
Common.OpenConnection();
String sql = "select * from rpt_doctorvisit";
if (rows > 0)
{
sql = "select top " + rows + " * from rpt_doctorvisit";
}
string whsql = "";
string strconcat = "";
if (itmsearch.months != null && itmsearch.months != "")
{
whsql = whsql + strconcat + " month in (" + itmsearch.months + ")";
strconcat = " and ";
}
if (itmsearch.divs != null && itmsearch.divs != "" && itmsearch.divs != "select")
{
whsql = whsql + strconcat + " division in(" + itmsearch.divs + ")";
strconcat = " and ";
}
if (itmsearch.rsms != null && itmsearch.rsms != "" && itmsearch.rsms != "select")
{
whsql = whsql + strconcat + " RSMHQ in (" + itmsearch.rsms + ")";
strconcat = " and ";
}
if (itmsearch.dists != null && itmsearch.dists != "" && itmsearch.dists != "select")
{
whsql = whsql + strconcat + " Area in (" + itmsearch.dists + ")";
strconcat = " and ";
}
if (itmsearch.emps != null && itmsearch.emps != "" && itmsearch.emps != "select")
{
whsql = whsql + strconcat + " EmpName in (" + itmsearch.emps + ")";
strconcat = " and ";
}
if (itmsearch.desigs != null && itmsearch.desigs != "" && itmsearch.desigs != "select")
{
whsql = whsql + strconcat + " Designation in (" + itmsearch.desigs + ")";
strconcat = " and ";
}
if (itmsearch.asms != null && itmsearch.asms != "" && itmsearch.asms != "select")
{
whsql = whsql + strconcat + " AsmHQ in (" + itmsearch.asms + ")";
strconcat = " and ";
}
if (itmsearch.msrs != null && itmsearch.msrs != "" && itmsearch.msrs != "select")
{
whsql = whsql + strconcat + " MFSOHQ in (" + itmsearch.msrs + ")";
strconcat = " and ";
}
if (whsql != null && whsql != "")
{
sql = sql + " where " + whsql;
}
SqlCommand cmd = new SqlCommand(sql, Common.conn);
DataSet dsCustomers = new DataSet();
using (SqlDataAdapter sda = new SqlDataAdapter())
{
sda.SelectCommand = cmd;
//sda.Fill(dsCustomers, "rpt_ageing");
sda.Fill(dsCustomers);
}
Common.CloseConnection();
return(dsCustomers);
}
