public bool EditPassword(string email, string newPassword) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return (dbManager.NonReturnQuery("UPDATE Clients set Client_Password = '******' WHERE Client_Email ='" + email + "';")); }
private void StartSession() { new System.Threading.Thread(() => { Classes.Cryptography crypto = new Classes.Cryptography(); SetLoadingStatus(true); DisplayNotifyBox("Attempting to Sign In", "Please wait while we sign you in"); string passsword = crypto.EncryptString(GetPassword()); Classes.Session session = new Classes.Session(GetUsername(), passsword); if (session.LoginSuccessfull) { DisplayNotifyBox("Signed In", "Welcome " + session.username); OpenAdminWindow(session.username); } else { DisplayNotifyBox("Invalid Username or Password", "Could not sign in"); } SetLoadingStatus(false); }).Start(); }
public bool EditPassword(string email, string newPassword) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return (dbManager.NonReturnQuery("UPDATE Agent set Agent_Password = '******' WHERE Agent_Email ='" + email + "';")); }
public bool AddClient(string name, string surname, string phone, string email, string password) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return (dbManager.NonReturnQuery("INSERT INTO Clients (Client_Name , Client_Surname, Client_Phone, Client_Email, Client_Password) VALUES ('" + name + "','" + surname + "','" + phone + "','" + email + "','" + crypto.EncryptString(password) + "');")); }
public bool EditPassword(string username, string newPassword) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return (dbManager.NonReturnQuery("UPDATE Admin set Admin_Password = '******' WHERE Admin_Username ='******';")); }
public bool AddAdmin(string username, string password) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return (dbManager.NonReturnQuery("INSERT INTO Admin (Admin_Username , Admin_Password) VALUES ('" + username + "','" + crypto.EncryptString(password) + "');")); }
public bool AddAgent(string name, string surname, string phone, string email, string password) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); MySql.Data.MySqlClient.MySqlCommand com = new MySql.Data.MySqlClient.MySqlCommand(); return (dbManager.NonReturnQuery("INSERT INTO Agent (Agent_Name , Agent_Surname, Agent_Phone, Agent_Email, Agent_Password) VALUES ('" + name + "','" + surname + "','" + phone + "','" + email + "','" + Cryptography.CreateHash(password).ToString() + "');")); }
/// <summary> /// Creates config file with keys and empty values /// </summary> private void CreateConfigFile() { Cryptography crypto = new Cryptography(); if (!Directory.Exists(configDirPath)) { Directory.CreateDirectory(configDirPath); } config.Options.AddOptionsRow(crypto.EncryptString(serverKey), ""); config.Options.AddOptionsRow(crypto.EncryptString(userKey), ""); config.Options.AddOptionsRow(crypto.EncryptString(passwordKey), ""); config.Options.AddOptionsRow(crypto.EncryptString(dbKey), ""); config.Options.AddOptionsRow(crypto.EncryptString(portKey), ""); WriteConfig(); }
public Session(string loginUsername, string loginPassword) { username = ""; IsAdmin = UsernameInAdminTable(loginUsername); Cryptography crypto = new Cryptography(); password = GetPassword(loginUsername, IsAdmin); username = GetUsername(loginUsername, IsAdmin); if (password != "" && username != "") { if ((username == loginUsername) && (password == loginPassword)) { LoginSuccessfull = true; } } }
/// <summary> /// Loads values from config XML file /// </summary> private void LoadConfig() { try { config.ReadXml(configFilePath); Cryptography crypto = new Cryptography(); r = config.Options.Select("Key ='" + crypto.EncryptString(serverKey) + "'")[0]; ServerIP = crypto.DecryptString(r[1].ToString()); r = config.Options.Select("Key ='" + crypto.EncryptString(userKey) + "'")[0]; ServerUser = crypto.DecryptString(r[1].ToString()); r = config.Options.Select("Key ='" + crypto.EncryptString(passwordKey) + "'")[0]; ServerPassword = crypto.DecryptString(r[1].ToString()); r = config.Options.Select("Key ='" + crypto.EncryptString(dbKey) + "'")[0]; ServerDB = crypto.DecryptString(r[1].ToString()); r = config.Options.Select("Key ='" + crypto.EncryptString(portKey) + "'")[0]; ServerPort = crypto.DecryptString(r[1].ToString()); ConnectionString = "server=" + ServerIP + ";uid=" + ServerUser + ";database=" + ServerDB + ";port=" + ServerPort + ";pwd=" + ServerPassword + ";"; ConfigLoaded = true; } /*catch { ConfigLoaded = false; }*/ catch (Exception e) { Console.WriteLine("LoadConfig Exception " + e.ToString()); ConfigLoaded = false; } }
/// <summary> /// Saves data and writes it encrypted to config XML file /// </summary> /// <param name="server">Server IP address string</param> /// <param name="username">Server username</param> /// <param name="password">Server password</param> /// <param name="database">Server database</param> /// <param name="portno">Server port number</param> /// <returns>Boolean if saved</returns> public bool SaveConfig(string server, string username, string password, string database, string portno) { try { Cryptography crypto = new Cryptography(); ServerIP = server; ServerUser = username; ServerPassword = password; ServerDB = database; ServerPort = portno; r = config.Options.Select("Key = '" + crypto.EncryptString(serverKey) + "'")[0]; r[1] = crypto.EncryptString(ServerIP); r = config.Options.Select("Key = '" + crypto.EncryptString(userKey) + "'")[0]; r[1] = crypto.EncryptString(ServerUser); r = config.Options.Select("Key = '" + crypto.EncryptString(passwordKey) + "'")[0]; r[1] = crypto.EncryptString(ServerPassword); r = config.Options.Select("Key = '" + crypto.EncryptString(dbKey) + "'")[0]; r[1] = crypto.EncryptString(ServerDB); r = config.Options.Select("Key = '" + crypto.EncryptString(portKey) + "'")[0]; r[1] = crypto.EncryptString(ServerPort); WriteConfig(); LoadConfig(); return true; } catch { return false; } }
public bool AddAdmin(string username, string password) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return(dbManager.NonReturnQuery("INSERT INTO Admin (Admin_Username , Admin_Password) VALUES ('" + username + "','" + Cryptography.CreateHash(password) + "');")); }
public bool AddAgent(string name, string surname, string phone, string email, string password) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); MySql.Data.MySqlClient.MySqlCommand com = new MySql.Data.MySqlClient.MySqlCommand(); return(dbManager.NonReturnQuery("INSERT INTO Agent (Agent_Name , Agent_Surname, Agent_Phone, Agent_Email, Agent_Password) VALUES ('" + name + "','" + surname + "','" + phone + "','" + email + "','" + Cryptography.CreateHash(password).ToString() + "');")); }
private void StartSession() { new System.Threading.Thread(() => { Classes.Cryptography crypto = new Classes.Cryptography(); SetLoadingStatus(true); DisplayNotifyBox("Attempting to Sign In", "Please wait while we sign you in"); string passsword = crypto.EncryptString(GetPassword()); Classes.Session session = new Classes.Session(GetUsername(), passsword); if (session.LoginSuccessfull) { DisplayNotifyBox("Signed In", "Welcome " + session.username); if( session.IsAdmin ) { OpenAdminWindow(session.username); } else { OpenAgentWindow(session.username); } } else { DisplayNotifyBox("Invalid Username or Password", "Could not sign in"); } SetLoadingStatus(false); }).Start(); }
public bool SaveFTPConfig(string webdir, string username, string password) { try { Cryptography crypto = new Cryptography(); FtpWebDirectory = webdir; FtpUser = username; FtpPassword = password; r = config.Options.Select("Key = '" + crypto.EncryptString(ftpWebdirKey) + "'")[0]; r[1] = crypto.EncryptString(webdir); r = config.Options.Select("Key = '" + crypto.EncryptString(ftpUserKey) + "'")[0]; r[1] = crypto.EncryptString(FtpUser); r = config.Options.Select("Key = '" + crypto.EncryptString(ftpPasswordKey) + "'")[0]; r[1] = crypto.EncryptString(FtpPassword); WriteConfig(); LoadConfig(); return true; } catch { return false; } }
public bool AddClient(string name, string surname, string phone, string email, string password) { DatabaseManager dbManager = new DatabaseManager(); Cryptography crypto = new Cryptography(); return(dbManager.NonReturnQuery("INSERT INTO Clients (Client_Name , Client_Surname, Client_Phone, Client_Email, Client_Password) VALUES ('" + name + "','" + surname + "','" + phone + "','" + email + "','" + Cryptography.CreateHash(password) + "');")); }