protected void FillGrid()
{
Organisation org = IsValidFormOrgID() ? OrganisationDB.GetByID(GetFormOrgID()) : null;
if (!IsValidFormOrgID())
{
lblHeading.Text = "Maintain Letters";
}
else if (org == null)
{
lblHeading.Text = "Maintain Default Letters";
}
else
{
lblHeading.Text = "Maintain Letters For ";
lnkToEntity.Text = org.Name;
lnkToEntity.NavigateUrl = "OrganisationDetailV2.aspx?type=view&id=" + org.OrganisationID;
}
DataTable dt = IsValidFormOrgID() ? LetterDB.GetDataTable_ByOrg(GetFormOrgID(), GetFormOrgID() == 0 ? Convert.ToInt32(Session["SiteID"]) : -1) : LetterDB.GetDataTable(Convert.ToInt32(Session["SiteID"]));
Session["letter_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["letter_sortexpression"] != null && Session["letter_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["letter_sortexpression"].ToString();
GrdLetter.DataSource = dataView;
}
else
{
GrdLetter.DataSource = dt;
}
try
{
GrdLetter.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdLetter.DataSource = dt;
GrdLetter.DataBind();
int TotalColumns = GrdLetter.Rows[0].Cells.Count;
GrdLetter.Rows[0].Cells.Clear();
GrdLetter.Rows[0].Cells.Add(new TableCell());
GrdLetter.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdLetter.Rows[0].Cells[0].Text = "No Record Found";
}
}
protected void PopulateLettersList()
{
DataTable letters = LetterDB.GetDataTable_ByOrg(0, Convert.ToInt32(Session["SiteID"]));
// remove ones that dont exists
for (int i = letters.Rows.Count - 1; i >= 0; i--)
{
Letter letter = LetterDB.LoadAll(letters.Rows[i]);
if (!letter.FileExists(Convert.ToInt32(Session["SiteID"])))
{
letters.Rows.RemoveAt(i);
}
}
lstLetters.DataSource = letters;
lstLetters.DataTextField = "letter_docname";
lstLetters.DataValueField = "letter_letter_id";
lstLetters.DataBind();
}
protected void PopulateLettersList()
{
UserView userView = UserView.GetInstance();
int orgID = (txtUpdateOrganisationID.Text.Length == 0) ? 0 : Convert.ToInt32(txtUpdateOrganisationID.Text);
if (orgID == 0 && !userView.IsAdminView)
{
orgID = Convert.ToInt32(Session["OrgID"]);
}
bool usingDeafultLetters = orgID == 0 || chkUseDefaultDocs.Checked; // || !LetterDB.OrgHasdocs(orgID);
DataTable letters = LetterDB.GetDataTable_ByOrg(usingDeafultLetters ? 0 : orgID, usingDeafultLetters ? Convert.ToInt32(Session["SiteID"]) : -1);
lblSpaceBeforeUseDefaultDocsCheckbox.Visible = orgID != 0;
chkUseDefaultDocs.Visible = orgID != 0;
chkUseDefaultDocs.ForeColor = System.Drawing.Color.DarkOrchid;
lblDefaultOrOrgSpecificDocs.Visible = orgID == 0;
lblSpaceBeforeUseDefaultDocsCheckbox.Visible = orgID == 0;
if (usingDeafultLetters)
{
SetLabel(lblDefaultOrOrgSpecificDocs, "**Using Default Docs", System.Drawing.Color.Blue, false);
}
else
{
SetLabel(lblDefaultOrOrgSpecificDocs, "**Using Organisation Specific Docs", System.Drawing.Color.DarkOrchid, false);
}
// remove ones that dont exists
for (int i = letters.Rows.Count - 1; i >= 0; i--)
{
Letter letter = LetterDB.LoadAll(letters.Rows[i]);
if (!letter.FileExists(Convert.ToInt32(Session["SiteID"])))
{
letters.Rows.RemoveAt(i);
}
}
lstLetters.DataSource = letters;
lstLetters.DataTextField = "letter_docname";
lstLetters.DataValueField = "letter_letter_id";
lstLetters.DataBind();
}
protected void GrdTreatmentTemplateLetters_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable fields = DBBase.GetGenericDataTable_WithWhereOrderClause(null, "Field", "field_id <> 0 AND has_offerings = 1", "descr", "field_id", "descr");
DataTable letters = LetterDB.GetDataTable_ByOrg(0, Convert.ToInt32(Session["SiteID"]));
DataTable dt = Session["treatment_template_letters_data"] as DataTable;
bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value);
// remove offering flds that are used
if (!tblEmpty)
{
foreach (DataRow row in dt.Rows)
{
for (int i = 0; i < fields.Rows.Count; i++)
{
if (Convert.ToInt32(fields.Rows[i]["field_id"]) == Convert.ToInt32(row["lettertreatmenttemplate_field_id"]))
{
fields.Rows.RemoveAt(i);
}
}
}
}
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("lettertreatmenttemplate_letter_treatment_template_id=" + lblId.Text);
DataRow thisRow = foundRows[0];
DropDownList ddlField = (DropDownList)e.Row.FindControl("ddlField");
if (ddlField != null)
{
ddlField.DataSource = fields;
ddlField.DataTextField = "descr";
ddlField.DataValueField = "field_id";
ddlField.DataBind();
ddlField.SelectedValue = thisRow["lettertreatmenttemplate_field_id"].ToString();
}
DropDownList ddlFirstLetter = (DropDownList)e.Row.FindControl("ddlFirstLetter");
if (ddlFirstLetter != null)
{
ddlFirstLetter.DataSource = letters;
ddlFirstLetter.DataTextField = "letter_docname";
ddlFirstLetter.DataValueField = "letter_letter_id";
ddlFirstLetter.DataBind();
ddlFirstLetter.SelectedValue = thisRow["lettertreatmenttemplate_first_letter_id"].ToString();
}
DropDownList ddlTreatmentNoteLetter = (DropDownList)e.Row.FindControl("ddlTreatmentNoteLetter");
if (ddlTreatmentNoteLetter != null)
{
ddlTreatmentNoteLetter.DataSource = letters;
ddlTreatmentNoteLetter.DataTextField = "letter_docname";
ddlTreatmentNoteLetter.DataValueField = "letter_letter_id";
ddlTreatmentNoteLetter.DataBind();
ddlTreatmentNoteLetter.SelectedValue = thisRow["lettertreatmenttemplate_treatment_notes_letter_id"].ToString();
}
DropDownList ddlLastLetter = (DropDownList)e.Row.FindControl("ddlLastLetter");
if (ddlLastLetter != null)
{
ddlLastLetter.DataSource = letters;
ddlLastLetter.DataTextField = "letter_docname";
ddlLastLetter.DataValueField = "letter_letter_id";
ddlLastLetter.DataBind();
ddlLastLetter.SelectedValue = thisRow["lettertreatmenttemplate_last_letter_id"].ToString();
}
DropDownList ddlLastLetterPT = (DropDownList)e.Row.FindControl("ddlLastLetterPT");
if (ddlLastLetterPT != null)
{
ddlLastLetterPT.DataSource = letters;
ddlLastLetterPT.DataTextField = "letter_docname";
ddlLastLetterPT.DataValueField = "letter_letter_id";
ddlLastLetterPT.DataBind();
ddlLastLetterPT.SelectedValue = thisRow["lettertreatmenttemplate_last_letter_pt_id"].ToString();
}
DropDownList ddlLastLetterWhenReplacingEPC = (DropDownList)e.Row.FindControl("ddlLastLetterWhenReplacingEPC");
if (ddlLastLetterWhenReplacingEPC != null)
{
ddlLastLetterWhenReplacingEPC.DataSource = letters;
ddlLastLetterWhenReplacingEPC.DataTextField = "letter_docname";
ddlLastLetterWhenReplacingEPC.DataValueField = "letter_letter_id";
ddlLastLetterWhenReplacingEPC.DataBind();
ddlLastLetterWhenReplacingEPC.SelectedValue = thisRow["lettertreatmenttemplate_last_letter_when_replacing_epc_id"].ToString();
}
Utilities.AddConfirmationBox(e);
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow);
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
if (fields.Rows.Count == 0)
{
if (GrdTreatmentTemplateLetters.FooterRow != null)
{
GrdTreatmentTemplateLetters.FooterRow.Visible = false;
}
hideFotter = true;
}
else
{
DropDownList ddlField = (DropDownList)e.Row.FindControl("ddlNewField");
ddlField.DataSource = fields;
ddlField.DataTextField = "descr";
ddlField.DataValueField = "field_id";
ddlField.DataBind();
DropDownList ddlFirstLetter = (DropDownList)e.Row.FindControl("ddlNewFirstLetter");
ddlFirstLetter.DataSource = letters;
ddlFirstLetter.DataTextField = "letter_docname";
ddlFirstLetter.DataValueField = "letter_letter_id";
ddlFirstLetter.DataBind();
DropDownList ddlTreatmentNoteLetter = (DropDownList)e.Row.FindControl("ddlNewTreatmentNoteLetter");
ddlTreatmentNoteLetter.DataSource = letters;
ddlTreatmentNoteLetter.DataTextField = "letter_docname";
ddlTreatmentNoteLetter.DataValueField = "letter_letter_id";
ddlTreatmentNoteLetter.DataBind();
DropDownList ddlLastLetter = (DropDownList)e.Row.FindControl("ddlNewLastLetter");
ddlLastLetter.DataSource = letters;
ddlLastLetter.DataTextField = "letter_docname";
ddlLastLetter.DataValueField = "letter_letter_id";
ddlLastLetter.DataBind();
DropDownList ddlLastLetterPT = (DropDownList)e.Row.FindControl("ddlNewLastLetterPT");
ddlLastLetterPT.DataSource = letters;
ddlLastLetterPT.DataTextField = "letter_docname";
ddlLastLetterPT.DataValueField = "letter_letter_id";
ddlLastLetterPT.DataBind();
DropDownList ddlLastLetterWhenReplacingEPC = (DropDownList)e.Row.FindControl("ddlNewLastLetterWhenReplacingEPC");
ddlLastLetterWhenReplacingEPC.DataSource = letters;
ddlLastLetterWhenReplacingEPC.DataTextField = "letter_docname";
ddlLastLetterWhenReplacingEPC.DataValueField = "letter_letter_id";
ddlLastLetterWhenReplacingEPC.DataBind();
}
}
}