private static void GetProductivityReport(OperatorReportItems ProductivityReport, chatEntities db) { var reports = db.OperatorProductivity(website: null, visitorID: null, startDate: null, endDate: null).ToList(); // var starters = db.Messages.GroupBy(x => x.ConversationID); // SqlDataReader dr = sqlcomm.ExecuteReader(); // if (dr.Read()) foreach (var dr in reports) { OperatorReportViewModel opVM = new Models.OperatorReportViewModel(); opVM.ID = Convert.ToInt32(dr.OperatorID); opVM.Name = Convert.ToString(dr.Name); opVM.ProactiveAnswered = Convert.ToInt32(dr.ProactiveAnswered); opVM.ProactiveSent = Convert.ToInt32(dr.ProactiveSent); opVM.ProactiveResponseRate = Convert.ToInt32(dr.ProactiveResponseRate); opVM.ReactiveAnswered = Convert.ToInt32(dr.ReactiveAnswered); opVM.ReactiveReceived = Convert.ToInt32(dr.ReactiveReceived); opVM.ReactiveResponseRate = Convert.ToInt32(dr.ReactiveResponseRate); opVM.AverageChatLength = Convert.ToString(dr.AverageChatLength) + "mm"; // opVM.TotalChatLength = Convert.ToString(dr.TotalChatLength)+"mm"; TimeSpan t = TimeSpan.FromMinutes(Convert.ToDouble(dr.TotalChatLength)); string answer = string.Format("{0:D2}d:{1:D2}h:{2:D2}m", t.Days, t.Hours, t.Minutes); opVM.TotalChatLength = answer; ProductivityReport.OperatorProductivity.Add(opVM); } }
private static void GetProductivityReport(OperatorReportItems ProductivityReport, List <OperatorProductivity_Result> reports) { foreach (var dr in reports) { OperatorReportViewModel opVM = new Models.OperatorReportViewModel(); opVM.ID = Convert.ToInt32(dr.OperatorID); opVM.Name = Convert.ToString(dr.Name); opVM.ProactiveAnswered = Convert.ToInt32(dr.ProactiveAnswered); opVM.ProactiveSent = Convert.ToInt32(dr.ProactiveSent); opVM.ProactiveResponseRate = Convert.ToInt32(dr.ProactiveResponseRate); opVM.ReactiveAnswered = Convert.ToInt32(dr.ReactiveAnswered); opVM.ReactiveReceived = Convert.ToInt32(dr.ReactiveReceived); opVM.ReactiveResponseRate = Convert.ToInt32(dr.ReactiveResponseRate); opVM.AverageChatLength = Convert.ToString(dr.AverageChatLength) + "mm"; TimeSpan t = TimeSpan.FromMinutes(Convert.ToDouble(dr.TotalChatLength)); string answer = string.Format("{0:D2}d:{1:D2}h:{2:D2}m", t.Days, t.Hours, t.Minutes); opVM.TotalChatLength = answer; ProductivityReport.OperatorProductivity.Add(opVM); } }