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