public SachUC(string name, string DonGia, string img, string soLuongTon)
{
InitializeComponent();
DataContext = new SachViewModel();
tbTenSach.Text = name;
tbDonGia.Text = DonGia;
string _localLink = System.Reflection.Assembly.GetExecutingAssembly().Location.Remove(System.Reflection.Assembly.GetExecutingAssembly().Location.IndexOf(@"bin\Debug"));
BitmapImage bitmap = new BitmapImage();
bitmap.BeginInit();
bitmap.UriSource = new Uri(_localLink + @"Resources\img\" + img);
bitmap.EndInit();
imgAnhSach.Source = bitmap;
if (int.Parse(soLuongTon) > Const.QuyDinh_TonToiThieuSauKhiBan)
{
cardHetHang.Visibility = Visibility.Collapsed;
}
else
{
cardHetHang.Visibility = Visibility.Visible;
}
}
public static void UpdateSach(this Sach sach, SachViewModel sachVm)
{
sach.Id = sachVm.Id;
sach.IdNXB = sachVm.IdNXB;
sach.TenSach = sachVm.TenSach;
sach.TacGia = sachVm.TacGia;
sach.LinhVuc = sachVm.LinhVuc;
sach.GiaBan = sachVm.GiaBan;
sach.TrangThai = true;
}
public ActionResult ThemVaoBang(SachViewModel sachVM)
{
var tonTaiSach = entities.SACHes.Where(x => x.TenSach == sachVM.TenSach).ToList();
if (tonTaiSach.Count != 0)
{
SACH sach = entities.SACHes.Where(s => s.TenSach == sachVM.TenSach).FirstOrDefault();
sachVM.MaSach = sach.MaSach;
sachVM.TenSach = sach.TenSach;
sachVM.GiaNhap = (int)sach.DonGiaNhap;
((List <SachViewModel>)Session["listSach"]).Add(sachVM);
return(RedirectToAction("NhapSach"));
}
else
{
TempData["ErrorMessage"] = "Trong CSDL không có tên sách này";
return(RedirectToAction("NhapSach"));
}
}
public ActionResult LuuCSDL(SachViewModel sachVM)
{
/**
* Lưu Ngày nhập và NXB
*/
PHIEUNHAP pn = new PHIEUNHAP();
pn.NgayNhap = sachVM.NgayNhap;
pn.MaNXB = sachVM.MaNXB;
pn.TrangThai = true;
var addedPN = entities.PHIEUNHAPs.Add(pn);
entities.SaveChanges();
int tongTien = 0;
/**
* Lưu CT_Phiếu Nhập
*/
foreach (var ct in (List <SachViewModel>)Session["listSach"])
{
int thanhTien = ct.GiaNhap * ct.SLNhap;
tongTien += thanhTien;
// Add ct phieu nhap
CT_PHIEUNHAP ctpn = new CT_PHIEUNHAP();
ctpn.MaPN = pn.MaPN;
ctpn.MaSach = ct.MaSach;
ctpn.SLNhap = ct.SLNhap;
ctpn.DonGia = ct.GiaNhap;
ctpn.ThanhTien = thanhTien;
entities.CT_PHIEUNHAP.Add(ctpn);
}
/**
* Update tồn kho
*/
foreach (var ton in (List <SachViewModel>)Session["listSach"])
{
TONKHO tonkho = new TONKHO();
tonkho.MaSach = ton.MaSach;
tonkho.ThoiGian = sachVM.NgayNhap;
tonkho.SLTon = ton.SLNhap;
entities.TONKHOes.Add(tonkho);
entities.SaveChanges();
}
/**
* Update tổng tiền
*/
addedPN.TongTien = tongTien;
/**
* Update công nợ NXB
*/
CONGNO_NXB cnNXB = new CONGNO_NXB();
cnNXB.MaNXB = sachVM.MaNXB;
cnNXB.ThoiGian = sachVM.NgayNhap;
cnNXB.TienNo = tongTien;
cnNXB.TienDaTra = 0;
entities.CONGNO_NXB.Add(cnNXB);
entities.SaveChanges();
Session.Clear();
return(RedirectToAction("Index"));
}
