protected void FillGrid() { DataTable dt = SiteDB.GetDataTable(); if (dt.Rows.Count > 0) { if (IsPostBack && Session["siteinfo_sortexpression"] != null && Session["siteinfo_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = Session["siteinfo_sortexpression"].ToString(); GrdSite.DataSource = dataView; } else { GrdSite.DataSource = dt; } Session["siteinfo_data"] = dt; try { GrdSite.DataBind(); } catch (Exception ex) { HideTableAndSetErrorMessage("", ex.ToString()); } } else { dt.Rows.Add(dt.NewRow()); GrdSite.DataSource = dt; GrdSite.DataBind(); int TotalColumns = GrdSite.Rows[0].Cells.Count; GrdSite.Rows[0].Cells.Clear(); GrdSite.Rows[0].Cells.Add(new TableCell()); GrdSite.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdSite.Rows[0].Cells[0].Text = "No Record Found"; } GrdSite.FooterRow.Visible = !hideFotter; btnAddSite.Visible = br_before_add_site_btn_1.Visible = br_before_add_site_btn_2.Visible = !hideFotter; }
protected void GrdNote_RowDataBound(object sender, GridViewRowEventArgs e) { try { UserView userView = UserView.GetInstance(); // if there exists note with the type not in the list of types offered on this screen, use this to add below with "foundRows" DataTable allNoteTypes = DBBase.GetGenericDataTable(null, "NoteType", "note_type_id", "descr"); DataTable allBodyParts = DBBase.GetGenericDataTable(null, "BodyPart", "body_part_id", "descr"); DataTable noteTypes = IsValidFormScreen() ? ScreenNoteTypesDB.GetDataTable_ByScreenID(GetFormScreen()) : allNoteTypes; DataTable sites = SiteDB.GetDataTable(); DataTable dt = ViewState["noteinfo_data"] as DataTable; bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value); if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow) { Label lblId = (Label)e.Row.FindControl("lblId"); DataRow[] foundRows = dt.Select("note_id=" + lblId.Text); DataRow thisRow = foundRows[0]; bool isDeleted = thisRow["deleted_by"] != DBNull.Value || thisRow["date_deleted"] != DBNull.Value; DropDownList ddlDate_Day = (DropDownList)e.Row.FindControl("ddlDate_Day"); DropDownList ddlDate_Month = (DropDownList)e.Row.FindControl("ddlDate_Month"); DropDownList ddlDate_Year = (DropDownList)e.Row.FindControl("ddlDate_Year"); if (ddlDate_Day != null && ddlDate_Month != null && ddlDate_Year != null) { ddlDate_Day.Items.Add(new ListItem("--", "-1")); ddlDate_Month.Items.Add(new ListItem("--", "-1")); ddlDate_Year.Items.Add(new ListItem("----", "-1")); for (int i = 1; i <= 31; i++) { ddlDate_Day.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = 1; i <= 12; i++) { ddlDate_Month.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = DateTime.Today.Year - 1; i <= DateTime.Today.Year + 1; i++) { ddlDate_Year.Items.Add(new ListItem(i.ToString(), i.ToString())); } if (thisRow["date_added"] != DBNull.Value) { DateTime Date = Convert.ToDateTime(thisRow["date_added"]); ddlDate_Day.SelectedValue = Date.Day.ToString(); ddlDate_Month.SelectedValue = Date.Month.ToString(); int firstYearSelectable = Convert.ToInt32(ddlDate_Year.Items[1].Value); int lastYearSelectable = Convert.ToInt32(ddlDate_Year.Items[ddlDate_Year.Items.Count - 1].Value); if (Date.Year < firstYearSelectable) { ddlDate_Year.Items.Insert(1, new ListItem(Date.Year.ToString(), Date.Year.ToString())); } if (Date.Year > lastYearSelectable) { ddlDate_Year.Items.Add(new ListItem(Date.Year.ToString(), Date.Year.ToString())); } ddlDate_Year.SelectedValue = Date.Year.ToString(); } } DropDownList ddlNoteType = (DropDownList)e.Row.FindControl("ddlNoteType"); if (ddlNoteType != null) { ddlNoteType.DataSource = noteTypes; ddlNoteType.DataTextField = "descr"; ddlNoteType.DataValueField = "note_type_id"; ddlNoteType.DataBind(); // if this note type is not in the list for this screen, add it to the edit list bool found = false; foreach (ListItem li in ddlNoteType.Items) { if (li.Value == thisRow["note_type_id"].ToString()) { found = true; } } if (!found) { ddlNoteType.Items.Add(new ListItem(thisRow["note_type_descr"].ToString(), thisRow["note_type_id"].ToString())); } ddlNoteType.SelectedValue = thisRow["note_type_id"].ToString(); } DropDownList ddlBodyPart = (DropDownList)e.Row.FindControl("ddlBodyPart"); if (ddlBodyPart != null) { ddlBodyPart.Items.Clear(); ddlBodyPart.Items.Add(new ListItem("", "-1")); for (int i = 0; i < allBodyParts.Rows.Count; i++) { ddlBodyPart.Items.Add(new ListItem(allBodyParts.Rows[i]["body_part_id"].ToString() + ". " + allBodyParts.Rows[i]["descr"].ToString(), allBodyParts.Rows[i]["body_part_id"].ToString())); } ddlBodyPart.SelectedValue = thisRow["body_part_id"].ToString(); } ImageButton lnkEdit = (ImageButton)e.Row.FindControl("lnkEdit"); if (lnkEdit != null) { lnkEdit.Visible = !isDeleted && (userView.IsAdminView || (thisRow["added_by_staff_id"] != DBNull.Value && Convert.ToInt32(thisRow["added_by_staff_id"]) == Convert.ToInt32(Session["StaffID"])) || (thisRow["modified_by_staff_id"] != DBNull.Value && Convert.ToInt32(thisRow["modified_by_staff_id"]) == Convert.ToInt32(Session["StaffID"]))); } /* * DropDownList ddlSite = (DropDownList)e.Row.FindControl("ddlSite"); * if (ddlSite != null) * { * ddlSite.Items.Add(new ListItem("--", "-1")); * foreach (DataRow row in sites.Rows) * ddlSite.Items.Add(new ListItem(row["name"].ToString(), row["site_id"].ToString())); * ddlSite.SelectedValue = thisRow["site_id"].ToString(); * } */ ImageButton lnkDelete = (ImageButton)e.Row.FindControl("lnkDelete"); if (lnkDelete != null) { lnkDelete.Visible = userView.IsAdminView || (thisRow["added_by_staff_id"] != DBNull.Value && Convert.ToInt32(thisRow["added_by_staff_id"]) == Convert.ToInt32(Session["StaffID"])) || (thisRow["modified_by_staff_id"] != DBNull.Value && Convert.ToInt32(thisRow["modified_by_staff_id"]) == Convert.ToInt32(Session["StaffID"])); if (isDeleted) { lnkDelete.CommandName = "_UnDelete"; lnkDelete.ImageUrl = "~/images/tick-24.png"; lnkDelete.ToolTip = "Un-Delete"; } } if (isDeleted) { e.Row.AddCssClass("deleted_note"); e.Row.Style["display"] = "none"; e.Row.Style["color"] = "gray"; } Utilities.AddConfirmationBox(e); if ((e.Row.RowState & DataControlRowState.Edit) > 0) { Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow); } } if (e.Row.RowType == DataControlRowType.Footer) { DropDownList ddlDate_Day = (DropDownList)e.Row.FindControl("ddlNewDate_Day"); DropDownList ddlDate_Month = (DropDownList)e.Row.FindControl("ddlNewDate_Month"); DropDownList ddlDate_Year = (DropDownList)e.Row.FindControl("ddlNewDate_Year"); if (ddlDate_Day != null && ddlDate_Month != null && ddlDate_Year != null) { ddlDate_Day.Items.Add(new ListItem("--", "-1")); ddlDate_Month.Items.Add(new ListItem("--", "-1")); ddlDate_Year.Items.Add(new ListItem("----", "-1")); for (int i = 1; i <= 31; i++) { ddlDate_Day.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = 1; i <= 12; i++) { ddlDate_Month.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = DateTime.Today.Year - 1; i <= DateTime.Today.Year + 1; i++) { ddlDate_Year.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddlDate_Day.SelectedValue = DateTime.Today.Day.ToString(); ddlDate_Month.SelectedValue = DateTime.Today.Month.ToString(); ddlDate_Year.SelectedValue = DateTime.Today.Year.ToString(); } DropDownList ddlNoteType = (DropDownList)e.Row.FindControl("ddlNewNoteType"); ddlNoteType.DataSource = noteTypes; ddlNoteType.DataBind(); DropDownList ddlBodyPart = (DropDownList)e.Row.FindControl("ddlNewBodyPart"); ddlBodyPart.Items.Add(new ListItem("", "-1")); for (int i = 0; i < allBodyParts.Rows.Count; i++) { ddlBodyPart.Items.Add(new ListItem(allBodyParts.Rows[i]["body_part_id"].ToString() + ". " + allBodyParts.Rows[i]["descr"].ToString(), allBodyParts.Rows[i]["body_part_id"].ToString())); } // set note text in cookie in case user logged out, to keep note text for this user and this entity TextBox txtNewText = (TextBox)e.Row.FindControl("txtNewText"); txtNewText.Attributes["onkeyup"] = "set_note(document.getElementById('" + txtNewText.ClientID + "'), document.getElementById('" + userID.ClientID + "').value, document.getElementById('" + entityID.ClientID + "').value);"; /* * DropDownList ddlSite = (DropDownList)e.Row.FindControl("ddlNewSite"); * ddlSite.Items.Add(new ListItem("--", "-1")); * foreach (DataRow row in sites.Rows) * ddlSite.Items.Add(new ListItem(row["name"].ToString(), row["site_id"].ToString())); * ddlSite.SelectedValue = Session["SiteID"].ToString(); */ } } catch (Exception ex) { if (Utilities.IsDev()) { throw; } else { HideTableAndSetErrorMessage(ex is CustomMessageException ? ex.Message : ""); } } }
private void FillEmptyAddForm() { txtName.Focus(); Page.Title = ((SystemVariables)Session["SystemVariables"])["Site"].Value + " - " + "Add Site"; lblHeading.Text = "Add Site"; // this.lnkNotes.Visible = false; idRow.Visible = false; DataTable dt = SiteDB.GetDataTable(); bool showClinicAddOption = Convert.ToInt32(SystemVariableDB.GetByDescr("AllowAddSiteClinic").Value) == 1; bool showAgedCareAddOption = Convert.ToInt32(SystemVariableDB.GetByDescr("AllowAddSiteAgedCare").Value) == 1; bool showGPAddOption = Convert.ToInt32(SystemVariableDB.GetByDescr("AllowAddSiteGP").Value) == 1; for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToInt32(dt.Rows[i]["site_type_id"]) == 1) { showClinicAddOption = false; } if (Convert.ToInt32(dt.Rows[i]["site_type_id"]) == 2) { showAgedCareAddOption = false; } if (Convert.ToInt32(dt.Rows[i]["site_type_id"]) == 3) { showGPAddOption = false; } } ddlClinic.Items.Clear(); if (showClinicAddOption) { ddlClinic.Items.Add(new ListItem("Clinic", "1")); } if (showAgedCareAddOption) { ddlClinic.Items.Add(new ListItem("Aged Care", "2")); } if (showGPAddOption) { ddlClinic.Items.Add(new ListItem("GP", "3")); } if (!showClinicAddOption && !showAgedCareAddOption) { HideTableAndSetErrorMessage("Unable to add either Clinic or Aged Care Facility or GP."); } ddlNumBookingMonthsToGet.SelectedValue = "9"; ddlFiscalYrEnd_Day.SelectedValue = "30"; ddlFiscalYrEnd_Month.SelectedValue = "6"; chkIncSunday.Checked = false; chkIncMonday.Checked = true; chkIncTuesday.Checked = true; chkIncWednesday.Checked = true; chkIncThursday.Checked = true; chkIncFriday.Checked = true; chkIncSaturday.Checked = false; ddlDayStart_Hour.SelectedValue = "8"; ddlDayStart_Minute.SelectedValue = "0"; ddlDayEnd_Hour.SelectedValue = "18"; ddlDayEnd_Minute.SelectedValue = "0"; ddlLunchStart_Hour.SelectedValue = "12"; ddlLunchStart_Minute.SelectedValue = "0"; ddlLunchEnd_Hour.SelectedValue = "13"; ddlLunchEnd_Minute.SelectedValue = "0"; addressControl.Visible = false; addressAusControl.Visible = false; btnSubmit.Text = "Add Site"; }
private void FillEditViewForm(Site site, bool isEditMode) { Page.Title = ((SystemVariables)Session["SystemVariables"])["Site"].Value + " - " + site.Name; if (!Utilities.IsDev()) { idRow.Attributes["class"] = "hiddencol"; } string screen_id = "2"; string allFeatures = "dialogWidth:980px;dialogHeight:530px;center:yes;resizable:no; scroll:no"; string js = "javascript:window.showModalDialog('" + "NoteListV2.aspx?id=" + site.EntityID.ToString() + "&screen=" + screen_id + "', '', '" + allFeatures + "');document.getElementById('btnUpdateNotesIcon').click();return false;"; // lnkNotes.Attributes.Add("onclick", js); // lnkNotes.ImageUrl = NoteDB.HasNotes(site.EntityID) ? "~/images/notes-48.png" : "~/images/notes-bw-48.jpg"; lblId.Text = site.SiteID.ToString(); chkIncSunday.Checked = !site.ExclSun; chkIncMonday.Checked = !site.ExclMon; chkIncTuesday.Checked = !site.ExclTue; chkIncWednesday.Checked = !site.ExclWed; chkIncThursday.Checked = !site.ExclThu; chkIncFriday.Checked = !site.ExclFri; chkIncSaturday.Checked = !site.ExclSat; ddlDayStart_Hour.SelectedValue = site.DayStartTime.Hours.ToString(); ddlDayStart_Minute.SelectedValue = site.DayStartTime.Minutes.ToString(); ddlDayEnd_Hour.SelectedValue = site.DayEndTime.Hours.ToString(); ddlDayEnd_Minute.SelectedValue = site.DayEndTime.Minutes.ToString(); ddlLunchStart_Hour.SelectedValue = site.LunchStartTime.Hours.ToString(); ddlLunchStart_Minute.SelectedValue = site.LunchStartTime.Minutes.ToString(); ddlLunchEnd_Hour.SelectedValue = site.LunchEndTime.Hours.ToString(); ddlLunchEnd_Minute.SelectedValue = site.LunchEndTime.Minutes.ToString(); lblPrintEPCText.Text = site.SiteType.ID == 1 ? "Print EPC" : "Print Referral"; if (isEditMode) { DataTable dt = SiteDB.GetDataTable(); bool showClinicAddOption = true; bool showAgedCareAddOption = true; bool showGPAddOption = true; for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToInt32(dt.Rows[i]["site_type_id"]) == 1) { showClinicAddOption = false; } if (Convert.ToInt32(dt.Rows[i]["site_type_id"]) == 2) { showAgedCareAddOption = false; } if (Convert.ToInt32(dt.Rows[i]["site_type_id"]) == 3) { showGPAddOption = false; } } if (site.SiteType.ID == 1) { showClinicAddOption = true; } if (site.SiteType.ID == 2) { showAgedCareAddOption = true; } if (site.SiteType.ID == 3) { showGPAddOption = true; } ddlClinic.Items.Clear(); if (showClinicAddOption) { ddlClinic.Items.Add(new ListItem("Clinic", "1")); } if (showAgedCareAddOption) { ddlClinic.Items.Add(new ListItem("Aged Care", "2")); } if (showGPAddOption) { ddlClinic.Items.Add(new ListItem("GP", "3")); } txtName.Text = site.Name; ddlClinic.SelectedValue = site.SiteType.ID.ToString(); txtABN.Text = site.Abn; txtACN.Text = site.Acn; txtTFN.Text = site.Tfn; txtASIC.Text = site.Asic; chkIsProvider.Checked = site.IsProvider; txtBPay.Text = site.BankBpay; txtBSB.Text = site.BankBsb; txtBankAccount.Text = site.BankAccount; txtBankDirectDebitUserID.Text = site.BankDirectDebitUserID; txtBankUsername.Text = site.BankUsername; txtOustandingBalanceWarning.Text = site.OustandingBalanceWarning.ToString(); chkIsPrintEPC.Checked = site.PrintEpc; ddlNumBookingMonthsToGet.SelectedValue = site.NumBookingMonthsToGet > 36 ? "36" : site.NumBookingMonthsToGet.ToString(); ddlFiscalYrEnd_Day.SelectedValue = site.FiscalYrEnd.Day.ToString(); ddlFiscalYrEnd_Month.SelectedValue = site.FiscalYrEnd.Month.ToString(); ddlFiscalYrEnd_Year.SelectedValue = site.FiscalYrEnd.Year.ToString(); lblName.Visible = false; lblClinic.Visible = false; lblABN.Visible = false; lblACN.Visible = false; lblTFN.Visible = false; lblASIC.Visible = false; lblIsProvider.Visible = false; lblBPay.Visible = false; lblBSB.Visible = false; lblBankAccount.Visible = false; lblBankDirectDebitUserID.Visible = false; lblBankUsername.Visible = false; lblOustandingBalanceWarning.Visible = false; lblIsPrintEPC.Visible = false; lblNumBookingMonthsToGet.Visible = false; lblFiscalYrEnd.Visible = false; } else { lblName.Text = site.Name; lblClinic.Text = site.SiteType.Descr; lblABN.Text = site.Abn.Length == 0 ? "--" : site.Abn; lblACN.Text = site.Acn.Length == 0 ? "--" : site.Acn; lblTFN.Text = site.Tfn.Length == 0 ? "--" : site.Tfn; lblASIC.Text = site.Asic.Length == 0 ? "--" : site.Asic; lblIsProvider.Text = site.IsProvider ? "Yes" : "No"; lblBPay.Text = site.BankBpay.Length == 0 ? "--" : site.BankBpay; lblBSB.Text = site.BankBsb.Length == 0 ? "--" : site.BankBsb; lblBankAccount.Text = site.BankAccount.Length == 0 ? "--" : site.BankAccount; lblBankDirectDebitUserID.Text = site.BankDirectDebitUserID.Length == 0 ? "--" : site.BankDirectDebitUserID; lblBankUsername.Text = site.BankUsername.Length == 0 ? "--" : site.BankUsername; lblOustandingBalanceWarning.Text = site.OustandingBalanceWarning.ToString(); lblIsPrintEPC.Text = site.PrintEpc ? "Yes" : "No"; lblNumBookingMonthsToGet.Text = site.NumBookingMonthsToGet.ToString(); lblFiscalYrEnd.Text = site.FiscalYrEnd == DateTime.MinValue ? "--" : site.FiscalYrEnd.ToString("dd-MM-yyyy"); txtName.Visible = false; ddlClinic.Visible = false; txtABN.Visible = false; txtACN.Visible = false; txtTFN.Visible = false; txtASIC.Visible = false; chkIsProvider.Visible = false; txtBPay.Visible = false; txtBSB.Visible = false; txtBankAccount.Visible = false; txtBankDirectDebitUserID.Visible = false; txtBankUsername.Visible = false; txtOustandingBalanceWarning.Visible = false; chkIsPrintEPC.Visible = false; ddlNumBookingMonthsToGet.Visible = false; ddlFiscalYrEnd_Day.Visible = false; ddlFiscalYrEnd_Month.Visible = false; ddlFiscalYrEnd_Year.Visible = false; chkIncSunday.Enabled = false; chkIncMonday.Enabled = false; chkIncTuesday.Enabled = false; chkIncWednesday.Enabled = false; chkIncThursday.Enabled = false; chkIncFriday.Enabled = false; chkIncSaturday.Enabled = false; ddlDayStart_Hour.Enabled = false; ddlDayStart_Minute.Enabled = false; ddlDayEnd_Hour.Enabled = false; ddlDayEnd_Minute.Enabled = false; ddlLunchStart_Hour.Enabled = false; ddlLunchStart_Minute.Enabled = false; ddlLunchEnd_Hour.Enabled = false; ddlLunchEnd_Minute.Enabled = false; } btnSubmit.Text = isEditMode ? "Update Details" : "Edit Details"; btnCancel.Visible = isEditMode; }
protected void GrdLetter_RowDataBound(object sender, GridViewRowEventArgs e) { DataTable letterTypes = DBBase.GetGenericDataTable_WithWhereOrderClause(null, "LetterType", "", "descr", "letter_type_id", "descr"); DataTable sites = SiteDB.GetDataTable(); DataTable dt = Session["letter_data"] as DataTable; bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value); if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow) { bool hasData = dt.Rows[0][0].ToString() != string.Empty; Label lblId = (Label)e.Row.FindControl("lblId"); DataRow[] foundRows = dt.Select("letter_letter_id=" + lblId.Text); DataRow thisRow = foundRows[0]; Letter letter = LetterDB.LoadAll(thisRow); DropDownList ddlLetterType = (DropDownList)e.Row.FindControl("ddlLetterType"); if (ddlLetterType != null) { ddlLetterType.DataSource = letterTypes; ddlLetterType.DataTextField = "descr"; ddlLetterType.DataValueField = "letter_type_id"; ddlLetterType.DataBind(); ddlLetterType.SelectedValue = thisRow["letter_letter_type_id"].ToString(); } DropDownList ddlSite = (DropDownList)e.Row.FindControl("ddlSite"); if (ddlSite != null) { ddlSite.DataSource = sites; ddlSite.DataTextField = "name"; ddlSite.DataValueField = "site_id"; ddlSite.DataBind(); ddlSite.SelectedValue = thisRow["letter_site_id"].ToString(); } Label lblFileExists = (Label)e.Row.FindControl("lblFileExists"); if (lblFileExists != null) { lblFileExists.Style.Remove("border-bottom"); lblFileExists.Font.Bold = false; if (letter.FileExists(Convert.ToInt32(Session["SiteID"]))) { lblFileExists.Text = "Yes"; } else { if (letter.LetterType.ID == 234 || letter.LetterType.ID == 235) // medicare/dva rejection codes { if (letter.Docname.Length == 0) { lblFileExists.Text = string.Empty; } if (letter.Docname.Length > 0) { lblFileExists.Text = "<span style=\"border-bottom:thin dotted black;\" title=\"This won't be in the list of available reject codes.\r\nTo have it in the available list of reject codes, either change the docname to be blank or change the docname to one that exists in the below list.\">No</span>"; lblFileExists.Font.Bold = true; } } else { lblFileExists.Text = "No"; if (letter.Docname.Length > 0) { lblFileExists.Text = "<span style=\"border-bottom:thin dotted black;\" title=\"This won't be in the list of available letters.\r\nTo have it in the available list of letters, change the docname to one that exists in the below list.\">No</span>"; lblFileExists.Font.Bold = true; } } } } Utilities.AddConfirmationBox(e); if ((e.Row.RowState & DataControlRowState.Edit) > 0) { Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow); } } if (e.Row.RowType == DataControlRowType.Footer) { DropDownList ddlLetterType = (DropDownList)e.Row.FindControl("ddlNewLetterType"); ddlLetterType.DataSource = letterTypes; ddlLetterType.DataTextField = "descr"; ddlLetterType.DataValueField = "letter_type_id"; ddlLetterType.DataBind(); DropDownList ddlSite = (DropDownList)e.Row.FindControl("ddlNewSite"); ddlSite.DataSource = sites; ddlSite.DataTextField = "name"; ddlSite.DataValueField = "site_id"; ddlSite.DataBind(); } }