public bool them(PHIEUNHAP pmh)
{
try
{
data.PHIEUNHAPs.InsertOnSubmit(pmh);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool themPhieuNhap(PHIEUNHAP pn)
{
try
{
qlhh.PHIEUNHAPs.InsertOnSubmit(pn);
qlhh.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool xoa(PHIEUNHAP pmh)
{
try
{
PHIEUNHAP mh = data.PHIEUNHAPs.Where(t => t.MAPN == pmh.MAPN.ToString()).FirstOrDefault();
data.PHIEUNHAPs.DeleteOnSubmit(mh);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool thanhToanCongNoNCC(string mapn)
{
try
{
PHIEUNHAP pn = qlcn.PHIEUNHAPs.Where(t => t.MaPN == mapn).FirstOrDefault();
pn.TienNo = 0;
qlcn.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool suaPhieuNhap(string mapn, float tonggt, float tongsl, float tienno)
{
try
{
PHIEUNHAP pn = qlhh.PHIEUNHAPs.Where(t => t.MaPN == mapn).FirstOrDefault();
pn.TongGiaTriNhap = tonggt;
pn.TongSoLuongNhap = tongsl;
pn.TienNo = tienno;
qlhh.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool sua(PHIEUNHAP pmh)
{
try
{
PHIEUNHAP thanhvien = data.PHIEUNHAPs.Where(t => t.MAPN == pmh.MAPN.ToString()).FirstOrDefault();
data.Refresh(RefreshMode.OverwriteCurrentValues, thanhvien);
thanhvien.SODONHANG = pmh.SODONHANG;
thanhvien.NGAYNHAP = pmh.NGAYNHAP;
thanhvien.TONGTIENNHAP = pmh.TONGTIENNHAP;
data.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool ktkc(PHIEUNHAP ma)
{
int r = data.PHIEUNHAPs.Count(t => t.MAPN == ma.MAPN.ToString());
try
{
if (r == 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}