public void HUDAppraiserContactInfoRepository_BulkUpdate() { //arrange var appraiserContactInfoes = new HUDAppraiserContactInfo[] { new HUDAppraiserContactInfo(){AppraiserID="000F4U",AddressAttentionLine="",City="NORTH WILKESBORO",CreateDate=SafeConvert.ToDateTime("20080501","yyyyMMdd"),CreateDateString="20080501",FaxNumber="3368387386",FirstName="CHARLES",LastName="SINK",LastUpdateDate=SafeConvert.ToDateTime("20110623","yyyymmdd"),LastUpdateDateString="20110623",MiddleInitial="S",NameSuffix="III",PhoneNumber="3368387337",StateCode="NC",StreetAddress="309 10TH ST-RM 202-PO BOX 1063",Zip="286590000"}, new HUDAppraiserContactInfo(){AppraiserID="000FDM",AddressAttentionLine="FIRST AMERICAN APPRAISAL SVS",City="POWAY",CreateDate=SafeConvert.ToDateTime("19990522","yyyyMMdd"),CreateDateString="19990522",FaxNumber="0000000000",FirstName="BARBARA",LastName="OAKS",LastUpdateDate=SafeConvert.ToDateTime("20100708","yyyymmdd"),LastUpdateDateString="20100708",MiddleInitial="M",NameSuffix="",PhoneNumber="8009846773",StateCode="CA",StreetAddress="12395 FIRST AMERICAN WAY",Zip="920640000"} }; //act _repository.BulkUpdate(appraiserContactInfoes); //assert _repository.Get().Should().HaveCount(2); }
private string GetAppraiserContactInfoParseProblem(HUDAppraiserContactInfo importedRecord) { string problemDescription = " problems:"; problemDescription += string.IsNullOrWhiteSpace(importedRecord.AppraiserID) ? "appraiserID is empty" : ""; problemDescription += string.IsNullOrWhiteSpace(importedRecord.LastName) ? "LastName is empty" : ""; problemDescription += string.IsNullOrWhiteSpace(importedRecord.FirstName) ? "FirstName is empty" : ""; problemDescription += string.IsNullOrWhiteSpace(importedRecord.City) ? "City is empty" : ""; problemDescription += string.IsNullOrWhiteSpace(importedRecord.StateCode) ? "StateCode is empty" : ""; problemDescription += string.IsNullOrWhiteSpace(importedRecord.Zip) ? "Zip is empty" : ""; problemDescription += importedRecord.CreateDate.HasValue ? "" : "cannot parse CreateDate " + importedRecord.CreateDateString; problemDescription += importedRecord.LastUpdateDate.HasValue ? "" : "cannot parse LastUpdateDate " + importedRecord.LastUpdateDateString; return problemDescription; }
private bool IsStringParsedCorrectly(HUDAppraiserContactInfo importedRecord) { return !String.IsNullOrWhiteSpace(importedRecord.AppraiserID) || !String.IsNullOrWhiteSpace(importedRecord.LastName) || !String.IsNullOrWhiteSpace(importedRecord.FirstName) || !String.IsNullOrWhiteSpace(importedRecord.City) || !String.IsNullOrWhiteSpace(importedRecord.StateCode) || !String.IsNullOrWhiteSpace(importedRecord.Zip) || !importedRecord.CreateDate.HasValue || !importedRecord.LastUpdateDate.HasValue; }
public HUDAppraiserContactInfo GetAppraiserContactInfoFromHUDString(string record) { if (string.IsNullOrWhiteSpace(record)) throw new ArgumentNullException("HUD record for appraiser contact info cannot be empty"); if (record.Length != 191) throw new ArgumentOutOfRangeException("HUD record length for appraiser contact info is incorrect " + record.Length); HUDAppraiserContactInfo appraiserContactInfo = new HUDAppraiserContactInfo(); appraiserContactInfo.AppraiserID = record.Substring(0, 6).Trim(); appraiserContactInfo.LastUpdateDateString = record.Substring(10, 8).Trim(); appraiserContactInfo.LastUpdateDate = SafeConvert.ToDateTime(appraiserContactInfo.LastUpdateDateString, "yyyyMMdd"); appraiserContactInfo.CreateDateString = record.Substring(22, 8).Trim(); appraiserContactInfo.CreateDate = SafeConvert.ToDateTime(appraiserContactInfo.CreateDateString, "yyyyMMdd"); appraiserContactInfo.LastName = record.Substring(30, 20).Trim(); appraiserContactInfo.FirstName = record.Substring(50, 20).Trim(); appraiserContactInfo.MiddleInitial = record.Substring(70, 1).Trim(); appraiserContactInfo.NameSuffix = record.Substring(71, 4).Trim(); appraiserContactInfo.AddressAttentionLine = record.Substring(75, 30).Trim(); appraiserContactInfo.StreetAddress = record.Substring(105, 30).Trim(); appraiserContactInfo.City = record.Substring(135, 17).Trim(); appraiserContactInfo.StateCode = record.Substring(152, 2).Trim(); appraiserContactInfo.Zip = record.Substring(157, 9).Trim(); appraiserContactInfo.PhoneNumber = record.Substring(168, 10).Trim(); appraiserContactInfo.FaxNumber = record.Substring(180, 10).Trim(); return appraiserContactInfo; }