/// <summary> /// Creates a new Quadrangle record using async /// </summary> public static async Task CreateAsync(QuadrangleDO DO) { SqlParameter _FIPSStateID = new SqlParameter("FIPSStateID", SqlDbType.VarChar); SqlParameter _FIPSCountyID = new SqlParameter("FIPSCountyID", SqlDbType.VarChar); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); SqlParameter _Latitude = new SqlParameter("Latitude", SqlDbType.VarChar); SqlParameter _Longitude = new SqlParameter("Longitude", SqlDbType.VarChar); _FIPSStateID.Value = DO.FIPSStateID; _FIPSCountyID.Value = DO.FIPSCountyID; _Description.Value = DO.Description; _QuadrangleID.Value = DO.QuadrangleID; _Latitude.Value = DO.Latitude; _Longitude.Value = DO.Longitude; SqlParameter[] _params = new SqlParameter[] { _FIPSStateID, _FIPSCountyID, _Description, _QuadrangleID, _Latitude, _Longitude }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; await DataCommon.ExecuteNonQueryAsync("[dbo].[Quadrangle_Insert]", _params, pid); }
/// <summary> /// Selects Quadrangle records by PK /// </summary> public static async Task<QuadrangleDO[]> GetByPKAsync(String QuadrangleID) { SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); _QuadrangleID.Value = QuadrangleID; SqlParameter[] _params = new SqlParameter[] { _QuadrangleID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[Quadrangle_GetByPK]", _params, pid); List<QuadrangleDO> objs = new List<QuadrangleDO>(); while(sr.Read()) { QuadrangleDO obj = new QuadrangleDO(); obj.FIPSStateID = sr.GetString(sr.GetOrdinal("FIPSStateID")); obj.FIPSCountyID = sr.GetString(sr.GetOrdinal("FIPSCountyID")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); obj.QuadrangleID = sr.GetString(sr.GetOrdinal("QuadrangleID")); obj.Latitude = sr.GetString(sr.GetOrdinal("Latitude")); obj.Longitude = sr.GetString(sr.GetOrdinal("Longitude")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a Quadrangle record /// </summary> public static async Task<int> DeleteAsync(QuadrangleDO DO) { SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); _QuadrangleID.Value = DO.QuadrangleID; SqlParameter[] _params = new SqlParameter[] { _QuadrangleID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[Quadrangle_Delete]", _params, pid); }
/// <summary> /// Gets all Quadrangle records /// </summary> public static async Task<QuadrangleDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[Quadrangle_GetAll]", new SqlParameter[] { }, pid); List<QuadrangleDO> objs = new List<QuadrangleDO>(); while(sr.Read()){ QuadrangleDO obj = new QuadrangleDO(); obj.FIPSStateID = sr.GetString(sr.GetOrdinal("FIPSStateID")); obj.FIPSCountyID = sr.GetString(sr.GetOrdinal("FIPSCountyID")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); obj.QuadrangleID = sr.GetString(sr.GetOrdinal("QuadrangleID")); obj.Latitude = sr.GetString(sr.GetOrdinal("Latitude")); obj.Longitude = sr.GetString(sr.GetOrdinal("Longitude")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Updates a Quadrangle record and returns the number of records affected /// </summary> public static int Update(QuadrangleDO DO) { SqlParameter _FIPSStateID = new SqlParameter("FIPSStateID", SqlDbType.VarChar); SqlParameter _FIPSCountyID = new SqlParameter("FIPSCountyID", SqlDbType.VarChar); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); SqlParameter _Latitude = new SqlParameter("Latitude", SqlDbType.VarChar); SqlParameter _Longitude = new SqlParameter("Longitude", SqlDbType.VarChar); _FIPSStateID.Value = DO.FIPSStateID; _FIPSCountyID.Value = DO.FIPSCountyID; _Description.Value = DO.Description; _QuadrangleID.Value = DO.QuadrangleID; _Latitude.Value = DO.Latitude; _Longitude.Value = DO.Longitude; SqlParameter[] _params = new SqlParameter[] { _FIPSStateID, _FIPSCountyID, _Description, _QuadrangleID, _Latitude, _Longitude }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[Quadrangle_Update]", _params, pid); }