public async Task InsertCustomersSampleData(CustomersDbContext db) { var states = GetStates(); db.States.AddRange(states); try { int numAffected = await db.SaveChangesAsync(); _Logger.LogInformation(@"Saved {numAffected} states"); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(CustomersDbSeeder)}: " + exp.Message); throw; } var customers = GetCustomers(states); db.Customers.AddRange(customers); try { int numAffected = await db.SaveChangesAsync(); _Logger.LogInformation($"Saved {numAffected} customers"); } catch (Exception exp) { _Logger.LogError($"Error in {nameof(CustomersDbSeeder)}: " + exp.Message); throw; } }
public async Task <IActionResult> PutCustomer(int id, Customer customer) { if (id != customer.id) { return(BadRequest()); } _context.Entry(customer).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CustomerExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task InsertCustomersSampleData(CustomersDbContext db) { var states = GetStates(); db.States.AddRange(states); try { await db.SaveChangesAsync(); } catch (Exception exp) { _logger.LogError($"Error in {nameof(CustomersDbSeeder)}: " + exp.Message); throw; } var customers = GetCustomers(states); db.Customers.AddRange(customers); try { await db.SaveChangesAsync(); } catch (Exception exp) { _logger.LogError($"Error in {nameof(CustomersDbSeeder)}: " + exp.Message); throw; } }
public async Task <(bool IsSuccess, Db.Customer Customer, string ErrorMessage)> PostCustomerAsync([FromBody] Models.Customer customer) { try { logger?.LogInformation("Creating customer"); var mapper = configurationProvider.CreateMapper(); var newcustomer = mapper.Map <Db.Customer>(customer); if (newcustomer != null) { dbContext.Customers.Add(newcustomer); await dbContext.SaveChangesAsync(); logger?.LogInformation($"product created {newcustomer}"); var createPostCustomerCommand = new CreatePostCustomerCommand(newcustomer.Id, customer.Name, customer.Address); await eventBus.SendCommand(createPostCustomerCommand); return(true, newcustomer, null); } return(false, null, "Not created"); } catch (Exception ex) { logger?.LogError(ex.ToString()); return(false, null, ex.Message); } }
public async Task <IActionResult> Create([Bind("ID,Title,Author,Price,Rating")] Books books) { if (ModelState.IsValid) { _context.Add(books); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(books)); }
public async Task <IActionResult> Create([Bind("Id,Place,Address,Description,Open_Hours")] Attraction attraction) { if (ModelState.IsValid) { _context.Add(attraction); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(attraction)); }
public async Task <IActionResult> Create([Bind("Id,Name,Mobile,Email,Address")] Customer customer) { if (ModelState.IsValid) { _context.Add(customer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(customer)); }
public async Task <IActionResult> Create([Bind("Id,Number_of_Tickets,Ticket_Price,CustomerId,AttractionId")] Booking booking) { if (ModelState.IsValid) { _context.Add(booking); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["AttractionId"] = new SelectList(_context.Attraction, "Id", "Address", booking.AttractionId); ViewData["CustomerId"] = new SelectList(_context.Customer, "Id", "Id", booking.CustomerId); return(View(booking)); }
public async Task <IActionResult> Create([Bind("ID,CustomerID,BooksID,OrderDate")] Order order) { if (ModelState.IsValid) { _context.Add(order); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BooksID"] = new SelectList(_context.Books, "ID", "ID", order.BooksID); ViewData["CustomerID"] = new SelectList(_context.Customer, "ID", "ID", order.CustomerID); return(View(order)); }
public async Task <Customer> InsertCustomerAsync(Customer customer) { _Context.Add(customer); try { await _Context.SaveChangesAsync(); } catch (System.Exception exp) { _Logger.LogError($"Error in {nameof(InsertCustomerAsync)}: " + exp.Message); } return(customer); }
public async Task <ActionResult <CustomersForInsertModel> > InputCustomerAsync(CustomersForInsertModel customer) { try { CustomersModel newCustomer = GetNewCustomer(customer); _context.Add(newCustomer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { throw; } return(NoContent()); }
public async Task <IActionResult> Post([FromBody] Customer customer) { try { _customersDbContext.Customers.Add(customer); await _customersDbContext.SaveChangesAsync(); return(Ok(customer)); } catch (Exception ex) { Debug.WriteLine(ex.Message); _logger.LogError(ex.Message); throw; } }
public async Task <ActionResult <Customer> > CreateCustomerAsync([FromBody, Required] CustomerInput customer) { var newCustomer = new Customer(customer); try { await context.AddAsync(newCustomer); await context.SaveChangesAsync(); } catch (Exception) { return(BadRequest()); } return(CreatedAtAction("GetCustomer", new { id = newCustomer.Id }, newCustomer)); }
public async Task Setup() { using var context = new CustomersDbContext(dbContextOptions); await context.AddRangeAsync(customers); await context.SaveChangesAsync(); customersController = new CustomersController(new CustomersDbContext(dbContextOptions)); }
public async Task <IActionResult> Index() { var newCustomer = new Customer { Name = "Michelle Thomas", City = "Los Angeles" }; _context.Customers.Add(newCustomer); await _context.SaveChangesAsync(); var customer = _context.Customers.FirstOrDefault(); return(View(customer)); }
public async Task <RegisterViewModel> Register(CreateUserModel registerRequest) { var register = customersDbContext.Customers.SingleOrDefault(customer => (customer.Email == registerRequest.Email || customer.Phone == registerRequest.Phone)); if (register != null) { return(null); } var customer = _mapper.Map <User>(registerRequest); await customersDbContext.Customers.AddAsync(customer); await customersDbContext.SaveChangesAsync(); return(new RegisterViewModel { Fullname = customer.Fullname, Status = "200", Message = "Success" }); }
public async Task Add(Customer customer) { _customersDbContext.Customers.Add(customer); await _customersDbContext.SaveChangesAsync(); }