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