/// <summary>
/// Deletes a MiningEquipment record
/// </summary>
public static int Delete(MiningEquipmentDO DO)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _EquipmentDescription = new SqlParameter("EquipmentDescription", SqlDbType.VarChar);
SqlParameter _Purpose = new SqlParameter("Purpose", SqlDbType.VarChar);
_PermitKey.Value = DO.PermitKey;
_EquipmentDescription.Value = DO.EquipmentDescription;
_Purpose.Value = DO.Purpose;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_EquipmentDescription,
_Purpose
};
return DataCommon.ExecuteScalar("[dbo].[MiningEquipment_Delete]", _params, "dbo");
}
/// <summary>
/// Creates a new MiningEquipment record
/// </summary>
public static void Create(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
};
DataCommon.ExecuteNonQuery("[dbo].[MiningEquipment_Insert]", _params, "dbo");
}
/// <summary>
/// Gets all MiningEquipment records
/// </summary>
public static MiningEquipmentDO[] GetAll()
{
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MiningEquipment_GetAll]", new SqlParameter[] { }, "dbo");
List<MiningEquipmentDO> objs = new List<MiningEquipmentDO>();
while(sr.Read()){
MiningEquipmentDO obj = new MiningEquipmentDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.EquipmentDescription = sr.GetString(sr.GetOrdinal("EquipmentDescription"));
obj.Purpose = sr.GetString(sr.GetOrdinal("Purpose"));
obj.Units = sr.GetInt32(sr.GetOrdinal("Units"));
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Selects MiningEquipment records by PK
/// </summary>
public static MiningEquipmentDO[] GetByPK(Int32 PermitKey,
String EquipmentDescription,
String Purpose)
{
SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
SqlParameter _EquipmentDescription = new SqlParameter("EquipmentDescription", SqlDbType.VarChar);
SqlParameter _Purpose = new SqlParameter("Purpose", SqlDbType.VarChar);
_PermitKey.Value = PermitKey;
_EquipmentDescription.Value = EquipmentDescription;
_Purpose.Value = Purpose;
SqlParameter[] _params = new SqlParameter[] {
_PermitKey,
_EquipmentDescription,
_Purpose
};
SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MiningEquipment_GetByPK]", _params, "dbo");
List<MiningEquipmentDO> objs = new List<MiningEquipmentDO>();
while(sr.Read())
{
MiningEquipmentDO obj = new MiningEquipmentDO();
obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
obj.EquipmentDescription = sr.GetString(sr.GetOrdinal("EquipmentDescription"));
obj.Purpose = sr.GetString(sr.GetOrdinal("Purpose"));
obj.Units = sr.GetInt32(sr.GetOrdinal("Units"));
objs.Add(obj);
}
return objs.ToArray();
}
