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); } } }