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