private void FillCallInfoList(IXLRows rows, ref CallInfoList listInfo)
{
try
{
foreach (IXLRow r in rows)
{
if (r.RowNumber() == 1)
{
continue;
}
CallInfoSymptom symptom = new CallInfoSymptom();
CallInfoTime time = new CallInfoTime();
foreach (IXLCell cell in r.CellsUsed())
{
MatchCallInfoListName(cell, ref listInfo, ref symptom, ref time);
}
listInfo.SymptomInfo.Add(symptom);
listInfo.TimeInfo.Add(time);
}
}
catch (Exception)
{
throw;
}
}
private void MatchCallInfoListName(IXLCell cell, ref CallInfoList listInfo, ref CallInfoSymptom symptom, ref CallInfoTime time)
{
try
{
switch (cell.WorksheetColumn().FirstCell().GetString().Trim().ToLower())
{
case "contactperson":
listInfo.ContactPerson.Add(HttpUtility.UrlEncode(cell.GetString()));
break;
case "location":
listInfo.Location.Add(HttpUtility.UrlEncode(cell.GetString()));
break;
case "company":
listInfo.Company.Add(HttpUtility.UrlEncode(cell.GetString()));
break;
case "requesttype":
symptom.RequestType = HttpUtility.UrlEncode(cell.GetString());
break;
case "symptom":
symptom.Symptom = HttpUtility.UrlEncode(cell.GetString());
break;
case "scheduletime":
time.ScheduleTime = HttpUtility.UrlEncode(cell.GetString());
break;
case "servetime1":
time.ServeTime1 = HttpUtility.UrlEncode(cell.GetString());
break;
case "servetime2":
time.ServeTime2 = HttpUtility.UrlEncode(cell.GetString());
break;
case "servicedescription":
symptom.ServiceDescription = HttpUtility.UrlEncode(cell.GetString());
break;
}
}
catch (Exception)
{
throw;
}
}