public ActionResult Create(user_rightViewModel user_right) { if (ModelState.IsValid) { foreach (var mn in user_right.ms_menus) { ms_user_rights rights = new ms_user_rights() { user_rights_id = user_right.user_type.user_type_id, job_level_id = user_right.job_level.job_level_id, menu_id = mn.menu_id, fl_active = true, created_date = DateTime.Now, created_by = 0, updated_date = DateTime.Now, updated_by = 1, deleted_date = null, deleted_by = null, org_id = 0 }; db.ms_user_rights.Add(rights); db.SaveChanges(); } } //ViewBag.job_level_id = new SelectList(db.ms_job_level, "job_level_id", "job_level_code", user_right.job_level.job_level_id); //ViewBag.user_type_id = new SelectList(db.ms_user_type, "user_type_id", "user_type_code", user_right.user_type.user_type_id); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { ms_user_rights ms_user_rights = db.ms_user_rights.Find(id); db.ms_user_rights.Remove(ms_user_rights); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: user_rights/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ms_user_rights ms_user_rights = db.ms_user_rights.Find(id); if (ms_user_rights == null) { return(HttpNotFound()); } return(View(ms_user_rights)); }
// GET: user_rights/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ms_user_rights ms_user_rights = db.ms_user_rights.Find(id); if (ms_user_rights == null) { return(HttpNotFound()); } ViewBag.job_level_id = new SelectList(db.ms_job_level, "job_level_id", "job_level_code", ms_user_rights.job_level_id); ViewBag.user_type_id = new SelectList(db.ms_user_type, "user_type_id", "user_type_code", ms_user_rights.user_type_id); return(View(ms_user_rights)); }
public ActionResult Edit([Bind(Include = "menu_id,user_type_id,job_level_id")] ms_user_rights ms_user_rights) { if (ModelState.IsValid) { ms_user_rights.fl_active = true; ms_user_rights.updated_date = DateTime.Now; ms_user_rights.updated_by = 1; ms_user_rights.deleted_date = null; ms_user_rights.deleted_by = null; ms_user_rights.org_id = 0; db.Entry(ms_user_rights).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.job_level_id = new SelectList(db.ms_job_level, "job_level_id", "job_level_code", ms_user_rights.job_level_id); ViewBag.user_type_id = new SelectList(db.ms_user_type, "user_type_id", "user_type_code", ms_user_rights.user_type_id); return(View(ms_user_rights)); }
public ActionResult Create(user_rightViewModel user_right) { string _ids = Request.Form["menu_id"]; if (string.IsNullOrWhiteSpace(_ids)) { user_right.selected_menu_id_str = "0,0"; } else { user_right.selected_menu_id_str = _ids; } if (ModelState.IsValid) { ms_user_rights[] _objs = (from m in db.ms_user_rights where m.job_level_id == user_right.job_level_id && m.user_type_id == user_right.user_type_id select m).ToArray(); if (_objs.Length > 0) { IEnumerable <ms_user_rights> _ur = db.ms_user_rights.RemoveRange(_objs); db.SaveChanges(); } ms_user_type user_type_db = db.ms_user_type.Single(u => u.user_type_id == user_right.user_type_id); if (user_type_db == null) { throw new Exception("Unknown User Right"); } ms_job_level job_level_db = db.ms_job_level.Single(u => u.job_level_id == user_right.job_level_id); if (job_level_db == null) { throw new Exception("Unknown Job Level"); } string[] arr_menu_id = user_right.selected_menu_id_str.Split(new char[1] { ',' }); bool bool_menu = false; int menu_counter = 0; foreach (var menu_id_string in arr_menu_id) { int menu_id_int = Convert.ToInt32(menu_id_string); ms_menu menu_db = db.ms_menu.Single(m => m.menu_id == menu_id_int); bool_menu = (menu_db != null); if (bool_menu) { menu_counter++; ms_user_rights rights = new ms_user_rights() { user_type_id = user_right.user_type_id, job_level_id = user_right.job_level_id, menu_id = menu_id_int, fl_active = true, created_date = DateTime.Now, created_by = UserProfile.UserId, updated_date = DateTime.Now, updated_by = UserProfile.UserId, deleted_date = null, deleted_by = null, org_id = UserProfile.OrgId }; db.ms_user_rights.Add(rights); } } if (menu_counter > 0) { db.SaveChanges(); } return(RedirectToAction("Index")); } List <ms_job_level> ds_job = db.ms_job_level.Where(m => m.fl_active == true && m.deleted_date == null).ToList(); ms_job_level jl_opt = new ms_job_level { job_level_id = 0, job_level_code = "Select", job_level_name = "-- Select Job Level --" }; ds_job.Add(jl_opt); var job_level_ddl = new SelectList(ds_job, "job_level_id", "job_level_name", jl_opt); ViewBag.job_level_id = job_level_ddl; List <ms_user_type> ds_user_type = db.ms_user_type.Where(m => m.fl_active == true && m.deleted_date == null).ToList(); ms_user_type ut_opt = new ms_user_type { user_type_id = 0, user_type_code = "Select", user_type_name = "-- Select User Right --" }; ds_user_type.Add(ut_opt); var user_type_ddl = new SelectList(ds_user_type, "user_type_id", "user_type_name", ut_opt); ViewBag.user_type_id = user_type_ddl; //ViewBag.job_level_id = new SelectList(db.ms_job_level, "job_level_id", "job_level_name", user_right.job_level_id); //ViewBag.user_type_id = new SelectList(db.ms_user_type, "user_type_id", "user_type_name", user_right.user_type_id); return(View("Create", user_right)); }