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