public ActionResult Login(FormCollection form)
{
using (var context = new BanDoDienTuEntities())
{
Models.USER a = new Models.USER();
Models.USER us = a.GetUser(form["username"].ToString(), form["password"].ToString());
if (us != null)
{
if (us.ChucNang.Contains("admin"))
{
return(RedirectToAction("Index", "AdminHome"));
}
else if (us.ChucNang.Contains("customer"))
{
if (HttpContext.Session["cart"] == null)
{
HttpContext.Session["cart"] = new List <Models.Cart>();
}
HttpContext.Session["cusname"] = us.TenKH;
HttpContext.Session["cuscode"] = us.MaKH;
return(RedirectToAction("Index", "Home"));
}
}
}
return(RedirectToAction("Login", "Home"));
}
public int UpdateCustomer(List <listcustomer> kh)
{
int success = 0;
using (var context = new BanDoDienTuEntities())
{
foreach (listcustomer item in kh)
{
KhachHang updatecustomer = context.KhachHangs.Where(makh => makh.MaKH == item.recid).First();
if (updatecustomer != null)
{
if (item.TenKH != null)
{
updatecustomer.TenKH = item.TenKH;
}
if (item.SDT != null)
{
updatecustomer.SDT = item.SDT;
}
if (item.DiaChi != null)
{
updatecustomer.DiaChi = item.DiaChi;
}
if (item.Email != null)
{
updatecustomer.Email = item.Email;
}
context.Entry(updatecustomer).State = System.Data.Entity.EntityState.Modified;
success = context.SaveChanges();
}
}
}
return(success);
}
public ActionResult Index()
{
Models.Home home = new Models.Home();
using (var context = new BanDoDienTuEntities())
{
var feature = from sp in context.SanPhams
join lsp in context.LoaiSanPhams on sp.MaLoai equals lsp.MaLoai
where lsp.TenLoai == "mới nhập"
select new Models.Product {
MaSP = sp.MaSP, TenSP = sp.TenSP, DonGia = sp.GiaBan, Hinh = sp.Hinh
};
home.FeaturePhone = feature.Take(6).ToList();
//đếm số lượng sản phẩm
List <Models.BrandHome> li = new List <Models.BrandHome>();
Models.Brand brand = new Models.Brand();
List <Models.Brand> b = brand.GetBrand();
foreach (Models.Brand item in b)
{
Models.BrandHome brh = new Models.BrandHome();
brh.MaNSX = item.MaNSX;
brh.TenNSX = item.TenNSX;
var h = from sp in context.SanPhams
join nsx in context.NhaSanXuats on sp.MaNSX equals nsx.MaNSX
where nsx.TenNSX == item.TenNSX
select new Models.Product {
};
brh.SoLuong = h.Count();
li.Add(brh);
}
home.brand = li;
}
return(View(home));
}
public List <Product> SearchProduct(string name)
{
List <Product> Product;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from sp in context.SanPhams
join lsp in context.LoaiSanPhams on sp.MaLoai equals lsp.MaLoai
join nsx in context.NhaSanXuats on sp.MaNSX equals nsx.MaNSX
where sp.TenSP.Contains(name) || nsx.TenNSX.Contains(name)
select new Product
{
MaSP = sp.MaSP,
TenSP = sp.TenSP,
MaLoai = lsp.TenLoai,
SoLuongTrongKho = sp.SoLuongTrongKho,
MaNSX = nsx.TenNSX,
DonGia = sp.GiaBan,
TinhTrang = sp.TinhTrang,
NoiDung = sp.NoiDung,
Hinh = sp.Hinh
};
Product = L2EQuery.ToList();
}
return(Product);
}
public Product GetProductByID(int id)
{
Product product;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from sp in context.SanPhams
join lsp in context.LoaiSanPhams on sp.MaLoai equals lsp.MaLoai
join nsx in context.NhaSanXuats on sp.MaNSX equals nsx.MaNSX
where sp.MaSP == id
select new Product
{
MaSP = sp.MaSP,
TenSP = sp.TenSP,
MaLoai = lsp.TenLoai,
SoLuongTrongKho = sp.SoLuongTrongKho,
MaNSX = nsx.TenNSX,
TinhTrang = sp.TinhTrang,
NoiDung = sp.NoiDung,
Hinh = sp.Hinh,
DonGia = sp.GiaBan
};
product = L2EQuery.SingleOrDefault();
}
return(product);
}
public List <Product> GetProductByBrand(int brandid)
{
List <Product> Product;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from sp in context.SanPhams
join lsp in context.LoaiSanPhams on sp.MaLoai equals lsp.MaLoai
join nsx in context.NhaSanXuats on sp.MaNSX equals nsx.MaNSX
where nsx.MaNSX == brandid
select new Product
{
MaSP = sp.MaSP,
TenSP = sp.TenSP,
MaLoai = lsp.TenLoai,
SoLuongTrongKho = sp.SoLuongTrongKho,
MaNSX = nsx.TenNSX,
TinhTrang = sp.TinhTrang,
NoiDung = sp.NoiDung,
Hinh = sp.Hinh,
DonGia = sp.GiaBan
};
Product = L2EQuery.ToList();
}
return(Product);
}
public ActionResult Signup(FormCollection form)
{
using (var context = new BanDoDienTuEntities())
{
User user = new User();
user.MaPQ = 2;
user.Username = form["email"].ToString();
user.Password = form["pass"].ToString();
context.Users.Add(user);
context.SaveChanges();
}
using (var context = new BanDoDienTuEntities())
{
var a = from u in context.Users
select new Models.USER {
MaTK = u.MaTK
};
Models.USER us = a.OrderByDescending(matk => matk.MaTK).FirstOrDefault();
KhachHang kh = new KhachHang();
kh.TenKH = form["name"].ToString();
kh.SDT = form["phone"].ToString();
kh.DiaChi = form["address"].ToString();
kh.Email = form["email"].ToString();
kh.MaTK = us.MaTK;
context.KhachHangs.Add(kh);
context.SaveChanges();
}
return(View("Index"));
}
public string AddToCart(int id)
{
Models.Cart pro;
using (var context = new BanDoDienTuEntities())
{
var a = from sp in context.SanPhams
where sp.MaSP == id
select new Models.Cart {
Hinh = sp.Hinh, MaSP = id, TenSP = sp.TenSP, DonGia = sp.GiaBan, SoLuong = 1, TongTien = sp.GiaBan
};
pro = a.SingleOrDefault();
}
if (pro != null)
{
List <Models.Cart> licart = HttpContext.Session["cart"] as List <Models.Cart>;
if (licart != null)
{
licart.Add(pro);
HttpContext.Session["cart"] = licart;
return("success");
}
else
{
return("login");
}
}
else
{
return("fail");
}
}
public int DeleteCustomer(int MaKH)
{
int success = 0;
using (var context = new BanDoDienTuEntities())
{
KhachHang deletecustomer = context.KhachHangs.Where(makh => makh.MaKH == MaKH).FirstOrDefault();
if (deletecustomer != null)
{
context.KhachHangs.Remove(deletecustomer);
success = context.SaveChanges();
}
}
return(success);
}
public int DeleteImportProduct(int id)
{
int success = 0;
using (var context = new BanDoDienTuEntities())
{
NhapSanPham deleteimportproduct = context.NhapSanPhams.Where(mansp => mansp.MaNhap == id).FirstOrDefault();
if (deleteimportproduct != null)
{
context.NhapSanPhams.Remove(deleteimportproduct);
success = context.SaveChanges();
}
}
return(success);
}
public List <TypeOfProduct> GetTypeOfProduct()
{
List <Models.TypeOfProduct> TypeOfProduct;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from lsp in context.LoaiSanPhams
select new Models.TypeOfProduct
{
MaLoai = lsp.MaLoai,
TenLoai = lsp.TenLoai
};
TypeOfProduct = L2EQuery.ToList();
}
return(TypeOfProduct);
}
public List <Brand> GetBrand()
{
List <Models.Brand> brand;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from nsx in context.NhaSanXuats
select new Models.Brand
{
MaNSX = nsx.MaNSX,
TenNSX = nsx.TenNSX
};
brand = L2EQuery.ToList();
}
return(brand);
}
public Models.ProductDetail GetProductDetailByid(int id)
{
Models.ProductDetail prode = new ProductDetail();
using (var context = new BanDoDienTuEntities())
{
var a = from sp in context.SanPhams
join ct in context.ChiTietSanPhams on sp.MaCTSP equals ct.MaCTSP
where sp.MaSP == id
select new Models.ProductDetail {
MaCTSP = sp.MaCTSP, ManHinh = ct.ManHinh, HDH = ct.HDH,
Camera = ct.Camera, RAM = ct.RAM, BoNhoTrong = ct.BoNhoTrong, Hinh = sp.Hinh,
DungLuongPin = ct.DungLuongPin, TenSP = sp.TenSP, GiaBan = sp.GiaBan, MaSP = sp.MaSP
};
prode = a.SingleOrDefault();
}
return(prode);
}
public TypeOfProduct GetTypeOfProductByID(int id)
{
TypeOfProduct a;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from lsp in context.LoaiSanPhams
where lsp.MaLoai == id
select new Models.TypeOfProduct
{
MaLoai = lsp.MaLoai,
TenLoai = lsp.TenLoai
};
a = L2EQuery.SingleOrDefault();
}
return(a);
}
public Brand GetBrandByName(string name)
{
Brand brand;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from nsx in context.NhaSanXuats
where nsx.TenNSX == name
select new Models.Brand
{
MaNSX = nsx.MaNSX,
TenNSX = nsx.TenNSX
};
brand = L2EQuery.SingleOrDefault();
}
return(brand);
}
public Models.USER GetUser(string username, string password)
{
Models.USER a;
using (var context = new BanDoDienTuEntities())
{
var user = from u in context.Users
join pq in context.Roles on u.MaPQ equals pq.MaPQ
join kh in context.KhachHangs on u.MaTK equals kh.MaTK
where u.Username == username && u.Password == password
select new Models.USER {
MaPQ = u.MaPQ, MaKH = kh.MaKH, ChucNang = pq.ChucNang,
TenKH = kh.TenKH
};
a = user.SingleOrDefault();
}
return(a);
}
public List <Feedback> GetFeedbackList()
{
List <Models.Feedback> a;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from ph in context.PhanHois
select new Models.Feedback
{
MaPH = ph.MaPH,
TieuDe = ph.TieuDe,
TenNguoiGui = ph.TenNguoiGui,
Email = ph.Email,
NoiDung = ph.NoiDung
};
a = L2EQuery.ToList();
}
return(a);
}
public List <Customer> GetCustomer()
{
List <Models.Customer> customer;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from kh in context.KhachHangs
select new Models.Customer
{
MaKH = kh.MaKH,
TenKH = kh.TenKH,
SDT = kh.SDT,
DiaChi = kh.DiaChi,
Email = kh.Email
};
customer = L2EQuery.ToList();
}
return(customer);
}
public ActionResult Checkout()
{
using (var context = new BanDoDienTuEntities())
{
long? tongtien = 0;
HoaDon hd = new HoaDon();
List <Models.Cart> licart = HttpContext.Session["cart"] as List <Models.Cart>;
foreach (Models.Cart item in licart)
{
tongtien += item.TongTien;
}
hd.MaKH = int.Parse(HttpContext.Session["cuscode"].ToString());
hd.NgayLap = DateTime.Today;
hd.TongTien = tongtien;
hd.TinhTrangDonHang = "chưa giao";
context.HoaDons.Add(hd);
context.SaveChanges();
}
using (var context = new BanDoDienTuEntities())
{
var a = from hd in context.HoaDons
select new Models.Receipt {
MaHD = hd.MaHD
};
int MAHD = a.ToList().OrderByDescending(mahd => mahd.MaHD).FirstOrDefault().MaHD;
List <Models.Cart> licart = HttpContext.Session["cart"] as List <Models.Cart>;
foreach (Models.Cart item in licart)
{
ChiTietHoaDon cthd = new ChiTietHoaDon();
cthd.MaHD = MAHD;
cthd.MaSP = item.MaSP;
cthd.SoLuong = item.SoLuong;
cthd.TongTien = item.TongTien;
context.ChiTietHoaDons.Add(cthd);
context.SaveChanges();
}
}
HttpContext.Session["cart"] = new List <Models.Cart>();
return(View("Index"));
}
public List <Models.Receipt> GetReceipt()
{
List <Models.Receipt> a;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from hd in context.HoaDons
join kh in context.KhachHangs on hd.MaKH equals kh.MaKH
select new Models.Receipt
{
MaHD = hd.MaHD,
NgayLap = hd.NgayLap,
TongTien = hd.TongTien,
TinhTrangDonHang = hd.TinhTrangDonHang,
TenKH = kh.TenKH
};
a = L2EQuery.ToList();
}
return(a);
}
public ActionResult AddImportProdutcToDatabase(FormCollection form)
{
using (var context = new BanDoDienTuEntities())
{
NhapSanPham nsp = new NhapSanPham();
nsp.MaSP = int.Parse(form["SanPham"].ToString());
nsp.SoLuong = int.Parse(form["SoLuong"].ToString());
nsp.DonGia = int.Parse(form["DonGia"].ToString());
nsp.NgayNhap = DateTime.Parse(form["NgayNhap"].ToString());
nsp.GhiChu = form["Ghichu"].ToString();
nsp.TongTien = int.Parse(form["SoLuong"].ToString()) * int.Parse(form["DonGia"].ToString());
context.NhapSanPhams.Add(nsp);
SanPham pro = context.SanPhams.ToList <SanPham>().Where(masp => masp.MaSP == int.Parse(form["SanPham"].ToString())).FirstOrDefault <SanPham>();
pro.SoLuongTrongKho += int.Parse(form["SoLuong"].ToString());
context.SaveChanges();
}
return(RedirectToAction("ImportProduct"));
}
public List <ReceiptDetail> GetReceiptDetailByMaHD(int id)
{
List <ReceiptDetail> a;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from cthd in context.ChiTietHoaDons
join sp in context.SanPhams on cthd.MaSP equals sp.MaSP
where cthd.MaHD == id
select new Models.ReceiptDetail
{
MaSP = cthd.MaSP,
MaHD = cthd.MaHD,
TenSP = sp.TenSP,
SoLuong = cthd.SoLuong,
TongTien = cthd.TongTien
};
a = L2EQuery.ToList();
}
return(a);
}
public Receipt GetReceiptByID(int id)
{
Receipt a;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from hd in context.HoaDons
join kh in context.KhachHangs on hd.MaKH equals kh.MaKH
where hd.MaHD == id
select new Models.Receipt
{
MaHD = hd.MaHD,
NgayLap = hd.NgayLap,
TongTien = hd.TongTien,
TinhTrangDonHang = hd.TinhTrangDonHang,
TenKH = kh.TenKH
};
a = L2EQuery.SingleOrDefault();
}
return(a);
}
public ImportProduct GetImportProductByID(int id)
{
Models.ImportProduct importproduct;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from ip in context.NhapSanPhams
join sp in context.SanPhams on ip.MaSP equals sp.MaSP
where ip.MaNhap == id
select new Models.ImportProduct
{
MaNhap = ip.MaNhap,
TenSP = sp.TenSP,
SoLuong = ip.SoLuong,
DonGia = ip.DonGia,
NgayNhap = ip.NgayNhap,
TongTien = ip.TongTien,
GhiChu = ip.GhiChu
};
importproduct = L2EQuery.SingleOrDefault();
}
return(importproduct);
}
public List <ImportProduct> GetImportProduct()
{
List <Models.ImportProduct> customer;
using (var context = new BanDoDienTuEntities())
{
var L2EQuery = from ip in context.NhapSanPhams
join sp in context.SanPhams on ip.MaSP equals sp.MaSP
select new Models.ImportProduct
{
MaNhap = ip.MaNhap,
TenSP = sp.TenSP,
SoLuong = ip.SoLuong,
DonGia = ip.DonGia,
NgayNhap = ip.NgayNhap,
TongTien = ip.TongTien,
GhiChu = ip.GhiChu
};
customer = L2EQuery.ToList();
}
return(customer);
}
