public void insertcategory(categoryviewmodel item) { category c = new category(); c.cat_id = item.cat_id; c.cat_name = item.cat_name; c.cat_createon = item.cat_createon; c.cat_icon = item.cat_icon; c.cat_fk_ad_id = item.cat_fk_ad_id; db.categories.Add(c); db.SaveChanges(); }
public void editcategory(categoryviewmodel item) { category c = db.categories.Where(x => x.cat_id == item.cat_id).SingleOrDefault(); c.cat_id = item.cat_id; c.cat_name = item.cat_name; c.cat_createon = item.cat_createon; c.cat_icon = item.cat_icon; c.cat_fk_ad_id = item.cat_fk_ad_id; db.categories.Add(c); db.SaveChanges(); }
public categoryviewmodel getcategorybyid(int id) { category item = db.categories.Where(x => x.cat_id == id).SingleOrDefault(); categoryviewmodel c = new categoryviewmodel(); c.cat_id = item.cat_id; c.cat_name = item.cat_name; c.cat_createon = item.cat_createon; c.cat_icon = item.cat_icon; c.cat_fk_ad_id = item.cat_fk_ad_id; return(c); }
public ActionResult category(categoryviewmodel obj) { tbl_category t = new tbl_category(); t.cat_name = obj.cat_name; db.tbl_category.Add(t); db.SaveChanges(); return(RedirectToAction("Index")); return(View()); }
public List <categoryviewmodel> viewcategory() { List <categoryviewmodel> li = new List <categoryviewmodel>(); List <category> cat = db.categories.ToList(); foreach (var item in cat) { categoryviewmodel c = new categoryviewmodel(); c.cat_id = item.cat_id; c.cat_name = item.cat_name; c.cat_createon = item.cat_createon; c.cat_icon = item.cat_icon; c.cat_fk_ad_id = item.cat_fk_ad_id; li.Add(c); } return(li); }