public ActionResult NewOpp() { var con = ConfigurationManager.ConnectionStrings["REVENUE"].ToString(); var model = new List <Oppurtunity>(); using (SqlConnection myConnection = new SqlConnection(con)) { string oString = "SELECT * FROM[RevenueDB].[dbo].[Oppurtunity]"; SqlCommand oCmd = new SqlCommand(oString, myConnection); myConnection.Open(); using (SqlDataReader oReader = oCmd.ExecuteReader()) { while (oReader.Read()) { Oppurtunity oppur = new Oppurtunity(); oppur.AccountName = oReader["AccountName"].ToString(); oppur.Portfolio = oReader["Portfolio"].ToString(); oppur.OppurtunityType = oReader["OppurtunityType"].ToString(); oppur.OppurtunityNo = oReader["OppurtunityNo"].ToString(); oppur.OppurtunityName = oReader["OppurtunityName"].ToString(); oppur.OppurtunityDescription = oReader["OppurtunityDescription"].ToString(); oppur.ProjectType = oReader["ProjectType"].ToString(); oppur.RFPDT = Convert.ToDateTime(oReader["RFPDT"]); oppur.ProposalSubmissionDate = Convert.ToDateTime(oReader["ProposalSubmissionDate"]); oppur.NegitationClosureDate = Convert.ToDateTime(oReader["NegitationClosureDate"]); oppur.LOIDT = Convert.ToDateTime(oReader["LOIDT"]); oppur.WinningProbability = Convert.ToInt64(oReader["WinningProbability"]); oppur.OnDateClosureProbability = Convert.ToInt64(oReader["OnDateClosureProbability"]); oppur.SignatureExpectedDate = Convert.ToDateTime(oReader["SignatureExpectedDate"]); model.Add(oppur); } myConnection.Close(); } } return(View(model)); }
public void ShowOtherVenuesAndDatesTest(bool otherVenuesExists) { // Arrange var courseDetailsCourseDetails = new _MVC_Views_CourseDetails_OtherDatesAndVenues_cshtml(); var courseDetailsViewModel = new CourseDetailsViewModel(); var courseDetails = new CourseDetails(); courseDetailsViewModel.CourseDetails.VenueDetails = new Venue(); if (otherVenuesExists) { courseDetailsViewModel.CourseDetails.Oppurtunities = new System.Collections.Generic.List <Oppurtunity>(); var otherDatesAndVenues = new Oppurtunity(); courseDetailsViewModel.CourseDetails.Oppurtunities.Add(otherDatesAndVenues); courseDetailsViewModel.CourseDetails.Oppurtunities.FirstOrDefault().VenueName = nameof(CourseDetails.Oppurtunities); } else { courseDetailsViewModel.CourseDetails.Oppurtunities = null; courseDetailsViewModel.NoOtherDateOrVenueAvailableMessage = nameof(CourseDetailsViewModel.NoOtherDateOrVenueAvailableMessage); } // Act var htmlDocument = courseDetailsCourseDetails.RenderAsHtml(courseDetailsViewModel); // Assert if (otherVenuesExists) { htmlDocument.DocumentNode.Descendants("td") .Any(div => div.Attributes["class"].Value.Contains("govuk-table__cell") && div.InnerText.Contains(courseDetailsViewModel.CourseDetails.Oppurtunities.FirstOrDefault().VenueName)).Should().BeTrue(); } else { htmlDocument.DocumentNode.Descendants("td") .Any(div => div.Attributes["class"].Value.Contains("govuk-table__cell") && div.InnerText.Contains(courseDetailsViewModel.NoOtherDateOrVenueAvailableMessage)).Should().BeTrue(); } }
public void OtherVenuesStartdatesTest(bool startDateIsNull) { //Arrange var startDate = DateTime.Now; var courseDetailsCourseDetails = new _MVC_Views_CourseDetails_OtherDatesAndVenues_cshtml(); var courseDetailsViewModel = new CourseDetailsViewModel(); var courseDetails = new CourseDetails(); courseDetailsViewModel.CourseDetails.VenueDetails = new Venue(); courseDetailsViewModel.CourseDetails.Oppurtunities = new System.Collections.Generic.List <Oppurtunity>(); var otherDatesAndVenues = new Oppurtunity(); if (!startDateIsNull) { otherDatesAndVenues.StartDate = startDate; } courseDetailsViewModel.CourseDetails.Oppurtunities.Add(otherDatesAndVenues); // Act var htmlDocument = courseDetailsCourseDetails.RenderAsHtml(courseDetailsViewModel); var expectedStartDate = $"{string.Format("{0:dd MMMM yyyy}", startDate)}"; var dateCell = htmlDocument.DocumentNode.SelectNodes("//table[1]/tbody/tr[2]/td[2]").FirstOrDefault().InnerText; // Assert if (startDateIsNull) { dateCell.Should().NotContain(expectedStartDate); } else { dateCell.Should().Contain(expectedStartDate); } }