private void button2_Click(object sender, EventArgs e)
{
CounselorMenu a = new CounselorMenu();
a.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
{
int serialNum = Program.Activities.Count + 1;
SqlCommand s = new SqlCommand();
s.CommandText = "EXECUTE dbo.SP_Update_materialPerActivity @term_no , @term_serialNumber, @term_quantity, @term_id";
s.Parameters.AddWithValue("@term_no", activityNum);
s.Parameters.AddWithValue("@term_serialNumber", material2.getSerialNumber());
s.Parameters.AddWithValue("@term_quantity", int.Parse(textBox1.Text.ToString()));
s.Parameters.AddWithValue("@term_id", i + 20);
i = i + 20;
SQL_CON SC = new SQL_CON();
SC.execute_non_query(s);
CounselorMenu mn = new CounselorMenu();
this.Hide();
mn.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
int serialNum = Program.TechnicalFailures.Count() + 1;
SqlCommand s = new SqlCommand();
s.CommandText = "EXECUTE [dbo].[SP_create_technical_call] @term_no, @term_dt, @term_roomId, @term_employeeId, @term_description";
s.Parameters.AddWithValue("@term_no", serialNum);
s.Parameters.AddWithValue("@term_dt", DateTime.Parse(dateTimePicker1.Value.ToShortDateString()));
s.Parameters.AddWithValue("@term_roomId ", comboBox1.Text.ToString());
s.Parameters.AddWithValue("@term_employeeId ", EmployeeId);
s.Parameters.AddWithValue("@term_description ", richTextBox1.Text.ToString());
SQL_CON SC = new SQL_CON();
SC.execute_non_query(s);
Program.init_TechnicalFailures();
CounselorMenu mn = new CounselorMenu();
this.Hide();
mn.Show();
}
