/// <summary> /// CreatedBy : Kasun Samarawickrama /// CreatedDate: 2016/01/17 /// /// Get user permission permission string which contain rightId's /// </summary> /// <param name="userId"> Profile edit users id</param> /// <returns>Right List, but first Right contain the string, If List have more than 1 value it is going to be an unAuthorize one</returns> /// public List<Right> getRightsString(int userId, int loanId) { List<Right> RightsLists = new List<Right>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@userId", userId }); paramertList.Add(new object[] { "@loanId", loanId }); try { DataSet dataSet = dataHandler.GetDataSet("spGetRightsStringByUserId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Right right = new Right(); right.userId = int.Parse(dataRow["user_id"].ToString()); right.rightsPermissionString = dataRow["right_id"].ToString(); right.reportRightsPermissionString = dataRow["report_rights"].ToString(); RightsLists.Add(right); } return RightsLists; } else { return null; } } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Kasun Samarawickrama /// CreatedDate: 2016/01/16 /// /// Get all rights in database /// </summary> /// <param name="userId"></param> /// <returns>Right list</returns> /// public List<Right> getRights() { List<Right> RightsLists = new List<Right>(); DataHandler dataHandler = new DataHandler(); try { DataSet dataSet = dataHandler.GetDataSet("spGetRights"); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Right right = new Right(); right.rightId = dataRow["right_id"].ToString(); right.active = false; right.description = dataRow["description"].ToString(); RightsLists.Add(right); } return RightsLists; } else { return null; } } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy:Piyumi /// CreatedDate:6/22/2016 /// Get all report details /// </summary> /// <returns></returns> public List<Right> getReportRights() { List<Right> RightsLists = new List<Right>(); DataHandler dataHandler = new DataHandler(); try { DataSet dataSet = dataHandler.GetDataSet("spGetReportRights"); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Right right = new Right(); right.rightId = dataRow["report_id"].ToString(); right.active = false; right.description = dataRow["report_description"].ToString(); right.name = dataRow["report_name"].ToString(); right.ImagePath = dataRow["image_path"].ToString(); right.DealerView = bool.Parse(dataRow["dealer_can_view"].ToString()); right.UserView = bool.Parse(dataRow["user_can_view"].ToString()); RightsLists.Add(right); } return RightsLists; } else { return null; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Frontend Page:Bottom Link Bar of each page in floor plan management section /// Title: return user rights for given loan code and user id /// Designed: Irfan MAM /// User Story: /// Developed: Piyumi Perera /// Date created: /// </summary> /// <param name="loanCode"></param> /// <param name="userId"></param> /// <returns></returns> public List<Right> GetUserRightsByLoanCode(string loanCode,int userId) { List<Right> resltList = new List<Right>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@user_id", userId }); paramertList.Add(new object[] { "@loan_code", loanCode }); try { DataSet dataSet = dataHandler.GetDataSet("spGetUserRightsByLoanCode", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Right right = new Right(); right.userId = int.Parse(dataRow["user_id"].ToString()); right.rightsPermissionString = dataRow["right_id"].ToString(); resltList.Add(right); } return resltList; } else { return null; } } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Kasun Samarawickrama /// CreatedDate: 2016/01/17 /// /// Rew Right string Updating /// </summary> /// <param name="returnRight"></param> /// <param name="writerId"></param> /// <returns>boolian value</returns> /// public bool postNewRights(Right returnRight) { DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@editor_id", returnRight.userId }); paramertList.Add(new object[] { "@permission", returnRight.rightsPermissionString }); paramertList.Add(new object[] { "@modified_user", returnRight.editorId }); paramertList.Add(new object[] { "@DateNow", DateTime.Now }); try { return dataHandler.ExecuteSQL("spUpdateRightsStringByUserId", paramertList); } catch (Exception ex) { throw ex; } }
public ActionResult SetRights(IList<Right> rightList) { List<string> returnIntArray = new List<string>(); for (int i = 0; i < rightList.Count;) { if (rightList[i].active == false) { returnIntArray.Add(rightList[i].rightId); } i++; } var resultRightIdString = string.Join(",", returnIntArray); var returnRight = new Right(); returnRight.userId = rightList[0].userId; returnRight.editorId = rightList[0].editorId; UserManageAccess uma = new UserManageAccess(); // not allow to edit rights for admin and superadmin... not allow user to use this page if (uma.getUserRole(returnRight.userId) < 3 || uma.getUserRole(returnRight.editorId) == 3) { return new HttpStatusCodeResult(404); } returnRight.rightsPermissionString = resultRightIdString; var returnAccess = new UserRightsAccess(); if (returnAccess.postNewRights(returnRight)) { ViewBag.SuccessMsg = "Succesfully Updated"; return RedirectToAction("SetRights", "EditRights", new { lbl1 = ViewBag.SuccessMsg }); } else { ViewBag.ErrorMsg = "Sorry, rights can't update"; return RedirectToAction("SetRights", "EditRights", new { lbl2 = ViewBag.ErrorMsg }); } }