public ActionResult Edit(Companys models) { bool status = false; if (ModelState.IsValid) { using (ZONYEntities db = new ZONYEntities()) { if (models.rowid > 0) { //Edit var Companys = db.Companys.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (Companys != null) { Companys.mno = models.mno; Companys.mname = models.mname; Companys.remark = models.remark; } } else { //Save db.Companys.Add(models); } db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult ChangeStatus(int id = 0) { string str_status = "ON"; using (ZONYEntities db = new ZONYEntities()) { 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 = ShopContent.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 EditProfile(Users model) { if (!ModelState.IsValid) { return(View(model)); } using (ZONYEntities db = new ZONYEntities()) { 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("VendorProfile")); } }
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 (ZONYEntities db = new ZONYEntities()) { 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 GetDataList() { using (ZONYEntities db = new ZONYEntities()) { 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, payment_name = p3.p2.payment_name, shipping_name = d3.mname, 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)); } }
public static List <Status> GetStatusList() { using (ZONYEntities db = new ZONYEntities()) { return(db.Status.OrderBy(m => m.mno).ToList()); } }
private static int GetCartTotals() { int?int_totals = 0; using (ZONYEntities db = new ZONYEntities()) { 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()); }
/// <summary> /// 取得目前購物車筆數 /// </summary> /// <returns></returns> private static int GetCartCount() { int int_count = 0; using (ZONYEntities db = new ZONYEntities()) { 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); }
public static List <Users> GetVendorsList() { using (ZONYEntities db = new ZONYEntities()) { return(db.Users.Where(m => m.role_no == "Vendor").OrderBy(m => m.mno).ToList()); } }
public ActionResult GetDataList() { using (ZONYEntities db = new ZONYEntities()) { var models = db.Companys.OrderBy(m => m.mno).ToList(); return(Json(new { data = models }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(Users models) { bool status = false; ModelState.Remove("Password"); //忽略 Password 驗證 ModelState.Remove("role_no"); //忽略 role_no 驗證 if (ModelState.IsValid) { using (ZONYEntities db = new ZONYEntities()) { if (models.rowid > 0) { //Edit var users = db.Users.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (users != null) { users.isvarify = ShopContent.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 = ShopContent.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 EditProfile() { using (ZONYEntities db = new ZONYEntities()) { var model = db.Users .Where(m => m.mno == UserAccount.UserNo) .FirstOrDefault(); return(View(model)); } }
public static List <Categorys> GetCategorys(int id) { ZONYEntities db = new ZONYEntities(); var lists = db.Categorys .Where(m => m.parentid == id) .OrderBy(m => m.category_no) .ToList(); return(lists); }
public static List <Products> GetTopProducts() { ZONYEntities db = new ZONYEntities(); var lists = db.Products .Where(m => m.istop == 1) .OrderBy(m => m.product_no) .ToList(); return(lists); }
public ActionResult GetDataList() { using (ZONYEntities db = new ZONYEntities()) { 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)); } }
public ActionResult ReturnToParent() { using (ZONYEntities db = new ZONYEntities()) { 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 ActionResult Edit(int id = 0) { using (ZONYEntities db = new ZONYEntities()) { if (id == 0) { Companys new_model = new Companys(); return(View(new_model)); } var models = db.Companys.Where(m => m.rowid == id).FirstOrDefault(); return(View(models)); } }
/// <summary> /// 取得日期範圍中的銷售金額 /// </summary> /// <param name="startDate">開始日期</param> /// <param name="endDate">結束日期</param> /// <returns></returns> private int GetSaleAmount(DateTime startDate, DateTime endDate) { using (ZONYEntities db = new ZONYEntities()) { int int_amount = 0; startDate = startDate.ezMinDateTime(); endDate = endDate.ezMaxDateTime(); if (UserAccount.RoleNo == AppEnums.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 == AppEnums.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 == AppEnums.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> /// <param name="productNo">商品代號</param> /// <returns></returns> public static string GetProductName(string productNo) { string str_name = ""; using (ZONYEntities db = new ZONYEntities()) { var models = db.Products.Where(m => m.product_no == productNo).FirstOrDefault(); if (models != null) { str_name = models.product_name; } } return(str_name); }
public static string GetUserName(string userNo) { string str_name = ""; using (ZONYEntities db = new ZONYEntities()) { var models = db.Users.Where(m => m.mno == userNo).FirstOrDefault(); if (models != null) { str_name = models.mname; } } return(str_name); }
public static string GetVendorNoByProduct(string productNo) { string str_no = ""; using (ZONYEntities db = new ZONYEntities()) { var prod = db.Products.Where(m => m.product_no == productNo).FirstOrDefault(); if (prod != null) { str_no = prod.vendor_no; } } return(str_no); }
/// <summary> /// 加入購物車 /// </summary> /// <param name="productNo">商品編號</param> /// <param name="color_no">商品顏色</param> /// <param name="size_no">商品尺寸</param> /// <param name="buyQty">數量</param> public static void AddCart(string productNo /*, string color_no, string size_no*/, int buyQty) { using (ZONYEntities db = new ZONYEntities()) { string str_spec = ""; //if (!string.IsNullOrEmpty(color_no)) str_spec += string.Format("顏色:{0}", color_no); //if (!string.IsNullOrEmpty(size_no)) //{ // if (!string.IsNullOrEmpty(str_spec)) str_spec += " "; // str_spec += string.Format("尺寸:{0}", size_no); //} AddCart(productNo, str_spec, buyQty); } }
public ActionResult Delete(int id) { using (ZONYEntities db = new ZONYEntities()) { var model = db.Products.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { return(View(model)); } else { return(HttpNotFound()); } } }
/// <summary> /// 消費者付款 /// </summary> public static void CartPayment(cvmOrders model) { OrderNo = CreateNewOrderNo(model); using (ZONYEntities db = new ZONYEntities()) { var datas = db.Carts .Where(m => m.user_no == UserAccount.UserNo) .ToList(); if (datas != null) { int int_amount = datas.Sum(m => m.amount).GetValueOrDefault(); decimal dec_tax = 0; if (int_amount > 0) { dec_tax = Math.Round((decimal)(int_amount * 5 / 100), 0); } int int_total = int_amount + (int)dec_tax; var data = db.Orders.Where(m => m.order_no == OrderNo).FirstOrDefault(); if (data != null) { data.amounts = int_amount; data.taxs = (int)dec_tax; data.totals = int_total; db.SaveChanges(); } 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 = ShopContent.GetVendorNoByProduct(item.product_no); detail.category_name = ShopContent.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 ActionResult Remark(int id = 0) { using (ZONYEntities db = new ZONYEntities()) { var model = db.Products.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { ShopContent.ProductNo = model.product_no; return(View(model)); } else { return(HttpNotFound()); } } }
public ActionResult Reset(int id) { using (ZONYEntities db = new ZONYEntities()) { var model = db.Users.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { model.bool_isvarify = ShopContent.IntegerToBool(model.isvarify); return(View(model)); } else { return(HttpNotFound()); } } }
/// <summary> /// 取得分類名稱 /// </summary> /// <param name="cat_no">分類代號</param> /// <param name="cat_id">分類 ID</param> /// <returns></returns> public static string GetCategoryName(string cat_no, ref int cat_id) { cat_id = 0; string str_name = ""; using (ZONYEntities db = new ZONYEntities()) { var model = db.Categorys.Where(m => m.category_no == cat_no).FirstOrDefault(); if (model != null) { str_name = model.category_name; cat_id = model.rowid; } return(str_name); } }
public ActionResult UnConfirm(int id = 0) { using (ZONYEntities db = new ZONYEntities()) { var model = db.Users.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { model.isvarify = 0; db.SaveChanges(); return(RedirectToAction("Index", "Vendor", new { area = "Admin", id = UserAccount.UserStatus })); } else { return(HttpNotFound()); } } }
public ActionResult ReturnProduct(int id = 0) { using (ZONYEntities db = new ZONYEntities()) { var model = db.Orders.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { if (ShopContent.IsUnCloseOrder(model.order_status)) { model.order_status = "RT"; model.order_closed = 1; db.SaveChanges(); } } } return(RedirectToAction("Index", "Orders", new { area = "Member", id = UserAccount.UserStatus, code = UserAccount.UserCode })); }
/// <summary> /// 取得商品單價 /// </summary> /// <param name="productNo">商品代號</param> /// <returns></returns> public static int GetProductPrice(string productNo) { int int_price = 0; using (ZONYEntities db = new ZONYEntities()) { var models = db.Products.Where(m => m.product_no == productNo).FirstOrDefault(); if (models != null) { if (models.price != null) { int.TryParse(models.price.ToString(), out int_price); } } } return(int_price); }