public List <SANPHAM> GetListSP()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
List <SANPHAM> list = db.SANPHAMs.ToList();
return(list);
}
public List <nhapKho> getListNhapKho()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
List <nhapKho> list = db.nhapKhoes.ToList();
return(list);
}
public List <NHANVIEN> GetListNhanVien()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
List <NHANVIEN> list = db.NHANVIENs.ToList();
return(list);
}
public account Select(string username)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
account account = db.accounts.SingleOrDefault(x => x.username == username);
return(account);
}
public List <CHITIETSANPHAM> getListSanPham()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
List <CHITIETSANPHAM> list = db.CHITIETSANPHAMs.ToList();
return(list);
}
public double getGiaXuatByMaSp(string maSanPham)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
CHITIETSANPHAM chitietSp = db.CHITIETSANPHAMs.SingleOrDefault(x => x.maSanPham == maSanPham);
return((double)chitietSp.donGiaXuat);
}
public void DeleteAccount(string username)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
account a = db.accounts.SingleOrDefault(x => x.username == username);
db.accounts.Remove(a);
db.SaveChanges();
}
public void updateTrangThai(string id)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
nhapKho nhapKho = db.nhapKhoes.SingleOrDefault(x => x.id == id);
nhapKho.TrangThai = 1;
db.SaveChanges();
}
public void deleteDeXuatNhapKho(string id)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
nhapKho nk = db.nhapKhoes.SingleOrDefault(x => x.id == id);
db.nhapKhoes.Remove(nk);
db.SaveChanges();
}
public void DeleteByID(string NVID)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
NHANVIEN nv = db.NHANVIENs.SingleOrDefault(x => x.maNhanVien == NVID);
db.NHANVIENs.Remove(nv);
db.SaveChanges();
}
public List <AccountantQuanLiHoaDon> GetListSearch()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
List <AccountantQuanLiHoaDon> list = db.HOADONs.Where(x => x.maHoaDon == MaHoaDon).Select(x => new AccountantQuanLiHoaDon {
MaHoaDon = x.maHoaDon, NgayLapHoaDon = x.ngayLapHoaDon, ThanhTien = (float)x.thanhTien, MaNVienLapHDon = x.maNhanVien
}).ToList();
return(list);
}
public void UpdateTonKhoNhap(string id, string maSP)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
int soluong = new ModifierNhapKho().GetSoLuongByID(id);
TONKHO tk = db.TONKHOes.SingleOrDefault(x => x.maSanPham == maSP);
tk.soLuong += soluong;
db.SaveChanges();
}
public List <MDeXuatNhapKho> getListNhapKho()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
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, maSanPham = x.maSanPham
}).Where(x => x.TrangThai == 0).ToList();
return(list);
}
public List <WareHouseTonKho> GetListTK()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
List <WareHouseTonKho> list = db.TONKHOes.Select(x => new WareHouseTonKho {
maHang = x.maSanPham, soLuong = (int)x.soLuong, TenSP = x.SANPHAM.tenSanPham
}).ToList();
return(list);
}
public void Insert(string productID)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
TONKHO wh = new TONKHO();
wh.maSanPham = productID;
wh.soLuong = 0;
db.TONKHOes.Add(wh);
db.SaveChanges();
}
public void ThemSPMoi(SANPHAM modifier)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
SANPHAM sp = new SANPHAM();
sp.tenSanPham = modifier.tenSanPham;
sp.maSanPham = getNextMaSP();
db.SANPHAMs.Add(sp);
db.SaveChanges();
}
public void InsertTonKho(string maSP)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
TONKHO tk = new TONKHO();
tk.maSanPham = maSP;
tk.soLuong = 0;
db.TONKHOes.Add(tk);
db.SaveChanges();
}
public void ThemChiTietSanPhamMoi(CHITIETSANPHAM modifier, string maSanPham)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
CHITIETSANPHAM sp = new CHITIETSANPHAM();
sp.maSanPham = maSanPham;
sp.donGiaNhap = modifier.donGiaNhap;
sp.donGiaXuat = modifier.donGiaXuat;
db.CHITIETSANPHAMs.Add(sp);
db.SaveChanges();
}
public void UpdateHDForDeleteNV(string maNV)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
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 ThemAccount(account acc)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
account acc1 = new account();
acc1.username = acc.username;
acc1.password = acc.password;
acc1.position = acc.position;
db.accounts.Add(acc1);
db.SaveChanges();
}
public string UpdateTonKho(string ma, int sl)
{
string temp;
QuanLyDTDBContent db = new QuanLyDTDBContent();
TONKHO tk = db.TONKHOes.SingleOrDefault(x => x.maSanPham == ma);
tk.soLuong = tk.soLuong + sl;
db.SaveChanges();
temp = "true";
return(temp);
}
public JsonResult JThemSPMoi(AdminSanPhamMoi model)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
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 JsonResult DeleteNhanVien(string maNhanVien)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
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 ActionResult GetSearchRecord(string SearchText)
{
// DateTime time = DateTime.Parse(SearchText);
// int Nam = time.Year;
// int Thang = time.Month;
// int Ngay = time.Day;
QuanLyDTDBContent db = new QuanLyDTDBContent();
//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.thanhTien, NgayLapHoaDon = x.ngayLapHoaDon
}).ToList();
return(PartialView("SearchPartial", list));
}
public void InsertNhapKho(WarehouseNhapKho model)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
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 void Update(ListProduct model)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
SANPHAM p = db.SANPHAMs.SingleOrDefault(x => x.maSanPham == model.ID);
p.tenSanPham = model.Name;
p.MaNhaCC = model.Producer;
p.ProductTypeID = model.ProductType;
p.CHITIETSANPHAM.donGiaNhap = (double)model.OriginalPrice;
p.CHITIETSANPHAM.donGiaXuat = (double)model.SellPrice;
if (model.Image != null)
{
p.Images = model.Image;
}
db.SaveChanges();
}
// GET: Accountant/QuanLiHoaDon
public ActionResult Index()
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
if (Session["username"] != null && (string)Session["quyen"] == "Accountant")
{
//ViewBag.listInfoHoaDon = new AccountantQuanLiHoaDon().GetListHDon();
List <AccountantQuanLiHoaDon> list = db.HOADONs.Select(x => new AccountantQuanLiHoaDon {
MaHoaDon = x.maHoaDon, MaNVienLapHDon = x.maNhanVien, ThanhTien = (float)x.thanhTien, NgayLapHoaDon = x.ngayLapHoaDon
}).ToList();
ViewBag.listInfoHoaDon = list;
return(View());
}
return(RedirectToAction("Index", "Login", new { @area = "" }));
}
public void ThemNhanVien(ModifierNhanVien model)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
NHANVIEN nv = new NHANVIEN();
nv.tenNhanVien = model.tenNhanVien;
nv.maNhanVien = getNextId();
nv.ngaySinh = model.NgaySinh;
nv.gioiTinh = model.GioiTinh;
nv.cmnd = model.Cmnd;
nv.soDienThoai = model.SDT;
nv.diaChi = model.DiaChi;
nv.tenDangNhap = model.TenDangNhap;
nv.chucVu = model.ViTri;
db.NHANVIENs.Add(nv);
db.SaveChanges();
}
public void Insert(ListProduct model)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
SANPHAM p = new SANPHAM();
string ID = getNextMaSP();
CHITIETSANPHAM chitietSP = new CHITIETSANPHAM();
LoaiSanPham loaiSP = new LoaiSanPham();
p.maSanPham = getNextMaSP();
p.tenSanPham = model.Name;
p.MaNhaCC = model.Producer;
p.ProductTypeID = model.ProductType;
chitietSP.donGiaNhap = (double)model.OriginalPrice;
chitietSP.donGiaXuat = (double)model.SellPrice;
p.Images = model.Image;
db.SANPHAMs.Add(p);
db.SaveChanges();
new ModifierTonKho().Insert(ID);
}
public string KTuserpass(string username, string password)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
account a = db.accounts.SingleOrDefault(x => x.username == username);
if (a == null)
{
return("Username Không Tồn Tại");
}
else
{
if (a.password == password)
{
return(a.position);
}
else
{
return("Sai PassWord");
}
}
}
