/// <summary> /// Updates a OwnershipType record and returns the number of records affected /// </summary> public static int Update(OwnershipTypeDO DO) { SqlParameter _OwnershipTypeID = new SqlParameter("OwnershipTypeID", SqlDbType.VarChar); _OwnershipTypeID.Value = DO.OwnershipTypeID; SqlParameter[] _params = new SqlParameter[] { _OwnershipTypeID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[OwnershipType_Update]", _params, pid); }
/// <summary> /// Creates a new OwnershipType record using async /// </summary> public static async Task CreateAsync(OwnershipTypeDO DO) { SqlParameter _OwnershipTypeID = new SqlParameter("OwnershipTypeID", SqlDbType.VarChar); _OwnershipTypeID.Value = DO.OwnershipTypeID; SqlParameter[] _params = new SqlParameter[] { _OwnershipTypeID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; await DataCommon.ExecuteNonQueryAsync("[dbo].[OwnershipType_Insert]", _params, pid); }
/// <summary> /// Selects OwnershipType records by PK /// </summary> public static async Task<OwnershipTypeDO[]> GetByPKAsync(String OwnershipTypeID) { SqlParameter _OwnershipTypeID = new SqlParameter("OwnershipTypeID", SqlDbType.VarChar); _OwnershipTypeID.Value = OwnershipTypeID; SqlParameter[] _params = new SqlParameter[] { _OwnershipTypeID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[OwnershipType_GetByPK]", _params, pid); List<OwnershipTypeDO> objs = new List<OwnershipTypeDO>(); while(sr.Read()) { OwnershipTypeDO obj = new OwnershipTypeDO(); obj.OwnershipTypeID = sr.GetString(sr.GetOrdinal("OwnershipTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Gets all OwnershipType records /// </summary> public static async Task<OwnershipTypeDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[OwnershipType_GetAll]", new SqlParameter[] { }, pid); List<OwnershipTypeDO> objs = new List<OwnershipTypeDO>(); while(sr.Read()){ OwnershipTypeDO obj = new OwnershipTypeDO(); obj.OwnershipTypeID = sr.GetString(sr.GetOrdinal("OwnershipTypeID")); objs.Add(obj); } return objs.ToArray(); }