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