public EquipmentCollection GetAllEquipments() { EquipmentCollection equipments = null; if (this.TryConnection()) { DatabaseParameters keyParameters = new DatabaseParameters(); DataTable table = this.QueryData(keyParameters, this.DataStructrure.Tables.MasterEquipment.ActualTableName); if (table == null) { return(equipments); } equipments = new EquipmentCollection(); foreach (DataRow row in table.Rows) { EquipmentObj obj2 = new EquipmentObj(row[this.DataStructrure.Tables.MasterEquipment.EquipmentID.ActualFieldName].ToString()) { Description = row[this.DataStructrure.Tables.MasterEquipment.EquipmentDescription.ActualFieldName].ToString(), EquipmentObject = row[this.DataStructrure.Tables.MasterEquipment.EquipmentObject.ActualFieldName].ToString(), EquipmentSNR = row[this.DataStructrure.Tables.MasterEquipment.Equipmentsnr.ActualFieldName].ToString(), EquipmentLocation = row[this.DataStructrure.Tables.MasterEquipment.EquipmentLocation.ActualFieldName].ToString(), EquipmentProfileID = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString() }; equipments.Add(obj2); } } return(equipments); }
public bool UpdateEquipment(EquipmentObj NewEquipment) { bool flag = true; if (this.TryConnection()) { DatabaseParameters values = new DatabaseParameters(); DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.EquipmentID.ActualFieldName, NewEquipment.InternalID)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.EquipmentDescription.ActualFieldName, NewEquipment.Description)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.EquipmentObject.ActualFieldName, NewEquipment.EquipmentObject)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.Equipmentsnr.ActualFieldName, NewEquipment.EquipmentSNR)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.EquipmentLocation.ActualFieldName, NewEquipment.EquipmentLocation)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName, NewEquipment.EquipmentProfileID)); base.CurSQLFactory.UpdateCommand(keys, values, this.DataStructrure.Tables.MasterEquipment.ActualTableName); if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL))) { base.error_occured = true; string errMsg = base.ErrMsg; base.ErrMsg = errMsg + "[EquipmentManager] : UpdateEquipment : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage; } return(flag); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[EquipmentManager] : UpdateEquipment : " + base.ErrMsg; return(flag); }
public EquipmentObj GetEquipmentByEquipmentID(string EquipmentID) { EquipmentObj obj2 = null; DatabaseParameters keyParameters = new DatabaseParameters(); keyParameters.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterEquipment.EquipmentID.ActualFieldName, EquipmentID)); DataTable table = this.QueryData(keyParameters, this.DataStructrure.Tables.MasterEquipment.ActualTableName); if (table != null) { obj2 = new EquipmentObj(); foreach (DataRow row in table.Rows) { obj2 = new EquipmentObj(row[this.DataStructrure.Tables.MasterEquipment.EquipmentID.ActualFieldName].ToString()) { Description = row[this.DataStructrure.Tables.MasterEquipment.EquipmentDescription.ActualFieldName].ToString(), EquipmentObject = row[this.DataStructrure.Tables.MasterEquipment.EquipmentObject.ActualFieldName].ToString(), EquipmentSNR = row[this.DataStructrure.Tables.MasterEquipment.Equipmentsnr.ActualFieldName].ToString(), EquipmentLocation = row[this.DataStructrure.Tables.MasterEquipment.EquipmentLocation.ActualFieldName].ToString(), EquipmentProfileID = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString() }; } } return(obj2); }
public EquipmentCollection GetAllEquipmentProfiles() { EquipmentCollection equipments = null; if (this.TryConnection()) { DataTable table = base.CurDBEngine.SelectQuery("SELECT DISTINCT " + this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName + " FROM " + this.DataStructrure.Tables.MasterEquipment.ActualTableName); if (table == null) { return(equipments); } equipments = new EquipmentCollection(); foreach (DataRow row in table.Rows) { EquipmentObj obj2 = new EquipmentObj(row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString()) { EquipmentSNR = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString(), EquipmentProfileID = row[this.DataStructrure.Tables.MasterEquipment.EquipmentProfile.ActualFieldName].ToString() }; equipments.Add(obj2); } } return(equipments); }