/// <summary>
/// Login worker.
/// Use this for testing log in
/// </summary>
/// <returns></returns>
public bool auth()
{
if (!IsDigits(this.id_textbox.Text))
{
throw new Exception("Make sure that your id contains only digits");
}
if (!SqlWorker.CheckForInternetConnection())
{
throw new Exception("There is no internet connection.\nPlease try again later.");
}
string f_id = this.id_textbox.Text.ToString();
string f_pwd = this.pwd_textbox.Text.ToString();
User usr = SqlWorker.GetUser(f_id);
// check if we found it and if pwds much
if (usr == null || usr.Pwd != f_pwd)
{
throw new Exception("User not found or Password is incorrect");
}
// set session user
Globals._session = usr;
return(true);
}
public bool SaveUser()
{
if (this.name_input.Text != "" &&
this.id_input.Text != "" &&
this.sem_sbox.Text != "")
{
try
{
DataTable users_list = SqlWorker.GetUsersList();
Student student = new Student();
student.Type = "Student";
student.Name = this.name_input.Text;
student.ID = this.id_input.Text;
student.Pwd = this.pwd_input.Text;
student.SemCount = int.Parse(this.sem_sbox.Text);
foreach (DataRow row in users_list.Rows)
{
if ((row["id"].ToString()) == this.id_input.Text)
{
if (row["Type"].ToString() == "Student")
{
// Configure the message box to be displayed
string messageBoxText = "Student with that ID is already in system. Do you want to update?";
string caption = "Confirme Update";
if (MessageBox.Show(messageBoxText, caption, MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
Student DbStudent = (Student)SqlWorker.GetUser(student.ID.ToString());
student.ActiveLects = DbStudent.ActiveLects;
student.ActivePracLabs = DbStudent.ActivePracLabs;
student.Constraints = DbStudent.Constraints;
if (SqlWorker.SaveUser(student))
{
return(true);
}
}
return(false);
}
else
{
MessageBox.Show("User with that ID is already in system");
return(false);
}
}
}
if (SqlWorker.AddStudent(student))
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
else
{
throw new Exception("Fields can't be empty!");
}
return(false);
}