public static void Destroy(int id)
{
List <Dictionary <string, object> > user = DbConnector.Query($"SELECT * FROM users WHERE user_id = {id}");
Console.WriteLine("User " + user[0]["FirstName"] + " " + user[0]["LastName"] + " has been deleted!");
DbConnector.Execute($"DELETE FROM users WHERE user_id = {id}");
Read();
}
static void Delete()
{
Console.Clear();
Read();
System.Console.WriteLine("Please input the id number of the user you want to delete...");
int id = Int32.Parse(System.Console.ReadLine());
string x = "DELETE FROM table1 WHERE id = " + id;
DbConnector.Execute(x);
Back();
}
public static void Update(string userId)
{
User userToUpdate = PromptForUser();
string query =
$@"
UPDATE users SET first_name = '{userToUpdate.FirstName}',
last_name = '{userToUpdate.LastName}',
favorite_number = '{userToUpdate.FavNum}'
WHERE id = {userId}
";
DbConnector.Execute(query);
}
static void Create()
{
Console.Clear();
System.Console.WriteLine("Give First Name:");
string first = System.Console.ReadLine();
System.Console.WriteLine("Give Last Name:");
string last = System.Console.ReadLine();
System.Console.WriteLine("Give his Favorite number:");
int favorite = Int32.Parse(System.Console.ReadLine());
string x = "INSERT INTO table1 (first_name, last_name, favorite_number) VALUES ('" + first + "','" + last + "','" + favorite + "')";
// System.Console.WriteLine(x);
DbConnector.Execute(x);
Back();
}
public static void Update(int id, string q1 = "", string q2 = "", string q3 = "")
{
List <Dictionary <string, object> > user = DbConnector.Query($"SELECT * FROM users WHERE user_id = {id}");
Console.WriteLine("User " + user[0]["FirstName"] + " " + user[0]["LastName"] + " has been updated!");
if (q1 != "")
{
DbConnector.Execute($"UPDATE users SET {q1} WHERE user_id = {id}");
}
if (q2 != "")
{
DbConnector.Execute($"UPDATE users SET {q2} WHERE user_id = {id}");
}
if (q3 != "")
{
DbConnector.Execute($"UPDATE users SET {q3} WHERE user_id = {id}");
}
Read();
}
static void Update()
{
Console.Clear();
Read();
System.Console.WriteLine("Please input the id number of the user you want to update...");
int id = Int32.Parse(System.Console.ReadLine());
System.Console.WriteLine("Give First Name:");
string first = System.Console.ReadLine();
System.Console.WriteLine("Give Last Name:");
string last = System.Console.ReadLine();
System.Console.WriteLine("Give his Favorite number:");
int favorite = Int32.Parse(System.Console.ReadLine());
string x = "UPDATE table1 SET first_name = '" + first + "', last_name = '" + last + "', favorite_number = '" + favorite + "' WHERE id = " + id;
DbConnector.Execute(x);
Back();
}
public static void Insert()
{
Console.WriteLine("First Name");
string first = Console.ReadLine();
Console.WriteLine("Last Name");
string last = Console.ReadLine();
Console.WriteLine("Favorite number");
int fav = Int32.Parse(Console.ReadLine());
Console.WriteLine("Purpose");
string purpose = Console.ReadLine();
Console.WriteLine("Job");
string job = Console.ReadLine();
Console.WriteLine("Hobby");
string hobby = Console.ReadLine();
DbConnector.Execute("INSERT into `consoledb`.`Users` (`FirstName`, `LastName`, `FavoriteNumber`, `Purpose`, `Job`, `Hobby`) VALUES('" + first + "','" + last + "','" + fav + "','" + purpose + "','" + job + "','" + hobby + "')");
Read();
}
public static void Create(string first, string last, int num)
{
DbConnector.Execute($"INSERT INTO users (FirstName, LastName, FavNum) VALUES ('{first}','{last}',{num})");
Console.WriteLine($"{first} {last} added to database USERS");
Read();
}
