private static string CreateNewOrderNo(cvmOrders model) { string str_order_no = ""; string str_guid = Guid.NewGuid().ToString().Substring(0, 25).ToUpper(); using (goshoppingEntities db = new goshoppingEntities()) { Orders orders = new Orders(); orders.order_closed = 0; orders.order_validate = 0; orders.order_no = ""; orders.order_date = DateTime.Now; orders.user_no = UserAccount.UserNo; orders.order_status = "ON"; orders.order_guid = str_guid; orders.payment_no = model.payment_no; orders.shipping_no = model.shipping_no; orders.receive_name = model.receive_name; orders.receive_email = model.receive_email; orders.receive_address = model.receive_address; orders.remark = ""; db.Orders.Add(orders); db.SaveChanges(); var neword = db.Orders.Where(m => m.order_guid == str_guid).FirstOrDefault(); if (neword != null) { str_order_no = neword.rowid.ToString().PadLeft(8, '0'); neword.order_no = str_order_no; db.SaveChanges(); } } return(str_order_no); }
private static int GetCartTotals() { int?int_totals = 0; using (goshoppingEntities db = new goshoppingEntities()) { if (UserAccount.IsLogin) { var data1 = db.Carts .Where(m => m.user_no == UserAccount.UserNo) .ToList(); if (data1 != null) { int_totals = data1.Sum(m => m.amount); } } else { var data2 = db.Carts .Where(m => m.lot_no == LotNo) .ToList(); if (data2 != null) { int_totals = data2.Sum(m => m.amount); } } } if (int_totals == null) { int_totals = 0; } return(int_totals.GetValueOrDefault()); }
public ActionResult Edit(Status models) { bool status = false; if (ModelState.IsValid) { using (goshoppingEntities db = new goshoppingEntities()) { if (models.rowid > 0) { //Edit var Status = db.Status.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (Status != null) { Status.mno = models.mno; Status.mname = models.mname; Status.remark = models.remark; } } else { //Save db.Status.Add(models); } db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
/// <summary> /// 消費者付款 /// </summary> public static void CartPayment(cvmOrders model) { OrderNo = CreateNewOrderNo(model); using (goshoppingEntities db = new goshoppingEntities()) { var datas = db.Carts .Where(m => m.user_no == UserAccount.UserNo) .ToList(); if (datas != null) { foreach (var item in datas) { OrdersDetail detail = new OrdersDetail(); detail.order_no = OrderNo; detail.product_no = item.product_no; detail.product_name = item.product_name; detail.vendor_no = Shop.GetVendorNoByProduct(item.product_no); detail.category_name = Shop.GetCategoryName(item.product_no); detail.product_spec = item.product_spec; detail.qty = item.qty; detail.price = item.price; detail.amount = item.amount; detail.remark = ""; db.OrdersDetail.Add(detail); db.SaveChanges(); db.Carts.Remove(item); db.SaveChanges(); } } } }
public static List <Status> GetStatusList() { using (goshoppingEntities db = new goshoppingEntities()) { return(db.Status.OrderBy(m => m.mno).ToList()); } }
/// <summary> /// 取得商品子分類產品數量 /// </summary> /// <param name="id">父分類id</param> /// <returns></returns> public static int GetProductCount(int id) { using (goshoppingEntities db = new goshoppingEntities()) { return(db.Products.Where(m => m.categoryid == id).Count()); } }
public ActionResult EditProfile(Users model) { if (!ModelState.IsValid) { return(View(model)); } using (goshoppingEntities db = new goshoppingEntities()) { var user = db.Users .Where(m => m.rowid == model.rowid) .FirstOrDefault(); if (user != null) { user.mname = model.mname; user.email = model.email; user.birthday = model.birthday; user.remark = model.remark; db.SaveChanges(); } return(RedirectToAction("AdminProfile")); } }
public static List <Users> GetVendorsList() { using (goshoppingEntities db = new goshoppingEntities()) { return(db.Users.Where(m => m.role_no == "Vendor").OrderBy(m => m.mno).ToList()); } }
public ActionResult Index(int id = 0, int code = -1) { UserAccount.UserStatus = id; if (code == -1) { if (UserAccount.UserCode == -1) { UserAccount.UserCode = 0; } } else { UserAccount.UserCode = code; } if (id > 0) { using (goshoppingEntities db = new goshoppingEntities()) { string str_order_no = ""; var orders = db.Orders.Where(m => m.rowid == id).FirstOrDefault(); if (orders != null) { str_order_no = orders.order_no; } var details = db.OrdersDetail.Where(m => m.order_no == str_order_no).ToList(); ViewBag.OrderNo = str_order_no; ViewBag.OrderDetail = details; } } return(View()); }
public ActionResult ChangeStatus(int id = 0) { string str_status = "ON"; using (goshoppingEntities db = new goshoppingEntities()) { var model = db.Orders.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { str_status = model.order_status; } var selectList = new List <SelectListItem>(); List <Status> lists = Shop.GetStatusList(); foreach (var item in lists) { SelectListItem list = new SelectListItem(); list.Value = item.mno; list.Text = item.mname; selectList.Add(list); } //預設選擇哪一筆 selectList.Where(m => m.Value == str_status).First().Selected = true; ViewBag.SelectList = selectList; return(View(model)); } }
public ActionResult GetDataList() { using (goshoppingEntities db = new goshoppingEntities()) { var models = db.Orders .Join(db.Payments, p => p.payment_no, d => d.mno, (p1, d1) => new { p1, payment_name = d1.mname }) .Join(db.Status, p => p.p1.order_status, d => d.mno, (p2, d2) => new { p2, status_name = d2.mname }) .Join(db.Shippings, p => p.p2.p1.shipping_no, d => d.mno, (p3, d3) => new { rowid = p3.p2.p1.rowid, order_closed = p3.p2.p1.order_closed, user_no = p3.p2.p1.user_no, order_no = p3.p2.p1.order_no, order_date = p3.p2.p1.order_date, status_no = p3.p2.p1.order_status, status_name = p3.status_name, shipping_name = d3.mname, payment_name = p3.p2.payment_name, receive_name = p3.p2.p1.receive_name, receive_address = p3.p2.p1.receive_address, remark = p3.p2.p1.remark }) .Where(m => m.user_no == UserAccount.UserNo) .Where(m => m.order_closed == UserAccount.UserCode) .OrderByDescending(m => m.order_no).ToList(); return(Json(new { data = models }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 取得目前購物車筆數 /// </summary> /// <returns></returns> private static int GetCartCount() { int int_count = 0; using (goshoppingEntities db = new goshoppingEntities()) { if (UserAccount.IsLogin) { var data1 = db.Carts .Where(m => m.user_no == UserAccount.UserNo) .ToList(); if (data1 != null) { int_count = data1.Count; } } else { var data2 = db.Carts .Where(m => m.lot_no == LotNo) .ToList(); if (data2 != null) { int_count = data2.Count; } } } return(int_count); }
/// <summary> /// 取得父分類列表 /// </summary> /// <param name="catrgoryNo">分類代號</param> /// <param name="list_no">代號列表</param> /// <param name="list_name">名稱列表</param> /// <returns></returns> public static int GetParentCategoryList(string catrgoryNo, ref List <string> list_no, ref List <string> list_name) { using (goshoppingEntities db = new goshoppingEntities()) { int int_id = 0; int int_count = 0; var model = db.Categorys.Where(m => m.category_no == catrgoryNo).FirstOrDefault(); if (model != null) { int_id = model.rowid; while (int_id > 0) { var item = db.Categorys.Where(m => m.rowid == int_id).FirstOrDefault(); if (item == null) { return(int_count); } int_count++; list_no.Add(item.category_no); list_name.Add(item.category_name); int_id = item.parentid.GetValueOrDefault(); } } return(int_count); } }
public ActionResult GetDataList() { using (Models.goshoppingEntities db = new goshoppingEntities()) { var models = db.HeartDetails.OrderBy(m => m.rowid).ToList(); return(Json(new { data = models }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetDataList() { using (goshoppingEntities db = new goshoppingEntities()) { var models = db.Status.OrderBy(m => m.mno).ToList(); return(Json(new { data = models }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(Products models) { bool status = false; if (ModelState.IsValid) { using (goshoppingEntities db = new goshoppingEntities()) { int int_cate_id = 0; if (models.rowid > 0) { //Edit var products = db.Products.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (products != null) { int_cate_id = models.categoryid.GetValueOrDefault(); products.product_no = models.product_no; products.product_name = models.product_name; products.product_spec = models.product_spec; products.categoryid = int_cate_id; products.category_name = Shop.GetCategoryName(int_cate_id); products.istop = (models.bool_istop) ? 1 : 0; products.issale = (models.bool_issale) ? 1 : 0; products.issize = (models.bool_issize) ? 1 : 0; products.iscolor = (models.bool_iscolor) ? 1 : 0; products.price = models.price; products.start_count = models.start_count; products.browse_count = models.browse_count; products.vendor_no = UserAccount.UserNo; products.remark = models.remark; products.product_content = models.product_content; products.deadline_end = models.deadline_end; products.deadline_start = models.deadline_start; products.product_tag = models.product_tag; products.color_name = models.color_name; products.size_name = models.size_name; } } else { //Save models.vendor_no = UserAccount.UserNo; int_cate_id = models.categoryid.GetValueOrDefault(); models.category_name = Shop.GetCategoryName(int_cate_id); models.istop = (models.bool_istop) ? 1 : 0; models.issale = (models.bool_issale) ? 1 : 0; models.issize = (models.bool_issize) ? 1 : 0; models.iscolor = (models.bool_iscolor) ? 1 : 0; db.Products.Add(models); } db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Edit(Users models) { bool status = false; ModelState.Remove("Password"); //忽略 Password 驗證 ModelState.Remove("role_no"); //忽略 role_no 驗證 if (ModelState.IsValid) { using (goshoppingEntities db = new goshoppingEntities()) { if (models.rowid > 0) { //Edit var users = db.Users.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (users != null) { users.isvarify = Shop.BoolToInteger(models.bool_isvarify); users.mno = models.mno; users.mname = models.mname; users.email = models.email; users.birthday = models.birthday; users.remark = models.remark; } } else { //Save models.role_no = UserAccount.UserRoleNo; models.varify_code = UserAccount.GetNewVarifyCode(); //產生驗證碼 if (UserAccount.UserStatus < 2) { models.isvarify = UserAccount.UserStatus; } else { models.isvarify = Shop.BoolToInteger(models.bool_isvarify); } db.Users.Add(models); } try { db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled = true; status = true; } catch (Exception ex) { string str_message = ex.Message; status = false; } } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Edit(int id = 0) { using (goshoppingEntities db = new goshoppingEntities()) { var models = db.Products.Where(m => m.rowid == id).FirstOrDefault(); //Category DropDownList string str_rowid = "0"; var categoryList = new List <SelectListItem>(); List <Categorys> clists = db.Categorys.OrderBy(m => m.category_no).ToList(); foreach (var item in clists) { SelectListItem list = new SelectListItem(); list.Value = item.rowid.ToString(); list.Text = Shop.GetCategoryName(item.rowid); categoryList.Add(list); if (id == 0) { if (str_rowid == "0") { str_rowid = item.rowid.ToString(); } } } if (models != null) { str_rowid = models.categoryid.ToString(); } //預設選擇哪一筆 categoryList.Where(m => m.Value == str_rowid).First().Selected = true; ViewBag.CategoryList = categoryList; if (id == 0) { Products new_model = new Products(); new_model.size_name = ""; new_model.color_name = ""; new_model.remark = ""; new_model.start_count = 5; new_model.browse_count = 0; new_model.bool_istop = false; new_model.bool_issale = true; new_model.bool_iscolor = true; new_model.bool_issize = true; return(View(new_model)); } models.bool_istop = (models.istop == 1); models.bool_issale = (models.issale == 1); models.bool_iscolor = (models.iscolor == 1); models.bool_issize = (models.issize == 1); return(View(models)); } }
public static List <HeartDetails> HeartNew() { goshoppingEntities db = new goshoppingEntities(); var lists = db.HeartDetails .Where(m => m.flag == 1) .OrderBy(m => m.deadline_start) .ToList(); return(lists); }
public ActionResult EditProfile() { using (goshoppingEntities db = new goshoppingEntities()) { var model = db.Users .Where(m => m.mno == UserAccount.UserNo) .FirstOrDefault(); return(View(model)); } }
public ActionResult GetDataList() { using (goshoppingEntities db = new goshoppingEntities()) { int int_pid = int.Parse(Session["CategoryID"].ToString()); var models = db.Categorys .Where(m => m.parentid == int_pid) .OrderBy(m => m.category_no).ToList(); return(Json(new { data = models }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 取得商品子分類列表 /// </summary> /// <param name="id">父分類id</param> /// <returns></returns> public static List <Categorys> GetCategorys(int id) { using (goshoppingEntities db = new goshoppingEntities()) { var lists = db.Categorys .Where(m => m.parentid == id) .OrderBy(m => m.category_no) .ToList(); return(lists); } }
public static List <Products> GetProducts() { using (goshoppingEntities db = new goshoppingEntities()) { var lists = db.Products .Where(m => m.issale == 1) .OrderBy(m => m.deadline_end) .ToList(); return(lists); } }
public ActionResult GetDataList() { using (goshoppingEntities db = new goshoppingEntities()) { var models = db.HeartDetails .Where(m => m.Mno == UserAccount.UserNo) .OrderBy(m => m.heart_no) .ToList(); return(Json(new { data = models }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int id = 0) { using (goshoppingEntities db = new goshoppingEntities()) { if (id == 0) { Status new_model = new Status(); return(View(new_model)); } var models = db.Status.Where(m => m.rowid == id).FirstOrDefault(); return(View(models)); } }
public ActionResult ReturnToParent() { using (goshoppingEntities db = new goshoppingEntities()) { int int_pid = int.Parse(Session["CategoryID"].ToString()); var model = db.Categorys.Where(m => m.rowid == int_pid).FirstOrDefault(); if (model != null) { int_pid = model.parentid.GetValueOrDefault(); } return(RedirectToAction("Index", "Category", new { id = int_pid })); } }
public static List <Products> GetTopColthProducts() { using (goshoppingEntities db = new goshoppingEntities()) { var lists = db.Products .Where(m => m.istop == 1) .Where(m => m.issale == 1) .Where(m => m.categoryid == 3 || m.categoryid == 10 || m.categoryid == 11 || m.categoryid == 12) .OrderBy(m => m.product_no) .ToList(); return(lists); } }
/// <summary> /// 取得日期範圍中的銷售金額 /// </summary> /// <param name="startDate">開始日期</param> /// <param name="endDate">結束日期</param> /// <returns></returns> private int GetSaleAmount(DateTime startDate, DateTime endDate) { using (goshoppingEntities db = new goshoppingEntities()) { int int_amount = 0; startDate = startDate.ezMinDateTime(); endDate = endDate.ezMaxDateTime(); if (UserAccount.RoleNo == AppEnum.enUserRole.Admin) { object obj_value = db.OrdersDetail .Join(db.Orders, p => p.order_no, d => d.order_no, (p1, d1) => new { p1, d1 }) .Where(m => m.d1.order_date >= startDate) .Where(m => m.d1.order_date <= endDate) .Sum(m => m.p1.amount); if (obj_value != null) { int.TryParse(obj_value.ToString(), out int_amount); } } if (UserAccount.RoleNo == AppEnum.enUserRole.Member) { object obj_value = db.OrdersDetail .Join(db.Orders, p => p.order_no, d => d.order_no, (p1, d1) => new { p1, d1 }) .Where(m => m.d1.order_date >= startDate) .Where(m => m.d1.order_date <= endDate) .Where(m => m.d1.user_no == UserAccount.UserNo) .Sum(m => m.p1.amount); if (obj_value != null) { int.TryParse(obj_value.ToString(), out int_amount); } } if (UserAccount.RoleNo == AppEnum.enUserRole.Vendor) { object obj_value = db.OrdersDetail .Join(db.Orders, p => p.order_no, d => d.order_no, (p1, d1) => new { p1, d1 }) .Where(m => m.d1.order_date >= startDate) .Where(m => m.d1.order_date <= endDate) .Where(m => m.p1.vendor_no == UserAccount.UserNo) .Sum(m => m.p1.amount); if (obj_value != null) { int.TryParse(obj_value.ToString(), out int_amount); } } return(int_amount); } }
/// <summary> /// 取得置頂商品列表 /// </summary> /// <returns></returns> public static List <Products> GetTopProducts() { using (goshoppingEntities db = new goshoppingEntities()) { var lists = db.Products .Where(m => m.ishot == 1) .Where(m => m.issale == 1) .OrderBy(m => m.product_no) .ToList(); return(lists); } }
public static string GetUserName(string userNo) { string str_name = ""; using (goshoppingEntities db = new goshoppingEntities()) { var models = db.Users.Where(m => m.mno == userNo).FirstOrDefault(); if (models != null) { str_name = models.mname; } } return(str_name); }