public MiningEquipmentVM(MiningEquipmentDO DO)
{
this.MiningEquipmentID = DO.MiningEquipmentID;
this.EquipmentDescription = DO.EquipmentDescription;
this.PermitKey = DO.PermitKey;
this.Purpose = DO.Purpose;
this.Units = DO.Units;
}
public MiningEquipmentDO WriteDataToTables()
{
MiningEquipmentDO data = new MiningEquipmentDO()
{
MiningEquipmentID = this.MiningEquipmentID,
EquipmentDescription = this.EquipmentDescription,
PermitKey = this.PermitKey,
Purpose = this.Purpose,
Units = this.Units
};
return data;
}
/// <summary>
/// Creates a new MiningEquipment record using async
/// </summary>
public static async Task<int> CreateAsync(MiningEquipmentDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _EquipmentDescription = new SqlParameter("EquipmentDescription", SqlDbType.VarChar);
SqlParameter _Purpose = new SqlParameter("Purpose", SqlDbType.VarChar);
SqlParameter _Units = new SqlParameter("Units", SqlDbType.Int);
_PermitKey.Value = DO.PermitKey;
_EquipmentDescription.Value = DO.EquipmentDescription;
_Purpose.Value = DO.Purpose;
_Units.Value = DO.Units;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_EquipmentDescription,
_Purpose,
_Units
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[MiningEquipment_Insert]", _params, pid);
}
/// <summary>
/// Updates a MiningEquipment record and returns the number of records affected
/// </summary>
public static int Update(MiningEquipmentDO DO)
{
SqlParameter _MiningEquipmentID = new SqlParameter("MiningEquipmentID", SqlDbType.Int);
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _EquipmentDescription = new SqlParameter("EquipmentDescription", SqlDbType.VarChar);
SqlParameter _Purpose = new SqlParameter("Purpose", SqlDbType.VarChar);
SqlParameter _Units = new SqlParameter("Units", SqlDbType.Int);
_MiningEquipmentID.Value = DO.MiningEquipmentID;
_PermitKey.Value = DO.PermitKey;
_EquipmentDescription.Value = DO.EquipmentDescription;
_Purpose.Value = DO.Purpose;
_Units.Value = DO.Units;
SqlParameter[] _params = new SqlParameter[] {
_MiningEquipmentID,
_PermitKey,
_EquipmentDescription,
_Purpose,
_Units
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return DataCommon.ExecuteScalar("[dbo].[MiningEquipment_Update]", _params, pid);
}
/// <summary>
/// Selects MiningEquipment records by PK
/// </summary>
public static async Task<MiningEquipmentDO[]> GetByPKAsync(Int32 MiningEquipmentID)
{
SqlParameter _MiningEquipmentID = new SqlParameter("MiningEquipmentID", SqlDbType.Int);
_MiningEquipmentID.Value = MiningEquipmentID;
SqlParameter[] _params = new SqlParameter[] {
_MiningEquipmentID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[MiningEquipment_GetByPK]", _params, pid);
List<MiningEquipmentDO> objs = new List<MiningEquipmentDO>();
while(sr.Read())
{
MiningEquipmentDO obj = new MiningEquipmentDO();
obj.MiningEquipmentID = sr.GetInt32(sr.GetOrdinal("MiningEquipmentID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.EquipmentDescription = sr.GetString(sr.GetOrdinal("EquipmentDescription"));
obj.Units = sr.GetInt32(sr.GetOrdinal("Units"));
if (sr.IsDBNull(sr.GetOrdinal("Purpose"))) { obj.Purpose = null; } else { obj.Purpose = sr.GetString(sr.GetOrdinal("Purpose")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Gets all MiningEquipment records
/// </summary>
public static MiningEquipmentDO[] GetAll()
{
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MiningEquipment_GetAll]", new SqlParameter[] { }, pid);
List<MiningEquipmentDO> objs = new List<MiningEquipmentDO>();
while(sr.Read()){
MiningEquipmentDO obj = new MiningEquipmentDO();
obj.MiningEquipmentID = sr.GetInt32(sr.GetOrdinal("MiningEquipmentID"));
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.EquipmentDescription = sr.GetString(sr.GetOrdinal("EquipmentDescription"));
obj.Units = sr.GetInt32(sr.GetOrdinal("Units"));
if (sr.IsDBNull(sr.GetOrdinal("Purpose"))) { obj.Purpose = null; } else { obj.Purpose = sr.GetString(sr.GetOrdinal("Purpose")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a MiningEquipment record
/// </summary>
public static async Task<int> DeleteAsync(MiningEquipmentDO DO)
{
SqlParameter _MiningEquipmentID = new SqlParameter("MiningEquipmentID", SqlDbType.Int);
_MiningEquipmentID.Value = DO.MiningEquipmentID;
SqlParameter[] _params = new SqlParameter[] {
_MiningEquipmentID
};
string pid = ConfigurationManager.AppSettings["ePermitDAL"];
return await DataCommon.ExecuteScalarAsync("[dbo].[MiningEquipment_Delete]", _params, pid);
}
