public ActionResult SAreaDT3() { global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); var List2 = farmar.products.Select(x => x).ToList(); var List1 = List2.Select(x => new Serviceitem { productid = x.productid, productname = x.productname, unitprice = x.unitprice, unitstock = x.unitstock, //description = $"{x.description.Substring(0,15)}.....", picture = x.productid, category = x.category, user_email = x.user_email, EmailA = x.productid }).ToList <Serviceitem>(); foreach (var x in List1) { var i = List2.Where(o => o.productid == x.productid).SingleOrDefault(); if (i.description.Length < 16) { x.description = i.description; } else { x.description = $"{i.description.Substring(0, 15)}....."; } } return(Json(new { data = List1 }, JsonRequestBehavior.AllowGet)); }
public ActionResult OrderEditView(int id = 0) { if (id == 0) { return(View("Index")); } global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); Serviceorder user = farmar.orders.Where(o => o.order_id == id).Select(o => new Serviceorder { order_id = o.order_id, status = o.status, buy_id = o.buy_id, flag = true }).SingleOrDefault(); var T = farmar.order_detail.Where(o => o.order_id == id).ToList(); foreach (var x in T) { var produ = farmar.products.Where(o => o.productid == x.productid).SingleOrDefault(); if (produ.unitstock < x.quiantity) { user.flag = false; } } return(View(user)); }
public ActionResult Itemphoto(int id) { global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); var x = farmar.products.Find(id).picture; return(File(x, "image/jpeg")); }
public ActionResult SAreaDT4() { global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); var List2 = farmar.orders.Select(x => x).ToList(); var List1 = List2.Select(x => new Serviceordetail { order_id = x.order_id, buy_Name = x.buy_id, sell_id = x.sell_id, total_price = farmar.order_detail.Where(o => o.order_id == x.order_id).Select(p => p.total_price).Sum(), status = x.status, date = x.date, EmailA = x.order_id }).ToList <Serviceordetail>(); foreach (var x in List1) { var T = farmar.order_detail.Where(o => o.order_id == x.order_id).ToList(); foreach (var y in T) { x.detail += $"<tr><td>商品名稱:{y.productname}</td><td>數量:{y.quiantity}</td><td>金額:{y.total_price}</td></tr>"; } } return(Json(new { data = List1 }, JsonRequestBehavior.AllowGet)); }
public ActionResult ResetPsView(string id = "") { if (id == "") { return(View("Index")); } global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); AspNetUser user = farmar.AspNetUsers.Where(o => o.Id == id).SingleOrDefault(); return(View(user)); }
public ActionResult DeleteItemView(int id = 0) { if (id == 0) { return(View("Index")); } global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); product user = farmar.products.Where(o => o.productid == id).SingleOrDefault(); return(View(user)); }
public ActionResult SAreaDT2() { global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); var List2 = farmar.AspNetUsers.Select(x => x).ToList(); var List1 = List2.Select(x => new Serviceuser { Email = x.Email, FamName = x.FamName, PhoneNumber = x.PhoneNumber, UserIg = x.UserIg, EmailA = x.Id }).ToList <Serviceuser>(); return(Json(new { data = List1 }, JsonRequestBehavior.AllowGet)); }
//GET public ActionResult SAreaDT1() { global::farmarproject2.Models.farmarEntities1 farmar = new Models.farmarEntities1(); var List2 = farmar.ServiceLogins.Select(x => x).ToList(); var List1 = List2.Select(x => new ServiceLogin2 { userID = x.userID, State = x.State, Type = x.Type, LoginTime = x.LoginTime.ToString(), ContentA = x.ContentA }).ToList <ServiceLogin2>(); return(Json(new { data = List1 }, JsonRequestBehavior.AllowGet)); }