Esempio n. 1
0
        public DataTable PostOwnerUpdateAcademy([FromBody] ClubOwner_academy a)
        {
            System.Diagnostics.Debug.WriteLine("Inside event_Post********************************** ");
            DataTable result = handler.clubOwner_academy(a);

            return(result);
        }
Esempio n. 2
0
        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);
            }
        }