public List <ImportFileTemplates> AdaptTemplate(DataTable dt)
{
List <ImportFileTemplates> results = new List <ImportFileTemplates>();
foreach (DataRow rw in dt.Rows)
{
ImportFileTemplates ImportJob = new ImportFileTemplates();
ImportJob = AdaptTemplateItem(rw, dt);
results.Add(ImportJob);
}
return(results);
}
public ImportFileTemplates AdaptTemplateItem(DataRow rw, DataTable dt)
{
ImportFileTemplates result = new ImportFileTemplates();
if (dt.Columns.Contains("TemplateId"))
{
result.TemplateId = SafeHelper.GetSafeint(rw["TemplateId"]);
}
if (dt.Columns.Contains("FileFormat"))
{
result.FileFormat = SafeHelper.GetSafestring(rw["FileFormat"]);
}
if (dt.Columns.Contains("ImportType"))
{
result.ImportType = SafeHelper.GetSafestring(rw["ImportType"]);
}
if (dt.Columns.Contains("TemplateName"))
{
result.TemplateName = SafeHelper.GetSafestring(rw["TemplateName"]);
}
if (dt.Columns.Contains("Delimiter"))
{
result.Delimiter = SafeHelper.GetSafestring(rw["Delimiter"]);
}
if (dt.Columns.Contains("HasHeader"))
{
result.HasHeader = SafeHelper.GetSafebool(rw["HasHeader"]);
}
if (dt.Columns.Contains("ExcelWorksheetName"))
{
result.ExcelWorksheetName = SafeHelper.GetSafestring(rw["ExcelWorksheetName"]);
}
if (dt.Columns.Contains("FileColumnMetadata"))
{
result.FileColumnMetadata = SafeHelper.GetSafestring(rw["FileColumnMetadata"]);
}
if (dt.Columns.Contains("ColumnMappings"))
{
result.ColumnMappings = SafeHelper.GetSafestring(rw["ColumnMappings"]);
}
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("UserId"))
{
result.UserId = SafeHelper.GetSafeint(rw["UserId"]);
}
if (dt.Columns.Contains("IsUnicode"))
{
result.IsUnicode = SafeHelper.GetSafeboolIfNull(rw["IsUnicode"]);
}
if (dt.Columns.Contains("UpdatedDateTime"))
{
result.UpdatedDateTime = SafeHelper.GetSafeDateTime(rw["UpdatedDateTime"]);
}
if (dt.Columns.Contains("ImportFileConfigurationId"))
{
result.ImportFileConfigurationId = SafeHelper.GetSafestring(rw["ImportFileConfigurationId"]);
}
return(result);
}
public ImportJobDataEntity()
{
lstTemplates = new List <ImportFileTemplates>();
selectedTemplated = new ImportFileTemplates();
AllUploadedFileColumn = new List <SelectListItem>();
}
