public IHttpActionResult Get()
{
IList <Sale> sales = null;
using (var ctx = new EmployeeDBEntities_Sale())
{
sales = ctx.Sales.ToList();
}
using (var ctxEmp = new EmployeeDBEntities())
{
foreach (var sale in sales)
{
sale.EmployeeName = ctxEmp.Employees.FirstOrDefault(e => e.ID == sale.EmployeeId)?.FirstName + " " +
ctxEmp.Employees.FirstOrDefault(e => e.ID == sale.EmployeeId)?.LastName;
}
}
using (var ctxProd = new EmployeeDBEntities_Product())
{
foreach (var sale in sales)
{
sale.ProductName = ctxProd.Products.FirstOrDefault(p => p.ProductId == sale.ProductId)?.Name;
}
}
if (sales.Count == 0)
{
return(NotFound());
}
return(Ok(sales));
}
private decimal GetProductPriceByProductId(int id)
{
using (var ctx = new EmployeeDBEntities_Product())
{
return(ctx.Products.FirstOrDefault(p => p.ProductId == id).Price);
}
}
public Product Get(int id)
{
using (var ctx = new EmployeeDBEntities_Product())
{
return(ctx.Products.FirstOrDefault(p => p.ProductId == id));
}
}
public IHttpActionResult Put(Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest("The data you entered is not valid"));
}
using (var ctx = new EmployeeDBEntities_Product())
{
var existingProduct = ctx.Products.FirstOrDefault(p => p.ProductId == product.ProductId);
if (existingProduct != null)
{
existingProduct.Name = product.Name;
existingProduct.Description = product.Description;
existingProduct.Price = product.Price;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public ActionResult Edit(int id)
{
Sale sale = new Sale();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("https://localhost:44350/api/");
var responseTask = client.GetAsync("sale/get/" + id);
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <Sale>();
readTask.Wait();
sale = readTask.Result;
}
}
using (var prodCtx = new EmployeeDBEntities_Product())
{
sale.ProductCollection = prodCtx.Products.ToList <Product>();
}
using (var empCtx = new EmployeeDBEntities())
{
sale.EmployeeCollection = empCtx.Employees.ToList <Employee>();
}
return(View(sale));
}
public IHttpActionResult Get()
{
IList <Product> products = null;
using (var ctx = new EmployeeDBEntities_Product())
{
products = ctx.Products.ToList();
}
if (products.Count == 0)
{
return(NotFound());
}
return(Ok(products));
}
public ActionResult Create()
{
Sale saleModel = new Sale();
using (var prodCtx = new EmployeeDBEntities_Product())
{
saleModel.ProductCollection = prodCtx.Products.ToList <Product>();
}
using (var empCtx = new EmployeeDBEntities())
{
saleModel.EmployeeCollection = empCtx.Employees.ToList <Employee>();
}
return(View(saleModel));
}
public IHttpActionResult Delete(int id)
{
if (id < 0)
{
return(BadRequest("Not a valid Product Id"));
}
using (var ctx = new EmployeeDBEntities_Product())
{
var product = ctx.Products.FirstOrDefault(p => p.ProductId == id);
ctx.Entry(product).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewProduct(Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new EmployeeDBEntities_Product())
{
ctx.Products.Add(new Product()
{
Name = product.Name,
Description = product.Description,
Price = product.Price
});
try
{
ctx.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"",
ve.PropertyName,
eve.Entry.CurrentValues.GetValue <object>(ve.PropertyName),
ve.ErrorMessage);
}
}
throw;
}
}
return(Ok());
}
