public Task<FormatedList<UserModel>> GetAll (NameValueCollection requestParams) { return Task.Run(() => { using(var session = new UnitOfWork<FoodMenuEntities>()) { IUserRepository userRepository = session.GetRepository<IUserRepository>(); var userList = userRepository.Find(u => u.IsActive).Select(u => new UserModel { Id = u.Id, Email = u.Email, Password = u.Password, FirstName = u.FirstName, LastName = u.LastName, BusinessId = u.BusinessId, Address = u.Address, }); var parser = new DataTableEntityParser<UserModel>(requestParams,userList.AsQueryable()); return parser.Parse(); } }); }
public Task<FormatedList<InvoiceModel>> GetAll (NameValueCollection requestParams,int clientId) { return Task.Run(() => { using(var session = new UnitOfWork<FoodMenuEntities>()) { IInvoiceRepository InvoiceRepository = session.GetRepository<IInvoiceRepository>(); var InvoiceList = InvoiceRepository.GetAll().Where(u => u.ClientId == clientId).Select(i => new InvoiceModel { Id = i.Id, ClientId = i.ClientId, Notes = i.Notes, MeetingId = i.MeetingId, Number = i.Number, }); var parser = new DataTableEntityParser<InvoiceModel>(requestParams,InvoiceList.AsQueryable()); var list = parser.Parse(); return list; } }); }
public Task<FormatedList<ClientModel>> GetAll (NameValueCollection requestParams) { return Task.Run(() => { using(var session = new UnitOfWork<FoodMenuEntities>()) { IClientRepository ClientRepository = session.GetRepository<IClientRepository>(); var ClientList = ClientRepository.Find(u => u.IsActive).Select(c => new ClientModel { Id = c.Id, Name = c.Name, Email = c.Email, Phone = c.Phone, Nationalid = c.Nationalid, Sex = c.Sex, Height = c.Height, Weight = c.Weight, FatPercentage = c.FatPercentage, //Goal = c.Goal, //Pills = c.Pills, //Supplement = c.Supplement, //RedirectedBy = c.RedirectedBy, Price = c.Price, //RMR = c.RMR, //UserId = c.UserId, }); var parser = new DataTableEntityParser<ClientModel>(requestParams,ClientList.AsQueryable()); var list = parser.Parse(); foreach(var item in list.aaData) { var itemSex = item[4].ToInt(); item[4] = Utility.GetDescription(itemSex,typeof(SexEnum)); } return list; } }); }
public Task<FormatedList<MeetingModel>> GetAll (NameValueCollection requestParams,int clientId) { return Task.Run(() => { using(var session = new UnitOfWork<FoodMenuEntities>()) { IMeetingRepository MeetingRepository = session.GetRepository<IMeetingRepository>(); var MeetingList = MeetingRepository.Find(u => u.ClientId == clientId).Select(m => new MeetingModel { Id = m.Id, ClientId = m.ClientId, Date = m.Date, Weight = m.Weight, Water = m.Water, Muscle = m.Muscle, FatPercentage = m.FatPercentage, MeetingIndex = m.MeetingIndex, ArmMuscleMeasurement = m.ArmMuscleMeasurement, ArmNOMuscleMeasurement = m.ArmNOMuscleMeasurement, HipMeasurement = m.HipMeasurement, StomachMeasurement = m.StomachMeasurement, ThighMeasurement = m.ThighMeasurement, FrontHandFat = m.FrontHandFat, BackHandFat = m.BackHandFat, ThighFat = m.ThighFat, BackFat = m.BackFat, FatAvrg = m.FatAvrg, }); var parser = new DataTableEntityParser<MeetingModel>(requestParams,MeetingList.AsQueryable()); var list = parser.Parse(); return list; } }); }