public ICollection <object> ParseDataMin(MySqlDataReader dataReader) { var entities = new List <object>(); while (dataReader.Read()) { var entity = new PreFilingSimilarityResearch { ID = (int)dataReader["ID"], ResearchedBrand = new Brand { ID = Convert.ToInt32(dataReader["ResearchedBrandID"]), Name = dataReader["ResearchedBrandName"] as string }, Office = new Office { ID = Convert.ToInt32(dataReader["OfficeID"]), OfficeName = dataReader["OfficeName"] as string }, }; entities.Add(entity); } return(entities); }
public static bool IsValid(PreFilingSimilarityResearch preFilingSimilarityResearch, out Dictionary <string, string> validationResult) { validationResult = new Dictionary <string, string>(); if (preFilingSimilarityResearch.ResearchedBrand == null || string.IsNullOrWhiteSpace(preFilingSimilarityResearch.ResearchedBrand.Name)) { validationResult.Add("Record.ResearchedBrand.Name", ValidationMessages.REQUIRED); } if (preFilingSimilarityResearch.Office == null || string.IsNullOrWhiteSpace(preFilingSimilarityResearch.Office.OfficeName)) { validationResult.Add("Record.Office.OfficeName", ValidationMessages.REQUIRED); } if (string.IsNullOrWhiteSpace(preFilingSimilarityResearch.SimilarityLevel)) { validationResult.Add("Record.SimilarityLevel", ValidationMessages.REQUIRED); } return(!validationResult.Any()); }
public ICollection <object> ParseData(MySqlDataReader dataReader) { var entities = new List <object>(); while (dataReader.Read()) { var entity = new PreFilingSimilarityResearch { ID = (int)dataReader["ID"], OwnerName = dataReader["OwnerName"] as string, ResearchedBrand = new Brand { ID = Convert.ToInt32(dataReader["ResearchedBrandID"]), Name = dataReader["ResearchedBrandName"] as string }, Office = new Office { ID = Convert.ToInt32(dataReader["OfficeID"]), OfficeName = dataReader["OfficeName"] as string }, DateOfResearch = dataReader["DateOfResearch"] as string, Comments = dataReader["Comments"] as string, SimilarityLevel = dataReader["SimilarityLevel"] as string, SimilarityLevel2 = dataReader["SimilarityLevel2"] as string, Class1 = dataReader["Class1"] as string, Class1_2 = dataReader["Class1_2"] as string, Class2 = dataReader["Class2"] as string, Class2_2 = dataReader["Class2_2"] as string, Class3 = dataReader["Class3"] as string, Class3_2 = dataReader["Class3_2"] as string, Class4 = dataReader["Class4"] as string, Class4_2 = dataReader["Class4_2"] as string, Class5 = dataReader["Class5"] as string, Class5_2 = dataReader["Class5_2"] as string, Class6 = dataReader["Class6"] as string, Class6_2 = dataReader["Class6_2"] as string, Class7 = dataReader["Class7"] as string, Class7_2 = dataReader["Class7_2"] as string, Class8 = dataReader["Class8"] as string, Class8_2 = dataReader["Class8_2"] as string, Class9 = dataReader["Class9"] as string, Class9_2 = dataReader["Class9_2"] as string, Class10 = dataReader["Class10"] as string, Class10_2 = dataReader["Class10_2"] as string, Class11 = dataReader["Class11"] as string, Class11_2 = dataReader["Class11_2"] as string, Class12 = dataReader["Class12"] as string, Class12_2 = dataReader["Class12_2"] as string, Class13 = dataReader["Class13"] as string, Class13_2 = dataReader["Class13_2"] as string, Class14 = dataReader["Class14"] as string, Class14_2 = dataReader["Class14_2"] as string, Class15 = dataReader["Class15"] as string, Class15_2 = dataReader["Class15_2"] as string, Class16 = dataReader["Class16"] as string, Class16_2 = dataReader["Class16_2"] as string, Class17 = dataReader["Class17"] as string, Class17_2 = dataReader["Class17_2"] as string, Class18 = dataReader["Class18"] as string, Class18_2 = dataReader["Class18_2"] as string, Class19 = dataReader["Class19"] as string, Class19_2 = dataReader["Class19_2"] as string, Class20 = dataReader["Class20"] as string, Class20_2 = dataReader["Class20_2"] as string, Class21 = dataReader["Class21"] as string, Class21_2 = dataReader["Class21_2"] as string, Class22 = dataReader["Class22"] as string, Class22_2 = dataReader["Class22_2"] as string, Class23 = dataReader["Class23"] as string, Class23_2 = dataReader["Class23_2"] as string, Class24 = dataReader["Class24"] as string, Class24_2 = dataReader["Class24_2"] as string, Class25 = dataReader["Class25"] as string, Class25_2 = dataReader["Class25_2"] as string, Class26 = dataReader["Class26"] as string, Class26_2 = dataReader["Class26_2"] as string, Class27 = dataReader["Class27"] as string, Class27_2 = dataReader["Class27_2"] as string, Class28 = dataReader["Class28"] as string, Class28_2 = dataReader["Class28_2"] as string, Class29 = dataReader["Class29"] as string, Class29_2 = dataReader["Class29_2"] as string, Class30 = dataReader["Class30"] as string, Class30_2 = dataReader["Class30_2"] as string, Class31 = dataReader["Class31"] as string, Class31_2 = dataReader["Class31_2"] as string, Class32 = dataReader["Class32"] as string, Class32_2 = dataReader["Class32_2"] as string, Class33 = dataReader["Class33"] as string, Class33_2 = dataReader["Class33_2"] as string, Class34 = dataReader["Class34"] as string, Class34_2 = dataReader["Class34_2"] as string, Class35 = dataReader["Class35"] as string, Class35_2 = dataReader["Class35_2"] as string, Class36 = dataReader["Class36"] as string, Class36_2 = dataReader["Class36_2"] as string, Class37 = dataReader["Class37"] as string, Class37_2 = dataReader["Class37_2"] as string, Class38 = dataReader["Class38"] as string, Class38_2 = dataReader["Class38_2"] as string, Class39 = dataReader["Class39"] as string, Class39_2 = dataReader["Class39_2"] as string, Class40 = dataReader["Class40"] as string, Class40_2 = dataReader["Class40_2"] as string, Class41 = dataReader["Class41"] as string, Class41_2 = dataReader["Class41_2"] as string, Class42 = dataReader["Class42"] as string, Class42_2 = dataReader["Class42_2"] as string, Class43 = dataReader["Class43"] as string, Class43_2 = dataReader["Class43_2"] as string, Class44 = dataReader["Class44"] as string, Class44_2 = dataReader["Class44_2"] as string, Class45 = dataReader["Class45"] as string, Class45_2 = dataReader["Class45_2"] as string }; if (int.TryParse((dataReader["OfficeID"] as int?)?.ToString(), out int officeID)) { entity.Office = new Office { ID = officeID }; } entities.Add(entity); } return(entities); }