public ActionResult Add()
{
try
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
var model = new productViewModel()
{
productClass = proclassd.Get().ToList().OrderBy(a => a.sort)
};
return View(model);
}
}
catch (Exception ex)
{
NlogWrite.Log(ex, 6);
return RedirectToAction("login", "admin");
}
}
public ActionResult Index()
{
var model = new productViewModel()
{
product = pd.Get().ToList().Where(a => a.isdel == 0),
productClass = pcd.Get().ToList()
};
return View(model);
}
public ActionResult Detail(int m, int num, int kind)
{
var model = new productViewModel()
{
productClass = pcd.Get().ToList(),
product_detail = pd.Get().ToList().Where(a => a.isdel == 0),
product = pd.Get().ToList().Where(a => a.isdel == 0 && a.num == num),
productSize = psized.Get().ToList().Where(a => a.pid == num && a.isdel == 0),
productColor = pcolord.Get().ToList().Where(a => a.pid == num && a.isdel == 0),
m = m,
productnum = num,
kind = kind
};
return View(model);
}
public ActionResult Add()
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
var model = new productViewModel()
{
product = pd.Get().Where(a => a.isdel == 0).ToList()
};
return View(model);
}
}
public ActionResult Add()
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
var model = new productViewModel()
{
product_type = ptd.Get().ToList().OrderByDescending(a => a.num),
product = pd.Get().ToList().Where(a => a.isdel == 0),
productClass = pcd.Get().ToList().Where(a=>a.isdel == 0)
};
return View(model);
}
}
public ActionResult Search(string keyval = "")
{
ViewBag.keyval = keyval;
ViewBag.isSearch = false;
int page = (Request.QueryString["page"] != null) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
double pagesize = 6, count = 0;
int pagesort = (page - 1) * Convert.ToInt32(pagesize);
IEnumerable<product> productdata = null;
if (keyval != "")
{
Session["keywordforSearch"] = keyval;
}
else
{
if (Session["keywordforSearch"] == null)
{
Session["keywordforSearch"] = keyval;
}
}
if (Session["keywordforSearch"].ToString() != "")
{
count = Convert.ToDouble(productd.Get().ToList()
.Where(a => a.isdel == 0 && (
// a.pname.Contains(Session["keywordforSearch"].ToString())
//|| a.pname.Contains(Session["keywordforSearch"].ToString().ToLower())
//|| a.pname.Contains(Session["keywordforSearch"].ToString().ToUpper())
//|| a.word.Contains(Session["keywordforSearch"].ToString())
//|| a.word.Contains(Session["keywordforSearch"].ToString().ToLower())
//|| a.word.Contains(Session["keywordforSearch"].ToString().ToUpper())
a.Model.Contains(Session["keywordforSearch"].ToString())
|| a.Model.Contains(Session["keywordforSearch"].ToString().ToLower())
|| a.Model.Contains(Session["keywordforSearch"].ToString().ToUpper())
|| a.OENO.Contains(Session["keywordforSearch"].ToString())
|| a.OENO.Contains(Session["keywordforSearch"].ToString().ToLower())
|| a.OENO.Contains(Session["keywordforSearch"].ToString().ToUpper())
|| a.kindname.Contains(Session["keywordforSearch"].ToString())
|| a.kindname.Contains(Session["keywordforSearch"].ToString().ToLower())
|| a.kindname.Contains(Session["keywordforSearch"].ToString().ToUpper())
)).Count());
productdata = productd.Get().ToList().Where(
a => a.isdel == 0 && (
// a.pname.Contains(Session["keywordforSearch"].ToString())
//|| a.pname.Contains(Session["keywordforSearch"].ToString().ToLower())
//|| a.pname.Contains(Session["keywordforSearch"].ToString().ToUpper())
//|| a.word.Contains(Session["keywordforSearch"].ToString())
//|| a.word.Contains(Session["keywordforSearch"].ToString().ToLower())
//|| a.word.Contains(Session["keywordforSearch"].ToString().ToUpper())
a.Model.Contains(Session["keywordforSearch"].ToString())
|| a.Model.Contains(Session["keywordforSearch"].ToString().ToLower())
|| a.Model.Contains(Session["keywordforSearch"].ToString().ToUpper())
|| a.OENO.Contains(Session["keywordforSearch"].ToString())
|| a.OENO.Contains(Session["keywordforSearch"].ToString().ToLower())
|| a.OENO.Contains(Session["keywordforSearch"].ToString().ToUpper())
|| a.kindname.Contains(Session["keywordforSearch"].ToString())
|| a.kindname.Contains(Session["keywordforSearch"].ToString().ToLower())
|| a.kindname.Contains(Session["keywordforSearch"].ToString().ToUpper())
));
ViewBag.count = count;
ViewBag.isSearch = true;
}
else
{
count = Convert.ToDouble(productd.Get().ToList().Where(a => a.isdel == 0).Count());
productdata = productd.Get().ToList().Where(a => a.isdel == 0);
ViewBag.count = count;
ViewBag.isSearch = false;
}
var model = new productViewModel()
{
product = productdata.OrderBy(a => a.sort).Skip(pagesort).Take(Convert.ToInt32(pagesize)),
productClass = proclassd.Get().ToList(),
page = page,
pages = Convert.ToInt32(Math.Ceiling(count / pagesize))
};
return View(model);
}
public ActionResult inquiry()
{
var model = new productViewModel()
{
product = productd.Get().ToList().Where(a => a.isdel == 0).OrderBy(a => a.sort),
productClass = proclassd.Get().ToList(),
contact = cond.Get().ToList()
};
return View(model);
}
public ActionResult Detail(int num, int kind)
{
//加入最近瀏覽
if (Request.Cookies["tracking_" + num.ToString()] != null)
{
}
else
{
HttpCookie cookie = new HttpCookie("tracking_" + num.ToString());
cookie.Values.Add("num", num.ToString());
//cookie.Values.Add("wdate", DateTime.Now.ToShortDateString());
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
}
var model = new productViewModel()
{
allproduct = pd.Get().ToList().Where(a => a.isdel == 0),
//product_type = ptd.Get().ToList().Where(a => a.isdel == 0 && a.pid == kind),
//product_type_item = ptid.Get().ToList().Where(a => a.isdel == 0),
product = pd.Get().ToList().Where(a => a.num == num && a.isdel == 0).OrderBy(a => a.sort),
productClass = pcd.Get().ToList().Where(a => a.isdel == 0)
};
return View(model);
}
public ActionResult Edit(int num)
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
var model = new productViewModel()
{
product_type = ptd.Get().ToList().Where(a => a.num == num),
product = pd.Get().ToList().Where(a => a.isdel == 0),
productClass = pcd.Get().ToList().Where(a=>a.isdel == 0),
product_type_item = ptid.Get().ToList().Where(a => a.isdel == 0 && a.ptid == num)
};
return View(model);
}
}
public ActionResult Read(int page = 1, string find1 = "")
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
ViewBag.searchResult = 0;
ViewBag.search = 0;
ViewBag.gowhere = Url.Action("Read", "adminProduct");
//if (find1 != "")
//{
// ViewBag.searchResult = 1;
// ViewBag.searchText = find1;
//}
var currentpage = page < 1 ? 1 : page;
var pagesize = 10;
var pro = ptd.Get().ToList().Where(a => a.isdel == 0);
var model = new productViewModel()
{
product_type_pagelist = pro.ToPagedList(currentpage, pagesize),
product = pd.Get().ToList().Where(a => a.isdel == 0),
productClass = pcd.Get().ToList().Where(a => a.isdel == 0)
//productClass = proclassd.Get().ToList()
};
return View(model);
}
}
public ActionResult pro_info(int num)
{
var model = new productViewModel()
{
allproduct = pd.Get().ToList().Where(a => a.isdel == 0),
product = pd.Get().ToList().Where(a => a.isdel == 0).OrderBy(a => a.sort),
productClass = pcd.Get().ToList().Where(a => a.isdel == 0 && a.num == num).OrderBy(a => a.sort)
};
return View(model);
}
public ActionResult list(int? kind)
{
productViewModel model = null;
int page = (Request.QueryString["page"] != null) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
double pagesize = 900, count = 0;
int pagesort = (page - 1) * Convert.ToInt32(pagesize);
if (kind != null)
{
count = Convert.ToDouble(pd.Get().ToList().Where(a => a.kind == kind && a.isdel == 0).Count());
model = new productViewModel()
{
product = pd.Get().ToList().Where(a => a.kind == kind && a.isdel == 0).OrderBy(a => a.sort).Skip(pagesort).Take(Convert.ToInt32(pagesize)),
productClass = pcd.Get().ToList().OrderBy(a => a.sort),
page = page,
pages = Convert.ToInt32(Math.Ceiling(count / pagesize))
};
}
else
{
count = Convert.ToDouble(pd.Get().Where(a => a.isdel == 0).ToList().Count());
model = new productViewModel()
{
product = pd.Get().ToList().Where(a => a.isdel == 0).OrderBy(a => a.sort).Skip(pagesort).Take(Convert.ToInt32(pagesize)),
productClass = pcd.Get().ToList().OrderBy(a => a.sort),
page = page,
pages = Convert.ToInt32(Math.Ceiling(count / pagesize))
};
}
return View(model);
}
public ActionResult Index(int? kind)
{
var model = new productViewModel()
{
product = pd.Get().ToList().Where(a => a.isdel == 0),
productClass = pcd.Get().ToList().Where(a => a.isdel == 0).OrderBy(a => a.sort),
productHot = phd.Get().ToList().Where(a => a.num == 1 && a.pid != 0)
};
return View(model);
}
public ActionResult list(int m, int? kind, int? kind2)
{
ViewBag.kind = kind;
ViewBag.m = m;
int page = (Request.QueryString["page"] != null) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
double pagesize = 6, count = 0;
int pagesort = (page - 1) * Convert.ToInt32(pagesize);
IEnumerable<product> data = null;
if (kind != null && kind2 == null)
{
count = Convert.ToDouble(pd.Get().ToList().Where(a => a.isdel == 0 && a.kind == kind).Count());
data = pd.Get().ToList().Where(a => a.isdel == 0 && a.kind == kind).OrderBy(a => a.sort).ThenByDescending(a => a.wdate);
}
else if (kind2 != null)
{
count = Convert.ToDouble(pd.Get().ToList().Where(a => a.isdel == 0 && a.kind2 == kind2).Count());
data = pd.Get().ToList().Where(a => a.isdel == 0 && a.kind2 == kind2).OrderBy(a => a.sort).ThenByDescending(a => a.wdate);
}
var model = new productViewModel()
{
productClass = pcd.Get().ToList(),
product_detail = pd.Get().ToList().Where(a => a.isdel == 0).OrderBy(a => a.sort).ThenByDescending(a => a.wdate),
product = data.OrderBy(a => a.sort).ThenByDescending(a => a.wdate).Skip(pagesort).Take(Convert.ToInt32(pagesize)),
page = page,
pages = Convert.ToInt32(Math.Ceiling(count / pagesize)),
m = m
};
return View(model);
}
public ActionResult Edit(int num)
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
var model = new productViewModel()
{
productSize = psd.Get().ToList().Where(a => a.num == num),
product = pd.Get().ToList()
};
return View(model);
}
}
public ActionResult Read(int page = 1, string find1 = "")
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
ViewBag.searchResult = 0;
ViewBag.search = 1;
ViewBag.gowhere = Url.Action("Read", "adminProductSize");
ViewBag.searchSession = false;
var currentpage = page < 1 ? 1 : page;
var pagesize = 10;
if (find1 != "")
{
//ViewBag.searchResult = 1;
//ViewBag.searchText = find1;
Session["SizeSearch"] = find1;
}
else
{
if (Session["SizeSearch"] == null)
{
Session["SizeSearch"] = find1;
}
}
if (Session["SizeSearch"].ToString() != "")
{
ViewBag.searchSession = true;
}
else
{
ViewBag.searchSession = false;
}
var pro = psd.Get().ToList().Where(a => a.isdel == 0 && (a.pname.Contains(Session["SizeSearch"].ToString()) || a.size.Contains(Session["SizeSearch"].ToString()))).OrderBy(a => a.sort);
var model = new productViewModel()
{
productSize_pagelist = pro.ToPagedList(currentpage, pagesize)
};
return View(model);
}
}
public ActionResult Detail(int num)
{
ViewBag.num = num;
var pro = productd.Get().ToList().Where(a => a.isdel == 0 && a.num == num).SingleOrDefault();
ViewBag.kind = pro.kind;
var model = new productViewModel()
{
product = productd.Get().ToList().Where(a => a.isdel == 0),
productClass = proclassd.Get().ToList(),
product_single = productd.Get().ToList().Where(a => a.isdel == 0 && a.num == num)
};
return View(model);
}
public ActionResult Read()
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
var model = new productViewModel()
{
productClass = proclassd.Get().ToList().OrderBy(a => a.sort)
};
return View(model);
}
}
public ActionResult Index()
{
int page = (Request.QueryString["page"] != null) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
double pagesize = 6, count = 0;
int pagesort = (page - 1) * Convert.ToInt32(pagesize);
count = Convert.ToDouble(productd.Get().ToList().Where(a => a.isdel == 0).Count());
var model = new productViewModel()
{
product = productd.Get().ToList().Where(a => a.isdel == 0).OrderBy(a => a.sort).Skip(pagesort).Take(Convert.ToInt32(pagesize)),
productClass = proclassd.Get().ToList(),
page = page,
pages = Convert.ToInt32(Math.Ceiling(count / pagesize))
};
return View(model);
}
public ActionResult Read(int page = 1, string find1 = "")
{
try
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
ViewBag.searchResult = 0;
ViewBag.search = 1;
ViewBag.gowhere = Url.Action("Read", "adminProduct");
if (find1 != "")
{
ViewBag.searchResult = 1;
ViewBag.searchText = find1;
}
var currentpage = page < 1 ? 1 : page;
var pagesize = 10;
var pro = productd.Get().ToList().Where(a => a.isdel == 0 && (a.pname.Contains(find1))).OrderBy(a => a.sort);
var model = new productViewModel()
{
product_pagelist = pro.ToPagedList(currentpage, pagesize),
productClass = proclassd.Get().ToList()
};
return View(model);
}
}
catch (Exception ex)
{
NlogWrite.Log(ex, 6);
return RedirectToAction("login", "admin");
}
}
public ActionResult Read(int page = 1, string find1 = "")
{
if (!CheckMemberlogin)
{
return RedirectToAction("login", "admin");
}
else
{
leftModel();
ViewBag.searchResult = 0;
ViewBag.search = 1;
ViewBag.gowhere = Url.Action("Read", "adminProductSize");
if (find1 != "")
{
ViewBag.searchResult = 1;
ViewBag.searchText = find1;
}
var currentpage = page < 1 ? 1 : page;
var pagesize = 10;
var pro = pcd.Get().ToList().Where(a => a.isdel == 0 && (a.pname.Contains(find1) || a.color.Contains(find1))).OrderBy(a => a.sort);
var model = new productViewModel()
{
productColor_pagelist = pro.ToPagedList(currentpage, pagesize)
};
return View(model);
}
}