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");
}
