public void OnLogInfo(LoginInfoEventArgs e)
{
if (LogInfo != null)
{
LogInfo(this, e);
}
}
public void LoginDBEvent(object sender, LoginInfoEventArgs e)
{
if (CheckTPassword(e) && CheckTUsrname(e))
{
CreateUserT(e);
Console.Clear();
App.BootstrapTeacherView(e.User);
App.Start();
}
else if (CheckSPassword(e) && CheckSUsrname(e))
{
CreateUserS(e);
Console.Clear();
App.BootstrapStudentView(e.User);
App.Start();
}
else
{
Console.SetCursorPosition(Console.WindowWidth / 2 - 10, Console.WindowHeight / 2 + 11);
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(" ");
Console.SetCursorPosition(Console.WindowWidth / 2 - 10, Console.WindowHeight / 2 + 11);
Console.WriteLine("* Wrong username or password");
Console.SetCursorPosition(0, 0);
Console.ForegroundColor = ConsoleColor.White;
}
}
public bool CheckTUsrname(LoginInfoEventArgs e)
{
OleDbCommand aCommandPT = new OleDbCommand("SELECT * from Teachers", aConnection);
bool valid = false;
try
{
aConnection.Open();
OleDbDataReader aReader = aCommandPT.ExecuteReader();
while (aReader.Read())
{
if (e.Username == aReader.GetString(4))
{
valid = true;
break;
}
}
aReader.Close();
aConnection.Close();
}
catch (OleDbException eOl)
{
Console.WriteLine("Error: {0}", eOl.Errors[0].Message);
aConnection.Close();
}
return(valid);
}
public void CreateUserS(LoginInfoEventArgs e)
{
OleDbCommand aCommand = new OleDbCommand("SELECT * from Students" +
" WHERE username = @par1 AND `password` = @par2", aConnection);
aCommand.Parameters.AddRange(new[] {
new OleDbParameter("@par1", e.Username),
new OleDbParameter("@par2", e.Password)
});
try
{
aConnection.Open();
OleDbDataReader aReader = aCommand.ExecuteReader();
while (aReader.Read())
{
int fieldID = aReader.GetInt32(0);
string firstName = aReader.GetString(1);
string lastName = aReader.GetString(2);
string subject = aReader.GetString(3);
string letterID = aReader.GetString(7);
e.User = new Model.User(e.Password, e.Username, letterID,
firstName, lastName, fieldID, subject);
}
aReader.Close();
aConnection.Close();
}
catch (OleDbException ex)
{
Console.WriteLine("Error: {0}", ex.Errors[0].Message);
aConnection.Close();
}
}