public JsonResult <ApiMobileArray> GetCategory() { ApiMobileArray result = new ApiMobileArray(); using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var categoryDB = db.CATEGORY_PRODUCT.ToList(); if (categoryDB is null) { result.Success = false; result.Message = "Lấy list Category thất bại. Data trông"; result.Data = null; } else { result.Success = true; result.Message = "Lấy list Category thành công"; List <ModalCategory> arrCategory = new List <ModalCategory>(); foreach (var ctgr in categoryDB) { ModalCategory ctgrNew = new ModalCategory(); ctgrNew.IdCategory = ctgr.IdCategory; ctgrNew.CategoryName = ctgr.CategoryName; ctgrNew.CategoryIcon = ctgr.CategoryIcon; arrCategory.Add(ctgrNew); } result.Data = arrCategory; } } return(Json(result)); }
public ActionResult Login(LoginModel data) { if (data is null) { return(HttpNotFound()); } if (String.IsNullOrEmpty(data.username) || String.IsNullOrEmpty(data.password)) { ViewBag.Error = "Vui lòng nhập tài khoản hoặc mật khẩu"; return(View()); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { // mã hóa pass nhận vào string password = db.proc_CryptData(data.password).FirstOrDefault(); // lấy info user var userDB = db.USERs.Where(x => x.Username.Equals(data.username.ToLower().Trim()) && x.Password.Equals(password)).FirstOrDefault(); if (userDB is null) { ViewBag.Error = "Tài khoản hoặc mật khẩu không chính xác"; return(View()); } Session["login"] = userDB; return(RedirectToAction("Index")); } }
public string AccpetReview(int id) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var review = db.REVIEW_PRODUCT.Where(x => x.IdReview == id).FirstOrDefault(); if (review is null) { return("Không tìm thấy đối tượng này"); } review.ReviewStatus = true; try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public JsonResult RemoveCart(int id) { if (Session["cart"] is null) { Session["cart"] = new List <PRODUCT>(); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var list = Session["cart"] as List <PRODUCT>; var product = list.Where(x => x.IdProduct == id).FirstOrDefault(); if (product is null) { return new JsonResult() { Data = new { Success = 0, Message = "Không tồn tại sản phẩm trong giỏ hàng" }, JsonRequestBehavior = JsonRequestBehavior.AllowGet } } ; list.Remove(product); Session["cart"] = list; return(new JsonResult() { Data = new { Success = 1, Message = list.Count }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult <ApiMobileObject> GetInfoCustomerByPhone(string Phone) { ApiMobileObject result = new ApiMobileObject(); using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var url = "http://localhost:58702/"; var InfoCustomer = db.CUSTOMERs.Where(x => x.CustomerPhone == Phone.ToString()).FirstOrDefault(); if (InfoCustomer is null) { result.Success = false; result.Message = "Lấy InfoCostomer thất bại. SĐT không tồn tại trong hệ thống"; result.Data = null; } else { ModalInfoCustomer InfoCTM = new ModalInfoCustomer(); InfoCTM.IdCustomer = InfoCustomer.IdCustomer; InfoCTM.CustomerName = InfoCustomer.CustomerName; InfoCTM.CustomerAddress = InfoCustomer.CustomerAddress; InfoCTM.CustomerPhone = InfoCustomer.CustomerPhone; InfoCTM.CustomerEmail = InfoCustomer.CustomerEmail; result.Success = true; result.Message = "Lấy list Product By IDCategory thành công"; result.Data = InfoCTM; } } return(Json(result)); }
public string DeleteCategory(int id) { if (Session["login"] is null) { return(null); } int idRole = ((USER)Session["login"]).IdRole; if (idRole != 1) { return("Bạn không có quyền xóa"); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var category = db.CATEGORY_PRODUCT.Where(x => x.IdCategory == id).FirstOrDefault(); if (category is null) { return("Không tìm thấy đối tượng này"); } db.CATEGORY_PRODUCT.Remove(category); try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public string UpdateImei(ProductOrderModel data) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var product = db.PRODUCT_ORDER.Where(x => x.IdOrder == data.IdOrder && x.IdProduct == data.IdProduct).FirstOrDefault(); if (product is null) { return("Không tìm thấy đối tượng này"); } try { var order = db.ORDERs.Where(x => x.IdOrder == data.IdOrder).FirstOrDefault(); if (order.IdStatus == 5 || order.IdStatus == 4) { throw new Exception("Đơn hàng này đã không giao được"); } product.IMEI = data.IMEI; db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public string DeleteUser(int id) { if (Session["login"] is null) { return(null); } int idRole = ((USER)Session["login"]).IdRole; if (idRole != 1) { return("Bạn không có quyền xóa"); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var user = db.USERs.Where(x => x.IdUser == id).FirstOrDefault(); if (user is null) { return("Không tìm thấy đối tượng này"); } db.USERs.Remove(user); try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public string AccpetComment(int id) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var comment = db.COMMENT_PRODUCT.Where(x => x.IdComment == id).FirstOrDefault(); if (comment is null) { return("Không tìm thấy đối tượng này"); } comment.CommentStatus = true; try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public ActionResult Info(int?id) { int slitem = 0; int tongtien = 0; if (Session["cart"] != null) { foreach (var item in Session["cart"] as List <PRODUCT> ) { slitem += item.Quantily; tongtien += (int)item.ProductPrice * item.Quantily; } } ViewBag.sl = slitem; ViewBag.tongtien = tongtien; using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { if (id is null) { return(HttpNotFound()); } var product = db.PRODUCTs.Where(x => x.IdProduct == id).FirstOrDefault(); string linkk = "http://m-store.store/img/product/" + product.PRODUCT_IMG.FirstOrDefault().Filename; Session["imgShare"] = linkk; if (product is null) { return(HttpNotFound()); } return(View(product)); } }
public ActionResult NewsInfo(int?id) { if (Session["login"] is null) { return(RedirectToAction("Login")); } int idRole = ((USER)Session["login"]).IdRole; if (idRole != 1 && idRole != 2) { return(RedirectToAction("Index")); } NEWS news = new NEWS(); if (id != null) { using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { news = db.NEWS.Where(x => x.IdNews == id).FirstOrDefault(); if (news.IdUser != ((USER)Session["login"]).IdUser && idRole != 1) { return(RedirectToAction("News")); } if (news is null) { return(HttpNotFound()); } } } return(View(news)); }
public ActionResult ProductEdit(int?id) { if (Session["login"] is null) { return(RedirectToAction("Login")); } int idRole = ((USER)Session["login"]).IdRole; if (idRole != 1 && idRole != 2) { return(RedirectToAction("Index")); } PRODUCT product = new PRODUCT(); if (id != null) { using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { product = db.PRODUCTs.Where(x => x.IdProduct == id).FirstOrDefault(); if (product.IdUser != ((USER)Session["login"]).IdUser && idRole != 1) { return(RedirectToAction("Product")); } if (product is null) { return(HttpNotFound()); } } } return(View(product)); }
public ActionResult PromotionInfo(int?id) { if (Session["login"] is null) { return(RedirectToAction("Login")); } int idRole = ((USER)Session["login"]).IdRole; if (idRole != 1) { return(RedirectToAction("Index")); } PROMOTION promotion = new PROMOTION(); if (id != null) { using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { promotion = db.PROMOTIONs.Where(x => x.IdPromotion == id).FirstOrDefault(); if (promotion is null) { return(HttpNotFound()); } } } return(View(promotion)); }
public ActionResult OrderInfo(int id) { if (Session["login"] is null) { return(RedirectToAction("Login")); } int idRole = ((USER)Session["login"]).IdRole; if (idRole != 1) { return(RedirectToAction("Index")); } ORDER order = new ORDER(); using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { order = db.ORDERs.Where(x => x.IdOrder == id).FirstOrDefault(); if (order is null) { return(HttpNotFound()); } } return(View(order)); }
public ActionResult Callback() { if (Request.QueryString.Count > 0) { var vnpayData = Request.QueryString; VnPayLibrary vnpay = new VnPayLibrary(); //if (vnpayData.Count > 0) //{ foreach (string s in vnpayData) { //get all querystring data if (!string.IsNullOrEmpty(s) && s.StartsWith("vnp_")) { vnpay.AddResponseData(s, vnpayData[s]); } } // } //vnp_TxnRef: Ma don hang merchant gui VNPAY tai command=pay string orderId = vnpay.GetResponseData("vnp_TxnRef"); // lấy ra idkiosk để lấy hashsecret trong kiosk string vnp_HashSecret = "NZWQLJRMIMACCBLXUUHZXWRDPRMJPIVQ"; int IdTransaction = int.Parse(orderId); int IdKiosk = 0; DateTime payDate = DateTime.Now; //vnp_TransactionNo: Ma GD tai he thong VNPAY long vnpayTranId = Convert.ToInt64(vnpay.GetResponseData("vnp_TransactionNo")); //vnp_ResponseCode:Response code from VNPAY: 00: Thanh cong, Khac 00: Xem tai lieu string vnp_ResponseCode = vnpay.GetResponseData("vnp_ResponseCode"); //vnp_SecureHash: MD5 cua du lieu tra ve String vnp_SecureHash = Request.QueryString["vnp_SecureHash"]; bool checkSignature = vnpay.ValidateSignature(vnp_SecureHash, vnp_HashSecret); if (checkSignature) { if (vnp_ResponseCode.Equals("00")) { //Thanh toan thanh cong using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var order = db.ORDERs.Where(x => x.IdOrder == IdTransaction).FirstOrDefault(); order.IdStatus = 2; db.SaveChanges(); TempData["id"] = IdTransaction; return(RedirectToAction("Success")); } } } } return(RedirectToAction("Fail")); }
public ActionResult Logo(int LogoID, int IDLogo) { using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var email = db.CUSTOMER_EMAIL.Where(x => x.IdEmail == IDLogo && LogoID == x.IdCustomer).FirstOrDefault(); if (email == null) { return(HttpNotFound()); } email.IsRead = true; db.SaveChanges(); } return(View()); }
public JsonResult <ApiMobileObject> CheckCodeDiscount(string code) { ApiMobileObject result = new ApiMobileObject(); using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var giftCode = db.GIFTCODEs.Where(x => x.Code == code.ToString()).FirstOrDefault(); if (giftCode is null || giftCode.Status == true) { result.Success = false; result.Message = "Giftcode đã được sử dụng hoặc không tồn tại!"; result.Data = null; return(Json(result)); }
public string EditUser(UserModel user) { if (Session["login"] is null) { return(""); } if (String.IsNullOrEmpty(user.Fullname) || String.IsNullOrEmpty(user.Username) || (String.IsNullOrEmpty(user.Password) && user.IdUser == 0)) { return("Vui lòng nhập đầy đủ thông tin"); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { if (db.USERs.Any(x => x.Username.Equals(user.Username) && x.IdUser != user.IdUser)) { return("Tài khoản này đã tồn tại"); } USER u = new USER(); if (user.IdUser > 0) { u = db.USERs.Where(x => x.IdUser == user.IdUser).FirstOrDefault(); } if (u is null) { return("Dữ liệu bất thường vui lòng thử lại sau"); } u.Username = user.Username; u.Fullname = user.Fullname; u.IdRole = user.IdRole; if (!String.IsNullOrEmpty(user.Password)) { u.Password = user.Password; } if (user.IdUser == 0) { db.USERs.Add(u); } try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public ActionResult Info(int?id) { using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { if (id is null) { return(HttpNotFound()); } var product = db.PRODUCTs.Where(x => x.IdProduct == id).FirstOrDefault(); if (product is null) { return(HttpNotFound()); } return(View(product)); } }
public JsonResult GetCustomer(string phone) { using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var customer = db.CUSTOMERs.Where(x => x.CustomerPhone.Equals(phone)).FirstOrDefault(); if (customer is null) { return(null); } return(new JsonResult() { Data = new { Name = customer.CustomerName, Email = customer.CustomerEmail, Address = customer.CustomerAddress }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult GetCategory(int id) { //if (Session["login"] is null) return null; using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var categoryDB = db.CATEGORY_PRODUCT.Where(x => x.IdCategory == id).FirstOrDefault(); if (categoryDB is null) { return(null); } return(new JsonResult() { Data = new { Name = categoryDB.CategoryName, Icon = categoryDB.CategoryIcon }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public ActionResult checkOrder(string phone) { if (string.IsNullOrEmpty(phone) || !phone.IsPhoneNumber()) { return(View()); } ApiResult result = new ApiResult(); using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var custom = db.CUSTOMERs.Where(x => x.CustomerPhone.Equals(phone)).FirstOrDefault(); //câu truy vấn sai var order = db.ORDERs.Where(x => x.IdCustomer == custom.IdCustomer)?.FirstOrDefault(); //.Join //( // db.PAYMENT_METHOD, // a => a.IdPayment, // b => b.IdPayment, // ( a, b ) => new { a, b } //).Where(x => x.a.IdCustomer == custom.IdCustomer).Select(x => new //{ // x.a.IdOrder, // x.a.IdCustomer, ///get ra các thông tin cần lấy đi, có ng tới :v, xong alo a // x.a.DateOrder, // x.a.DateDelivery, // x.a.IdPayment, // x.a.Total, // x.a.IdStatus //}) if (custom is null) { return(ViewBag.Error = "Số điện thoại này không tồn tại"); } return(View(order)); //return new JsonResult() //{ // Data = new { NAME = custom.CustomerName, SDT = custom.CustomerPhone, ORDER = order.IdOrder }, // JsonRequestBehavior = JsonRequestBehavior.AllowGet //}; } }
public JsonResult AddCart(int id) { if (Session["cart"] is null) { Session["cart"] = new List <PRODUCT>(); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var product = db.PRODUCTs.Where(x => x.IdProduct == id).FirstOrDefault(); if (product is null) { return new JsonResult() { Data = new { Success = 0, Message = "Không tìm thấy sản phẩm này" }, JsonRequestBehavior = JsonRequestBehavior.AllowGet } } ; var list = Session["cart"] as List <PRODUCT>; if (list.Any(x => x.IdProduct == id)) { return new JsonResult() { Data = new { Success = 0, Message = "Sản phẩm này đã được thêm vào giỏ hàng" }, JsonRequestBehavior = JsonRequestBehavior.AllowGet } } ; list.Add(product); Session["cart"] = list; return(new JsonResult() { Data = new { Success = 1, Message = list.Count }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult GetUser(int id) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var userDB = db.USERs.Where(x => x.IdUser == id).FirstOrDefault(); if (userDB is null) { return(null); } return(new JsonResult() { Data = new { IdRole = userDB.IdRole, Fullname = userDB.Fullname, Username = userDB.Username }, JsonRequestBehavior = JsonRequestBehavior.DenyGet }); } }
public JsonResult GetGiftcode(int id) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var giftDB = db.GIFTCODEs.Where(x => x.IdCode == id).FirstOrDefault(); if (giftDB is null) { return(null); } return(new JsonResult() { Data = new { Code = giftDB.Code, Discount = giftDB.Discount }, JsonRequestBehavior = JsonRequestBehavior.DenyGet }); } }
public JsonResult GetProductInfo(int id) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var infoDB = db.INFOes.Where(x => x.IdInfo == id).FirstOrDefault(); if (infoDB is null) { return(null); } return(new JsonResult() { Data = new { Name = infoDB.InfoName, Category = infoDB.InfoCategory }, JsonRequestBehavior = JsonRequestBehavior.DenyGet }); } }
public string EditCategoryNews(CategoryModel category) { if (Session["login"] is null) { return(""); } if (String.IsNullOrEmpty(category.CategoryName) || String.IsNullOrEmpty(category.CategoryIcon)) { return("Vui lòng nhập đầy đủ thông tin"); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { CATEGORY_NEWS c = new CATEGORY_NEWS(); if (category.IdCategory > 0) { c = db.CATEGORY_NEWS.Where(x => x.IdCategory == category.IdCategory).FirstOrDefault(); } if (c is null) { return("Dữ liệu bất thường vui lòng thử lại sau"); } c.CategoryName = category.CategoryName; c.CategoryIcon = category.CategoryIcon; c.IdUser = ((USER)Session["login"]).IdUser; if (category.IdCategory == 0) { db.CATEGORY_NEWS.Add(c); } try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public string DeliveryOrder(int id) { if (Session["login"] is null) { return(null); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { var order = db.ORDERs.Where(x => x.IdOrder == id).FirstOrDefault(); if (order is null) { return("Không tìm thấy đối tượng này"); } try { if (order.IdStatus != 1 && order.IdStatus != 2) { throw new Exception("Đơn hàng này không giao được"); } if (order.PRODUCT_ORDER.Any(x => String.IsNullOrEmpty(x.IMEI))) { throw new Exception("Vui lòng nhập đủ IMEI để giao hàng"); } order.IdStatus = 3; ORDER_HISTORY history = new ORDER_HISTORY(); history.IdOrder = id; history.IdUser = (Session["login"] as USER).IdUser; history.IdStatus = order.IdStatus; history.DateHistory = DateTime.Now; order.ORDER_HISTORY.Add(history); db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public string EditGiftcode(GIFTCODE gift) { if (Session["login"] is null) { return(""); } if (String.IsNullOrEmpty(gift.Code) || gift.Discount < 1) { return("Vui lòng nhập đầy đủ thông tin"); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { GIFTCODE c = new GIFTCODE(); if (gift.IdCode > 0) { c = db.GIFTCODEs.Where(x => x.IdCode == gift.IdCode).FirstOrDefault(); } if (c is null) { return("Dữ liệu bất thường vui lòng thử lại sau"); } c.Code = gift.Code.ToUpper(); c.Discount = gift.Discount; if (gift.IdCode == 0) { db.GIFTCODEs.Add(c); } try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }
public string EditProductInfo(InfoModel info) { if (Session["login"] is null) { return(""); } if (String.IsNullOrEmpty(info.InfoName) || String.IsNullOrEmpty(info.InfoCategory)) { return("Vui lòng nhập đầy đủ thông tin"); } using (THUONGMAIDIENTUEntities db = new THUONGMAIDIENTUEntities()) { INFO i = new INFO(); if (info.IdInfo > 0) { i = db.INFOes.Where(x => x.IdInfo == info.IdInfo).FirstOrDefault(); } if (i is null) { return("Dữ liệu bất thường vui lòng thử lại sau"); } i.InfoName = info.InfoName; i.InfoCategory = info.InfoCategory.ToUpper(); if (info.IdInfo == 0) { db.INFOes.Add(i); } try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message); } } return("ok"); }