public bool XoaTU(int maTU) { try { THUC_UONG tuDB = db.THUC_UONG.SingleOrDefault(p => p.MATU == maTU && p.TRANGTHAIXOA == false); tuDB.TRANGTHAIXOA = true; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public bool SuaTU(ThucUongDTO tu) { try { THUC_UONG tuDB = db.THUC_UONG.SingleOrDefault(p => p.MATU == tu.Matu && p.TRANGTHAIXOA == false); tuDB.TENTU = tu.Tentu; tuDB.MALOAITU = tu.Maloaitu; tu.Gia = tu.Gia; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public bool ThemTU(ThucUongDTO tu) { try { THUC_UONG tuDB = new THUC_UONG { TENTU = tu.Tentu, MALOAITU = tu.Maloaitu, GIA = tu.Gia }; db.THUC_UONG.Add(tuDB); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
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); }