protected void gvPELList_Sorting(object sender, GridViewSortEventArgs e)
{
Classes.cUserOption Option = new Classes.cUserOption();
Option.LoadOptionValue(Master.UserName, HttpContext.Current.Request.Url.AbsolutePath, "gvPELList", "SortField");
string sSortField = Option.OptionValue;
Option.LoadOptionValue(Master.UserName, HttpContext.Current.Request.Url.AbsolutePath, "gvPELList", "SortDir");
string sSortDir = Option.OptionValue;
if (e.SortExpression == sSortField)
{
if (String.IsNullOrEmpty(sSortDir))
{
sSortDir = "DESC";
}
else
{
sSortDir = "";
}
}
else
{
sSortField = e.SortExpression;
sSortDir = "";
}
Option = new Classes.cUserOption();
Option.LoginUsername = Master.UserName;
Option.PageName = HttpContext.Current.Request.Url.AbsolutePath;
Option.ObjectName = "gvPELList";
Option.ObjectOption = "SortField";
Option.OptionValue = sSortField;
Option.SaveOptionValue();
Option = new Classes.cUserOption();
Option.LoginUsername = Master.UserName;
Option.PageName = HttpContext.Current.Request.Url.AbsolutePath;
Option.ObjectName = "gvPELList";
Option.ObjectOption = "SortDir";
Option.OptionValue = sSortDir;
Option.SaveOptionValue();
}
protected void BindData()
{
SortedList sParams = new SortedList();
DataTable dtCharHistory = new DataTable();
int iSessionID = 0;
int.TryParse(Session ["CampaignID"].ToString(), out iSessionID);
sParams.Add("@CampaignID", iSessionID);
dtCharHistory = Classes.cUtilities.LoadDataTable("uspGetCampaignCharacterHistory", sParams, "LARPortal", Session ["UserName"].ToString(), "PELApprovalList.Page_PreRender");
if (!IsPostBack)
{
ddlCharacterName.DataSource = dtCharHistory;
ddlCharacterName.DataTextField = "CharacterAKA";
ddlCharacterName.DataValueField = "CharacterAKA";
ddlCharacterName.DataBind();
if (dtCharHistory.Rows.Count > 1)
{
ListItem liNoFilter = new ListItem();
liNoFilter.Text = "No Filter";
liNoFilter.Value = "";
ddlCharacterName.Items.Insert(0, liNoFilter);
}
}
string sSelectedChar = "";
string sStatus = "";
string sRowFilter = "";
Classes.cUserOption Option = new Classes.cUserOption();
Option.LoadOptionValue(Session["UserName"].ToString(), HttpContext.Current.Request.Url.AbsolutePath, "ddlCharacterName", "SelectedValue");
sSelectedChar = Option.OptionValue;
Option.LoadOptionValue(Session["UserName"].ToString(), HttpContext.Current.Request.Url.AbsolutePath, "ddlStatus", "SelectedValue");
sStatus = Option.OptionValue;
if (!string.IsNullOrEmpty(sSelectedChar))
{
ddlCharacterName.ClearSelection();
foreach (ListItem lItem in ddlCharacterName.Items)
{
if (lItem.Value == sSelectedChar)
{
sRowFilter = "(CharacterAKA = '" + lItem.Value.Replace("'", "''") + "')";
ddlCharacterName.ClearSelection();
lItem.Selected = true;
}
}
if (ddlCharacterName.SelectedIndex < 0)
{
ddlCharacterName.SelectedIndex = 0;
}
}
else
{
if (sStatus.Length > 0)
{
ddlStatus.ClearSelection();
foreach (ListItem lItem in ddlStatus.Items)
{
if (lItem.Value == sStatus)
{
switch (sStatus)
{
case "A":
sRowFilter = "(DateHistoryApproved is not null)";
break;
case "S":
sRowFilter = "(DateHistoryApproved is null) and (DateHistorySubmitted is not null)";
break;
default:
sRowFilter = "(DateHistorySubmitted is not null)";
break;
}
}
}
if (ddlStatus.SelectedIndex < 0)
{
ddlStatus.SelectedIndex = 0;
}
}
}
if (dtCharHistory.Columns ["HistoryStatus"] == null)
{
dtCharHistory.Columns.Add("HistoryStatus", typeof(string));
}
if (dtCharHistory.Columns ["ShortHistory"] == null)
{
dtCharHistory.Columns.Add("ShortHistory", typeof(string));
}
foreach (DataRow dRow in dtCharHistory.Rows)
{
string sRawHistory = dRow ["CharacterHistory"].ToString();
string ScrubbedHistory = ScrubHtml(sRawHistory);
if (ScrubbedHistory.Length > 100)
{
dRow ["ShortHistory"] = ScrubbedHistory.Substring(0, 95) + "...";
}
else
{
dRow ["ShortHistory"] = ScrubbedHistory;
}
if (dRow ["DateHistoryApproved"] == DBNull.Value)
{
dRow ["HistoryStatus"] = "Submitted";
}
else
{
dRow ["HistoryStatus"] = "Approved";
}
}
DataView dvPELs = new DataView(dtCharHistory, sRowFilter, "CharacterAKA", DataViewRowState.CurrentRows);
gvHistoryList.DataSource = dvPELs;
gvHistoryList.DataBind();
}