static void Create() { List <Dictionary <string, object> > list = DbConnector.Query("SELECT max(id) FROM Users;"); int newId = (int)list[0].First().Value + 1; System.Console.WriteLine("Please enter the first name:"); string fname = Console.ReadLine(); System.Console.WriteLine("Please enter the last name:"); string lname = Console.ReadLine(); System.Console.WriteLine("Please enter the favorite number:"); string favnumstr = Console.ReadLine(); int favnum = Convert.ToInt32(favnumstr); System.Console.WriteLine("You entered the name {0} {1}, with the number {2}", fname, lname, favnum); System.Console.WriteLine("Is this correct? (Y/N):"); string answer = Console.ReadLine(); if (answer == "y" || answer == "Y" || answer == "yes" || answer == "Yes" || answer == "YES") { string insQuery = string.Format("INSERT into users (id, FirstName, LastName, FavoriteNumber) VALUES ({0}, \"{1}\", \"{2}\", {3});", newId, fname, lname, favnum); DbConnector.Execute(insQuery); } }
public static void remove() { Console.WriteLine("Enter id of user you want to delete"); string id = Console.ReadLine(); string removeQuery = $"DELETE FROM users WHERE id = {id}"; DbConnector.Execute(removeQuery); read(); }
public static void create() { Console.WriteLine("What's your First Name"); string first_name = '"' + Console.ReadLine() + '"'; Console.WriteLine("What's your Last Name"); string last_name = '"' + Console.ReadLine() + '"'; Console.WriteLine("What's your Favorite Number"); string num = Console.ReadLine(); string query = $"INSERT into users(first_name, last_name, favorite_number) VALUES({first_name}, {last_name}, {num})"; Console.WriteLine(query); DbConnector.Execute(query); read(); }
public static void Main(string[] args) { System.Console.WriteLine("Enter first name: "); string fname = Console.ReadLine(); string lname = Console.ReadLine(); int fnum = Console.Read(); DbConnector.Query("SELECT idUsers, FirstName, LastName, FavoriteNumber FROM Users"); DbConnector.Execute("INSERT INTO Users(FirstName, LastName, FavoriteNumber) VALUES ('{fname}', '{lname}', fnum)"); var host = new WebHostBuilder() .UseKestrel() .UseContentRoot(Directory.GetCurrentDirectory()) .UseStartup <Startup>() .Build(); host.Run(); }
public static void Create() { System.Console.WriteLine("Enter first name"); string firstName = Console.ReadLine(); string fString = '"' + firstName + '"'; System.Console.WriteLine("Enter last name"); string lastName = Console.ReadLine(); string lString = '"' + lastName + '"'; System.Console.WriteLine("Enter lucky number"); string luckyNum = Console.ReadLine(); // string nString = '"' + luckyNum + '"'; string insert = $"INSERT INTO users (FirstName, LastName, FavoriteNumber) VALUES ({fString}, {lString}, {luckyNum})"; DbConnector.Execute(insert); Read(); }
public static void update() { Console.WriteLine("Enter id"); string id = Console.ReadLine(); Console.WriteLine("Enter First Name"); string first_name = Console.ReadLine(); string fString = '"' + first_name + '"'; Console.WriteLine("Enter Last Name"); string last_name = Console.ReadLine(); string lString = '"' + last_name + '"'; Console.WriteLine("Enter Favorite Number"); string favorite_number = Console.ReadLine(); string updateQuery = $"UPDATE users SET first_name = {fString}, last_name = {lString}, favorite_number = {favorite_number} WHERE id = {id}"; DbConnector.Execute(updateQuery); read(); }
public static void Update() { Console.WriteLine("Enter user_id"); string id = Console.ReadLine(); System.Console.WriteLine("Enter first name"); string firstName = Console.ReadLine(); string fString = '"' + firstName + '"'; System.Console.WriteLine("Enter last name"); string lastName = Console.ReadLine(); string lString = '"' + lastName + '"'; System.Console.WriteLine("Enter lucky number"); string luckyNum = Console.ReadLine(); string nString = '"' + luckyNum + '"'; // Why do you not need nString for this one? // string update = $"UPDATE users SET (FirstName, LastName, FavoriteNumber) = ({fString}), ({lString}), ({nString}) WHERE id = ({id})"; string update = $"UPDATE users SET FirstName = {fString}, LastName = {lString}, FavoriteNumber = {nString} WHERE id = {id}"; DbConnector.Execute(update); }
public static void Create(string first, string last, int number) { DbConnector.Execute($"INSERT INTO users (FirstName, LastName, FavoriteNumber) VALUES ('{first}', '{last}', '{number}')"); System.Console.WriteLine($"{first} {last} successfully added to the database!"); }