public BXH GetTop10()
{
cnn.Open();
SqlCommand com = new SqlCommand("select top 10 * from BangXepHang order by SoDiem desc", cnn);
com.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(com);
DataTable tb = new DataTable();
com.ExecuteNonQuery();
adapter.Fill(tb);
BXH bxh = new BXH();
Playerlist list = new Playerlist();
for (int i = 0; i < tb.Rows.Count; i++)
{
DateTime date = (DateTime)tb.Rows[i][1];
Player player = new Player(tb.Rows[i][0].ToString(), Int32.Parse(tb.Rows[i][2].ToString()), date.ToString());
list.AddPlayer(player);
}
bxh.ListPlayer = list;
cnn.Close();
return(bxh);
}
public ActionResult DeleteConfirmed(string id, string idd)
{
BXH bXH = db.BXHs.Find(id, idd);
db.BXHs.Remove(bXH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void Rank_Load(object sender, EventArgs e)
{
RankBUS rank = new RankBUS();
BXH bxh = rank.GetTop10();
for (int i = 0; i < bxh.ListPlayer.ListPLayer.Count; i++)
{
listBoxRank.Items.Add(bxh.ListPlayer.ListPLayer[i].Nickname);
listBoxRank2.Items.Add(bxh.ListPlayer.ListPLayer[i].Point);
}
}
public ActionResult Edit([Bind(Include = "MaDoi,MaMua,TongHieuSo,SoTranThang,SoTranThua,SoTranHoa,BanThangSanKhach")] BXH bXH)
{
if (ModelState.IsValid)
{
db.Entry(bXH).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaMua = new SelectList(db.MUAGIAIs, "MaMua", "TenMua", bXH.MaMua);
return(View(bXH));
}
// GET: BXH/Edit/5
public ActionResult Edit(string id, string idd)
{
if (id == null || idd == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BXH bXH = db.BXHs.Find(id, idd);
if (bXH == null)
{
return(HttpNotFound());
}
ViewBag.MaMua = new SelectList(db.MUAGIAIs, "MaMua", "TenMua", bXH.MaMua);
return(View(bXH));
}
// GET: BXH/Details/5
public ActionResult Details(string id, string idd)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BXH bXH = db.BXHs.Find(id, idd);
if (bXH == null)
{
return(HttpNotFound());
}
return(View(bXH));
}
