public static List<FootTraffic> ReportFTByMonth()
        {
            var dal = new FootTrafficDAL();
            var collection = new List<FootTraffic>();

            foreach (DataRow row in dal.ReportFTByMonth().Rows)
            {
                var instance = new FootTraffic();
                instance.Bind(row);
                collection.Add(instance);
            }

            return collection;
        }
 public static void InsertFootTrafficCount(FootTraffic ins)
 {
     var dal = new FootTrafficDAL();
     dal.InsertFootTrafficCount(ins);
 }
        public static List<FootTraffic> ReportFTByDay(string from, string to, int kioskid)
        {
            var dal = new FootTrafficDAL();
            var collection = new List<FootTraffic>();

            foreach (DataRow row in dal.ReportFTByDay(from, to, kioskid).Rows)
            {
                var ins = new FootTraffic();
                ins.Bind(row);
                collection.Add(ins);
            }

            return collection;
        }
        public static FootTraffic GetFTByKioskAndToday(int kioskid, string date)
        {
            var dal = new FootTrafficDAL();

            var ins = new FootTraffic();

            foreach (DataRow dr in dal.GetFTByKioskAndToday(kioskid, date).Rows)
            {
                ins.Bind(dr);
            }

            return ins;
        }