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());
}
