public bool xoaCT_PhieuNhap(string mactpn)
{
CT_PHIEUNHAP ct = db.CT_PHIEUNHAPs.Where(a => a.MaChiTietPhieuNhap == int.Parse(mactpn)).FirstOrDefault();
string mavach = ct.MaVach;
TAILIEU tl = db.TAILIEUs.Where(a => a.MaVach == mavach).FirstOrDefault();
string matailieu = tl.MaTaiLieu;
if (ct != null)
{
ct.TinhTrangXoa = true;
if (tl != null)
{
tl.TinhTrangXoa = true;
}
else
{
return(false);
}
db.SubmitChanges();
qltl.updateMaDauTaiLieu(matailieu);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
public bool themCT_PhieuNhap(string maphieunhap, string manhacungcap, List <TAILIEU> dsTL)
{
int madausach = 1;
foreach (TAILIEU tl in dsTL)
{
TAILIEU tlNew = new TAILIEU();
tlNew.MaTaiLieu = tl.MaTaiLieu;
tlNew.MaLoaiTaiLieu = tl.MaLoaiTaiLieu;
tlNew.MaChuDe = tl.MaChuDe;
tlNew.TenTaiLieu = tl.TenTaiLieu;
tlNew.SoTrang = tl.SoTrang;
tlNew.Gia = tl.Gia;
tlNew.NamXuatBan = tl.NamXuatBan;
tlNew.MaTacGia = tl.MaTacGia;
tlNew.MaNhaXuatBan = tl.MaNhaXuatBan;
tlNew.ThongTinTaiLieu = tl.ThongTinTaiLieu;
tlNew.MaNgonNgu = tl.MaNgonNgu;
tlNew.MaViTri = tl.MaViTri;
TAILIEU mavach = db.TAILIEUs.OrderByDescending(a => a.MaVach).First();
string mv = (int.Parse(mavach.MaVach.ToString()) + 1).ToString();
tlNew.MaVach = mv;
if (!string.IsNullOrEmpty(tl.HinhAnh))
{
string uploadsPath = System.IO.Path.GetFullPath("..\\..\\..\\");
string ext = Path.GetExtension(tl.HinhAnh);
uploadsPath += "Images\\TaiLieu\\" + tlNew.MaVach.ToString() + ext;
if (System.IO.File.Exists(uploadsPath))
{
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
try
{
System.IO.File.Delete(uploadsPath);
}
catch (Exception ex)
{
}
}
try
{
System.IO.File.Copy(tl.HinhAnh.ToString(), uploadsPath.ToString());
tlNew.HinhAnh = tlNew.MaVach + "" + ext;
}
catch (Exception ex)
{
continue;
}
}
tlNew.TinhTrangXoa = false;
tlNew.MaDauTaiLieu = madausach.ToString();
madausach++;
CT_PHIEUNHAP item = new CT_PHIEUNHAP();
item.MaVach = tlNew.MaVach;
item.MaPhieuNhap = int.Parse(maphieunhap);
item.MaNhaCungCap = int.Parse(manhacungcap);
try
{
db.TAILIEUs.InsertOnSubmit(tlNew);
db.CT_PHIEUNHAPs.InsertOnSubmit(item);
db.SubmitChanges();
}
catch (Exception ex)
{
return(false);
}
}
return(true);
}
public bool themTaiLieuCu(string mavach, string soluong, string maphieunhap, string manhacungcap)
{
TAILIEU tl = db.TAILIEUs.Where(a => a.MaVach == mavach).FirstOrDefault();
if (tl != null)
{
string matailieu = tl.MaTaiLieu;
TAILIEU madtl = db.TAILIEUs.Where(a => a.MaTaiLieu == tl.MaTaiLieu).OrderByDescending(a => a.MaDauTaiLieu).First();
int madautailieu = int.Parse(madtl.MaDauTaiLieu) + 1;
for (int i = 0; i < int.Parse(soluong); i++)
{
TAILIEU item = new TAILIEU();
item.MaTaiLieu = tl.MaTaiLieu;
item.MaLoaiTaiLieu = tl.MaLoaiTaiLieu;
item.MaDauTaiLieu = madautailieu.ToString();
madautailieu++;
item.MaChuDe = tl.MaChuDe;
item.MaTap = tl.MaTap;
item.TenTaiLieu = tl.TenTaiLieu;
item.SoTrang = tl.SoTrang;
item.Gia = tl.Gia;
item.NamXuatBan = tl.NamXuatBan;
item.MaTacGia = tl.MaTacGia;
item.MaNhaXuatBan = tl.MaNhaXuatBan;
item.ThongTinTaiLieu = tl.ThongTinTaiLieu;
item.MaViTri = tl.MaViTri;
item.MaNgonNgu = tl.MaNgonNgu;
item.TinhTrangXoa = false;
TAILIEU flg = db.TAILIEUs.OrderByDescending(a => a.MaVach).First();
string mv = (int.Parse(flg.MaVach.ToString()) + 1).ToString();
item.MaVach = mv;
if (!string.IsNullOrEmpty(tl.HinhAnh))
{
string uploadsPath = System.IO.Path.GetFullPath("..\\..\\..\\");
string[] arr = tl.HinhAnh.Split('.');
string old = System.IO.Path.GetFullPath("..\\..\\..\\");
old += "Images\\TaiLieu\\" + tl.HinhAnh;
uploadsPath += "Images\\TaiLieu\\" + item.MaVach.ToString() + "." + arr[1];
if (System.IO.File.Exists(uploadsPath))
{
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
try
{
System.IO.File.Delete(uploadsPath);
}
catch (Exception ex)
{
}
}
try
{
System.IO.File.Copy(old, uploadsPath.ToString());
item.HinhAnh = item.MaVach + "." + arr[1];
}
catch (Exception ex)
{
continue;
}
}
CT_PHIEUNHAP itemct = new CT_PHIEUNHAP();
itemct.MaVach = item.MaVach;
itemct.MaPhieuNhap = int.Parse(maphieunhap);
itemct.MaNhaCungCap = int.Parse(manhacungcap);
try
{
db.TAILIEUs.InsertOnSubmit(item);
db.CT_PHIEUNHAPs.InsertOnSubmit(itemct);
db.SubmitChanges();
}
catch (Exception ex)
{
return(false);
}
}
return(true);
}
return(false);
}
public bool nhapTaiLieu(TAILIEU tl, int soluong, string maphieunhap, string manhacungcap)
{
TAILIEU matailieu = db.TAILIEUs.OrderByDescending(a => a.MaTaiLieu).First();
string matl = (int.Parse(matailieu.MaTaiLieu.ToString()) + 1).ToString();
double? tongtien = 0;
for (int i = 0; i < soluong; i++)
{
TAILIEU rs = new TAILIEU();
rs.TenTaiLieu = tl.TenTaiLieu;
rs.MaLoaiTaiLieu = tl.MaLoaiTaiLieu;
rs.SoTrang = tl.SoTrang;
rs.Gia = tl.Gia;
rs.NamXuatBan = tl.NamXuatBan;
rs.MaTacGia = tl.MaTacGia;
rs.MaNhaXuatBan = tl.MaNhaXuatBan;
rs.ThongTinTaiLieu = tl.ThongTinTaiLieu;
rs.MaNgonNgu = tl.MaNgonNgu;
rs.MaChuDe = tl.MaChuDe;
rs.MaTap = tl.MaTap;
rs.MaViTri = tl.MaViTri;
rs.TinhTrangXoa = false;
tongtien += rs.Gia != null?rs.Gia:0;
TAILIEU mavach = db.TAILIEUs.OrderByDescending(a => a.MaVach).First();
string mv = (int.Parse(mavach.MaVach.ToString()) + 1).ToString();
rs.MaVach = mv;
rs.MaTaiLieu = matl;
rs.MaDauTaiLieu = (i + 1).ToString();
if (!string.IsNullOrEmpty(tl.HinhAnh))
{
string uploadsPath = System.IO.Path.GetFullPath("..\\..\\..\\");
string ext = Path.GetExtension(tl.HinhAnh);
uploadsPath += "Images\\TaiLieu\\" + rs.MaVach.ToString() + ext;
if (System.IO.File.Exists(uploadsPath))
{
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
try
{
System.IO.File.Delete(uploadsPath);
}
catch (Exception ex)
{
}
}
try
{
System.IO.File.Copy(tl.HinhAnh.ToString(), uploadsPath.ToString());
rs.HinhAnh = rs.MaVach + "" + ext;
}
catch (Exception ex)
{
continue;
}
}
CT_PHIEUNHAP item = new CT_PHIEUNHAP();
item.MaVach = rs.MaVach;
item.MaPhieuNhap = int.Parse(maphieunhap);
item.MaNhaCungCap = int.Parse(manhacungcap);
try
{
db.TAILIEUs.InsertOnSubmit(rs);
db.CT_PHIEUNHAPs.InsertOnSubmit(item);
db.SubmitChanges();
}
catch (Exception ex)
{
return(false);
}
}
PHIEUNHAP pn = db.PHIEUNHAPs.Where(a => a.MaPhieuNhap == int.Parse(maphieunhap)).FirstOrDefault();
if (pn != null)
{
pn.TongTien += tongtien;
db.SubmitChanges();
}
return(true);
}