public static void CompleteOrder( int orderID , string orderType , ref List <int> listOfBagsCounted , ref List <int> listOfBagsNotCounted ) { if (listOfBagsNotCounted.Count < 1) { return; } //set the status of the rest of the bags to MISSING Qds_Drop_Sp qds_Drop_Sp = new Qds_Drop_Sp(Properties.Settings.Default.WsirDbConnectionString); List <Qds_Drop> dl = qds_Drop_Sp._SelectAllByOrderID_OrderType(orderID, orderType); Qds_Drop qds_Drop = dl[0]; Qds_Bag_Sp qds_Bag_Sp = new Qds_Bag_Sp(Properties.Settings.Default.WsirDbConnectionString); List <Qds_Bag> bl = qds_Bag_Sp._SelectAllByDropID(qds_Drop.DropID); //create new drop for missing bags Qds_Drop nd = new Qds_Drop(); //nd.DropID = 0; nd.CustomerID = qds_Drop.CustomerID; nd.NumberOfBags = listOfBagsNotCounted.Count; // od.NumberOfBags; nd.PaymentMethodID = qds_Drop.PaymentMethodID; nd.DepotID = qds_Drop.DepotID; nd.OrderID = 0; nd.OrderType = "M"; //missing qds_Drop_Sp.Insert(nd); //move missing bags to new drop //foreach(ComboBoxItem i in comboBoxBagId.Items) foreach (int id in listOfBagsNotCounted) { //move missing bag Qds_Bag mb = qds_Bag_Sp.Select(id); //bagIdFromComboBox); mb.DropID = nd.DropID; qds_Bag_Sp.Update(mb); } //change numer of bags of the original drop qds_Drop.NumberOfBags -= listOfBagsNotCounted.Count(); qds_Drop_Sp.Update(qds_Drop); //close order Sol_Order_Sp sol_Order_Sp = new Sol_Order_Sp(Properties.Settings.Default.WsirDbConnectionString); Sol_Order sol_Order = sol_Order_Sp.Select(orderID, orderType); sol_Order_Sp.UpdateDates(sol_Order.OrderID, sol_Order.OrderType, "", "DateClosed"); //is drop ready for payment? if (qds_Drop_Sp.IsReady(qds_Drop.DropID)) { string status = String.Empty; if (qds_Drop.PaymentMethodID == 1) { status = "A"; } else { status = "O"; } sol_Order_Sp.UpdateStatus(sol_Order.OrderID, sol_Order.OrderType, status); } //update customerID //sol_Order_Sp._UpdateCustomerID(sol_Order.OrderID, sol_Order.OrderType, qds_Drop.CustomerID); }
private void QdBags_Load(object sender, EventArgs e) { panelDrops.Dock = DockStyle.Fill; panelDrops.Visible = true; //disable form resizing this.FormBorderStyle = FormBorderStyle.FixedSingle; if (Properties.Settings.Default.TouchOriented) { this.Height = this.Height + (OK.Height) + 150; OK.Height = OK.Height * 2; buttonBags.Height = buttonBags.Height * 2; buttonRefresh.Height = buttonRefresh.Height * 2; Cancel.Height = Cancel.Height * 2; toolStripButtonVirtualKb.Visible = true; this.radioButtonShowAll.Font = new System.Drawing.Font("Microsoft Sans Serif", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.radioButtonMineOnly.Font = new System.Drawing.Font("Microsoft Sans Serif", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.CenterToParent(); //bags buttonBagsSelect.Height = buttonBagsSelect.Height * 2; buttonBagsRefresh.Height = buttonBagsRefresh.Height * 2; buttonBagsClose.Height = buttonBagsClose.Height * 2; this.radioButtonBagsShowAll.Font = new System.Drawing.Font("Microsoft Sans Serif", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.radioButtonBagsUnused.Font = new System.Drawing.Font("Microsoft Sans Serif", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); } //drops //listview with headers listViewDrops.View = View.Details; listViewDrops.Columns.Add("Drop #", 120, HorizontalAlignment.Right); listViewDrops.Columns.Add("Customer", 230, HorizontalAlignment.Left); listViewDrops.Columns.Add("Bags", 110, HorizontalAlignment.Right); listViewDrops.Columns.Add("Payment Method", 230, HorizontalAlignment.Left); // listViewDrop.Columns.Add("DepotID", 120, HorizontalAlignment.Left); listViewDrops.Columns.Add("Order #", 120, HorizontalAlignment.Right); listViewDrops.Columns.Add("Type", 75, HorizontalAlignment.Center); listViewDrops.FullRowSelect = true; listViewDrops.CheckBoxes = true; listViewDrops.GridLines = true; //listViewDrops.Activation = ItemActivation.OneClick; listViewDrops.MultiSelect = true; //bags //listview with headers listViewBags.View = View.Details; listViewBags.Columns.Add("Bag #", 120, HorizontalAlignment.Right); listViewBags.Columns.Add("Date Entered", 230, HorizontalAlignment.Center); listViewBags.Columns.Add("Date Counted", 230, HorizontalAlignment.Center); listViewBags.Columns.Add("Date Printed", 230, HorizontalAlignment.Center); // listViewDrop.Columns.Add("DepotID", 120, HorizontalAlignment.Left); listViewBags.Columns.Add("Order #", 120, HorizontalAlignment.Right); listViewBags.FullRowSelect = true; listViewBags.CheckBoxes = true; listViewBags.GridLines = true; //listViewBags.Activation = ItemActivation.OneClick; if (qds_Drop_Sp == null) { qds_Drop_Sp = new Qds_Drop_Sp(Properties.Settings.Default.WsirDbConnectionString); } if (qds_Bag_Sp == null) { qds_Bag_Sp = new Qds_Bag_Sp(Properties.Settings.Default.WsirDbConnectionString); } if (qds_PaymentMethod_Sp == null) { qds_PaymentMethod_Sp = new Qds_PaymentMethod_Sp(Properties.Settings.Default.WsirDbConnectionString); } if (sol_Customer_Sp == null) { sol_Customer_Sp = new Sol_Customer_Sp(Properties.Settings.Default.WsirDbConnectionString); } radioButtonMineOnly.Checked = true; ReadDrops(radioButtonMineOnly.Checked); }