private void ScheduleBtn_Click(object sender, EventArgs e)
{
using (var Wait = new merge_B.Loading(GoSch))
{
Wait.ShowDialog(this);
}
this.Close();
Thread th = new Thread(ScheduleOpen);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
private void LoginBtn_Click(object sender, EventArgs e)
{
int permission2, count = 0;
String Address, Semester, Email;
Address = Semester = Email = "";
string permission, name, id, pass, islogged;//, Email,Semester,Address;
islogged = "0";
name = pass = permission = id = null;
try
{
if (!(IdText.Text == string.Empty))
{
if (!(passwordtext.Text == string.Empty))
{
String query = "select * from Login where Id = '" + IdText.Text + "'and Password = '******'";
StringBuilder sb = new StringBuilder();
using (SqlCommand q = new SqlCommand(query, Globals.conn))
{
using (SqlDataReader dr = q.ExecuteReader())
{
if (!dr.HasRows)
{
//MessageBox.Show("No Such this username or password!", "ERROR", MessageBoxButtons.OK);
ErrorLbl.Visible = true;
return;
}
ErrorLbl.Visible = false;
while (dr.Read())
{
//getting the information from database.
permission = dr[3].ToString(); //getting the field of User : Student/Admin/..
id = dr[0].ToString();
name = dr[1].ToString();
pass = dr[2].ToString();
islogged = dr[4].ToString();
//Student Fields
Email = dr[5].ToString();
Semester = dr[6].ToString();
Address = dr[7].ToString();
///////////////////////////////////
//Updating the Instance fields.
Globals.LoggedUser.setName(name);
Globals.LoggedUser.setPerm(permission);
Globals.LoggedUser.setId(id);
Globals.LoggedUser.setPwd(pass);
Globals.LoggedUser.setIsLogged(islogged);
//////////////////////////////////
count = count + 1;
}
}
}
/*Check If Another user already logged*/
if (Int32.Parse(Globals.LoggedUser.getisLogged()) == 1)
{
MessageBox.Show("ERROR: This account is already logged in.");
return;
}
//dbr.Close(); //closing Reader
//Globals.LoggedUser.setIsLogged("1"); //to prevent dual-login.
//Globals.LoggedUser.saveData(id); //updating the database.
permission2 = Int32.Parse(permission); //converting to int , to check field.
//Loading Screen
using (var Wait = new merge_B.Loading(GoSch))
{
Wait.ShowDialog(this);
}
if (count == 1)
{
if (permission2 == 0)
{
Globals.LoggedUser = new User();
Globals.LoggedUser = new Classes.Student(Globals.LoggedUser);
Globals.LoggedUser.setName(name);
Globals.LoggedUser.setPerm(permission);
Globals.LoggedUser.setId(id);
Globals.LoggedUser.setPwd(pass);
Globals.LoggedUser.setIsLogged(islogged);
//Student fields
(Globals.LoggedUser as Classes.Student).setAddress(Address);
(Globals.LoggedUser as Classes.Student).setSemester(Semester);
(Globals.LoggedUser as Classes.Student).setMail(Email);
//View Student Panel
this.Close();
Thread th = new Thread(OpenStudentPortal);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
if (permission2 == 1)
{
Globals.GlobalSecretary.setName(name);
Globals.GlobalSecretary.setPerm(permission);
Globals.GlobalSecretary.setId(id);
Globals.GlobalSecretary.setPwd(pass);
Globals.GlobalSecretary.setIsLogged(islogged);
//View Student Panel
this.Close();
Thread th = new Thread(OpenSecretaryPortal);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
if (permission2 == 2)
{
Globals.GlobalAdmin.setName(name);
Globals.GlobalAdmin.setPerm(permission);
Globals.GlobalAdmin.setId(id);
Globals.GlobalAdmin.setPwd(pass);
Globals.GlobalAdmin.setIsLogged(islogged);
//View Student Panel
this.Close();
Thread th = new Thread(GoAdmin);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
if (permission2 == 3)
{
Globals.GlobalTechnican.setName(name);
Globals.GlobalTechnican.setPerm(permission);
Globals.GlobalTechnican.setId(id);
Globals.GlobalTechnican.setPwd(pass);
Globals.GlobalTechnican.setIsLogged(islogged);
//View Student Panel
this.Close();
Thread th = new Thread(GoTechnical);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
}
else if (count > 1)
{
MessageBox.Show("Duplicate username and password", "login page");
}
else
{
MessageBox.Show("Username and password are incorrect", "login page");
}
}
else
{
MessageBox.Show("Password is Empty!", "login page");
}
}
else
{
MessageBox.Show("UserName is Empty!", "login page");
}
}
catch
{
MessageBox.Show("UnExcpected Exception, ask owner to fix!!", "ERROR", MessageBoxButtons.OK);
}
}
