コード例 #1
0
    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;
    }
コード例 #2
0
    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 : "");
            }
        }
    }
コード例 #3
0
    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";
    }
コード例 #4
0
    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;
    }
コード例 #5
0
    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();
        }
    }