public List <ImportFileConfigurationEntity> Adapt(DataTable dt)
{
List <ImportFileConfigurationEntity> results = new List <ImportFileConfigurationEntity>();
foreach (DataRow rw in dt.Rows)
{
ImportFileConfigurationEntity matchCode = new ImportFileConfigurationEntity();
matchCode = AdaptItem(rw, dt);
results.Add(matchCode);
}
return(results);
}
public ImportFileConfigurationEntity AdaptItem(DataRow rw, DataTable dt)
{
ImportFileConfigurationEntity result = new ImportFileConfigurationEntity();
if (dt.Columns.Contains("Id"))
{
result.Id = SafeHelper.GetSafeint(rw["Id"]);
}
if (dt.Columns.Contains("ConfigurationName"))
{
result.ConfigurationName = SafeHelper.GetSafestring(rw["ConfigurationName"]);
}
if (dt.Columns.Contains("ExternalDataStoreId"))
{
result.ExternalDataStoreId = SafeHelper.GetSafeint(rw["ExternalDataStoreId"]);
}
if (dt.Columns.Contains("SourceFolderPath"))
{
result.SourceFolderPath = SafeHelper.GetSafestring(rw["SourceFolderPath"]);
}
if (dt.Columns.Contains("TemplateId"))
{
result.TemplateId = SafeHelper.GetSafeint(rw["TemplateId"]);
}
if (dt.Columns.Contains("FileNamePattern"))
{
result.FileNamePattern = SafeHelper.GetSafestring(rw["FileNamePattern"]);
}
if (dt.Columns.Contains("PostLoadAction"))
{
result.PostLoadAction = SafeHelper.GetSafestring(rw["PostLoadAction"]);
}
if (dt.Columns.Contains("PostLoadActionParameters"))
{
result.PostLoadActionParameters = SafeHelper.GetSafestring(rw["PostLoadActionParameters"]);
}
if (dt.Columns.Contains("UserId"))
{
result.UserId = SafeHelper.GetSafeint(rw["UserId"]);
}
return(result);
}
internal string InsertImportFileConfiguration(ImportFileConfigurationEntity objImportFileConfiguration)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "cfg.InsertImportFileConfiguration";
sproc.StoredProceduresParameter.Add(GetParam("@id", Convert.ToString(objImportFileConfiguration.Id), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@configurationName", objImportFileConfiguration.ConfigurationName, SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@externalDataStoreId", Convert.ToString(objImportFileConfiguration.ExternalDataStoreId), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@sourceFolderPath", string.IsNullOrEmpty(objImportFileConfiguration.SourceFolderPath) ? "" : objImportFileConfiguration.SourceFolderPath, SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@templateId", Convert.ToString(objImportFileConfiguration.TemplateId), SQLServerDatatype.SmallintDataType));
sproc.StoredProceduresParameter.Add(GetParam("@fileNamePattern", string.IsNullOrEmpty(objImportFileConfiguration.FileNamePattern) ? "" : objImportFileConfiguration.FileNamePattern, SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@postLoadAction", string.IsNullOrEmpty(objImportFileConfiguration.PostLoadAction) ? "" : objImportFileConfiguration.PostLoadAction, SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@postLoadActionParameters", string.IsNullOrEmpty(objImportFileConfiguration.PostLoadActionParameters) ? "" : objImportFileConfiguration.PostLoadActionParameters, SQLServerDatatype.NvarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@userId", Convert.ToString(objImportFileConfiguration.UserId), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
return("");
}
catch (Exception ex)
{
throw ex;
}
}
public string InsertImportFileConfiguration(ImportFileConfigurationEntity objImportFileConfiguration)
{
return(rep.InsertImportFileConfiguration(objImportFileConfiguration));
}
