protected IEnumerable<RequestListViewModel> RequestViewList(RequestLookupViewModel lookup)
{
var requests = from r in PrdnDBContext.Requests
select r;
if (!string.IsNullOrEmpty(lookup.RequestID))
{
requests = from r in requests
where r.ID == lookup.RequestID
select r;
}
else
{
if ((lookup.FromDt != null) || (lookup.ThruDt != null))
{
DateTime afterDt = lookup.FromDt ?? DateTime.Today.Date.AddMonths(-1);
afterDt = afterDt.Date;
DateTime beforeDt = lookup.ThruDt ?? DateTime.Today.Date;
beforeDt = beforeDt.Date.AddDays(1);
requests = from r in requests
where (r.RequestDt >= afterDt) && (r.RequestDt < beforeDt)
select r;
}
if (!lookup.AllStauses)
{
List<string> states = new List<string>();
if (lookup.StatusProcessing)
{
states.Add(RequestStatus.PROCESSING.ToString().ToUpper());
}
if (lookup.StatusConfirmed)
{
states.Add(RequestStatus.CONFIRMED.ToString().ToUpper());
}
if (lookup.StatusCanceled)
{
states.Add(RequestStatus.CANCELED.ToString().ToUpper());
}
if (lookup.StatusScheduled)
{
states.Add(RequestStatus.SCHEDULED.ToString().ToUpper());
}
if ((states.Count()==0) || (lookup.StatusNew))
{
states.Add(RequestStatus.NEW.ToString().ToUpper());
}
requests = from r in requests
where states.Contains(r.StatusStr)
select r;
}
}
requests = from r in requests
orderby r.RequestDt descending
select r;
List<RequestListViewModel> viewRequests =
Mapper.Map<List<Request>, List<RequestListViewModel>>(requests.ToList());
return viewRequests;
}
protected GridModel RequestGridList(RequestLookupViewModel lookup)
{
GridModel g = new GridModel(RequestViewList(lookup).ToList());
return g;
}
public ActionResult _SelectRequest(string id, DateTime? fromDt, DateTime? thruDt,
bool allStauses, bool statusNew, bool statusProcessing, bool statusConfirmed, bool statusScheduled, bool statusCanceled)
{
RequestLookupViewModel lookup = new RequestLookupViewModel()
{
RequestID = id,
FromDt = fromDt,
ThruDt = thruDt,
AllStauses = allStauses,
StatusNew = statusNew,
StatusProcessing = statusProcessing,
StatusConfirmed = statusConfirmed,
StatusScheduled = statusScheduled,
StatusCanceled = statusCanceled
};
return View(RequestGridList(lookup));
}
public ActionResult Lookup(RequestLookupViewModel lookup)
{
Session[RequestLookupKey] = lookup;
return RedirectToAction("Lookup");
}
public ActionResult Lookup()
{
RequestLookupViewModel model = Session[RequestLookupKey] as RequestLookupViewModel;
if (model != null)
{
model.DefineCriteria = false;
}
else
{
model = new RequestLookupViewModel();
model.DefineLookupDefault();
model.PageSize = GetRequestPageSize();
}
//model.DefaultRunModel = MakeDefaultRunViewModel(true);
UserSettingsViewModel settings = GetUserSettingsViewModel(true);
model.SettingsModel = settings;
model.PageSize = (int)(settings.RequestPageSize ?? UserSettingsModel.DefaultPageSize);
return View(model);
}
public ActionResult List()
{
RequestLookupViewModel model = new RequestLookupViewModel();
model.DefineListDefault();
UserSettingsViewModel settings = GetUserSettingsViewModel(true);
model.SettingsModel = settings;
model.PageSize = (int)(settings.RequestPageSize ?? UserSettingsModel.DefaultPageSize);
ViewBag.RefreshMsg = "The data refreshes every minute. To force a refresh of the data, click the refresh button on your browser";
Response.AppendHeader("Refresh", "60");
return View(model);
}
