public ActionResult ViewOrder()
        {
            WorkOrders ord  = new WorkOrders(StringDAL.connectionString);
            var        list = ord.ViewOrders();

            return(View(list));
        }
        public ActionResult MadeTime(int OrderID)
        {
            WorkOrders ord = new WorkOrders(StringDAL.connectionString);

            ord.DateToMadeOrder(OrderID);
            return(RedirectToAction("Update", "Order", new { OrderID = OrderID }));
        }
        public async Task <IActionResult> Edit(int id, [Bind("WorkOrderId,UserId,UnitId,ServiceId,WorkOrderNumber,WorkOrderName,WorkOrderServiceType,WorkOrderCompletionStatus,WorkOrderAssign,WorkOrderLastModified,WorkOrderLastModifiedBy,WorkOrderIsActive")] WorkOrders workOrders)
        {
            if (id != workOrders.WorkOrderId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(workOrders);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!WorkOrdersExists(workOrders.WorkOrderId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["ServiceId"] = new SelectList(_context.Services, "ServiceId", "ServiceType", workOrders.ServiceId);
            ViewData["UnitId"]    = new SelectList(_context.Units, "UnitId", "UnitName", workOrders.UnitId);
            ViewData["UserId"]    = new SelectList(_context.Users, "UserId", "UserFirstName", workOrders.UserId);
            return(View(workOrders));
        }
Beispiel #4
0
 public void LoadWorkOrderDetails(int row)
 {
     if (WorkOrderGrid.GetRow(row) is WorkOrders item)
     {
         cboEmployeeId.EditValue    = item.Employees?.Id;
         txtPosition.Text           = item.Employees?.Position;
         txtOffice.Text             = item.Employees?.Offices?.OfficeName;
         txtPropNo.EditValue        = item.PPEs?.PropertyNo;
         dtRequestedDate.EditValue  = item.RequestedDate;
         cboEquipmentType.EditValue = item.PPEs?.EquipmentTypeId;
         txtDescription.Text        = item.PPEs?.Description;
         lblPODescription.Text      = item.WorkOrderId + " - " + item.PPEs?.PPEId + " - " + item.PPEs?.EquipmentTypes?.EquipmentType;
         txtFindings.Text           = item.Findings;
         txtProblems.Text           = item.Problem;
         txtRecommendation.Text     = item.Recommendation;
         lblBox.Text                           = item.Box?.ToString();
         this.WOId                             = item.Id;
         this.WorkOrders                       = item;
         lblFolderNo.Text                      = item.FolderNo;
         txtDeliveredDescription.Text          = item.DeliveredDescription;
         cboDeliveredBy.EditValue              = item.DeliveredBy;
         this.DocumentBindingSource.DataSource =
             new UnitOfWork().DocumentsRepo.Get(m => m.RefId == item.Id && m.TableName == "WorkOrders");
         backgroundWorker         = new BackgroundWorker();
         backgroundWorker.DoWork += (a, b) =>
         {
             this.Invoke(new Action(() =>
             {
                 LoadActions();
                 LoadTechEvalSheet();
             }));
         };
         backgroundWorker.RunWorkerAsync();
     }
 }
        public ActionResult CreateOrder(Order order)
        {
            WorkOrders ord     = new WorkOrders(StringDAL.connectionString);
            int        OrderID = ord.CreateOrder(correction(order));

            return(RedirectToAction("Update", "Order", new { OrderID = OrderID }));
        }
Beispiel #6
0
 private static void AddWorkOrderTempData()
 {
     WorkOrders.Add(new WorkOrder {
         No = "1001", StartDate = ParseDateTime("1.01.2017 08:00:00"), EndDate = ParseDateTime("1.01.2017 16:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1002", StartDate = ParseDateTime("1.01.2017 16:00:00"), EndDate = ParseDateTime("2.01.2017 00:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1003", StartDate = ParseDateTime("2.01.2017 00:00:00"), EndDate = ParseDateTime("2.01.2017 08:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1004", StartDate = ParseDateTime("2.01.2017 08:00:00"), EndDate = ParseDateTime("2.01.2017 16:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1005", StartDate = ParseDateTime("2.01.2017 16:00:00"), EndDate = ParseDateTime("3.01.2017 00:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1006", StartDate = ParseDateTime("3.01.2017 00:00:00"), EndDate = ParseDateTime("3.01.2017 08:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1007", StartDate = ParseDateTime("3.01.2017 08:00:00"), EndDate = ParseDateTime("3.01.2017 16:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1008", StartDate = ParseDateTime("3.01.2017 16:00:00"), EndDate = ParseDateTime("4.01.2017 00:00:00")
     });
     WorkOrders.Add(new WorkOrder {
         No = "1009", StartDate = ParseDateTime("4.01.2017 00:00:00"), EndDate = ParseDateTime("4.01.2017 08:00:00")
     });
 }
Beispiel #7
0
        private void Search()
        {
            Loading = true;

            QualityReportClient client = new QualityReportClient();

            client.GetAllWorkOrderAsync(new OrderClause()
            {
                WorkId = SearchText, PageSize = PageSize, PageIndex = _currentPageIndex
            });
            client.GetAllWorkOrderCompleted += (s, e) =>
            {
                Loading = false;
                if (e.Error == null)
                {
                    WorkOrders = e.Result.ToList();
                    if (WorkOrders.Any())
                    {
                        ReCordCount = WorkOrders.First().WorkSubItemGroup.RecordCount;
                    }
                    else
                    {
                        ReCordCount = 0;
                    }
                }
                else
                {
                    ReCordCount = 0;
                }
            };
        }
Beispiel #8
0
        public async Task <IActionResult> Edit(int id, [Bind("WorkOrderId,Description,ResidentId,StatusId,EmployeeId,Notes,DateCompleted,DateUpdated,DateCreated")] WorkOrders workOrders)
        {
            if (id != workOrders.WorkOrderId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(workOrders);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!WorkOrdersExists(workOrders.WorkOrderId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["EmployeeId"] = new SelectList(_context.Employees, "EmployeeId", "Email", workOrders.EmployeeId);
            ViewData["ResidentId"] = new SelectList(_context.Residents, "ResidentId", "Address", workOrders.ResidentId);
            ViewData["StatusId"]   = new SelectList(_context.Statuses, "StatusId", "Title", workOrders.StatusId);
            return(View(workOrders));
        }
Beispiel #9
0
 public frmAddEditTechSpecs(WorkOrders workOrders)
 {
     InitializeComponent();
     this.Icon       = Resources.maintenance.ToIcon();
     this.workOrders = workOrders;
     //Initialize(workOrders);
 }
Beispiel #10
0
        private void BindWorkOrderInfo()
        {
            PagingQueryConfig config = new PagingQueryConfig()
            {
                PageNo   = pgnWorkOrderInfoList.PageNo,
                PageSize = pgnWorkOrderInfoList.PageSize
            };
            WorkOrders workOrders = new WorkOrders();

            this.Factory     = this.cbeFactory.Text;
            this.Status      = this.cbeStatus.Text;
            this.WorkOrderNo = this.teWorkOrderNo.Text;
            this.PartNo      = this.tePart.Text;
            this.Type        = this.cbeType.Text;
            this.Store       = this.teStore.Text;
            DataSet ds = workOrders.GetWorkOrderByCondition(this.Factory, this.WorkOrderNo,
                                                            this.PartNo, this.Type, this.Store, this.Status, ref config);

            pgnWorkOrderInfoList.Pages   = config.Pages;
            pgnWorkOrderInfoList.Records = config.Records;
            if (string.IsNullOrEmpty(workOrders.ErrorMsg))
            {
                Content.MainView   = gridView1;
                Content.DataSource = ds.Tables[0];
                gridView1.BestFitColumns();
            }
            else
            {
                MessageService.ShowMessage(workOrders.ErrorMsg);
            }
        }
Beispiel #11
0
        public ActionResult EditWO(int id)
        {
            //add list of order statuses
            lstStatus.Clear();
            OrderStatus received = new OrderStatus();

            received.Status_ID          = 1;
            received.Status_Description = "Received";
            lstStatus.Add(received);
            OrderStatus testing = new OrderStatus();

            testing.Status_ID          = 2;
            testing.Status_Description = "Testing";
            lstStatus.Add(testing);
            OrderStatus finalizingReport = new OrderStatus();

            finalizingReport.Status_ID          = 3;
            finalizingReport.Status_Description = "Finalizing Reports";
            lstStatus.Add(finalizingReport);
            OrderStatus finished = new OrderStatus();

            finished.Status_ID          = 4;
            finished.Status_Description = "Finished";
            lstStatus.Add(finished);
            //add list to viewbag
            ViewBag.orderStatus = lstStatus;

            ViewBag.customers = db.Customers.ToList();
            ViewBag.employees = db.Employees.ToList();
            ViewBag.Message   = "Edit Work Order";
            WorkOrders wo = db.WorkOrders.Find(id);

            return(View(wo));
        }
        public ActionResult SelectOrder(int OrderID)
        {
            WorkOrders ord   = new WorkOrders(StringDAL.connectionString);
            Order      order = ord.ViewOrder(OrderID);

            return(View(order));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            WorkOrders workOrders = db.workOrders.Find(id);

            db.workOrders.Remove(workOrders);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Beispiel #14
0
 public static List <WorkOrder> GetWorkOrders()
 {
     if (WorkOrders.Any() == false)
     {
         AddWorkOrderTempData();
     }
     return(WorkOrders);
 }
        // GET: WorkOrders/Create
        public ActionResult Create()
        {
            ViewBag.ClientId = new SelectList(_medixServices.GetClients(), "ClientId", "Name");
            ViewBag.StateId  = new SelectList(_medixServices.GetStates(), "StateId", "Code");
            ViewBag.StatusId = new SelectList(_medixServices.GetStatus(), "StatusId", "Name");
            WorkOrders wo = new WorkOrders();

            return(View(wo));
        }
 // GET: WorkOrders/Edit
 public ActionResult Edit([Bind(Include = "WorkOrderId,WorkOrderNumber,CreatedDate,ClientId,StateId,StatusId,ETA")] WorkOrders wo)
 {
     if (ModelState.IsValid)
     {
         _medixServices.EditWorkOrder(wo);
     }
     TempData["messageNotifySuccess"] = "WorkOrder successfully updated";
     return(RedirectToAction("Index"));
 }
        public ActionResult CreateOrder()
        {
            WorkOrders ord = new WorkOrders(StringDAL.connectionString);
            CustEmplID id  = new CustEmplID();

            id.CustomerID = ord.GetCustomerID();
            id.EmployeeID = ord.GetEmployeeID();
            return(View(id));
        }
        public ActionResult Update(int OrderID)
        {
            WorkOrders ord = new WorkOrders(StringDAL.connectionString);
            CusEmpOrd  id  = new CusEmpOrd();

            id.CustomerID = ord.GetCustomerID();
            id.EmployeeID = ord.GetEmployeeID();
            id.order      = ord.ViewOrder(OrderID);
            return(View(id));
        }
 public ActionResult Edit([Bind(Include = "Id,WorkOrderId,GoldSmithName,CustomerName,CustomerMobileNumber,CustomerEmail,JewelleryDescription1,JewelleryDescription2,JewelleryDescription3,WorkToBeDone,WorkToBeDone2,WorkToBeDone3,AgentName,ProductGivenOn,DateAcceptedOrRejected,sAcceptedRejectedStatus,AmountToBeCollected,sStatus,Comments")] WorkOrders workOrders)
 {
     if (ModelState.IsValid)
     {
         db.Entry(workOrders).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(workOrders));
 }
 public NewWorkOrderSelectParameter(WorkOrders newWO, List <Parameters> lp, int woNO)
 {
     this.woNO  = woNO;
     this.newWO = newWO;
     this.lp    = lp;
     //this.LOPForOperations = lp;
     InitializeComponent();
     NavigationPage.SetHasNavigationBar(this, false);
     generateGrid();
 }
        public async Task <bool> PostWorkOrderUpdateAsync(WorkOrders newWO)
        {
            RestClient <WorkOrders> restClient = new RestClient <WorkOrders>();

            restClient.WebServiceUrl = url + "/api/WorkOrders/PostWorkOrder/";

            var result = await restClient.PostAsync(newWO);

            return(result);
        }
Beispiel #22
0
 public ActionResult CreateWorkOrder([Bind(Include = "WorkOrderID, Comments, RushOrder, CustomerID, PmtInfoID, LTNumber")] WorkOrders workOrders)
 {
     if (ModelState.IsValid)
     {
         db.WorkOrders.Add(workOrders);
         db.SaveChanges();
         return(RedirectToAction("WorkList"));
     }
     return(View(workOrders));
 }
Beispiel #23
0
 public NewWorkOrderConti(WorkOrders newWO, List <Parameters> lwop, int woNO, int backCount)
 {
     this.backCount = backCount;
     this.woNO      = woNO;
     this.newWO     = newWO;
     this.lp        = lwop;
     InitializeComponent();
     NavigationPage.SetHasNavigationBar(this, false);
     generateGrid();
 }
        // GET: WorkOrders/Edit
        public ActionResult Edit(int Id)
        {
            ViewBag.ClientId = new SelectList(_medixServices.GetClients(), "ClientId", "Name");
            ViewBag.StateId  = new SelectList(_medixServices.GetStates(), "StateId", "Code");
            ViewBag.StatusId = new SelectList(_medixServices.GetStatus(), "StatusId", "Name");

            WorkOrders wo = _medixServices.GetWorkOrderById(Id);

            return(View(wo));
        }
Beispiel #25
0
 public ActionResult Edit([Bind(Include = "WorkOrderID,OrderDueDate,OrderRushed,OrderStatus,OrderCreationDate,OrderDiscounts,CustID")] WorkOrders workOrders)
 {
     if (ModelState.IsValid)
     {
         db.Entry(workOrders).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.CustID = new SelectList(db.Customer, "CustID", "CustName", workOrders.CustID);
     return(View(workOrders));
 }
        public ActionResult WorkOrderList(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            WorkOrders workOrders = db.WorkOrders.Find(id);

            return(View(db.WorkOrders.SqlQuery("SELECT * FROM WorkOrders WHERE CustomerID = " + id).ToList()));
        }
 public ActionResult Update(Order order, int OrderID)
 {
     if (order != null)
     {
         order.orderID = OrderID;
         WorkOrders ord = new WorkOrders(StringDAL.connectionString);
         order = correction(order);
         ord.UpdateOrder(order);
     }
     return(RedirectToAction("Update", "Order", new { OrderID = OrderID }));
 }
        public IActionResult OnGet()
        {
            Message    = config["Message"];
            WorkOrders = data.GetByDetail(SearchTerm);

            if (WorkOrders == null || !WorkOrders.Any())
            {
                return(RedirectToPage("./NotFound"));
            }
            return(Page());
        }
Beispiel #29
0
        public virtual Models.Hours.HoursOfDay[] UserWork(int Year, string UserId)
        {
            var data = ((IObjectContextAdapter)this)
                       .ObjectContext.ExecuteStoreQuery <Models.Hours.HoursOfDay>("CALL sp_UserWork_Year({0}, {1});", Year, UserId).ToArray();

            foreach (var item in data)
            {
                item.WorkOrders = WorkOrders.Where(x => x.UserId == item.UserId && x.Date == item.Date).ToArray();
            }
            return(data);
        }
        public void CalcXpForCompletion(WorkOrders order)
        {
            var workOrderMember = GetWorkOrderMembers(order.Id);

            foreach (var member in workOrderMember)
            {
                var acceptedMember = new MemberController().GetMemberById(member.MemberId);
                acceptedMember.Xp = (acceptedMember.Xp + 50);
                MultiBotDb.Mcmember.Update(acceptedMember);
                MultiBotDb.SaveChanges();
            }
        }
 private static string GetValue(WorkOrders.PerfectView.PvRelationData data, RelationField field)
 {
   switch(field)
   {
     case RelationField.OverledenOpgeheven:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("e836ac6a-9f4f-4c88-91ab-1215cfdefa35")).Value;
     case RelationField.Extrainfo:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("52f6cb6a-926f-460d-ab55-3da0a4b67f2a")).Value;
     case RelationField.Sorteernaam:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("47b0e705-0cc4-462d-9399-518db42dc10d")).Value;
     case RelationField.Weergavenaam:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("4427c201-9484-4e63-bb87-598aa25c3c32")).Value;
     case RelationField.Aangemaaktdoor:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("33ca722b-5dcd-43af-a457-6c43e1015851")).Value;
     case RelationField.Aangemaaktop:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("5cd344a1-48a1-4e4f-872b-a6b41549884c")).Value;
     case RelationField.Gewijzigddoor:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("f11bf562-f9a6-4417-8cd7-b3d73bf829e5")).Value;
     case RelationField.Gewijzigdop:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("6899f229-dba6-4d98-a4f1-ba9d37f4af9e")).Value;
     case RelationField.Bezoekadresland:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("dbcb8f1b-803f-4321-abca-0555201e4078")).Value;
     case RelationField.Weblog:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("71256b0b-b2a3-4a86-bc39-06ab249fa045")).Value;
     case RelationField.Postadresstraat:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("e65a46aa-ba7e-4cc6-9ded-1080eba1cc7c")).Value;
     case RelationField.Website:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("997bf4c6-9dd0-4d42-9395-19e0aebadc73")).Value;
     case RelationField.Organisatienaam:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("d1d4d794-61a8-407c-bdd1-1e6827510d20")).Value;
     case RelationField.Postadrestoevoeging:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("6be73d9d-a95f-459d-b7ab-21ae546dc672")).Value;
     case RelationField.NaamKvK:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("dffb850f-ab58-4712-9068-22d1b31f5f98")).Value;
     case RelationField.Vervaldatumidentificatie:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("5187e77e-1243-49db-97ad-2ac510677cea")).Value;
     case RelationField.Factuuradresstraat:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("8efc0788-a13c-404c-9ace-30df9250dd67")).Value;
     case RelationField.Identificatieaanwezig:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("810f91e3-746b-4971-b5aa-33908fa19ca5")).Value;
     case RelationField.Bezoekadrestoevoeging:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("da76f44f-c354-4b6a-8fa6-42985e42eda2")).Value;
     case RelationField.Postadresextra:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("33e229d6-38a1-4e72-a5de-447918854961")).Value;
     case RelationField.Internenaam:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("43477e4c-a3f3-46bd-b126-45116539a6c1")).Value;
     case RelationField.Bezoekadresextra:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("4bdeb408-c29d-4b02-a419-47ede4c7c39f")).Value;
     case RelationField.BankrekeningnummerGironummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("55bc7130-7c27-40d5-a0ad-5043e27d5488")).Value;
     case RelationField.LinkedIn:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("107f4837-7ba2-4967-a38b-606f6b6ee9eb")).Value;
     case RelationField.Twitter:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("075eb39f-0bfa-44c1-9ca8-63d8c7652687")).Value;
     case RelationField.Crediteurnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("fbb17da4-0828-4a27-9093-65079b80b238")).Value;
     case RelationField.Factuuradrestoevoeging:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("85deaaf0-7f57-4d21-b19b-744d0ff046ac")).Value;
     case RelationField.Factuuradresland:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("55da04e8-bfff-46f9-bd00-7729bbd1588d")).Value;
     case RelationField.Postadresplaats:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("510b1bb5-b2d4-4558-8d6e-7d8a621cbf61")).Value;
     case RelationField.Aantalmedewerkers:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("bdd63d7c-b2d3-40c4-addd-7d9cc2f19398")).Value;
     case RelationField.Bedrijfsactiviteit:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("8026c75b-618a-4d7d-ba92-8517416f0781")).Value;
     case RelationField.Extranaam:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("69bb6c4a-b81b-4b3d-ba86-884a0dd36d0a")).Value;
     case RelationField.AfgiftedatuminschrijvingKvK:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("e3a7d5f3-6834-4fb5-a973-896b39fcea23")).Value;
     case RelationField.Bezoekadresplaats:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("b998f8b0-17bb-481f-99ff-8c95782c09a0")).Value;
     case RelationField.Facebook:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("b8d98a5b-c8e1-409b-b4d8-922ed7501f04")).Value;
     case RelationField.Rechtsvorm:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("78827f74-a111-4790-88c2-9274afb65fd5")).Value;
     case RelationField.Relatiecode:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("818569ad-550c-4666-ba66-94d62a1ffc44")).Value;
     case RelationField.Naambank:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("ea1fb638-290b-4ba3-858a-9d07dba47c94")).Value;
     case RelationField.Postadresland:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("bc70a414-0521-442c-b1c4-ae19366e3def")).Value;
     case RelationField.Factuuradresplaats:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("da4754ac-1426-4a1e-860b-ae59df6f2cbd")).Value;
     case RelationField.Algemeenemailadres:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("75970ab4-dad5-4a94-b70f-ae67e7e62575")).Value;
     case RelationField.Debiteurnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("5ca37d6d-d218-40aa-a05a-b32737af0866")).Value;
     case RelationField.Bezoekadrespostcode:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("040130e8-f60f-4534-9783-bcd7ce5db9c6")).Value;
     case RelationField.Postadrespostcode:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("bef9fdcd-aca5-4a9b-9bd6-c66cca68644a")).Value;
     case RelationField.Factuuradrespostcode:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("ac7d2dc3-8fdc-446d-8dc6-ca186bc593df")).Value;
     case RelationField.Algemeentelefoonnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("c8a5397b-3f3d-45a3-ba50-cb2cfa15cd2c")).Value;
     case RelationField.NummerKvK:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("4c4c1b0e-42bb-412d-9c34-ccc9678c2cf1")).Value;
     case RelationField.BTWnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("0eeb1902-7599-4a9e-bc53-cd28cd186ffd")).Value;
     case RelationField.Bezoekadresstraat:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("a3ede6e3-f568-4ea0-82a5-cd656dbb8728")).Value;
     case RelationField.Ibancode:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("f5004863-d334-403e-83c0-cdb2442b8129")).Value;
     case RelationField.Branche:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("7d2f2141-54f4-41a0-9423-ce04cbf46b0e")).Value;
     case RelationField.BICcode:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("773ed094-815c-4dd1-8205-d03ca2ac55e6")).Value;
     case RelationField.Factuuradresextra:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("10f0ee74-ccdc-4b14-87da-dcdd4f85a602")).Value;
     case RelationField.Algemeenfaxnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("93e1264a-f442-4d8a-9369-dcefffb7a932")).Value;
     case RelationField.Factuuradresnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("8f7d1213-1c97-440a-bc65-dcf7dd996b5e")).Value;
     case RelationField.Postadresnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("5e5919da-bd4d-4013-ad9c-feab4ace8f3f")).Value;
     case RelationField.Bezoekadresnummer:
       return data.FieldValues.Items.First(i => i.Id == Guid.Parse("1bb1e06c-c722-40b8-8098-fef591e3cef3")).Value;
   }
   return "";
 }