public DataTable PostOwnerUpdateAcademy([FromBody] ClubOwner_academy a) { System.Diagnostics.Debug.WriteLine("Inside event_Post********************************** "); DataTable result = handler.clubOwner_academy(a); return(result); }
public DataTable clubOwner_academy(ClubOwner_academy c) { string query = "Update Academy set monthlySubscription =" + c.subscription + " where clubId =" + 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); } }