C# (CSharp) ResellerClub.DataAccess AdminQuery Beispiele

Beispiel #1

 public void UpdateQuery(int queryId, string query)
 {
     using (var connection = ConnectionFactory.GetConnection())
     {
         var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
         adminQ.UpdateQuery(queryId, query);
     }
 }

Beispiel #2

 public void SaveQuery(string query)
 {
     using (var connection = ConnectionFactory.GetConnection())
     {
         var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
         adminQ.SaveQuery(query);
     }
 }

Beispiel #3

 public void DeleteQuery(int queryId)
 {
     using (var connection = ConnectionFactory.GetConnection())
     {
         var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
         adminQ.DeleteQuery(queryId);
     }
 }

Beispiel #4

        public System.Data.DataTable GetAllQuery()
        {
            DataTable dt;

            using (var connection = ConnectionFactory.GetConnection())
            {
                var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
                dt = adminQ.GetAllQuery();
            }
            return(dt);
        }

Beispiel #5

        public DataTable ExcueteQuery(string query, bool fillSchema)
        {
            DataTable dt;

            using (var connection = ConnectionFactory.GetConnection())
            {
                var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
                dt = adminQ.ExcueteQuery(query, fillSchema);
            }
            return(dt);
        }