public static bool AddUser(string Username, string Password) { if (!UserExists(Username, Password)) { try { string cmd = "INSERT INTO Users (UName,PWord) Values ('" + Username + "','" + Password + "');"; OledbHelper.Execute(cmd); return(true); } catch { return(false); } } return(false); }
/// <summary> /// Creates a user with the provided information, /// returns the created user's ID. /// </summary> /// <param name="Username">Created User's Username</param> /// <param name="Password">Created User's Password</param> /// <param name="FName">Created User's First Name</param> /// <param name="LName">Created User's Surname</param> /// <param name="UserType">Created User's Type: /// -1: Admin, 0: Teacher, 1: Student</param> public static int CreateUser(string Username, string Password, string FName, string LName, int UserType) { if (!UserExists(Username, Password)) { try { string cmd = string.Format("INSERT INTO Users ([UName],[PWord],[FName],[LName],[UserType]) VALUES ('{0}','{1}','{2}','{3}',{4});", Username, Password, FName, LName, UserType.ToString()); OledbHelper.Execute(cmd); return(GetUserByCredentials(Username, Password).ID); } catch { return(-1); } } return(-1); }
/// <summary> /// Removes The Specified Lesson From The Database /// </summary> /// <param name="LessonID"></param> public static void RemoveLesson(int LessonID) { string expr = String.Format("DELETE * FROM Lessons Where [LessonID]={0}", LessonID); OledbHelper.Execute(expr); }
//Update A Group's CourseID public static void UpdateGroup(int GroupID, int CourseID) { string expr = string.Format("UPDATE Groups SET Groups.CourseID = {1} WHERE (((Groups.GroupID)={0}));", GroupID, CourseID); OledbHelper.Execute(expr); }
//Update A Group's GroupName public static void UpdateGroup(int GroupID, string GroupName) { string expr = string.Format("UPDATE Groups SET Groups.GroupName = '{1}' WHERE (((Groups.GroupID)={0}));", GroupID, GroupName); OledbHelper.Execute(expr); }
public static void UpdateLesson(int LessonID, int TeacherID, int GroupID, int SubjectID, int Day, int Period) { string expr = string.Format("UPDATE Lessons SET Lessons.GroupID = {1}, Lessons.TeacherID = {2}, Lessons.SubjectID = {3}, Lessons.[Day] = {4}, Lessons.Period = {5} WHERE (((Lessons.LessonID)={0}));", LessonID, GroupID, TeacherID, SubjectID, Day, Period); OledbHelper.Execute(expr); }
public static void AddLesson(int TeacherID, int GroupID, int SubjectID, int Day, int Period) { string Expr = string.Format("INSERT INTO Lessons ([TeacherID],[GroupID],[SubjectID],[Day],[Period]) Values ({0},{1},{2},{3},{4})", TeacherID, GroupID, SubjectID, Day, Period); OledbHelper.Execute(Expr); }
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(); } } } }