public string UpdateUser(string firstName, string lastName, string username, string phoneNumber, int income, string typeOfUser, int householdSize, ArrayList county) { AccountValidator checkInput = new AccountValidator(); if (checkInput.ValidName(firstName, lastName) != "valid.") { return(checkInput.ValidName(firstName, lastName)); } else if (checkInput.PhoneValid(phoneNumber) != "Valid Number.") { return(checkInput.PhoneValid(phoneNumber)); } else if (checkInput.ValidIncome(income) != "valid income") { return(checkInput.ValidIncome(income)); } else if (checkInput.ValidHouseSize(householdSize) != "Valid housing size") { return(checkInput.ValidHouseSize(householdSize)); } else { try { // establishing ssh connection to server where MySql is hosted using (var client = new SshClient("softeng.cs.uwosh.edu", 1022, "heidem57", "cs341SoftEngg@486257")) { client.Connect(); string connectDB = ConfigurationManager.ConnectionStrings["MySQLDB"].ConnectionString; var portForwarded = new ForwardedPortLocal("127.0.0.1", 3306, "127.0.0.1", 3306); client.AddForwardedPort(portForwarded); portForwarded.Start(); using (MySqlConnection conn = new MySqlConnection(connectDB)) { using (MySqlCommand cmd = new MySqlCommand("UPDATE Renters Phone=@Phone,FirstName@FirstName,LastName=@LastName,Income=@Income,HouseHold=@HouseHold,County1=@County1,County2=@County2,County3=@County3 WHERE Username=@Username", conn)) { conn.Open(); cmd.Parameters.AddWithValue("@Username", username);//Insert all parameters. cmd.Parameters.AddWithValue("@Phone", phoneNumber); cmd.Parameters.AddWithValue("@FirstName", firstName); cmd.Parameters.AddWithValue("@LastName", lastName); cmd.Parameters.AddWithValue("@Income", income); cmd.Parameters.AddWithValue("@HouseHold", householdSize); cmd.Parameters.AddWithValue("@County1", county[0] != null ? county[0] : "empty"); cmd.Parameters.AddWithValue("@County2", county[1] != null ? county[1] : "empty"); cmd.Parameters.AddWithValue("@County3", county[2] != null ? county[2] : "empty"); cmd.ExecuteNonQuery(); conn.Close(); } } client.Disconnect(); } } catch (Exception error) { return(error.Message); } } return("yes"); }
public string CreateUser(string firstName, string lastName, string phoneNumber, string email, string userName, string password, int income, string typeOfUser, int householdSize, ArrayList county) { AccountValidator checkInput = new AccountValidator(); if (checkInput.ValidName(firstName, lastName) != "valid.") { return(checkInput.ValidName(firstName, lastName)); } else if (checkInput.PhoneValid(phoneNumber) != "Valid Number.") { return(checkInput.PhoneValid(phoneNumber)); } else if (checkInput.ValidEmail(email) != "Valid email.") { return(checkInput.ValidEmail(email)); } else if (checkInput.ValidUserName(userName) != "Valid userName") { return(checkInput.ValidUserName(userName)); } else if (checkInput.ValidPassword(password, firstName, lastName) != "Valid Pass.") { return(checkInput.ValidPassword(firstName, lastName, password)); } else if (checkInput.ValidIncome(income) != "valid income") { return(checkInput.ValidIncome(income)); } else if (checkInput.ValidHouseSize(householdSize) != "Valid housing size") { return(checkInput.ValidHouseSize(householdSize)); } else { try { // establishing ssh connection to server where MySql is hosted using (var client = new SshClient("softeng.cs.uwosh.edu", 1022, "heidem57", "cs341SoftEngg@486257")) { client.Connect(); string connectDB = ConfigurationManager.ConnectionStrings["MySQLDB"].ConnectionString; var portForwarded = new ForwardedPortLocal("127.0.0.1", 3306, "127.0.0.1", 3306); client.AddForwardedPort(portForwarded); portForwarded.Start(); using (MySqlConnection conn = new MySqlConnection(connectDB)) { using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Renters(Username, Password, PasswordSalt, Email, Phone, FirstName, LastName, Income, Household, County1, County2, County3) VALUES(@Username, @Password, @PasswordSalt, @Email, @Phone, @FirstName, @LastName, @Income, @Household, @County1, @County2, @County3)", conn)) { string salt = CreateSalt(); string finalPass = CreateHash(password, salt); //Convert.ToBase64String(bytHash); conn.Open(); cmd.Parameters.AddWithValue("@Username", userName);//Insert all parameters. cmd.Parameters.AddWithValue("@Password", finalPass); cmd.Parameters.AddWithValue("@PasswordSalt", salt); cmd.Parameters.AddWithValue("@Email", email); cmd.Parameters.AddWithValue("@Phone", phoneNumber); cmd.Parameters.AddWithValue("@FirstName", firstName); cmd.Parameters.AddWithValue("@LastName", lastName); cmd.Parameters.AddWithValue("@Income", income); cmd.Parameters.AddWithValue("@HouseHold", householdSize); cmd.Parameters.AddWithValue("@County1", county[0] != null ? county[0] : "empty"); cmd.Parameters.AddWithValue("@County2", county[1] != null ? county[1] : "empty"); cmd.Parameters.AddWithValue("@County3", county[2] != null ? county[2] : "empty"); cmd.ExecuteNonQuery(); conn.Close(); } } client.Disconnect(); } } catch (Exception error) { return(error.Message); } } return("yes"); }