public bool ThanhToan(BanDTO ban, double tongTien)
{
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();
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);
}
public bool ChuyenBan(BanDTO banHienTai, string TenBanMoi, int ManvLap)
{
try
{
BAN banMoi = db.BANs.Where(u => u.TENBAN == TenBanMoi && u.TRANGTHAI != 0).SingleOrDefault();
BAN banCu = db.BANs.Where(u => u.SOBAN == banHienTai.Soban && u.TRANGTHAI != 0).SingleOrDefault();
if (banMoi.TRANGTHAI == 1) // Bàn Chưa có người
{
banCu.TRANGTHAI = 1;
banMoi.TRANGTHAI = 2;
HOA_DON hd = new HOA_DON();
hd = db.HOA_DON.Where(u => u.SOBAN == banHienTai.Soban && u.TRANGTHAI == 0).SingleOrDefault();
hd.SOBAN = banMoi.SOBAN;
db.SaveChanges();
}
else //Ban Có Người
{
banCu.TRANGTHAI = 1;
//Lay
HOA_DON hd = new HOA_DON();
hd = db.HOA_DON.Where(u => u.SOBAN == banMoi.SOBAN && u.TRANGTHAI == 0).SingleOrDefault();
// ThemVao Database
int MaHDCU = db.HOA_DON.Where(u => u.SOBAN == banHienTai.Soban && u.TRANGTHAI == 0).SingleOrDefault().MAHD;
List <ChiTietHoaDonDTO> listCTHDCU = db.CHI_TIET_HOA_DON.Where(u => u.MAHD == MaHDCU).Select(v => new
ChiTietHoaDonDTO {
Mahd = v.MAHD,
Giaban = v.GIABAN,
Matu = v.MATU,
Tentu = v.THUC_UONG.TENTU,
Soluong = v.SL
}).ToList();
//
BanDTO bDTO = new BanDTO {
Soban = banMoi.SOBAN, Socho = banMoi.SOCHO, Tenban = banMoi.TENBAN, Trangthai = banMoi.TRANGTHAI
};
foreach (ChiTietHoaDonDTO cthd in listCTHDCU)
{
int MaLoaiTu = db.THUC_UONG.Where(u => u.MATU == cthd.Matu).SingleOrDefault().MALOAITU;
string TenLoaiTU = db.LOAI_THUC_UONG.Where(u => u.MALOAITU == MaLoaiTu).SingleOrDefault().TENLOAITU;
if (ThemThucUongTheoBan(bDTO, ManvLap, cthd.Tentu, TenLoaiTU, cthd.Soluong))
{
}
}
// sau khi add vao hd moi hd cu bi huy bo
HOA_DON HDCU = new HOA_DON();
List <CHI_TIET_HOA_DON> CTHDCU = new List <CHI_TIET_HOA_DON>();
HDCU = db.HOA_DON.Where(u => u.SOBAN == banHienTai.Soban && u.TRANGTHAI == 0).SingleOrDefault();
CTHDCU = db.CHI_TIET_HOA_DON.Where(u => u.MAHD == HDCU.MAHD).ToList();
db.CHI_TIET_HOA_DON.RemoveRange(CTHDCU);
db.SaveChanges();
db.HOA_DON.Remove(HDCU);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}