public OpEngineerCollection GetOpEngineers() { OpEngineerCollection engineers = null; if (this.TryConnection()) { DatabaseParameters parameters = new DatabaseParameters(); base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.OpEngineers.ActualTableName); DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL); if (table != null) { engineers = new OpEngineerCollection(); foreach (DataRow row in table.Rows) { OpEngineerObj obj2 = new OpEngineerObj { Notification = new OpNotificationObj(row[this.DataStructrure.Tables.OpEngineers.NotificationID.ActualFieldName].ToString()), Engineer = new ApplicationUser(row[this.DataStructrure.Tables.OpEngineers.EngineerID.ActualFieldName].ToString()), Lead = Convert.ToInt32(row[this.DataStructrure.Tables.OpEngineers.Lead.ActualFieldName].ToString()), OpSys = Convert.ToInt32(row[this.DataStructrure.Tables.OpEngineers.OpSys.ActualFieldName].ToString()) }; engineers.Add(obj2); } return(engineers); } base.error_occured = true; base.ErrMsg = "[OpEngineerManager] : GetOpEngineers : " + base.CurDBEngine.ErrorMessage; return(engineers); } base.error_occured = true; base.ErrMsg = "[OpEngineerManager] : GetOpEngineers : " + base.ErrMsg; return(engineers); }
public bool CreateOpEngineers(OpEngineerCollection ResultCollection) { bool flag = false; if (this.TryConnection()) { ArrayList sqla = new ArrayList(); DatabaseParameters keys = new DatabaseParameters(); foreach (OpEngineerObj obj2 in ResultCollection) { keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpEngineers.EngineerID.ActualFieldName, obj2.Engineer.InternalID)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpEngineers.Lead.ActualFieldName, obj2.Lead.ToString())); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpEngineers.NotificationID.ActualFieldName, obj2.Notification.InternalID)); base.CurSQLFactory.InsertCommand(keys, this.DataStructrure.Tables.OpEngineers.ActualTableName); sqla.Add(base.CurSQLFactory.SQL); } if (!(flag = base.CurDBEngine.ExecuteQuery(sqla))) { base.error_occured = true; string errMsg = base.ErrMsg; base.ErrMsg = errMsg + "[OpEngineerManager] : CreateOpEngineers : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage; } return(flag); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpEngineerManager] : CreatePartOnVehicle : " + base.ErrMsg; return(flag); }