public int Create(ProductRequest productRequest)
{
try
{
using (var db = new ReadingIsGoodDbContext())
{
var product = new Product
{
Name = productRequest.Name,
Description = productRequest.Description,
Quantity = productRequest.Quantity,
CreatedAt = DateTime.Now
};
db.Products.Add(product);
db.SaveChanges();
return(product.ProductId);
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(0);
}
}
public async Task <Customer> Get(SignInRequest request)
{
await using (var db = new ReadingIsGoodDbContext())
{
var foundUser = db.Customers.FirstOrDefault(u => u.Email == request.Email);
return(foundUser ?? new Customer());
}
}
public List <Product> List()
{
try
{
using (var db = new ReadingIsGoodDbContext())
{
var products = db.Products.ToList();
if (products.Any())
{
return(products);
}
return(new List <Product>());
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(new List <Product>());
}
}
public bool Delete(ProductDeleteRequest productDeleteRequest)
{
try
{
using (var db = new ReadingIsGoodDbContext())
{
var product = db.Products.FirstOrDefault(i => i.ProductId == productDeleteRequest.Id);
if (product != null)
{
db.Products.Remove(product);
return(true);
}
return(false);
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public OrderItemRepository(ReadingIsGoodDbContext ctx)
{
_ctx = ctx;
}
public StockRepository(ReadingIsGoodDbContext ctx)
{
_ctx = ctx;
}
public CustomerRepository(ReadingIsGoodDbContext ctx)
{
_ctx = ctx;
}
public ProductRepository(ReadingIsGoodDbContext ctx)
{
_ctx = ctx;
}
