Exemplo n.º 1
0
        public DataTable PostOwnerAddAcadamy([FromBody] ClubOwner_addacademy c)
        {
            System.Diagnostics.Debug.WriteLine("Inside event_Post********************************** ");
            DataTable result = handler.clubOwner_addacademy(c);

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