/* private void update_stat_breakdown_HE() { bool result = false; string query = String.Format("SELECT count(ps_invoice_info.id) AS manifest_count FROM ps_invoice_info WHERE 1 AND ps_invoice_info.status={0} AND ps_invoice_info.packed=2 AND ps_invoice_info.carrier_id=2 GROUP BY ps_invoice_info.carrier_id", (int)InvoiceStatus.INVOICED); MySqlDataReader dataReader = connection.getDataReader(query); while (dataReader.Read()) { if (dataReader["manifest_count"] + "" != "") { txtBox_stat_breakdown_HE.Text = dataReader["manifest_count"] + ""; result = true; } } if (!result) { txtBox_stat_breakdown_HE.Text = "0"; } dataReader.Close(); } private void update_stat_breakdown_EP() { bool result = false; string query = String.Format("SELECT count(ps_invoice_info.id) AS manifest_count FROM ps_invoice_info WHERE 1 AND ps_invoice_info.status={0} AND ps_invoice_info.packed=2 AND ps_invoice_info.carrier_id=4 GROUP BY ps_invoice_info.carrier_id", (int)InvoiceStatus.INVOICED); MySqlDataReader dataReader = connection.getDataReader(query); while (dataReader.Read()) { if (dataReader["manifest_count"] + "" != "") { txtBox_stat_breakdown_EP.Text = dataReader["manifest_count"] + ""; result = true; } } if (!result) { txtBox_stat_breakdown_EP.Text = "0"; } dataReader.Close(); } */ private void update_last_inserted() { if(last_invoiced == null) { last_invoiced = new Invoice(); string query = String.Format("SELECT i.time_created, i.invoiceNo, i.title, i.surName, i.firstName, i.middleName, i.postcode, i.parcel_weight, i.carrier_id, i.charge, i.parcel_num, i.packed FROM ps_invoice_info i WHERE i.status={0} ORDER BY i.id DESC LIMIT 1", (int)InvoiceStatus.INVOICED); IDataReader dataReader = connection.getDataReader(query); while (dataReader.Read()) { last_invoiced.InvoiceNo = String.IsNullOrEmpty(dataReader["invoiceNo"].ToString()) ? "" : dataReader["invoiceNo"].ToString(); last_invoiced.InvoiceCustomer.Title = String.IsNullOrEmpty(dataReader["title"].ToString()) ? "" : dataReader["title"].ToString(); last_invoiced.InvoiceCustomer.Firstname = String.IsNullOrEmpty(dataReader["firstName"].ToString()) ? "" : dataReader["firstName"].ToString(); last_invoiced.InvoiceCustomer.Middlename = String.IsNullOrEmpty(dataReader["middleName"].ToString()) ? "" : dataReader["middleName"].ToString(); last_invoiced.InvoiceCustomer.Lastname = String.IsNullOrEmpty(dataReader["surName"].ToString()) ? "" : dataReader["surName"].ToString(); last_invoiced.InvoiceCustomer.Postcode = String.IsNullOrEmpty(dataReader["postcode"].ToString()) ? "" : dataReader["postcode"].ToString(); Parcel p = new Parcel(); p.Weight = (float)(String.IsNullOrEmpty(dataReader["parcel_weight"].ToString()) ? 0 : Convert.ToDouble(dataReader["parcel_weight"]) / 1000); p.CostEstimate = String.IsNullOrEmpty(dataReader["charge"].ToString()) ? 0 : float.Parse(dataReader["charge"].ToString()); p.ParcelNumber = String.IsNullOrEmpty(dataReader["parcel_num"].ToString()) ? 1 : int.Parse(dataReader["parcel_num"].ToString()); last_invoiced.addParcel(p); int providerId = String.IsNullOrEmpty(dataReader["carrier_id"].ToString()) ? AP : int.Parse(dataReader["carrier_id"].ToString()); switch (providerId) { case AP: last_invoiced.Provider = AustraliaPost; break; case EP: last_invoiced.Provider = EPost; break; case HE: last_invoiced.Provider = HunterExpress; break; case TL: last_invoiced.Provider = Toll; break; } last_invoiced.Packed = String.IsNullOrEmpty(dataReader["packed"].ToString()) ? false : (dataReader["packed"].ToString() == "1" ? true : false); last_invoiced.InvoiceDate = String.IsNullOrEmpty(dataReader["time_created"].ToString()) ? DateTime.Now : DateTime.Parse(dataReader["time_created"].ToString()); txtBox_last_carrier.Text = GetCarrierNameForID(int.Parse(dataReader["carrier_id"].ToString())); } dataReader.Close(); } Parcel par = last_invoiced.Parcels.Count > 0 ? (Parcel)last_invoiced.Parcels[0] : new Parcel(); //txtBox_last_carrier.Text = String.Format("{0}", last_invoiced.Provider); txtBox_last_cost.Text = String.Format("{0:C}", par.CostEstimate); txtBox_last_invoiceNo.Text = last_invoiced.InvoiceNo; txtBox_last_packpick.Text = last_invoiced.Packed ? "Yes" : "No"; txtBox_last_parcelnum.Text = par.ParcelNumber.ToString(); txtBox_last_postcode.Text = last_invoiced.InvoiceCustomer.Postcode; txtBox_last_receiptient.Text = last_invoiced.InvoiceCustomer.FullName; txtBox_last_weight.Text = par.Weight.ToString(); txtBox_last_time.Text = last_invoiced.InvoiceDate.ToString("dd/MM/yyyy"); }