/// <summary> /// This method sets the reference data DTO by reading reference data xml file. /// </summary> private void SetReferenceData() { XDocument xdoc = XDocument.Load(refDataFilePath); //Set Value Factor var selectFactorValue = from fResult in xdoc.Descendants(ApplicationConstant.VALUE_FACTOR) select fResult; XElement nodeValue = selectFactorValue.ElementAt(0); if (null == referenceDataDTO) { referenceDataDTO = new ReferenceDataDTO(); } referenceDataDTO.ValueFactorHigh = double.Parse(nodeValue.Element(ApplicationConstant.HIGH).Value); referenceDataDTO.ValueFactorMedium = double.Parse(nodeValue.Element(ApplicationConstant.MEDIUM).Value); referenceDataDTO.ValueFactorLow = double.Parse(nodeValue.Element(ApplicationConstant.LOW).Value); //Parse EmissionFactor var selectEmissionValue = from fResult in xdoc.Descendants(ApplicationConstant.EMISSIONS_FACTOR) select fResult; nodeValue = selectEmissionValue.ElementAt(0); referenceDataDTO.EmissionFactorHigh = double.Parse(nodeValue.Element(ApplicationConstant.HIGH).Value); referenceDataDTO.EmissionFactorMedium = double.Parse(nodeValue.Element(ApplicationConstant.MEDIUM).Value); referenceDataDTO.EmissionFactorLow = double.Parse(nodeValue.Element(ApplicationConstant.LOW).Value); }
public static List <ReferenceDataCategoryDTO> MapDTO(List <SimpleListDTO> simpleLists) { List <ReferenceDataCategoryDTO> referenceDataCategoryDTOList = new List <ReferenceDataCategoryDTO>(); foreach (var simpleList in simpleLists) { ReferenceDataCategoryDTO referenceDataCategoryDTO = new ReferenceDataCategoryDTO(); referenceDataCategoryDTO.CategoryName = simpleList.ListName; referenceDataCategoryDTO.ReferenceDatas = new List <ReferenceDataDTO>(); foreach (var item in simpleList.ListItems) { ReferenceDataDTO referenceDataDTO = new ReferenceDataDTO(); referenceDataDTO.DisplayText = item.DisplayText; referenceDataDTO.DataDescription = item.Description; referenceDataDTO.ID = item.Id; referenceDataDTO.ReferenceDataName = item.Name; referenceDataDTO.ReferenceDataValue = item.Value; referenceDataCategoryDTO.ReferenceDatas.Add(referenceDataDTO); } referenceDataCategoryDTOList.Add(referenceDataCategoryDTO); } return(referenceDataCategoryDTOList); }
public static List <ReferenceDataCategoryDTO> MapDTO(List <NameValuePair> nameValuePairs) { List <ReferenceDataCategoryDTO> referenceDataCategoryDTOList = new List <ReferenceDataCategoryDTO>(); foreach (var nameValuePair in nameValuePairs.GroupBy(x => x.Group)) { ReferenceDataCategoryDTO referenceDataCategoryDTO = new ReferenceDataCategoryDTO(); referenceDataCategoryDTO.CategoryName = nameValuePair.Key; referenceDataCategoryDTO.ReferenceDatas = new List <ReferenceDataDTO>(); foreach (var item in nameValuePair) { ReferenceDataDTO referenceDataDTO = new ReferenceDataDTO(); referenceDataDTO.DisplayText = item.DisplayText; referenceDataDTO.DataDescription = item.Description; referenceDataDTO.ID = item.Id; referenceDataDTO.ReferenceDataName = item.Name; referenceDataDTO.ReferenceDataValue = item.Value; referenceDataCategoryDTO.ReferenceDatas.Add(referenceDataDTO); } referenceDataCategoryDTOList.Add(referenceDataCategoryDTO); } return(referenceDataCategoryDTOList); }
private static Reference_Data convertToEntity(ReferenceDataDTO referenceDataDTO) { var referenceData = new Retrosheet_Persist.Reference_Data(); referenceData.record_id = referenceDataDTO.RecordID; referenceData.ref_data_type = referenceDataDTO.ReferenceDataType; referenceData.ref_data_code = referenceDataDTO.ReferenceDataCode; referenceData.ref_data_desc = referenceDataDTO.ReferenceDataDescription; return(referenceData); }
public static void CreateReferenceData(ReferenceDataDTO referenceDataDTO) { // ballpark instance of Ballpark class in Retrosheet_Persist.Retrosheet var referenceData = convertToEntity(referenceDataDTO); // entity data model //var dbCtx = new retrosheetDB(); var dbCtx = new retrosheetEntities(); try { dbCtx.Reference_Data.Add(referenceData); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } catch (Exception e) { string text; text = e.Message; } try { dbCtx.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { foreach (var ve in eve.ValidationErrors) { Console.WriteLine(ve.PropertyName); Console.WriteLine(ve.ErrorMessage); } } } catch (Exception e) { string text; text = e.Message; } }
private static void ReadWriteReferenceDataFile() { string[] columnValue; string textLine = null; using (StreamReader reader = new StreamReader(@"C:\users\mmr\documents\retrosheet\reference_data.txt")) { while (!reader.EndOfStream) { try { textLine = reader.ReadLine(); } catch (Exception e) { // Let the user know what went wrong. Console.WriteLine("The " + @"C:\users\mmr\documents\retrosheet\reference_data.txt" + " file could not be read:"); Console.WriteLine(e.Message); Console.ReadLine(); } // skip the header record in the input file if (textLine.IndexOf("ref_data_type") == -1) { columnValue = textLine.Split('|'); ReferenceDataDTO referenceDataDTO = new ReferenceDataDTO(); referenceDataDTO.RecordID = Guid.NewGuid(); referenceDataDTO.ReferenceDataType = columnValue[0]; referenceDataDTO.ReferenceDataCode = columnValue[1]; referenceDataDTO.ReferenceDataDescription = columnValue[2]; ReferenceDataPersist.CreateReferenceData(referenceDataDTO); } Console.WriteLine(textLine); } } }