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); }