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