public async Task <ActionResult> PostBrand(BrandQuery brand)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (brand.Logo != null && !Enum.GetNames(typeof(ImageExt))
.Contains(System.IO.Path.GetExtension(brand.Logo.FileName)
.Trim().ToUpper()))
{
return(BadRequest("File not supported"));
}
var dbBrand = await _repo.AddBrand(brand);
if (dbBrand != null)
{
if (brand.Logo != null)
{
await _repo.AssignLogo(brand.Logo, dbBrand.Id);
}
if (brand.Tags.Count > 0)
{
await _repo.AssignTags(brand.Tags, dbBrand.Id);
}
}
return(CreatedAtAction("GetBrand", new { id = dbBrand.Id }, dbBrand));
}
public ICollection <Resource.Brand> query(BrandQuery query)
{
IQueryable <DB.Models.Brand> brands = context.Brand.Where(query.asExpression());
brands = query.getOrdering(brands).Skip(query.page * query.results).Take(query.results);
return(mapper.Map <ICollection <DB.Models.Brand>, ICollection <API.Resource.Brand> >(brands.ToList()));
}
public DbQueryResult Query(BrandQuery query)
{
StringBuilder stringBuilder = new StringBuilder("1=1 ");
if (!string.IsNullOrEmpty(query.Name))
{
stringBuilder.AppendFormat("and BrandName like '%{0}%' ", query.Name);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_BrandCategories", "BrandId", stringBuilder.ToString(), "*"));
}
public async Task <Brand> EditBrand(BrandQuery brand)
{
//TODO: see if extension is not supported
//
var dbBrand = await GetBrandById(brand.Id);
dbBrand.Name = brand.Name;
await _context.SaveChangesAsync();
return(dbBrand);
}
public async Task <Brand> AddBrand(BrandQuery bToCreate)
{
Brand brand = new Brand();
if (bToCreate.CategoryId == null)
{
throw new Exception("category required");
}
Category cat = await _context.Categories.FindAsync(bToCreate.CategoryId);
brand.Category = cat;
_context.Brands.Add(brand);
await _context.SaveChangesAsync();
return(brand);
}
public static DbQueryResult GetBrandQuery(BrandQuery query)
{
return((new BrandCategoryDao()).Query(query));
}
public JsonResult Query([FromQuery][Bind] BrandQuery query)
{
return(Json(_brandRepo.query(query)));
}
