public void Delete(int id)
{
using (var context = new ArkanisDBContext())
{
var catgFound = context.Category.Find(id);
context.Category.Remove(catgFound);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new ArkanisDBContext())
{
var prodFound = context.Product.Find(id);
context.Product.Remove(prodFound);
context.SaveChanges();
}
}
public CategoryEntity Get(string name)
{
CategoryEntity response = null;
using (var context = new ArkanisDBContext())
{
var catgFound = context.Category
.Where(p => p.name.Equals(name))
.FirstOrDefault();
if (catgFound != null)
{
response = catgFound.ConvertToEntity();
}
}
return(response);
}
public ProductEntity Get(string code, string name)
{
ProductEntity response = null;
using (var context = new ArkanisDBContext())
{
var prodFound = context.Product
.Where(p => p.code == code && p.name == name)
.FirstOrDefault();
if (prodFound != null)
{
response = prodFound.ConvertToEntity();
}
}
return(response);
}
public int Create(CategoryEntity model)
{
using (var context = new ArkanisDBContext())
{
var catg = new Category()
{
name = model.name,
description = model.description,
createdBy = model.createdBy,
createdOn = model.createdOn,
status = model.status
};
context.Category.Add(catg);
context.SaveChanges();
return(catg.id);
}
}
public IEnumerable <ProductEntity> Search(string name)
{
var result = new List <ProductEntity>();
using (var context = new ArkanisDBContext())
{
var products = context.Product.Include("categories")
.Where(p => p.name.Equals(name)).ToList();
foreach (var item in products)
{
var prod = item.ConvertToEntity();
if (item.categories != null && item.categories.Count() > 0)
{
prod.categories = item.categories.Select(c => c.ConvertToEntity()).ToList();
}
result.Add(prod);
}
}
return(result);
}
public int Create(ProductEntity model)
{
using (var context = new ArkanisDBContext())
{
var prod = new Product();
prod.code = model.code;
prod.name = model.title;
prod.description = model.description;
prod.unitPrice = model.unitPrice;
prod.unitsInStock = model.unitsInStock;
prod.unitsOrdered = model.unitsOrdered;
prod.status = model.status;
prod.discount = model.discount;
prod.createdBy = model.createdBy;
prod.createdOn = model.createdOn;
context.Product.Add(prod);
context.SaveChanges();
return(prod.id);
}
}
