public async Task <ActionResult <AdminPutResponse> > PutAdmin(AdminPutRequest request)
{
if (!(await checkToken(request.username, request.token)))
{
return(BadRequest());
}
AdminPutResponse result = new AdminPutResponse();
using (var db = new NutrientContext())
{
NutrientModel model = await db.nutrients.FindAsync(request.id);
if (model == null)
{
return(NotFound());
}
DateTime dt = DateTime.Now;
model.approval = true;
model.approvaled_at = dt;
db.nutrients.Update(model);
await db.SaveChangesAsync();
result.token = await updateToken(request.username);
}
return(result);
}
public async Task <ActionResult <IEnumerable <NutrientGetResponse> > > GetNutrient(string word)
{
List <NutrientGetResponse> result = new List <NutrientGetResponse>();
using (var db = new NutrientContext())
{
var dbset = db.nutrients
.Where(x => x.approval == true);
if (word != null)
{
dbset = dbset.Where(x => x.name.Contains(word));
}
var ret = await dbset.OrderBy(x => x.name)
.ToListAsync();
foreach (NutrientModel item in ret)
{
NutrientGetResponse nutrient = new NutrientGetResponse();
nutrient.id = item.id;
nutrient.name = item.name;
nutrient.protein = item.protein;
nutrient.lipid = item.lipid;
nutrient.carbohydrate = item.carbohydrate;
nutrient.calorie = item.calorie;
result.Add(nutrient);
}
}
return(result);
}
public async Task <ActionResult> PostNutrient(NutrientPostRequest item)
{
using (var db = new NutrientContext())
{
NutrientModel model = new NutrientModel();
DateTime dt = DateTime.Now;
model.name = item.name;
model.protein = item.protein;
model.lipid = item.lipid;
model.carbohydrate = item.carbohydrate;
model.calorie = item.calorie;
model.created_at = dt;
model.updated_at = dt;
db.nutrients.Add(model);
await db.SaveChangesAsync();
}
return(NoContent());
}
public async Task <ActionResult <AdminPostResponse> > PostAdmin(AdminPostRequest request)
{
if (!(await checkToken(request.username, request.token)))
{
return(BadRequest());
}
AdminPostResponse result = new AdminPostResponse();
using (var db = new NutrientContext())
{
result.nutrients = new List <NutrientGetResponse>();
IEnumerable <NutrientModel> ret;
if (request.all == true)
{
ret = await db.nutrients
.ToListAsync();
}
else
{
ret = await db.nutrients
.Where(x => x.approval == true)
.ToListAsync();
}
foreach (NutrientModel item in ret)
{
NutrientGetResponse nutrient = new NutrientGetResponse();
nutrient.id = item.id;
nutrient.name = item.name;
nutrient.protein = item.protein;
nutrient.lipid = item.lipid;
nutrient.carbohydrate = item.carbohydrate;
nutrient.calorie = item.calorie;
result.nutrients.Add(nutrient);
}
result.token = await updateToken(request.username);
}
return(result);
}
public async Task <ActionResult <AdminDeleteResponse> > DeleteAdmin(AdminDeleteRequest request)
{
if (!(await checkToken(request.username, request.token)))
{
return(BadRequest());
}
AdminDeleteResponse result = new AdminDeleteResponse();
using (var db = new NutrientContext())
{
NutrientModel model = await db.nutrients.FindAsync(request.id);
if (model == null)
{
return(NotFound());
}
db.nutrients.Remove(model);
await db.SaveChangesAsync();
result.token = await updateToken(request.username);
}
return(result);
}
