public static void update_ed_approvalNote_in_DB(EquipmentDemand ed, String status)
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.SP_update_EquipmentDemand_ApprovalNote @EquipmentDemand, @ApprovalNote";
c.Parameters.AddWithValue("@EquipmentDemand", ed.getId());
c.Parameters.AddWithValue("@ApprovalNote", ed.getApprovalNote());
Console.WriteLine(c.ToString());
SQL_CON SC = new SQL_CON();
SC.execute_non_query(c);
}
public static void create_EquipmentDemand_In_DB(EquipmentDemand ed)
{
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.SP_add_EquipmentDemand @id, @Emp, @reason";
c.Parameters.AddWithValue("@id", ed.getId());
if (ed.getCreator() != null)
{
c.Parameters.AddWithValue("@Emp", ed.getCreator().getId());
}
c.Parameters.AddWithValue("@reason", ed.getReason());
Console.WriteLine(c.ToString());
SQL_CON SC = new SQL_CON();
SC.execute_non_query(c);
}
public static void init_EquipmentDemands()
{ //מילוי המערך מתוך בסיס הנתונים
SqlCommand c = new SqlCommand();
c.CommandText = "EXECUTE dbo.Get_All_EquipmentDemands";
SQL_CON SC = new SQL_CON();
SqlDataReader rdr = SC.execute_query(c);
equipmentDemands = new List <EquipmentDemand>();
while (rdr.Read())
{
EquipmentDemand ed = new EquipmentDemand(int.Parse(rdr.GetValue(0).ToString()), getEmployeeObject(rdr.GetValue(1).ToString()), DateTime.Parse((rdr.GetValue(5).ToString())), rdr.GetValue(2).ToString());
equipmentDemands.Add(ed);
init_contain(ed.getId());
ed.setStatus(rdr.GetValue(3).ToString());
ed.addApprovalNote(rdr.GetValue(4).ToString());
ed.getCreator().addEquipmentDemand(ed);
}
}