public void can_read_customers()
{
var context = new OrdersAppDbContext();
var customer = context.Customer.FirstOrDefault();
Assert.IsNotNull(customer);
}
public ActionResult Index()
{
ViewBag.Title = "OrderApp Home Page";
try
{
var orderAppDbContext = new OrdersAppDbContext();
var customers = orderAppDbContext.Customer.ToList();
var list = new List <CustomerViewModel>();
foreach (var item in customers)
{
var returnCustomer = new CustomerViewModel
{
CustomerId = item.CustomerId,
Email = item.Email,
Name = item.Name
};
list.Add(returnCustomer);
}
return(View(list));
}
catch (Exception exception)
{
Log.Error(exception);
throw;
}
}
public void can_read_orders()
{
var context = new OrdersAppDbContext();
var orders = context.Orders.ToList();
Assert.IsNotNull(orders);
}
// POST V1/Customers/{id}
/// <summary>
/// Add new Order for existing Customer
/// </summary>
/// <param name="id"></param>
/// <param name="model"></param>
/// <returns></returns>
public Order Post(int id, OrderViewModel model)
{
try
{
var orderAppDbContext = new OrdersAppDbContext();
var customer = orderAppDbContext.Customer.FirstOrDefault(x => x.CustomerId == id);
if (customer != null)
{
var order = new Order {
Price = model.Price, CreatedDate = DateTime.Now, Customer = customer
};
orderAppDbContext.Orders.Add(order);
orderAppDbContext.SaveChanges();
return(order);
}
return(null);
}
catch (Exception ex)
{
Log.Error(ex);
return(null);
}
}
public Customer Post(CustomerViewModel model)
{
try
{
var orderAppDbContext = new OrdersAppDbContext();
var customer = new Customer {
Email = model.Email, Name = model.Name
};
orderAppDbContext.Customer.Add(customer);
orderAppDbContext.SaveChanges();
return(customer);
}
catch (Exception ex)
{
Log.Error(ex);
return(null);
}
}
// GET V1/Customers/{id}
/// <summary>
/// Return customer with his order list
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public CustomerViewModel Get(int id)
{
try
{
var orderAppDbContext = new OrdersAppDbContext();
var customer = orderAppDbContext.Customer.FirstOrDefault(x => x.CustomerId == id);
if (customer != null)
{
var returnCustomer = new CustomerViewModel
{
CustomerId = customer.CustomerId,
Email = customer.Email,
Name = customer.Name
};
if (customer.CustomerOrders.Any())
{
var listUserOrders = new List <OrderViewModel>();
foreach (var item in customer.CustomerOrders)
{
var order = new OrderViewModel
{
OrderId = item.OrderId,
Price = item.Price,
CreatedDate = item.CreatedDate
};
listUserOrders.Add(order);
}
returnCustomer.Orders = listUserOrders;
}
return(returnCustomer);
}
return(null);
}
catch (Exception ex)
{
Log.Error(ex);
return(null);
}
}
// GET V1/Customers
/// <summary>
/// Return list of all customers
/// </summary>
/// <returns></returns>
public IQueryable <CustomerViewModel> GetCustomers()
{
try
{
var orderAppDbContext = new OrdersAppDbContext();
var customers = from b in orderAppDbContext.Customer
select new CustomerViewModel()
{
CustomerId = b.CustomerId,
Email = b.Email,
Name = b.Name
};
return(customers);
}
catch (Exception ex)
{
Log.Error(ex);
return(null);
}
}
