//inserts a message to the database with the sender and the reciver of the message public static void SendMessagePrivate(string user_name, string content, string reciver) { if (UserMethods.userExist(user_name) && UserMethods.userExist(reciver)) { string com = "INSERT INTO watts_private_messages (sender,content,reciver,Mdate) VALUES ('" + user_name + "','" + content + "','" + reciver + "','" + DateTime.Now.ToString() + "')"; dal.Execute(com); } else if (!UserMethods.userExist(reciver)) { Console.WriteLine("the reciver of the message does not exist"); } }
public static void SQL() { bool SQL = true; string str = ""; System.Console.Clear(); System.Console.ForegroundColor = ConsoleColor.Red; System.Console.Write("SQL Mode "); System.Console.ResetColor(); while (SQL) { System.Console.WriteLine("---------"); System.Console.WriteLine(str); System.Console.ForegroundColor = ConsoleColor.Yellow; System.Console.Write("> "); System.Console.ResetColor(); str = System.Console.ReadLine(); try { if (str == "") { SQL = false; } else if (str.ToLower().Contains("adduser")) { string UName = ""; string PWord = ""; for (int i = 0; i < 3; i++) { UName += (Random.Next(10).ToString()); PWord += (Random.Next(10).ToString()); } System.Console.ForegroundColor = ConsoleColor.Yellow; System.Console.Write(UserMethods.AddUser(UName, PWord) + "\n"); System.Console.ResetColor(); } else if (str.ToLower().Contains("select")) { System.Data.DataTable Table = OledbHelper.GetTable(str); foreach (System.Data.DataColumn Col in Table.Columns) { System.Console.ForegroundColor = ConsoleColor.Cyan; System.Console.Write("{0,15}|", Col.ColumnName.ToString()); System.Console.ResetColor(); } System.Console.Write("\n"); foreach (System.Data.DataRow Row in Table.Rows) { foreach (var item in Row.ItemArray) { System.Console.Write("{0,15}|", item.ToString()); } System.Console.Write("\n"); } } else { OledbHelper.Execute(str); System.Console.ForegroundColor = ConsoleColor.Green; System.Console.Write("Success. "); System.Console.ResetColor(); } //System.Console.ReadLine(); } catch (Exception e) { //throw e; if (str == "") { SQL = false; } else { System.Console.ForegroundColor = ConsoleColor.Red; System.Console.Write("Invalid. "); System.Console.WriteLine(e.Message); System.Console.ResetColor(); // System.Console.ReadLine(); } } } }