public YellowstonePathology.Business.PreviousResultCollection GetPreviousResultsByTestFinal(int panelSetId, DateTime startDate, DateTime endDate, string tableName) { PreviousResultCollection result = new PreviousResultCollection(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = this.m_TableDictionary[tableName]; cmd.CommandText = cmd.CommandText.Replace("table_name", tableName); cmd.Parameters.AddWithValue("@PanelSetId", panelSetId); cmd.Parameters.AddWithValue("@StartDate", startDate); cmd.Parameters.AddWithValue("@EndDate", endDate); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { PreviousResult previousResult = new PreviousResult(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(previousResult, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(previousResult); } } } return(result); }
public async Task SavePreviousResultsAsync() { //Arrange var previousResultEntity = new PreviousResult(); previousResultEntity.LifeOfProject = 5; previousResultEntity.InitialCost = 300000; previousResultEntity.LowerBoundDiscountRate = 1; previousResultEntity.UpperBoundDiscountRate = 15; previousResultEntity.DiscountRateIncrement = 0.65; previousResultEntity.NetPresentValue = 234553; previousResultEntity.PresentValueOfCashFlows = 17345; previousResultEntity.CreatedDate = DateTime.UtcNow; previousResultEntity.CashFlows.Add(new CashFlows { Year = 1, Value = 12345, }); previousResultEntity.CashFlows.Add(new CashFlows { Year = 2, Value = 24223, }); previousResultEntity.CashFlows.Add(new CashFlows { Year = 3, Value = 22345, }); previousResultEntity.CashFlows.Add(new CashFlows { Year = 4, Value = 52344, }); previousResultEntity.CashFlows.Add(new CashFlows { Year = 5, Value = 12623, }); //Act _npvContext.AddPreviousResults(previousResultEntity); var saveChangesResult = await _npvContext.SaveEntityChangesAsync(); //Assert Assert.IsTrue(saveChangesResult > 0); }
public async Task <IActionResult> SavePreviousResults(CalculationModel calculationModel) { if (calculationModel == null) { throw new Exception("The parameter calculationModel is null"); } var netPresentValue = Convert.ToDecimal(_calculationService.CalculateNetPresentValue(calculationModel)); var presentValueOfCashFlows = netPresentValue + calculationModel.InitialCost; var previousResult = new PreviousResult(); previousResult.LifeOfProject = calculationModel.LifeOfProject; previousResult.InitialCost = calculationModel.InitialCost; previousResult.LowerBoundDiscountRate = calculationModel.LowerBoundDiscountRate; previousResult.UpperBoundDiscountRate = calculationModel.UpperBoundDiscountRate; previousResult.DiscountRateIncrement = calculationModel.DiscountRateIncrement; previousResult.NetPresentValue = netPresentValue; previousResult.PresentValueOfCashFlows = presentValueOfCashFlows; calculationModel?.CashFlows?.ForEach(x => { previousResult.CashFlows.Add(new CashFlows { Year = x.Year, Value = x.Value }); }); previousResult.CreatedDate = DateTime.UtcNow; _npvContext.AddPreviousResults(previousResult); var saveChangesResult = await _npvContext.SaveEntityChangesAsync(); if (saveChangesResult > 0) { return(Ok(new { Success = true })); } return(StatusCode((int)HttpStatusCode.InternalServerError)); }
private void Button_Click(object sender, RoutedEventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "XML Data Set (.xml)|*.xml"; if (openFileDialog.ShowDialog( ) != true) { return; } XmlDocument doc = new XmlDocument(); doc.Load(openFileDialog.FileName); int current_Person_ID = 0; Athlete athlete = new Athlete(); //CSDB context = ChampionshipSolutions.FileIO.FConnFile.getContext(); foreach (XmlElement row in doc.ChildNodes[1].ChildNodes [1].ChildNodes) { //if (current_Person_ID == 0) current_Person_ID = int.Parse(row.Attributes["People_ID"].Value); if (current_Person_ID != int.Parse(row.Attributes ["People_ID"].Value)) { //FileIO.FConnFile.SaveChanges(); // new person athlete = new Athlete( ); athlete.ID = int.Parse(row.Attributes ["People_ID"].Value); current_Person_ID = athlete.ID; athlete.FirstName = row.Attributes ["FirstName"].Value; athlete.MiddleName = row.Attributes ["MiddleName"].Value; athlete.LastName = row.Attributes ["LastName"].Value; System.Diagnostics.Debug.WriteLine("New Athlete: " + athlete.Fullname); athlete.Gender = (Gender)int.Parse(row.Attributes ["Gender"].Value); if (!string.IsNullOrWhiteSpace(row.Attributes ["DateOfBirth"].Value)) { athlete.DateOfBirth = DateTime.Parse(row.Attributes ["DateOfBirth"].Value); } if (!string.IsNullOrWhiteSpace(row.Attributes ["phoneNumber"].Value)) { athlete.AddContact(new PhoneContactDetail( ) { phoneNumber = row.Attributes ["phoneNumber"].Value }); } if (!string.IsNullOrWhiteSpace(row.Attributes ["SchoolCode"].Value)) { //athlete.Attends = context.Schools.ToArray( ).Where( s => s.ShortName == row.Attributes [ "SchoolCode" ].Value ).FirstOrDefault( ); athlete.Attends = FileIO.FConnFile.GetFileDetails().IO.GetAll <School>().ToArray( ).Where(s => s.ShortName == row.Attributes ["SchoolCode"].Value).FirstOrDefault( ); if (athlete.Attends == null) { System.Diagnostics.Debug.WriteLine("Failed to find school: " + row.Attributes ["School"].Value); } } FileIO.FConnFile.GetFileDetails( ).IO.Add <Person>(athlete); } PreviousResult pr = new PreviousResult(athlete, DateTime.Now); pr.Championship = row.Attributes ["Championship"].Value; pr.Venue = row.Attributes ["ChampionshipLocation"].Value; pr.Team = row.Attributes ["Team"].Value; pr.Event = row.Attributes ["Event"].Value; pr.Rank = row.Attributes ["Rank"].Value; if (!string.IsNullOrWhiteSpace(row.Attributes ["Value_RawValue"].Value)) { pr.Event = row.Attributes ["EventIfHeat"].Value; ResultValue rv = new ResultValue((ResultDisplayDescription)int.Parse(row.Attributes["Value_ValueType"].Value)); rv.setResult(int.Parse(row.Attributes ["Value_RawValue"].Value)); pr.ResultValue = rv.ToString( ); } athlete.AddNote(pr); //< FIELD FieldName = "School" DisplayLabel = "School" FieldType = "String" FieldClass = "TField" /> //< FIELD FieldName = "Event_ID" DisplayLabel = "Event_ID" FieldType = "Integer" FieldClass = "TField" /> //< FIELD FieldName = "VestNumber" DisplayLabel = "VestNumber" FieldType = "String" FieldClass = "TField" /> //< FIELD FieldName = "EventIDIfHeat" DisplayLabel = "EventIDIfHeat" FieldType = "Integer" FieldClass = "TField" /> //< FIELD FieldName = "FinalEventID" DisplayLabel = "FinalEventID" FieldType = "Integer" FieldClass = "TField" /> //< FIELD FieldName = "TypeDescriminator" DisplayLabel = "TypeDescriminator" FieldType = "Integer" FieldClass = "TField" /> //< FIELD FieldName = "ContactName" DisplayLabel = "ContactName" FieldType = "String" FieldClass = "TField" /> } //FileIO.FConnFile.SaveChanges( ); }
public void AddPreviousResults(PreviousResult previousResult) { PreviousResults.Add(previousResult); }