/// <summary> /// Updates a State record and returns the number of records affected /// </summary> public static int Update(StateDO DO) { SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _FIPSStateID = new SqlParameter("FIPSStateID", SqlDbType.VarChar); _StateID.Value = DO.StateID; _Description.Value = DO.Description; _FIPSStateID.Value = DO.FIPSStateID; SqlParameter[] _params = new SqlParameter[] { _StateID, _Description, _FIPSStateID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[State_Update]", _params, pid); }
/// <summary> /// Creates a new State record using async /// </summary> public static async Task CreateAsync(StateDO DO) { SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _FIPSStateID = new SqlParameter("FIPSStateID", SqlDbType.VarChar); _StateID.Value = DO.StateID; _Description.Value = DO.Description; _FIPSStateID.Value = DO.FIPSStateID; SqlParameter[] _params = new SqlParameter[] { _StateID, _Description, _FIPSStateID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; await DataCommon.ExecuteNonQueryAsync("[dbo].[State_Insert]", _params, pid); }
/// <summary> /// Gets all State records /// </summary> public static async Task<StateDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[State_GetAll]", new SqlParameter[] { }, pid); List<StateDO> objs = new List<StateDO>(); while(sr.Read()){ StateDO obj = new StateDO(); obj.StateID = sr.GetString(sr.GetOrdinal("StateID")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); obj.FIPSStateID = sr.GetString(sr.GetOrdinal("FIPSStateID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects State records by PK /// </summary> public static async Task<StateDO[]> GetByPKAsync(String StateID) { SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar); _StateID.Value = StateID; SqlParameter[] _params = new SqlParameter[] { _StateID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[State_GetByPK]", _params, pid); List<StateDO> objs = new List<StateDO>(); while(sr.Read()) { StateDO obj = new StateDO(); obj.StateID = sr.GetString(sr.GetOrdinal("StateID")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); obj.FIPSStateID = sr.GetString(sr.GetOrdinal("FIPSStateID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a State record /// </summary> public static async Task<int> DeleteAsync(StateDO DO) { SqlParameter _StateID = new SqlParameter("StateID", SqlDbType.VarChar); _StateID.Value = DO.StateID; SqlParameter[] _params = new SqlParameter[] { _StateID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[State_Delete]", _params, pid); }