public DataTable Subscribe([FromBody] Player_Subscription p)
{
System.Diagnostics.Debug.WriteLine("Inside update_player********************************** ");
DataTable result = handler.SubscribeDB(p);
return(result);
}
public DataTable SubscribeDB(Player_Subscription p)
{
string query = "update Player set academyName ='" + p.aname + "' , clubId='" + p.cid + "' where userName = '******'";
if (dbMan.ExecuteNonQuery(query) != 0)
{
query = "SELECT *, 'player' AS type FROM Player WHERE userName='******' AND academyName='" + p.aname + "';";
AddAcademyIncome(p.cid);
return(dbMan.ExecuteReader(query));
}
return(null);
}
