public string PhatSinhMaCTHD(string maHoaDon)
{
string maCTHD = maHoaDon;
List <ChiTietHoaDon> cthds = qlcf.ChiTietHoaDons.Where(ct => ct.MaHoaDon == maHoaDon).Select(ct => ct).ToList();
ChiTietHoaDon cthd = cthds.LastOrDefault();
if (cthd == null)
{
maCTHD += "_1000";
}
else
{
int k;
k = Convert.ToInt32(cthd.MaCTHD.Substring(7, 4));
k += 1;
maCTHD += "_" + k.ToString();
}
return(maCTHD);
}
public int AddChiTietHoaDons(string MaPN, string MaSP, int soLuong, int tongTien)
{
ChiTietHoaDon chitiethoadons = qlhh.ChiTietHoaDons.Where(t => t.MaHoaDon == MaPN && t.MaSanPham == MaPN).FirstOrDefault();
if (chitiethoadons == null)
{
ChiTietHoaDon cthd = new ChiTietHoaDon();
cthd.MaHoaDon = MaPN;
cthd.MaSanPham = MaSP;
cthd.SoLuong = soLuong;
cthd.TongTien = tongTien;
qlhh.ChiTietHoaDons.InsertOnSubmit(cthd);
qlhh.SubmitChanges();
return(1);
}
else
{
return(0);
}
}
public void InsertChiTietHoaDon(string maHoaDon, string maDoUong)
{
ChiTietHoaDon cts = qlcf.ChiTietHoaDons.Where(ct => ct.MaHoaDon == maHoaDon && ct.MaDoUong == maDoUong).FirstOrDefault();
if (cts == null)
{
ChiTietHoaDon cthd = new ChiTietHoaDon();
cthd.MaCTHD = PhatSinhMaCTHD(maHoaDon);
cthd.MaHoaDon = maHoaDon;
cthd.MaDoUong = maDoUong;
cthd.SoLuong = 1;
cthd.ThanhTien = GetDonGiaDoUong(maDoUong);
qlcf.ChiTietHoaDons.InsertOnSubmit(cthd);
qlcf.SubmitChanges();
}
else
{
cts.SoLuong++;
cts.ThanhTien = cts.SoLuong * GetDonGiaDoUong(maDoUong);
qlcf.SubmitChanges();
}
}