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