using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Sleis.Models;
using NHibernate;
using System.Collections;
using NHibernate.Transform;

namespace Sleis.Data
{
    public class DataSetData:BaseData<BaseIdentityModel>
    {
        public IList<Dictionary<string, object>> GetDataSetByAgencyReportId(string queryString, int reportId)
        {
            using (ISession session = GetSession())
			{
                IQuery query = session.CreateSQLQuery(queryString);
                query.SetParameter("reportId", reportId);
                query.SetResultTransformer(new DictionaryResultTransformer());
                IList<Dictionary<string, object>> results = query.List<Dictionary<string, object>>();                           
                return results;
			}
			
        }
        public IList<Dictionary<string, object>> GetDataSetByFacilityId(string queryString, int facilityId)
        {
            using (ISession session = GetSession())
            {
                IQuery query = session.CreateSQLQuery(queryString);
                query.SetParameter("facilityId", facilityId);
                query.SetResultTransformer(new DictionaryResultTransformer());
                IList<Dictionary<string, object>> results = query.List<Dictionary<string, object>>();
                return results;
            }

        }
    }
    public class DictionaryResultTransformer : IResultTransformer
    { 
        public DictionaryResultTransformer() { } 
        #region IResultTransformer Members 
        public IList TransformList(IList collection) { return collection; } 
        public object TransformTuple(object[] tuple, string[] aliases) 
        { 
            var result = new Dictionary<string,object>(); 
            for (int i = 0; i < aliases.Length; i++) 
            { 
                result[aliases[i]] = tuple[i]; 
            } 
            return result; 
        } 
        #endregion
    }
}