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();
}
}
}
}
