private static CompPhaseDetails GetPhaseDetails()
{
CompPhaseDetails details = new CompPhaseDetails();
details.Titile = StringUtilities.GetRandomString(10);
details.StartDate = DateTime.Now.Date.ToString("MM/dd/yyyy");
details.MaxSubmissions = 10;
return(details);
}
public void Verify_CompetitionCreateWithPhases()
{
try
{
Browser.Start();
Pages.LoginPage.Login();
DataSetDetails dataSetDetails1 = new DataSetDetails()
{
AccessString = StringUtilities.GetRandomPlainString(10), BlobURL = StringUtilities.GetRandomPlainString(10), DataSetType = PhaseDetailsPageOps.DataSetType.AzureBlob
};
DataSetDetails dataSetDetails2 = new DataSetDetails()
{
AccessString = StringUtilities.GetRandomPlainString(10), BlobURL = StringUtilities.GetRandomPlainString(10), DataSetType = PhaseDetailsPageOps.DataSetType.AzureBlobSharedAccessSignature
};
List <DataSetDetails> dsDetails = new List <DataSetDetails>();
dsDetails.Add(dataSetDetails1);
dsDetails.Add(dataSetDetails2);
CompPhaseDetails phaseDetails = new CompPhaseDetails()
{
DataSets = dsDetails, MaxSubmissions = 10, StartDate = DateTime.Now.Date.ToString("MM/dd/yyyy"), Titile = StringUtilities.GetRandomPlainString(10)
};
Pages.MyCodaLabPage.ClickMyCodaLabLink();
CompetitionDetails details = Pages.MyCodaLabPage.CreateCompetition(phaseDetails);
this.competitionTitle = phaseDetails.Titile;
Pages.MyCodaLabPage.SelectCompetitionOptionlink(MyCodaLabPageOps.CompetitionOptionLinks.Edit, details.Title);
Pages.MyCodaLabPage.CreatePage.SelectTab(CompetitionCreatePageOps.Tab.PhaseDetails);
List <CompPhaseDetails> actual = Pages.MyCodaLabPage.CreatePage.PhaseDetailsPage.GetAllPhaseDetails();
Assert.AreEqual <string>(phaseDetails.Titile, actual[0].Titile, "Phase details are not as expected");
Assert.AreEqual <string>(phaseDetails.StartDate, actual[0].StartDate, "Start date was not as expected");
Assert.AreEqual <int>(phaseDetails.MaxSubmissions, actual[0].MaxSubmissions, "Maximum submissions are not as expected");
Assert.AreEqual <MI_UI_Framework.PageOperations.PhaseDetailsPageOps.DataSetType>(phaseDetails.DataSets[0].DataSetType, actual[0].DataSets[0].DataSetType,
"Dataset type is not as expected");
Assert.AreEqual <string>(phaseDetails.DataSets[0].BlobURL, actual[0].DataSets[0].BlobURL, "Blob URL is not as expected");
Assert.AreEqual <string>(phaseDetails.DataSets[0].AccessString, actual[0].DataSets[0].AccessString, "Access string is not as expected");
Assert.IsTrue(!string.IsNullOrEmpty(actual[0].DataSets[0].DownloadURL), "Download URL was not generated");
Assert.AreEqual <MI_UI_Framework.PageOperations.PhaseDetailsPageOps.DataSetType>(phaseDetails.DataSets[1].DataSetType, actual[0].DataSets[1].DataSetType,
"Dataset type is not as expected");
Assert.AreEqual <string>(phaseDetails.DataSets[1].BlobURL, actual[0].DataSets[1].BlobURL, "Blob URL is not as expected");
Assert.AreEqual <string>(phaseDetails.DataSets[1].AccessString, actual[0].DataSets[1].AccessString, "Access string is not as expected");
this.deleteCompetition = true;
}
catch (Exception ex)
{
LogException(ex);
throw;
}
}
public static List <CompetitionDetails> InsertCompetitions(string userName, int count = 1, bool isPublic = true)
{
List <CompetitionDetails> details = new List <CompetitionDetails>();
int userId = GetUserId(userName);
string values = string.Empty;
for (int i = 0; i < count; i++)
{
string title = StringUtilities.GetRandomString(10);
string description = StringUtilities.GetRandomString(20);
string changeData = string.Format("{0:yyyy-MM-dd hh:mm:ss}", DateTime.Now);
values = string.Format("{6}(1, '{0}','{1}','',null,{2}, '{3}','{4}', '{0}','{1}','',null,{2}, '{3}','{4}',{5},0),", title, description, userId, userName, changeData, Convert.ToInt32(isPublic), values);
details.Add(new CompetitionDetails()
{
Title = title, Description = description, CreatedBy = userName, IsPublic = isPublic
});
}
values = values.Remove(values.Length - 1);
string sqlQuery = string.Format("INSERT into {0}.[dbo].[Competitions] values {1}", connection.Database, values);
SqlCommand cmd = new SqlCommand(sqlQuery, connection);
cmd.ExecuteScalar();
foreach (var item in details)
{
int competitionId = GetCompetitionID(item.Title);
InsertIntoCompetitionUserTable(competitionId, userId);
InsertIntoCompetitionpageTable(competitionId);
CompPhaseDetails phdetails1 = GetPhaseDetails();
InsertIntoCompetitionPhasesTable(competitionId, 1, 1, phdetails1.Titile, phdetails1.StartDate, phdetails1.MaxSubmissions);
CompPhaseDetails phdetails2 = GetPhaseDetails();
InsertIntoCompetitionPhasesTable(competitionId, 1, 2, phdetails2.Titile, phdetails2.StartDate, phdetails2.MaxSubmissions);
}
return(details);
}