public contain(EquipmentDemand equipmentDemand, Product product, int quantity, string description)
{
this.equipmentDemand = equipmentDemand;
this.product = product;
this.quantity = quantity;
this.description = description;
}
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 EquipmentDemand getEquipmentDemandObject(int id)
{
EquipmentDemand edRes = null;
foreach (EquipmentDemand ed in equipmentDemands)
{
if (ed.getId() == id)
{
edRes = ed;
}
}
return(edRes);
}
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);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string reasonForDemand = ReasonForDemand.Text;
if (string.IsNullOrWhiteSpace(reasonForDemand))
{
throw new Exception("Reason for Demand is nesessary");
}
EquipmentDemand ed = new EquipmentDemand(Program.equipmentDemands.Count + 1, Program.empUser, DateTime.Now, reasonForDemand);
Program.equipmentDemands.Add(ed);
Program.create_EquipmentDemand_In_DB(ed);
Program.empUser.addEquipmentDemand(ed);
for (int rows = 0; rows < productList.Rows.Count; rows++)
{
int quantity = 0;
string description = null;
if (productList.Rows[rows].Cells[1].Value != null)
{
int valueQuantity = int.Parse(productList.Rows[rows].Cells[1].Value.ToString());
if (valueQuantity != 0)
{
quantity = valueQuantity;
}
if (!string.IsNullOrWhiteSpace(productList.Rows[rows].Cells[2].Value.ToString()))
{
description = productList.Rows[rows].Cells[2].Value.ToString();
}
else
{
description = "N/A";
}
contain c = new contain(ed, Program.getProductObject(productList.Rows[rows].Cells[0].Value.ToString()), quantity, description);
ed.addContain(c);
Program.create_Contain_In_DB(c);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Invalid Input", MessageBoxButtons.OK);
}
}
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);
}
}
}
public void addEquipmentDemand(EquipmentDemand ed)
{
createdEquipmentDemands.Add(ed);
}