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); }