public void InsertChiTietPhieuNhap(string maPhieuNhap, string maNguyenLieu, int donGiaNhap, int soLuong)
{
ChiTietPhieuNhap cts = qlcf.ChiTietPhieuNhaps.Where(ct => ct.MaPhieuNhap == maPhieuNhap && ct.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
if (cts == null)
{
ChiTietPhieuNhap ctpn = new ChiTietPhieuNhap();
ctpn.MaCTPN = PhatSinhMaCTPN(maPhieuNhap);
ctpn.MaPhieuNhap = maPhieuNhap;
ctpn.MaNguyenLieu = maNguyenLieu;
ctpn.DonGiaNhap = donGiaNhap;
ctpn.SoLuong = soLuong;
ctpn.ThanhTien = donGiaNhap * soLuong;
qlcf.ChiTietPhieuNhaps.InsertOnSubmit(ctpn);
qlcf.SubmitChanges();
}
else
{
cts.DonGiaNhap = donGiaNhap;
cts.SoLuong += soLuong;
cts.ThanhTien = cts.SoLuong * donGiaNhap;
qlcf.SubmitChanges();
}
}
public void DeleteChiTietPhieuNhap(string maCTPN)
{
ChiTietPhieuNhap ctpn = qlcf.ChiTietPhieuNhaps.Where(ct => ct.MaCTPN == maCTPN).FirstOrDefault();
if (ctpn != null)
{
qlcf.ChiTietPhieuNhaps.DeleteOnSubmit(ctpn);
qlcf.SubmitChanges();
}
}
public int kiemTraKhoaNgoai(string qMaSP)
{
ChiTietHoaDon chiTietHoaDons = qlhh.ChiTietHoaDons.Where(t => t.MaSanPham == qMaSP).FirstOrDefault();
ChiTietPhieuNhap chiTietPhieuNhaps = qlhh.ChiTietPhieuNhaps.Where(t => t.MaSanPham == qMaSP).FirstOrDefault();
if (chiTietHoaDons == null && chiTietPhieuNhaps == null)
{
return(1);
}
else
{
return(0);
}
}
public bool KiemTraKhoaNgoaiNguyenLieu(string maNguyenLieu)
{
CongThuc ct = qlcf.CongThucs.Where(c => c.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
ChiTietPhieuNhap ctpn = qlcf.ChiTietPhieuNhaps.Where(c => c.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
if (ct == null && ctpn == null)
{
return(false);
}
else
{
return(true);
}
}
public string PhatSinhMaCTPN(string maPhieuNhap)
{
string maCTPN = maPhieuNhap;
List <ChiTietPhieuNhap> lstCTPN = qlcf.ChiTietPhieuNhaps.Where(ct => ct.MaPhieuNhap == maPhieuNhap).Select(ct => ct).ToList();
ChiTietPhieuNhap ctpn = lstCTPN.LastOrDefault();
if (ctpn == null)
{
maCTPN += "_1000";
}
else
{
int k;
k = Convert.ToInt32(ctpn.MaCTPN.Substring(7, 4));
k += 1;
maCTPN += "_" + k.ToString();
}
return(maCTPN);
}
public int AddChiTietPhieuNhaps(string MaPN, string MaSP, int soLuong, int gianhap, int tongTien)
{
ChiTietPhieuNhap chiietphieunhaps = qlhh.ChiTietPhieuNhaps.Where(t => t.MaPhieuNhap == MaPN && t.MaSanPham == MaPN).FirstOrDefault();
if (chiietphieunhaps == null)
{
ChiTietPhieuNhap ctpn = new ChiTietPhieuNhap();
ctpn.MaPhieuNhap = MaPN;
ctpn.MaSanPham = MaSP;
ctpn.SoLuong = soLuong;
ctpn.GiaNhap = gianhap;
ctpn.TongTien = tongTien;
qlhh.ChiTietPhieuNhaps.InsertOnSubmit(ctpn);
qlhh.SubmitChanges();
UpdateGiaNhap(MaSP, gianhap);
return(1);
}
else
{
return(0);
}
}
