protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
if (CurrentEnvironment.LoggedUser != null)
{
int userId = CurrentEnvironment.LoggedUser.Id;
string language = CurrentEnvironment.Language;
int languageId = int.Parse(language);
Dictionary <string, string> wtList = (Dictionary <string, string>)HttpContext.Current.Cache["CohortCoverageReport-dictionary" + language + language];
if (wtList == null)
{
List <WordTranslate> wordTranslateList = WordTranslate.GetWordByLanguage(languageId, "CohortCoverageReport");
wtList = new Dictionary <string, string>();
foreach (WordTranslate vwt in wordTranslateList)
{
wtList.Add(vwt.Code, vwt.Name);
}
HttpContext.Current.Cache.Insert("CohortCoverageReport-dictionary" + language + language, wtList);
}
//controls
this.lbFromDate.Text = wtList["CohortCoverageReportFromDate"];
this.lbToDate.Text = wtList["CohortCoverageReportToDate"];
this.lbEndDate.Text = wtList["CohortCoverageReportEndDate"];
this.lbVaccine.Text = wtList["CohortCoverageReportVaccine"];
this.lblTitle.Text = wtList["PrintCohortCoverageReportPageTitle"];
int hfId = CurrentEnvironment.LoggedUser.HealthFacilityId;
string _hfId = (string)Request.QueryString["hfId"];
if (!String.IsNullOrEmpty(_hfId))
{
int.TryParse(_hfId, out hfId);
}
string healthFacilityId = HealthFacility.GetAllChildsForOneHealthFacility(hfId);
lblFromDate.Text = HttpContext.Current.Session["fromdate"].ToString();
lblToDate.Text = HttpContext.Current.Session["todate"].ToString();
lblEndDate.Text = HttpContext.Current.Session["enddate"].ToString();
int vaccine = Helper.ConvertToInt(HttpContext.Current.Session["vaccineId"]);
int community = int.Parse(HttpContext.Current.Session["community"].ToString());
int domicile = int.Parse(HttpContext.Current.Session["domicile"].ToString());
if (vaccine != -1)
{
Dose o = Dose.GetDoseById(vaccine);
lblVaccine.Text = o.Fullname;
}
string dateFormat = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString();
DateTime datefrom = DateTime.ParseExact(lblFromDate.Text, dateFormat, CultureInfo.CurrentCulture);
DateTime dateto = DateTime.ParseExact(lblToDate.Text, dateFormat, CultureInfo.CurrentCulture);
DateTime dateend = DateTime.ParseExact(lblEndDate.Text, dateFormat, CultureInfo.CurrentCulture);
DataTable dt = CohortCoverage.GetCohortCoverage(languageId, healthFacilityId, datefrom, dateto, dateend, vaccine, community, domicile);
DataTable table = CreateDataTable(dt);
if (dt != null)
{
char[] stringSeparators = new char[] { ',' };
string[] result;
foreach (DataRow dr in dt.Rows)
{
result = dr[0].ToString().Replace(" ", "").Replace("(", "").Replace(")", "").Replace("\"", "").Split(stringSeparators);
CreateDataRow(result, table);
}
gvCohortCoverage.DataSource = table;
gvCohortCoverage.DataBind();
}
}
else
{
Response.Redirect("Default.aspx", false);
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (CurrentEnvironment.LoggedUser != null)
{
string dateFormat = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString();
DateTime datefrom = DateTime.ParseExact(txtFromDate.Text, dateFormat, CultureInfo.CurrentCulture);
DateTime dateto = DateTime.ParseExact(txtToDate.Text, dateFormat, CultureInfo.CurrentCulture);
DateTime dateend = DateTime.ParseExact(txtEndDate.Text, dateFormat, CultureInfo.CurrentCulture);
string language = CurrentEnvironment.Language;
int languageId = int.Parse(language);
int vaccineId = int.Parse(ddlVaccine.SelectedValue);
int community = 0;
int domicile = 0;
if (!String.IsNullOrEmpty(communityId))
{
community = int.Parse(communityId);
}
if (!String.IsNullOrEmpty(domicileId))
{
domicile = int.Parse(domicileId);
}
int hfId = CurrentEnvironment.LoggedUser.HealthFacilityId;
string _hfId = (string)Request.QueryString["hfId"];
if (!String.IsNullOrEmpty(_hfId))
{
int.TryParse(_hfId, out hfId);
}
string healthFacilityId = "1";
if (hfId != 1)
{
healthFacilityId = HealthFacility.GetAllChildsForOneHealthFacility(hfId, true);
}
HttpContext.Current.Session["fromdate"] = txtFromDate.Text;
HttpContext.Current.Session["todate"] = txtToDate.Text;
HttpContext.Current.Session["enddate"] = txtEndDate.Text;
HttpContext.Current.Session["vaccineId"] = vaccineId;
HttpContext.Current.Session["community"] = community;
HttpContext.Current.Session["domicile"] = domicile;
DataTable dt = CohortCoverage.GetCohortCoverage(languageId, healthFacilityId, datefrom, dateto, dateend, vaccineId, community, domicile);
DataTable table = CreateDataTable(dt);
if (dt != null)
{
char[] stringSeparators = new char[] { ',' };
string[] result;
foreach (DataRow dr in dt.Rows)
{
result = dr[0].ToString().Replace(" ", "").Replace("(", "").Replace(")", "").Replace("\"", "").Split(stringSeparators);
CreateDataRow(result, table);
}
gvCohortCoverage.DataSource = table;
gvCohortCoverage.DataBind();
string url = VaccineCoverageReportGrahpHelper.GetUrl(table, this.lblTitle.Text);
iCoverageReport.Text = String.Format("<img src='{0}' alt='' />", url.Replace(" ", ""));
}
}
}
