public ActionResult Update(MProductVM model) { if (ModelState.IsValid) { if (MProductRepo.CheckIfExists(model) == true) { var notif = new { success = false, alertType = "error", alertMessage = "ERROR !", alertStrong = "Your Data With Name (" + model.name + ") is Already Exists" }; return(Json(notif, JsonRequestBehavior.AllowGet)); } else { MProductRepo.Update(model); var result = new { success = true, alertType = "info", alertMessage = "Updated !", alertStrong = "Your Data With Code <strong>(" + model.code + ")</strong> is Updated" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } return(PartialView("_Update")); }
public static bool CheckIfExists(MProductVM model) { bool res = false; using (AppEntity db = new AppEntity()) { var data = db.m_product.Where(x => x.name == model.name && x.id != model.id).ToList(); if (data.Count > 0) { res = true; } } return(res); }
public static bool Update(MProductVM model) { bool res = false; using (AppEntity db = new AppEntity()) { m_product data = db.m_product.Find(model.id); data.code = model.code; data.name = model.name; data.description = model.description; data.updated_by = 1; data.updated_date = DateTime.Now; try { db.SaveChanges(); res = true; } catch (Exception) { throw; } } return(res); }
public static bool Insert(MProductVM model, string userID) { bool res = false; using (AppEntity db = new AppEntity()) { m_product data = new m_product() { code = model.code, name = model.name, description = model.description, created_by = 1, created_date = DateTime.Now, is_active = true }; db.m_product.Add(data); try { db.SaveChanges(); res = true; } catch (Exception) { throw; } } return(res); }
public static MProductVM GetId(int id) { var data = new MProductVM(); using (AppEntity db = new AppEntity()) { data = db.m_product.Select(x => new MProductVM() { id = x.id, code = x.code, name = x.name, description = x.description, is_active = x.is_active, created_by = x.created_by, created_date = x.created_date, updated_by = x.updated_by, updated_date = x.updated_date }) .Where(x => x.id == id) .FirstOrDefault(); } return(data); }