private void Init()
{
mCapitalRequest = null;
mVendor = null;
mQuoteBlob = null;
mCreatedBy = null;
mModifiedBy = null;
VendorContactPhone = null;
BidID = 0;
CapitalRequestID = 0;
VendorID = 0;
VendorName = null;
VendorContactName = null;
VendorContactPhone = null;
VendorContactEmail = null;
QuoteBlobID = 0;
BidAmount = 0;
IsPreferredBid = false;
CreatedByUser = null;
ModifiedByUser = null;
DateCreated = DateTime.MinValue;
DateModified = DateTime.MinValue;
Active = true;
}
private void LoadCapitalRequests()
{
//ConfigureCapitalRequestGrid();
Dictionary <string, string> filterValues = BuildFilters();
List <CapitalRequestListItem> requests = CapitalRequest.GetCapitalRequestList(filterValues);
SortProperty sortProperty = gRequestList.SortProperty;
// Check User Preferences to see if we have a pre-existing sort property
if (sortProperty == null)
{
sortProperty = new SortProperty();
sortProperty.Direction = GetUserPreference(string.Format("{0}_Sort_Direction", PersonSettingKey)) == "ASC" ? SortDirection.Ascending : SortDirection.Descending;
sortProperty.Property = GetUserPreference(string.Format("{0}_Sort_Column", PersonSettingKey));
if (string.IsNullOrEmpty(sortProperty.Property))
{
sortProperty.Property = "CapitalRequestId";
}
}
if (sortProperty != null)
{
if (sortProperty.Direction == SortDirection.Ascending)
{
requests = requests.OrderBy(r => r.GetType().GetProperty(sortProperty.Property).GetValue(r)).ToList();
}
else
{
requests = requests.OrderByDescending(r => r.GetType().GetProperty(sortProperty.Property).GetValue(r)).ToList();
}
SetUserPreference(string.Format("{0}_Sort_Direction", PersonSettingKey), sortProperty.DirectionString);
SetUserPreference(string.Format("{0}_Sort_Column", PersonSettingKey), sortProperty.Property);
}
else
{
requests = requests.OrderByDescending(r => r.CapitalRequestId).ToList();
}
DataTable capRequestDT = new DataTable();
capRequestDT.Columns.Add("CapitalRequestId", typeof(string));
capRequestDT.Columns.Add("ProjectName", typeof(string));
capRequestDT.Columns.Add("RequestingMinistry", typeof(string));
capRequestDT.Columns.Add("RequesterName", typeof(string));
capRequestDT.Columns.Add("RequesterNameLastFirst", typeof(string));
capRequestDT.Columns.Add("FullAccountNumber", typeof(string));
capRequestDT.Columns.Add("ProjectId", typeof(string));
capRequestDT.Columns.Add("Status", typeof(string));
capRequestDT.Columns.Add("RequisitionCount", typeof(int));
capRequestDT.Columns.Add("TotalCharges", typeof(decimal));
capRequestDT.Columns.Add("Active", typeof(bool));
foreach (var request in requests)
{
capRequestDT.Rows.Add(
request.CapitalRequestId,
request.ProjectName,
request.RequestingMinistry,
request.RequesterName,
request.RequesterNameLastFirst,
request.FullAccountNumber,
request.ProjectId,
request.Status,
request.RequisitionCount,
request.TotalCharges,
request.Active
);
}
gRequestList.DataSource = capRequestDT;
gRequestList.DataBind();
gRequestList.Actions.ShowAdd = UserCanEdit;
gRequestList.Actions.AddButton.Text = "<i class=\"fa fa-plus\"></i> Add Capital Request";
gRequestList.Actions.AddClick += lbCreateCapitalRequest_Click;
gRequestList.Actions.ShowExcelExport = false;
gRequestList.Actions.ShowMergeTemplate = false;
if (sortProperty != null)
{
foreach (var column in gRequestList.Columns)
{
var dcf = column as DataControlField;
if (dcf != null && dcf.SortExpression == sortProperty.Property)
{
gRequestList.HeaderRow.Cells[gRequestList.Columns.IndexOf(dcf)].AddCssClass(sortProperty.Direction.ToString().ToLower());
break;
}
}
if (gRequestList.SortProperty == null)
{
gRequestList.Sort(sortProperty.Property, sortProperty.Direction);
}
}
//grdCapitalRequests.DataSource = capRequestDT;
//grdCapitalRequests.DataBind();
//grdCapitalRequests.Visible = requests.Count > 0;
}
