public ActionResult Edit([Bind(Include = "ID,Name,UserLogin,UserPassword,UgID,TelNo,Email")] Staff staff) { if (ModelState.IsValid) { db.Entry(staff).State = EntityState.Modified; db.SaveChanges(); StaffID = staff.ID; //Delete old data StaffWarehouse sf = db.StaffWarehouses.Find(StaffID); db.StaffWarehouses.Remove(sf); db.SaveChanges(); staff.StWh.RemoveAt(0); foreach (var a in staff.StWh) { StaffWarehouse SW = new StaffWarehouse(); SW.StID = StaffID; SW.WhID = a.WhID; SW.IsManager = a.IsManager; db.StaffWarehouses.Add(SW); db.SaveChanges(); } return(Json("success")); } ViewBag.ID = new SelectList(db.UserGroups, "ID", "Name", staff.ID); return(View(staff)); }
public ActionResult InsertStaff(Staff model) { using (DLSMEntities context = new DLSMEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { Staff w = context.Staffs.Where(p => p.UserLogin == model.UserLogin).FirstOrDefault(); if (w != null) { return(Json("UserLogin นี้มีอยู่แล้วในระบบ")); } model.UserPassword = Hash(model.UserPassword); context.Staffs.Add(model); context.SaveChanges(); StaffID = model.ID; model.StWh.RemoveAt(0); foreach (var a in model.StWh) { StaffWarehouse SW = new StaffWarehouse(); SW.StID = StaffID; SW.WhID = a.WhID; SW.IsManager = a.IsManager; context.StaffWarehouses.Add(SW); } context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); return(Json(ex.InnerException.Message)); } } } return(Json(StaffID)); }
public ActionResult DeleteConfirmed(int id) { var context = new DLSMEntities(); StaffWarehouse st = context.StaffWarehouses.Where(p => p.WhID == id).FirstOrDefault(); Stock s = context.Stocks.Where(p => p.WhID == id).FirstOrDefault(); if (st != null || s != null) { // Cannot delete becasue Topic group is using another process TempData["Msg"] = "ลบไม่ได้ เนื่องจากข้อมูลนี้มีการถูกใช้งานอยู่"; return(RedirectToAction("Edit", new { id = id, ViewBag.Msg })); } else { Warehouse warehouse = db.Warehouses.Find(id); db.Warehouses.Remove(warehouse); db.SaveChanges(); TempData["Msg"] = "ลบข้อมูลเรียบร้อยแล้ว"; } return(RedirectToAction("Index")); }
public JsonResult EditStaff(Staff staff) { using (DLSMEntities context = new DLSMEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { if (staff != null && staff.ID != 0) { Staff w = context.Staffs.Where(p => (p.UserLogin == staff.UserLogin) && (p.ID != staff.ID)).FirstOrDefault(); if (w != null) { return(Json("UserLogin นี้มีอยู่แล้วในระบบ")); } if (staff.NewUserPassword != null && staff.NewUserPassword != "") { staff.UserPassword = Hash(staff.NewUserPassword); } context.Entry(staff).State = EntityState.Modified; context.SaveChanges(); StaffID = staff.ID; context.StaffWarehouses.RemoveRange(context.StaffWarehouses.Where(x => x.StID == StaffID)); context.SaveChanges(); staff.StWh.RemoveAt(0); foreach (var a in staff.StWh) { StaffWarehouse SW = new StaffWarehouse(); SW.StID = StaffID; SW.WhID = a.WhID; SW.IsManager = a.IsManager; context.StaffWarehouses.Add(SW); } context.SaveChanges(); //Update some data Referance with Authorize var updRef = (from rf in context.Staffs where rf.RefAuthorize == staff.ID select rf).ToList(); foreach (var i in updRef) { i.TitleTH = staff.TitleTH; i.AuthorizeNameTH = staff.AuthorizeNameTH; i.AuthorizeLastNameTH = staff.AuthorizeLastNameTH; i.TitleEN = staff.TitleEN; i.AuthorizeNameEN = staff.AuthorizeNameEN; i.AuthorizeLastNameEN = staff.AuthorizeLastNameEN; i.Signature = staff.Signature; i.AuthorityType = staff.AuthorityType; i.AuthorizeIdCard = staff.AuthorizeIdCard; } context.SaveChanges(); dbContextTransaction.Commit(); } } catch (Exception ex) { dbContextTransaction.Rollback(); return(Json(ex.InnerException.Message)); } } } return(Json(StaffID)); }