public CategoryItem GetById(int id) { Mapper.CreateMap <Category_Master, CategoryItem>(); Category_Master objCat = dbContext.Category_Master.SingleOrDefault(m => m.Cat_id == id); CategoryItem objCatItem = Mapper.Map <CategoryItem>(objCat); return(objCatItem); }
public int Insert(CategoryItem model) { Mapper.CreateMap <CategoryItem, Category_Master>(); Category_Master objCat = Mapper.Map <Category_Master>(model); dbContext.Category_Master.Add(objCat); return(dbContext.SaveChanges()); }
public int Update(CategoryItem model) { Category_Master objCat = dbContext.Category_Master.SingleOrDefault(m => m.Cat_id == model.Cat_id); objCat.CatName = model.CatName; objCat.CatDesc = model.CatDesc; objCat.UpdatedDate = System.DateTime.Now; return(dbContext.SaveChanges()); }
public ActionResult Create([Bind(Include = "ID,Name,ShortName")] Category_Master category_Master) { try { //if (ModelState.IsValid) //{ var getName = db.Category_Master.Where(u => u.Name == category_Master.Name).ToList(); if (getName.Count > 0) { ViewBag.message = ToasterMessage.Message(ToastType.info, "Record already exist"); return(View()); } else { db.Category_Master.Add(category_Master); db.SaveChanges(); TempData["message"] = ToasterMessage.Message(ToastType.success, "Saved successfully"); return(RedirectToAction("Index")); } //} } catch (DbEntityValidationException e) { string errorMessage = string.Empty; foreach (DbEntityValidationResult eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (DbValidationError ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); errorMessage = ve.ErrorMessage; ViewBag.message = ViewBag.message + ToasterMessage.Message(ToastType.error, errorMessage); } } return(View()); } catch (Exception) { ViewBag.message = ToasterMessage.Message(ToastType.error, "Something went wrong"); } return(View()); }
// GET: Category_Master/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Category_Master category_Master = db.Category_Master.Find(id); if (category_Master == null) { return(HttpNotFound()); } return(View(category_Master)); }
public ActionResult DeleteConfirmed(decimal?id) { try { Category_Master category_Master = db.Category_Master.Find(id); db.Category_Master.Remove(category_Master); db.SaveChanges(); TempData["message"] = ToasterMessage.Message(ToastType.success, "Deleted successfully"); return(RedirectToAction("Index")); } catch (DbEntityValidationException e) { string errorMessage = string.Empty; foreach (DbEntityValidationResult eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (DbValidationError ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); errorMessage = ve.ErrorMessage; ViewBag.message = ViewBag.message + ToasterMessage.Message(ToastType.error, errorMessage); } } return(View()); } catch (Exception) { ViewBag.message = ToasterMessage.Message(ToastType.error, "Something went wrong"); } return(View()); }