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();
/* int serial = Program.TechnicalFailures.Count;
* DateTime dt = dateTimePicker1.Value.Date;
* ActivityRoom acr = Program.searchActivityRoom(int.Parse(comboBox1.ValueMember.ToString()));
* Employee emp = Program.searchEmployee(int.Parse(comboBox2.ValueMember.ToString()));
* string stri = richTextBox1.Text.ToString();
* TechnicalFailure tf = new TechnicalFailure(serial, dt, acr, emp, stri);
* Program.TechnicalFailures.Add(tf); */
}
private void button2_Click(object sender, EventArgs e)
{
int serialNum = Program.Activities.Count() + 1;
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.SP_Update_activities @term_no, @term_age, @term_activity, @term_needChair, @term_needtable, @term_needComputer, @term_needBoard, @term_startActivity, @term_endActivity, @term_numOfParticipants, @term_embedCounselor, @term_embedRoom";
c.Parameters.AddWithValue("@term_no", serialNum);
c.Parameters.AddWithValue("@term_age", int.Parse((textBox2.Text.ToString())));
c.Parameters.AddWithValue("@term_activity", comboBox1.Text.ToString());
c.Parameters.AddWithValue("@term_needChair", chairValue);
c.Parameters.AddWithValue("@term_needtable", tableValue);
c.Parameters.AddWithValue("@term_needComputer", computerValue);
c.Parameters.AddWithValue("@term_needBoard", boardValue);
c.Parameters.AddWithValue("@term_startActivity", DateTime.Parse(dateTimePicker2.Value.ToShortDateString()));
c.Parameters.AddWithValue("@term_endActivity", DateTime.Parse(dateTimePicker1.Value.ToShortDateString()));
c.Parameters.AddWithValue("@term_numOfParticipants", int.Parse(textBox9.Text.ToString()));
c.Parameters.AddWithValue("@term_embedCounselor", 0);
c.Parameters.AddWithValue("@term_embedRoom", 0);
SQL_CON SC = new SQL_CON();
SC.execute_non_query(c);
Program.init_Activities();
Menu mn = new Menu();
this.Hide();
mn.Show();
}
public static void init_Materials()
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_all_materials";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
Materials = new List<Material>();
while (rdr.Read())
{
Material m = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), rdr.GetValue(1).ToString());
Materials.Add(m);
}
}
public static void init_Activities()
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_all_activities";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
Activities = new List<Activity>();
while (rdr.Read())
{
Activity a = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), rdr.GetValue(1).ToString(), int.Parse(rdr.GetValue(2).ToString()), int.Parse(rdr.GetValue(3).ToString()), rdr.GetValue(4).ToString());
Activities.Add(a);
}
}
public static void init_TechnicalFailures()
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_all_technicalFailure";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
TechnicalFailures = new List<TechnicalFailure>();
while (rdr.Read())
{
TechnicalFailure tf = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse((rdr.GetValue(1).ToString())), DateTime.Parse((rdr.GetValue(2).ToString())), int.Parse(rdr.GetValue(3).ToString());
TechnicalFailures.Add(tf);
}
}
public static void init_Employees()//מילוי המערך מתוך בסיס הנתונים
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_all_employees";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
Employees = new List<Employee>();
while (rdr.Read())
{
Employee e = new Employee(rdr.GetValue(0).ToString(), rdr.GetValue(1).ToString(), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), int.Parse(rdr.GetValue(5).ToString()));
Employees.Add(e);
}
}
public static void init_EmbedEmployeesToActivities()
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_all_embedEmployeesToActivities";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
EmbedEmployeesToActivities = new List<EmbedEmployeeToActivity>();
while (rdr.Read())
{
EmbedEmployeeToActivity eetar = new ActivityRoom(int.Parse(rdr.GetValue(0).ToString()), DateTime.Parse((rdr.GetValue(1).ToString())), DateTime.Parse((rdr.GetValue(2).ToString())), int.Parse(rdr.GetValue(3).ToString()), int.Parse(rdr.GetValue(4).ToString()));
EmbedEmployeesToActivities.Add(eetar);
}
}
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 button2_Click_1(object sender, EventArgs e)
{
int serialNum = Program.EmbedEmployeesToActivities.Count() + 6;
SqlCommand s = new SqlCommand();
s.CommandText = "EXECUTE [dbo].[SP_Update_embed_employee_to_activities] @term_embedId, @term_no, @term_employeeId";
s.Parameters.AddWithValue("@term_embedId", serialNum);
s.Parameters.AddWithValue("@term_no", activityNum);
s.Parameters.AddWithValue("@term_employeeId", comboBox2.Text.ToString());
SQL_CON SC = new SQL_CON();
SC.execute_non_query(s);
Program.init_EmbedEmployeesToActivities();
Menu mn = new Menu();
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();
}