public ActionResult DeleteConfirmed(int id)
{
ms_job_level ms_job_level = db.ms_job_level.Find(id);
db.ms_job_level.Remove(ms_job_level);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "job_level_id,job_level_code,job_level_name,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] ms_job_level ms_job_level)
{
if (ModelState.IsValid)
{
db.Entry(ms_job_level).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ms_job_level));
}
public ActionResult Create([Bind(Include = "job_level_id,job_level_code,job_level_name,fl_active,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,org_id")] ms_job_level ms_job_level)
{
if (ModelState.IsValid)
{
db.ms_job_level.Add(ms_job_level);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ms_job_level));
}
// GET: job_level/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ms_job_level ms_job_level = db.ms_job_level.Find(id);
if (ms_job_level == null)
{
return(HttpNotFound());
}
return(View(ms_job_level));
}
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));
}
public JsonResult CrudJobLevel()
{
if (Request.Form["oper"] == "add")
{
//prepare for insert data
ms_job_level ms_job_level = new ms_job_level();
ms_job_level.job_level_code = Request.Form["job_level_code"];
ms_job_level.job_level_name = Request.Form["job_level_name"];
ms_job_level.fl_active = Request.Form["rec_isactive"].ToLower().Equals("yes");
ms_job_level.created_by = UserProfile.UserId;
ms_job_level.created_date = DateTime.Now;
ms_job_level.updated_by = UserProfile.UserId;
ms_job_level.updated_date = DateTime.Now;
ms_job_level.org_id = UserProfile.OrgId;
ms_job_level.deleted_by = null;
ms_job_level.deleted_date = null;
db.ms_job_level.Add(ms_job_level);
db.SaveChanges();
return(Json("Insert Job Level Data Success!", JsonRequestBehavior.AllowGet));
}
else if (Request.Form["oper"] == "edit")
{
if (IsNumeric(Request.Form["job_level_id"].ToString()))
{
//prepare for update data
int id = Convert.ToInt32(Request.Form["job_level_id"]);
ms_job_level ms_job_level = db.ms_job_level.Find(id);
ms_job_level.job_level_code = Request.Form["job_level_code"];
ms_job_level.job_level_name = Request.Form["job_level_name"];
ms_job_level.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
ms_job_level.updated_by = UserProfile.UserId;
ms_job_level.updated_date = DateTime.Now;
ms_job_level.org_id = UserProfile.OrgId;
ms_job_level.deleted_by = null;
ms_job_level.deleted_date = null;
db.SaveChanges();
return(Json("Update Job Level Data Success!", JsonRequestBehavior.AllowGet));
}
else
{
//prepare for insert data
ms_job_level ms_job_level = new ms_job_level();
ms_job_level.job_level_code = Request.Form["job_level_code"];
ms_job_level.job_level_name = Request.Form["job_level_name"];
ms_job_level.fl_active = Request.Form["rec_isactive"] == "Yes" ? true : false;
ms_job_level.created_by = UserProfile.UserId;
ms_job_level.created_date = DateTime.Now;
ms_job_level.updated_by = UserProfile.UserId;
ms_job_level.updated_date = DateTime.Now;
ms_job_level.org_id = UserProfile.OrgId;
ms_job_level.deleted_by = null;
ms_job_level.deleted_date = null;
db.ms_job_level.Add(ms_job_level);
db.SaveChanges();
return(Json("Insert Job Level Data Success!", JsonRequestBehavior.AllowGet));
}
}
else
{
if (Request.Form["oper"] == "del")
{
//for delete process
string ids = Request.Form["id"];
string[] values = ids.Split(',');
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
//prepare for soft delete data
int id = Convert.ToInt32(values[i]);
ms_job_level ms_job_level = db.ms_job_level.Find(id);
ms_job_level.fl_active = false;
ms_job_level.deleted_by = UserProfile.UserId; //userid
ms_job_level.deleted_date = DateTime.Now;
db.SaveChanges();
}
}
return(Json("Deleted Success!"));
}
}
