// GET: RoleOptions
public ActionResult Index(int?id)
{
try
{
if (DataUtil.Validation())
{
if (id == null)
{
id = 0;
}
RoleOptionView objRoleOptionView = new RoleOptionView();
objRoleOptionView.roleOptionList = db.RoleOption.Include(u => u.option).Include(u => u.role).Where(u => u.role.roleID == id).ToList();
objRoleOptionView.options = db.Database.SqlQuery <Option>("select o.optionid, o.name, CAST(ISNULL((select 1 from roleOptions ro where ro.roleID = @roleID and ro.optionID = o.optionID),0) AS BIT) selected, o.active, o.createdate, o.createuser, o.updatedate, o.updateuser from options o where o.active = 1", new SqlParameter("@roleID", id)).ToList();
objRoleOptionView.role = db.Role.Find(id);
return(View(objRoleOptionView));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "RoleOptions";
objError.option = "Index-1";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Index(RoleOptionView objRoleOptionView)
{
try
{
if (DataUtil.Validation())
{
RoleOptionView objRoleOptionView2 = new RoleOptionView();
try
{
if (Request.Form["ActionForm"] == "Registrar")
{
var RemoveAll = db.RoleOption.Where(x => x.roleID == objRoleOptionView.role.roleID);
db.RoleOption.RemoveRange(RemoveAll);
db.SaveChanges();
RoleOption objRoleOption = new RoleOption();
foreach (var item in objRoleOptionView.options)
{
if (item.selected)
{
objRoleOption.roleID = objRoleOptionView.role.roleID;
objRoleOption.optionID = item.optionID;
db.RoleOption.Add(objRoleOption);
db.SaveChanges();
}
}
objRoleOptionView2.roleOptionList = db.RoleOption.Include(u => u.option).Include(u => u.role).Where(u => u.role.roleID == objRoleOptionView.role.roleID).ToList();
objRoleOptionView2.options = db.Database.SqlQuery <Option>("select o.optionid, o.name, CAST(ISNULL((select 1 from roleOptions ro where ro.roleID = @roleID and ro.optionID = o.optionID),0) AS BIT) selected, o.active, o.createdate, o.createuser, o.updatedate, o.updateuser from options o where o.active = 1", new SqlParameter("@roleID", objRoleOptionView.role.roleID)).ToList();
objRoleOptionView2.role = db.Role.Find(objRoleOptionView.role.roleID);
ModelState.Clear();
}
}
catch (Exception ex)
{
}
return(View(objRoleOptionView2));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "RoleOptions";
objError.option = "Index-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
// GET: RoleOptions
public ActionResult Index(int?id)
{
if (DataUtil.Validation())
{
if (id == null)
{
id = 0;
}
RoleOptionView objRoleOptionView = new RoleOptionView();
objRoleOptionView.roleOptionList = db.RoleOption.Include(u => u.option).Include(u => u.role).Where(u => u.role.roleID == id).ToList();
objRoleOptionView.options = db.Database.SqlQuery <Option>("select o.optionid, o.name, CAST(ISNULL((select 1 from roleOptions ro where ro.roleID = @roleID and ro.optionID = o.optionID),0) AS BIT) selected, o.active, o.createdate, o.createuser, o.updatedate, o.updateuser from options o where o.active = 1", new SqlParameter("@roleID", id)).ToList();
objRoleOptionView.role = db.Role.Find(id);
return(View(objRoleOptionView));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
