protected void LayoutCreated(object sender, EventArgs e)
{
var SortExpression = ParentPageListObject.SortExpression;
string[] Sort = SortExpression.Split(' ');
Panel divHeader = (Panel)ListViewInquriesListRadGrid.FindControl("divHeader");
foreach (Control ctrl in divHeader.Controls)
{
if (ctrl.GetType() == typeof(Panel))
{
string SortId = ((Panel)ctrl).Attributes["SortId"];
if (SortId != null)
{
((Panel)ctrl).Attributes.Add("onclick", "SortListPage(" + ParentPageListObject.ScreenId.ToString() + ",'" + SortId + "');");
if (Sort.Count() > 0)
{
if (Sort[0] == SortId)
{
if (Sort.Count() == 1)
{
((Panel)ctrl).CssClass = "SortUp";
}
else
{
((Panel)ctrl).CssClass = "SortDown";
}
}
}
}
}
}
Panel divContent = (Panel)ListViewInquriesListRadGrid.FindControl("divListPageContent");
//CheckboxController1.ListPageControllerDivID = divContent.ClientID.Trim();
divContent.Attributes.Add("onscroll", "fnScroll('#" + divHeader.ClientID + "','#" + divContent.ClientID + "');");
}
/// <summary>
/// <Description>Bind the list view grid with the data from database.</Description>
/// <Author>Pradeep</Author>
/// <CreatedOn>8 Sept 2011</CreatedOn>
/// </summary>
/// <returns></returns>
public override DataTable BindGrid()
{
string sessionId;
int instanceId = 0;
int pageNumber = 0;
int pageSize = 0;
string sortExpression = "";
int otherFilter = 0;
int recordedByStaffId = 0;
int assignedToStaffId = 0;
int dispositions = 0;
int inquieryStatus = 0;
DateTime?inquiryFrom = null;
DateTime?inquiryTo = null;
string memberLatName = null;
string memberFirstName = null;
//using (SHS.UserBusinessServices.MemberInquiriesKalamazoo objectMemberInquiries = new SHS.UserBusinessServices.MemberInquiriesKalamazoo())
//{
DataSet dataSetInquries = null;
sessionId = Session.SessionID;
int.TryParse(ParentPageListObject.CurrentHistoryId, out instanceId);
pageNumber = ParentPageListObject.CurrentPage;
pageSize = ParentPageListObject.PageSize;
sortExpression = ParentPageListObject.SortExpression;
PeriodStartDate = GetFilterValue("InquiriesFrom", "01/01/1900");
PeriodEndDate = GetFilterValue("InquiriesTo", "12/31/9999");
if (Extension.IsDropDownHaveItems(DropDownList_AssignedToStaffId))
{
int.TryParse(GetFilterValue("AssignedToStaffId", DropDownList_AssignedToStaffId.SelectedValue), out assignedToStaffId);
}
else
{
int.TryParse(GetFilterValue("AssignedToStaffId"), out assignedToStaffId);
}
if (Extension.IsDropDownHaveItems(DropDownList_RecordedByStaffId))
{
int.TryParse(GetFilterValue("RecordedByStaffId", DropDownList_RecordedByStaffId.SelectedValue), out recordedByStaffId);
}
else
{
int.TryParse(GetFilterValue("RecordedByStaffId"), out recordedByStaffId);
}
if (Extension.IsDropDownHaveItems(DropDownList_Dispositions))
{
int.TryParse(GetFilterValue("Dispositions", DropDownList_Dispositions.SelectedValue), out dispositions);
}
else
{
int.TryParse(GetFilterValue("Dispositions"), out dispositions);
}
if (Extension.IsDropDownHaveItems(DropDownList_InquiryStatus))
{
int.TryParse(GetFilterValue("InquiryStatus", DropDownList_InquiryStatus.SelectedValue), out inquieryStatus);
}
else
{
int.TryParse(GetFilterValue("InquiryStatus"), out inquieryStatus);
}
if (Extension.IsDropDownHaveItems(DropDownList_CustomFilter))
{
int.TryParse(GetFilterValue("CustomFilter", DropDownList_CustomFilter.SelectedValue), out otherFilter);
}
else
{
int.TryParse(GetFilterValue("CustomFilter"), out otherFilter);
}
if (GetFilterValue("InquiriesFrom") != null && GetFilterValue("InquiriesFrom") != "")
{
inquiryFrom = Convert.ToDateTime(GetFilterValue("InquiriesFrom"));
}
else
{
inquiryFrom = Convert.ToDateTime(GetFilterValue("InquiriesFrom", "01/01/1900"));
}
if (GetFilterValue("InquiriesTo") != null && GetFilterValue("InquiriesTo") != "")
{
inquiryTo = Convert.ToDateTime(GetFilterValue("InquiriesTo"));
}
else
{
inquiryTo = Convert.ToDateTime(GetFilterValue("InquiriesTo", "12/31/9999"));
}
if (GetFilterValue("MemberLatName") != "")
{
memberLatName = GetFilterValue("MemberLatName").ToString();
}
if (GetFilterValue("MemberFirstName") != "")
{
memberFirstName = GetFilterValue("MemberFirstName").ToString();
}
//dataSetInquries = objectMemberInquiries.GetInquriesList(sessionId,instanceId, pageNumber, pageSize, sortExpression, recordedByStaffId, assignedToStaffId, inquiryFrom, inquiryTo, memberLatName, memberFirstName, dispositions,inquieryStatus,otherFilter);
dataSetInquries = GetInquriesList(instanceId, pageNumber, pageSize, sortExpression, recordedByStaffId, assignedToStaffId, inquiryFrom, inquiryTo, memberLatName, memberFirstName, dispositions, inquieryStatus, otherFilter);
if (dataSetInquries.Tables.Count > 0)
{
if (dataSetInquries.Tables.Contains("CustomInquiries") == true)
{
//GridViewInquriesListRadGrid.SettingsPager.PageSize = pageSize; //Set the page size
ListViewInquriesListRadGrid.DataSource = dataSetInquries.Tables["CustomInquiries"];
//Extension.SetDevXGridSortIcon(sortExpression, GridViewInquriesListRadGrid);
ListViewInquriesListRadGrid.DataBind();
//GridViewInquriesListRadGrid.Settings.ShowVerticalScrollBar = true;
}
}
return(dataSetInquries.Tables["TablePagingInformation"]);
//}
}
