/// <summary> /// Deletes a OwnershipStatus record /// </summary> public static int Delete(OwnershipStatusDO DO) { SqlParameter _OwnershipStatusID = new SqlParameter("OwnershipStatusID", SqlDbType.VarChar); _OwnershipStatusID.Value = DO.OwnershipStatusID; SqlParameter[] _params = new SqlParameter[] { _OwnershipStatusID }; return DataCommon.ExecuteScalar("[dbo].[OwnershipStatus_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new OwnershipStatus record /// </summary> public static void Create(OwnershipStatusDO DO) { SqlParameter _OwnershipStatusID = new SqlParameter("OwnershipStatusID", SqlDbType.VarChar); _OwnershipStatusID.Value = DO.OwnershipStatusID; SqlParameter[] _params = new SqlParameter[] { _OwnershipStatusID }; DataCommon.ExecuteNonQuery("[dbo].[OwnershipStatus_Insert]", _params, "dbo"); }
/// <summary> /// Gets all OwnershipStatus records /// </summary> public static OwnershipStatusDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[OwnershipStatus_GetAll]", new SqlParameter[] { }, "dbo"); List<OwnershipStatusDO> objs = new List<OwnershipStatusDO>(); while(sr.Read()){ OwnershipStatusDO obj = new OwnershipStatusDO(); obj.OwnershipStatusID = sr.GetString(sr.GetOrdinal("OwnershipStatusID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects OwnershipStatus records by PK /// </summary> public static OwnershipStatusDO[] GetByPK(String OwnershipStatusID) { SqlParameter _OwnershipStatusID = new SqlParameter("OwnershipStatusID", SqlDbType.VarChar); _OwnershipStatusID.Value = OwnershipStatusID; SqlParameter[] _params = new SqlParameter[] { _OwnershipStatusID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[OwnershipStatus_GetByPK]", _params, "dbo"); List<OwnershipStatusDO> objs = new List<OwnershipStatusDO>(); while(sr.Read()) { OwnershipStatusDO obj = new OwnershipStatusDO(); obj.OwnershipStatusID = sr.GetString(sr.GetOrdinal("OwnershipStatusID")); objs.Add(obj); } return objs.ToArray(); }