private void button_back_Click(object sender, EventArgs e)
{
this.Hide();
A_TeachingAssistant back = new A_TeachingAssistant(ta);
back.ShowDialog();
}
private void A_TeachingAssistant_Load(object sender, EventArgs e)
{
cureentA_TeachingAssistant = this;
}
private void button_SUBMIT_Click(object sender, EventArgs e)
{
bool alreadySigned = false;
if (String.IsNullOrEmpty(textBox_hoursAmount.Text))
{
MessageBox.Show("You dont enter your work hours amount");
this.Hide();
A_Insert_work_hours_for_TA.currentA_Insert_work_hours_for_TA.Show(); //form = new A_Insert_work_hours_for_TA(ta);
// form.ShowDialog();
}
SqlConnection cn = new SqlConnection("Data Source=p17server.database.windows.net;Initial Catalog=P17DATABASE;Persist Security Info=True;User ID=P17;Password=Hadas@2017");
cn.Open();
SqlCommand cmd0 = new SqlCommand("SELECT MAX (Num) FROM staffHours", cn);
dr = cmd0.ExecuteReader();
while (dr.Read())
{
//getting the last Num in table - in order to know to set next primary key
followNum = dr[0].ToString();
index = Int32.Parse(followNum) + 1;
nextIndex = index; //in order to get the number outside the loop
}
dr.Close();
List <String> dept = new List <string>();
SqlCommand cmd1 = new SqlCommand("SELECT * FROM UsersDepartment", cn);
dr = cmd1.ExecuteReader();
while (dr.Read())
{
if (dr["ID"].ToString() == ta.getID().ToString())
{
dept.Add(dr["IDdepartment"].ToString());
}
}
dr.Close();
if (dept.Count() == 0)
{
MessageBox.Show("You'r not associated with a department \n You'r not allowed to insert work hours");
textBox_hoursAmount.Clear();
}
else
{
SqlCommand cmd2 = new SqlCommand("SELECT * FROM staffHours", cn);
dr = cmd2.ExecuteReader();
while (dr.Read())
{
if (dr["ID"].ToString() == ta.getID().ToString())
{
if (Int32.Parse(dr["month"].ToString()) == numericUpDown_month.Value)
{
if (Int32.Parse(dr["year"].ToString()) == numericUpDown_year.Value)
{
alreadySigned = true;
break;
}
}
}
}
dr.Close();
if (!alreadySigned)
{
cmd = new SqlCommand("INSERT INTO staffHours(Num,ID,name,Type,IDdepartment,month,year,hoursAmount) VALUES (@Num,@ID,@name,@Type,@IDdepartment,@month,@year,@hoursAmount)", cn);
cmd.Parameters.AddWithValue("@Num", nextIndex);
cmd.Parameters.AddWithValue("@ID", ta.getID().ToString());
cmd.Parameters.AddWithValue("@name", ta.getFirstName().ToString() + " " + ta.getLastName().ToString());
cmd.Parameters.AddWithValue("@Type", 3);
cmd.Parameters.AddWithValue("@IDdepartment", dept[0]);
cmd.Parameters.AddWithValue("@month", numericUpDown_month.Value);
cmd.Parameters.AddWithValue("@year", numericUpDown_year.Value);
cmd.Parameters.AddWithValue("@hoursAmount", textBox_hoursAmount.Text);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
MessageBox.Show("Your work hours added succesfully!");
this.Close();
A_TeachingAssistant back = new A_TeachingAssistant(ta);
this.Hide();
back.ShowDialog();
}
else
{
if (alreadySigned)
{
MessageBox.Show("You have already enterd your hours for: " + numericUpDown_month.Value + " - " + numericUpDown_year.Value);
}
textBox_hoursAmount.Clear();
MessageBox.Show(" *** PAY ATTENTION: insertion work hours FAILED! ***");
}
}
cn.Close();
}
private void Login_button_Click(object sender, EventArgs e)
{
if (ID_Box.TextLength != 9)
{
MessageBox.Show("ooops Wrong ID please try again");
ID_Box.Text = "";
Password_box.Text = "";
}
SqlConnection connect = new SqlConnection(Return_Connection_String_Class.Return_Connection_String());
try
{
connect.Open();
}
catch (Exception ex)
{
// output the error to see what's going on
MessageBox.Show(ex.Message);
}
if (connect.State == System.Data.ConnectionState.Open)
{
string command = "select * from Users where ID = '" + ID_Box.Text + "' and Password = '******'";
SqlCommand cmd = new SqlCommand(command, connect);
SqlDataReader dataRead;
dataRead = cmd.ExecuteReader();
int type = 0;
string Messenge1 = "", Messenge2 = "";
while (dataRead.Read())
{
type = Convert.ToInt32(dataRead["Type"]);
int id = Convert.ToInt32(dataRead["ID"]);
string ln = (dataRead["LastName"].ToString());
string fn = (dataRead["FirstName"].ToString());
string depa = (dataRead["Departments"].ToString());
if (type == 1)
{
// 317509073/
//int id = Convert.ToInt32(dataRead["ID"]);
//string ln = (dataRead["LastName"].ToString());
//string fn = (dataRead["FirstName"].ToString());
string year = (dataRead["Year"].ToString());
//string depa = (dataRead["Departments"].ToString());
int semester = Convert.ToInt32(dataRead["Semester"]);
S1 = new StudentClass(id, fn, ln, type, year, semester, depa);
string readMassange = "select * from Messege_Box where ID = '" + S1.getID().ToString() + "'";
SqlCommand ReadMessageCommand = new SqlCommand(readMassange, connect);
SqlDataReader messangeRead;
messangeRead = ReadMessageCommand.ExecuteReader();
while (messangeRead.Read())
{
Messenge1 = (messangeRead["S_Messege"].ToString());
Messenge2 = (messangeRead["L_Messege"].ToString());
}
}
if (type == 2) // to create the object Lecturer
{
int pid = Convert.ToInt32(dataRead["ID"]);
string pln = (dataRead["LastName"].ToString());
string pfn = (dataRead["FirstName"].ToString());
string pdepa = (dataRead["Departments"].ToString());
P1 = new ProfessorClass(pid, pln, pfn, type, pdepa);
string readMassange = "select * from Messege_Box where ID = '" + P1.getID().ToString() + "'";
SqlCommand ReadMessageCommand = new SqlCommand(readMassange, connect);
SqlDataReader messangeRead;
messangeRead = ReadMessageCommand.ExecuteReader();
while (messangeRead.Read())
{
Messenge1 = (messangeRead["S_Messege"].ToString());
Messenge2 = (messangeRead["L_Messege"].ToString());
}
lec = new Lecturer();
this.lec.setLastName(ln);
this.lec.setFirstName(fn);
this.lec.setID(id);
this.lec.setdeparName(depa);
}
if (type == 3) // to create the object TeachingAssitant
{
ta = new TeachingAssitant();
this.ta.setLastName(ln);
this.ta.setFirstName(fn);
this.ta.setID(id);
this.ta.setdeparName(depa);
}
if (type == 4) // to create the object HeadDepartmrent
{
hd = new HeadDepartment();
this.hd.setLastName(ln);
this.hd.setFirstName(fn);
this.hd.setID(id);
this.hd.setdeparName(depa);
}
if (type == 5)
{
sec = new Secretary();
this.sec.setLastName(ln);
this.sec.setFirstName(fn);
this.sec.setID(id);
this.sec.setdeparName(depa);
}
if (type == 7)
{
sec = new Secretary();
this.sec.setLastName(ln);
this.sec.setFirstName(fn);
this.sec.setID(id);
this.sec.setdeparName(depa);
}
}
if (save_id.Checked)
{
Properties.Settings.Default.IDREMEMBER = ID_Box.Text.ToString();
Properties.Settings.Default.Save();
}
if (!save_id.Checked)
{
Properties.Settings.Default.IDREMEMBER = "";
Properties.Settings.Default.Save();
}
if (type == 1)
{
MessageBox.Show("wellcome " + S1.getFirstName() + " to student menu your ID " + S1.getID() + "");
this.Hide();
Student_Menu_B student = new Student_Menu_B();
if (Messenge1 != "" || Messenge2 != "")
{
student.Massange = true;
}
connect.Close();
student.passValue = S1;
dataRead.Close();
student.Show();
}
else if (type == 2)
{
MessageBox.Show("wellcome " + P1.getFirstName() + " to Lecturer Menu your ID " + P1.getID() + "");
this.Hide();
//Proffesor_Menu_B professor = new Proffesor_Menu_B();
A_LecturerMenu lecMenu = new A_LecturerMenu(lec);
lecMenu.passValue = P1;
connect.Close();
dataRead.Close();
lecMenu.ShowDialog();
/*
* this.Hide();
* A_LecturerMenu lecMenu = new A_LecturerMenu(lec);
* lecMenu.ShowDialog();
*/
//MessageBox.Show("Connceted Professor");
//this.Hide();
//Proffesor_Menu_B professor = new Proffesor_Menu_B();
//professor.Show();
// קבוצה B שימו לב !!!!!!!!
// אתם צריכים לשנות את הסוג של פרופסור אצלכם ל-2 ולשנות את זה בכל מקום! גם בקוד וגם בדטהבייס
// ואז לשלוח אותו לפורם הבא: A_lecturerMenu אחרי שתאחדו את הדרישות שלכם בפורם הזה
}
else if (type == 3)
{
this.Hide();
MessageBox.Show("wellcome " + ta.getFirstName() + " to Teaching Assistant Menu your ID " + ta.getID() + "");
A_TeachingAssistant taMenu = new A_TeachingAssistant(ta);
taMenu.passValue = ta;
connect.Close();
dataRead.Close();
taMenu.ShowDialog();
//change branch B --- type of proffesor to type 2
//MessageBox.Show("Connceted Professor");
//this.Hide();
//Proffesor_Menu_B professor = new Proffesor_Menu_B();
//professor.Show();
}
else if (type == 4)
{
this.Hide();
//HeadDepartment hd = new HeadDepartment();
A_DepartmentHead hdMenu = new A_DepartmentHead();
hdMenu.passValue = hd;
connect.Close();
dataRead.Close();
hdMenu.ShowDialog();
}
else if (type == 5)
{
MessageBox.Show("wellcome " + sec.getFirstName() + " to Secretary Menu your ID " + sec.getID() + "");
this.Hide();
Secretary_Menu_B secretary = new Secretary_Menu_B();
secretary.passsec = sec;
secretary.Show();
}
else if (type == 6)
{
MessageBox.Show("Connceted TECH");
this.Hide();
support__manager supp = new support__manager();
supp.Show();
}
else if (type == 7)
{
this.Hide();
MessageBox.Show("wellcome " + sec.getFirstName() + " to Secretary Menu your ID " + sec.getID() + "");
A_menuForSecretary secMenu = new A_menuForSecretary();
// secMenu.passValue = sec;
//connect.Close();
//dataRead.Close();
secMenu.Show();
}
else
{
MessageBox.Show("Wrong password");
Password_box.Text = "";
}
}
}
private void buttonLogin_Click(object sender, EventArgs e)
{
bool login = false;
SqlConnection cn = new SqlConnection("Data Source=p17server.database.windows.net;Initial Catalog=P17DATABASE;Persist Security Info=True;User ID=P17;Password=Hadas@2017");
cn.Open();
SqlCommand cmd = new SqlCommand("select * from Users where ID ='" + this.id_text.Text + "' and Password = '******'", cn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
string headDepartment;
string userType, user_name;
int result = 0;
while (dr.Read())
{
login = true;
userType = dr["Type"].ToString();
//We dont have Student - therefor we doesnt need to know his type
if (userType == "2")//for Lecturer Type
{
result = 2;
lec = new Lecturer();
lec.setID(int.Parse(dr["ID"].ToString()));
lec.setdeparName(dr["Departments"].ToString());
lec.setFirstName(dr["FirstName"].ToString());
lec.setLastName(dr["LastName"].ToString());
}
if (userType == "3")//for Teaching Assitant Type
{
result = 3;
ta = new TeachingAssitant();
ta.setID(int.Parse(dr["ID"].ToString()));
ta.setdeparName(dr["Departments"].ToString());
ta.setFirstName(dr["FirstName"].ToString());
ta.setLastName(dr["LastName"].ToString());
}
if (userType == "4")//for Head Department Type
{
result = 4;
dh = new HeadDepartment();
headDepartment = dr["ID"].ToString();
dh.setID(int.Parse(headDepartment));
dh.setdeparName(dr["Departments"].ToString());
dh.setFirstName(dr["FirstName"].ToString());
dh.setLastName(dr["LastName"].ToString());
}
if (userType == "5")//for Secretary Type
{
result = 5;
}
}
dr.Close();
cn.Close();
if (login)
{
//MessageBox.Show("Connect SUCCESSFULY");
if (result == 2)// in case user is Lecturer
{
this.Hide();
A_LecturerMenu lec = new A_LecturerMenu(this.lec);
lec.ShowDialog();
}
if (result == 3)//in case user is Teaching Assitant
{
this.Hide();
A_TeachingAssistant ta = new A_TeachingAssistant(this.ta);
ta.ShowDialog();
}
if (result == 4)// in case the user is Department Head
{
this.Hide();
//A_DepartmentHead depHead = new A_DepartmentHead();
A_DepartmentHead depHead = new A_DepartmentHead(this.dh);
depHead.ShowDialog();
}
if (result == 5)// in case the user is secretary
{
this.Hide();
A_menuForSecretary sec = new A_menuForSecretary();
sec.ShowDialog();
}
}
else
{
MessageBox.Show("Login FAILED !!! Invalid ID/Password");
}
this.id_text.Clear();
this.password_text.Clear();
}