private void button_findOrder_Click(object sender, EventArgs e) { panel_CustomerSalesInfo.Visible = true; orderID = Convert.ToInt32(numericUpDown_OrderID.Value); /*CLEAR LISTBOXES*/ listBox_WorkTasks.Items.Clear(); listBox_Employees.Items.Clear(); listBox_Materials.Items.Clear(); panel_MaterialInfo.Visible = false; panel_TasksInfo.Visible = false; checkBox_TaskIsComplete.Visible = false; currentOrder = cc.FindInquiry(orderID); /*CHECK IF ORDER EXISTS*/ if (currentOrder != null) { /*LOAD CUSTOMER INFO*/ textBox_CustomerName.Text = currentOrder.GetOffer().GetBuyer().GetFullName(); textBox_CustomerAdress.Text = currentOrder.GetOffer().GetBuyer().GetAdresses()[0].GetAdress(); textBox_CustomerCity.Text = cc.GetCityName(currentOrder.GetOffer().GetBuyer().GetAdresses()[0].GetPostalCode()); textBox_CustomerPostalCode.Text = currentOrder.GetOffer().GetBuyer().GetAdresses()[0].GetPostalCode().ToString(); textBox_CustomerPhone.Text = currentOrder.GetOffer().GetBuyer().getTlf()[0].ToString(); textBox_CustomerId.Text = currentOrder.GetOffer().GetBuyer().GetID().ToString(); /*LOAD SALESMAN INFO*/ textBox_Salesman.Text = currentOrder.GetOffer().GetSalesMan().GetFullName(); textBox_SalesmanPhone.Text = currentOrder.GetOffer().GetSalesMan().GetPhone().ToString(); /*LOAD ORDER AND TASK INFO*/ textBox_OrderValue.Text = currentOrder.getOrderValue().ToString(); textBox_OrderCost.Text = currentOrder.getOrderCost().ToString(); /*ONLY DO THIS, IF WORK TASKS EXIST!*/ if (currentOrder.GetOffer().GetWorkTasks() != null) { foreach (TaskDescription item in currentOrder.GetOffer().GetWorkTasks().GetTasks()) { listBox_WorkTasks.Items.Add(item.GetDesc()); } } } else { /*LOAD CUSTOMER INFO*/ textBox_CustomerName.Text = ""; textBox_CustomerAdress.Text = ""; textBox_CustomerCity.Text = ""; textBox_CustomerPostalCode.Text = ""; textBox_CustomerPhone.Text = ""; textBox_CustomerId.Text = ""; /*LOAD SALESMAN INFO*/ textBox_Salesman.Text = ""; textBox_SalesmanPhone.Text = ""; } }
// XML CALLS public void WriteOrderXML(OrderDescription CurrentOrder) { OrderDescription ordre = CurrentOrder; xml.WriteOrderStatusXML(ordre); }
public void UpdateOrder(OrderDescription CurrentOrder) { dbc.OSDB.UpdateOrder(CurrentOrder); }
/*SETTERS*/ public void AddOrderDesc(OrderDescription order) { orders.Add(order); }
/*OrderDescription*/ public void ReadOrderStatusXML() { //TODO: MAKE IT UPDATE DATABASE! int itemLineID = 0; int taskID = 0; int itemID = 0; int itemAmount = 0; int itemAmountExtra = 0; int orderID = 0; int offerID = 0; int itemIsCompleted = 0; TaskCatalog tc = new TaskCatalog(); using (XmlReader reader = XmlReader.Create("Orderstatus.xml")) { while (reader.Read()) { if (reader.IsStartElement()) { switch (reader.Name) { case "Order": //Console.WriteLine("Start af Ordre"); break; case "OrderID": if (reader.Read()) { orderID = Convert.ToInt32(reader.Value.Trim()); } //Console.WriteLine("OrderID = " + orderID); break; case "OfferID": if (reader.Read()) { offerID = Convert.ToInt32(reader.Value.Trim()); } break; case "Task": //Console.WriteLine("Start på Task"); break; case "TaskID": if (reader.Read()) { taskID = Convert.ToInt32(reader.Value.Trim()); } //Console.WriteLine(taskID); break; case "Taskdescription": string taskDesc = ""; if (reader.Read()) { taskDesc = reader.Value.Trim(); } tc.AddTask(taskID, taskDesc); //Console.WriteLine(taskDesc); break; case "Taskcomplete": bool taskComplete = false; if (reader.Read()) { taskComplete = Convert.ToBoolean(reader.Value.Trim()); } tc.GetTask(taskID).SetStatus(taskComplete); //Console.WriteLine(taskComplete); break; /* case "ItemLine": itemLineID += 1; break;*/ case "itemID": if (reader.Read()) { itemID = Convert.ToInt32(reader.Value.Trim()); } //Console.WriteLine(" " + itemID); break; case "itemLineID": if(reader.Read()) { itemLineID = Convert.ToInt32(reader.Value.Trim()); } break; /*case "itemDesc": string itemDesc = ""; if (reader.Read()) { itemDesc = reader.Value.Trim(); } //Console.WriteLine(" " + itemDesc); break;*/ case "itemAmountExtra": if (reader.Read()) { itemAmountExtra = Convert.ToInt32(reader.Value.Trim()); } break; case "itemAmount": if (reader.Read()) { itemAmount = Convert.ToInt32(reader.Value.Trim()); } //Console.WriteLine(" " + itemAmount); dbc.OSDB.UpdateTaskEntry(itemAmountExtra, itemLineID); tc.AddTaskItems(taskID, ic.GetItem(itemID), itemAmount, itemAmountExtra); break; case "itemIsCompleted": if (reader.Read()) { itemIsCompleted = Convert.ToInt32(reader.Value.Trim()); } if (itemIsCompleted != 0) { tc.GetTask(taskID).GetItemLine(itemLineID).SetAmountCompleted(itemIsCompleted); } //Console.WriteLine(" " + itemIsCompleted); break; case "itemIsComplete": bool itemIsComplete = false; if (reader.Read()) { itemIsComplete = Convert.ToBoolean(reader.Value.Trim()); } if (itemIsComplete != false) { tc.GetTask(taskID).GetItemLine(itemLineID).setStatus(itemIsComplete); } //Console.WriteLine(" " + itemIsComplete); break; } } } } OrderDescription ordre = new OrderDescription(orderID, new OfferDescription(offerID, tc)); }
public void WriteOrderStatusXML(OrderDescription Order) { using (XmlWriter writer = XmlWriter.Create("OrderStatus.xml")) { writer.WriteStartDocument(); writer.WriteStartElement("Order"); writer.WriteElementString("OrderID", Order.GetId().ToString()); writer.WriteElementString("OfferID", Order.GetOffer().GetId().ToString()); foreach (TaskDescription task in Order.GetOffer().GetWorkTasks().GetTasks()) { writer.WriteStartElement("Task"); writer.WriteElementString("TaskID", task.GetId().ToString()); writer.WriteElementString("Taskdescription", task.GetDesc()); writer.WriteElementString("Taskcomplete", task.GetStatus().ToString()); foreach (ItemLine item in task.GetItemLines()) { writer.WriteStartElement("ItemLine"); writer.WriteElementString("itemID", item.GetItem().GetID().ToString()); writer.WriteElementString("itemLineID", item.GetLineID().ToString()); /*writer.WriteElementString("itemDesc", item.GetItem().GetDesc());*/ writer.WriteElementString("itemAmountExtra", item.GetAmountCompleted().ToString()); //TEMP FIX writer.WriteElementString("itemAmount", item.GetAmount().ToString()); //writer.WriteElementString("itemIsCompleted", item.GetAmountCompleted().ToString()); writer.WriteElementString("itemIsComplete", item.GetStatus().ToString()); writer.WriteEndElement(); } writer.WriteEndElement(); } writer.WriteEndElement(); writer.WriteEndDocument(); } }
public OrderDescription FindOrderStatus(int orderID) { String stringOfferID = ""; String stringCustomerID = ""; TaskCatalog orderTasks = new TaskCatalog(); // find inquiry for OfferID string findInquiry = "select * from Inquiry where InquiryID = " + orderID; conn.Open(); SqlCommand com = new SqlCommand(findInquiry, conn); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { stringOfferID = reader["OfferID"].ToString(); } conn.Close(); //find offer for Customer ID string findOffer = "select * from Offer where OfferID = " + stringOfferID; conn.Open(); com = new SqlCommand(findOffer, conn); reader = com.ExecuteReader(); while (reader.Read()) { stringCustomerID = reader["CustomerID"].ToString(); } conn.Close(); //find worktasks associated with offerID string findWorkTasks = "select * from Task where OfferID = " + stringOfferID; conn.Open(); com = new SqlCommand(findWorkTasks, conn); reader = com.ExecuteReader(); while (reader.Read()) { String stringTaskID = reader["TaskID"].ToString(); String taskDesc = reader["TaskDescription"].ToString(); int taskID = Convert.ToInt32(stringTaskID); orderTasks.AddTask(taskID, taskDesc); } conn.Close(); //add items to these worktasks foreach (TaskDescription task in orderTasks.GetTasks()) { string findWorkTasksItems = "select * from TaskEntry where TaskID = " + task.GetId(); com = new SqlCommand(findWorkTasksItems, conn); conn.Open(); reader = com.ExecuteReader(); while (reader.Read()) { String stringItemLineID = reader["TaskEntyID"].ToString(); int itemLineID = Convert.ToInt32(stringItemLineID); String stringTaskID = reader["TaskID"].ToString(); int taskID = Convert.ToInt32(stringTaskID); String stringItemID = reader["ItemID"].ToString(); int itemID = Convert.ToInt32(stringItemID); String stringAmount = reader["Amount"].ToString(); int amount = Convert.ToInt32(stringAmount); String stringAmountExtra = reader["AmountExtra"].ToString(); int amountExtra = Convert.ToInt32(stringAmountExtra); task.AddItems(itemLineID, ic.GetItem(itemID), amount, amountExtra); } conn.Close(); } int offerID = Convert.ToInt32(stringOfferID); OfferDescription offer = new OfferDescription(offerID, orderTasks); int customerID = Convert.ToInt32(stringCustomerID); offer.SetBuyer(custDB.FindCustomer(customerID)); OrderDescription order = new OrderDescription(orderID, offer); return order; }
public void UpdateOrder(OrderDescription CurrentOrder) { foreach (TaskDescription task in CurrentOrder.GetOffer().GetWorkTasks().GetTasks()) { foreach (ItemLine taskentry in task.GetItemLines()) { string update = "update TaskEntry set AmountExtra = " + taskentry.GetAmountCompleted() + " where TaskEntyID = " + taskentry.GetLineID(); SQLQueryHelper(update); } } }