//***********Hash discount product
public List <Product> GetHasDiscountProduct()
{
using (var context = new FAContext())
{
return(context.Products.Where(x => x.HasDiscount && x.ImageUrl != null).ToList());
}
}
public Config GetConfig(string Key)
{
using (var context = new FAContext())
{
return(context.Configurations.Find(Key));
}
}
public List <Category> GetCategories()
{
using (var context = new FAContext())
{
return(context.Categories.Include(r => r.Products).ToList());
}
}
public List <Product> GetProductsByCategory(int categoryID, int pageSize)
{
using (var context = new FAContext())
{
return(context.Products.Where(x => x.Category.ID == categoryID).OrderByDescending(x => x.ID).Take(pageSize).Include(x => x.Category).ToList());
}
}
public List <Product> GetLatestProducts(int numberOfProducts)
{
using (var context = new FAContext())
{
return(context.Products.OrderByDescending(x => x.ID).Take(numberOfProducts).Include(x => x.Category).ToList());
}
}
public List <Product> GetProducts(int pageNo, int pageSize)
{
using (var context = new FAContext())
{
return(context.Products.OrderByDescending(x => x.ID).Skip((pageNo - 1) * pageSize).Take(pageSize).Include(x => x.Category).ToList());
}
}
public Category GetCategory(int ID)
{
using (var context = new FAContext())
{
return(context.Categories.Find(ID));
}
}
public List <Product> GetProducts(List <int> IDs)
{
using (var context = new FAContext())
{
return(context.Products.Where(product => IDs.Contains(product.ID)).ToList());
}
}
//********************Get All category
public List <Category> GetAllCategories()
{
using (var context = new FAContext())
{
return(context.Categories.ToList());
}
}
public Product GetProduct(int ID)
{
using (var context = new FAContext())
{
return(context.Products.Where(x => x.ID == ID).Include(x => x.Category).FirstOrDefault());
}
}
public int GetMaximumPrice()
{
using (var context = new FAContext())
{
return((int)(context.Products.Max(x => x.Price)));
}
}
//********************Get category
public List <Category> GetCategories(string search, int pageNo, int pageSize = 3)
{
using (var context = new FAContext())
{
if (!string.IsNullOrEmpty(search))
{
return(context.Categories.Where(category => category.Name != null &&
category.Name.ToLower().Contains(search.ToLower()))
.OrderBy(x => x.ID)
.Skip((pageNo - 1) * pageSize)
.Take(pageSize)
.Include(x => x.Products)
.ToList());
}
else
{
return(context.Categories
.OrderBy(x => x.ID)
.Skip((pageNo - 1) * pageSize)
.Take(pageSize)
.Include(x => x.Products)
.ToList());
}
}
}
public Order GetOrderByID(int ID)
{
using (var context = new FAContext())
{
return(context.Orders.Where(x => x.ID == ID).Include(x => x.OrderItems).Include("orderItems.product").FirstOrDefault());
}
}
//********************Feature category
public List <Category> GetFeaturedCategories()
{
using (var context = new FAContext())
{
return(context.Categories.Where(x => x.IsFeatured && x.ImageUrl != null).ToList());
}
}
//********************Update Products
public void UpdateProduct(Product Product)
{
using (var context = new FAContext())
{
context.Entry(Product).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public int SaveOrder(Order order)
{
using (var context = new FAContext())
{
context.Orders.Add(order);
return(context.SaveChanges());
}
}
//********************Save category
public void SaveCategory(Category category)
{
using (var context = new FAContext())
{
context.Categories.Add(category);
context.SaveChanges();
}
}
//********************Update category
public void UpdateCategory(Category category)
{
using (var context = new FAContext())
{
context.Entry(category).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public List <Product> GetProducts(int pageNo)
{
//int pageSize = 5;
using (var context = new FAContext())
{
//return context.Products.OrderBy(x=>x.ID).Skip((pageNo-1) * pageSize).Take(pageSize).Include(x=>x.Category).ToList();
return(context.Products.Include(x => x.Category).ToList());
}
}
public int ShopPageSize()
{
using (var context = new FAContext())
{
var pageSizeConfig = context.Configurations.Find("ShopPageSize");
return(pageSizeConfig != null?int.Parse(pageSizeConfig.value) : 6);
}
}
//********************Save Products
public void SaveProduct(Product Product)
{
using (var context = new FAContext())
{
context.Entry(Product.Category).State = System.Data.Entity.EntityState.Unchanged;
context.Products.Add(Product);
context.SaveChanges();
}
}
public object UpdateOrderStatus(int ID, string status)
{
using (var context = new FAContext())
{
var order = context.Orders.Find(ID);
order.status = status;
context.Entry(order).State = EntityState.Modified;
return(context.SaveChanges() > 0);
}
}
//********************Delete Products
public void DeleteProduct(int ID)
{
using (var context = new FAContext())
{
var Product = context.Products.Find(ID);
context.Products.Remove(Product);
context.SaveChanges();
}
}
//********************Delete category*****
public void DeleteCategory(int ID)
{
using (var context = new FAContext())
{
var categoty = context.Categories.Where(x => x.ID == ID).Include(x => x.Products).FirstOrDefault();
context.Products.RemoveRange(categoty.Products);
context.Categories.Remove(categoty);
context.SaveChanges();
}
}
//********************Get category Count
public int GetCategoriesCount(string search)
{
using (var context = new FAContext())
{
if (!string.IsNullOrEmpty(search))
{
return(context.Categories.Where(category => category.Name != null && category.Name.ToLower().Contains(search.ToLower())).Count());
}
else
{
return(context.Categories.Count());
}
}
}
public int GetProductsCount(string search)
{
using (var context = new FAContext())
{
if (!string.IsNullOrEmpty(search))
{
return(context.Products.Where(product => product.Name != null &&
product.Name.ToLower().Contains(search.ToLower()))
.Count());
}
else
{
return(context.Products.Count());
}
}
}
public int SearchProductsCount(string searchTerm, int?minimumPrice, int?maximumPrice, int?categoryID, int?sortBy)
{
using (var context = new FAContext())
{
var products = context.Products.ToList();
if (categoryID.HasValue)
{
products = products.Where(x => x.Category.ID == categoryID.Value).ToList();
}
if (!string.IsNullOrEmpty(searchTerm))
{
products = products.Where(x => x.Name.ToLower().Contains(searchTerm.ToLower())).ToList();
}
if (minimumPrice.HasValue)
{
products = products.Where(x => x.Price >= minimumPrice.Value).ToList();
}
if (maximumPrice.HasValue)
{
products = products.Where(x => x.Price <= maximumPrice.Value).ToList();
}
if (sortBy.HasValue)
{
switch (sortBy.Value)
{
case 2:
products = products.OrderByDescending(x => x.ID).ToList();
break;
case 3:
products = products.OrderBy(x => x.Price).ToList();
break;
default:
products = products.OrderByDescending(x => x.Price).ToList();
break;
}
}
return(products.Count);
}
}
public List <Order> SearchOrders(string userID, string status, int pageNo, int pageSize)
{
using (var context = new FAContext())
{
var Orders = context.Orders.ToList();
if (!string.IsNullOrEmpty(userID))
{
Orders = Orders.Where(x => x.UserID.ToLower().Contains(userID.ToLower())).ToList();
}
if (!string.IsNullOrEmpty(status))
{
Orders = Orders.Where(x => x.status.ToLower().Contains(status.ToLower())).ToList();
}
return(Orders.Skip((pageNo - 1) * pageSize).Take(pageSize).ToList());
}
}
public int SearchOrdersCount(string userID, string status)
{
using (var context = new FAContext())
{
var Orders = context.Orders.ToList();
if (!string.IsNullOrEmpty(userID))
{
Orders = Orders.Where(x => x.UserID.ToLower().Contains(userID.ToLower())).ToList();
}
if (!string.IsNullOrEmpty(status))
{
Orders = Orders.Where(x => x.status.ToLower().Contains(status.ToLower())).ToList();
}
return(Orders.Count);
}
}
/// <summary>
/// Used internally by the derived viewer that may also set the modelprogram
/// </summary>
internal void SetStateMachine(FSM fa, StateProvider stateProvider, ModelProgram mp1, Set<Transition> groupingTransitions)
{
// Clear the node and transition tables and the cache
this.mp = mp1;
nodes.Clear();
transitions.Clear();
//reductCache.Clear();
this.faInfo = new FAInfo(this.stateViewer1.DefaultModelName, fa, stateProvider, mp1);
this.finiteAutomatonContext = new FAContext(fa, stateProvider, faInfo.ReductNames.Last, mp1);
this.finiteAutomatonContext.groupingTransitions = groupingTransitions;
//this.reductCache[this.faInfo.ReductNames.Last] = this.finiteAutomatonContext;
this.projectionButton.Text = " " + faInfo.ReductNames.Last.name.ToString();
this.projectionButton.ToolTipText = faInfo.ReductNames.Last.name.ToString();
if (faInfo.IsProduct)
{
this.projectionButton.Enabled = true;
EnableProjection();
}
else
{
this.projectionButton.Enabled = false;
}
graphChanged = true;
PerformLayout();
}
/// <summary>
/// Used internally by the derived viewer that may also set the modelprogram
/// </summary>
internal void SetStateMachine(FSM fa, StateProvider stateProvider, ModelProgram mp1, Set<Transition> groupingTransitions)
{
// Clear the node and transition tables and the cache
this.mp = mp1;
// nodes.Clear(); // not needed for mp2dot, I believe
// transitions.Clear(); // ditto
//reductCache.Clear();
//this.faInfo = new FAInfo(this.stateViewer1.DefaultModelName, fa, stateProvider, mp1);
this.faInfo = new FAInfo("Fsm", fa, stateProvider, mp1); // defined in StateView.cs
this.finiteAutomatonContext = new FAContext(fa, stateProvider, faInfo.ReductNames.Last, mp1);
this.finiteAutomatonContext.groupingTransitions = groupingTransitions;
//this.reductCache[this.faInfo.ReductNames.Last] = this.finiteAutomatonContext;
// removed code here
}
//Dictionary<ReductName, FAContext> reductCache = new Dictionary<ReductName, FAContext>();
private void ShowReduct(ReductName reductName)
{
FAContext faContext1;
//if (!reductCache.TryGetValue(reductName, out faContext1))
//{
Dictionary<Term, IState> reductStateMap;
Dictionary<Term, IState> stateMap = new Dictionary<Term, IState>();
foreach (Term t in faInfo.fa.States)
{
stateMap[t] = faInfo.stateProvider(t);
}
FSM fa = FSMBuilder.ProjectFromProduct(faInfo.fa, ProjectedActionSymbols(reductName.treePosition), reductName.treePosition, stateMap, out reductStateMap);
faContext1 = new FAContext(fa, delegate(Term n) { return reductStateMap[n]; }, reductName, ProjectedModelProgram(reductName.treePosition));//+++
//reductCache[reductName] = faContext1;
//}
finiteAutomatonContext = faContext1;
graphChanged = true;
this.selectedAglNode = null; //forget previous selected glee node
this.selectedNode = null; //forget previous selected corresponding node
PerformLayout();
}
