public async Task <JsonResult> GetTicketgrid(string SDate, string EDate)
{
string TotalSolved = String.Empty; string TotalUnSolved = String.Empty; string Dates = String.Empty;
List <SolutionProvidedReportValues> IsSolvedRecordJson = new List <SolutionProvidedReportValues>();
List <PieChartSolutionResult> ResultRecordJson = new List <PieChartSolutionResult>();
try
{
string a = Convert.ToString(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
// Create the table client.
Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
// Retrieve a reference to the table.
// CloudTable table = tableClient.GetTableReference("SolutionProvidedReport");
table = tableClient.GetTableReference("TicketRaisedHistory");
await table.CreateIfNotExistsAsync();
string StartdateString = SDate;
string EnddateString = EDate;
DateTime StartDate = DateTime.Parse(StartdateString, System.Globalization.CultureInfo.InvariantCulture);
DateTime EndDate = DateTime.Parse(EnddateString, System.Globalization.CultureInfo.InvariantCulture);
List <SolutionProvidedReport> SutdentListObj = RetrieveEntity <SolutionProvidedReport>();
var SutdentListObj1 = SutdentListObj.Where(item => item.Timestamp >= StartDate && item.Timestamp <= EndDate).OrderByDescending(item => item.Timestamp).ToList();
foreach (var singleData in SutdentListObj1)
{
SolutionProvidedReportValues DataList = new SolutionProvidedReportValues();
PieChartSolutionResult resultdata = new PieChartSolutionResult();
// DataList.Department = (singleData.Key).ToString();
// DataList.Values = singleData.Count();
resultdata.EmployeeID += singleData.EmployeeID;
resultdata.TicketID += singleData.TicketID;
resultdata.SubCategory += singleData.SubCategory;
resultdata.QueryCategory += singleData.QueryCategory;
resultdata.category += singleData.Category;
resultdata.Location += singleData.Location;
resultdata.Status += singleData.Status;
resultdata.Description += singleData.Description;
resultdata.Dates += Convert.ToDateTime(singleData.Timestamp.DateTime).ToString("dd-MMM-yyyy");
ResultRecordJson.Add(resultdata);
}
}
catch (Exception ex)
{
Utility.Utility.GenrateLog(ex.Message);
}
finally
{
}
var output = JsonConvert.SerializeObject(ResultRecordJson);
// var resultData = new {TotalSolved = TotalSolved, TotalUnSolved = TotalUnSolved, Dates = Dates };
// return Json(resultData, JsonRequestBehavior.AllowGet);
//return Json(c, JsonRequestBehavior.AllowGet);
return(Json(output, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> GetIsSolvedReport(string SDate, string EDate)
{
string TotalSolved = String.Empty; string TotalUnSolved = String.Empty; string Dates = String.Empty;
List <SolutionProvidedReportValues> IsSolvedRecordJson = new List <SolutionProvidedReportValues>();
List <SolutionResult> ResultRecordJson = new List <SolutionResult>();
try
{
string a = Convert.ToString(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
table = tableClient.GetTableReference("SolutionProvidedReport");
await table.CreateIfNotExistsAsync();
string StartdateString = SDate; //"2018-10-25T00:00:00.000Z";
string EnddateString = EDate; // "2018-11-10T00:00:00.000Z";
DateTime StartDate = DateTime.Parse(StartdateString, System.Globalization.CultureInfo.InvariantCulture);
DateTime EndDate = DateTime.Parse(EnddateString, System.Globalization.CultureInfo.InvariantCulture);
List <SolutionProvidedReport> SutdentListObj = RetrieveEntity <SolutionProvidedReport>();
var SutdentListObj1 = SutdentListObj.Where(item => item.Timestamp >= StartDate && item.Timestamp <= EndDate).OrderByDescending(item => item.Timestamp).GroupBy(item => item.Timestamp.Date).ToList();
foreach (var singleData in SutdentListObj1)
{
SolutionProvidedReportValues DataList = new SolutionProvidedReportValues();
SolutionResult resultdata = new SolutionResult();
DataList.Timestamp1 = (singleData.Key).ToString();
foreach (var result in singleData)
{
if (result.IsSolved == true)
{
DataList.isSolvedTrue += 1;
}
else
{
DataList.isSolvedFalse += 1;
}
}
resultdata.TotalSolved += DataList.isSolvedTrue; //+ ", ";
resultdata.TotalUnSolved += DataList.isSolvedFalse; // + ", ";
resultdata.Dates += Convert.ToDateTime(DataList.Timestamp1).ToString("dd MMM"); // + ", ";
ResultRecordJson.Add(resultdata);
//IsSolvedRecordJson.Add(DataList);
}
}
catch (Exception ex)
{
Utility.Utility.GenrateLog(ex.Message);
}
finally
{
}
var output = JsonConvert.SerializeObject(ResultRecordJson);
return(Json(output, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> GetTop10DetectedIntent(string SDate, string EDate)
{
string TotalSolved = String.Empty; string TotalUnSolved = String.Empty; string Dates = String.Empty;
List <SolutionProvidedReportValues> IsSolvedRecordJson = new List <SolutionProvidedReportValues>();
List <SolutionResult> ResultRecordJson = new List <SolutionResult>();
try
{
string a = Convert.ToString(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
// Create the table client.
Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
// Retrieve a reference to the table.
// CloudTable table = tableClient.GetTableReference("SolutionProvidedReport");
table = tableClient.GetTableReference("SolutionProvidedReport");
await table.CreateIfNotExistsAsync();
string StartdateString = SDate;
string EnddateString = EDate;
DateTime StartDate = DateTime.Parse(StartdateString, System.Globalization.CultureInfo.InvariantCulture);
DateTime EndDate = DateTime.Parse(EnddateString, System.Globalization.CultureInfo.InvariantCulture);
List <SolutionProvidedReport> SutdentListObj = RetrieveEntity <SolutionProvidedReport>();
var SutdentListObj1 = SutdentListObj.Where(item => item.Timestamp >= StartDate && item.Timestamp <= EndDate).OrderByDescending(item => item.Timestamp).GroupBy(item => item.DetectedIntent).Take(10).OrderByDescending(g => g.Count()).ToList();
foreach (var singleData in SutdentListObj1)
{
SolutionProvidedReportValues DataList = new SolutionProvidedReportValues();
SolutionResult resultdata = new SolutionResult();
DataList.DetectedIntent = (singleData.Key).ToString();
DataList.Values = singleData.Count();
resultdata.DetectedIntent += DataList.DetectedIntent;
resultdata.DetectedIntentCount += DataList.Values;
ResultRecordJson.Add(resultdata);
}
}
catch (Exception ex)
{
Utility.Utility.GenrateLog(ex.Message);
}
finally
{
}
var output = JsonConvert.SerializeObject(ResultRecordJson);
return(Json(output, JsonRequestBehavior.AllowGet));
}
public ActionResult Top10DetectedIntentExport(string SDate, string EDate)
{
string TotalSolved = String.Empty; string TotalUnSolved = String.Empty; string Dates = String.Empty;
List <SolutionProvidedReportValues> IsSolvedRecordJson = new List <SolutionProvidedReportValues>();
List <SolutionResult> ResultRecordJson = new List <SolutionResult>();
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("DetectedIntent");
dt.Columns.Add("DetectedIntentCount");
try
{
string a = Convert.ToString(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
table = tableClient.GetTableReference("SolutionProvidedReport");
string StartdateString = SDate; //"2018-10-25T00:00:00.000Z";
string EnddateString = EDate; //"2018-11-10T00:00:00.000Z";
DateTime StartDate = DateTime.Parse(StartdateString, System.Globalization.CultureInfo.InvariantCulture);
DateTime EndDate = DateTime.Parse(EnddateString, System.Globalization.CultureInfo.InvariantCulture);
List <SolutionProvidedReport> SutdentListObj = RetrieveEntity <SolutionProvidedReport>();
var SutdentListObj1 = SutdentListObj.Where(item => item.Timestamp >= StartDate && item.Timestamp <= EndDate).OrderByDescending(item => item.Timestamp).GroupBy(item => item.DetectedIntent).Take(10).OrderByDescending(g => g.Count()).ToList();
foreach (var singleData in SutdentListObj1)
{
SolutionProvidedReportValues DataList = new SolutionProvidedReportValues();
DataList.DetectedIntent = (singleData.Key).ToString();
DataList.Values = singleData.Count();
DataRow _rvi = dt.NewRow();
_rvi["DetectedIntent"] = DataList.DetectedIntent;
_rvi["DetectedIntentCount"] = DataList.Values;
dt.Rows.Add(_rvi);
}
}
catch (Exception ex)
{
Utility.Utility.GenrateLog(ex.Message);
}
finally
{
}
if (dt.Rows.Count > 0)
{
ExcelExport(dt, SDate, EDate, "TOP10DetectedIntent");
}
return(Redirect("/top10/top10"));
}
