private IQueryable <MakerModel> QueryMakerModel(DataContext dbContext, BaseParameterModel parameter, bool pageControl = false)
{
IQueryable <MakerModel> query = dbContext.MakerModels.OrderBy(x => x.Id);
if (!parameter.Deleted)
{
query = query.Where(x => x.Deleted == false);
}
if (parameter.Enabled)
{
query = query.Where(x => x.Enabled == true);
}
if (pageControl)
{
if (parameter.Limit.HasValue && parameter.Limit.GetValueOrDefault() > 0)
{
if (parameter.Page.HasValue && parameter.Page.GetValueOrDefault() >= 0)
{
query = query.Skip(parameter.Limit.GetValueOrDefault() * parameter.Page.GetValueOrDefault()).Take(parameter.Limit.GetValueOrDefault());
}
else
{
query = query.Take(parameter.Limit.GetValueOrDefault());
}
}
}
return(query);
}
public IHttpActionResult GetGroupList(int id, [FromUri] BaseParameterModel param)
{
try
{
if (id <= 0)
{
return(BadRequest());
}
var maker = repository.GetMakerByIdForInterface(id);
if (maker.Code != HttpStatusCode.OK)
{
return(BadRequest());
}
var parameter = new CustomParameterModel();
parameter.MakerId = id;
parameter.Deleted = param.Deleted;
var result = groupRepository.GetGroupsForInterface(parameter);
if (result == null || result.Count() == 0)
{
return(NotFound());
}
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult Get([FromUri] BaseParameterModel param)
{
try
{
using (DataContext dbContext = DataContext.Create())
{
IQueryable <DashboardModel> query = dbContext.DashboardModels.OrderBy(x => x.Id);
if (!param.Deleted)
{
query = query.Where(x => x.Deleted == false);
}
if (param.Enabled)
{
query = query.Where(x => x.StartDateTime <= DateTime.Now);
query = query.Where(x => x.EndDateTime >= DateTime.Now);
}
var result = query.ToList();
if (result == null || result.Count == 0)
{
return(NotFound());
}
return(Ok(result));
}
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public object GetMakersPages(BaseParameterModel parameter)
{
try
{
if (parameter == null)
{
return(null);
}
if (!parameter.Limit.HasValue)
{
return(null);
}
else if (parameter.Limit.GetValueOrDefault() <= 0)
{
return(null);
}
using (DataContext dbContext = DataContext.Create())
{
int maxcount = 0;
int maxpages = 0;
IQueryable <MakerModel> query = QueryMakerModel(dbContext, parameter);
maxcount = query.Count();
maxpages = CountToPages(maxcount, parameter.Limit.GetValueOrDefault());
return(new { count = maxcount, pages = maxpages });
}
}
catch (Exception ex)
{
throw ex;
}
}
public ParameterModel MapUp(BaseParameterModel model)
{
ParameterModel parameterModel = new ParameterModel();
parameterModel.Name = model.Name;
Type type = model.GetType();
PropertyInfo typeProperty = type.GetProperty("Type",
BindingFlags.Instance | BindingFlags.Public | BindingFlags.DeclaredOnly);
BaseTypeModel typeModel = (BaseTypeModel)typeProperty?.GetValue(model);
if (typeModel != null)
{
parameterModel.Type = TypeModelMapper.EmitType(typeModel);
}
return(parameterModel);
}
public IHttpActionResult Get([FromUri] BaseParameterModel param)
{
try
{
var result = repository.GetMakersForInterface(param);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult GetMakerMaxPages([FromUri] BaseParameterModel param)
{
try
{
var result = repository.GetMakersPages(param);
if (result == null)
{
return(BadRequest());
}
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IEnumerable <MakerInterfaceModel> GetMakersForInterface(BaseParameterModel parameter)
{
try
{
using (DataContext dbContext = DataContext.Create())
{
IQueryable <MakerModel> query = QueryMakerModel(dbContext, parameter, true);
var result = query.ProjectTo <MakerInterfaceModel>().ToList();
if (result == null || result.Count == 0)
{
return(null);
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public object GetUsersPages(BaseParameterModel parameter)
{
try
{
if (parameter == null)
{
return(null);
}
if (!parameter.Limit.HasValue)
{
return(null);
}
else if (parameter.Limit.GetValueOrDefault() <= 0)
{
return(null);
}
using (DataContext dbContext = DataContext.Create())
{
int maxcount = 0;
int maxpages = 0;
IQueryable <UserModel> query;
query = dbContext.UserModels.OrderBy(x => x.Id);
if (!parameter.Deleted)
{
query = query.Where(x => x.Deleted == false);
}
if (parameter.Enabled)
{
query = query.Where(x => x.Enabled == true);
}
maxcount = query.Count();
maxpages = CountToPages(maxcount, parameter.Limit.GetValueOrDefault());
return(new { count = maxcount, pages = maxpages });
}
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <RoleInterfaceModel> GetRolesForInterface(BaseParameterModel parameter, bool isAdmin = false)
{
try
{
IQueryable <RoleModel> query = AppRoleManager.Roles.OrderBy(x => x.Id);
if (!isAdmin)
{
query = query.Where(r => r.Name != "admin");
}
if (!parameter.Deleted)
{
query = query.Where(x => x.Deleted == false);
}
if (parameter.Limit.HasValue)
{
if (parameter.Page.HasValue)
{
query = query.Skip((int)parameter.Limit * (int)parameter.Page).Take((int)parameter.Limit);
}
else
{
query = query.Take((int)parameter.Limit);
}
}
var result = query.ProjectTo <RoleInterfaceModel>().ToList();
if (result == null || result.Count == 0)
{
return(null);
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <UserInterfaceModel> GetUsersForInterface(BaseParameterModel parameter)
{
try
{
IQueryable <UserModel> query = AppUserManager.Users.OrderBy(x => x.Id);
if (!parameter.Deleted)
{
query = query.Where(x => x.Deleted == false);
}
if (parameter.Enabled)
{
query = query.Where(x => x.Enabled == true);
}
if (parameter.Limit.HasValue)
{
if (parameter.Page.HasValue)
{
query = query.Skip((int)parameter.Limit * (int)parameter.Page).Take((int)parameter.Limit);
}
else
{
query = query.Take((int)parameter.Limit);
}
}
var result = query.ProjectTo <UserInterfaceModel>().ToList();
if (result == null || result.Count == 0)
{
return(null);
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult Get([FromUri] BaseParameterModel param)
{
try
{
using (DataContext dbContext = DataContext.Create())
{
IQueryable <ContainerModel> query = dbContext.ContainerModels.OrderBy(x => x.Id);
if (!param.Deleted)
{
query = query.Where(x => x.Deleted == false);
}
if (param.Limit.HasValue)
{
if (param.Page.HasValue)
{
query = query.Skip(param.Limit.GetValueOrDefault() * param.Page.GetValueOrDefault()).Take(param.Limit.GetValueOrDefault());
}
else
{
query = query.Take(param.Limit.GetValueOrDefault());
}
}
var result = query.ProjectTo <ContainerInterfaceModel>().ToList();
if (result == null || result.Count == 0)
{
return(NotFound());
}
return(Ok(result));
}
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult GetSalesViews(int id, int year, [FromUri] BaseParameterModel param)
{
return(StatusCode(HttpStatusCode.MethodNotAllowed));
}
