public static string GetUserRole(string username) { SqlConnection connection = ConnectionToServer.Connection(); string userRole = ""; try { connection.Open(); SqlCommand command = new SqlCommand($"Select Role FROM Person WHERE username = '******'", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { userRole = reader["Role"].ToString(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } return(userRole); }
public static void ChangeRole() { SqlConnection connection = ConnectionToServer.Connection(); try { Console.Write("Enter Username: "******"Select user's role: Simple, Editor, Deleter, Admin"); string newrole = Console.ReadLine().ToUpper(); connection.Open(); SqlCommand command = new SqlCommand($"UPDATE Person SET Role = '{newrole}' WHERE userName = '******'", connection); int updateRole = command.ExecuteNonQuery(); if (updateRole > 0) { Console.WriteLine("User's role updated successfully!"); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static void NewMessage(string sender, string receiver) { SqlConnection connection = ConnectionToServer.Connection(); int messageId; DateTime date = DateTime.Now; string messDate = date.ToString("dd/MM/yyyy HH:mm:ss"); try { connection.Open(); Console.Write("Message: "); string newmessage = Console.ReadLine(); int senderId = ConnectionToServer.GetUserId(sender); int receiverId = ConnectionToServer.GetUserId(receiver); SqlCommand cmd = new SqlCommand($"INSERT INTO Message (Date, Sender, Receiver, Text) VALUES('{messDate}','{senderId}','{receiverId}','{newmessage}');SELECT SCOPE_IDENTITY();", connection); messageId = System.Convert.ToInt32(cmd.ExecuteScalar()); string userscontact = $"{sender} to {receiver}"; TextFile.MessagesToText(messDate, sender, receiver, newmessage); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static int GetUserId(string username) { SqlConnection connection = ConnectionToServer.Connection(); int id = 0; try { connection.Open(); SqlCommand cmdLogin = new SqlCommand($"SELECT Id FROM Person WHERE username = '******'", connection); SqlDataReader reader = cmdLogin.ExecuteReader(); while (reader.Read()) { id = reader.GetInt32(0); } reader.Close(); //Console.WriteLine(id); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } return(id); }
public static void DeleteMessage(int messageId) { SqlConnection connection = ConnectionToServer.Connection(); try { using (connection) { connection.Open(); SqlCommand command = new SqlCommand($"DELETE FROM Message WHERE Id = {messageId}", connection); int deleted = command.ExecuteNonQuery(); if (deleted > 0) { Console.WriteLine($"{deleted} rows deleted successfully"); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static void EditMessage(int messageId) { SqlConnection connection = ConnectionToServer.Connection(); try { using (connection) { Console.Write("Message: "); string upMessage = Console.ReadLine(); connection.Open(); SqlCommand command = new SqlCommand($"UPDATE Message SET Text = '{upMessage}' WHERE Id = '{messageId}'", connection); int update = command.ExecuteNonQuery(); if (update > 0) { Console.WriteLine("Update successfull"); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static string GetUserName(int Id) { SqlConnection connection = ConnectionToServer.Connection(); string UserName = ""; try { connection.Open(); SqlCommand command = new SqlCommand($"SELECT Username FROM Person WHERE Id = '{Id}'", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { UserName = reader["Username"].ToString(); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } return(UserName); }
public static void ReadReceivedMessages(string username) { SqlConnection connection = ConnectionToServer.Connection(); try { int userId = 0; using (connection) { userId = ConnectionToServer.GetUserId(username); connection.Open(); Console.WriteLine("Messages that received: \n"); SqlCommand command = new SqlCommand($"SELECT Id, Date, Sender, Receiver, Text FROM Message WHERE Receiver = {userId}", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int messId = reader.GetInt32(0); string sender = ConnectionToServer.GetUserName(Int32.Parse(reader["Sender"].ToString())); Console.WriteLine(String.Format("Message Id:" + $"{messId}\n" + "From:" + username + $"\nTo:{sender}\n" + "Message: " + $"{reader[4]}\n")); } Console.WriteLine("Press enter key to exit"); Console.ReadLine(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static bool UserExist(string username) { bool exists = false; SqlConnection connection = ConnectionToServer.Connection(); try { connection.Open(); SqlCommand cmd = new SqlCommand($"SELECT COUNT (*) Username FROM Person WHERE username = '******'", connection); cmd.Parameters.AddWithValue("@username", username); int match = (int)cmd.ExecuteScalar(); if (match > 0) { Console.WriteLine("Username exists!"); exists = true; } else { Console.WriteLine("Username does not exist!"); exists = false; } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } return(exists); }
public static void ReadUser(string username) { SqlConnection connection = ConnectionToServer.Connection(); try { connection.Open(); SqlCommand command = new SqlCommand($"SELECT Id, Nickname, Username, Password, Role FROM Person WHERE username = '******'", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader["Id"].ToString()); Console.WriteLine(reader["Nickname"].ToString()); Console.WriteLine(reader["Username"].ToString()); Console.WriteLine(reader["Password"].ToString()); Console.WriteLine(reader["Role"].ToString()); } Console.WriteLine("Press enter to exit"); Console.ReadLine(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static void UpdateUserPassWord(string username) { SqlConnection connection = ConnectionToServer.Connection(); try { Console.Write("Enter new username: "******"UPDATE Person SET password = '******' WHERE username = '******'", connection); int updatepass = command.ExecuteNonQuery(); if (updatepass > 0) { Console.WriteLine("Password updated successfully!"); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static void UpdateUserName(string username) { SqlConnection connection = ConnectionToServer.Connection(); try { Console.WriteLine($"Current username is {username}"); Console.Write("Enter new username: "******"UPDATE Person SET username = '******' WHERE userName = '******'", connection); int updatename = command.ExecuteNonQuery(); if (updatename > 0) { Console.WriteLine("Username updated successfully!"); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static void CreateUser() { SqlConnection connection = ConnectionToServer.Connection(); string username, role, nickname, password; try { Console.WriteLine("New user entry:"); Console.Write("Enter Nickname: "); nickname = Console.ReadLine(); do { Console.Write("Enter username: "******"Enter password: "******"Select user's role: Simple, Editor, Deleter, Admin"); role = Console.ReadLine().ToUpper(); if (role == "SIMPLE" || role == "EDITOR" || role == "DELETER" || role == "ADMIN") { Console.WriteLine("Role selected: " + role); } else { Console.WriteLine("Try again"); } } while (!(role == "SIMPLE" || role == "EDITOR" || role == "DELETER" || role == "ADMIN")); connection.Open(); SqlCommand userInput = new SqlCommand($"INSERT INTO Person(Nickname, Username, Password, Role) VALUES('{nickname}','{username}','{password}','{role}');SELECT SCOPE_IDENTITY();", connection); int id = System.Convert.ToInt32(userInput.ExecuteScalar()); User user = new User(id, nickname, username, password, role); connection.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
static void Main(string[] args) { SqlConnection connection = ConnectionToServer.Connection(); string loggedUser = Login.LoginCheck(); if (loggedUser != "") { Menu.DisplayMenu(loggedUser); } }
public static void ReadAllUsers() { SqlConnection connection = ConnectionToServer.Connection(); List <User> users = new List <User>(); try { connection.Open(); SqlCommand command = new SqlCommand($"SELECT Id, Nickname, Username, Password, Role FROM Person", connection); SqlDataReader reader = command.ExecuteReader(); Console.WriteLine("Users: "); while (reader.Read()) { User user = new User() { Id = reader.GetInt32(0), NickName = reader["Nickname"].ToString(), UserName = reader["Username"].ToString(), Password = reader["Password"].ToString(), Role = reader["Role"].ToString() }; users.Add(user); } foreach (User u in users) { Console.WriteLine($"Id: {u.Id}"); Console.WriteLine($"Username: {u.UserName}"); Console.WriteLine($"Nickname: {u.NickName}"); Console.WriteLine($"Password: {u.Password}"); Console.WriteLine($"Role: {u.Role}"); } reader.Close(); Console.WriteLine("Press enter to exit"); Console.ReadLine(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Close(); } }
public static void DeleteUser(string username) { SqlConnection connection = ConnectionToServer.Connection(); try { connection.Open(); SqlCommand command = new SqlCommand($"DELETE FROM Person WHERE Username = '******'", connection); int del = command.ExecuteNonQuery(); if (del > 0) { Console.WriteLine("User successfully deleted!"); } connection.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static string LoginCheck() { SqlConnection connection = ConnectionToServer.Connection(); try { connection.Open(); Console.WriteLine("Login Screen \n------------\n"); Console.Write("Enter Username: "******"Enter Password: "******"SELECT COUNT (*) FROM Person WHERE Username = @uusername AND Password = @password", connection); command.Parameters.AddWithValue("@uusername", entername); command.Parameters.AddWithValue("@password", enterpass); int result = (int)command.ExecuteScalar(); connection.Close(); if (result > 0) { Console.WriteLine("Login Successful!"); return(entername); } else { Console.WriteLine("Incorrect login. Please try again..."); return(""); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(""); } finally { connection.Close(); } }