public IActionResult Index() { List <bans> BANSS = new List <bans>(); List <HoaDon> hds = new List <HoaDon>(); hds = db.HoaDons.Include(x => x.KhanhHang).Where(p => p.TrangThaiID == 7).ToList(); List <ChiTietHd> cts = new List <ChiTietHd>(); foreach (var item in hds) { bans bans = new bans(); List <mon> listmonss = new List <mon>(); List <ChiTietHd> ct = new List <ChiTietHd>(); ct = db.ChiTietHds.Include(x => x.MonAn).Where(p => p.HoaDonID == item.HoaDonID).ToList(); foreach (var tmp in ct) { mon mon = new mon(); mon.BanID = item.BanID; mon.KhachHangID = item.KhanhHang.TenKh; mon.MonAnId = tmp.MonAn.TenMon; mon.soluong = tmp.SoLuong; listmonss.Add(mon); } bans.listmons = listmonss; bans.MaHD = item.HoaDonID; BANSS.Add(bans); } ViewData["KhachHangID"] = new SelectList(db.khachHangs, "KhachHangID", "TenKh"); ViewData["MonAnID"] = new SelectList(db.MonAns, "MonAnID", "TenMon"); return(View(BANSS)); }
public void UnbanPlayer(string playerName) { using (var db = ghostEntities.Create()) { bans banData = db.bans.Single(x => x.name.Equals(playerName, StringComparison.InvariantCultureIgnoreCase)); db.bans.Remove(banData); db.SaveChanges(); } }
public void BanPlayer(PlayerBanData playerBanData) { using (var db = ghostEntities.Create()) { if (playerBanData.IpAddresses.Any()) { foreach (string ipAddress in playerBanData.IpAddresses) { bans ban = new bans { id = 300, name = playerBanData.PlayerName, admin = playerBanData.Admin, reason = playerBanData.Reason, ip = ipAddress, botid = 1, date = DateTime.Now, server = "", gamename = "" }; db.bans.Add(ban); } } else { bans ban = new bans { name = playerBanData.PlayerName, admin = playerBanData.Admin, reason = playerBanData.Reason, botid = 1, date = DateTime.Now, server = "", gamename = "", ip = "" }; db.bans.Add(ban); } db.Database.CommandTimeout = 300; db.SaveChanges(); } }