public Orchestrator.WebUI.ws.MappingServices.Point GetPoint(int pointID) { Orchestrator.Facade.IPoint facPoint = new Orchestrator.Facade.Point(); Orchestrator.Entities.Point selectedPoint = facPoint.GetPointForPointId(pointID); Orchestrator.WebUI.ws.MappingServices.Point p = new Orchestrator.WebUI.ws.MappingServices.Point(); p.PointID = selectedPoint.PointId; p.Description = selectedPoint.Description; p.Latitide = (double)selectedPoint.Latitude; p.Longitude = (double)selectedPoint.Longitude; p.GeofencePoints = new List <double[]>(); string points = string.Empty; for (int i = 0; i < selectedPoint.Geofence.STNumPoints(); i++) { SqlGeography point = selectedPoint.Geofence.STPointN(i + 1); double[] latLon = new double[2] { (double)point.Lat, (double)point.Long }; p.GeofencePoints.Add(latLon); //points = point.Lat.ToString() + ',' + point.Long.ToString() + '|'; } return(p); }
private void DisplayOrder(Orchestrator.Entities.Order order) { Orchestrator.Facade.IOrganisation facOrg = new Orchestrator.Facade.Organisation(); Orchestrator.Facade.IPoint facPoint = new Orchestrator.Facade.Point(); Orchestrator.Facade.IReferenceData facRefData = new Orchestrator.Facade.ReferenceData(); Orchestrator.Facade.IPOD facPOD = new Orchestrator.Facade.POD(); Orchestrator.Facade.IOrder facOrd = new Orchestrator.Facade.Order(); order.ClientInvoiceID = facOrd.ClientInvoiceID(OrderID); Orchestrator.Facade.Organisation facOrgD = new Orchestrator.Facade.Organisation(); Orchestrator.Entities.Point collectionPoint = facPoint.GetPointForPointId(order.CollectionPointID); Orchestrator.Entities.Point deliveryPoint = facPoint.GetPointForPointId(order.DeliveryPointID); Orchestrator.Entities.POD scannedPOD = facPOD.GetForOrderID(order.OrderID); Orchestrator.Entities.Scan scannedBookingForm = null; CurrentCulture = new CultureInfo(order.LCID); ExchangeRateID = order.ExchangeRateID; lblOrderHeading.Text = string.Format("Order {0}", order.OrderID); this.lblOrderStatus.Text = order.OrderStatus.ToString(); if (((Entities.CustomPrincipal) this.Page.User).IsInRole(((int)eUserRole.SubConPortal).ToString())) { this.btnPIL.Visible = false; this.btnCreateDeliveryNote.Visible = false; this.btnCreateDeliveryNote2.Visible = false; this.btnPIL2.Visible = false; plcBooking.Visible = false; plcPOD.Visible = false; // get cost for subby and display as rate. (The rate the subby is being paid) Facade.IJobSubContractor jobSubContractor = new Facade.Job(); if (order != null && order.JobSubContractID > 0) { Entities.JobSubContractor js = jobSubContractor.GetSubContractorForJobSubContractId(order.JobSubContractID); CultureInfo subbyCulture = new CultureInfo(js.LCID); if (Orchestrator.Globals.Configuration.MultiCurrency) { this.lblRate.Text = string.Format(rateTemplate, js.ForeignRate.ToString("C", subbyCulture), js.Rate.ToString("C")); } else { this.lblRate.Text = js.Rate.ToString("C", subbyCulture); } } this.tblSubbyRate.Visible = true; this.trRate.Visible = false; this.trInvoiceId.Visible = false; } else { this.tblSubbyRate.Visible = false; //If the order has a scanned Booking Form get it so that //a link to it can be displayed if (order.BookingFormScannedFormId != null) { Orchestrator.Facade.Form facBF = new Orchestrator.Facade.Form(); scannedBookingForm = facBF.GetForScannedFormId(order.BookingFormScannedFormId.Value); } //this.lblOrderID.Text = order.OrderID.ToString(); this.lblOrderStatus.Text = order.OrderStatus.ToString().Replace("_", " "); if (scannedBookingForm != null) { hlBookingFormLink.Visible = true; hlBookingFormLink.NavigateUrl = scannedBookingForm.ScannedFormPDF.Trim(); aScanBookingForm.InnerHtml = "| Re-Scan"; aScanBookingForm.HRef = @"javascript:ReDoBookingForm(" + scannedBookingForm.ScannedFormId + "," + order.OrderID.ToString() + ");"; } else { hlBookingFormLink.Visible = false; aScanBookingForm.InnerHtml = "Scan"; aScanBookingForm.HRef = @"javascript:NewBookingForm(" + order.OrderID.ToString() + ");"; } plcPOD.Visible = false; if (Orchestrator.Globals.Configuration.MultiCurrency) { this.lblRate.Text = string.Format(rateTemplate, order.ForeignRate.ToString("C", CurrentCulture), order.Rate.ToString("C")); } else { this.lblRate.Text = order.ForeignRate.ToString("C", CurrentCulture); } trRate.Visible = !order.IsInGroup; if (order.ClientInvoiceID <= 0) { lblInvoiceNumber.Text = "None Assigned"; } else { lblInvoiceNumber.Text = order.ClientInvoiceID.ToString(); string PDFLink = order.PDFLocation.ToString(); lblInvoiceNumber.NavigateUrl = Orchestrator.Globals.Configuration.WebServer + PDFLink; } } this.lblLoadNumber.Text = order.CustomerOrderNumber; this.lblDeliveryOrderNo.Text = order.DeliveryOrderNumber; this.lblCollectionPoint.Text = collectionPoint.Address.ToString(); this.lblDeliverTo.Text = deliveryPoint.Address.ToString(); this.lblCollectDateTime.Text = (order.CollectionIsAnytime == true ? (order.CollectionDateTime.ToString("dd/MM/yy") + " AnyTime") : (order.CollectionDateTime.ToString("dd/MM/yy HH:mm"))); this.lblDeliveryDateTime.Text = (order.DeliveryIsAnytime == true ? (order.DeliveryDateTime.ToString("dd/MM/yy") + " AnyTime") : (order.DeliveryDateTime.ToString("dd/MM/yy HH:mm"))) + order.DeliveryAnnotation; this.lblPallets.Text = order.NoPallets.ToString() + " " + Orchestrator.Facade.PalletType.GetForPalletTypeId(order.PalletTypeID).Description; this.lblPalletSpaces.Text = order.PalletSpaces.ToString("0.##"); this.lblGoodsType.Text = Orchestrator.Facade.GoodsType.GetForGoodsTypeId(order.GoodsTypeID).Description; this.lblWeight.Text = Convert.ToInt32(order.Weight).ToString() + " " + Orchestrator.Facade.WeightType.GetForWeightTypeId(order.WeightTypeID).ShortCode; this.repReferences.DataSource = order.OrderReferences; this.repReferences.DataBind(); this.lblCartons.Text = order.Cases.ToString(); if (order.Notes == null || order.Notes.Length == 0) { this.lblNotes.Text = " "; } else { this.lblNotes.Text = order.Notes; } if (order.CreateDateTime != DateTime.MinValue) { lblCreated.Text = order.CreatedBy + " on " + order.CreateDateTime.ToString("dd/MM/yy HH:mm"); } lblOrderServiceLevel.Text = order.OrderServiceLevel; if (order.BusinessTypeID > 0) { Orchestrator.Facade.IBusinessType facBusinessType = new Orchestrator.Facade.BusinessType(); Orchestrator.Entities.BusinessType businessType = facBusinessType.GetForBusinessTypeID(order.BusinessTypeID); lblBusinessType.Text = businessType.Description; } else { lblBusinessType.Text = "Not Set"; } plcCancellation.Visible = order.OrderStatus == eOrderStatus.Cancelled; if (order.OrderStatus == eOrderStatus.Cancelled) { lblCancellationReason.Text = order.CancellationReason; lblCancelledBy.Text = order.CancelledBy; lblCancelledAt.Text = order.CancelledAt.ToString("dd/MM/yy HH:mm"); } }
public bool ImportCustomers(DataSet ds) { DataTable dt = ds.Tables[0]; Orchestrator.Entities.Organisation organisation; Orchestrator.Entities.OrganisationLocation ol; Orchestrator.Entities.Individual i; Orchestrator.Entities.Point point; Orchestrator.Entities.Address address; Orchestrator.Facade.Organisation facOrganisation = new Orchestrator.Facade.Organisation(); foreach (DataRow row in dt.Rows) { organisation = new Orchestrator.Entities.Organisation(); organisation.OrganisationName = row["NAME"].ToString(); organisation.OrganisationDisplayName = row["NAME"].ToString(); organisation.OrganisationType = Orchestrator.eOrganisationType.Client; organisation.AccountCode = row["ACCOUNT_REF"].ToString(); address = new Orchestrator.Entities.Address(); address.AddressType = Orchestrator.eAddressType.Correspondence; address.AddressLine1 = row["ADDRESS_1"].ToString(); address.AddressLine2 = row["ADDRESS_2"].ToString(); address.PostTown = row["ADDRESS_3"].ToString(); address.County = row["ADDRESS_4"].ToString(); address.PostCode = row["ADDRESS_5"].ToString(); address.TrafficArea = new Orchestrator.Entities.TrafficArea(); address.TrafficArea.TrafficAreaId = 0; //Resolve The post Town if possible. string defaultPostTown = "Glasgow"; int defaultPostTownId = 9063; string postTown = (row["ADDRESS_4"].ToString() == "" ? null : row["ADDRESS_4"].ToString()) ?? (row["ADDRESS_3"].ToString() == "" ? null : row["ADDRESS_3"].ToString()) ?? (row["ADDRESS_2"].ToString() == "" ? null : row["ADDRESS_2"].ToString()) ?? defaultPostTown; if (address.PostTown == string.Empty) { address.PostTown = postTown; } int?postTownID = null; Orchestrator.Facade.ReferenceData facRef = new Orchestrator.Facade.ReferenceData(); DataSet dsTown = facRef.GetTownForTownName(postTown); if (dsTown.Tables[0].Rows.Count > 0) { postTownID = int.Parse(dsTown.Tables[0].Rows[0]["TownId"].ToString()); } ol = new Orchestrator.Entities.OrganisationLocation(); ol.OrganisationLocationName = "Head Office"; ol.OrganisationLocationType = Orchestrator.eOrganisationLocationType.HeadOffice; point = new Orchestrator.Entities.Point(); point.Description = "Head Office"; point.Collect = false; point.Deliver = false; point.Address = address; point.PostTown = new Orchestrator.Entities.PostTown(); point.PostTown.TownName = postTown; point.PostTown.TownId = postTownID ?? defaultPostTownId; ol.Point = point; if (organisation.Locations == null) { organisation.Locations = new Orchestrator.Entities.OrganisationLocationCollection(); } organisation.Locations.Add(ol); i = new Orchestrator.Entities.Individual(); i.Contacts = new Orchestrator.Entities.ContactCollection(); i.IndividualType = Orchestrator.eIndividualType.Contact; i.Title = Orchestrator.eTitle.Mr; if (row["CONTACT_NAME"] != string.Empty) { if (row["CONTACT_NAME"].ToString().IndexOf(' ') > 0) { i.FirstNames = row["CONTACT_NAME"].ToString().Split(' ')[0]; i.LastName = row["CONTACT_NAME"].ToString().Split(' ')[1]; } else { i.FirstNames = row["CONTACT_NAME"].ToString(); i.LastName = string.Empty; } } if (row["TELEPHONE"].ToString() != string.Empty) { i.Contacts.Add(new Orchestrator.Entities.Contact(Orchestrator.eContactType.Telephone, row["TELEPHONE"].ToString())); ol.TelephoneNumber = row["TELEPHONE"].ToString(); } if (row["FAX"].ToString() != string.Empty) { i.Contacts.Add(new Orchestrator.Entities.Contact(Orchestrator.eContactType.Fax, row["FAX"].ToString())); ol.FaxNumber = row["FAX"].ToString(); } if (row["E_MAIL"].ToString() != string.Empty) { i.Contacts.Add(new Orchestrator.Entities.Contact(Orchestrator.eContactType.Email, row["E_MAIL"].ToString())); } if (row["CONTACT_NAME"] != string.Empty) { organisation.IndividualContacts.Add(i); } Orchestrator.Entities.FacadeResult ret = facOrganisation.Create(organisation, "Orchestrator_Import"); if (!ret.Success) { return(false); } } return(true); }