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);
}
}
private void Submit_ED_Approval_Click(object sender, EventArgs e)
{
for (int rows = 0; rows < OpenEDforLC.Rows.Count; rows++)
{
if (OpenEDforLC.Rows[rows].Cells[5].Value != null && OpenEDforLC.Rows[rows].Cells[6].Value != null)
{
MessageBox.Show("Please make sure you are marking only one option", "Message", MessageBoxButtons.OK);
}
else if (OpenEDforLC.Rows[rows].Cells[5].Value == null && OpenEDforLC.Rows[rows].Cells[6].Value == null)
{
continue;
}
else
{
String newStatus = "Not Handeled";
String approvalNote = null;
if (OpenEDforLC.Rows[rows].Cells[7].Value != null)
{
approvalNote = OpenEDforLC.Rows[rows].Cells[7].Value.ToString();
}
EquipmentDemand ed = Program.getEquipmentDemandObject(int.Parse(OpenEDforLC.Rows[rows].Cells[0].Value.ToString()));
if (OpenEDforLC.Rows[rows].Cells[5].Value != null)
{
ed.approved();
newStatus = "Approved";
}
if (OpenEDforLC.Rows[rows].Cells[6].Value != null)
{
ed.notApproved();
newStatus = "Not Approved";
}
if (approvalNote != null)
{
ed.addApprovalNote(approvalNote);
Program.update_ed_approvalNote_in_DB(ed, approvalNote);
}
Program.update_ed_status_in_DB(ed, newStatus);
}
}
}