public List <ExportJobSettingsEntity> Adapt(DataTable dt) { List <ExportJobSettingsEntity> results = new List <ExportJobSettingsEntity>(); foreach (DataRow rw in dt.Rows) { ExportJobSettingsEntity ExportJob = new ExportJobSettingsEntity(); ExportJob = AdaptItem(rw, dt); results.Add(ExportJob); } return(results); }
public ExportJobSettingsEntity AdaptItem(DataRow rw, DataTable dt) { ExportJobSettingsEntity result = new ExportJobSettingsEntity(); if (dt.Columns.Contains("Id")) { result.Id = SafeHelper.GetSafeint(rw["Id"]); } if (dt.Columns.Contains("UserId")) { result.UserId = SafeHelper.GetSafeint(rw["UserId"]); } if (dt.Columns.Contains("Tags")) { result.Tags = SafeHelper.GetSafestring(rw["Tags"]); } if (dt.Columns.Contains("Input")) { result.Input = SafeHelper.GetSafestring(rw["Input"]); } if (dt.Columns.Contains("LOBTag")) { result.LOBTag = SafeHelper.GetSafestring(rw["LOBTag"]); } if (dt.Columns.Contains("MatchOutPut")) { result.MatchOutPut = SafeHelper.GetSafebool(rw["MatchOutPut"]); } if (dt.Columns.Contains("Enrichment")) { result.Enrichment = SafeHelper.GetSafebool(rw["Enrichment"]); } if (dt.Columns.Contains("ActiveDataQueue")) { result.ActiveDataQueue = SafeHelper.GetSafebool(rw["ActiveDataQueue"]); } if (dt.Columns.Contains("MarkAsExported")) { result.MarkAsExported = SafeHelper.GetSafebool(rw["MarkAsExported"]); } if (dt.Columns.Contains("Format")) { result.Format = SafeHelper.GetSafestring(rw["Format"]); } if (dt.Columns.Contains("FilePath")) { result.FilePath = SafeHelper.GetSafestring(rw["FilePath"]); } if (dt.Columns.Contains("RequestedDate")) { result.RequestedDate = SafeHelper.GetSafeDateTime(rw["RequestedDate"]); } if (dt.Columns.Contains("ProcessStartDate")) { //if (rw["ProcessStartDate"] == DBNull.Value) //{ // result.ProcessStartDate = null; //} //else //{ result.ProcessStartDate = SafeHelper.GetSafeDateTimeIfNull(rw["ProcessStartDate"]); } //} if (dt.Columns.Contains("ProcessEndDate")) { result.ProcessEndDate = SafeHelper.GetSafeDateTimeIfNull(rw["ProcessEndDate"]); } if (dt.Columns.Contains("IsProcessComplete")) { result.IsProcessComplete = SafeHelper.GetSafebool(rw["IsProcessComplete"]); } if (dt.Columns.Contains("IsAlreadyDownloaded")) { result.IsAlreadyDownloaded = SafeHelper.GetSafebool(rw["IsAlreadyDownloaded"]); } if (dt.Columns.Contains("ApplicationId")) { result.ApplicationId = SafeHelper.GetSafeint(rw["ApplicationId"]); } if (dt.Columns.Contains("LastDownloadedDate")) { result.LastDownloadedDate = SafeHelper.GetSafeDateTime(rw["LastDownloadedDate"]); } if (dt.Columns.Contains("LastDownloadedUserId")) { result.LastDownloadedUserId = SafeHelper.GetSafeint(rw["LastDownloadedUserId"]); } if (dt.Columns.Contains("Delimiter")) { result.Delimiter = SafeHelper.GetSafestring(rw["Delimiter"]); } if (dt.Columns.Contains("SrcRecID")) { result.SrcRecID = SafeHelper.GetSafestring(rw["SrcRecID"]); } if (dt.Columns.Contains("IsExactMatch")) { result.SrcRecIdExactMatch = SafeHelper.GetSafebool(rw["IsExactMatch"]); } if (dt.Columns.Contains("IsEmailSent")) { result.IsEmailSent = SafeHelper.GetSafebool(rw["IsEmailSent"]); } if (dt.Columns.Contains("LCMQueue")) { result.LCMQueue = SafeHelper.GetSafebool(rw["LCMQueue"]); } if (dt.Columns.Contains("NoMatchQueue")) { result.NoMatchQueue = SafeHelper.GetSafebool(rw["NoMatchQueue"]); } if (dt.Columns.Contains("TrasferedDuns")) { result.TrasferedDuns = SafeHelper.GetSafebool(rw["TrasferedDuns"]); //Add DUNS Transfer to Export(MP-367) } if (dt.Columns.Contains("IsCancelled")) { result.IsCancelled = SafeHelper.GetSafebool(rw["IsCancelled"]); } if (dt.Columns.Contains("ProcessCancelledDateTime")) { result.ProcessCancelledDateTime = SafeHelper.GetSafeDateTime(rw["ProcessCancelledDateTime"]); } if (dt.Columns.Contains("IsDeleted")) { result.IsDeleted = SafeHelper.GetSafebool(rw["IsDeleted"]); } if (dt.Columns.Contains("IsAlreadyNotify")) { result.IsAlreadyNotify = SafeHelper.GetSafebool(rw["IsAlreadyNotify"]); } if (dt.Columns.Contains("ExportType")) { result.ExportType = SafeHelper.GetSafestring(rw["ExportType"]); } if (dt.Columns.Contains("CompanyTree")) { result.CompanyTree = SafeHelper.GetSafebool(rw["CompanyTree"]); } if (dt.Columns.Contains("RetryCount")) { result.RetryCount = SafeHelper.GetSafeint(rw["RetryCount"]); } if (dt.Columns.Contains("ErrorMessage")) { result.ErrorMessage = SafeHelper.GetSafestring(rw["ErrorMessage"]); } if (dt.Columns.Contains("HasHeader")) { result.HasHeader = SafeHelper.GetSafebool(rw["HasHeader"]); } if (dt.Columns.Contains("HasTextQualifierToAll")) { result.HasTextQualifierToAll = SafeHelper.GetSafebool(rw["HasTextQualifierToAll"]); } return(result); }