public async Task <IActionResult> Create([Bind("BookId,Price,Ammount")] PurchasesHistory purchaseshistory)
{
if (ModelState.IsValid)
{
await purchasesHistoryService.Create(purchaseshistory);
return(RedirectToAction(nameof(Index)));
}
return(View(purchaseshistory));
}
protected override OpResult _Store(PurchasesHistory _obj)
{
if (_obj == null)
{
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "PurchasesHistory object cannot be created as it is null"));
}
if (Exists(_obj))
{
ExecuteNonQuery(GetQuery_UpdateQuery(_obj));
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj));
}
ExecuteNonQuery(GetQuery_InsertQuery(_obj));
if (_obj.PurchasesHistoryID == null)
{
_obj.PurchasesHistoryID = DbMgr.GetLastInsertID();
}
_obj.FromDb = true;
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj));
}
private DbUpdateStatement GetQuery_UpdateQuery(PurchasesHistory _obj)
{
return(DbMgr.CreateUpdateClause("PurchasesHistory", GetFields(_obj), "PurchasesHistoryID", _obj.PurchasesHistoryID));
}
private DbInsertStatement GetQuery_InsertQuery(PurchasesHistory _obj)
{
Dictionary <string, DbFieldEntry> fields = GetFields(_obj);
return(DbMgr.CreateInsertClause("PurchasesHistory", fields));
}
public async Task Create(PurchasesHistory purchasehistory)
{
_context.Add(purchasehistory);
await _context.SaveChangesAsync();
}
