public DataTable PostOwnerEvent([FromBody] ClubOwner_event e)
{
System.Diagnostics.Debug.WriteLine("Inside event_Post********************************** ");
DataTable result = handler.clubOwner_event(e);
return(result);
}
public DataTable clubOwner_event(ClubOwner_event c)
{
string query = "Insert into Event (clubId,name,startTime,endTime,noOfTeams,noOfTeamMembers,availablePlaces,prize,pricePerTeam) " +
" VALUES (" + c.clubid + ",'" + c.name + "','" + c.event_start_time.ToString("yyyy-MM-dd hh:mm:00.000")
+ "','" + c.event_end_time.ToString("yyyy-MM-dd hh:mm:00.000") + "'," + c.noofteams + "," + c.noofteammembers
+ "," + c.availableplaces + "," + c.prize + "," + c.priceperteam + ")";
if (dbMan.ExecuteNonQuery(query) != 0)
{
query = "SELECT * FROM Event WHERE clubId=" + c.clubid + " AND startTime='"
+ c.event_start_time.ToString("yyyy-MM-dd hh:mm:00.000") + "' AND endTime='"
+ c.event_end_time.ToString("yyyy-MM-dd hh:mm:00.000") + "';";
return(dbMan.ExecuteReader(query));
}
else
{
return(null);
}
}
