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 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 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() + "');")); }
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) + "');")); }