public ActionResult Compare() { var first = Convert.ToInt32(Request["First"]); var secound = Request["Secound"]; var name = Request["Name"]; var res1 = db.Products.AsQueryable(); var res = res1.Where(p => p.IsOnlyForMarketer == false).Where(p => p.Name.Contains(name)).OrderByDescending(p => p.Id); var data = new PagedItem <Product>(res, "/Products/Compare?Name=" + name + "&First=" + first, 6); ViewBag.Data = data; var element1 = db.Products.Include("Category").Where(p => p.Id == first).FirstOrDefault(); ViewBag.Product1 = element1; ViewBag.Product2 = null; if (secound != null && secound != "") { int id = Convert.ToInt32(secound); var element2 = db.Products.Where(p => p.Id == id).FirstOrDefault(); ViewBag.Product2 = element2; } else { var expect = db.Products.Include("Category").Where(p => p.Id == first); var list = db.Products.Where(p => p.Category.Id == element1.Category.Id).Except(expect).OrderByDescending(p => p.Id); var d = new PagedItem <Product>(list, "/Products/Compare?&First=" + first, 6); ViewBag.Data = d; } return(View()); }
public object Index() { var data = db.News.Select(p => new { p.Id, p.Title, p.Desc }).OrderByDescending(p => p.Id); var paged = new PagedItem <object>(data, "/api/News/Index"); return(paged); }
public object AjaxData() { int id = Convert.ToInt32(Request["Category_Id"]); var products = db.Products.Include("Category").Where(p => p.Status == true).Where(p => p.Category.Id == id); var name = Request["Name"]; if (name != null && name != "") { products = products.Where(p => p.Name.Contains(name)); } int flag = Convert.ToInt32(Request["changeCategory"]); if (flag == 0) { var tmp = Request["PriceFrom"]; if (tmp != null && tmp != "") { long from = Convert.ToInt64(Request["PriceFrom"]); products = products.Where(p => p.Price - p.Discount >= from); } tmp = Request["PriceTo"]; if (tmp != null && tmp != "") { long?to = Convert.ToInt64(Request["PriceTo"]); products = products.Where(p => p.Price - p.Discount <= to); } } var res = products.OrderByDescending(p => p.Id); long MaxPrice = 0; long MinPrice = 0; if (db.Products.Where(p => p.Category.Id == id).Count() > 0) { MaxPrice = db.Products.Where(p => p.Category.Id == id).Max(p => p.Price); MinPrice = db.Products.Where(p => p.Category.Id == id).Min(p => p.Price); } JavaScriptSerializer js = new JavaScriptSerializer(); var paged = new PagedItem <Product>(res, "", 16); long pf = -1; long pt = -1; if ((Request["PriceFrom"]) != null || (Request["PriceFrom"]) != "") { pf = Convert.ToInt64(Request["PriceFrom"]); } if ((Request["PriceTo"]) != null || (Request["PriceTo"]) != "") { pf = Convert.ToInt64(Request["PriceFrom"]); } var obj = new { Links = paged.GetAjaxLinks(id), Data = paged, MaxPrice = MaxPrice, MinPrice = MinPrice, PriceFrom = pf, PriceTo = pt }; var result = js.Serialize(obj); return(result); }
// GET: News public ActionResult Index() { var data = db.News.OrderByDescending(p => p.Id); var paged = new PagedItem <object>(data, "/ShowNews/Index", 10); ViewBag.Data = paged; return(View()); }
public object ShowComment() { var Product_Id = Convert.ToInt32(HttpContext.Current.Request.Form["Product_Id"]); var Comments = db.Comments.Include("User").Where(p => p.Product.Id == Product_Id).Where(p => p.Product.IsOnlyForMarketer == false).Select(p => new { p.Date, p.Dislike, p.Id, p.Like, p.Status, p.Text, p.Title, p.User.Fullname }).OrderByDescending(p => p.Id); var data = new PagedItem <object>(Comments, ""); return(data); }
public object Receive() { long Timestamp = Convert.ToInt64(HttpContext.Current.Request.Form["Timestamp"]); var data = db.MarketerChats.Where(p => p.Timestamp > Timestamp).Select(p => new{ p.Id, p.Text, User = p.User.Name + " " + p.User.LastName }).OrderBy(p => p.Id); var paged = new PagedItem <object>(data, "/api/MarketerChat/Receive"); return(new { Data = paged, Message = 0 }); }
// GET: Admin/WholeSaler public ActionResult Index() { var data = db.WholeSalers.OrderByDescending(p => p.Id).OrderBy(p => p.IsShow); var paginate = new PagedItem <WholeSaler>(data, "/Admin/WholeSaler/Index"); ViewBag.Data = paginate; return(View()); }
public ActionResult Create() { var data = db.Emails.OrderByDescending(p => p.Id); var paginate = new PagedItem <Email>(data, "/Admin/Email/Create"); ViewBag.Data = paginate; return(View()); }
// GET: Admin/Payments public ActionResult Index() { var url = "/admin/Payments/index"; var data = db.Payments.Include("User").Include("Factor").OrderByDescending(p => p.Id); var paged = new PagedItem <Payment>(data, url); ViewBag.Data = paged; return(View()); }
public ActionResult Search() { string name = Request["Name"]; var res = db.Products.Where(p => p.IsOnlyForMarketer == false).Where(p => p.Name.Contains(name)).OrderByDescending(p => p.Id); var data = new PagedItem <Product>(res, "/Products/Search?Name=" + name, 16); ViewBag.Data = data; return(View("Search")); }
public object index() { var msg = new MarketerChat(); var token = System.Web.HttpContext.Current.Request.Form["Api_Token"]; var user = db.MarketerUsers.Where(p => p.Api_Token == token).FirstOrDefault(); var data = db.Commission.Include("MarketerFactor").Where(p => p.MarketerUser.Id == user.Id).Select(p => new { p.Id, p.Date, p.Detail, p.Formula, p.Money }).OrderByDescending(p => p.Id); var paged = new PagedItem <object>(data, ""); return(paged); }
public ActionResult History() { var email = User.Identity.Name; int id = db.Users.Where(p => p.Email == email).FirstOrDefault().Id; var data = db.Factors.Where(p => p.Status == true).Where(p => p.User.Id == id).OrderByDescending(p => p.Id); var d = new PagedItem <object>(data, "/Factor/History"); ViewBag.Data = d; return(View()); }
// GET: Admin/Marketer public ActionResult Index() { var link = "/Admin/MarketerFactors/Index"; var buyer = Request["Buyer"]; var flag = Request["IsAdminShow"]; var marketer = Request["Marketer"]; var data = db.MarketerFactor.Include("MarketerUser").Where(p => p.Status == 0 || p.Status == 2); if (buyer != null) { data = data.Where(p => p.Buyer.Contains(buyer)); link += "?Buyer=" + buyer; } if (marketer != null) { data = data.Where(p => p.MarketerUser.Name.Contains(marketer) || p.MarketerUser.LastName.Contains(marketer)); link += "?Marketer=" + marketer; } if (flag != null) { if (flag == "1") { data = data.Where(p => p.IsAdminShow == true); if (link.Contains("?")) { link = link + "&IsAdminShow=" + 1; } else { link = link + "?IsAdminShow=" + 1; } } else if (flag == "2") { data = data.Where(p => p.IsAdminShow == false); if (link.Contains("?")) { link = link + "&IsAdminShow=" + 2; } else { link = link + "?IsAdminShow=" + 2; } } } var order = data.OrderBy(p => p.IsAdminShow).OrderByDescending(p => p.Id); var paged = new PagedItem <object>(order, link); ViewBag.Data = paged; return(View()); }
public ActionResult Detail(int id) { var data = db.Factors.Include("FactorItems.Product.Category").Include("User").Where(p => p.Id == id).FirstOrDefault(); data.IsAdminShow = true; db.SaveChanges(); ViewBag.Data = data; var d = db.Payments.Where(p => p.Factor.Id == id).OrderByDescending(p => p.Id); var paged = new PagedItem <Payment>(d, "/admin/Factors/Detail/" + id, 20); ViewBag.Payments = paged; return(View()); }
public object GetPrizes() { var token = System.Web.HttpContext.Current.Request.QueryString["Api_Token"]; var usr = db.MarketerUsers.Where(p => p.Api_Token == token).FirstOrDefault(); if (usr == null) { return(new { Message = "UnAuthorized" }); } var data = db.MarketerPrizes.OrderByDescending(p => p.Id); var paged = new PagedItem <MarketerPrize>(data, "/api/MarketerNews/GetPrizes"); return(new { Data = paged, Message = 0 }); }
public ActionResult Index(Category category, int?parent_id) { var categories = db.Categories.Where(x => x.Parent.Id == parent_id).OrderByDescending(x => x.Id); if (parent_id != null) { ViewBag.CategoryTitle = db.Categories.Find(parent_id).Name; } var url = parent_id != null ? "/Admin/Category/Index?parent_id=" + parent_id : "/Admin/Category/Index?parent_id=null"; var result = new PagedItem <Category>(categories, url); ViewBag.Data = result; ViewBag.Parent_Id = parent_id; return(View()); }
// GET: Admin/User public ActionResult Index() { var url = "/Admin/Users/Index?"; var role = db.Roles.Where(n => n.RoleNameEn == "Member").FirstOrDefault(); string name = Request["Name"]; string mobile = Request["Mobile"]; var query = db.Users.Where(p => p.Role.Id == role.Id); if (Request["Name"] != null && Request["Name"] != "") { query = query.Where(p => p.Fullname.Contains(name)); if (url.Contains("?")) { url = url + "&Name=" + name; } else { url = url + "?Name=" + name; } } if (Request["Mobile"] != null && Request["Mobile"] != "") { query = query.Where(p => p.Mobile.Contains(mobile)); if (url.Contains("?")) { url = url + "&Mobile=" + mobile; } else { url = url + "?Mobile=" + mobile; } } var ordered = query.OrderByDescending(p => p.Id); var paginated = new PagedItem <User>(ordered, url); ViewBag.Data = paginated; return(View()); }
// GET: Admin/User public ActionResult Index() { var url = "/Admin/MarketerUser/Index?"; string name = Request["LastName"]; string mobile = Request["Mobile"]; var query = db.MarketerUsers.AsQueryable(); if (Request["LastName"] != null && Request["LastName"] != "") { query = query.Where(p => p.LastName.Contains(name)); if (url.Contains("?")) { url = url + "&LastName=" + name; } else { url = url + "?LastName=" + name; } } if (Request["Mobile"] != null && Request["Mobile"] != "") { query = query.Where(p => p.Mobile.Contains(mobile)); if (url.Contains("?")) { url = url + "&Mobile=" + mobile; } else { url = url + "?Mobile=" + mobile; } } var ordered = query.OrderByDescending(p => p.Id); var paginated = new PagedItem <MarketerUser>(ordered, url); ViewBag.Data = paginated; return(View()); }
// GET: Admin/Commision public ActionResult Index() { var link = "/Admin/Commision/Index"; var buyer = Request["Buyer"]; var marketer = Request["Marketer"]; var data = db.Commission.Include("MarketerUser").Include("MarketerFactor").AsQueryable(); if (buyer != null) { data = data.Where(p => p.MarketerFactor.Buyer.Contains(buyer)); link += "?Buyer=" + buyer; } if (marketer != null) { data = data.Where(p => p.MarketerUser.Name.Contains(marketer) || p.MarketerUser.LastName.Contains(marketer)); link += "?Marketer=" + marketer; } var commision = data.OrderByDescending(p => p.Id); var paged = new PagedItem <object>(commision, link); ViewBag.Data = paged; return(View()); }
public override void ToolStripItems_Clicked(object sender, ToolStripItemClickedEventArgs e) { switch (e.ClickedItem.ToString()) { case "Add": btnSave.Enabled = true; break; case "Edit": btnSave.Enabled = true; break; case "Next": { CurrentItem = new PagedItem <T>(QueryableItems, CurrentItemIndex + 1); BindValues(CurrentItem.Entity); SetNavigationControls(); break; } case "Previous": { CurrentItem = new PagedItem <T>(QueryableItems, CurrentItemIndex - 1); BindValues(CurrentItem.Entity); SetNavigationControls(); break; } case "First": { CurrentItem = new PagedItem <T>(QueryableItems, 1); BindValues(CurrentItem.Entity); SetNavigationControls(); break; } case "Last": { CurrentItem = new PagedItem <T>(QueryableItems, CurrentItem.TotalRecords); BindValues(CurrentItem.Entity); SetNavigationControls(); break; } case "Refresh": { OnActivated(null); break; } case "Search": { break; } default: btnSave.Enabled = false; break; } base.ToolStripItems_Clicked(sender, e); }
public override void ToolStripItems_Clicked(object sender, ToolStripItemClickedEventArgs e) { switch (e.ClickedItem.ToString()) { case "Add": btnSave.Enabled = true; break; case "Edit": btnSave.Enabled = true; break; case "Next": { CurrentItem = new PagedItem <T>(QueryableItems, CurrentItemIndex + 1); BindValues(CurrentItem.Entity); if (!CurrentItem.HasNextRecord) { MDIForm.toolStrip.Items["nextToolStripButton"].Enabled = false; } break; } case "Previous": { CurrentItem = new PagedItem <T>(QueryableItems, CurrentItemIndex - 1); BindValues(CurrentItem.Entity); if (!CurrentItem.HasPreviousRecord) { MDIForm.toolStrip.Items["previousToolStripButton"].Enabled = false; } break; } case "First": { CurrentItem = new PagedItem <T>(QueryableItems, 1); BindValues(CurrentItem.Entity); if (!CurrentItem.HasPreviousRecord) { MDIForm.toolStrip.Items["previousToolStripButton"].Enabled = false; } break; } case "Last": { CurrentItem = new PagedItem <T>(QueryableItems, CurrentItem.TotalRecords); BindValues(CurrentItem.Entity); if (!CurrentItem.HasNextRecord) { MDIForm.toolStrip.Items["nextToolStripButton"].Enabled = false; } break; } case "Refresh": { btnSave.Enabled = false; OnActivated(null); break; } case "Search": { break; } default: btnSave.Enabled = false; break; } MDIAction(); base.ToolStripItems_Clicked(sender, e); }
public object GetProducts() { long MaxPrice = 0; long MinPrice = 0; var data = db.Products.Include("Category").Where(p => p.Status == true).AsQueryable(); if (HttpContext.Current.Request.Form.AllKeys.Contains("status")) { bool status = Convert.ToBoolean(HttpContext.Current.Request.Form["status"]); if (status) { data = data.Where(p => p.Qty > 0); } else { data = data.Where(p => p.Qty == 0); } } if (HttpContext.Current.Request.Form.AllKeys.Contains("name")) { string name = HttpContext.Current.Request.Form["name"]; data = data.Where(p => p.Name.Contains(name)); } if (HttpContext.Current.Request.Form.AllKeys.Contains("minprice")) { int min = Convert.ToInt32(HttpContext.Current.Request.Form["minprice"]); data = data.Where(p => p.Price >= min); } if (HttpContext.Current.Request.Form.AllKeys.Contains("maxprice")) { int max = Convert.ToInt32(HttpContext.Current.Request.Form["maxprice"]); data = data.Where(p => p.Price <= max); } if (HttpContext.Current.Request.Form.AllKeys.Contains("category_id")) { List <int> list = new List <int>(); int temp = Convert.ToInt32(HttpContext.Current.Request.Form["category_id"]); list.Add(temp); var main = db.Categories.Where(p => p.Parent.Id == temp).ToList(); for (int i = 0; i < main.Count; i++) { var id = main[i].Id; list.AddRange(db.Categories.Where(p => p.Parent.Id == id).Select(p => p.Id).ToList()); } data = data.Where(p => list.Contains(p.Category.Id)); MinPrice = db.Products.Where(p => list.Contains(p.Category.Id)).Min(p => p.Price); MaxPrice = db.Products.Where(p => list.Contains(p.Category.Id)).Max(p => p.Price); } else { MinPrice = db.Products.Min(p => p.Price); MaxPrice = db.Products.Max(p => p.Price); } var res = data.OrderByDescending(p => p.Id); var Result = new PagedItem <Product>(res, ""); return(new { MinPrice = MinPrice, MaxPrice = MaxPrice, Result }); }