public ActionResult ShowStat24(string id, string id2) { var userId = (Guid)MembershipService.GetUser(User.Identity.Name).ProviderUserKey; //var id = Request.Form["id"]; //var id2 = Request.Form["id2"]; var end = DateTime.Now; var start = end.AddDays(-1); var context = new IncomingCallsQAEntities(); var list = context.StatisticTracks.Where( i => i.UserId == userId && i.StartDate >= start && i.StartDate <= end && i.OptionId == null) .Select( t => new CallStat { TrackId = t.TrackId, CalledNumber = t.CalledNumber, DialedNumber = t.DialedNumber, StartDate = t.StartDate }).ToList(); var listOfOptions = context.EndCallOptions.Select(item => new Option { OptionId = item.OptionId, OptionName = item.OptionName }).ToList(); listOfOptions.Add(new Option() { OptionId = -1, OptionName = "None" }); var model = new Stat24Model { StartDate = start, EndDate = end, UserStat24 = list, AllPossibleOptions = listOfOptions }; return(View(model)); }
public ActionResult FakeShowStat24(string id, string id2) { var model = new Stat24Model { StartDate = DateTime.Now.AddDays(-1), EndDate = DateTime.Now, UserStat24 = new List <CallStat> { new CallStat { TrackId = 1, CalledNumber = "800XXXXX1", DialedNumber = "8000YYYYYY1", StartDate = DateTime.Now.AddHours(-1) }, new CallStat { TrackId = 2, CalledNumber = "800XXXXX2", DialedNumber = "8000YYYYYY2", StartDate = DateTime.Now.AddHours(-1) }, new CallStat { TrackId = 3, CalledNumber = "800XXXXX3", DialedNumber = "8000YYYYYY3", StartDate = DateTime.Now.AddHours(-1) } }, AllPossibleOptions = new List <Option> { new Option { OptionId = -1, OptionName = "none" }, new Option { OptionId = 0, OptionName = "opt0" }, new Option { OptionId = 1, OptionName = "opt1" }, new Option { OptionId = 2, OptionName = "opt2" } } }; return(View("ShowStat24", model)); }