/// <summary>
/// Creates a new Exemption record
/// </summary>
public static void Create(ExemptionDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _NationalParkSystem = new SqlParameter("NationalParkSystem", SqlDbType.Bit);
SqlParameter _NationalWildlifeRefugeSystem = new SqlParameter("NationalWildlifeRefugeSystem", SqlDbType.Bit);
SqlParameter _NationalSystemofTrails = new SqlParameter("NationalSystemofTrails", SqlDbType.Bit);
SqlParameter _NationalWildernessPreservationSystem = new SqlParameter("NationalWildernessPreservationSystem", SqlDbType.Bit);
SqlParameter _NationalWildandScenicRiversSystem = new SqlParameter("NationalWildandScenicRiversSystem", SqlDbType.Bit);
SqlParameter _NationalRecreationArea = new SqlParameter("NationalRecreationArea", SqlDbType.Bit);
SqlParameter _OnFederalLandWithinNationalForest = new SqlParameter("OnFederalLandWithinNationalForest", SqlDbType.Bit);
SqlParameter _Within100feetOfPublicRoad = new SqlParameter("Within100feetOfPublicRoad", SqlDbType.Bit);
SqlParameter _Within300feetOfOccupiedDwelling = new SqlParameter("Within300feetOfOccupiedDwelling", SqlDbType.Bit);
SqlParameter _Within300feetOfPublicBuilding = new SqlParameter("Within300feetOfPublicBuilding", SqlDbType.Bit);
SqlParameter _Within100feetOfCemetary = new SqlParameter("Within100feetOfCemetary", SqlDbType.Bit);
SqlParameter _NationalRegisterofHistoricPlaces = new SqlParameter("NationalRegisterofHistoricPlaces", SqlDbType.Bit);
_PermitKey.Value = DO.PermitKey;
_NationalParkSystem.Value = DO.NationalParkSystem;
_NationalWildlifeRefugeSystem.Value = DO.NationalWildlifeRefugeSystem;
_NationalSystemofTrails.Value = DO.NationalSystemofTrails;
_NationalWildernessPreservationSystem.Value = DO.NationalWildernessPreservationSystem;
_NationalWildandScenicRiversSystem.Value = DO.NationalWildandScenicRiversSystem;
_NationalRecreationArea.Value = DO.NationalRecreationArea;
_OnFederalLandWithinNationalForest.Value = DO.OnFederalLandWithinNationalForest;
_Within100feetOfPublicRoad.Value = DO.Within100feetOfPublicRoad;
_Within300feetOfOccupiedDwelling.Value = DO.Within300feetOfOccupiedDwelling;
_Within300feetOfPublicBuilding.Value = DO.Within300feetOfPublicBuilding;
_Within100feetOfCemetary.Value = DO.Within100feetOfCemetary;
_NationalRegisterofHistoricPlaces.Value = DO.NationalRegisterofHistoricPlaces;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_NationalParkSystem,
_NationalWildlifeRefugeSystem,
_NationalSystemofTrails,
_NationalWildernessPreservationSystem,
_NationalWildandScenicRiversSystem,
_NationalRecreationArea,
_OnFederalLandWithinNationalForest,
_Within100feetOfPublicRoad,
_Within300feetOfOccupiedDwelling,
_Within300feetOfPublicBuilding,
_Within100feetOfCemetary,
_NationalRegisterofHistoricPlaces
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
DataCommon.ExecuteNonQuery("[dbo].[Exemption_Insert]", _params, pid);
}
/// <summary>
/// Selects Exemption records by PK
/// </summary>
public static async Task<ExemptionDO[]> GetByPKAsync(Int32 PermitKey)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
_PermitKey.Value = PermitKey;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[Exemption_GetByPK]", _params, pid);
List<ExemptionDO> objs = new List<ExemptionDO>();
while(sr.Read())
{
ExemptionDO obj = new ExemptionDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
if (sr.IsDBNull(sr.GetOrdinal("NationalParkSystem"))) { obj.NationalParkSystem = null; } else { obj.NationalParkSystem = sr.GetBoolean(sr.GetOrdinal("NationalParkSystem")); }
if (sr.IsDBNull(sr.GetOrdinal("NationalWildlifeRefugeSystem"))) { obj.NationalWildlifeRefugeSystem = null; } else { obj.NationalWildlifeRefugeSystem = sr.GetBoolean(sr.GetOrdinal("NationalWildlifeRefugeSystem")); }
if (sr.IsDBNull(sr.GetOrdinal("NationalSystemofTrails"))) { obj.NationalSystemofTrails = null; } else { obj.NationalSystemofTrails = sr.GetBoolean(sr.GetOrdinal("NationalSystemofTrails")); }
if (sr.IsDBNull(sr.GetOrdinal("NationalWildernessPreservationSystem"))) { obj.NationalWildernessPreservationSystem = null; } else { obj.NationalWildernessPreservationSystem = sr.GetBoolean(sr.GetOrdinal("NationalWildernessPreservationSystem")); }
if (sr.IsDBNull(sr.GetOrdinal("NationalWildandScenicRiversSystem"))) { obj.NationalWildandScenicRiversSystem = null; } else { obj.NationalWildandScenicRiversSystem = sr.GetBoolean(sr.GetOrdinal("NationalWildandScenicRiversSystem")); }
if (sr.IsDBNull(sr.GetOrdinal("NationalRecreationArea"))) { obj.NationalRecreationArea = null; } else { obj.NationalRecreationArea = sr.GetBoolean(sr.GetOrdinal("NationalRecreationArea")); }
if (sr.IsDBNull(sr.GetOrdinal("OnFederalLandWithinNationalForest"))) { obj.OnFederalLandWithinNationalForest = null; } else { obj.OnFederalLandWithinNationalForest = sr.GetBoolean(sr.GetOrdinal("OnFederalLandWithinNationalForest")); }
if (sr.IsDBNull(sr.GetOrdinal("Within100feetOfPublicRoad"))) { obj.Within100feetOfPublicRoad = null; } else { obj.Within100feetOfPublicRoad = sr.GetBoolean(sr.GetOrdinal("Within100feetOfPublicRoad")); }
if (sr.IsDBNull(sr.GetOrdinal("Within300feetOfOccupiedDwelling"))) { obj.Within300feetOfOccupiedDwelling = null; } else { obj.Within300feetOfOccupiedDwelling = sr.GetBoolean(sr.GetOrdinal("Within300feetOfOccupiedDwelling")); }
if (sr.IsDBNull(sr.GetOrdinal("Within300feetOfPublicBuilding"))) { obj.Within300feetOfPublicBuilding = null; } else { obj.Within300feetOfPublicBuilding = sr.GetBoolean(sr.GetOrdinal("Within300feetOfPublicBuilding")); }
if (sr.IsDBNull(sr.GetOrdinal("Within100feetOfCemetary"))) { obj.Within100feetOfCemetary = null; } else { obj.Within100feetOfCemetary = sr.GetBoolean(sr.GetOrdinal("Within100feetOfCemetary")); }
if (sr.IsDBNull(sr.GetOrdinal("NationalRegisterofHistoricPlaces"))) { obj.NationalRegisterofHistoricPlaces = null; } else { obj.NationalRegisterofHistoricPlaces = sr.GetBoolean(sr.GetOrdinal("NationalRegisterofHistoricPlaces")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a Exemption record
/// </summary>
public static async Task<int> DeleteAsync(ExemptionDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
_PermitKey.Value = DO.PermitKey;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[Exemption_Delete]", _params, pid);
}
public ActionResult Exemptions(ExemptionDO Model, int PermitKey)
{
if (!ModelState.IsValid)
{
return View(Model);
}
try
{
PermitBLL.SaveExemptions(Model);
AddSuccessMessage("Your changes have been saved");
}
catch (Exception ex)
{
AddErrorMessage(ex);
}
return View(Model);
}
