private void add_assistant_button_Click(object sender, EventArgs e)
{
this.Hide();
//A_addTA_DH ta = new A_addTA_DH();
A_addTA_DH ta = new A_addTA_DH(this.dep);
ta.passValue = dep;
ta.Show();
}
private void submit_button_Click(object sender, EventArgs e)
{
int flag = 0;
int depFlag = 0;
//check fields are not empty
if (String.IsNullOrEmpty(ID_txtBox.Text) ||
String.IsNullOrEmpty(firstName_txtbox.Text) ||
String.IsNullOrEmpty(lastName_txtbox.Text) ||
String.IsNullOrEmpty(password_textBox.Text) ||
String.IsNullOrEmpty(ID_Department_txtbox.Text))
{
MessageBox.Show("All fields REQIRED! please try again");
this.ID_txtBox.Clear();
this.firstName_txtbox.Clear();
this.lastName_txtbox.Clear();
this.password_textBox.Clear();
this.ID_Department_txtbox.Clear();
this.Hide();
//A_addTA_DH lec = new A_addTA_DH();
A_addTA_DH lec = new A_addTA_DH(this.dep);
lec.ShowDialog();
}
cn = new SqlConnection("Data Source=p17server.database.windows.net;Initial Catalog=P17DATABASE;Persist Security Info=True;User ID=P17;Password=Hadas@2017");
cn.Open();
cmd = new SqlCommand("SELECT* FROM Departments", cn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString() == ID_Department_txtbox.Text)
{
depName = dr[1].ToString();
depFlag++;
break;
}
}
dr.Close();
cmd = new SqlCommand("select * from Users ", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString() == ID_txtBox.Text)
{
flag++;
}
}
dr.Close();
cmd = new SqlCommand("SELECT * FROM UsersDepartment", cn);
dr = cmd.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();
cn.Close();
if (depFlag == 0)
{
MessageBox.Show("Department not exists in database!");
this.ID_txtBox.Clear();
this.firstName_txtbox.Clear();
this.lastName_txtbox.Clear();
this.password_textBox.Clear();
this.ID_Department_txtbox.Clear();
}
else
{
if (flag > 0)
{
MessageBox.Show("teaching assistant allready exists in database!");
this.ID_txtBox.Clear();
this.firstName_txtbox.Clear();
this.lastName_txtbox.Clear();
this.password_textBox.Clear();
this.ID_Department_txtbox.Clear();
}
else
{
cn = new SqlConnection("Data Source=p17server.database.windows.net;Initial Catalog=P17DATABASE;Persist Security Info=True;User ID=P17;Password=Hadas@2017");
cn.Open();
cmd = new SqlCommand("INSERT INTO Users(ID,FirstName,LastName,Type,Password,Departments) VALUES (@ID,@FirstName,@LastName,@Type,@Password,@Departments)", cn);
cmd.Parameters.AddWithValue("@ID", ID_txtBox.Text);
cmd.Parameters.AddWithValue("@FirstName", firstName_txtbox.Text);
cmd.Parameters.AddWithValue("@LastName", lastName_txtbox.Text);
cmd.Parameters.AddWithValue("@Type", 3);
cmd.Parameters.AddWithValue("@Password", password_textBox.Text);
cmd.Parameters.AddWithValue("@Departments", depName);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd1 = new SqlCommand("INSERT INTO UsersDepartment(Num,ID,IDdepartment) VALUES (@Num,@ID,@IDdepartment)", cn);
cmd1.Parameters.AddWithValue("@Num", nextIndex);
cmd1.Parameters.AddWithValue("@ID", ID_txtBox.Text);
cmd1.Parameters.AddWithValue("@IDdepartment", ID_Department_txtbox.Text);
cmd1.ExecuteNonQuery();
cmd1.Parameters.Clear();
MessageBox.Show("New Teaching assistant [" + firstName_txtbox.Text + "] added succesfully!");
this.Hide();
//A_DHadd back = new A_DHadd();
A_DHadd.currentA_DHadd.Show();// back = new A_DHadd(this.dep);
// back.ShowDialog();
}
}
dr.Close();
cn.Close();
}
private void A_addTA_DH_Load(object sender, EventArgs e)
{
currentA_addTA_DH = this;
}
