public static List<DanhSachGame_DTO> FindGame(String sTen) { try { SqlConnection connection = SQLDBConnection.CreateSQlConnection(); String cmdStr = String.Format(@"SELECT * FROM TROCHOI WHERE TEN LIKE N'%{0}%'", sTen); SqlCommand cmd = new SqlCommand(cmdStr, connection); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); connection.Close(); List<DanhSachGame_DTO> lGame = new List<DanhSachGame_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { DanhSachGame_DTO Game = new DanhSachGame_DTO(); Game.Ma = dt.Rows[i]["Ma"].ToString(); Game.Ten = dt.Rows[i]["Ten"].ToString(); Game.NguoiChoi = int.Parse(dt.Rows[i]["NguoiChoi"].ToString()); Game.TheLoai = dt.Rows[i]["TheLoai"].ToString(); Game.GhiChu = dt.Rows[i]["GhiChu"].ToString(); lGame.Add(Game); } return lGame; } catch { return null; } }
public static List<DanhSachGame_DTO> FindGameMay(String sTen, String sMaMay) { try { SqlConnection connection = SQLDBConnection.CreateSQlConnection(); String cmdStr = String.Empty; if (sMaMay == "Tất cả") { cmdStr = String.Format(@"SELECT * FROM TROCHOI TC, GAME_MAY GM WHERE TC.TEN LIKE N'%{0}%' AND GM.MAGAME = TC.MA", sTen); } else { cmdStr = String.Format(@"SELECT * FROM TROCHOI TC, GAME_MAY GM WHERE TC.TEN LIKE N'%{0}%' AND GM.MAMAY = N'{1}' AND GM.MAGAME = TC.MA", sTen, sMaMay); } SqlCommand cmd = new SqlCommand(cmdStr, connection); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dt = new DataTable(); adapter.Fill(dt); connection.Close(); List<DanhSachGame_DTO> lGame = new List<DanhSachGame_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { DanhSachGame_DTO Game = new DanhSachGame_DTO(); Game.Ten = dt.Rows[i]["Ten"].ToString(); Game.NguoiChoi = int.Parse(dt.Rows[i]["NguoiChoi"].ToString()); Game.TheLoai = dt.Rows[i]["TheLoai"].ToString(); Game.MaMay = dt.Rows[i]["MaMay"].ToString(); Game.GhiChu = dt.Rows[i]["GhiChu"].ToString(); lGame.Add(Game); } return lGame; } catch (Exception EX) { throw EX; return null; } }
public static List<DanhSachGame_DTO> SelectDanhSachGame_May(String sMaMay) { try { SqlConnection connection = SQLDBConnection.CreateSQlConnection(); SqlCommand command = connection.CreateCommand(); command.CommandText = String.Format("SELECT * FROM TROCHOI G, GAME_MAY GM WHERE G.MA = GM.MAGAME AND GM.MAMAY = {0}", sMaMay); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; DataTable dt = new DataTable(); adapter.Fill(dt); connection.Close(); List<DanhSachGame_DTO> lGame = new List<DanhSachGame_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { DanhSachGame_DTO Game = new DanhSachGame_DTO(); Game.Ma = dt.Rows[i]["Ma"].ToString(); Game.Ten = dt.Rows[i]["Ten"].ToString(); Game.NguoiChoi = int.Parse(dt.Rows[i]["NguoiChoi"].ToString()); Game.TheLoai = dt.Rows[i]["TheLoai"].ToString(); Game.GhiChu = dt.Rows[i]["GhiChu"].ToString(); lGame.Add(Game); } return lGame; } catch { return null; } }
public static List<DanhSachGame_DTO> SelectDanhSachGame() { try { SqlConnection connection = SQLDBConnection.CreateSQlConnection(); SqlCommand command = connection.CreateCommand(); //int MaMay = int.Parse(this.cbMay.SelectedValue.ToString()); command.CommandText = "SELECT * FROM TROCHOI"; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; DataTable dt = new DataTable(); adapter.Fill(dt); connection.Close(); List<DanhSachGame_DTO> lGame = new List<DanhSachGame_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { DanhSachGame_DTO Game = new DanhSachGame_DTO(); Game.Ma = dt.Rows[i]["Ma"].ToString(); Game.Ten = dt.Rows[i]["Ten"].ToString(); Game.NguoiChoi = int.Parse(dt.Rows[i]["NguoiChoi"].ToString()); Game.TheLoai = dt.Rows[i]["TheLoai"].ToString(); Game.GhiChu = dt.Rows[i]["GhiChu"].ToString(); lGame.Add(Game); } return lGame; } catch { return null; } }