public ActionResult EditRole(int iRoleId)
{
RolesBAL objRolesBAL = new RolesBAL();
RolesBO objRolesBO = objRolesBAL.EditRole(iRoleId);
return(PartialView("AddRole", objRolesBO));
}
public List <RolesBO> getRolesList()
{
DataSet objDataSet = null;
RolesBO objRolesBO = null;
List <RolesBO> objRolesBOList = new List <RolesBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetRolesList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objRolesBO = new RolesBO();
objRolesBO.RoleId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objRolesBO.RoleName = objDataSet.Tables[0].Rows[i][1].ToString();
objRolesBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][2].ToString());
objRolesBOList.Add(objRolesBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getRolesList");
throw ex;
}
return(objRolesBOList);
}
public RolesBO EditRole(int iRoleId)
{
DataSet objDataSet = null;
RolesBO objRolesBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iRoleId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iRoleId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditRole, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objRolesBO = new RolesBO();
objRolesBO.RoleId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objRolesBO.RoleName = objDataSet.Tables[0].Rows[0][1].ToString();
objRolesBO.Description = objDataSet.Tables[0].Rows[0][2].ToString();
objRolesBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][3].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditRole");
throw ex;
}
return(objRolesBO);
}
public JsonResult saveRole(RolesBO Data)
{
RolesBAL objRolesBAL = new RolesBAL();
Data.IsActive = true;
string strResult = objRolesBAL.SaveorUpdateRole(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
ViewBag.MainTitle = "Roles";
ViewBag.Title = "My Pages";
ViewBag.Icon = "fa fa-user";
RolesBO objRolesBO = new RolesBO();
return(View(objRolesBO));
}
public void AddRole(RoleBO roleBO)
{
if (RolesBO.Contains(roleBO))
{
return;
}
RolesBO.Add(roleBO);
}
public void RemoveRole(RoleBO role)
{
if (!role.RoleName.Contains("admin") && RolesBO != null)
{
if (RolesBO.Contains(role))
{
RolesBO.Remove(role);
}
}
return;
}
public ActionResult AddRole()
{
RolesBO objRolesBO = new RolesBO();
return(PartialView("AddRole", objRolesBO));
}
public string SaveorUpdateRole(RolesBO objRolesBO, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iRoleId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objRolesBO.RoleId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strRoleName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objRolesBO.RoleName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strDescription";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objRolesBO.Description;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@bIsActive";
objDBparameter.dbType = DbType.Boolean;
objDBparameter.ParameterValue = objRolesBO.IsActive;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcSaveRole, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveorUpdateRole");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string SaveorUpdateRole(RolesBO objRolesBO, int iUserId)
{
return(objRolesDAL.SaveorUpdateRole(objRolesBO, iUserId));
}
