public JsonResult GetFriendCallDetailsPrep([DataSourceRequest] DataSourceRequest request, int dateIndex, string friendFbId) { IList <DateTime> dateRange = CallDetailsModel.GetDateRange(); string startDate = String.Format("{0:dd'/'MM'/'yyyy}", dateRange[dateIndex + 1]); string endDate = String.Format("{0:dd'/'MM'/'yyyy}", dateRange[dateIndex]); ServiceManager.ServiceHandlers.CallDetailHandler srvHandler = new CallDetailHandler(); var srvData = srvHandler.PrepareData(startDate, endDate); IList <CallDetailModel> modelList = (from u in srvData join p in UserFb.Friends on LIB.StringHelper.Right(u.OpAddress.TrimEnd(), 10) equals p.Msisdn into a from f in a.DefaultIfEmpty(new UserFbFriendModel()) select new CallDetailModel { Amount = u.Amount, DataVolume = u.DataVolume, DateDisplay = u.DateDisplay, Description = u.Description, OpAddress = ProjectUtil.CallDetailOpAddres(u.OpAddress, session.IsSubscriptionActive), PictureLink = f.PictureLink, UserId = f.UserId, FbId = f.FbId, FirstNameView = f.FirstNameView, IsClickToCallBlock = f.IsClickToCallBlock, IsClickToCallInvisible = f.IsClickToCallInvisible, LastNameView = f.LastNameView, }) .Where(f => f.FbId == friendFbId) .ToList(); return(Json(modelList.ToList(), JsonRequestBehavior.AllowGet)); }
public JsonResult GetFriendCallDetailsPosp([DataSourceRequest] DataSourceRequest request, string Period, string friendFbId) { ServiceManager.ServiceHandlers.CallDetailHandler srvHandler = new CallDetailHandler(); srvHandler.customerType = (Parameter.CustomerType)UserFb.Data.CustomerType; var srvData = srvHandler.PrepareData(Period); IList <CallDetailModel> modelList = (from u in srvData join p in UserFb.Friends on LIB.StringHelper.Right(u.OpAddress.TrimEnd(), 10) equals p.Msisdn into a from f in a.DefaultIfEmpty(new UserFbFriendModel()) select new CallDetailModel { Amount = u.Amount, DataVolume = u.DataVolume, DateDisplay = u.DateDisplay, Description = u.Description, OpAddress = ProjectUtil.CallDetailOpAddres(u.OpAddress, session.IsSubscriptionActive), PictureLink = f.PictureLink, UserId = f.UserId, FbId = f.FbId, FirstNameView = f.FirstNameView, IsClickToCallBlock = f.IsClickToCallBlock, IsClickToCallInvisible = f.IsClickToCallInvisible, LastNameView = f.LastNameView, }) .Where(f => f.FbId == friendFbId) .ToList(); return(Json(modelList.ToList(), JsonRequestBehavior.AllowGet)); }