/// <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();
}
