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;
}
});
}
