public int InsertPDNNKChiTiet(eChiTietPhieuDeNghiNhapKho Chitiet)
{
var sp = from i in db.SanPhams
where i.MaSP == Chitiet.MaSP
select i;
if (sp.Any())
{
var c = from i in db.ChiTietPhieuDNNKs
where i.MaSP == Chitiet.MaSP && i.MaPhieuDNNK == Chitiet.SoPDNNK
select i;
if (c.Any())
{
throw new Exception("There have already");
}
else
{
ChiTietPhieuDNNK newct = new ChiTietPhieuDNNK();
newct.MaPhieuDNNK = Chitiet.SoPDNNK;
newct.MaSP = Chitiet.MaSP;
newct.GhiChu = Chitiet.GhiChu;
newct.SoLuong = Chitiet.SoLuong;
db.ChiTietPhieuDNNKs.InsertOnSubmit(newct);
db.SubmitChanges();
return(1);
}
}
else
{
throw new Exception("Invaild SanPham ID");
}
}
public void DeletePDNNKChiTiet(string SoPhieu, string MaSP)
{
MaSP = SetMaSp(MaSP);
ChiTietPhieuDNNK ct = db.ChiTietPhieuDNNKs.Where(x => x.MaPhieuDNNK == SoPhieu && x.MaSP == MaSP).FirstOrDefault();
if (ct != null)
{
db.ChiTietPhieuDNNKs.DeleteOnSubmit(ct);
db.SubmitChanges();
}
else
{
throw new Exception("Invalid Details of Null Information");
}
}
