/// <summary> /// Retrieves list of PermissionGroupMap objects from SqlCommand, after database query /// number of rows retrieved and returned depends upon the rows field value /// </summary> /// <param name="cmd">The command object to use for query</param> /// <param name="rows">Number of rows to process</param> /// <returns>A list of PermissionGroupMap objects</returns> private PermissionGroupMapList GetList(SqlCommand cmd, long rows) { // Select multiple records SqlDataReader reader; long result = SelectRecords(cmd, out reader); //PermissionGroupMap list PermissionGroupMapList list = new PermissionGroupMapList(); using ( reader ) { // Read rows until end of result or number of rows specified is reached while (reader.Read() && rows-- != 0) { PermissionGroupMap permissionGroupMapObject = new PermissionGroupMap(); FillObject(permissionGroupMapObject, reader); list.Add(permissionGroupMapObject); } // Close the reader in order to receive output parameters // Output parameters are not available until reader is closed. reader.Close(); } return(list); }
/// <summary> /// populates a PermissionGroupMap with its child entities /// </summary> /// <param name="permissionGroupMap"></param> /// <param name="fillChilds"></param> private void FillPermissionGroupMapWithChilds(PermissionGroupMap permissionGroupMapObject, bool fillChilds) { // populate child data for a permissionGroupMapObject if (permissionGroupMapObject != null) { } }
/// <summary> /// Update PermissionGroupMap Object. /// Data manipulation processing for: new, deleted, updated PermissionGroupMap /// </summary> /// <param name="permissionGroupMapObject"></param> /// <returns></returns> public bool Update(PermissionGroupMap permissionGroupMapObject) { bool success = false; success = UpdateBase(permissionGroupMapObject); return(success); }
/// <summary> /// Retrieves PermissionGroupMap object from SqlCommand, after database query /// </summary> /// <param name="cmd">The command object to use for query</param> /// <returns>PermissionGroupMap object</returns> private PermissionGroupMap GetObject(SqlCommand cmd) { SqlDataReader reader; long rows = SelectRecords(cmd, out reader); using (reader) { if (reader.Read()) { PermissionGroupMap permissionGroupMapObject = new PermissionGroupMap(); FillObject(permissionGroupMapObject, reader); return(permissionGroupMapObject); } else { return(null); } } }
/// <summary> /// Update base of PermissionGroupMap Object. /// Data manipulation processing for: new, deleted, updated PermissionGroupMap /// </summary> /// <param name="permissionGroupMapObject"></param> /// <returns></returns> public bool UpdateBase(PermissionGroupMap permissionGroupMapObject) { // use of switch for different types of DML switch (permissionGroupMapObject.RowState) { // insert new rows case BaseBusinessEntity.RowStateEnum.NewRow: return(Insert(permissionGroupMapObject)); // delete rows case BaseBusinessEntity.RowStateEnum.DeletedRow: return(Delete(permissionGroupMapObject.Id)); } // update rows using (PermissionGroupMapDataAccess data = new PermissionGroupMapDataAccess(ClientContext)) { return(data.Update(permissionGroupMapObject) > 0); } }
/// <summary> /// Insert new permissionGroupMap. /// data manipulation for insertion of PermissionGroupMap /// </summary> /// <param name="permissionGroupMapObject"></param> /// <returns></returns> private bool Insert(PermissionGroupMap permissionGroupMapObject) { // new permissionGroupMap using (PermissionGroupMapDataAccess data = new PermissionGroupMapDataAccess(ClientContext)) { // insert to permissionGroupMapObject Int32 _Id = data.Insert(permissionGroupMapObject); // if successful, process if (_Id > 0) { permissionGroupMapObject.Id = _Id; return(true); } else { return(false); } } }
public JsonResult SavedChacked(int permissionId, int UserId) { bool result = false; PermissionGroupMap permissionGroupMap = _Util.Facade.permissionFacade.GetAllPermissionGroupMap().Where(x => x.PermissionId == permissionId && x.PermissionGroupId == UserId).FirstOrDefault(); if (permissionGroupMap == null) { PermissionGroupMap pm = new PermissionGroupMap(); pm.PermissionGroupId = UserId; pm.PermissionId = permissionId; pm.IsActive = true; _Util.Facade.permissionFacade.InsertPermissionGroupMap(pm); result = true; } else { _Util.Facade.permissionFacade.DeletePermissionGroupMap(permissionGroupMap.Id); } return(Json(result)); }
public bool InsertPermissionGroupMap(PermissionGroupMap permissionGroupMap) { return(_PermissionGroupMapDataAccess.Insert(permissionGroupMap) > 0); }
/// <summary> /// Fill External Childs of PermissionGroupMap Object. /// </summary> /// <param name="permissionGroupMapObject"></param> /// <returns></returns> public void FillChilds(PermissionGroupMap permissionGroupMapObject) { ///Fill external information of Childs of PermissionGroupMapObject }