/// <summary> /// Deletes a AccessPermission record /// </summary> public static int Delete(AccessPermissionDO DO) { SqlParameter _RegistrationID = new SqlParameter("RegistrationID", SqlDbType.Int); SqlParameter _PermissionTypeID = new SqlParameter("PermissionTypeID", SqlDbType.VarChar); _RegistrationID.Value = DO.RegistrationID; _PermissionTypeID.Value = DO.PermissionTypeID; SqlParameter[] _params = new SqlParameter[] { _RegistrationID, _PermissionTypeID }; return DataCommon.ExecuteScalar("[dbo].[AccessPermission_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new AccessPermission record /// </summary> public static void Create(AccessPermissionDO DO) { SqlParameter _RegistrationID = new SqlParameter("RegistrationID", SqlDbType.Int); SqlParameter _PermissionTypeID = new SqlParameter("PermissionTypeID", SqlDbType.VarChar); _RegistrationID.Value = DO.RegistrationID; _PermissionTypeID.Value = DO.PermissionTypeID; SqlParameter[] _params = new SqlParameter[] { _RegistrationID, _PermissionTypeID }; DataCommon.ExecuteNonQuery("[dbo].[AccessPermission_Insert]", _params, "dbo"); }
/// <summary> /// Gets all AccessPermission records /// </summary> public static AccessPermissionDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[AccessPermission_GetAll]", new SqlParameter[] { }, "dbo"); List<AccessPermissionDO> objs = new List<AccessPermissionDO>(); while(sr.Read()){ AccessPermissionDO obj = new AccessPermissionDO(); obj.RegistrationID = sr.GetInt32(sr.GetOrdinal("RegistrationID")); obj.PermissionTypeID = sr.GetString(sr.GetOrdinal("PermissionTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects AccessPermission records by PK /// </summary> public static AccessPermissionDO[] GetByPK(Int32 RegistrationID, String PermissionTypeID) { SqlParameter _RegistrationID = new SqlParameter("RegistrationID", SqlDbType.Int); SqlParameter _PermissionTypeID = new SqlParameter("PermissionTypeID", SqlDbType.VarChar); _RegistrationID.Value = RegistrationID; _PermissionTypeID.Value = PermissionTypeID; SqlParameter[] _params = new SqlParameter[] { _RegistrationID, _PermissionTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[AccessPermission_GetByPK]", _params, "dbo"); List<AccessPermissionDO> objs = new List<AccessPermissionDO>(); while(sr.Read()) { AccessPermissionDO obj = new AccessPermissionDO(); obj.RegistrationID = sr.GetInt32(sr.GetOrdinal("RegistrationID")); obj.PermissionTypeID = sr.GetString(sr.GetOrdinal("PermissionTypeID")); objs.Add(obj); } return objs.ToArray(); }