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);
}
