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);
}