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