public CulturalResourcesAddEditVM(CulturalResourceManagementDO DO)
{
this.CulturalResourceManagementID = DO.CulturalResourceManagementID;
this.SiteID = DO.SiteID;
this.NRHPEligible = DO.NRHPEligible;
this.AdditionalInvestigationRequired = DO.AdditionalInvestigationRequired;
this.MitigationRequired = DO.MitigationRequired;
this.PlannedMitigation = DO.PlannedMitigation;
this.ActualMitigation = DO.ActualMitigation;
this.PlannedDisturbance = DO.PlannedDisturbance;
this.Disturbance = DO.Disturbance;
this.DescriptionOfMitigationEfforts = DO.DescriptionOfMitigationEfforts;
}
/// <summary>
/// Creates a new CulturalResourceManagement record using async
/// </summary>
public static async Task<int> CreateAsync(CulturalResourceManagementDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _SiteID = new SqlParameter("SiteID", SqlDbType.VarChar);
SqlParameter _NRHPEligible = new SqlParameter("NRHPEligible", SqlDbType.Bit);
SqlParameter _AdditionalInvestigationRequired = new SqlParameter("AdditionalInvestigationRequired", SqlDbType.Bit);
SqlParameter _MitigationRequired = new SqlParameter("MitigationRequired", SqlDbType.Bit);
SqlParameter _PlannedMitigation = new SqlParameter("PlannedMitigation", SqlDbType.DateTime);
SqlParameter _ActualMitigation = new SqlParameter("ActualMitigation", SqlDbType.DateTime);
SqlParameter _PlannedDisturbance = new SqlParameter("PlannedDisturbance", SqlDbType.DateTime);
SqlParameter _Disturbance = new SqlParameter("Disturbance", SqlDbType.DateTime);
SqlParameter _DescriptionOfMitigationEfforts = new SqlParameter("DescriptionOfMitigationEfforts", SqlDbType.VarChar);
_PermitKey.Value = DO.PermitKey;
_SiteID.Value = DO.SiteID;
_NRHPEligible.Value = DO.NRHPEligible;
_AdditionalInvestigationRequired.Value = DO.AdditionalInvestigationRequired;
_MitigationRequired.Value = DO.MitigationRequired;
_PlannedMitigation.Value = DO.PlannedMitigation;
_ActualMitigation.Value = DO.ActualMitigation;
_PlannedDisturbance.Value = DO.PlannedDisturbance;
_Disturbance.Value = DO.Disturbance;
_DescriptionOfMitigationEfforts.Value = DO.DescriptionOfMitigationEfforts;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_SiteID,
_NRHPEligible,
_AdditionalInvestigationRequired,
_MitigationRequired,
_PlannedMitigation,
_ActualMitigation,
_PlannedDisturbance,
_Disturbance,
_DescriptionOfMitigationEfforts
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[CulturalResourceManagement_Insert]", _params, pid);
}
public CulturalResourceManagementDO WriteResourceManagementDataToTables()
{
CulturalResourceManagementDO data = new CulturalResourceManagementDO()
{
CulturalResourceManagementID = this.CulturalResourceManagementID,
SiteID = this.SiteID,
NRHPEligible = this.NRHPEligible,
MitigationRequired = this.MitigationRequired,
PermitKey = this.PermitKey,
AdditionalInvestigationRequired = this.AdditionalInvestigationRequired,
PlannedMitigation = this.PlannedMitigation,
ActualMitigation = this.ActualMitigation,
PlannedDisturbance = this.PlannedDisturbance,
Disturbance = this.Disturbance,
DescriptionOfMitigationEfforts = this.DescriptionOfMitigationEfforts
};
return data;
}
public ActionResult CulturalResourcesAdd(int PermitKey)
{
CulturalResourceManagementDO CR = new CulturalResourceManagementDO();
CulturalResourcesAddEditVM model = new CulturalResourcesAddEditVM(CR);
model.PermitKey = PermitKey;
return PartialView("CulturalResourcesAddEdit", model);
}
/// <summary>
/// Selects CulturalResourceManagement records by PK
/// </summary>
public static async Task<CulturalResourceManagementDO[]> GetByPKAsync(Int32 CulturalResourceManagementID)
{
SqlParameter _CulturalResourceManagementID = new SqlParameter("CulturalResourceManagementID", SqlDbType.Int);
_CulturalResourceManagementID.Value = CulturalResourceManagementID;
SqlParameter[] _params = new SqlParameter[] {
_CulturalResourceManagementID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[CulturalResourceManagement_GetByPK]", _params, pid);
List<CulturalResourceManagementDO> objs = new List<CulturalResourceManagementDO>();
while(sr.Read())
{
CulturalResourceManagementDO obj = new CulturalResourceManagementDO();
obj.CulturalResourceManagementID = sr.GetInt32(sr.GetOrdinal("CulturalResourceManagementID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.SiteID = sr.GetString(sr.GetOrdinal("SiteID"));
if (sr.IsDBNull(sr.GetOrdinal("NRHPEligible"))) { obj.NRHPEligible = null; } else { obj.NRHPEligible = sr.GetBoolean(sr.GetOrdinal("NRHPEligible")); }
if (sr.IsDBNull(sr.GetOrdinal("AdditionalInvestigationRequired"))) { obj.AdditionalInvestigationRequired = null; } else { obj.AdditionalInvestigationRequired = sr.GetBoolean(sr.GetOrdinal("AdditionalInvestigationRequired")); }
if (sr.IsDBNull(sr.GetOrdinal("MitigationRequired"))) { obj.MitigationRequired = null; } else { obj.MitigationRequired = sr.GetBoolean(sr.GetOrdinal("MitigationRequired")); }
if (sr.IsDBNull(sr.GetOrdinal("PlannedMitigation"))) { obj.PlannedMitigation = null; } else { obj.PlannedMitigation = sr.GetDateTime(sr.GetOrdinal("PlannedMitigation")); }
if (sr.IsDBNull(sr.GetOrdinal("ActualMitigation"))) { obj.ActualMitigation = null; } else { obj.ActualMitigation = sr.GetDateTime(sr.GetOrdinal("ActualMitigation")); }
if (sr.IsDBNull(sr.GetOrdinal("PlannedDisturbance"))) { obj.PlannedDisturbance = null; } else { obj.PlannedDisturbance = sr.GetDateTime(sr.GetOrdinal("PlannedDisturbance")); }
if (sr.IsDBNull(sr.GetOrdinal("Disturbance"))) { obj.Disturbance = null; } else { obj.Disturbance = sr.GetDateTime(sr.GetOrdinal("Disturbance")); }
if (sr.IsDBNull(sr.GetOrdinal("DescriptionOfMitigationEfforts"))) { obj.DescriptionOfMitigationEfforts = null; } else { obj.DescriptionOfMitigationEfforts = sr.GetString(sr.GetOrdinal("DescriptionOfMitigationEfforts")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a CulturalResourceManagement record
/// </summary>
public static async Task<int> DeleteAsync(CulturalResourceManagementDO DO)
{
SqlParameter _CulturalResourceManagementID = new SqlParameter("CulturalResourceManagementID", SqlDbType.Int);
_CulturalResourceManagementID.Value = DO.CulturalResourceManagementID;
SqlParameter[] _params = new SqlParameter[] {
_CulturalResourceManagementID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[CulturalResourceManagement_Delete]", _params, pid);
}
