public List <nhapKho> getListNhapKho()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <nhapKho> list = db.nhapKhoes.ToList();
return(list);
}
public double getGiaXuatByMaSp(string maSanPham)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
CHITIETSANPHAM chitietSp = db.CHITIETSANPHAMs.SingleOrDefault(x => x.maSanPham == maSanPham);
return((double)chitietSp.donGiaXuat);
}
public account Select(string username)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
account account = db.accounts.SingleOrDefault(x => x.username == username);
return(account);
}
public void ADDHoaDon(string maNhanVien, string MaDatHang, string SDT)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
HOADON hd = new HOADON();
string mahd = getNextMaHDon();
hd.maHoaDon = mahd;
hd.ngayLapHoaDon = DateTime.Now;
hd.maNhanVien = maNhanVien;
hd.DatHangID = MaDatHang;
hd.SDTKhachHang = SDT;
db.HOADONs.Add(hd);
db.SaveChanges();
DATHANGCHITIET dhct = new DATHANGCHITIET();
List <DATHANGCHITIET> listDatHangChiTiet = db.DATHANGCHITIETs.Where(x => x.DatHangID == MaDatHang).ToList();
double Tong = 0;
foreach (var item in listDatHangChiTiet)
{
List <CHITIETSANPHAM> ctsp = db.CHITIETSANPHAMs.Where(x => x.maSanPham == item.MaHangHoa).ToList();
Tong += (double)ctsp[0].donGiaXuat;
new ModifierChiTietHD().AddChiTietHD(mahd, item.MaHangHoa, (int)item.SoLuong, (float)ctsp[0].donGiaXuat);
}
List <HOADON> hoadon = db.HOADONs.Where(x => x.maHoaDon == mahd).ToList();
hoadon[0].TongTien = Tong;
db.SaveChanges();
}
public List <CHITIETSANPHAM> getListSanPham()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <CHITIETSANPHAM> list = db.CHITIETSANPHAMs.ToList();
return(list);
}
public List <SANPHAM> GetListSP()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <SANPHAM> list = db.SANPHAMs.ToList();
return(list);
}
public List <NHANVIEN> GetListNV()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <NHANVIEN> list = db.NHANVIENs.ToList();
return(list);
}
public JsonResult JAddShoppingCheque(string listProduct, string listQuantity, string listInfo)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
new SalesManModel().ThemPhieuMuaHang(listProduct, listQuantity, listInfo);
return(Json("true", JsonRequestBehavior.AllowGet));
}
public void DeleteAccount(string username)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
account a = db.accounts.SingleOrDefault(x => x.username == username);
db.accounts.Remove(a);
db.SaveChanges();
}
public void updateTrangThai(string id)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
nhapKho nhapKho = db.nhapKhoes.SingleOrDefault(x => x.id == id);
nhapKho.TrangThai = 1;
db.SaveChanges();
}
public void deleteDeXuatNhapKho(string id)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
nhapKho nk = db.nhapKhoes.SingleOrDefault(x => x.id == id);
db.nhapKhoes.Remove(nk);
db.SaveChanges();
}
public void DonePaymentByWarehouse(string madonhang)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
DATHANG dathang = db.DATHANGs.SingleOrDefault(x => x.MaDonHang == madonhang);
dathang.statusID = 3;
db.SaveChanges();
}
public List <WareHouseTonKho> GetListTK()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <WareHouseTonKho> list = db.TONKHOes.Select(x => new WareHouseTonKho {
maHang = x.maSanPham, soLuong = (int)x.soLuong, Size = x.SANPHAM.size, XuatXu = x.SANPHAM.xuatXu, TenSP = x.SANPHAM.tenSanPham
}).ToList();
return(list);
}
public void DeleteByID(string NVID)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
NHANVIEN nv = db.NHANVIENs.SingleOrDefault(x => x.maNhanVien == NVID);
db.NHANVIENs.Remove(nv);
db.SaveChanges();
}
public void UpdateTonKhoNhap(string id, string maSP)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
int soluong = new ModifierNhapKho().GetSoLuongByID(id);
TONKHO tk = db.TONKHOes.SingleOrDefault(x => x.maSanPham == maSP);
tk.soLuong += soluong;
db.SaveChanges();
}
public List <AccountantQuanLiHoaDon> GetListSearch()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <AccountantQuanLiHoaDon> list = db.HOADONs.Where(x => x.maHoaDon == MaHoaDon).Select(x => new AccountantQuanLiHoaDon {
MaHoaDon = x.maHoaDon, NgayLapHoaDon = x.ngayLapHoaDon, ThanhTien = (float)x.TongTien, MaNVienLapHDon = x.maNhanVien
}).ToList();
return(list);
}
public List <MDeXuatNhapKho> getListNhapKho()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <MDeXuatNhapKho> list = db.nhapKhoes.Select(x => new MDeXuatNhapKho {
TrangThai = (int)x.TrangThai, id = x.id, soLuong = (int)x.soLuong, ngayNhap = (DateTime)x.ngayNhap, tenSanPham = x.SANPHAM.tenSanPham, size = x.SANPHAM.size, xuatXu = x.SANPHAM.xuatXu, maSanPham = x.maSanPham
}).Where(x => x.TrangThai == 0).ToList();
return(list);
}
public void InsertTonKho(string maSP)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
TONKHO tk = new TONKHO();
tk.maSanPham = maSP;
tk.soLuong = 0;
db.TONKHOes.Add(tk);
db.SaveChanges();
}
public void UpdateHDForDeleteNV(string maNV)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
List <HOADON> list = db.HOADONs.Where(x => x.maNhanVien == maNV).ToList();
for (int i = 0; i < list.Count(); i++)
{
list[i].maNhanVien = "0";
db.SaveChanges();
}
}
public void ThemChiTietSanPhamMoi(CHITIETSANPHAM modifier, string maSanPham)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
CHITIETSANPHAM sp = new CHITIETSANPHAM();
sp.maSanPham = maSanPham;
sp.donGiaNhap = modifier.donGiaNhap;
sp.donGiaXuat = modifier.donGiaXuat;
db.CHITIETSANPHAMs.Add(sp);
db.SaveChanges();
}
public void ThemAccount(account acc)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
account acc1 = new account();
acc1.username = acc.username;
acc1.password = acc.password;
acc1.position = acc.position;
db.accounts.Add(acc1);
db.SaveChanges();
}
public void ThemSPMoi(SANPHAM modifier)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
SANPHAM sp = new SANPHAM();
sp.tenSanPham = modifier.tenSanPham;
sp.maSanPham = getNextMaSP();
sp.xuatXu = modifier.xuatXu;
sp.size = modifier.size;
db.SANPHAMs.Add(sp);
db.SaveChanges();
}
public string UpdateTonKho(string ma, int sl)
{
string temp;
QLQuanAoDBContent db = new QLQuanAoDBContent();
TONKHO tk = db.TONKHOes.SingleOrDefault(x => x.maSanPham == ma);
tk.soLuong = tk.soLuong + sl;
db.SaveChanges();
temp = "true";
return(temp);
}
public void AddChiTietHD(string billID, string ProDuctID, int Quantity, float Price)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
CHITIETHOADON cthd = new CHITIETHOADON();
cthd.ID = getNextID();
cthd.BillID = billID;
cthd.ProductID = ProDuctID;
cthd.Quantity = Quantity;
cthd.Price = Price;
db.CHITIETHOADONs.Add(cthd);
db.SaveChanges();
}
public JsonResult JThemSPMoi(AdminSanPhamMoi model)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
ModifierSP modifySP = new ModifierSP();
ModifierChiTietSanPham modifierCTSP = new ModifierChiTietSanPham();
string masp = modifySP.getNextMaSP();
modifySP.ThemSPMoi(model.SanPham);
modifierCTSP.ThemChiTietSanPhamMoi(model.ChiTietSanPham, masp);
new ModifierTonKho().InsertTonKho(masp);
return(Json("true", JsonRequestBehavior.AllowGet));
}
public void AddDatHangChiTiet(string idDatHang, string listProduct, int listQuantity)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
DATHANGCHITIET dhct = new DATHANGCHITIET();
dhct.ID = getNextIdOrDerDetail();
dhct.DatHangID = idDatHang;
dhct.MaHangHoa = listProduct;
dhct.SoLuong = listQuantity;
db.DATHANGCHITIETs.Add(dhct);
db.SaveChanges();
}
public JsonResult DeleteNhanVien(string maNhanVien)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
NHANVIEN nv = db.NHANVIENs.SingleOrDefault(x => x.maNhanVien == maNhanVien);
string username = nv.tenDangNhap;
new ModifierHD().UpdateHDForDeleteNV(maNhanVien);
new ModifierNhanVien().DeleteByID(maNhanVien);
new ModifierAccount().DeleteAccount(username);
return(Json("", JsonRequestBehavior.AllowGet));
}
public List <XuatKhoDHvaCTDT> getListDatHangVaCTDH()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
DATHANG dh = new DATHANG();
DATHANGCHITIET dhct = new DATHANGCHITIET();
List <XuatKhoDHvaCTDT> list = new List <XuatKhoDHvaCTDT>();
List <DATHANG> listDH = db.DATHANGs.Where(x => x.statusID == 2).ToList();
List <DATHANGCHITIET> listDHCT = db.DATHANGCHITIETs.ToList();
return(db.DATHANGCHITIETs.Where(x => x.DATHANG.statusID == 2).Select(x => new XuatKhoDHvaCTDT {
MaDH = x.DATHANG.MaDonHang, TenHangHoa = x.SANPHAM.tenSanPham,
tenKH = x.DATHANG.TenKhachHang, SDT = x.DATHANG.SoDienThoai, DiaChi = x.DATHANG.DiaChi, Sluong = (int)x.SoLuong
}).ToList());
}
public void InsertNhapKho(WarehouseNhapKho model)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
nhapKho nhapKho = new nhapKho();
nhapKho.id = GetNextId();
nhapKho.ngayNhap = DateTime.Now;
nhapKho.soLuong = model.soLuong;
nhapKho.maSanPham = model.maHang;
nhapKho.TrangThai = 0;
db.nhapKhoes.Add(nhapKho);
db.SaveChanges();
//ModifierTonKho mtk = new ModifierTonKho();
//mtk.UpdateTonKho(model.maHang, model.soLuong);
}
public ActionResult GetSearchRecord(string SearchText)
{
// DateTime time = DateTime.Parse(SearchText);
// int Nam = time.Year;
// int Thang = time.Month;
// int Ngay = time.Day;
QLQuanAoDBContent db = new QLQuanAoDBContent();
//List<HOADON> list = db.HOADONs.Where(x => x.ngayLapHoaDon.Year == Nam && x.ngayLapHoaDon.Month == Thang && x.ngayLapHoaDon.Day == Ngay).Select(x => new HOADON { maHoaDon = x.maHoaDon, ngayLapHoaDon = x.ngayLapHoaDon, thanhTien = x.thanhTien }).ToList();
//List<HOADON> list = db..Where(x => x.maHoaDon == SearchText).ToList();
List <AccountantQuanLiHoaDon> list = db.HOADONs.Where(x => x.maHoaDon.Contains(SearchText) || x.maNhanVien.Contains(SearchText)).Select(x => new AccountantQuanLiHoaDon {
MaHoaDon = x.maHoaDon, MaNVienLapHDon = x.maNhanVien, ThanhTien = (float)x.TongTien, NgayLapHoaDon = x.ngayLapHoaDon
}).ToList();
return(PartialView("SearchPartial", list));
}
