/// <summary> /// Deletes a ContactType record /// </summary> public static int Delete(ContactTypeDO DO) { SqlParameter _ContactTypeID = new SqlParameter("ContactTypeID", SqlDbType.VarChar); _ContactTypeID.Value = DO.ContactTypeID; SqlParameter[] _params = new SqlParameter[] { _ContactTypeID }; return DataCommon.ExecuteScalar("[dbo].[ContactType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new ContactType record /// </summary> public static void Create(ContactTypeDO DO) { SqlParameter _ContactTypeID = new SqlParameter("ContactTypeID", SqlDbType.VarChar); _ContactTypeID.Value = DO.ContactTypeID; SqlParameter[] _params = new SqlParameter[] { _ContactTypeID }; DataCommon.ExecuteNonQuery("[dbo].[ContactType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all ContactType records /// </summary> public static ContactTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ContactType_GetAll]", new SqlParameter[] { }, "dbo"); List<ContactTypeDO> objs = new List<ContactTypeDO>(); while(sr.Read()){ ContactTypeDO obj = new ContactTypeDO(); obj.ContactTypeID = sr.GetString(sr.GetOrdinal("ContactTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects ContactType records by PK /// </summary> public static ContactTypeDO[] GetByPK(String ContactTypeID) { SqlParameter _ContactTypeID = new SqlParameter("ContactTypeID", SqlDbType.VarChar); _ContactTypeID.Value = ContactTypeID; SqlParameter[] _params = new SqlParameter[] { _ContactTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ContactType_GetByPK]", _params, "dbo"); List<ContactTypeDO> objs = new List<ContactTypeDO>(); while(sr.Read()) { ContactTypeDO obj = new ContactTypeDO(); obj.ContactTypeID = sr.GetString(sr.GetOrdinal("ContactTypeID")); objs.Add(obj); } return objs.ToArray(); }