/// <summary>
/// Deletes a LifeOfMinePhase record
/// </summary>
public static int Delete(LifeOfMinePhaseDO DO)
{
SqlParameter _LifeOfMinePhaseID = new SqlParameter("LifeOfMinePhaseID", SqlDbType.Int);
_LifeOfMinePhaseID.Value = DO.LifeOfMinePhaseID;
SqlParameter[] _params = new SqlParameter[] {
_LifeOfMinePhaseID
};
return DataCommon.ExecuteScalar("[dbo].[LifeOfMinePhase_Delete]", _params, "dbo");
}
/// <summary>
/// Gets all LifeOfMinePhase records
/// </summary>
public static LifeOfMinePhaseDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[LifeOfMinePhase_GetAll]", new SqlParameter[] { }, "dbo");
List<LifeOfMinePhaseDO> objs = new List<LifeOfMinePhaseDO>();
while(sr.Read()){
LifeOfMinePhaseDO obj = new LifeOfMinePhaseDO();
obj.LifeOfMinePhaseID = sr.GetInt32(sr.GetOrdinal("LifeOfMinePhaseID"));
obj.LifeOfMinePhaseTypeID = sr.GetString(sr.GetOrdinal("LifeOfMinePhaseTypeID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.StartDate = sr.GetDateTime(sr.GetOrdinal("StartDate"));
obj.EndDate = sr.GetDateTime(sr.GetOrdinal("EndDate"));
obj.Acreage = sr.GetInt32(sr.GetOrdinal("Acreage"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Creates a new LifeOfMinePhase record
/// </summary>
public static int Create(LifeOfMinePhaseDO DO)
{
SqlParameter _LifeOfMinePhaseTypeID = new SqlParameter("LifeOfMinePhaseTypeID", SqlDbType.VarChar);
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _StartDate = new SqlParameter("StartDate", SqlDbType.DateTime);
SqlParameter _EndDate = new SqlParameter("EndDate", SqlDbType.DateTime);
SqlParameter _Acreage = new SqlParameter("Acreage", SqlDbType.Int);
_LifeOfMinePhaseTypeID.Value = DO.LifeOfMinePhaseTypeID;
_PermitKey.Value = DO.PermitKey;
_StartDate.Value = DO.StartDate;
_EndDate.Value = DO.EndDate;
_Acreage.Value = DO.Acreage;
SqlParameter[] _params = new SqlParameter[] {
_LifeOfMinePhaseTypeID,
_PermitKey,
_StartDate,
_EndDate,
_Acreage
};
return DataCommon.ExecuteScalar("[dbo].[LifeOfMinePhase_Insert]", _params, "dbo");
}
/// <summary>
/// Selects LifeOfMinePhase records by PK
/// </summary>
public static LifeOfMinePhaseDO[] GetByPK(Int32 LifeOfMinePhaseID)
{
SqlParameter _LifeOfMinePhaseID = new SqlParameter("LifeOfMinePhaseID", SqlDbType.Int);
_LifeOfMinePhaseID.Value = LifeOfMinePhaseID;
SqlParameter[] _params = new SqlParameter[] {
_LifeOfMinePhaseID
};
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[LifeOfMinePhase_GetByPK]", _params, "dbo");
List<LifeOfMinePhaseDO> objs = new List<LifeOfMinePhaseDO>();
while(sr.Read())
{
LifeOfMinePhaseDO obj = new LifeOfMinePhaseDO();
obj.LifeOfMinePhaseID = sr.GetInt32(sr.GetOrdinal("LifeOfMinePhaseID"));
obj.LifeOfMinePhaseTypeID = sr.GetString(sr.GetOrdinal("LifeOfMinePhaseTypeID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.StartDate = sr.GetDateTime(sr.GetOrdinal("StartDate"));
obj.EndDate = sr.GetDateTime(sr.GetOrdinal("EndDate"));
obj.Acreage = sr.GetInt32(sr.GetOrdinal("Acreage"));
objs.Add(obj);
}
return objs.ToArray();
}