public async Task <IActionResult> PutTB_Category(int id, TB_Category tB_Category)
{
if (id != tB_Category.CategoryID)
{
return(BadRequest());
}
_context.Entry(tB_Category).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TB_CategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <TB_Category> > PostTB_Category(TB_Category tB_Category)
{
_context.TB_Category.Add(tB_Category);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTB_Category", new { id = tB_Category.CategoryID }, tB_Category));
}
public JsonResult Update(TB_Category ClassCategory)
{
var Result = DB.TB_Category.SingleOrDefault(Item => Item.ID == ClassCategory.ID);
Result.Name = ClassCategory.Name;
DB.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public bool UpdateCategory(TB_CategorySurrogate category)
{
using (MarketDBEntities db = new MarketDBEntities())
{
TB_Category c = db.TB_Category.FirstOrDefault(q => q.CategoryID == category.CategoryID);
if (c != null)
{
c.CategoryName = category.CategoryName;
db.SaveChanges();
return(true);
}
}
return(false);
}
public bool AddCategory(TB_CategorySurrogate category)
{
using (MarketDBEntities db = new MarketDBEntities())
{
TB_Category c = new TB_Category();
if (db.TB_Category.FirstOrDefault(q => q.CategoryName == category.CategoryName) == null)
{
c.CategoryName = category.CategoryName;
db.TB_Category.Add(c);
db.SaveChanges();
return(true);
}
}
return(false);
}
public bool DeleteCategory(int categoryID)
{
using (MarketDBEntities db = new MarketDBEntities())
{
TB_Category c = db.TB_Category.FirstOrDefault(q => q.CategoryID == categoryID);
if (c != null)
{
db.TB_Category.Remove(c);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public JsonResult SaveRecordBody(TB_Category ClassTbl_Emp)
{
DB.TB_Category.Add(ClassTbl_Emp);
DB.SaveChanges();
return(Json(ClassTbl_Emp.ID, JsonRequestBehavior.AllowGet));
}
public JsonResult Save(TB_Category ClassCategory)
{
DB.TB_Category.Add(ClassCategory);
DB.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public bool Delete(TB_Category TB_Category)
{
return(TB_Category.Delete(TB_Category));
}
public bool Update(TB_Category TB_Category)
{
return(TB_Category.Update(TB_Category));
}
public bool Add(TB_Category TB_Category)
{
return(TB_Category.Add(TB_Category));
}
public CategoryService(TB_Category TB_Category)
{
this._TB_Category = TB_Category;
}
