/// <summary> /// Deletes a ProceedingType record /// </summary> public static int Delete(ProceedingTypeDO DO) { SqlParameter _ProceedingTypeID = new SqlParameter("ProceedingTypeID", SqlDbType.VarChar); _ProceedingTypeID.Value = DO.ProceedingTypeID; SqlParameter[] _params = new SqlParameter[] { _ProceedingTypeID }; return DataCommon.ExecuteScalar("[dbo].[ProceedingType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new ProceedingType record /// </summary> public static void Create(ProceedingTypeDO DO) { SqlParameter _ProceedingTypeID = new SqlParameter("ProceedingTypeID", SqlDbType.VarChar); _ProceedingTypeID.Value = DO.ProceedingTypeID; SqlParameter[] _params = new SqlParameter[] { _ProceedingTypeID }; DataCommon.ExecuteNonQuery("[dbo].[ProceedingType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all ProceedingType records /// </summary> public static ProceedingTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ProceedingType_GetAll]", new SqlParameter[] { }, "dbo"); List<ProceedingTypeDO> objs = new List<ProceedingTypeDO>(); while(sr.Read()){ ProceedingTypeDO obj = new ProceedingTypeDO(); obj.ProceedingTypeID = sr.GetString(sr.GetOrdinal("ProceedingTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects ProceedingType records by PK /// </summary> public static ProceedingTypeDO[] GetByPK(String ProceedingTypeID) { SqlParameter _ProceedingTypeID = new SqlParameter("ProceedingTypeID", SqlDbType.VarChar); _ProceedingTypeID.Value = ProceedingTypeID; SqlParameter[] _params = new SqlParameter[] { _ProceedingTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ProceedingType_GetByPK]", _params, "dbo"); List<ProceedingTypeDO> objs = new List<ProceedingTypeDO>(); while(sr.Read()) { ProceedingTypeDO obj = new ProceedingTypeDO(); obj.ProceedingTypeID = sr.GetString(sr.GetOrdinal("ProceedingTypeID")); objs.Add(obj); } return objs.ToArray(); }