public static void create_Contain_In_DB(contain con) { SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.SP_add_Contain @ProductName, @EdId, @Quantity, @Description "; c.Parameters.AddWithValue("@ProductName", con.getProduct().getName()); c.Parameters.AddWithValue("@EdId", con.getEquipmentDemand().getId()); c.Parameters.AddWithValue("@Quantity", con.getQuantity()); c.Parameters.AddWithValue("@Description", con.getDescription()); Console.WriteLine(c.ToString()); SQL_CON SC = new SQL_CON(); SC.execute_non_query(c); }
public static void init_contain(int edId) { //מילוי המערך מתוך בסיס הנתונים SqlCommand c = new SqlCommand(); c.CommandText = "EXECUTE dbo.Get_All_Contain " + edId; SQL_CON SC = new SQL_CON(); SqlDataReader rdr = SC.execute_query(c); while (rdr.Read()) { contain con = new contain(getEquipmentDemandObject(edId), getProductObject(rdr.GetValue(0).ToString()), int.Parse(rdr.GetValue(2).ToString()), rdr.GetValue(3).ToString()); getEquipmentDemandObject(edId).addContain(con); } }
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 void addContain(contain c) { ContainsProducts.Add(c); }