public Product SaveProduct(Product product)
{
KendoPOCEntities context = new KendoPOCEntities();
Product result = null;
product.StatusType = 1;
context.Entry<Product>(product).State = (product.Id == 0 ? EntityState.Added : EntityState.Modified);
if (context.Entry<Product>(product).State == EntityState.Added)
{
product.CreationUserId = "SuperUser";
product.CreationTs = DateTime.Now;
context.Product.Add(product);
}
else
{
product.LastChangeUserId = "SuperUser";
product.LastChangeTs = DateTime.Now;
}
int rowsAffected = context.SaveChanges();
if (rowsAffected != 0)
{
result = product;
}
return result;
}
public IEnumerable<Product> GetAllProducts()
{
KendoPOCEntities context = new KendoPOCEntities();
var productsList = context.Product.Include("Category").Include("UnitofMeasure");
//var productsList = context.Product;
return productsList.AsEnumerable();
}
public bool DeleteProduct(int id)
{
KendoPOCEntities context = new KendoPOCEntities();
var product = new Product() { Id = id };
context.Entry<Product>(product).State = EntityState.Deleted;
int rowsAffected = context.SaveChanges();
return (rowsAffected == 1);
}
public Product GetProductById(int id)
{
KendoPOCEntities context = new KendoPOCEntities();
var result = context.Product.FirstOrDefault(item => item.Id == id);
return result;
}
public IEnumerable<Category> GetAllCategory()
{
KendoPOCEntities context = new KendoPOCEntities();
return context.Category.AsEnumerable();
}
public IEnumerable<UnitofMeasure> GetAllunits()
{
KendoPOCEntities context = new KendoPOCEntities();
return context.UnitofMeasure.AsEnumerable();
}