private static void UpdatelocalDB(string suppliercallref, int callid, string pathwaysreturnedid)
{
try
{
clsCall objCall = new clsCall(System.Configuration.ConfigurationSettings.AppSettings["WsBaseURL"].ToString().Trim());
objCall.InsertUploadedPathwaysReportData(suppliercallref, callid, pathwaysreturnedid);
}
catch (Exception ee)
{
ErrorLogger.WriteError("UploadReportService", "UpdatelocalDB", ee.ToString());
}
}
private async Task SerializePathWaysData()
{
try
{
clsCall objcall = new clsCall(System.Configuration.ConfigurationSettings.AppSettings["WsBaseURL"].ToString().Trim());
DataSet ds = new DataSet();
ds = objcall.GetPathWaysReportData(new DateTime(2015, 12, 04), new DateTime(2015, 11, 25));
if (ds.Tables[0].Rows.Count > 0)
{
RemoveTimezoneForDataSet(ds);
ErrorLogger.WriteActivity("", "", "Operation started");
var myResult = ds.Tables[0].AsEnumerable().Select(c => c["CallID"]).Distinct().ToList();
Task <Boolean>[] objtaskss = new Task <Boolean> [myResult.Count];
for (int j = 0; j < myResult.Count; j++)
{
clsPathWaysCaseRecord objCaseRecord = new clsPathWaysCaseRecord();
//objCaseRecord.siteId = 21;
//objCaseRecord.supplierCallRef = ds.Tables[0].Rows[0]["suppliercallRef"].ToString().Trim();
////objCaseRecord.chSkillsetId = Convert.ToInt16(ds.Tables[0].Rows[0]["skillsetid"].ToString().Trim());
////objCaseRecord.chUserCode = ds.Tables[0].Rows[0]["userID"].ToString().Trim();
////objCaseRecord.clSkillsetId = Convert.ToInt16(ds.Tables[0].Rows[0]["skillsetid"].ToString().Trim());
//objCaseRecord.ageGroupId = Convert.ToInt16(ds.Tables[0].Rows[0]["ageGroupID"].ToString().Trim());
//objCaseRecord.genderId = Convert.ToInt16(ds.Tables[0].Rows[0]["GenderID"].ToString().Trim());
//objCaseRecord.partyId = Convert.ToInt16(ds.Tables[0].Rows[0]["PartyID"].ToString().Trim());
//objCaseRecord.releaseVersion = ds.Tables[0].Rows[0]["releaseVersion"].ToString().Trim();
//objCaseRecord.postcode = ds.Tables[0].Rows[0]["postCode"].ToString().Trim();
int callid = Convert.ToInt32(myResult[j].ToString());
DataView dv = new DataView(ds.Tables[0], "CallID=" + callid.ToString(), "Callid", DataViewRowState.CurrentRows);
int questionscount = dv.Count;
objCaseRecord.siteId = Convert.ToInt16(System.Configuration.ConfigurationSettings.AppSettings["siteid"].ToString().Trim());
objCaseRecord.supplierCallRef = dv[0]["suppliercallRef"].ToString().Trim();
if (ds.Tables[0].Rows[0]["skillsetid"].ToString().Trim() == "3")
{
objCaseRecord.chSkillsetId = Convert.ToInt16(dv[0]["skillsetid"].ToString().Trim());
objCaseRecord.chCallStartTime = Convert.ToDateTime(dv[0]["callstarttime"].ToString().Trim()).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.chCallEndTime = Convert.ToDateTime(dv[0]["DispoTime"]).AddSeconds(4).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.chDispoTime = Convert.ToDateTime(dv[0]["DispoTime"]).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.chTriageDispoCode = dv[0]["TriageDispositionCode"].ToString().Trim();
objCaseRecord.chFinalDispoCode = dv[0]["FinalDispositionCode"].ToString().Trim();
objCaseRecord.chUserCode = dv[0]["UserID"].ToString().Trim();
objCaseRecord.chTriageStartTime = Convert.ToDateTime(dv[0]["timein"].ToString().Trim()).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.chTriageEndTime = Convert.ToDateTime(dv[0]["DispoTime"]).AddSeconds(2).ToString("yyyy-MM-ddTHH:mm:ssK");
}
else
{
objCaseRecord.clSkillsetId = Convert.ToInt16(dv[0]["skillsetid"].ToString().Trim());
objCaseRecord.clCallStartTime = Convert.ToDateTime(dv[0]["callstarttime"].ToString().Trim()).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.clCallEndTime = Convert.ToDateTime(dv[0]["DispoTime"]).AddSeconds(4).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.clDispoTime = Convert.ToDateTime(dv[0]["DispoTime"]).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.clTriageDispoCode = dv[0]["TriageDispositionCode"].ToString().Trim();
objCaseRecord.clFinalDispoCode = dv[0]["FinalDispositionCode"].ToString().Trim();
objCaseRecord.clUserCode = dv[0]["UserID"].ToString().Trim();
objCaseRecord.clTriageStartTime = Convert.ToDateTime(dv[0]["timein"].ToString().Trim()).ToString("yyyy-MM-ddTHH:mm:ssK");
objCaseRecord.clTriageEndTime = Convert.ToDateTime(dv[0]["DispoTime"]).AddSeconds(2).ToString("yyyy-MM-ddTHH:mm:ssK");
//objCaseRecord.clSkillsetId = Convert.ToInt16(dv[0]["skillsetid"].ToString().Trim());
//objCaseRecord.clCallStartTime = Convert.ToDateTime(dv[0]["callstarttime"].ToString().Trim()).ToString("yyyy-MM-ddTHH:mm:ssK");
//objCaseRecord.clCallEndTime = Convert.ToDateTime(dv[0]["callendtime"]).ToString("yyyy-MM-ddTHH:mm:ssK");
//objCaseRecord.clDispoTime = Convert.ToDateTime(dv[0]["DispoTime"]).ToString("yyyy-MM-ddTHH:mm:ssK");
//objCaseRecord.clTriageDispoCode = dv[0]["TriageDispositionCode"].ToString().Trim();
//objCaseRecord.clFinalDispoCode = dv[0]["FinalDispositionCode"].ToString().Trim();
//objCaseRecord.clUserCode = dv[0]["UserID"].ToString().Trim();
//objCaseRecord.clTriageStartTime = Convert.ToDateTime(dv[0]["timein"]).AddMilliseconds(-10).ToString("yyyy-MM-ddTHH:mm:ssK");
//objCaseRecord.clTriageEndTime = Convert.ToDateTime(dv[questionscount - 1]["timeout"]).AddMilliseconds(10).ToString("yyyy-MM-ddTHH:mm:ssK");
}
// objCaseRecord.chSkillsetId = Convert.ToInt16(ds.Tables[0].Rows[0]["skillsetid"].ToString().Trim());
//objCaseRecord.chUserCode = ds.Tables[0].Rows[0]["userID"].ToString().Trim();
//objCaseRecord.clSkillsetId = Convert.ToInt16(ds.Tables[0].Rows[0]["skillsetid"].ToString().Trim());
objCaseRecord.ageGroupId = Convert.ToInt16(dv[0]["ageGroupID"].ToString().Trim());
objCaseRecord.genderId = Convert.ToInt16(dv[0]["GenderID"].ToString().Trim());
objCaseRecord.partyId = Convert.ToInt16(dv[0]["PartyID"].ToString().Trim());
objCaseRecord.releaseVersion = dv[0]["releaseVersion"].ToString().Trim();
objCaseRecord.postcode = dv[0]["postCode"].ToString().Trim();
List <clsTriageItem> lsttriageitems = new List <clsTriageItem>();
for (int i = 0; i < dv.Count; i++)
{
lsttriageitems.Add(new clsTriageItem
{
userCode = dv[i]["UserID"].ToString().Trim(),
timeIn = Convert.ToDateTime(dv[i]["timeIn"]).ToString("yyyy-MM-ddTHH:mm:ssK").Trim(),
timeOut = Convert.ToDateTime(dv[i]["timeOut"]).ToString("yyyy-MM-ddTHH:mm:ssK").Trim(),
pwId = dv[i]["PWID"].ToString().Trim(),
orderNo = Convert.ToInt32(dv[i]["OrderNo"].ToString().Trim()),
quID = dv[i]["QuID"].ToString().Trim(),
answerNo = Convert.ToInt16(dv[i]["AnswerNo"].ToString().Trim()),
userComment = dv[i]["UserComment"].ToString().Trim(),
actionId = Convert.ToInt16(dv[i]["ActionID"].ToString().Trim())
});
}
objCaseRecord.listOfTriageItems = lsttriageitems;
var json = new JavaScriptSerializer().Serialize(objCaseRecord);
//Boolean result = await Posttoserver(objCaseRecord, Convert.ToInt32(myResult[j].ToString().Trim()));
objtaskss[j] = Posttoserver(objCaseRecord, Convert.ToInt32(myResult[j].ToString().Trim()));
//if (result)
//{
// UpdatelocalDB(objCaseRecord.supplierCallRef, Convert.ToInt32(myResult[j].ToString().Trim()), createdcaseid);
//}
}
await Task.WhenAll(objtaskss);
ErrorLogger.WriteActivity("", "", "Operation finished");
//var json = new JavaScriptSerializer().Serialize(lstpathwayscaseRecords);
// System.IO.File.WriteAllText(@"C:\testFile.txt", json);
// Console.WriteLine(json);
}
else
{
ErrorLogger.WriteActivity("UploadReportService", "SerializePathWaysData", "No new Record Found");
}
}
catch (Exception ee)
{
ErrorLogger.WriteError("UploadReportService", "SerializePathwaysData", ee.ToString());
}
}
