public RoleNRightManagementController()
{
_mainMenuBAL = new MainMenuBAL();
_roleBAL = new RolesBAL();
_rolesNRightsBAL = new RolesNRightsBAL();
_manageRoleNRightsViewModel = new ManageRoleNRightsViewModel();
result = new Result();
}
public ActionResult SaveRoleNRights(ManageRoleNRightsViewModel manageRoleNRightsViewModel)
{
result = _rolesNRightsBAL.SaveRoleNRights(manageRoleNRightsViewModel);
return(RedirectToAction("ManageRoleNRights", new { RoleID = manageRoleNRightsViewModel.RoleID }));
}
public Result SaveRoleNRights(ManageRoleNRightsViewModel manageRoleNRightsViewModel)
{
Result result = new Result();
DBOperations dbOps = new DBOperations();
try
{
foreach (var item in manageRoleNRightsViewModel.RolesNRightsViewMdoels)
{
int res;
NpgsqlParameter[] aParams1 = new NpgsqlParameter[1];
aParams1[0] = new NpgsqlParameter("RNRID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams1[0].Value = item.RNRID;
long count = (long)dbOps.ExecuteScalar(AppConstants.QueryConstants.CheckRolesNRights, aParams1);
if (count > 0)
{
NpgsqlParameter[] aParams = new NpgsqlParameter[6];
aParams[0] = new NpgsqlParameter("RoleID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = manageRoleNRightsViewModel.RoleID;
aParams[1] = new NpgsqlParameter("ActionID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = item.ActionID;
aParams[2] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[2].Value = item.IsActive;
aParams[3] = new NpgsqlParameter("LastModifiedBy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = 0;
aParams[4] = new NpgsqlParameter("LastModifiedOn", NpgsqlTypes.NpgsqlDbType.Date);
aParams[4].Value = DateTime.Now;
aParams[5] = new NpgsqlParameter("RNRID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[5].Value = item.RNRID;
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.UpdateRolesNRights, aParams);
}
else
{
NpgsqlParameter[] aParams = new NpgsqlParameter[5];
aParams[0] = new NpgsqlParameter("RoleID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[0].Value = manageRoleNRightsViewModel.RoleID;
aParams[1] = new NpgsqlParameter("ActionID", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[1].Value = item.ActionID;
aParams[2] = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
aParams[2].Value = item.IsActive;
aParams[3] = new NpgsqlParameter("CreatedBy", NpgsqlTypes.NpgsqlDbType.Integer);
aParams[3].Value = 0;
aParams[4] = new NpgsqlParameter("CreatedOn", NpgsqlTypes.NpgsqlDbType.Date);
aParams[4].Value = DateTime.Now;
res = dbOps.ExecuteNonQuery(AppConstants.QueryConstants.AddRolesNRights, aParams);
}
if (res > 0)
{
result.Status = Status.Success;
result.Values = res.ToString();
}
else
{
result.Status = Status.Failure;
}
}
}
catch (Exception Ex)
{
dbOps.Abort();
result.Status = Status.Failure;
}
return(result);
}
