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