public void UpdateQuery(int queryId, string query)
{
using (var connection = ConnectionFactory.GetConnection())
{
var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
adminQ.UpdateQuery(queryId, query);
}
}
public void SaveQuery(string query)
{
using (var connection = ConnectionFactory.GetConnection())
{
var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
adminQ.SaveQuery(query);
}
}
public void DeleteQuery(int queryId)
{
using (var connection = ConnectionFactory.GetConnection())
{
var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
adminQ.DeleteQuery(queryId);
}
}
public System.Data.DataTable GetAllQuery()
{
DataTable dt;
using (var connection = ConnectionFactory.GetConnection())
{
var adminQ = new ResellerClub.DataAccess.AdminQuery(connection);
dt = adminQ.GetAllQuery();
}
return(dt);
}
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);
}
