private static void Update(SQLiteConnection sc) { int ms = 0, objid = 0; bool t = false; char c; bool ti = false; int ci; string mt = "", mg = "", mra = "", mre = "", notes = ""; Console.Write("\r\n"); // Movie ObjectID required getInfo_i: Console.Write("Movie Objectid 'Required' " + "\r\n"); ti = int.TryParse(Console.ReadLine(), out ci); if (ti == true) { objid = int.Parse(ci.ToString()); } else { goto getInfo_i; } // End Console.Write("Movie Title" + "\r\n"); mt = Console.ReadLine(); Console.Write("Movie Genre" + "\r\n"); mg = Console.ReadLine(); // Movie Status required getInfo_c: Console.Write("Movie Status, 0 or 1 'Required' " + "\r\n"); t = char.TryParse(Console.ReadLine(), out c); if (t == true && (c == '0' || c == '1')) { ms = int.Parse(c.ToString()); } else { goto getInfo_c; } // End Console.Write("Movie Rating" + "\r\n"); mra = Console.ReadLine(); Console.Write("Movie Review" + "\r\n"); mre = Console.ReadLine(); Console.Write("Movie Notes" + "\r\n"); notes = Console.ReadLine(); Console.WriteLine(Database_SQLite.UpdateData_Movie(objid, mt, mg, ms, mra, mre, notes, sc)); }
public static void ManageApp() { // DB Connection string SQLiteConnection sc = Database_SQLite.CreateConnection(); // Select all Movie data from table Movie for display Console.WriteLine(Database_SQLite.Select_MovieData(sc) + "\r\n"); while (true) { // Determine what user wants to do; insert, update, delete GetUserCommand(sc); } }
private static char GetUserCommand(SQLiteConnection sc) { getInfo: Console.Write("Enter: 'i' for insert, 'u' for update, 'd' for delete, 's' for select, or 9 for exit 'Required' " + "\r\n"); bool t = false; t = char.TryParse(Console.ReadLine(), out char c); if (t == true && c == '9') { Environment.Exit(0); } if (t == true && (c == 'i' || c == 'u' || c == 'd' || c == 's')) { } else { goto getInfo; } switch (c) { case 'i': Insert(sc); break; case 'u': Update(sc); break; case 'd': Delete(sc); break; case 's': Console.WriteLine(Database_SQLite.Select_MovieData(sc)); break; default: Environment.Exit(0); break; } return('0'); }
private static void Insert(SQLiteConnection sc) { int ms = 0; bool t = false; char c; string mt = "", mg = "", mra = "", mre = "", notes = ""; Console.Write("\r\n"); Console.Write("Movie Title" + "\r\n"); mt = Console.ReadLine(); Console.Write("Movie Genre" + "\r\n"); mg = Console.ReadLine(); // Movie Status required getInfo: Console.Write("Movie Status, 0 or 1 'Required' " + "\r\n"); t = char.TryParse(Console.ReadLine(), out c); if (t == true && (c == '0' || c == '1')) { ms = int.Parse(c.ToString()); } else { goto getInfo; } // End Console.Write("Movie Rating" + "\r\n"); mra = Console.ReadLine(); Console.Write("Movie Review" + "\r\n"); mre = Console.ReadLine(); Console.Write("Movie Notes" + "\r\n"); notes = Console.ReadLine(); Console.WriteLine(Database_SQLite.InsertData_Movie(mt, mg, ms, mra, mre, notes, sc)); }
private static void Delete(SQLiteConnection sc) { int objid = 0; bool t = false; Console.Write("\r\n"); // Movie Objectid required getInfo: Console.Write("Enter the Objectid of the Movie to delete 'Required'" + "\r\n"); t = int.TryParse(Console.ReadLine(), out objid); if (t == true) { objid = int.Parse(objid.ToString()); } else { goto getInfo; } // End Console.WriteLine(Database_SQLite.DeleteData_Movie(objid, sc)); }