/// <summary>
/// Creates a new RedistributionThickness record using async
/// </summary>
public static async Task<int> CreateAsync(RedistributionThicknessDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _LandUseType = new SqlParameter("LandUseType", SqlDbType.VarChar);
SqlParameter _Redistribution = new SqlParameter("Redistribution", SqlDbType.VarChar);
SqlParameter _Acres = new SqlParameter("Acres", SqlDbType.Int);
SqlParameter _SoilStockpileVolume = new SqlParameter("SoilStockpileVolume", SqlDbType.Int);
_PermitKey.Value = DO.PermitKey;
_LandUseType.Value = DO.LandUseType;
_Redistribution.Value = DO.Redistribution;
_Acres.Value = DO.Acres;
_SoilStockpileVolume.Value = DO.SoilStockpileVolume;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_LandUseType,
_Redistribution,
_Acres,
_SoilStockpileVolume
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[RedistributionThickness_Insert]", _params, pid);
}
/// <summary>
/// Selects RedistributionThickness records by PK
/// </summary>
public static async Task<RedistributionThicknessDO[]> GetByPKAsync(Int32 RedistributionThicknessID)
{
SqlParameter _RedistributionThicknessID = new SqlParameter("RedistributionThicknessID", SqlDbType.Int);
_RedistributionThicknessID.Value = RedistributionThicknessID;
SqlParameter[] _params = new SqlParameter[] {
_RedistributionThicknessID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[RedistributionThickness_GetByPK]", _params, pid);
List<RedistributionThicknessDO> objs = new List<RedistributionThicknessDO>();
while(sr.Read())
{
RedistributionThicknessDO obj = new RedistributionThicknessDO();
obj.RedistributionThicknessID = sr.GetInt32(sr.GetOrdinal("RedistributionThicknessID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.LandUseType = sr.GetString(sr.GetOrdinal("LandUseType"));
obj.Redistribution = sr.GetString(sr.GetOrdinal("Redistribution"));
obj.Acres = sr.GetInt32(sr.GetOrdinal("Acres"));
obj.SoilStockpileVolume = sr.GetInt32(sr.GetOrdinal("SoilStockpileVolume"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Gets all RedistributionThickness records
/// </summary>
public static RedistributionThicknessDO[] GetAll()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[RedistributionThickness_GetAll]", new SqlParameter[] { }, pid);
List<RedistributionThicknessDO> objs = new List<RedistributionThicknessDO>();
while(sr.Read()){
RedistributionThicknessDO obj = new RedistributionThicknessDO();
obj.RedistributionThicknessID = sr.GetInt32(sr.GetOrdinal("RedistributionThicknessID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.LandUseType = sr.GetString(sr.GetOrdinal("LandUseType"));
obj.Redistribution = sr.GetString(sr.GetOrdinal("Redistribution"));
obj.Acres = sr.GetInt32(sr.GetOrdinal("Acres"));
obj.SoilStockpileVolume = sr.GetInt32(sr.GetOrdinal("SoilStockpileVolume"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a RedistributionThickness record
/// </summary>
public static async Task<int> DeleteAsync(RedistributionThicknessDO DO)
{
SqlParameter _RedistributionThicknessID = new SqlParameter("RedistributionThicknessID", SqlDbType.Int);
_RedistributionThicknessID.Value = DO.RedistributionThicknessID;
SqlParameter[] _params = new SqlParameter[] {
_RedistributionThicknessID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[RedistributionThickness_Delete]", _params, pid);
}
public RedistributionThicknessDO WriteRedistributionThickness()
{
RedistributionThicknessDO data = new RedistributionThicknessDO()
{
RedistributionThicknessID = this.RedistributionThicknessID,
Redistribution = this.Redistribution,
PermitKey = this.PermitKey,
Acres = this.Acres,
LandUseType = this.LandUseType,
SoilStockpileVolume = this.SoilStockpileVolume
};
return data;
}
public RedistributionThicknessVM(RedistributionThicknessDO DO)
{
this.RedistributionThicknessID = DO.RedistributionThicknessID;
this.Redistribution = DO.Redistribution;
this.PermitKey = DO.PermitKey;
this.Acres = DO.Acres;
this.LandUseType = DO.LandUseType;
this.SoilStockpileVolume = DO.SoilStockpileVolume;
}
