public void xoaPhieuNhapKho(string mapnk)
{
PHIEUNHAPKHO delete = db.PHIEUNHAPKHOs.Where(t => t.MAPNK == mapnk).FirstOrDefault();
if (delete != null)
{
db.PHIEUNHAPKHOs.DeleteOnSubmit(delete);
}
db.SubmitChanges();
}
public void themPhieuNhapKho(string mapnk, string manv, string mancc, DateTime ngaynhap, float tongtien)
{
PHIEUNHAPKHO insert = new PHIEUNHAPKHO();
insert.MAPNK = mapnk;
insert.MANCC = mancc;
insert.MANV = manv;
insert.NGAYNHAP = ngaynhap;
insert.TONGTIEN = tongtien;
db.PHIEUNHAPKHOs.InsertOnSubmit(insert);
db.SubmitChanges();
}
public void suaPhieuNhapKho(string manv, string mancc, string ngaynhap, float tongtien)
{
PHIEUNHAPKHO update = db.PHIEUNHAPKHOs.Where(t => t.MAPNK == mancc).FirstOrDefault();
if (update != null)
{
update.MANCC = mancc;
update.MANV = manv;
update.NGAYNHAP = DateTime.Parse(ngaynhap);
update.TONGTIEN = tongtien;
}
db.SubmitChanges();
}
public long InsertDetailNhap(DetailNhapModel model)
{
var nhap = new PHIEUNHAPKHO();
nhap.IDNCC = model.idNCC;
nhap.IDSANPHAM = model.idProduct;
nhap.SOLUONG = model.SoLuong;
nhap.IDNHAPHANG = model.idNhap;
nhap.CREATEDATE = DateTime.Now;
db.PHIEUNHAPKHOes.Add(nhap);
db.SaveChanges();
if (nhap.PHIEUNHAPKHO_ID > 0)
{
return(nhap.PHIEUNHAPKHO_ID);
}
return(-1);
}
