/// <summary>
/// Convert all Pages to DiaryDetailFieldPage model
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>List of DiaryDetailFieldPage</returns>
private List<DiaryDetailFieldPage> ToPageList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<DiaryDetailFieldPage> TempList = new List<DiaryDetailFieldPage>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
if (dr["DetailFieldPageID"] != null)
{
if (Convert.ToInt32(dr["DetailFieldPageID"]) != 0)
{
TempList.Add(new DiaryDetailFieldPage(Convert.ToInt32(dr["DetailFieldPageID"]),dr["PageName"].ToString()));
}
}
}
return TempList;
}
/// <summary>
/// Converts Data to List of DiaryAppointments
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>List of DiaryAppointments</returns>
private List<IR_Dashboard_SDK.AquariumDiaryManagement.Appointment> ToList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<IR_Dashboard_SDK.AquariumDiaryManagement.Appointment> TempList = new List<IR_Dashboard_SDK.AquariumDiaryManagement.Appointment>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
if (dr["DiaryAppointmentID"] != null)
{
if (Convert.ToInt32(dr["DiaryAppointmentID"]) != 0)
TempList.Add(new IR_Dashboard_SDK.AquariumDiaryManagement.Appointment { DiaryAppointmentID = Convert.ToInt32(dr["DiaryAppointmentID"]), DiaryAppointmentTitle = dr["DiaryAppointmentTitle"].ToString(), DiaryAppointmentText = dr["DiaryAppointmentText"].ToString(), DueDate = Convert.ToDateTime(dr["DueDate"]), EndDate = Convert.ToDateTime(dr["EndDate"]), AllDayEvent = Convert.ToBoolean(dr["AllDayEvent"]), Completed = Convert.ToBoolean(dr["Completed"]), LeadID = Convert.ToInt32(dr["LeadID"]), ResourceInfo = dr["ResourceInfo"].ToString() });
}
}
return TempList;
}
/// <summary>
/// Convert data returned from SDK to ClaimReport Model used by Dashboard for monitoring Resolvers
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>List of ClaimReport Model</returns>
private List<ClaimReport> ToList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<ClaimReport> TempList = new List<ClaimReport>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
if (dr["LeadID"] != null)
{
if (Convert.ToInt32(dr["LeadID"]) != 0)
{
TempList.Add(new ClaimReport { LeadID = Convert.ToInt32(dr["LeadID"]), CustomerID = Convert.ToInt32(dr["CustomerID"]), Customer = dr["Customer"].ToString(), ClaimStatus = dr["ClaimStatus"].ToString(), CreatedOn = Convert.ToDateTime(dr["CreatedOn"]), LeadType = dr["LeadType"].ToString(), AssignedTo = dr["LeadType"].ToString() });
}
}
}
return TempList;
}
/// <summary>
/// Convert Data to Dynamic Object List
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>Dynamic Object List</returns>
private List<dynamic> ToDynamicList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<dynamic> TempList = new List<dynamic>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
var priorityTasks = New.PriorityTasks();
foreach (DataColumn dc in dt.Columns)
{
priorityTasks[dc.ColumnName] = dr[dc.ColumnName].ToString();
}
TempList.Add(priorityTasks);
}
return TempList;
}
/// <summary>
/// Convert Data to Dictionary
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>Dictionary List</returns>
private List<Dictionary<string, string>> ToDictionaryList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<Dictionary<string, string>> TempList = new List<Dictionary<string,string>>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, string> TempObject = new Dictionary<string, string>();
foreach (DataColumn dc in dt.Columns)
{
if(dr[dc.ColumnName] != null)
TempObject.Add(dc.ColumnName.ToString(), dr[dc.ColumnName].ToString());
else
TempObject.Add(dc.ColumnName.ToString(), "0");
}
TempList.Add(TempObject);
}
return TempList;
}
/// <summary>
/// Converts Data to List of DiaryAppointments with only ID
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>List of DiaryAppointments</returns>
private List<IR_Dashboard_SDK.AquariumDiaryManagement.Appointment> ToCustomList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<IR_Dashboard_SDK.AquariumDiaryManagement.Appointment> TempList = new List<IR_Dashboard_SDK.AquariumDiaryManagement.Appointment>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
if (dr["DiaryAppointmentID"] != null)
{
if (Convert.ToInt32(dr["DiaryAppointmentID"]) != 0)
TempList.Add(new IR_Dashboard_SDK.AquariumDiaryManagement.Appointment { DiaryAppointmentID = Convert.ToInt32(dr["DiaryAppointmentID"]), ResourceInfo = dr["ResourceInfo"].ToString() });
}
}
return TempList;
}
/// <summary>
/// Converts Data to List of ClaimReport
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>List of ClaimReport</returns>
private List<ClaimReport> ToClaimList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<ClaimReport> TempList = new List<ClaimReport>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
if (dr.Table.Columns.Contains("LeadID"))
{
if (Convert.ToInt32(dr["LeadID"]) != 0)
TempList.Add(new ClaimReport { LeadID = Convert.ToInt32(dr["LeadID"]), CustomerID = Convert.ToInt32(dr["CustomerID"]), Customer = dr["Customer"].ToString(), CreatedOn = Convert.ToDateTime(dr["CreatedOn"]), LeadType = dr["LeadType"].ToString(), AssignedTo = dr["Users"].ToString() });
}
else if (dr.Table.Columns.Contains("Settlements"))
TempList.Add(new ClaimReport { AssignedTo = dr["Users"].ToString(), Count = Convert.ToInt32(dr["Settlements"]) });
else if (dr.Table.Columns.Contains("Converted"))
TempList.Add(new ClaimReport { AssignedTo = dr["Users"].ToString(), Count = Convert.ToInt32(dr["Converted"]) });
}
return TempList;
}
/// <summary>
/// Converts data from SDK to DiaryAppointment List
/// </summary>
/// <param name="Data">AquariumReportManagement.ReportData</param>
/// <returns>DiaryAppointment List</returns>
private List<DiaryAppointment> ToList(IR_Dashboard_SDK.AquariumCustomProcessing.ReportData Data)
{
List<DiaryAppointment> TempList = new List<DiaryAppointment>();
DiaryPriorities = new List<DiaryPriority>();
DataTable dt = SDKHelper.GetDataTableFromSdkResult(Data.Columns, Data.Rows);
foreach (DataRow dr in dt.Rows)
{
if (dr["DiaryAppointmentID"] != null)
{
if (Convert.ToInt32(dr["DiaryAppointmentID"]) != 0)
{
DiaryPriorityLink dpl = new DiaryPriorityLink();
dpl.GetPriorityLinkbyID(Convert.ToInt32(dr["DiaryAppointmentID"]));
DiaryPriority dp = new DiaryPriority();
dp.GetDiaryPriority(dpl.DiaryPriorityID);
DiaryPriorities.Add(dp);
if (dr.Table.Columns.Contains("CustomerName"))
TempList.Add(new DiaryAppointment { DiaryAppointmentID = Convert.ToInt32(dr["DiaryAppointmentID"]), CustomerName = dr["CustomerName"].ToString(), DiaryAppointmentTitle = dr["DiaryAppointmentTitle"].ToString(), DiaryAppointmentText = dr["DiaryAppointmentText"].ToString(), DueDate = Convert.ToDateTime(dr["DueDate"]), EndDate = Convert.ToDateTime(dr["EndDate"]), AllDayEvent = Convert.ToBoolean(dr["AllDayEvent"]), Completed = Convert.ToBoolean(dr["Completed"]), LeadID = Convert.ToInt32(dr["LeadID"]), ResourceInfo = dr["ResourceInfo"].ToString() });
else
TempList.Add(new DiaryAppointment { DiaryAppointmentID = Convert.ToInt32(dr["DiaryAppointmentID"]), DiaryAppointmentTitle = dr["DiaryAppointmentTitle"].ToString(), DiaryAppointmentText = dr["DiaryAppointmentText"].ToString(), DueDate = Convert.ToDateTime(dr["DueDate"]), EndDate = Convert.ToDateTime(dr["EndDate"]), AllDayEvent = Convert.ToBoolean(dr["AllDayEvent"]), Completed = Convert.ToBoolean(dr["Completed"]), LeadID = Convert.ToInt32(dr["LeadID"]), ResourceInfo = dr["ResourceInfo"].ToString() });
}
}
}
return TempList;
}
