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()); }