コード例 #1
0
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        if (healthCenterId != null)
        {
            vaccineId       = Page.Request.QueryString["vaccineId"].ToString();
            txtVaccine.Text = Dose.GetDoseById(int.Parse(vaccineId)).Fullname;

            //fromdate = DateTime.Parse(HttpContext.Current.Session["fromdate"].ToString());
            //todate = DateTime.Parse(HttpContext.Current.Session["todate"].ToString());
            //enddate = DateTime.Parse(HttpContext.Current.Session["enddate"].ToString());

            string s = HealthFacility.GetAllChildsForOneHealthFacility(int.Parse(healthCenterId));
            string where = string.Format(" AND (\"HEALTHCENTER_ID\" in ({0})) ", s);

            where += String.Format(@" AND ""DOSE_ID"" = {0} AND ""BIRTHDATE"" between '{1}' and '{2}' AND ""VACCINATION_DATE"" between '{1}' and '{3}' ", vaccineId, fromdate.ToString("yyyy-MM-dd"), todate.ToString("yyyy-MM-dd"), enddate.ToString("yyyy-MM-dd"));

            odsChild.SelectParameters.Clear();
            odsChild.SelectParameters.Add("where", where);
            odsChild.DataBind();
            // HttpContext.Current.Session["hfId"] = healthCenterId;
            HttpContext.Current.Session["whereNotImmunized"] = where;
            Response.Redirect(Request.RawUrl);
        }
    }
コード例 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.Page.IsPostBack)
        {
            List <string> actionList        = null;
            string        sessionNameAction = "";
            if (CurrentEnvironment.LoggedUser != null)
            {
                sessionNameAction = "__GIS_actionList_" + CurrentEnvironment.LoggedUser.Id;
                actionList        = (List <string>)Session[sessionNameAction];
            }

            if ((actionList != null) && actionList.Contains("ViewDose") && (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["Dose-dictionary" + language];
                if (wtList == null)
                {
                    List <WordTranslate> wordTranslateList = WordTranslate.GetWordByLanguage(languageId, "Dose");
                    wtList = new Dictionary <string, string>();
                    foreach (WordTranslate vwt in wordTranslateList)
                    {
                        wtList.Add(vwt.Code, vwt.Name);
                    }
                    HttpContext.Current.Cache.Insert("Dose-dictionary" + language, wtList);
                }

                //controls
                this.lblScheduledVaccinationId.Text = wtList["DoseScheduledVaccination"];
                this.lblDoseNumber.Text             = wtList["DoseDoseNumber"];
                this.lblAgeDefinitionId.Text        = wtList["DoseAgeDefinition"];
                this.lblFullname.Text = wtList["DoseFullname"];
                this.lblNotes.Text    = wtList["DoseNotes"];
                this.lblIsActive.Text = wtList["DoseIsActive"];
                // this.lblFromAgeDef.Text = wtList["DoseFromAgeDefinition"];
                // this.lblToAgeDef.Text = wtList["DoseToAgeDefinition"];

                //grid header text
                gvDose.Columns[1].HeaderText = wtList["DoseFullname"];
                gvDose.Columns[2].HeaderText = wtList["DoseAgeDefinition"];
                gvDose.Columns[3].HeaderText = wtList["DoseScheduledVaccination"];
                gvDose.Columns[4].HeaderText = wtList["DoseDoseNumber"];
                gvDose.Columns[5].HeaderText = wtList["DoseNotes"];
                gvDose.Columns[6].HeaderText = wtList["DoseIsActive"];

                //actions
                this.btnAdd.Visible    = actionList.Contains("AddDose");
                this.btnEdit.Visible   = actionList.Contains("EditDose");
                this.btnRemove.Visible = actionList.Contains("RemoveDose");

                //buttons
                this.btnAdd.Text    = wtList["DoseAddButton"];
                this.btnEdit.Text   = wtList["DoseEditButton"];
                this.btnRemove.Text = wtList["DoseRemoveButton"];

                //message
                this.lblSuccess.Text = wtList["DoseSuccessText"];
                this.lblWarning.Text = wtList["DoseWarningText"];
                this.lblError.Text   = wtList["DoseErrorText"];

                //Page Title
                this.lblTitle.Text = wtList["DosePageTitle"];

                //validators
                cvDose.ErrorMessage = wtList["DoseMandatory"];
                // cvScheduledVaccination.ErrorMessage = wtList["DoseScheduledVaccinationValidator"];
                //cvAgeDefinition.ErrorMessage = wtList["DoseAgeDefinitionValidator"];

                //selected object
                int    id  = -1;
                string _id = Request.QueryString["id"];
                if (!String.IsNullOrEmpty(_id))
                {
                    int.TryParse(_id, out id);
                    Dose o = Dose.GetDoseById(id);
                    ddlScheduledVaccination.SelectedValue = o.ScheduledVaccinationId.ToString();
                    ddlAgeDefinition.SelectedValue        = o.AgeDefinitionId.ToString();
                    if (o.FromAgeDefinitionId > 0)
                    {
                        ddlFromAgeDef.SelectedValue = o.FromAgeDefinitionId.ToString();
                    }
                    if (o.ToAgeDefinitionId > 0)
                    {
                        ddlToAgeDef.SelectedValue = o.ToAgeDefinitionId.ToString();
                    }

                    txtDoseNumber.Text            = o.DoseNumber.ToString();
                    txtFullname.Text              = o.Fullname.ToString();
                    txtNotes.Text                 = o.Notes;
                    rblIsActive.Items[0].Selected = o.IsActive;
                    rblIsActive.Items[1].Selected = !o.IsActive;
                    gridview_Databind(id);
                    btnAdd.Visible = false;
                }
                else
                {
                    btnEdit.Visible   = false;
                    btnRemove.Visible = false;
                }
            }
            else
            {
                Response.Redirect("Default.aspx");
            }
        }
    }
コード例 #3
0
    protected void btnEdit_Click(object sender, EventArgs e)
    {
        try
        {
            if (Page.IsValid)
            {
                int    id  = -1;
                string _id = Request.QueryString["id"].ToString();
                int.TryParse(_id, out id);
                int userId = CurrentEnvironment.LoggedUser.Id;

                Dose o = Dose.GetDoseById(id);
                if (Exists(ddlScheduledVaccination.SelectedIndex, int.Parse(txtDoseNumber.Text)) && (o.ScheduledVaccinationId != int.Parse(ddlScheduledVaccination.SelectedValue)) && (o.DoseNumber != int.Parse(txtDoseNumber.Text)))
                {
                    return;
                }
                if (NameExists(txtFullname.Text.Replace("'", @"''")) && (o.Fullname != txtFullname.Text))
                {
                    return;
                }
                o.ScheduledVaccinationId = int.Parse(ddlScheduledVaccination.SelectedValue);
                o.AgeDefinitionId        = int.Parse(ddlAgeDefinition.SelectedValue);
                o.DoseNumber             = int.Parse(txtDoseNumber.Text);
                o.Fullname   = txtFullname.Text.Replace("'", @"''");
                o.Notes      = txtNotes.Text.Replace("'", @"''");
                o.IsActive   = bool.Parse(rblIsActive.SelectedValue);
                o.ModifiedOn = DateTime.Now;
                o.ModifiedBy = userId;
                if (ddlFromAgeDef.SelectedIndex > 0)
                {
                    o.FromAgeDefinitionId = int.Parse(ddlFromAgeDef.SelectedValue);
                }
                else
                {
                    o.FromAgeDefinitionId = null;
                }
                if (ddlToAgeDef.SelectedIndex > 0)
                {
                    o.ToAgeDefinitionId = int.Parse(ddlToAgeDef.SelectedValue);
                }
                else
                {
                    o.ToAgeDefinitionId = null;
                }

                int i = Dose.Update(o);

                if (i > 0)
                {
                    lblSuccess.Visible = true;
                    lblWarning.Visible = false;
                    lblError.Visible   = false;
                    gridview_Databind(id);
                    //ClearControls(this);
                }
                else
                {
                    lblSuccess.Visible = false;
                    lblWarning.Visible = false;
                    lblError.Visible   = true;
                }
            }
        }
        catch (Exception ex)
        {
            lblSuccess.Visible = false;
            lblWarning.Visible = false;
            lblError.Visible   = true;
        }
    }
コード例 #4
0
    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);
            }
        }
    }
コード例 #5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.Page.IsPostBack)
        {
            List <string> actionList        = null;
            string        sessionNameAction = "";
            if (CurrentEnvironment.LoggedUser != null)
            {
                sessionNameAction = "__GIS_actionList_" + CurrentEnvironment.LoggedUser.Id;
                actionList        = (List <string>)Session[sessionNameAction];
            }

            if ((CurrentEnvironment.LoggedUser != null)) //actionList.Contains("ViewNotImmunizedChildren") &&
            {
                int    userId     = CurrentEnvironment.LoggedUser.Id;
                string language   = CurrentEnvironment.Language;
                int    languageId = int.Parse(language);
                Dictionary <string, string> wtList = (Dictionary <string, string>)HttpContext.Current.Cache["Child-dictionary" + language];
                if (wtList == null)
                {
                    List <WordTranslate> wordTranslateList = WordTranslate.GetWordByLanguage(languageId, "Child");
                    wtList = new Dictionary <string, string>();
                    foreach (WordTranslate vwt in wordTranslateList)
                    {
                        wtList.Add(vwt.Code, vwt.Name);
                    }
                    HttpContext.Current.Cache.Insert("Child-dictionary" + language, wtList);
                }

                #region Person Configuration

                List <PersonConfiguration> pcList = PersonConfiguration.GetPersonConfigurationList();

                foreach (PersonConfiguration pc in pcList)
                {
                    if (pc.IsVisible == false)
                    {
                        //Control lbl = FindMyControl(this, "lbl" + pc.ColumnName);
                        //Control txt = FindMyControl(this, "txt" + pc.ColumnName);
                        ////Control rbl = FindMyControl(this, "rbl" + pc.ColumnName);
                        //Control tr = FindMyControl(this, "tr" + pc.ColumnName);

                        //if (lbl != null)
                        //    lbl.Visible = false;

                        //if (txt != null)
                        //    txt.Visible = false;

                        //if (rbl != null)
                        //    rbl.Visible = false;

                        //if (tr != null)
                        //    tr.Visible = false;

                        for (int i = 1; i < gvChild.Columns.Count; i++)
                        {
                            if (gvChild.Columns[i].HeaderText == pc.ColumnName)
                            {
                                gvChild.Columns[i].Visible = false;
                                break;
                            }
                        }
                    }
                }

                #endregion

                //controls
                #region Controls

                //this.lblHealthFacility.Text = wtList["ChildHealthcenter"];
                this.lblVaccine.Text = wtList["ChildVaccine"];
                this.lblTitle.Text   = wtList["ChildListNotImmunizedChildrenPageTitle"];
                // this.lblWarning.Text = wtList["ChildListNotImmunizedChildrenWarningText"];

                #endregion

                //grid header text
                #region Grid Columns
                gvChild.Columns[1].HeaderText  = wtList["ChildNonVaccinationReason"];
                gvChild.Columns[2].HeaderText  = wtList["ChildSystem"];
                gvChild.Columns[3].HeaderText  = wtList["ChildFirstname1"];
                gvChild.Columns[4].HeaderText  = wtList["ChildLastname1"];
                gvChild.Columns[5].HeaderText  = wtList["ChildMotherFirstname"];
                gvChild.Columns[6].HeaderText  = wtList["ChildMotherLastname"];
                gvChild.Columns[7].HeaderText  = wtList["ChildBirthdate"];
                gvChild.Columns[8].HeaderText  = wtList["ChildGender"];
                gvChild.Columns[9].HeaderText  = wtList["ChildHealthcenter"];
                gvChild.Columns[10].HeaderText = wtList["ChildDomicile"];

                gvExport.Columns[1].HeaderText  = wtList["ChildNonVaccinationReason"];
                gvExport.Columns[2].HeaderText  = wtList["ChildSystem"];
                gvExport.Columns[3].HeaderText  = wtList["ChildFirstname1"];
                gvExport.Columns[4].HeaderText  = wtList["ChildLastname1"];
                gvExport.Columns[5].HeaderText  = wtList["ChildMotherFirstname"];
                gvExport.Columns[6].HeaderText  = wtList["ChildMotherLastname"];
                gvExport.Columns[7].HeaderText  = wtList["ChildBirthdate"];
                gvExport.Columns[8].HeaderText  = wtList["ChildGender"];
                gvExport.Columns[9].HeaderText  = wtList["ChildHealthcenter"];
                gvExport.Columns[10].HeaderText = wtList["ChildBirthplace"];


                #endregion

                //buttons
                // this.btnSearch.Text = wtList["ChildSearchButton"];
                this.btnExcel.Text = wtList["ChildExcelButton"];
                this.btnPrint.Text = wtList["ChildPrintButton"];

                string _hfId = (string)Request.QueryString["hfId"];
                if (!String.IsNullOrEmpty(_hfId))
                {
                    healthCenterId = _hfId;
                }
                string _vaccineId = (string)Request.QueryString["vaccineId"];
                if (!String.IsNullOrEmpty(_vaccineId))
                {
                    vaccineId = _vaccineId;
                }
                txtVaccine.Text = Dose.GetDoseById(int.Parse(vaccineId)).Fullname;
                HttpContext.Current.Session["vaccine"] = txtVaccine.Text;

                string _planned = (string)Request.QueryString["planned"];
                if (!String.IsNullOrEmpty(_planned))
                {
                    planned = int.Parse(_planned);
                }

                string dateFormat = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString();

                fromdate = DateTime.ParseExact(HttpContext.Current.Session["fromdate"].ToString(), dateFormat, CultureInfo.CurrentCulture);
                todate   = DateTime.ParseExact(HttpContext.Current.Session["todate"].ToString(), dateFormat, CultureInfo.CurrentCulture);
                enddate  = DateTime.ParseExact(HttpContext.Current.Session["enddate"].ToString(), dateFormat, CultureInfo.CurrentCulture);

                string s = HealthFacility.GetAllChildsForOneHealthFacility(int.Parse(healthCenterId));
                string where = string.Format(" AND (\"HEALTHCENTER_ID\" in ({0})) ", s);

                if (planned == 1)
                {
                    where += String.Format(@" AND ""DOSE_ID"" = {0} AND ""SCHEDULED_DATE"" between '{1}' and '{2}' AND ""VACCINATION_DATE"" between '{1}' and '{3}' ", vaccineId, fromdate.ToString("yyyy-MM-dd"), todate.ToString("yyyy-MM-dd"), enddate.ToString("yyyy-MM-dd"));
                }
                else
                {
                    where += String.Format(@" AND ""DOSE_ID"" = {0} AND ""BIRTHDATE"" between '{1}' and '{2}' AND ""VACCINATION_DATE"" between '{1}' and '{3}' ", vaccineId, fromdate.ToString("yyyy-MM-dd"), todate.ToString("yyyy-MM-dd"), enddate.ToString("yyyy-MM-dd"));
                }

                odsChild.SelectParameters.Clear();
                odsChild.SelectParameters.Add("where", where);
                odsChild.DataBind();
                HttpContext.Current.Session["whereExcelNotImmunized"] = where; //use for excel

                if (HttpContext.Current.Session["whereNotImmunized"] != null)
                {
                    string swhere = HttpContext.Current.Session["whereNotImmunized"].ToString();
                    odsChild.SelectParameters.Clear();
                    odsChild.SelectParameters.Add("where", swhere);
                    odsChild.DataBind();
                    HttpContext.Current.Session["whereExcelNotImmunized"] = swhere;
                    HttpContext.Current.Session["whereNotImmunized"]      = null;
                }
            }
            else
            {
                Response.Redirect("Default.aspx");
            }
        }
    }