protected void btnRemove_Click(object sender, EventArgs e) { try { int id = -1; string _id = Request.QueryString["id"].ToString(); int.TryParse(_id, out id); int userId = CurrentEnvironment.LoggedUser.Id; int i = ScheduledVaccination.Remove(id); if (i > 0) { lblSuccess.Visible = true; lblWarning.Visible = false; lblError.Visible = false; gridview_Databind(id); ClearControls(this); } else { lblSuccess.Visible = false; lblWarning.Visible = true; lblError.Visible = false; } } catch (Exception ex) { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } }
protected void btnExcel_Click(object sender, EventArgs e) { string name = ""; string code = ""; if (Session["ScheduledVaccinationList-Name"] != null) { name = Session["ScheduledVaccinationList-Name"].ToString(); } if (Session["ScheduledVaccinationList-Code"] != null) { code = Session["ScheduledVaccinationList-Code"].ToString(); } int maximumRows = int.MaxValue; int startRowIndex = 0; List <ScheduledVaccination> list = ScheduledVaccination.GetPagedScheduledVaccinationList(name, code, ref maximumRows, ref startRowIndex); gvExport.DataSource = list; gvExport.DataBind(); gvExport.Visible = true; if (list.Count >= 1) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=ScheduledVaccinationList.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/ms-excel"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); gvExport.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); gvExport.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { #region Validator //DateTime date = DateTime.ParseExact(txtEntryDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); //cvEntryDate.ControlToValidate = date; //cvEntryDate.ValueToCompare = DateTime.Today.ToString(ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat); #endregion if (!this.Page.IsPostBack) { Page.DataBind(); 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("ViewScheduledVaccination") && (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["ScheduledVaccination-dictionary" + language]; if (wtList == null) { List <WordTranslate> wordTranslateList = WordTranslate.GetWordByLanguage(languageId, "ScheduledVaccination"); wtList = new Dictionary <string, string>(); foreach (WordTranslate vwt in wordTranslateList) { wtList.Add(vwt.Code, vwt.Name); } HttpContext.Current.Cache.Insert("ScheduledVaccination-dictionary" + language, wtList); } //controls this.lblName.Text = wtList["ScheduledVaccinationName"]; this.lblCode.Text = wtList["ScheduledVaccinationCode"]; // this.lblHl7VaccineId.Text = wtList["ScheduledVaccinationHl7Vaccine"]; this.lblItemId.Text = wtList["ScheduledVaccinationItem"]; this.lblEntryDate.Text = wtList["ScheduledVaccinationEntryDate"]; this.lblExitDate.Text = wtList["ScheduledVaccinationExitDate"]; // this.lblStatus.Text = wtList["ScheduledVaccinationStatus"]; this.lblDeseases.Text = wtList["ScheduledVaccinationDeseases"]; this.lblNotes.Text = wtList["ScheduledVaccinationNotes"]; this.lblIsActive.Text = wtList["ScheduledVaccinationIsActive"]; this.rblIsActive.Items[0].Text = wtList["ScheduledVaccinationYes"]; this.rblIsActive.Items[1].Text = wtList["ScheduledVaccinationNo"]; //grid header text gvScheduledVaccination.Columns[1].HeaderText = wtList["ScheduledVaccinationName"]; gvScheduledVaccination.Columns[2].HeaderText = wtList["ScheduledVaccinationCode"]; // gvScheduledVaccination.Columns[3].HeaderText = wtList["ScheduledVaccinationHl7Vaccine"]; gvScheduledVaccination.Columns[3].HeaderText = wtList["ScheduledVaccinationItem"]; gvScheduledVaccination.Columns[4].HeaderText = wtList["ScheduledVaccinationEntryDate"]; gvScheduledVaccination.Columns[5].HeaderText = wtList["ScheduledVaccinationExitDate"]; gvScheduledVaccination.Columns[6].HeaderText = wtList["ScheduledVaccinationStatus"]; gvScheduledVaccination.Columns[7].HeaderText = wtList["ScheduledVaccinationDeseases"]; gvScheduledVaccination.Columns[8].HeaderText = wtList["ScheduledVaccinationNotes"]; gvScheduledVaccination.Columns[9].HeaderText = wtList["ScheduledVaccinationIsActive"]; //actions //this.btnAdd.Visible = actionList.Contains("AddScheduledVaccination"); //this.btnEdit.Visible = actionList.Contains("EditScheduledVaccination"); //this.btnRemove.Visible = actionList.Contains("RemoveScheduledVaccination"); //buttons this.btnAdd.Text = wtList["ScheduledVaccinationAddButton"]; this.btnEdit.Text = wtList["ScheduledVaccinationEditButton"]; this.btnRemove.Text = wtList["ScheduledVaccinationRemoveButton"]; //message this.lblSuccess.Text = wtList["ScheduledVaccinationSuccessText"]; this.lblWarning.Text = wtList["ScheduledVaccinationWarningText"]; this.lblError.Text = wtList["ScheduledVaccinationErrorText"]; //Page Title this.lblTitle.Text = wtList["ScheduledVaccinationPageTitle"]; //validators ceEntryDate.Format = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat; revEntryDate.ErrorMessage = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat; revEntryDate.ValidationExpression = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateExpresion; ceExitDate.Format = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat; revExitDate.ErrorMessage = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat; revExitDate.ValidationExpression = ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateExpresion; cvScheduledVaccination.ErrorMessage = wtList["ScheduledVaccinationMandatory"]; // cvItem.ErrorMessage = wtList["ScheduledVaccinationItemValidator"]; // cvtxtEntryDate.ErrorMessage = wtList["EntryDateValidator"]; //cvEntryDate.ErrorMessage = wtList["EntryDateFieldValidator"]; //selected object int id = -1; string _id = Request.QueryString["id"]; if (!String.IsNullOrEmpty(_id)) { int.TryParse(_id, out id); ScheduledVaccination o = ScheduledVaccination.GetScheduledVaccinationById(id); //ddlHl7Vaccine.SelectedValue = o.Hl7VaccineId.ToString(); ddlItem.SelectedValue = o.ItemId.ToString(); txtName.Text = o.Name.ToString(); txtCode.Text = o.Code.ToString(); txtNotes.Text = o.Notes; txtEntryDate.Text = o.EntryDate.ToString(ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString()); txtExitDate.Text = o.ExitDate.ToString(ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString()); if (o.ExitDate.ToString("yyyy-MM-dd").Equals("0001-01-01")) { txtExitDate.Text = String.Empty; } rblIsActive.Items[0].Selected = o.IsActive; rblIsActive.Items[1].Selected = !o.IsActive; txtDeseases.Text = o.Deseases; gridview_Databind(id); btnAdd.Visible = false; } else { btnEdit.Visible = false; btnRemove.Visible = false; } } else { Response.Redirect("Default.aspx"); } } }
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; ScheduledVaccination o = ScheduledVaccination.GetScheduledVaccinationById(id); o.Name = txtName.Text.Replace("'", @"''"); o.Code = txtCode.Text.Replace("'", @"''"); // o.Hl7VaccineId = int.Parse(ddlHl7Vaccine.SelectedValue); o.ItemId = int.Parse(ddlItem.SelectedValue); DateTime date = DateTime.ParseExact(txtEntryDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); o.EntryDate = date; if (txtExitDate.Text != String.Empty) { DateTime exitdate = DateTime.ParseExact(txtExitDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); o.ExitDate = exitdate; } else { o.ExitDate = DateTime.Parse("0001-01-01"); } // o.Status = bool.Parse(rblStatus.SelectedValue); o.Deseases = txtDeseases.Text.Replace("'", @"''"); o.Notes = txtNotes.Text.Replace("'", @"''"); o.IsActive = bool.Parse(rblIsActive.SelectedValue); o.ModifiedOn = DateTime.Now; o.ModifiedBy = userId; if (o.ExitDate < DateTime.Now) { o.Status = false; } else { o.Status = true; } int i = ScheduledVaccination.Update(o); if (i > 0) { lblSuccess.Visible = true; lblWarning.Visible = false; lblError.Visible = false; gridview_Databind(id); } else { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } } } catch (Exception ex) { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } }
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; Item o = Item.GetItemById(id); if (nameExists(txtName.Text.Replace("'", @"''")) && (o.Name != txtName.Text)) { return; } o.ItemCategoryId = int.Parse(ddlItemCategory.SelectedValue); if (ddlHl7Vaccine.SelectedIndex > 0) { o.Hl7VaccineId = int.Parse(ddlHl7Vaccine.SelectedValue); } else { o.Hl7VaccineId = null; } o.Name = txtName.Text.Replace("'", @"''"); o.Code = txtCode.Text.Replace("'", @"''"); DateTime date = DateTime.ParseExact(txtEntryDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); o.EntryDate = date; if (txtExitDate.Text != String.Empty) { DateTime exitdate = DateTime.ParseExact(txtExitDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); o.ExitDate = exitdate; if (o.ExitDate < DateTime.Today.Date) { o.IsActive = false; } } else { o.ExitDate = DateTime.Parse("0001-01-01"); o.IsActive = true; } o.Notes = txtNotes.Text; o.ModifiedOn = DateTime.Now; o.ModifiedBy = userId; int i = Item.Update(o); if (i > 0) { lblSuccess.Visible = true; lblWarning.Visible = false; lblError.Visible = false; gridview_Databind(id); if (o.ItemCategoryId == 1) { //add Scheduled Vaccination ScheduledVaccination sv = ScheduledVaccination.GetScheduledVaccinationByItemId(o.Id); if (sv != null) { sv.Name = o.Name; sv.Code = o.Code; sv.EntryDate = o.EntryDate; if (txtExitDate.Text != String.Empty) { sv.ExitDate = o.ExitDate; } sv.IsActive = o.IsActive; sv.Notes = o.Notes; sv.ModifiedOn = DateTime.Now; sv.ModifiedBy = userId; int j = ScheduledVaccination.Update(sv); // end } } } else { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } } } catch (Exception ex) { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } }
protected void btnAdd_Click(object sender, EventArgs e) { try { if (Page.IsValid) { int userId = CurrentEnvironment.LoggedUser.Id; if (nameExists(txtName.Text.Replace("'", @"''"))) { return; } Item o = new Item(); o.ItemCategoryId = int.Parse(ddlItemCategory.SelectedValue); if (ddlHl7Vaccine.SelectedIndex > 0) { o.Hl7VaccineId = int.Parse(ddlHl7Vaccine.SelectedValue); } o.Name = txtName.Text.Replace("'", @"''"); o.Code = txtCode.Text.Replace("'", @"''"); DateTime date = DateTime.ParseExact(txtEntryDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); o.EntryDate = date; if (txtExitDate.Text != String.Empty) { DateTime exitdate = DateTime.ParseExact(txtExitDate.Text, ConfigurationDate.GetConfigurationDateById(int.Parse(Configuration.GetConfigurationByName("DateFormat").Value)).DateFormat.ToString(), CultureInfo.CurrentCulture); o.ExitDate = exitdate; } o.IsActive = true;// bool.Parse(rblIsActive.SelectedValue); o.Notes = txtNotes.Text; o.ModifiedOn = DateTime.Now; o.ModifiedBy = userId; int i = Item.Insert(o); if (i > 0) { lblSuccess.Visible = true; lblWarning.Visible = false; lblError.Visible = false; gridview_Databind(i); ClearControls(this); if (o.ItemCategoryId == 1) { //add Scheduled Vaccination ScheduledVaccination sv = new ScheduledVaccination(); sv.Name = o.Name; sv.Code = o.Code; sv.ItemId = i; sv.EntryDate = o.EntryDate; if (txtExitDate.Text != String.Empty) { sv.ExitDate = o.ExitDate; } sv.IsActive = o.IsActive; sv.Notes = o.Notes; sv.ModifiedOn = DateTime.Now; sv.ModifiedBy = userId; int j = ScheduledVaccination.Insert(sv); // end } } else { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } } } catch (Exception ex) { lblSuccess.Visible = false; lblWarning.Visible = false; lblError.Visible = true; } }