public GameGuideItem GameGuideGetOne(int id)
{
var item = new GameGuideItem();
string sql = "SELECT * FROM [portal].[dbo].gameGuide WHERE id = @id";
SqlConnection conn = new SqlConnection(Constants.DBConnection);
SqlCommand MyCommand = new SqlCommand(sql, conn);
MyCommand.Parameters.AddWithValue("id", id);
SqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
while (MyReader.Read())
{
item = new GameGuideItem
{
id = MyReader.GetInt32(MyReader.GetOrdinal("id")),
description = MyReader.GetString(MyReader.GetOrdinal("description")),
game_id = MyReader.GetInt32(MyReader.GetOrdinal("game_id")),
};
}
MyReader.Close();
conn.Close();
return(item);
}
public List <GameGuideItem> GameGuideGetAll()
{
var lst = new List <GameGuideItem>();
string sql = "SELECT gui.*, ga.Name FROM [portal].[dbo].gameGuide gui LEFT JOIN [portal].[dbo].game ga ON ga.ID = gui.game_id ORDER BY gui.id DESC";
SqlConnection conn = new SqlConnection(Constants.DBConnection);
SqlCommand MyCommand = new SqlCommand(sql, conn);
SqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
while (MyReader.Read())
{
var item = new GameGuideItem
{
id = MyReader.GetInt32(MyReader.GetOrdinal("id")),
game = MyReader.GetString(MyReader.GetOrdinal("Name")),
description = MyReader.GetString(MyReader.GetOrdinal("description")),
game_id = MyReader.GetInt32(MyReader.GetOrdinal("game_id")),
};
lst.Add(item);
}
MyReader.Close();
conn.Close();
return(lst);
}
public int GameGuideInsert(GameGuideItem obj)
{
var rs = 0;
string sql = "INSERT INTO [portal].[dbo].gameGuide(description, game_id) VALUES(@description, @game_id)";
SqlConnection conn = new SqlConnection(Constants.DBConnection);
SqlCommand MyCommand = new SqlCommand(sql, conn);
MyCommand.Parameters.AddWithValue("description", obj.description);
MyCommand.Parameters.AddWithValue("game_id", obj.game_id);
conn.Open();
rs = MyCommand.ExecuteNonQuery();
conn.Close();
return(rs);
}
/*end*/
#region game guide
public int GameGuideUpdate(GameGuideItem obj)
{
var rs = 0;
string sql = "UPDATE [portal].[dbo].gameGuide set description = @description, game_id = @game_id where id = @id";
SqlConnection conn = new SqlConnection(Constants.DBConnection);
SqlCommand MyCommand = new SqlCommand(sql, conn);
MyCommand.Parameters.AddWithValue("description", obj.description.Replace("'", "\""));
MyCommand.Parameters.AddWithValue("game_id", obj.game_id);
MyCommand.Parameters.AddWithValue("id", obj.id);
conn.Open();
rs = MyCommand.ExecuteNonQuery();
conn.Close();
return(rs);
}
public ActionResult Action(GameGuideItem objSubmit)
{
if (objSubmit.id == 0)
{
gamePlayerRepository.GameGuideInsert(objSubmit);
}
else
{
gamePlayerRepository.GameGuideUpdate(objSubmit);
}
return(Json(new
{
Error = false
}, JsonRequestBehavior.AllowGet));
}
public ActionResult EditForm(int?id)
{
var obj = new GameGuideItem();
obj.game_id = 0;
obj.id = 0;
var listGame = gamePlayerRepository.GetAllGame();
if (id.HasValue)
{
obj = gamePlayerRepository.GameGuideGetOne(id.Value);
}
return(Json(new
{
data = obj,
listGame = listGame
}, JsonRequestBehavior.AllowGet));
}
