/// <summary> /// Add common parameters before calling a procedure /// </summary> /// <param name="cmd">command object, where parameters will be added</param> /// <param name="userPermissionObject"></param> private void AddCommonParams(SqlCommand cmd, UserPermissionBase userPermissionObject) { AddParameter(cmd, pGuid(UserPermissionBase.Property_CompanyId, userPermissionObject.CompanyId)); AddParameter(cmd, pGuid(UserPermissionBase.Property_UserId, userPermissionObject.UserId)); AddParameter(cmd, pInt32(UserPermissionBase.Property_PermissionId, userPermissionObject.PermissionId)); AddParameter(cmd, pInt32(UserPermissionBase.Property_PermissionGroupId, userPermissionObject.PermissionGroupId)); }
/// <summary> /// Fills UserPermission object /// </summary> /// <param name="userPermissionObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> /// <param name="start">The ordinal position from which to start reading the reader</param> protected void FillObject(UserPermissionBase userPermissionObject, SqlDataReader reader, int start) { userPermissionObject.Id = reader.GetInt32(start + 0); userPermissionObject.CompanyId = reader.GetGuid(start + 1); userPermissionObject.UserId = reader.GetGuid(start + 2); if (!reader.IsDBNull(3)) { userPermissionObject.PermissionId = reader.GetInt32(start + 3); } if (!reader.IsDBNull(4)) { userPermissionObject.PermissionGroupId = reader.GetInt32(start + 4); } FillBaseObject(userPermissionObject, reader, (start + 5)); userPermissionObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; }
/// <summary> /// Updates UserPermission /// </summary> /// <param name="userPermissionObject">Object to be updated</param> /// <returns>Number of rows affected</returns> public long Update(UserPermissionBase userPermissionObject) { try { SqlCommand cmd = GetSPCommand(UPDATEUSERPERMISSION); AddParameter(cmd, pInt32(UserPermissionBase.Property_Id, userPermissionObject.Id)); AddCommonParams(cmd, userPermissionObject); long result = UpdateRecord(cmd); if (result > 0) { userPermissionObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; } return(result); } catch (SqlException x) { throw new ObjectUpdateException(userPermissionObject, x); } }
/// <summary> /// Inserts UserPermission /// </summary> /// <param name="userPermissionObject">Object to be inserted</param> /// <returns>Number of rows affected</returns> public long Insert(UserPermissionBase userPermissionObject) { try { SqlCommand cmd = GetSPCommand(INSERTUSERPERMISSION); AddParameter(cmd, pInt32Out(UserPermissionBase.Property_Id)); AddCommonParams(cmd, userPermissionObject); long result = InsertRecord(cmd); if (result > 0) { userPermissionObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; userPermissionObject.Id = (Int32)GetOutParameter(cmd, UserPermissionBase.Property_Id); } return(result); } catch (SqlException x) { throw new ObjectInsertException(userPermissionObject, x); } }
/// <summary> /// Fills UserPermission object /// </summary> /// <param name="userPermissionObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> protected void FillObject(UserPermissionBase userPermissionObject, SqlDataReader reader) { FillObject(userPermissionObject, reader, 0); }