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); } }