public RoleActionVM GetRoleActionsEdit(int RoleId)
{
var actionids = (from l in db.RoleActionRelations
where l.RId == RoleId
select l.AId).ToArray();
RoleActionVM r = new RoleActionVM();
r.ActionId = actionids;
var roleactiondata = (from rm in db.RoleMasters
join ra in db.RoleActionRelations
on rm.RoleId equals ra.RId
where rm.RoleId == ra.RId
select new
{
RoleId = ra.RId,
RoleName = rm.RoleName,
IsActive = rm.IsValid,
CreatedBy = rm.CreatedBy,
CreatedDate = rm.CreatedDate,
}).FirstOrDefault();
r.RoleId = roleactiondata.RoleId;
r.IsActive = roleactiondata.IsActive;
r.RoleName = roleactiondata.RoleName;
r.CreatedBy = roleactiondata.CreatedBy;
r.CreatedDate = roleactiondata.CreatedDate;
return(r);
}
public void InsertAction(RoleActionVM Roleaction, int[] actions)
{
db.spRoleActionInsert(
Roleaction.RoleId,
Roleaction.RoleName,
Roleaction.IsActive,
Roleaction.CreatedBy = 1, //(int)HttpContext.Current.Session["userid"],
Roleaction.ModifiedBy,
Roleaction.CreatedDate = DateTime.Now,
Roleaction.ModifiedDate,
string.Join(",", actions)
);
db.SaveChanges();
}
//[CustomAuthorization("ReportUploader,ReportCreater", "Create,Delete")]
public ActionResult RoleActionCreate(RoleActionVM roleaction, int[] actions)
{
if (ModelState.IsValid)
{
try
{
_ObjRoleActionRepository.InsertAction(roleaction, actions);
return(RedirectToAction("RoleActionIndex", "RoleAction"));
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
return(View("RoleActionIndex"));
}
