public DataTable PostOwnerAddAcadamy([FromBody] ClubOwner_addacademy c) { System.Diagnostics.Debug.WriteLine("Inside event_Post********************************** "); DataTable result = handler.clubOwner_addacademy(c); return(result); }
public DataTable clubOwner_addacademy(ClubOwner_addacademy c) { string query = "insert into Academy (name,monthlySubscription,clubId) values ('" + c.name + "'," + c.subscription + "," + c.clubid + ")"; if (dbMan.ExecuteNonQuery(query) != 0) { query = "select *from Academy where clubid=" + c.clubid + " and monthlySubscription=" + c.subscription; return(dbMan.ExecuteReader(query)); } else { return(null); } }