public FormMain(Company company, User user, List<Company> companies, Database database) {
this.company = company;
this.user = user;
this.companies = companies;
this.database = database;
InitializeComponent();
}
private void threadMysqlTestFunc () {
try {
Database database = new Database() {
IpAddress = Settings.Default.databaseHost,
Username = Settings.Default.databaseUsername,
Password = Settings.Default.databasePassword,
Port = Settings.Default.databasePort
};
Query query = new Query(database);
query.checkConnection();
Dispatcher.Invoke(new Action(() => {
MessageBox.Show("Successful", "Successful", MessageBoxButton.OK, MessageBoxImage.Information);
}));
} catch (DatabaseException databaseException) {
Dispatcher.Invoke(new Action(() => {
MessageBox.Show(databaseException.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}));
} catch (Exception exception) {
Dispatcher.Invoke(new Action(() => {
MessageBox.Show(exception.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}));
}
}
public Query (Database database) {
if (database == null) {
throw new QueryException(1, "Database is null.");
}
this.database = database;
mysqlConnection = new MySqlConnection(this.database.getConnectionString());
}
private void run(object state) {
try {
Dispatcher.Invoke(new Action(() => {
panelLogin.IsEnabled = false;
progressBarLoading.Visibility = Visibility.Visible;
}));
Database database = new Database { IpAddress = Settings.Default.databaseHost, Username = Settings.Default.databaseUsername, Password = Settings.Default.databasePassword };
query = new Query(database);
companies = query.getCompanies();
//query.fillGeofences(company);
//users = query.getUsers(company, user);
int count = 0;
foreach (Company companyItem in companies) {
query.getUser(companyItem, user);
//users = query.fillUsers(companyItem, user);
//companyItem.Trackers = query.getTrackers(companyItem, users);
Dispatcher.Invoke(new Action(() => {
panelLogin.ErrorNote = "Loading companies... " + (++count).ToString() + "/" + companies.Count.ToString();
}));
}
Dispatcher.Invoke(new Action(() => {
Settings.Default.accountCompanyUsername = panelLogin.CompanyUsername;
Settings.Default.accountUsername = panelLogin.Username;
Settings.Default.accountPassword = panelLogin.Password;
Settings.Default.accountRememberMe = (bool)panelLogin.RememberMe;
Settings.Default.Save();
FormMain formMain = new FormMain(company, user, companies, database);
formMain.Show();
this.Close();
}));
} catch (DatabaseException databaseException) {
Debug.Print(databaseException.Message);
Dispatcher.Invoke(new Action(() => {
panelLogin.ErrorNote = databaseException.Message;
TextLog.Write(databaseException);
}));
} catch (Exception exception) {
Debug.Print(exception.Message);
Dispatcher.Invoke(new Action(() => {
panelLogin.ErrorNote = exception.Message;
TextLog.Write(exception);
}));
} finally {
Dispatcher.Invoke(new Action(() => {
panelLogin.IsEnabled = true;
progressBarLoading.Visibility = Visibility.Hidden;
}));
}
}
private void run (object state) {
try {
Dispatcher.Invoke(new Action(() => {
panelLogin.IsEnabled = false;
progressBarLoading.Visibility = Visibility.Visible;
}));
Database database = new Database { IpAddress = Settings.Default.databaseHost, Port = 3306, Username = Settings.Default.databaseUsername, Password = Settings.Default.databasePassword };
query = new Query(database);
displayMessage("Connecting to " + database.IpAddress + "...");
query.getCompany(company);
displayMessage("Checking Company...");
query.getUser(company, user);
displayMessage("Checking User...");
if (user.AccessLevel != 1) {
int isExpired = company.DateTimeExpired.CompareTo(DateTime.Now);
if (isExpired == -1)
throw new QueryException(1, "This company is expired.");
if (!company.IsActive)
throw new QueryException(1, "Company is deactivated.");
isExpired = user.DateTimeExpired.CompareTo(DateTime.Now);
if (isExpired == -1)
throw new QueryException(1, "This user is expired.");
if (!user.IsActive)
throw new QueryException(1, "User is deactivated.");
}
//=============================Login successful
query.fillUsers(company, user);
displayMessage("Loading Users...");
query.fillPois(company);
displayMessage("Loading Pois...");
query.fillGeofences(company);
displayMessage("Loading Geofences...");
query.fillCollection(company);
displayMessage("Loading Collections...");
query.fillTrackers(company);
displayMessage("Loading Trackers...");
Dispatcher.Invoke(new Action(() => {
Settings.Default.accountCompanyUsername = panelLogin.CompanyUsername;
Settings.Default.accountUsername = panelLogin.Username;
Settings.Default.accountPassword = panelLogin.Password;
Settings.Default.accountRememberMe = (bool)panelLogin.RememberMe;
Settings.Default.Save();
FormMain formMain = new FormMain(company, user, database);
formMain.Show();
this.Close();
}));
} catch (DatabaseException databaseException) {
Debug.Print(databaseException.Message);
displayMessage(databaseException.Message);
TextLog.Write(databaseException);
} catch (Exception exception) {
Debug.Print(exception.Message);
displayMessage(exception.Message);
TextLog.Write(exception);
} finally {
Dispatcher.Invoke(new Action(() => {
panelLogin.IsEnabled = true;
progressBarLoading.Visibility = Visibility.Hidden;
}));
}
}
public FormMain (Company company, User user, Database database) {
InitializeComponent();
this.user = user;
this.database = database;
this.company = company;
server = new Server();
server.Name = "Realtime";
server.Ip = Settings.Default.webServiceIp;
server.PortCommand = 8001;
server.PortHttp = Settings.Default.webServicePort;
loadMap();
loadDefaultLayout();
}
private void threadMysqlTestFunc () {
try {
Database database = new Database {
IpAddress = Settings.Default.DatabaseIp,
Port = Int32.Parse(Settings.Default.DatabasePort),
DatabaseName = Settings.Default.DatabaseName,
Username = Settings.Default.DatabaseUsername,
Password = Settings.Default.DatabasePassword
};
Query query = new Query(database);
query.checkConnection();
Dispatcher.Invoke(new Action(() => {
MessageBox.Show("Successful...", "Successful", MessageBoxButton.OK, MessageBoxImage.Information);
}));
} catch (Exception exception) {
Dispatcher.Invoke(new Action(() => {
MessageBox.Show(exception.Message, "Failed", MessageBoxButton.OK, MessageBoxImage.Error);
}));
}
}
private void Window_Loaded (object sender, RoutedEventArgs e) {
this.Title = System.Reflection.Assembly.GetExecutingAssembly().GetName().Name + " - " + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version;
TextLog.Name = System.Reflection.Assembly.GetExecutingAssembly().GetName().Name;
machine = new Machine();
groupMachine.DataContext = machine;
Database database = new Database {
IpAddress = Settings.Default.DatabaseIp,
Port = Int32.Parse(Settings.Default.DatabasePort),
DatabaseName = Settings.Default.DatabaseName,
Username = Settings.Default.DatabaseUsername,
Password = Settings.Default.DatabasePassword
};
if (database != null) {
mysqlCredential.DataContext = database;
}
initializedTcpManagers();
threadUploaderManager = new Thread(threadUploaderManagerFunc);
threadUploaderManager.Start(tcpManagers);
threadGuiUpdater = new Thread(threadGuiUpdaterFunc);
threadGuiUpdater.Start(tcpManagers);
bufferOut = new ConcurrentDictionary<String, String[]>();
}
private void processBufferIn (Object state) {
TcpManager tcpManager = (TcpManager)state;
while (!tcpManager.BufferIn.IsEmpty) {
Database database = new Database {
IpAddress = Settings.Default.DatabaseIp,
Port = Int32.Parse(Settings.Default.DatabasePort),
DatabaseName = Settings.Default.DatabaseName,
Username = Settings.Default.DatabaseUsername,
Password = Settings.Default.DatabasePassword
};
Query query = null;
Object obj = null;
Gm gm = null;
Tracker tracker = null;
//Get data from the buffer.
if (!tcpManager.BufferIn.TryDequeue(out obj))
continue;
//Cast Obj into Gm
try {
gm = null;
gm = (Gm)obj;
if (gm == null) {
return;
}
} catch (Exception exception) {
if (debug) {
TextLog.Write(exception);
}
return;
}
//Check Database Connection
try {
query = new Query(database);
query.checkConnection();
} catch (Exception exception) {
object object1 = obj;
tcpManager.BufferIn.Enqueue(obj);
if (debug) {
TextLog.Write(exception);
}
continue;
}
//Check tracker if registered to the database, return
try {
tracker = query.getTracker(gm.Unit);
} catch (Exception exception) {
if (debug) {
TextLog.Write(exception);
}
continue;
}
//Insert Data to the database server
try {
query.insertTrackerData(tracker, gm);
} catch (Exception exception) {
if (debug) {
TextLog.Write(exception);
}
}
Thread.Sleep(10);
}
}
