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();
}
}
