public Products GetProduct(int id)
{
if (UsingSessiondB())
{
List <Products> Products = GetSessionProducts();
return(Products.Find(p => p.ProductID == id));
}
else
{
SanaAppWEBContext ctx = new SanaAppWEBContext();
return(ctx.Products.Find(id));
}
}
public List <Products> GetProducts()
{
HttpContext context = HttpContext.Current;
if (!UsingSessiondB())
{
SanaAppWEBContext ctx = new SanaAppWEBContext();
return(ctx.Products.ToList());
}
else
{
return(GetSessionProducts());
}
}
public Products DeleteProduct(int id)
{
HttpContext context = HttpContext.Current;
Products p = GetProduct(id);
if (!UsingSessiondB())
{
SanaAppWEBContext ctx = new SanaAppWEBContext();
ctx.Products.Attach(p);
ctx.Products.Remove(p);
ctx.SaveChanges();
return(p);
}
else
{
List <Products> Products = GetSessionProducts();
Products.Remove(p);
context.Session["Products"] = Products;
return(p);
}
}
public Products EditProduct(Products p)
{
HttpContext context = HttpContext.Current;
if (!UsingSessiondB())
{
SanaAppWEBContext ctx = new SanaAppWEBContext();
ctx.Entry(p).State = EntityState.Modified;
ctx.SaveChanges();
return(p);
}
else
{
List <Products> Products = GetSessionProducts();
var index = Products.FindIndex((prod => prod.ProductID == p.ProductID));
Products[index] = p;
context.Session["Products"] = Products;
SetSessionKey(p.ProductID.ToString());
return(p);
}
}
public Products SaveProduct(Products p)
{
HttpContext context = HttpContext.Current;
if (!UsingSessiondB())
{
SanaAppWEBContext ctx = new SanaAppWEBContext();
ctx.Products.Add(p);
ctx.SaveChanges();
return(p);
}
else
{
p.ProductID = NextSessionKey();
List <Products> Products = GetSessionProducts();
Products.Add(p);
context.Session["Products"] = Products;
SetSessionKey(p.ProductID.ToString());
return(p);
}
}
