protected string ReturnAllItems()
        {
            String strOutput = "{\"aaData\":[";

            var          connString  = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            RepDayOffDAL dal         = new RepDayOffDAL(connString);
            var          getallNames = dal.GetAttendanceReps();
            var          count       = 0;

            foreach (var item in getallNames)
            {
                count = count + 1;
                string c = "<img src='../Images/error.png' onclick='DeleteCal(" + item.Id + ")'/>";
                strOutput = strOutput + "[\"" + item.Id + "\"," + "\"" + item.Name + "\"," + "\"" + c + "\"],";
            }

            if (getallNames.Count() > 0)
            {
                int Length = strOutput.Length;
                strOutput = strOutput.Substring(0, (Length - 1));
            }
            strOutput = strOutput + "]}";

            return(strOutput);
        }
        private List <string> SetRepList()
        {
            var listRep = new List <string>();
            //listRep.Add("AIDAN");
            //listRep.Add("BAILEY"); listRep.Add("BRENDAN"); listRep.Add("DIMITRI"); listRep.Add("EMMA");
            //listRep.Add("JOHN"); listRep.Add("KRIT"); listRep.Add("TARAS");
            //listRep.Add("CHRISTINE"); listRep.Add("ALEC"); listRep.Add("JOE");
            //listRep.Add("JOSIAH"); listRep.Add("LACHLAN"); listRep.Add("PHIL"); listRep.Add("FARAH"); listRep.Add("ACCOUNTS");
            //listRep.Add("TRENT"); listRep.Add("PARTI");
            //listRep.Add("SOPHIE");

            var          connString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
            RepDayOffDAL dal        = new RepDayOffDAL(connString);
            var          listRepa   = dal.GetAttendanceReps();

            foreach (var item in listRepa)
            {
                listRep.Add(item.Name);
            }

            return(listRep);
        }