public IEnumerable <Orders> Get()
 {
     using (var context = new MovingCompanyContext())
     {
         return(context.Orders.ToList());
     }
 }
        public async Task <IActionResult> AddOrder([FromBody] PlaceOrder newData)
        {
            try
            {
                using (var context = new MovingCompanyContext())
                {
                    Person newPerson  = context.Person.SingleOrDefault(person => person.Mail == newData.Mail);
                    Person tempPerson = newPerson ?? new Person {
                        Mail = newData.Mail, Name = newData.Name, PhoneNumber = newData.PhoneNumber
                    };
                    if (newPerson == null)
                    {
                        context.Person.Add(tempPerson);
                        context.SaveChanges();
                    }

                    Orders newOrder = new Orders {
                        From = newData.From, Date = newData.Date, Note = newData.Note, PersonId = tempPerson.Id, To = newData.To, WorkType = newData.WorkType
                    };
                    context.Orders.Add(newOrder);
                    context.SaveChanges();
                }
            }
            catch (InvalidCastException e)
            {
                return(StatusCode(StatusCodes.Status500InternalServerError));
            }
            return(Ok());
        }