public bool ThemPhieuNhap(PHIEU_NHAP pn)
{
try
{
qlkho.PHIEU_NHAPs.InsertOnSubmit(pn);
qlkho.SubmitChanges();
return(true);
}
catch { return(false); }
}
public bool SuaTTPhieuNhap(PHIEU_NHAP p)
{
try
{
PHIEU_NHAP k = qlkho.PHIEU_NHAPs.Where(t => t.MAPN == p.MAPN).FirstOrDefault();
k = p;
qlkho.SubmitChanges();
return(true);
}
catch { return(false); }
}
public bool XoaPhieuNhap(string mapn)
{
try
{
PHIEU_NHAP p = qlkho.PHIEU_NHAPs.Where(t => t.MAPN == mapn).FirstOrDefault();
qlkho.PHIEU_NHAPs.DeleteOnSubmit(p);
qlkho.SubmitChanges();
return(true);
}
catch { return(false); }
}
public decimal layTongTien(string maPN)
{
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.PHIEU_NHAPs);
var tim = from p in db.PHIEU_NHAPs where p.MAPN.Equals(maPN) select p;
PHIEU_NHAP pn = tim.First();
if (pn == null || pn.TONGTIEN == null)
{
return(0);
}
return(decimal.Parse(pn.TONGTIEN.ToString()));
}
public EStatus them(PHIEU_NHAP pn)
{
//ton?
PHIEU_NHAP pTim = db.PHIEU_NHAPs.FirstOrDefault(n => n.MAPN == pn.MAPN);
if (pTim != null)
{
return(EStatus.TRUNG_KHOA);
}
db.PHIEU_NHAPs.InsertOnSubmit(pn);
db.SubmitChanges();
return(EStatus.THANH_CONG);
}
public bool KTKhoaPhieuNhap(string mapn)
{
PHIEU_NHAP pn = sp.PHIEU_NHAPs.Where(t => t.MAPN == mapn).FirstOrDefault();
if (pn == null)
{
return(true);
}
else
{
return(false);
}
}
public string KiemTraTrung()
{
string a = MaPhieuNhap();
PHIEU_NHAP pn = sp.PHIEU_NHAPs.Where(t => t.MAPN == a).FirstOrDefault();
if (pn == null)
{
return(a);
}
else
{
return(KiemTraTrung());
}
}
public bool them(PHIEU_NHAP pn, List <CT_PHIEU_NHAP> ctPNs)
{
if (ctPNs.Count == 0)
{
return(false);
}
try
{
db.PHIEU_NHAPs.InsertOnSubmit(pn);
db.SubmitChanges();
foreach (CT_PHIEU_NHAP ct in ctPNs)
{
db.CT_PHIEU_NHAPs.InsertOnSubmit(ct);
}
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public List <CT_PhieuNhap_Print> layPhieuNhap_s(PHIEU_NHAP pn, List <CT_PHIEU_NHAP> ctPhieuNhaps)
{
List <CT_PhieuNhap_Print> result = new List <CT_PhieuNhap_Print>();
SanPham_DTO sp;
SanPham_DAL_BLL spDAL_BLL = new SanPham_DAL_BLL();
foreach (CT_PHIEU_NHAP ct in ctPhieuNhaps)
{
sp = spDAL_BLL.laySanPham(ct.MASP);
result.Add(new CT_PhieuNhap_Print
{
MaPN = pn.MAPN,
MaSP = sp.MaSP,
TenSP = sp.TenSP,
NgayNhap = pn.NGAYNHAP,
GiaNhap = string.Format("{0:N0}", ct.GIANHAP),
SlNhap = ct.SL_NHAP
});
}
return(result);
}