protected string ReturnAllItems() { String strOutput = "{\"aaData\":["; var connString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; RepDayOffDAL repDayOffDal = new RepDayOffDAL(connString); var targetConfigs = repDayOffDal.GetAllTargetItems(); foreach (var item in targetConfigs) { String strEdit = "<img src='../../Images/Edit.png' onclick='Delete(" + item.Id + ")'/>"; strOutput = strOutput + "[\"" + item.Id + "\"," + "\"" + item.TargetTitle + "\"," + "\"" + Math.Truncate(item.TargetAmount) + "\"," + "\"" + item.TargetDay.ToString("dd-MM-yyyy") + "\"," + "\"" + strEdit + "\"],"; } if (targetConfigs.Count() > 0) { int Length = strOutput.Length; strOutput = strOutput.Substring(0, (Length - 1)); } strOutput = strOutput + "]}"; return(strOutput); }
public string HandleConfigTarget() { string re = ""; var connectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var targetConfig = new RepDayOffDAL(connectionString); var listConfig = targetConfig.GetAllTargetItems(); var currentDay = DateTime.Now.Date; listConfig = (from cons in listConfig where cons.TargetDay.Date == currentDay select cons).ToList(); if (listConfig.Count() > 0) { getRepName(); re = listConfig[0].TargetTitle + "," + Math.Truncate(listConfig[0].TargetAmount); } float dailyVolume = 0.0f; foreach (var pair in di_getStat) { obj_Contact = (DelReport_Contact)pair.Value; String repName = obj_Contact.FirstName + " " + obj_Contact.LastName; dailyVolume = dailyVolume + getDailyVolume(repName); } if (!string.IsNullOrEmpty(re)) { re = re + "," + dailyVolume + "," + listConfig[0].Id + "," + listConfig[0].IsReached; } return(re); }