public ActionResult CartDelete(int id) { var data = db.Carts .Where(m => m.rowid == id) .FirstOrDefault(); if (data != null) { db.Carts.Remove(data); db.SaveChanges(); } return(RedirectToAction("CartList")); }
/// <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 Register(cvmRegister model) { if (!ModelState.IsValid) return View(model); //自定義檢查 bool bln_error = false; var check = db.Users.Where(m => m.mno == model.mno).FirstOrDefault(); if (check != null) { ModelState.AddModelError("mno", "帳號重覆註冊!!"); bln_error = true; } check = db.Users.Where(m => m.email == model.email).FirstOrDefault(); if (check != null) { ModelState.AddModelError("email", "電子信箱重覆註冊!!"); bln_error = true; } if (bln_error) return View(model); //密碼加密 using (Cryptographys cryp = new Cryptographys()) { model.password = cryp.SHA256Encode(model.password); model.ConfirmPassword = model.password; } Users user = new Users(); user.mno = model.mno; user.mname = model.mname; user.password = model.password; user.email = model.email; user.birthday = model.birthday; user.remark = model.remark; user.role_no = "Member"; user.varify_code = UserAccount.GetNewVarifyCode(); //產生驗證碼 user.isvarify = 0; //寫入資料庫 try { db.Configuration.ValidateOnSaveEnabled = false; db.Users.Add(user); db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled = true; } catch (Exception ex) { string str_message = ex.Message; } //寄出驗證信 SendVerifyMail(model.email, user.varify_code); return RedirectToAction("SendEmailResult"); }
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 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 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 } }); }
private static string CreateNewOrderNo(cvmOrders model) { ShopContent.OrderID = 0; ShopContent.OrderNo = "0"; string str_order_no = ""; string str_guid = Guid.NewGuid().ToString().Substring(0, 25).ToUpper(); using (ZONYEntities db = new ZONYEntities()) { 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; ShopContent.OrderID = neword.rowid; ShopContent.OrderNo = str_order_no; db.SaveChanges(); } } return(str_order_no); }
/// <summary> /// 加入購物車 /// </summary> /// <param name="productNo">商品編號</param> /// <param name="prod_Spec">商品規格</param> /// <param name="buyQty">數量</param> public static void AddCart(string productNo, string prod_Spec, int buyQty) { using (ZONYEntities db = new ZONYEntities()) { int int_price = ShopContent.GetProductPrice(productNo); int int_amount = (buyQty * int_price); var datas = db.Carts .Where(m => m.lot_no == LotNo) .Where(m => m.user_no == UserAccount.UserNo) .Where(m => m.product_no == productNo) .Where(m => m.product_spec == prod_Spec) .FirstOrDefault(); if (datas == null) { Carts models = new Carts(); models.lot_no = LotNo; models.user_no = UserAccount.UserNo; models.crete_time = LotCreateTime; models.product_no = productNo; models.product_name = ShopContent.GetProductName(productNo); models.product_spec = prod_Spec; models.qty = buyQty; models.amount = int_amount; models.price = int_price; db.Carts.Add(models); db.SaveChanges(); } else { datas.qty += buyQty; datas.amount = buyQty * int_price; db.SaveChanges(); } } }
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 })); }
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 Remark(Products products) { bool status = false; using (ZONYEntities db = new ZONYEntities()) { var model = db.Products.Where(m => m.rowid == products.rowid).FirstOrDefault(); if (model != null) { model.detail_remark = products.detail_remark; db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult DeleteData(int id) { bool status = false; using (ZONYEntities db = new ZONYEntities()) { var model = db.Products.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { db.Products.Remove(model); db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult ChangeStatus(Orders model) { using (ZONYEntities db = new ZONYEntities()) { bool status = false; var orders = db.Orders.Where(m => m.order_no == model.order_no).FirstOrDefault(); if (orders != null) { orders.order_status = model.order_status; orders.order_closed = ShopContent.GetOrderClosed(model.order_status); orders.order_validate = ShopContent.GetOrderValidate(model.order_status); db.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); } }
public ActionResult ResetPassword(int id) { bool status = false; using (ZONYEntities db = new ZONYEntities()) { var model = db.Users.Where(m => m.rowid == id).FirstOrDefault(); if (model != null) { using (Cryptographys crpy = new Cryptographys()) { model.password = crpy.SHA256Encode(model.mno); db.SaveChanges(); } status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Edit(Categorys models) { bool status = false; if (ModelState.IsValid) { using (ZONYEntities db = new ZONYEntities()) { if (models.rowid > 0) { //Edit var Categorys = db.Categorys.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (Categorys != null) { Categorys.category_no = models.category_no; Categorys.category_name = models.category_name; } } else { //Save if (Session["CategoryID"] == null) { models.parentid = 0; } else { models.parentid = int.Parse(Session["CategoryID"].ToString()); } db.Categorys.Add(models); } db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
/// <summary> /// 登入時將現有遊客的購物車加入客戶的購物車 /// </summary> public static void LoginCart() { if (!string.IsNullOrEmpty(LotNo)) { int int_qty = 0; using (ZONYEntities db = new ZONYEntities()) { var datas = db.Carts .Where(m => m.lot_no == LotNo) .ToList(); if (datas != null) { foreach (var item in datas) { int_qty = item.qty.GetValueOrDefault(); AddCart(item.product_no, item.product_spec, int_qty); db.Carts.Remove(item); } db.SaveChanges(); } } NewLotNo(); } }
public ActionResult Edit(Products models) { bool status = false; if (ModelState.IsValid) { using (ZONYEntities db = new ZONYEntities()) { 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 = ShopContent.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.isgame = (models.bool_isgame) ? 1 : 0; products.ismultiplayer = (models.bool_ismultiplayer) ? 1 : 0; products.price = models.price; products.start_count = models.start_count; products.browse_count = models.browse_count; products.vendor_no = UserAccount.UserNo; products.color_name = models.color_name; products.size_name = models.size_name; products.remark = models.remark; products.detail_remark = models.detail_remark; products.publisher = models.publisher; products.language_view = models.language_view; products.language_voice = models.language_voice; products.player_num = models.player_num; } } else { //Save models.vendor_no = UserAccount.UserNo; int_cate_id = models.categoryid.GetValueOrDefault(); models.category_name = ShopContent.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; models.isgame = (models.bool_isgame) ? 1 : 0; models.ismultiplayer = (models.bool_ismultiplayer) ? 1 : 0; db.Products.Add(models); } db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }