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