public bool ThanhToan(BanDTO ban, double tongTien, HoaDonTamDTO hdtam, int Manvlap) { bool flag; try { //HOA_DON hd = db.HOA_DON.Where(u => u.SOBAN == ban.Soban && u.TRANGTHAI == 0).SingleOrDefault(); //hd.TONGTIEN = tongTien; //hd.TRANGTHAI = 1; //db.SaveChanges(); //BAN bandb = db.BANs.Where(u => u.SOBAN == ban.Soban).SingleOrDefault(); //bandb.TRANGTHAI = 1; //db.SaveChanges(); HOA_DON hd = new HOA_DON { SOBAN = hdtam.MaBan, NGAYLAP = DateTime.Now, MANVLAP = Manvlap, TONGTIEN = tongTien }; db.HOA_DON.Add(hd); db.SaveChanges(); foreach (ThucUongDTO tu in hdtam.ListTUTam) { CHI_TIET_HOA_DON cthd = new CHI_TIET_HOA_DON { MAHD = hd.MAHD, MATU = tu.Matu, SL = tu.Soluong, GIABAN = tu.Gia }; db.CHI_TIET_HOA_DON.Add(cthd); db.SaveChanges(); } flag = true; } catch (Exception e) { flag = false; } return(flag); }
public bool ThemThucUongTheoBan(BanDTO ban, int MaNVLap, string TenTU, string LoaiTU, int SoLg) { bool flag; try { //Lay Thong Tin Thuc Uong Theo TenTu Va Loai Tu THUC_UONG MonAn = new THUC_UONG(); MonAn = db.THUC_UONG.Where(u => u.TENTU == TenTU && u.LOAI_THUC_UONG.TENLOAITU == LoaiTU).SingleOrDefault(); //Lap Hoa Don if (ban.Trangthai == 1) { BAN bandb = new BAN(); bandb = db.BANs.Where(u => u.SOBAN == ban.Soban).SingleOrDefault(); bandb.TRANGTHAI = 2; db.SaveChanges(); HOA_DON hdAdd = new HOA_DON { SOBAN = ban.Soban, NGAYLAP = DateTime.Now, TRANGTHAI = 0, MANVLAP = MaNVLap }; db.HOA_DON.Add(hdAdd); db.SaveChanges(); CHI_TIET_HOA_DON cthdAdd = new CHI_TIET_HOA_DON { MAHD = hdAdd.MAHD, MATU = MonAn.MATU, SL = SoLg, GIABAN = MonAn.GIA }; db.CHI_TIET_HOA_DON.Add(cthdAdd); db.SaveChanges(); } else { HoaDonDTO mahd = db.HOA_DON.Where(u => u.SOBAN == ban.Soban && u.TRANGTHAI == 0).Select(v => new HoaDonDTO { Mahd = v.MAHD, Soban = v.SOBAN }).SingleOrDefault(); CHI_TIET_HOA_DON ctHoaDon = new CHI_TIET_HOA_DON(); if (db.CHI_TIET_HOA_DON.Where(u => u.MATU == MonAn.MATU && u.MAHD == mahd.Mahd && mahd.Soban == ban.Soban).SingleOrDefault() != null) { ctHoaDon = db.CHI_TIET_HOA_DON.Where(u => u.MATU == MonAn.MATU && u.MAHD == mahd.Mahd && mahd.Soban == ban.Soban).SingleOrDefault(); ctHoaDon.SL += SoLg; } else { ctHoaDon.MAHD = mahd.Mahd; ctHoaDon.MATU = MonAn.MATU; ctHoaDon.SL = SoLg; ctHoaDon.GIABAN = MonAn.GIA; db.CHI_TIET_HOA_DON.Add(ctHoaDon); } db.SaveChanges(); } flag = true; } catch (Exception e) { flag = false; } return(flag); }