public static void UpdateUserName()
{
Dictionary <string, string> DBDictionary = new Dictionary <string, string>();
Console.Write("Type the username you want to update: ");
DatabasesAccess da = new DatabasesAccess();
string username = Console.ReadLine();
bool userNotExist;
bool UserExist = HelpMethods.CheckExistUser(username);
if (UserExist == true)
{
Console.Clear();
Console.Write("Type a new username: "******"username", username);
DBDictionary.Add("newUsername", newUsername);
da.ProcedureDatabase(DBDictionary, "Update_UserName");
}
}
else
{
HelpMethods.UserDoesNotExistMessage();
}
}
public static void DeleteUser()
{
Dictionary <string, string> DBDictionary = new Dictionary <string, string>();
Console.Write("Type the username you want to delete: ");
string username = Console.ReadLine();
bool UserExist = HelpMethods.CheckExistUser(username);
DatabasesAccess da = new DatabasesAccess();
if (UserExist == true)
{
Console.Clear();
DBDictionary.Add("@username", username);
da.ProcedureDatabase(DBDictionary, "Delete_Users");
}
else
{
HelpMethods.UserDoesNotExistMessage();
}
}
public static void CreateUser()
{
Dictionary <string, string> DBDictionary = new Dictionary <string, string>();
Console.Write("Type the username: "******"@username", username);
DBDictionary.Add("@pass", password);
DBDictionary.Add("@role", role);
da.ProcedureDatabase(DBDictionary, "Insert_Users");
}
}
public static void UpdateRole()
{
Dictionary <string, string> DBDictionary = new Dictionary <string, string>();
Console.Write("Type the username you want to update: ");
string username = Console.ReadLine();
bool UserExist = HelpMethods.CheckExistUser(username);
DatabasesAccess da = new DatabasesAccess();
if (UserExist == true)
{
Console.Clear();
string role = ApplicationsMenus.RoleMenu();
DBDictionary.Add("username", username);
DBDictionary.Add("newRole", role);
da.ProcedureDatabase(DBDictionary, "Update_Users_By_Role");
}
else
{
HelpMethods.UserDoesNotExistMessage();
}
}