/// <summary> /// Updates a LocationQuadrangle record and returns the number of records affected /// </summary> public static int Update(LocationQuadrangleDO DO) { SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); _PermitKey.Value = DO.PermitKey; _QuadrangleID.Value = DO.QuadrangleID; SqlParameter[] _params = new SqlParameter[] { _PermitKey, _QuadrangleID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return DataCommon.ExecuteScalar("[dbo].[LocationQuadrangle_Update]", _params, pid); }
/// <summary> /// Creates a new LocationQuadrangle record using async /// </summary> public static async Task CreateAsync(LocationQuadrangleDO DO) { SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); _PermitKey.Value = DO.PermitKey; _QuadrangleID.Value = DO.QuadrangleID; SqlParameter[] _params = new SqlParameter[] { _PermitKey, _QuadrangleID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; await DataCommon.ExecuteNonQueryAsync("[dbo].[LocationQuadrangle_Insert]", _params, pid); }
/// <summary> /// Selects LocationQuadrangle records by PK /// </summary> public static async Task<LocationQuadrangleDO[]> GetByPKAsync(Int32 PermitKey, String QuadrangleID) { SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _QuadrangleID = new SqlParameter("QuadrangleID", SqlDbType.VarChar); _PermitKey.Value = PermitKey; _QuadrangleID.Value = QuadrangleID; SqlParameter[] _params = new SqlParameter[] { _PermitKey, _QuadrangleID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[LocationQuadrangle_GetByPK]", _params, pid); List<LocationQuadrangleDO> objs = new List<LocationQuadrangleDO>(); while(sr.Read()) { LocationQuadrangleDO obj = new LocationQuadrangleDO(); obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); obj.QuadrangleID = sr.GetString(sr.GetOrdinal("QuadrangleID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Gets all LocationQuadrangle records /// </summary> public static async Task<LocationQuadrangleDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[LocationQuadrangle_GetAll]", new SqlParameter[] { }, pid); List<LocationQuadrangleDO> objs = new List<LocationQuadrangleDO>(); while(sr.Read()){ LocationQuadrangleDO obj = new LocationQuadrangleDO(); obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); obj.QuadrangleID = sr.GetString(sr.GetOrdinal("QuadrangleID")); objs.Add(obj); } return objs.ToArray(); }