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); } }