/// <summary>
        /// Creates a new instance of the UserPermitVM
        /// </summary>
        /// <param name="permit"></param>
        /// <param name="user"></param>
        public UserPermitVM(PermitDO permit, myCoalUser user)
        {
            Permit = permit;
            User = user;

            List<PermitRegistrationBO> registrations = PermitRegistrationBLL.GetPermitRegistrationsByRegistrationID(User.RegistrationId);
            Registration = registrations.Where(r => r.PermitRegistration.PermitKey == Permit.PermitKey).FirstOrDefault();
        }
Example #2
0
        /// <summary>
        /// Updates a Permit record and returns the number of records affected
        /// </summary>
        public static async Task<int> UpdateAsync(PermitDO DO)
        {
            SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
            SqlParameter _PermitID = new SqlParameter("PermitID", SqlDbType.VarChar);
            SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar);
            SqlParameter _PermitStatusID = new SqlParameter("PermitStatusID", SqlDbType.VarChar);
            SqlParameter _StatusDate = new SqlParameter("StatusDate", SqlDbType.DateTime);
            SqlParameter _ApplicationNumber = new SqlParameter("ApplicationNumber", SqlDbType.VarChar);
            SqlParameter _ApplicationDescriptionOfInterests = new SqlParameter("ApplicationDescriptionOfInterests", SqlDbType.VarChar);
            SqlParameter _SiteName = new SqlParameter("SiteName", SqlDbType.VarChar);
            SqlParameter _MineTypeID = new SqlParameter("MineTypeID", SqlDbType.VarChar);
            SqlParameter _MSHAID = new SqlParameter("MSHAID", SqlDbType.VarChar);
            SqlParameter _ProposedReminedAcres = new SqlParameter("ProposedReminedAcres", SqlDbType.Int);
            SqlParameter _LegalDescriptionOfAccess = new SqlParameter("LegalDescriptionOfAccess", SqlDbType.VarChar);
            SqlParameter _Latitude = new SqlParameter("Latitude", SqlDbType.VarChar);
            SqlParameter _Longitude = new SqlParameter("Longitude", SqlDbType.VarChar);
            SqlParameter _NewspaperName = new SqlParameter("NewspaperName", SqlDbType.VarChar);
            SqlParameter _NearestTown = new SqlParameter("NearestTown", SqlDbType.VarChar);
            SqlParameter _LegalRightToEnter = new SqlParameter("LegalRightToEnter", SqlDbType.VarChar);
            SqlParameter _LitigationStatus = new SqlParameter("LitigationStatus", SqlDbType.Bit);
            SqlParameter _StatusOfLitigation = new SqlParameter("StatusOfLitigation", SqlDbType.VarChar);
            SqlParameter _LandsUnsuitable = new SqlParameter("LandsUnsuitable", SqlDbType.Bit);
            SqlParameter _LifeOfMineYears = new SqlParameter("LifeOfMineYears", SqlDbType.Int);
            SqlParameter _AnnualAnticipatedProductionInTons = new SqlParameter("AnnualAnticipatedProductionInTons", SqlDbType.Int);
            SqlParameter _TotalAnticipatedProductionInTons = new SqlParameter("TotalAnticipatedProductionInTons", SqlDbType.Int);
            SqlParameter _LifeOfMineComments = new SqlParameter("LifeOfMineComments", SqlDbType.VarChar);
            SqlParameter _OtherBondFormDescription = new SqlParameter("OtherBondFormDescription", SqlDbType.VarChar);
            SqlParameter _CulturalResourcesDescription = new SqlParameter("CulturalResourcesDescription", SqlDbType.VarChar);
            SqlParameter _UniqueSpecialCharacteristicsAndGeologicFormations = new SqlParameter("UniqueSpecialCharacteristicsAndGeologicFormations", SqlDbType.VarChar);
            SqlParameter _UniqueSpecialCharacteristicsAdverselyAffectedByMining = new SqlParameter("UniqueSpecialCharacteristicsAdverselyAffectedByMining", SqlDbType.Bit);
            SqlParameter _GeologicInformationUndesirable = new SqlParameter("GeologicInformationUndesirable", SqlDbType.Bit);
            SqlParameter _AverageWindDirection = new SqlParameter("AverageWindDirection", SqlDbType.VarChar);
            SqlParameter _AverageWindVelocity = new SqlParameter("AverageWindVelocity", SqlDbType.Decimal);
            SqlParameter _PrimeFarmlandInvestigation = new SqlParameter("PrimeFarmlandInvestigation", SqlDbType.Bit);
            SqlParameter _ResourcesAffectedByProposedOperation = new SqlParameter("ResourcesAffectedByProposedOperation", SqlDbType.Bit);
            SqlParameter _ResourcesAffectedByProposedOperationDescription = new SqlParameter("ResourcesAffectedByProposedOperationDescription", SqlDbType.VarChar);
            SqlParameter _ProposedMiningWithinPublicRoads = new SqlParameter("ProposedMiningWithinPublicRoads", SqlDbType.Bit);
            SqlParameter _ProposedMiningWithinPublicRoadsDescription = new SqlParameter("ProposedMiningWithinPublicRoadsDescription", SqlDbType.VarChar);
            SqlParameter _AdjacentToValleyHoldingStream = new SqlParameter("AdjacentToValleyHoldingStream", SqlDbType.Bit);
            SqlParameter _AlluvialValleyFloorDeterminationRequested = new SqlParameter("AlluvialValleyFloorDeterminationRequested", SqlDbType.Bit);
            SqlParameter _TypeAndMethodOfMiningPlanDescription = new SqlParameter("TypeAndMethodOfMiningPlanDescription", SqlDbType.VarChar);
            SqlParameter _AnnualAnticipatedMiningProductionInTons = new SqlParameter("AnnualAnticipatedMiningProductionInTons", SqlDbType.Int);
            SqlParameter _TotalAnticipatedMiningProductionInTons = new SqlParameter("TotalAnticipatedMiningProductionInTons", SqlDbType.Int);
            SqlParameter _TotalMiningReservesInTons = new SqlParameter("TotalMiningReservesInTons", SqlDbType.Int);
            SqlParameter _ToxicAndUndesirableMaterialsDisposalPlan = new SqlParameter("ToxicAndUndesirableMaterialsDisposalPlan", SqlDbType.VarChar);
            SqlParameter _FireContingencyPlan = new SqlParameter("FireContingencyPlan", SqlDbType.VarChar);
            SqlParameter _ComplianceWithAirAndWaterQualityLaws = new SqlParameter("ComplianceWithAirAndWaterQualityLaws", SqlDbType.VarChar);
            SqlParameter _NoxiousWeedsManagementPlan = new SqlParameter("NoxiousWeedsManagementPlan", SqlDbType.VarChar);
            SqlParameter _BlastingPlan = new SqlParameter("BlastingPlan", SqlDbType.VarChar);
            SqlParameter _AirPollutionControlPlan = new SqlParameter("AirPollutionControlPlan", SqlDbType.VarChar);
            SqlParameter _FishAndWildlifePlan = new SqlParameter("FishAndWildlifePlan", SqlDbType.VarChar);
            SqlParameter _MiningConductedWithin500FeetUndergroundMine = new SqlParameter("MiningConductedWithin500FeetUndergroundMine", SqlDbType.Bit);
            SqlParameter _MiningConductedWithin500FeetUndergroundMineDescription = new SqlParameter("MiningConductedWithin500FeetUndergroundMineDescription", SqlDbType.VarChar);
            SqlParameter _DiversionConstructed = new SqlParameter("DiversionConstructed", SqlDbType.Bit);
            SqlParameter _DisposalOfExcessSpoilRequired = new SqlParameter("DisposalOfExcessSpoilRequired", SqlDbType.Bit);
            SqlParameter _TransportationFacilitiesPlanDescription = new SqlParameter("TransportationFacilitiesPlanDescription", SqlDbType.VarChar);
            SqlParameter _CoalConservationPlanDescription = new SqlParameter("CoalConservationPlanDescription", SqlDbType.VarChar);
            SqlParameter _AugerMiningIncluded = new SqlParameter("AugerMiningIncluded", SqlDbType.Bit);
            SqlParameter _AugerMiningPlanDescription = new SqlParameter("AugerMiningPlanDescription", SqlDbType.VarChar);
            SqlParameter _BackfillAndGradingPlanDescription = new SqlParameter("BackfillAndGradingPlanDescription", SqlDbType.VarChar);
            SqlParameter _DrainageBasinReclamationPlanDescription = new SqlParameter("DrainageBasinReclamationPlanDescription", SqlDbType.VarChar);
            SqlParameter _SoilHandlingPlanDescription = new SqlParameter("SoilHandlingPlanDescription", SqlDbType.VarChar);
            SqlParameter _PostmineRevegetationTypesDiscussion = new SqlParameter("PostmineRevegetationTypesDiscussion", SqlDbType.VarChar);
            SqlParameter _SealedMineOpeningsPlanDescription = new SqlParameter("SealedMineOpeningsPlanDescription", SqlDbType.VarChar);
            SqlParameter _CADDrawing = new SqlParameter("CADDrawing", SqlDbType.Bit);
            SqlParameter _Completeness = new SqlParameter("Completeness", SqlDbType.Bit);
            SqlParameter _Acceptability = new SqlParameter("Acceptability", SqlDbType.Bit);
            SqlParameter _AccessCode = new SqlParameter("AccessCode", SqlDbType.VarChar);
            SqlParameter _AssignedTo = new SqlParameter("AssignedTo", SqlDbType.VarChar);
            SqlParameter _CompletenessRound = new SqlParameter("CompletenessRound", SqlDbType.TinyInt);
            SqlParameter _AcceptabilityRound = new SqlParameter("AcceptabilityRound", SqlDbType.TinyInt);
            SqlParameter _FacilitiesManagementPlan = new SqlParameter("FacilitiesManagementPlan", SqlDbType.VarChar);
            SqlParameter _FacilitiesReclamationPlan = new SqlParameter("FacilitiesReclamationPlan", SqlDbType.VarChar);
            SqlParameter _CoalPreparation = new SqlParameter("CoalPreparation", SqlDbType.Bit);
            SqlParameter _BondSurety = new SqlParameter("BondSurety", SqlDbType.Bit);
            SqlParameter _BondCollateral = new SqlParameter("BondCollateral", SqlDbType.Bit);
            SqlParameter _ExpirationDateOfInsurance = new SqlParameter("ExpirationDateOfInsurance", SqlDbType.DateTime);
            SqlParameter _MasterCAD = new SqlParameter("MasterCAD", SqlDbType.Bit);
            SqlParameter _GeologicInformationMiningIdentified = new SqlParameter("GeologicInformationMiningIdentified", SqlDbType.Bit);
            SqlParameter _NotAllCoalWillBeMined = new SqlParameter("NotAllCoalWillBeMined", SqlDbType.Bit);
            SqlParameter _EndOfLifeActivitiesComments = new SqlParameter("EndOfLifeActivitiesComments", SqlDbType.VarChar);
            SqlParameter _PreviouslyMined = new SqlParameter("PreviouslyMined", SqlDbType.Bit);
            SqlParameter _GeneralPlanForSedimentationPondsAndWaterImpoundments = new SqlParameter("GeneralPlanForSedimentationPondsAndWaterImpoundments", SqlDbType.VarChar);
            SqlParameter _PostMineLandUseComments = new SqlParameter("PostMineLandUseComments", SqlDbType.VarChar);
            SqlParameter _LandUseComments = new SqlParameter("LandUseComments", SqlDbType.VarChar);
            SqlParameter _ReviewStateID = new SqlParameter("ReviewStateID", SqlDbType.VarChar);
            SqlParameter _OtherPermitInformationProspecting = new SqlParameter("OtherPermitInformationProspecting", SqlDbType.VarChar);
            SqlParameter _OtherPermitInformationBonding = new SqlParameter("OtherPermitInformationBonding", SqlDbType.VarChar);
            SqlParameter _OtherPermitInformationSpecialDepartmentalProgramProcedures = new SqlParameter("OtherPermitInformationSpecialDepartmentalProgramProcedures", SqlDbType.VarChar);
            SqlParameter _OtherPermitInformationMiscellaneousProvisions = new SqlParameter("OtherPermitInformationMiscellaneousProvisions", SqlDbType.VarChar);
            SqlParameter _OtherPermitInformationDefinitions = new SqlParameter("OtherPermitInformationDefinitions", SqlDbType.Bit);
            SqlParameter _OtherPermitInformationFormatSupplementalInformation = new SqlParameter("OtherPermitInformationFormatSupplementalInformation", SqlDbType.Bit);
            SqlParameter _SynchTo = new SqlParameter("SynchTo", SqlDbType.Int);
            SqlParameter _RevisionDescription = new SqlParameter("RevisionDescription", SqlDbType.VarChar);
            SqlParameter _PendingWithdraw = new SqlParameter("PendingWithdraw", SqlDbType.VarChar);
            
            _PermitKey.Value = DO.PermitKey;
            _PermitID.Value = DO.PermitID;
            _ApplicationTypeID.Value = DO.ApplicationTypeID;
            _PermitStatusID.Value = DO.PermitStatusID;
            _StatusDate.Value = DO.StatusDate;
            _ApplicationNumber.Value = DO.ApplicationNumber;
            _ApplicationDescriptionOfInterests.Value = DO.ApplicationDescriptionOfInterests;
            _SiteName.Value = DO.SiteName;
            _MineTypeID.Value = DO.MineTypeID;
            _MSHAID.Value = DO.MSHAID;
            _ProposedReminedAcres.Value = DO.ProposedReminedAcres;
            _LegalDescriptionOfAccess.Value = DO.LegalDescriptionOfAccess;
            _Latitude.Value = DO.Latitude;
            _Longitude.Value = DO.Longitude;
            _NewspaperName.Value = DO.NewspaperName;
            _NearestTown.Value = DO.NearestTown;
            _LegalRightToEnter.Value = DO.LegalRightToEnter;
            _LitigationStatus.Value = DO.LitigationStatus;
            _StatusOfLitigation.Value = DO.StatusOfLitigation;
            _LandsUnsuitable.Value = DO.LandsUnsuitable;
            _LifeOfMineYears.Value = DO.LifeOfMineYears;
            _AnnualAnticipatedProductionInTons.Value = DO.AnnualAnticipatedProductionInTons;
            _TotalAnticipatedProductionInTons.Value = DO.TotalAnticipatedProductionInTons;
            _LifeOfMineComments.Value = DO.LifeOfMineComments;
            _OtherBondFormDescription.Value = DO.OtherBondFormDescription;
            _CulturalResourcesDescription.Value = DO.CulturalResourcesDescription;
            _UniqueSpecialCharacteristicsAndGeologicFormations.Value = DO.UniqueSpecialCharacteristicsAndGeologicFormations;
            _UniqueSpecialCharacteristicsAdverselyAffectedByMining.Value = DO.UniqueSpecialCharacteristicsAdverselyAffectedByMining;
            _GeologicInformationUndesirable.Value = DO.GeologicInformationUndesirable;
            _AverageWindDirection.Value = DO.AverageWindDirection;
            _AverageWindVelocity.Value = DO.AverageWindVelocity;
            _PrimeFarmlandInvestigation.Value = DO.PrimeFarmlandInvestigation;
            _ResourcesAffectedByProposedOperation.Value = DO.ResourcesAffectedByProposedOperation;
            _ResourcesAffectedByProposedOperationDescription.Value = DO.ResourcesAffectedByProposedOperationDescription;
            _ProposedMiningWithinPublicRoads.Value = DO.ProposedMiningWithinPublicRoads;
            _ProposedMiningWithinPublicRoadsDescription.Value = DO.ProposedMiningWithinPublicRoadsDescription;
            _AdjacentToValleyHoldingStream.Value = DO.AdjacentToValleyHoldingStream;
            _AlluvialValleyFloorDeterminationRequested.Value = DO.AlluvialValleyFloorDeterminationRequested;
            _TypeAndMethodOfMiningPlanDescription.Value = DO.TypeAndMethodOfMiningPlanDescription;
            _AnnualAnticipatedMiningProductionInTons.Value = DO.AnnualAnticipatedMiningProductionInTons;
            _TotalAnticipatedMiningProductionInTons.Value = DO.TotalAnticipatedMiningProductionInTons;
            _TotalMiningReservesInTons.Value = DO.TotalMiningReservesInTons;
            _ToxicAndUndesirableMaterialsDisposalPlan.Value = DO.ToxicAndUndesirableMaterialsDisposalPlan;
            _FireContingencyPlan.Value = DO.FireContingencyPlan;
            _ComplianceWithAirAndWaterQualityLaws.Value = DO.ComplianceWithAirAndWaterQualityLaws;
            _NoxiousWeedsManagementPlan.Value = DO.NoxiousWeedsManagementPlan;
            _BlastingPlan.Value = DO.BlastingPlan;
            _AirPollutionControlPlan.Value = DO.AirPollutionControlPlan;
            _FishAndWildlifePlan.Value = DO.FishAndWildlifePlan;
            _MiningConductedWithin500FeetUndergroundMine.Value = DO.MiningConductedWithin500FeetUndergroundMine;
            _MiningConductedWithin500FeetUndergroundMineDescription.Value = DO.MiningConductedWithin500FeetUndergroundMineDescription;
            _DiversionConstructed.Value = DO.DiversionConstructed;
            _DisposalOfExcessSpoilRequired.Value = DO.DisposalOfExcessSpoilRequired;
            _TransportationFacilitiesPlanDescription.Value = DO.TransportationFacilitiesPlanDescription;
            _CoalConservationPlanDescription.Value = DO.CoalConservationPlanDescription;
            _AugerMiningIncluded.Value = DO.AugerMiningIncluded;
            _AugerMiningPlanDescription.Value = DO.AugerMiningPlanDescription;
            _BackfillAndGradingPlanDescription.Value = DO.BackfillAndGradingPlanDescription;
            _DrainageBasinReclamationPlanDescription.Value = DO.DrainageBasinReclamationPlanDescription;
            _SoilHandlingPlanDescription.Value = DO.SoilHandlingPlanDescription;
            _PostmineRevegetationTypesDiscussion.Value = DO.PostmineRevegetationTypesDiscussion;
            _SealedMineOpeningsPlanDescription.Value = DO.SealedMineOpeningsPlanDescription;
            _CADDrawing.Value = DO.CADDrawing;
            _Completeness.Value = DO.Completeness;
            _Acceptability.Value = DO.Acceptability;
            _AccessCode.Value = DO.AccessCode;
            _AssignedTo.Value = DO.AssignedTo;
            _CompletenessRound.Value = DO.CompletenessRound;
            _AcceptabilityRound.Value = DO.AcceptabilityRound;
            _FacilitiesManagementPlan.Value = DO.FacilitiesManagementPlan;
            _FacilitiesReclamationPlan.Value = DO.FacilitiesReclamationPlan;
            _CoalPreparation.Value = DO.CoalPreparation;
            _BondSurety.Value = DO.BondSurety;
            _BondCollateral.Value = DO.BondCollateral;
            _ExpirationDateOfInsurance.Value = DO.ExpirationDateOfInsurance;
            _MasterCAD.Value = DO.MasterCAD;
            _GeologicInformationMiningIdentified.Value = DO.GeologicInformationMiningIdentified;
            _NotAllCoalWillBeMined.Value = DO.NotAllCoalWillBeMined;
            _EndOfLifeActivitiesComments.Value = DO.EndOfLifeActivitiesComments;
            _PreviouslyMined.Value = DO.PreviouslyMined;
            _GeneralPlanForSedimentationPondsAndWaterImpoundments.Value = DO.GeneralPlanForSedimentationPondsAndWaterImpoundments;
            _PostMineLandUseComments.Value = DO.PostMineLandUseComments;
            _LandUseComments.Value = DO.LandUseComments;
            _ReviewStateID.Value = DO.ReviewStateID;
            _OtherPermitInformationProspecting.Value = DO.OtherPermitInformationProspecting;
            _OtherPermitInformationBonding.Value = DO.OtherPermitInformationBonding;
            _OtherPermitInformationSpecialDepartmentalProgramProcedures.Value = DO.OtherPermitInformationSpecialDepartmentalProgramProcedures;
            _OtherPermitInformationMiscellaneousProvisions.Value = DO.OtherPermitInformationMiscellaneousProvisions;
            _OtherPermitInformationDefinitions.Value = DO.OtherPermitInformationDefinitions;
            _OtherPermitInformationFormatSupplementalInformation.Value = DO.OtherPermitInformationFormatSupplementalInformation;
            _SynchTo.Value = DO.SynchTo;
            _RevisionDescription.Value = DO.RevisionDescription;
            _PendingWithdraw.Value = DO.PendingWithdraw;
            
            SqlParameter[] _params = new SqlParameter[] {
                _PermitKey,
                _PermitID,
                _ApplicationTypeID,
                _PermitStatusID,
                _StatusDate,
                _ApplicationNumber,
                _ApplicationDescriptionOfInterests,
                _SiteName,
                _MineTypeID,
                _MSHAID,
                _ProposedReminedAcres,
                _LegalDescriptionOfAccess,
                _Latitude,
                _Longitude,
                _NewspaperName,
                _NearestTown,
                _LegalRightToEnter,
                _LitigationStatus,
                _StatusOfLitigation,
                _LandsUnsuitable,
                _LifeOfMineYears,
                _AnnualAnticipatedProductionInTons,
                _TotalAnticipatedProductionInTons,
                _LifeOfMineComments,
                _OtherBondFormDescription,
                _CulturalResourcesDescription,
                _UniqueSpecialCharacteristicsAndGeologicFormations,
                _UniqueSpecialCharacteristicsAdverselyAffectedByMining,
                _GeologicInformationUndesirable,
                _AverageWindDirection,
                _AverageWindVelocity,
                _PrimeFarmlandInvestigation,
                _ResourcesAffectedByProposedOperation,
                _ResourcesAffectedByProposedOperationDescription,
                _ProposedMiningWithinPublicRoads,
                _ProposedMiningWithinPublicRoadsDescription,
                _AdjacentToValleyHoldingStream,
                _AlluvialValleyFloorDeterminationRequested,
                _TypeAndMethodOfMiningPlanDescription,
                _AnnualAnticipatedMiningProductionInTons,
                _TotalAnticipatedMiningProductionInTons,
                _TotalMiningReservesInTons,
                _ToxicAndUndesirableMaterialsDisposalPlan,
                _FireContingencyPlan,
                _ComplianceWithAirAndWaterQualityLaws,
                _NoxiousWeedsManagementPlan,
                _BlastingPlan,
                _AirPollutionControlPlan,
                _FishAndWildlifePlan,
                _MiningConductedWithin500FeetUndergroundMine,
                _MiningConductedWithin500FeetUndergroundMineDescription,
                _DiversionConstructed,
                _DisposalOfExcessSpoilRequired,
                _TransportationFacilitiesPlanDescription,
                _CoalConservationPlanDescription,
                _AugerMiningIncluded,
                _AugerMiningPlanDescription,
                _BackfillAndGradingPlanDescription,
                _DrainageBasinReclamationPlanDescription,
                _SoilHandlingPlanDescription,
                _PostmineRevegetationTypesDiscussion,
                _SealedMineOpeningsPlanDescription,
                _CADDrawing,
                _Completeness,
                _Acceptability,
                _AccessCode,
                _AssignedTo,
                _CompletenessRound,
                _AcceptabilityRound,
                _FacilitiesManagementPlan,
                _FacilitiesReclamationPlan,
                _CoalPreparation,
                _BondSurety,
                _BondCollateral,
                _ExpirationDateOfInsurance,
                _MasterCAD,
                _GeologicInformationMiningIdentified,
                _NotAllCoalWillBeMined,
                _EndOfLifeActivitiesComments,
                _PreviouslyMined,
                _GeneralPlanForSedimentationPondsAndWaterImpoundments,
                _PostMineLandUseComments,
                _LandUseComments,
                _ReviewStateID,
                _OtherPermitInformationProspecting,
                _OtherPermitInformationBonding,
                _OtherPermitInformationSpecialDepartmentalProgramProcedures,
                _OtherPermitInformationMiscellaneousProvisions,
                _OtherPermitInformationDefinitions,
                _OtherPermitInformationFormatSupplementalInformation,
                _SynchTo,
                _RevisionDescription,
                _PendingWithdraw
            };

            string pid = ConfigurationManager.AppSettings["ePermitDAL"];

            return await DataCommon.ExecuteScalarAsync("[dbo].[Permit_Update]", _params, pid);
        }
Example #3
0
        /// <summary>
        /// Selects Permit records by PK
        /// </summary>
        public static async Task<PermitDO[]> 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].[Permit_GetByPK]", _params, pid);


            List<PermitDO> objs = new List<PermitDO>();
			
            while(sr.Read())
            {
                PermitDO obj = new PermitDO();
				
                obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
                obj.ApplicationTypeID = sr.GetString(sr.GetOrdinal("ApplicationTypeID"));
                obj.PermitStatusID = sr.GetString(sr.GetOrdinal("PermitStatusID"));
                obj.SiteName = sr.GetString(sr.GetOrdinal("SiteName"));
                obj.AccessCode = sr.GetString(sr.GetOrdinal("AccessCode"));
                if (sr.IsDBNull(sr.GetOrdinal("PermitID"))) { obj.PermitID = null; } else { obj.PermitID = sr.GetString(sr.GetOrdinal("PermitID")); }
                if (sr.IsDBNull(sr.GetOrdinal("StatusDate"))) { obj.StatusDate = null; } else { obj.StatusDate = sr.GetDateTime(sr.GetOrdinal("StatusDate")); }
                if (sr.IsDBNull(sr.GetOrdinal("ApplicationNumber"))) { obj.ApplicationNumber = null; } else { obj.ApplicationNumber = sr.GetString(sr.GetOrdinal("ApplicationNumber")); }
                if (sr.IsDBNull(sr.GetOrdinal("ApplicationDescriptionOfInterests"))) { obj.ApplicationDescriptionOfInterests = null; } else { obj.ApplicationDescriptionOfInterests = sr.GetString(sr.GetOrdinal("ApplicationDescriptionOfInterests")); }
                if (sr.IsDBNull(sr.GetOrdinal("MineTypeID"))) { obj.MineTypeID = null; } else { obj.MineTypeID = sr.GetString(sr.GetOrdinal("MineTypeID")); }
                if (sr.IsDBNull(sr.GetOrdinal("MSHAID"))) { obj.MSHAID = null; } else { obj.MSHAID = sr.GetString(sr.GetOrdinal("MSHAID")); }
                if (sr.IsDBNull(sr.GetOrdinal("ProposedReminedAcres"))) { obj.ProposedReminedAcres = null; } else { obj.ProposedReminedAcres = sr.GetInt32(sr.GetOrdinal("ProposedReminedAcres")); }
                if (sr.IsDBNull(sr.GetOrdinal("LegalDescriptionOfAccess"))) { obj.LegalDescriptionOfAccess = null; } else { obj.LegalDescriptionOfAccess = sr.GetString(sr.GetOrdinal("LegalDescriptionOfAccess")); }
                if (sr.IsDBNull(sr.GetOrdinal("Latitude"))) { obj.Latitude = null; } else { obj.Latitude = sr.GetString(sr.GetOrdinal("Latitude")); }
                if (sr.IsDBNull(sr.GetOrdinal("Longitude"))) { obj.Longitude = null; } else { obj.Longitude = sr.GetString(sr.GetOrdinal("Longitude")); }
                if (sr.IsDBNull(sr.GetOrdinal("NewspaperName"))) { obj.NewspaperName = null; } else { obj.NewspaperName = sr.GetString(sr.GetOrdinal("NewspaperName")); }
                if (sr.IsDBNull(sr.GetOrdinal("NearestTown"))) { obj.NearestTown = null; } else { obj.NearestTown = sr.GetString(sr.GetOrdinal("NearestTown")); }
                if (sr.IsDBNull(sr.GetOrdinal("LegalRightToEnter"))) { obj.LegalRightToEnter = null; } else { obj.LegalRightToEnter = sr.GetString(sr.GetOrdinal("LegalRightToEnter")); }
                if (sr.IsDBNull(sr.GetOrdinal("LitigationStatus"))) { obj.LitigationStatus = null; } else { obj.LitigationStatus = sr.GetBoolean(sr.GetOrdinal("LitigationStatus")); }
                if (sr.IsDBNull(sr.GetOrdinal("StatusOfLitigation"))) { obj.StatusOfLitigation = null; } else { obj.StatusOfLitigation = sr.GetString(sr.GetOrdinal("StatusOfLitigation")); }
                if (sr.IsDBNull(sr.GetOrdinal("LandsUnsuitable"))) { obj.LandsUnsuitable = null; } else { obj.LandsUnsuitable = sr.GetBoolean(sr.GetOrdinal("LandsUnsuitable")); }
                if (sr.IsDBNull(sr.GetOrdinal("LifeOfMineYears"))) { obj.LifeOfMineYears = null; } else { obj.LifeOfMineYears = sr.GetInt32(sr.GetOrdinal("LifeOfMineYears")); }
                if (sr.IsDBNull(sr.GetOrdinal("AnnualAnticipatedProductionInTons"))) { obj.AnnualAnticipatedProductionInTons = null; } else { obj.AnnualAnticipatedProductionInTons = sr.GetInt32(sr.GetOrdinal("AnnualAnticipatedProductionInTons")); }
                if (sr.IsDBNull(sr.GetOrdinal("TotalAnticipatedProductionInTons"))) { obj.TotalAnticipatedProductionInTons = null; } else { obj.TotalAnticipatedProductionInTons = sr.GetInt32(sr.GetOrdinal("TotalAnticipatedProductionInTons")); }
                if (sr.IsDBNull(sr.GetOrdinal("LifeOfMineComments"))) { obj.LifeOfMineComments = null; } else { obj.LifeOfMineComments = sr.GetString(sr.GetOrdinal("LifeOfMineComments")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherBondFormDescription"))) { obj.OtherBondFormDescription = null; } else { obj.OtherBondFormDescription = sr.GetString(sr.GetOrdinal("OtherBondFormDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("CulturalResourcesDescription"))) { obj.CulturalResourcesDescription = null; } else { obj.CulturalResourcesDescription = sr.GetString(sr.GetOrdinal("CulturalResourcesDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("UniqueSpecialCharacteristicsAndGeologicFormations"))) { obj.UniqueSpecialCharacteristicsAndGeologicFormations = null; } else { obj.UniqueSpecialCharacteristicsAndGeologicFormations = sr.GetString(sr.GetOrdinal("UniqueSpecialCharacteristicsAndGeologicFormations")); }
                if (sr.IsDBNull(sr.GetOrdinal("UniqueSpecialCharacteristicsAdverselyAffectedByMining"))) { obj.UniqueSpecialCharacteristicsAdverselyAffectedByMining = null; } else { obj.UniqueSpecialCharacteristicsAdverselyAffectedByMining = sr.GetBoolean(sr.GetOrdinal("UniqueSpecialCharacteristicsAdverselyAffectedByMining")); }
                if (sr.IsDBNull(sr.GetOrdinal("GeologicInformationUndesirable"))) { obj.GeologicInformationUndesirable = null; } else { obj.GeologicInformationUndesirable = sr.GetBoolean(sr.GetOrdinal("GeologicInformationUndesirable")); }
                if (sr.IsDBNull(sr.GetOrdinal("AverageWindDirection"))) { obj.AverageWindDirection = null; } else { obj.AverageWindDirection = sr.GetString(sr.GetOrdinal("AverageWindDirection")); }
                if (sr.IsDBNull(sr.GetOrdinal("AverageWindVelocity"))) { obj.AverageWindVelocity = null; } else { obj.AverageWindVelocity = sr.GetDecimal(sr.GetOrdinal("AverageWindVelocity")); }
                if (sr.IsDBNull(sr.GetOrdinal("PrimeFarmlandInvestigation"))) { obj.PrimeFarmlandInvestigation = null; } else { obj.PrimeFarmlandInvestigation = sr.GetBoolean(sr.GetOrdinal("PrimeFarmlandInvestigation")); }
                if (sr.IsDBNull(sr.GetOrdinal("ResourcesAffectedByProposedOperation"))) { obj.ResourcesAffectedByProposedOperation = null; } else { obj.ResourcesAffectedByProposedOperation = sr.GetBoolean(sr.GetOrdinal("ResourcesAffectedByProposedOperation")); }
                if (sr.IsDBNull(sr.GetOrdinal("ResourcesAffectedByProposedOperationDescription"))) { obj.ResourcesAffectedByProposedOperationDescription = null; } else { obj.ResourcesAffectedByProposedOperationDescription = sr.GetString(sr.GetOrdinal("ResourcesAffectedByProposedOperationDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("ProposedMiningWithinPublicRoads"))) { obj.ProposedMiningWithinPublicRoads = null; } else { obj.ProposedMiningWithinPublicRoads = sr.GetBoolean(sr.GetOrdinal("ProposedMiningWithinPublicRoads")); }
                if (sr.IsDBNull(sr.GetOrdinal("ProposedMiningWithinPublicRoadsDescription"))) { obj.ProposedMiningWithinPublicRoadsDescription = null; } else { obj.ProposedMiningWithinPublicRoadsDescription = sr.GetString(sr.GetOrdinal("ProposedMiningWithinPublicRoadsDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("AdjacentToValleyHoldingStream"))) { obj.AdjacentToValleyHoldingStream = null; } else { obj.AdjacentToValleyHoldingStream = sr.GetBoolean(sr.GetOrdinal("AdjacentToValleyHoldingStream")); }
                if (sr.IsDBNull(sr.GetOrdinal("AlluvialValleyFloorDeterminationRequested"))) { obj.AlluvialValleyFloorDeterminationRequested = null; } else { obj.AlluvialValleyFloorDeterminationRequested = sr.GetBoolean(sr.GetOrdinal("AlluvialValleyFloorDeterminationRequested")); }
                if (sr.IsDBNull(sr.GetOrdinal("TypeAndMethodOfMiningPlanDescription"))) { obj.TypeAndMethodOfMiningPlanDescription = null; } else { obj.TypeAndMethodOfMiningPlanDescription = sr.GetString(sr.GetOrdinal("TypeAndMethodOfMiningPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("AnnualAnticipatedMiningProductionInTons"))) { obj.AnnualAnticipatedMiningProductionInTons = null; } else { obj.AnnualAnticipatedMiningProductionInTons = sr.GetInt32(sr.GetOrdinal("AnnualAnticipatedMiningProductionInTons")); }
                if (sr.IsDBNull(sr.GetOrdinal("TotalAnticipatedMiningProductionInTons"))) { obj.TotalAnticipatedMiningProductionInTons = null; } else { obj.TotalAnticipatedMiningProductionInTons = sr.GetInt32(sr.GetOrdinal("TotalAnticipatedMiningProductionInTons")); }
                if (sr.IsDBNull(sr.GetOrdinal("TotalMiningReservesInTons"))) { obj.TotalMiningReservesInTons = null; } else { obj.TotalMiningReservesInTons = sr.GetInt32(sr.GetOrdinal("TotalMiningReservesInTons")); }
                if (sr.IsDBNull(sr.GetOrdinal("ToxicAndUndesirableMaterialsDisposalPlan"))) { obj.ToxicAndUndesirableMaterialsDisposalPlan = null; } else { obj.ToxicAndUndesirableMaterialsDisposalPlan = sr.GetString(sr.GetOrdinal("ToxicAndUndesirableMaterialsDisposalPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("FireContingencyPlan"))) { obj.FireContingencyPlan = null; } else { obj.FireContingencyPlan = sr.GetString(sr.GetOrdinal("FireContingencyPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("ComplianceWithAirAndWaterQualityLaws"))) { obj.ComplianceWithAirAndWaterQualityLaws = null; } else { obj.ComplianceWithAirAndWaterQualityLaws = sr.GetString(sr.GetOrdinal("ComplianceWithAirAndWaterQualityLaws")); }
                if (sr.IsDBNull(sr.GetOrdinal("NoxiousWeedsManagementPlan"))) { obj.NoxiousWeedsManagementPlan = null; } else { obj.NoxiousWeedsManagementPlan = sr.GetString(sr.GetOrdinal("NoxiousWeedsManagementPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("BlastingPlan"))) { obj.BlastingPlan = null; } else { obj.BlastingPlan = sr.GetString(sr.GetOrdinal("BlastingPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("AirPollutionControlPlan"))) { obj.AirPollutionControlPlan = null; } else { obj.AirPollutionControlPlan = sr.GetString(sr.GetOrdinal("AirPollutionControlPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("FishAndWildlifePlan"))) { obj.FishAndWildlifePlan = null; } else { obj.FishAndWildlifePlan = sr.GetString(sr.GetOrdinal("FishAndWildlifePlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("MiningConductedWithin500FeetUndergroundMine"))) { obj.MiningConductedWithin500FeetUndergroundMine = null; } else { obj.MiningConductedWithin500FeetUndergroundMine = sr.GetBoolean(sr.GetOrdinal("MiningConductedWithin500FeetUndergroundMine")); }
                if (sr.IsDBNull(sr.GetOrdinal("MiningConductedWithin500FeetUndergroundMineDescription"))) { obj.MiningConductedWithin500FeetUndergroundMineDescription = null; } else { obj.MiningConductedWithin500FeetUndergroundMineDescription = sr.GetString(sr.GetOrdinal("MiningConductedWithin500FeetUndergroundMineDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("DiversionConstructed"))) { obj.DiversionConstructed = null; } else { obj.DiversionConstructed = sr.GetBoolean(sr.GetOrdinal("DiversionConstructed")); }
                if (sr.IsDBNull(sr.GetOrdinal("DisposalOfExcessSpoilRequired"))) { obj.DisposalOfExcessSpoilRequired = null; } else { obj.DisposalOfExcessSpoilRequired = sr.GetBoolean(sr.GetOrdinal("DisposalOfExcessSpoilRequired")); }
                if (sr.IsDBNull(sr.GetOrdinal("TransportationFacilitiesPlanDescription"))) { obj.TransportationFacilitiesPlanDescription = null; } else { obj.TransportationFacilitiesPlanDescription = sr.GetString(sr.GetOrdinal("TransportationFacilitiesPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("CoalConservationPlanDescription"))) { obj.CoalConservationPlanDescription = null; } else { obj.CoalConservationPlanDescription = sr.GetString(sr.GetOrdinal("CoalConservationPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("AugerMiningIncluded"))) { obj.AugerMiningIncluded = null; } else { obj.AugerMiningIncluded = sr.GetBoolean(sr.GetOrdinal("AugerMiningIncluded")); }
                if (sr.IsDBNull(sr.GetOrdinal("AugerMiningPlanDescription"))) { obj.AugerMiningPlanDescription = null; } else { obj.AugerMiningPlanDescription = sr.GetString(sr.GetOrdinal("AugerMiningPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("BackfillAndGradingPlanDescription"))) { obj.BackfillAndGradingPlanDescription = null; } else { obj.BackfillAndGradingPlanDescription = sr.GetString(sr.GetOrdinal("BackfillAndGradingPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("DrainageBasinReclamationPlanDescription"))) { obj.DrainageBasinReclamationPlanDescription = null; } else { obj.DrainageBasinReclamationPlanDescription = sr.GetString(sr.GetOrdinal("DrainageBasinReclamationPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("SoilHandlingPlanDescription"))) { obj.SoilHandlingPlanDescription = null; } else { obj.SoilHandlingPlanDescription = sr.GetString(sr.GetOrdinal("SoilHandlingPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("PostmineRevegetationTypesDiscussion"))) { obj.PostmineRevegetationTypesDiscussion = null; } else { obj.PostmineRevegetationTypesDiscussion = sr.GetString(sr.GetOrdinal("PostmineRevegetationTypesDiscussion")); }
                if (sr.IsDBNull(sr.GetOrdinal("SealedMineOpeningsPlanDescription"))) { obj.SealedMineOpeningsPlanDescription = null; } else { obj.SealedMineOpeningsPlanDescription = sr.GetString(sr.GetOrdinal("SealedMineOpeningsPlanDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("CADDrawing"))) { obj.CADDrawing = null; } else { obj.CADDrawing = sr.GetBoolean(sr.GetOrdinal("CADDrawing")); }
                if (sr.IsDBNull(sr.GetOrdinal("Completeness"))) { obj.Completeness = null; } else { obj.Completeness = sr.GetBoolean(sr.GetOrdinal("Completeness")); }
                if (sr.IsDBNull(sr.GetOrdinal("Acceptability"))) { obj.Acceptability = null; } else { obj.Acceptability = sr.GetBoolean(sr.GetOrdinal("Acceptability")); }
                if (sr.IsDBNull(sr.GetOrdinal("AssignedTo"))) { obj.AssignedTo = null; } else { obj.AssignedTo = sr.GetString(sr.GetOrdinal("AssignedTo")); }
                if (sr.IsDBNull(sr.GetOrdinal("CompletenessRound"))) { obj.CompletenessRound = null; } else { obj.CompletenessRound = sr.GetInt16(sr.GetOrdinal("CompletenessRound")); }
                if (sr.IsDBNull(sr.GetOrdinal("AcceptabilityRound"))) { obj.AcceptabilityRound = null; } else { obj.AcceptabilityRound = sr.GetInt16(sr.GetOrdinal("AcceptabilityRound")); }
                if (sr.IsDBNull(sr.GetOrdinal("FacilitiesManagementPlan"))) { obj.FacilitiesManagementPlan = null; } else { obj.FacilitiesManagementPlan = sr.GetString(sr.GetOrdinal("FacilitiesManagementPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("FacilitiesReclamationPlan"))) { obj.FacilitiesReclamationPlan = null; } else { obj.FacilitiesReclamationPlan = sr.GetString(sr.GetOrdinal("FacilitiesReclamationPlan")); }
                if (sr.IsDBNull(sr.GetOrdinal("CoalPreparation"))) { obj.CoalPreparation = null; } else { obj.CoalPreparation = sr.GetBoolean(sr.GetOrdinal("CoalPreparation")); }
                if (sr.IsDBNull(sr.GetOrdinal("BondSurety"))) { obj.BondSurety = null; } else { obj.BondSurety = sr.GetBoolean(sr.GetOrdinal("BondSurety")); }
                if (sr.IsDBNull(sr.GetOrdinal("BondCollateral"))) { obj.BondCollateral = null; } else { obj.BondCollateral = sr.GetBoolean(sr.GetOrdinal("BondCollateral")); }
                if (sr.IsDBNull(sr.GetOrdinal("ExpirationDateOfInsurance"))) { obj.ExpirationDateOfInsurance = null; } else { obj.ExpirationDateOfInsurance = sr.GetDateTime(sr.GetOrdinal("ExpirationDateOfInsurance")); }
                if (sr.IsDBNull(sr.GetOrdinal("MasterCAD"))) { obj.MasterCAD = null; } else { obj.MasterCAD = sr.GetBoolean(sr.GetOrdinal("MasterCAD")); }
                if (sr.IsDBNull(sr.GetOrdinal("GeologicInformationMiningIdentified"))) { obj.GeologicInformationMiningIdentified = null; } else { obj.GeologicInformationMiningIdentified = sr.GetBoolean(sr.GetOrdinal("GeologicInformationMiningIdentified")); }
                if (sr.IsDBNull(sr.GetOrdinal("NotAllCoalWillBeMined"))) { obj.NotAllCoalWillBeMined = null; } else { obj.NotAllCoalWillBeMined = sr.GetBoolean(sr.GetOrdinal("NotAllCoalWillBeMined")); }
                if (sr.IsDBNull(sr.GetOrdinal("EndOfLifeActivitiesComments"))) { obj.EndOfLifeActivitiesComments = null; } else { obj.EndOfLifeActivitiesComments = sr.GetString(sr.GetOrdinal("EndOfLifeActivitiesComments")); }
                if (sr.IsDBNull(sr.GetOrdinal("PreviouslyMined"))) { obj.PreviouslyMined = null; } else { obj.PreviouslyMined = sr.GetBoolean(sr.GetOrdinal("PreviouslyMined")); }
                if (sr.IsDBNull(sr.GetOrdinal("GeneralPlanForSedimentationPondsAndWaterImpoundments"))) { obj.GeneralPlanForSedimentationPondsAndWaterImpoundments = null; } else { obj.GeneralPlanForSedimentationPondsAndWaterImpoundments = sr.GetString(sr.GetOrdinal("GeneralPlanForSedimentationPondsAndWaterImpoundments")); }
                if (sr.IsDBNull(sr.GetOrdinal("PostMineLandUseComments"))) { obj.PostMineLandUseComments = null; } else { obj.PostMineLandUseComments = sr.GetString(sr.GetOrdinal("PostMineLandUseComments")); }
                if (sr.IsDBNull(sr.GetOrdinal("LandUseComments"))) { obj.LandUseComments = null; } else { obj.LandUseComments = sr.GetString(sr.GetOrdinal("LandUseComments")); }
                if (sr.IsDBNull(sr.GetOrdinal("ReviewStateID"))) { obj.ReviewStateID = null; } else { obj.ReviewStateID = sr.GetString(sr.GetOrdinal("ReviewStateID")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherPermitInformationProspecting"))) { obj.OtherPermitInformationProspecting = null; } else { obj.OtherPermitInformationProspecting = sr.GetString(sr.GetOrdinal("OtherPermitInformationProspecting")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherPermitInformationBonding"))) { obj.OtherPermitInformationBonding = null; } else { obj.OtherPermitInformationBonding = sr.GetString(sr.GetOrdinal("OtherPermitInformationBonding")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherPermitInformationSpecialDepartmentalProgramProcedures"))) { obj.OtherPermitInformationSpecialDepartmentalProgramProcedures = null; } else { obj.OtherPermitInformationSpecialDepartmentalProgramProcedures = sr.GetString(sr.GetOrdinal("OtherPermitInformationSpecialDepartmentalProgramProcedures")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherPermitInformationMiscellaneousProvisions"))) { obj.OtherPermitInformationMiscellaneousProvisions = null; } else { obj.OtherPermitInformationMiscellaneousProvisions = sr.GetString(sr.GetOrdinal("OtherPermitInformationMiscellaneousProvisions")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherPermitInformationDefinitions"))) { obj.OtherPermitInformationDefinitions = null; } else { obj.OtherPermitInformationDefinitions = sr.GetBoolean(sr.GetOrdinal("OtherPermitInformationDefinitions")); }
                if (sr.IsDBNull(sr.GetOrdinal("OtherPermitInformationFormatSupplementalInformation"))) { obj.OtherPermitInformationFormatSupplementalInformation = null; } else { obj.OtherPermitInformationFormatSupplementalInformation = sr.GetBoolean(sr.GetOrdinal("OtherPermitInformationFormatSupplementalInformation")); }
                if (sr.IsDBNull(sr.GetOrdinal("SynchTo"))) { obj.SynchTo = null; } else { obj.SynchTo = sr.GetInt32(sr.GetOrdinal("SynchTo")); }
                if (sr.IsDBNull(sr.GetOrdinal("RevisionDescription"))) { obj.RevisionDescription = null; } else { obj.RevisionDescription = sr.GetString(sr.GetOrdinal("RevisionDescription")); }
                if (sr.IsDBNull(sr.GetOrdinal("PendingWithdraw"))) { obj.PendingWithdraw = null; } else { obj.PendingWithdraw = sr.GetString(sr.GetOrdinal("PendingWithdraw")); }

                objs.Add(obj);
            }

            return objs.ToArray();
        }
Example #4
0
        /// <summary>
        /// Deletes a Permit record
        /// </summary>
        public static async Task<int> DeleteAsync(PermitDO 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].[Permit_Delete]", _params, pid);
        }
        public ActionResult NewPermit(NewPermitVM model)
        {
            if (!ModelState.IsValid)
                return PartialView(model);

            try
            {
                PermitDO newPermit = new PermitDO() { SiteName = model.SiteName, ApplicationTypeID = "Permit", PermitID = model.PermitId };
                int permitKey = PermitBLL.Save(newPermit, (int)myCoalUser.GetInstance().RegistrationId);
                AjaxResult result = new AjaxResult(AjaxResult.AjaxStatus.OK, "The permit was created");
                result.Data.Add("PermitKey", permitKey);
                return Json(result);
            }
            catch (Exception ex)
            {
                AjaxResult result = new AjaxResult(AjaxResult.AjaxStatus.ERROR, ex.Message);
                return Json(result);
            }
        }