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