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