//get product fl block
public static List <SANPHAM_DTO> GetProductFlBlock(string idBlock)
{
QuanLyShop = new QUANLYCUAHANGEntities();
return((from sp in QuanLyShop.BANG_SANPHAM where sp.idblock == idBlock select new SANPHAM_DTO {
idsanpham = sp.idsanpham, soluong = sp.soluong, idcategory = sp.idcategory, name = sp.name, price = sp.price, idblock = sp.idblock, iddetail = sp.iddetail, datesell = sp.datesell, tenkho = sp.BANG_BLOCK.name, category = sp.BANG_CATEGORY.name, thongtinchitiet = "Màn hình: " + sp.BANG_DETAIL.manhinh + "\n" + "Camera sau: " + sp.BANG_DETAIL.camerasau + "\n" + "Camera trước: " + sp.BANG_DETAIL.cameratruoc + "\n" + "OS: " + sp.BANG_DETAIL.os + "\n" + "RAM: " + sp.BANG_DETAIL.ram + "\n" + "ROM: " + sp.BANG_DETAIL.rom + "\n" + "Dung lượng pin: " + sp.BANG_DETAIL.dungluongpin + "\n" + "Dòng chip: " + sp.BANG_DETAIL.chip + "\n", image = sp.image
}).ToList());
}
//Get single employee
public static List <NHANVIEN_DTO> GetSingleEmployee(string idNv)
{
QuanLyShop = new QUANLYCUAHANGEntities();
return((from nv in QuanLyShop.BANG_NHANVIEN where nv.idnhanvien == idNv select new NHANVIEN_DTO {
idnhanvien = nv.idnhanvien, username = nv.username, password = nv.password, name = nv.name, phonenumber = nv.phonenumber, idcard = nv.idcard, address = nv.address, idhistorysell = nv.idhistorysell, position = nv.position, avatar = nv.avatar
}).ToList());
}
public static List <KHACHHANG_DTO> GetSingleCustomer(string idkh)
{
QuanLyShop = new QUANLYCUAHANGEntities();
return((from kh in QuanLyShop.BANG_KHACHHANG where kh.idkhachhang == idkh select new KHACHHANG_DTO {
idkhachhang = kh.idkhachhang, name = kh.name, phonenumber = kh.phonenumber, address = kh.address, idkhuyenmai = kh.idkhuyenmai, makhuyenmai = kh.BANG_KHUYENMAI.giamgia, createdate = kh.createdate, Chitiet = kh.Chitiet, Old = kh.Old, gender = kh.gender
}).ToList());
}
//Lấy danh sách sản phẩm
public static List <SANPHAM_DTO> LayDanhSachSanPham(string flag)
{
QuanLyShop = new QUANLYCUAHANGEntities();
if (flag == "")
{
var lstSanPham = from sp in QuanLyShop.BANG_SANPHAM select new SANPHAM_DTO {
idsanpham = sp.idsanpham, idcategory = sp.idcategory, soluong = sp.soluong, name = sp.name, price = sp.price, idblock = sp.idblock, iddetail = sp.iddetail, datesell = sp.datesell, tenkho = sp.BANG_BLOCK.name, category = sp.BANG_CATEGORY.name, thongtinchitiet = "Màn hình: " + sp.BANG_DETAIL.manhinh + "\n" + "Camera sau: " + sp.BANG_DETAIL.camerasau + "\n" + "Camera trước: " + sp.BANG_DETAIL.cameratruoc + "\n" + "OS: " + sp.BANG_DETAIL.os + "\n" + "RAM: " + sp.BANG_DETAIL.ram + "\n" + "ROM: " + sp.BANG_DETAIL.rom + "\n" + "Dung lượng pin: " + sp.BANG_DETAIL.dungluongpin + "\n" + "Dòng chip: " + sp.BANG_DETAIL.chip + "\n", image = sp.image
};
return(lstSanPham.ToList());
}
if (flag.Contains("L"))
{
var lstSanPham = from sp in QuanLyShop.BANG_SANPHAM where sp.idcategory == "CATE1" select new SANPHAM_DTO {
idsanpham = sp.idsanpham, soluong = sp.soluong, idcategory = sp.idcategory, name = sp.name, price = sp.price, idblock = sp.idblock, iddetail = sp.iddetail, datesell = sp.datesell, tenkho = sp.BANG_BLOCK.name, category = sp.BANG_CATEGORY.name, thongtinchitiet = "Màn hình: " + sp.BANG_DETAIL.manhinh + "\n" + "Camera sau: " + sp.BANG_DETAIL.camerasau + "\n" + "Camera trước: " + sp.BANG_DETAIL.cameratruoc + "\n" + "OS: " + sp.BANG_DETAIL.os + "\n" + "RAM: " + sp.BANG_DETAIL.ram + "\n" + "ROM: " + sp.BANG_DETAIL.rom + "\n" + "Dung lượng pin: " + sp.BANG_DETAIL.dungluongpin + "\n" + "Dòng chip: " + sp.BANG_DETAIL.chip + "\n", image = sp.image
};
return(lstSanPham.ToList());
}
else if (flag.Contains("S"))
{
var lstSanPham = from sp in QuanLyShop.BANG_SANPHAM where sp.idcategory == "CATE2" select new SANPHAM_DTO {
idsanpham = sp.idsanpham, soluong = sp.soluong, idcategory = sp.idcategory, name = sp.name, price = sp.price, idblock = sp.idblock, iddetail = sp.iddetail, datesell = sp.datesell, tenkho = sp.BANG_BLOCK.name, category = sp.BANG_CATEGORY.name, thongtinchitiet = "Màn hình: " + sp.BANG_DETAIL.manhinh + "\n" + "Camera sau: " + sp.BANG_DETAIL.camerasau + "\n" + "Camera trước: " + sp.BANG_DETAIL.cameratruoc + "\n" + "OS: " + sp.BANG_DETAIL.os + "\n" + "RAM: " + sp.BANG_DETAIL.ram + "\n" + "ROM: " + sp.BANG_DETAIL.rom + "\n" + "Dung lượng pin: " + sp.BANG_DETAIL.dungluongpin + "\n" + "Dòng chip: " + sp.BANG_DETAIL.chip + "\n", image = sp.image
};
return(lstSanPham.ToList());
}
else if (flag.Contains("E"))
{
var lstSanPham = from sp in QuanLyShop.BANG_SANPHAM where sp.idcategory == "CATE3" select new SANPHAM_DTO {
idsanpham = sp.idsanpham, soluong = sp.soluong, idcategory = sp.idcategory, name = sp.name, price = sp.price, idblock = sp.idblock, iddetail = sp.iddetail, datesell = sp.datesell, tenkho = sp.BANG_BLOCK.name, category = sp.BANG_CATEGORY.name, thongtinchitiet = "Màn hình: " + sp.BANG_DETAIL.manhinh + "\n" + "Camera sau: " + sp.BANG_DETAIL.camerasau + "\n" + "Camera trước: " + sp.BANG_DETAIL.cameratruoc + "\n" + "OS: " + sp.BANG_DETAIL.os + "\n" + "RAM: " + sp.BANG_DETAIL.ram + "\n" + "ROM: " + sp.BANG_DETAIL.rom + "\n" + "Dung lượng pin: " + sp.BANG_DETAIL.dungluongpin + "\n" + "Dòng chip: " + sp.BANG_DETAIL.chip + "\n", image = sp.image
};
return(lstSanPham.ToList());
}
return(null);
}
//get single block
public static List <BLOCK_DTO> GetSingleBlock(string idBlock)
{
QuanLyShop = new QUANLYCUAHANGEntities();
return((from bl in QuanLyShop.BANG_BLOCK where bl.idblock == idBlock select new BLOCK_DTO {
idblock = bl.idblock, name = bl.name, soluong = bl.soluong
}).ToList());
}
//Lấy danh sách nhân viên
public static List <NHANVIEN_DTO> LayDanhSachNhanVien(string flag)
{
QuanLyShop = new QUANLYCUAHANGEntities();
if (flag == "")
{
var lstNhanVien = from nv in QuanLyShop.BANG_NHANVIEN select new NHANVIEN_DTO {
idnhanvien = nv.idnhanvien, username = nv.username, password = nv.password, name = nv.name, phonenumber = nv.phonenumber, idcard = nv.idcard, address = nv.address, idhistorysell = nv.idhistorysell, position = nv.position
};
return(lstNhanVien.ToList());
}
if (flag.Contains("S"))
{
var lstNhanVien = from nv in QuanLyShop.BANG_NHANVIEN where nv.position == "SALE" select new NHANVIEN_DTO {
idnhanvien = nv.idnhanvien, username = nv.username, password = nv.password, name = nv.name, phonenumber = nv.phonenumber, idcard = nv.idcard, address = nv.address, idhistorysell = nv.idhistorysell, position = nv.position
};
return(lstNhanVien.ToList());
}
if (flag.Contains("W"))
{
var lstNhanVien = from nv in QuanLyShop.BANG_NHANVIEN where nv.position == "WAREHOUSE" select new NHANVIEN_DTO {
idnhanvien = nv.idnhanvien, username = nv.username, password = nv.password, name = nv.name, phonenumber = nv.phonenumber, idcard = nv.idcard, address = nv.address, idhistorysell = nv.idhistorysell, position = nv.position
};
return(lstNhanVien.ToList());
}
return(null);
}
public static List <DETAIL_DTO> GetDetailOS(string text)
{
QuanLyShop = new QUANLYCUAHANGEntities();
return((from ct in QuanLyShop.BANG_DETAIL where ct.os.Contains(text) select new DETAIL_DTO {
iddetail = ct.iddetail, manhinh = ct.manhinh, cameratruoc = ct.cameratruoc, camerasau = ct.camerasau, os = ct.os, ram = ct.ram, rom = ct.rom, dungluongpin = ct.dungluongpin, chip = ct.chip
}).ToList());
}
//Thêm lịch sử.
public static HISTORY_DTO ThemLichSu(BANG_HISTORY ls)
{
QuanLyShop = new QUANLYCUAHANGEntities();
ls = QuanLyShop.BANG_HISTORY.Add(ls);
QuanLyShop.SaveChanges();
HISTORY_DTO lsDTO = ConvertDTO(ls);
return(lsDTO);
}
//Lấy danh sách lịch sử
public static List <HISTORY_DTO> LayDanhSachLichSu()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstLichSu = from ls in QuanLyShop.BANG_HISTORY select new HISTORY_DTO {
idhistory = ls.idhistory, idnhanvien = ls.idnhanvien, idkhachhang = ls.idkhachhang, ngayban = ls.ngayban, ngayluukho = ls.ngayluukho, chitiet = ls.chitiet, nhanvien = ls.BANG_NHANVIEN.name, khachhang = ls.BANG_KHACHHANG.name
};
return(lstLichSu.ToList());
}
//Thêm chi tiết sản phẩm.
public static DETAIL_DTO ThemChiTietSanPham(BANG_DETAIL dt)
{
QuanLyShop = new QUANLYCUAHANGEntities();
dt = QuanLyShop.BANG_DETAIL.Add(dt);
QuanLyShop.SaveChanges();
DETAIL_DTO dtDTO = ConvertDTO(dt);
return(dtDTO);
}
//Lấy danh sách chi tiết sản phẩm
public static List <DETAIL_DTO> LayDanhSachChiTietSanPham()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstChiTiet = from ct in QuanLyShop.BANG_DETAIL select new DETAIL_DTO {
iddetail = ct.iddetail, manhinh = ct.manhinh, cameratruoc = ct.cameratruoc, camerasau = ct.camerasau, os = ct.os, ram = ct.ram, rom = ct.rom, dungluongpin = ct.dungluongpin, chip = ct.chip
};
return(lstChiTiet.ToList());
}
//Thêm khách hàng.
public static KHACHHANG_DTO ThemKhachHang(BANG_KHACHHANG kh)
{
QuanLyShop = new QUANLYCUAHANGEntities();
kh = QuanLyShop.BANG_KHACHHANG.Add(kh);
QuanLyShop.SaveChanges();
KHACHHANG_DTO khDTO = ConvertDTO(kh);
return(khDTO);
}
//Lấy danh sách khách hàng
public static List <KHACHHANG_DTO> LayDanhSachKhachHang()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstKhachHang = from kh in QuanLyShop.BANG_KHACHHANG select new KHACHHANG_DTO {
idkhachhang = kh.idkhachhang, name = kh.name, phonenumber = kh.phonenumber, address = kh.address, idkhuyenmai = kh.idkhuyenmai, makhuyenmai = kh.BANG_KHUYENMAI.giamgia, createdate = kh.createdate, Chitiet = kh.Chitiet, Old = kh.Old, gender = kh.gender,
};
return(lstKhachHang.ToList());
}
//Lấy danh sách khuyến mãi
public static List <KHUYENMAI_DTO> LayDanhSachKhuyenMai()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstKhuyenMai = from km in QuanLyShop.BANG_KHUYENMAI select new KHUYENMAI_DTO {
idkhuyenmai = km.idkhuyenmai, giamgia = km.giamgia
};
return(lstKhuyenMai.ToList());
}
//get name block through key
public static string GetNameThrKeyBlock(string key)
{
QuanLyShop = new QUANLYCUAHANGEntities();
List <BLOCK_DTO> lstBlock = (from bl in QuanLyShop.BANG_BLOCK where bl.idblock == key select new BLOCK_DTO {
name = bl.name
}).ToList();
return(lstBlock[0].name);
}
//Lấy danh sách hóa đơn
public static List <HOADON_DTO> LayDanhSachHoaDon()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstHoaDon = from hd in QuanLyShop.BANG_HOADON select new HOADON_DTO {
idhoadon = hd.idhoadon, idnhanvien = hd.idnhanvien, idkhachhang = hd.idkhachhang, tongtien = hd.tongtien, ngayban = hd.ngayban, tongtiencuoi = hd.tongtiencuoi, soluong = hd.soluong, khachhang = hd.BANG_KHACHHANG.name, nhanvien = hd.BANG_NHANVIEN.name
};
return(lstHoaDon.ToList());
}
//Thêm hóa đơn.
public static HOADON_DTO ThemHoaDon(BANG_HOADON hd)
{
QuanLyShop = new QUANLYCUAHANGEntities();
hd = QuanLyShop.BANG_HOADON.Add(hd);
QuanLyShop.SaveChanges();
HOADON_DTO hdDTO = ConvertDTO(hd);
return(hdDTO);
}
public static List <NHANVIEN_DTO> GetNhanVienSoDienThoai(string sdt)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from nv in QuanLyShop.BANG_NHANVIEN where nv.phonenumber.ToString().Trim() == sdt.Trim() select new NHANVIEN_DTO {
idnhanvien = nv.idnhanvien, username = nv.username, password = nv.password, name = nv.name, phonenumber = nv.phonenumber, idcard = nv.idcard, address = nv.address, idhistorysell = nv.idhistorysell, position = nv.position
};
return(result.ToList());
}
//get name cate
public static string GetNameCate(string key)
{
QuanLyShop = new QUANLYCUAHANGEntities();
List <CATEGORY_DTO> lstCate = (from cate in QuanLyShop.BANG_CATEGORY where cate.idcategory == key select new CATEGORY_DTO {
name = cate.name
}).ToList();
return(lstCate[0].name);
}
//Thêm thông báo.
public static THONGBAO_DTO ThemThongBao(BANG_THONGBAO tb)
{
QuanLyShop = new QUANLYCUAHANGEntities();
tb = QuanLyShop.BANG_THONGBAO.Add(tb);
QuanLyShop.SaveChanges();
THONGBAO_DTO tbDTO = ConvertDTO(tb);
return(tbDTO);
}
//Kiểm tra đăng nhập
public static List <NHANVIEN_DTO> PhanQuyen(string username, string password)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from nv in QuanLyShop.BANG_NHANVIEN where nv.username == username && nv.password == password select new NHANVIEN_DTO {
idnhanvien = nv.idnhanvien, username = nv.username, password = nv.password, name = nv.name, phonenumber = nv.phonenumber, idcard = nv.idcard, address = nv.address, idhistorysell = nv.idhistorysell, position = nv.position, avatar = nv.avatar
};
return(result.ToList());
}
//Lấy danh sách kho hàng
public static List <BLOCK_DTO> LayDanhSachKhoHang()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstBlock = from bl in QuanLyShop.BANG_BLOCK select new BLOCK_DTO {
idblock = bl.idblock, name = bl.name, soluong = bl.soluong
};
return(lstBlock.ToList());
}
public static double DoanhThu(string month)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from hd in QuanLyShop.BANG_HOADON where hd.ngayban.Value.Month.ToString() == month select new HOADON_DTO {
tongtiencuoi = hd.tongtiencuoi
};
double r = double.Parse(result.ToList().Sum(e => e.tongtiencuoi).ToString());
return(r);
}
//Lấy danh sách thể loại
public static List <CATEGORY_DTO> LayDanhSachTheLoai()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstCate = from cate in QuanLyShop.BANG_CATEGORY select new CATEGORY_DTO {
idcategory = cate.idcategory, name = cate.name, quanity = cate.quanity
};
return(lstCate.ToList());
}
//Lấy danh sách thông báo
public static List <THONGBAO_DTO> LayDanhSachThongBao()
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstThongBao = from tb in QuanLyShop.BANG_THONGBAO select new THONGBAO_DTO {
idthongbao = tb.idthongbao, tieude = tb.tieude, createdate = tb.createdate, noidung = tb.noidung
};
return(lstThongBao.ToList());
}
//quantity product fol block
public static int QuantityFlBlock(string idBlock)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from sp in QuanLyShop.BANG_SANPHAM where sp.idblock == idBlock select new SANPHAM_DTO {
soluong = sp.soluong
};
int quantity = int.Parse(result.ToList().Sum(e => e.soluong).ToString());
return(quantity);
}
public static List <KHACHHANG_DTO> SellGroceries(string phone)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var lstKh = from kh in QuanLyShop.BANG_KHACHHANG
where kh.phonenumber.Contains(phone)
select new KHACHHANG_DTO {
idkhachhang = kh.idkhachhang, name = kh.name, phonenumber = kh.phonenumber, address = kh.address, idkhuyenmai = kh.idkhuyenmai, makhuyenmai = kh.BANG_KHUYENMAI.giamgia, createdate = kh.createdate, Chitiet = kh.Chitiet, Old = kh.Old, gender = kh.gender
};
return(lstKh.ToList());
}
public static bool CheckExist(string nameSP, string codeId)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from sp in QuanLyShop.BANG_SANPHAM where sp.name.ToLower() == nameSP && sp.idsanpham.ToLower() == codeId select sp.idsanpham;
if (result != null)
{
return(true);
}
return(false);
}
//Check exist
public static bool CheckExist(string idNv)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from nv in QuanLyShop.BANG_NHANVIEN where nv.idnhanvien == idNv select nv.idnhanvien;
if (result != null)
{
return(false);
}
return(true);
}
//quntity product fol cate
public static int Quanity(string idCate)
{
QuanLyShop = new QUANLYCUAHANGEntities();
var result = from sp in QuanLyShop.BANG_SANPHAM where sp.idcategory == idCate select new SANPHAM_DTO {
soluong = sp.soluong
};
int quanity = int.Parse(result.Sum(e => e.soluong).ToString());
return(quanity);
}
