public List <ImportJobQueueEntity> Adapt(DataTable dt)
{
List <ImportJobQueueEntity> results = new List <ImportJobQueueEntity>();
foreach (DataRow rw in dt.Rows)
{
ImportJobQueueEntity ExportJob = new ImportJobQueueEntity();
ExportJob = AdaptItem(rw, dt);
results.Add(ExportJob);
}
return(results);
}
public ImportJobQueueEntity AdaptItem(DataRow rw, DataTable dt)
{
ImportJobQueueEntity result = new ImportJobQueueEntity();
if (dt.Columns.Contains("Id"))
{
result.Id = SafeHelper.GetSafeint(rw["Id"]);
}
if (dt.Columns.Contains("ApplicationId"))
{
result.ApplicationId = SafeHelper.GetSafeint(rw["ApplicationId"]);
}
if (dt.Columns.Contains("SourceType"))
{
result.SourceType = SafeHelper.GetSafestring(rw["SourceType"]);
}
if (dt.Columns.Contains("SourceFileName"))
{
result.SourceFileName = SafeHelper.GetSafestring(rw["SourceFileName"]);
}
if (dt.Columns.Contains("ImportedDate"))
{
result.ImportedDate = SafeHelper.GetSafeDateTime(rw["ImportedDate"]);
}
if (dt.Columns.Contains("ProcessStartDate"))
{
result.ProcessStartDate = SafeHelper.GetSafeDateTimeIfNull(rw["ProcessStartDate"]);
}
if (dt.Columns.Contains("ProcessEndDate"))
{
//if (rw["ProcessEndDate"] == DBNull.Value)
//{
// result.ProcessEndDate = DateTime.MinValue;
//}
//else
//{
result.ProcessEndDate = SafeHelper.GetSafeDateTimeIfNull(rw["ProcessEndDate"]);
//}
}
if (dt.Columns.Contains("IsProcessComplete"))
{
result.IsProcessComplete = SafeHelper.GetSafebool(rw["IsProcessComplete"]);
}
if (dt.Columns.Contains("IsNotify"))
{
result.IsNotify = SafeHelper.GetSafebool(rw["IsNotify"]);
}
if (dt.Columns.Contains("ColumnMapping"))
{
result.ColumnMapping = SafeHelper.GetSafestring(rw["ColumnMapping"]);
}
if (dt.Columns.Contains("ImportType"))
{
result.ImportType = SafeHelper.GetSafestring(rw["ImportType"]);
}
if (dt.Columns.Contains("Tags"))
{
result.Tags = SafeHelper.GetSafestring(rw["Tags"]);
}
if (dt.Columns.Contains("InLanguage"))
{
result.InLanguage = SafeHelper.GetSafestring(rw["InLanguage"]);
}
if (dt.Columns.Contains("InLanguage"))
{
result.UserId = SafeHelper.GetSafeint(rw["UserId"]);
}
if (dt.Columns.Contains("Delimiter"))
{
result.Delimiter = SafeHelper.GetSafestring(rw["Delimiter"]);
}
if (dt.Columns.Contains("IsEmailSent"))
{
result.IsEmailSent = SafeHelper.GetSafebool(rw["IsEmailSent"]);
}
if (dt.Columns.Contains("ProviderType"))
{
result.ProvidersType = SafeHelper.GetSafestring(rw["ProviderType"]);
}
if (dt.Columns.Contains("IsHeader"))
{
result.IsHeader = SafeHelper.GetSafebool(rw["IsHeader"]);
}
if (dt.Columns.Contains("RetryCount"))
{
result.RetryCount = SafeHelper.GetSafeint(rw["RetryCount"]);
}
if (dt.Columns.Contains("ErrorMessage"))
{
result.ErrorMessage = SafeHelper.GetSafestring(rw["ErrorMessage"]);
}
return(result);
}