public DataTable enrollEvent(Player_Enrollment p)
{
int cid = p.cid;
int eid = p.eid;
string username = p.username;
string query = "select availableplaces from event where eventId = '" + eid + "'and clubId = '" + cid + "'";
int available = (int)dbMan.ExecuteScalar(query);
if (available > 0)
{
query = "insert into Participate values('" + username + "', '" + eid + "', '" + cid + "')";
if (dbMan.ExecuteNonQuery(query) == 1)
{
available--;
query = "update event set availableplaces = '" + available + "' where clubId = '" + cid + "' and eventId = '" + eid + "';";
dbMan.ExecuteNonQuery(query);
AddEventIncome(cid, eid);
query = "select * from Participate where clubId = '" + cid + "' and eventId = '" + eid + "' and playerUserName = '******';";
return(dbMan.ExecuteReader(query));
}
else
{
return(null);
}
}
else
{
return(null);
}
}
public DataTable Enroll([FromBody] Player_Enrollment p)
{
System.Diagnostics.Debug.WriteLine("Inside Player_Post********************************** ");
DataTable result = handler.enrollEvent(p);
return(result);
}
