public static List <TimSachDTO> GetDSSachTheoTheLoai(string strTheLoai)
{
List <TimSachDTO> DsSachTTL = new List <TimSachDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
// var timKiem = dbMain.Saches.Where(p => p.TheLoai == (strTheLoai)).ToList(); ;
var lst = from tk in dbMain.Saches where tk.TheLoai.Contains(strTheLoai) select tk;
//from tk in dbMain.Saches where tk.TheLoai.Contains(strTheLoai) select tk;
foreach (var row in lst)
{
TimSachDTO sach = new TimSachDTO();
sach.MaSach = row.MaSach;
sach.TenSach = row.TenSach;
sach.TheLoai = row.TheLoai;
sach.TacGia = row.TacGia;
sach.DonGia = row.DonGia.ToString("###,###,###' 'VNĐ");
sach.Luongton = row.TonCuoi.ToString();
DsSachTTL.Add(sach);
}
}
return(DsSachTTL);
}
public static List <ThuTienDTO> GetDS()
{
List <ThuTienDTO> DS = new List <ThuTienDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.PhieuThus select p;
foreach (var row in query)
{
ThuTienDTO tt = new ThuTienDTO();
tt.Maphieu = row.MaPhieuThu;
tt.Ngaythu = row.NgayThu.ToString();
tt.Sotienthu = row.SoTienThu.ToString();
tt.Makh = row.MaKH;
var getKH = from h in dbMain.KhachHangs where h.MaKh == row.MaKH select h;
foreach (var row2 in getKH)
{
tt.Tenkh = row2.HoTen;
tt.Email = row2.Email;
tt.Diachi = row2.DiaChi;
tt.Sdt = row2.SDT;
// tt.Sotienno = row2.TongNo;
}
DS.Add(tt);
}
}
return(DS);
}
public static List <PhieuNhapDTO> GetDSPN()
{
List <PhieuNhapDTO> DSPN = new List <PhieuNhapDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.PhieuNhaps select p;
foreach (var row in query)
{
PhieuNhapDTO pn = new PhieuNhapDTO();
pn.Maphieunhap = row.MaPhieuNhap;
pn.Ngaynhap = row.NgayNhap.ToString();
if (row.TongTien == 0)
{
pn.Tongtien = "0";
}
else
{
pn.Tongtien = row.TongTien.ToString("###,###,###' 'VNĐ");
}
DSPN.Add(pn);
}
}
return(DSPN);
}
public static List <BanSachDTO> GetDSHD(string maphieu)
{
List <BanSachDTO> DSHoaDon = new List <BanSachDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.PhieuBans where p.MaPhieuBan == maphieu select p;
foreach (var row in query)
{
BanSachDTO hd = new BanSachDTO();
hd.Soluong = row.SoLuong.ToString();
hd.Masach = row.MaSach;
var getSach = from d in dbMain.Saches where d.MaSach == row.MaSach select d;
foreach (var row3 in getSach)
{
hd.Tensach = row3.TenSach;
hd.Dongia = row3.DonGia.ToString();
}
DSHoaDon.Add(hd);
}
}
return(DSHoaDon);
}
public static List <CTPhieuNhapDTO> GetCTPN(string mapn)
{
List <CTPhieuNhapDTO> CTPN = new List <CTPhieuNhapDTO>();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.ChiTietPhieuNhaps where p.MaPhieuNhap == mapn select p;
foreach (var row in query)
{
CTPhieuNhapDTO ctpn = new CTPhieuNhapDTO();
ctpn.Mapn = row.MaPhieuNhap;
ctpn.Masachnhap = row.MaSach;
var getSach = from d in dbMain.Saches where d.MaSach == row.MaSach select d;
foreach (var row3 in getSach)
{
ctpn.Tensach = row3.TenSach;
}
ctpn.Soluongnhap = row.SoLuong.ToString();
ctpn.Dongianhap = row.DonGia.ToString();
ctpn.Tongtien = row.TongTien.ToString();
CTPN.Add(ctpn);
}
}
return(CTPN);
}
public static void UpdateTongtien(string mapn, int soluong)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuNhap pn = dbMain.PhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap ==
mapn);
pn.TongTien = soluong;
dbMain.SubmitChanges();
}
}
public static void UpdateTongtien(string mahd, int soluong)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
HoaDon hd = dbMain.HoaDons.SingleOrDefault(p => p.MaHD ==
mahd);
hd.TongTien = soluong;
dbMain.SubmitChanges();
}
}
public static void DeleteNhanVien(string email)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
NhanVien nv = dbMain.NhanViens.Where(p => p.Email == email).FirstOrDefault();
dbMain.NhanViens.DeleteOnSubmit(nv);
dbMain.SubmitChanges();
}
}
public static void UpdatePhieuNhap(string mapn, DateTime ngaynhap)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuNhap pn = dbMain.PhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap ==
mapn);
pn.MaPhieuNhap = mapn;
pn.NgayNhap = ngaynhap;
dbMain.SubmitChanges();
}
}
public static void DeletePhieuNhap(string mapn)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuNhap pn = dbMain.PhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap ==
mapn);
dbMain.PhieuNhaps.DeleteOnSubmit(pn);
dbMain.SubmitChanges();
}
}
public static void DeleteHoaDon(string mahd, string masach)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from h in dbMain.PhieuBans where h.MaPhieuBan == mahd && h.MaSach == masach select h;
PhieuBan pb = query.SingleOrDefault();
dbMain.PhieuBans.DeleteOnSubmit(pb);
dbMain.SubmitChanges();
}
}
public static void DeletePhieuThu(string mapt)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuThu pt = dbMain.PhieuThus.SingleOrDefault(p => p.MaPhieuThu ==
mapt);
dbMain.PhieuThus.DeleteOnSubmit(pt);
dbMain.SubmitChanges();
}
}
public static void DeleteKhachHang(string makh)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
KhachHang kh = dbMain.KhachHangs.SingleOrDefault(p => p.MaKh ==
makh);
dbMain.KhachHangs.DeleteOnSubmit(kh);
dbMain.SubmitChanges();
}
}
public static void DeleteSach(string masach)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
Sach s = dbMain.Saches.SingleOrDefault(p => p.MaSach ==
masach);
dbMain.Saches.DeleteOnSubmit(s);
dbMain.SubmitChanges();
}
}
public static void DeleteHoaDon(string mahd)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
HoaDon hd = dbMain.HoaDons.SingleOrDefault(p => p.MaHD ==
mahd);
dbMain.HoaDons.DeleteOnSubmit(hd);
dbMain.SubmitChanges();
}
}
public static void UpdateQuyDinh(string luongsach, int KHno, string tonNhap, string tonBan)
{
dbMainDataContext dbMain = new dbMainDataContext();
QuyDinh qd = dbMain.QuyDinhs.Where(p => p.MaQuyDinh == "1").FirstOrDefault();
qd.NhapToiThieu = luongsach;
qd.KHNoToiThieu = KHno;
qd.TonBanToiThieu = tonBan;
qd.TonNhapToiThieu = tonNhap;
dbMain.SubmitChanges();
}
public static bool checkTrung(string makh)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.KhachHangs where p.MaKh == makh select p;
if (query.Count() > 0)
{
return(false);
}
}
return(true);
}
public static bool checkTrung(string email)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.NhanViens where p.Email == email select p;
if (query.Count() > 0)
{
return(false);
}
}
return(true);
}
public static bool checkTrung(string mahd, string masach)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from h in dbMain.PhieuBans where h.MaPhieuBan == mahd && h.MaSach == masach select h;
if (query.Count() > 0)
{
return(false);
}
}
return(true);
}
public static bool checkTrung(string mapn)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.PhieuNhaps where p.MaPhieuNhap == mapn select p;
if (query.Count() > 0)
{
return(false);
}
}
return(true);
}
public static void InsertPhieuNhap(string mapn, DateTime ngaynhap)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuNhap pn = new PhieuNhap();
pn.MaPhieuNhap = mapn;
pn.NgayNhap = ngaynhap;
pn.TongTien = 0;
dbMain.PhieuNhaps.InsertOnSubmit(pn);
dbMain.SubmitChanges();
}
}
public static void DeleteCTPhieuNhap(string mapn, string masach)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from h in dbMain.ChiTietPhieuNhaps where h.MaPhieuNhap == mapn && h.MaSach == masach select h;
//ChiTietPhieuNhap ctpn = dbMain.ChiTietPhieuNhaps.SingleOrDefault(p => p.MaPhieuNhap ==
//mapn and p=> p.MaSach == masach);
ChiTietPhieuNhap ctpn = query.SingleOrDefault();
dbMain.ChiTietPhieuNhaps.DeleteOnSubmit(ctpn);
dbMain.SubmitChanges();
}
}
public static bool checkTrung(string mahd)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.HoaDons where p.MaHD == mahd select p;
if (query.Count() > 0)
{
return(false);
}
}
return(true);
}
public static void InsertHoaDon(string mahd, string masach, int soluong)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuBan pb = new PhieuBan();
pb.MaPhieuBan = mahd;
pb.MaSach = masach;
pb.SoLuong = soluong;
dbMain.PhieuBans.InsertOnSubmit(pb);
dbMain.SubmitChanges();
}
}
public static void UpdateHD(string mahd, string makh, string tenkh, DateTime ngaynhap)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
HoaDon hd = dbMain.HoaDons.SingleOrDefault(p => p.MaHD ==
mahd);
hd.MaKH = makh;
hd.TenKH = tenkh;
hd.Ngaylap = ngaynhap;
dbMain.SubmitChanges();
}
}
public static HoaDon getThongTinHD(string mahd)
{
HoaDon hd = new HoaDon();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.HoaDons where p.MaHD == mahd select p;
foreach (var row in query)
{
hd.TongTien = row.TongTien;
}
}
return(hd);
}
public static void UpdateSoLuongSach(string masach, int soluong, string tondau, string phatsinh, string tongnhap, string tongban)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
Sach s = dbMain.Saches.SingleOrDefault(p => p.MaSach ==
masach);
s.TonCuoi = soluong;
s.TonDau = tondau;
s.TongNhap = tongnhap;
s.TongBan = tongban;
s.PhatSinh = phatsinh;
dbMain.SubmitChanges();
}
}
public static PhieuNhap getThongTinPhieuNhap(string mapn)
{
PhieuNhap pn = new PhieuNhap();
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from p in dbMain.PhieuNhaps where p.MaPhieuNhap == mapn select p;
foreach (var row in query)
{
pn.TongTien = row.TongTien;
}
}
return(pn);
}
public static void UpdateTongNoKH(string makh, string tongno, string nodau, string phatsinh)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
KhachHang kh = dbMain.KhachHangs.SingleOrDefault(p => p.MaKh ==
makh);
kh.MaKh = makh;
kh.NoDau = nodau;
kh.PhatSinh = phatsinh;
kh.TongNo = tongno;
dbMain.SubmitChanges();
}
}
public static void InsertHD(string mahd, string makh, string tenkh, DateTime ngaynhap, int tongtien)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
HoaDon hd = new HoaDon();
hd.MaHD = mahd;
hd.MaKH = makh;
hd.TenKH = tenkh;
hd.Ngaylap = ngaynhap;
hd.TongTien = tongtien;
dbMain.HoaDons.InsertOnSubmit(hd);
dbMain.SubmitChanges();
}
}
