private static void ImportStndardSet(Guid jurisdictionsKey, StandardSet standardSet)
{
Guid standardSetsKey = Guid.NewGuid();
ImportStandardSetCore(jurisdictionsKey, standardSetsKey, standardSet);
ImportDocument(standardSet.Document, standardSetsKey);
}
/// <summary>
/// input show more form fields
/// </summary>
public void InputFormFieldsShowMore()
{
if (string.IsNullOrEmpty(Data.DataCollectionStatus) == false)
{
DataCollectionStatus.SelectByText(Data.DataCollectionStatus);
}
if (string.IsNullOrEmpty(Data.TestContent) == false)
{
TestContent.SendKeys(Data.TestContent);
}
if (string.IsNullOrEmpty(Data.TestCreatorFirstname) == false)
{
TestCreatorFirstname.SendKeys(Data.TestCreatorFirstname);
}
if (string.IsNullOrEmpty(Data.TestCreatorLastname) == false)
{
TestCreatorLastname.SendKeys(Data.TestCreatorLastname);
}
if (string.IsNullOrEmpty(Data.StandardSet) == false)
{
StandardSet.SelectByText(Data.StandardSet);
}
if (string.IsNullOrEmpty(Data.Institution) == false)
{
Institution.SendKeys(Data.Institution);
}
if (string.IsNullOrEmpty(Data.TestCategory) == false)
{
TestCategory.SelectByText(Data.TestCategory);
}
if (string.IsNullOrEmpty(Data.AdaptiveTests) == false)
{
AdaptiveTests.SelectByText(Data.AdaptiveTests);
}
if (string.IsNullOrEmpty(Data.Publisher) == false)
{
Publisher.SendKeys(Data.Publisher);
}
if (string.IsNullOrEmpty(Data.ExternalTestId) == false)
{
ExternalTestId.SendKeys(Data.ExternalTestId);
}
}
private static void ImportStandardSetCore(Guid jurisdictionsKey, Guid standardSetsKey, StandardSet standardSet)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
using (SqlCommand command = new SqlCommand("sp_insert_tbl_standard_sets", connection))
{
connection.Open();
command.CommandType = CommandType.StoredProcedure;
SqlParameter retVal = command.Parameters.Add("RetVal", SqlDbType.Int);
retVal.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(new SqlParameter("@standard_sets_key", standardSetsKey));
command.Parameters.Add(new SqlParameter("@jurisdictions_key", jurisdictionsKey));
command.Parameters.Add(new SqlParameter("@standard_sets_id", standardSet.Id));
command.Parameters.Add(new SqlParameter("@standard_sets_subject", standardSet.Subject));
command.Parameters.Add(new SqlParameter("@standard_sets_title", standardSet.Title));
command.Parameters.Add(new SqlParameter("@standard_sets_educationLevels", standardSet.GetEducationLevels()));
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
}
reader.Close();
}
}
public void VerifyFieldsExist(List<ViewPortalResultsSearchFields> requiredFields)
{
//input the required fields
foreach (var requiredField in requiredFields)
{
//wait for the fields. To check if the field is visible.
//If field is visible, the field exist
if (requiredField.Equals(ViewPortalResultsSearchFields.TestNameId))
{
TestNameId.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.Subject))
{
this.SubjectSelect.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.GradeLevelFrom))
{
this.GradeFromSelect.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.GradeLevelTo))
{
this.GradeToSelect.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.AdminDateRangeFrom))
{
AdminDateRangeFrom.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.AdminDateRangeTo))
{
AdminDateRangeTo.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.DataCollectionStatus))
{
DataCollectionStatus.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.TestContent))
{
TestContent.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.TestCreatorFirstname))
{
TestCreatorFirstName.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.TestCreatorLastname))
{
TestCreatorLastName.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.StandardSet))
{
StandardSet.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.AdaptiveTests))
{
AdaptiveTests.Wait(3);
}
if (requiredField.Equals(ViewPortalResultsSearchFields.TestCategory))
{
TestCategory.Wait(3);
}
}
}
//implemented methods
public override void InputFormFields()
{
if (Data.TestNameId != null)
{
TestNameId.Clear();
TestNameId.SendKeys(Data.TestNameId);
}
if (Data.Subject != null)
{
SubjectSelect.Wait().SelectByText(Data.Subject);
}
if (Data.GradeLevelFrom != null)
{
GradeFromSelect.Wait().SelectByText(Data.GradeLevelFrom);
}
if (Data.GradeLevelTo != null)
{
GradeToSelect.Wait().SelectByText(Data.GradeLevelTo);
}
if (Data.AdminDateRangeFrom != null)
{
AdminDateRangeFrom.Clear();
AdminDateRangeFrom.SendKeys(Data.AdminDateRangeFrom);
}
if (Data.AdminDateRangeTo != null)
{
AdminDateRangeTo.Clear();
AdminDateRangeTo.SendKeys(Data.AdminDateRangeTo);
}
switch (GridName)
{
case ViewPortalResultsGridNames.MyTests:
if (isAdvancedSearchExpanded)
{
if (Data.DataCollectionStatus != null)
{
DataCollectionStatus.SelectByText(Data.DataCollectionStatus);
}
if (Data.TestContent != null)
{
TestContent.Clear();
TestContent.SendKeys(Data.TestContent);
}
if (Data.StandardSet != null)
{
StandardSet.SelectByText(Data.StandardSet);
}
if (Data.AdaptiveTests != null)
{
AdaptiveTests.SelectByText(Data.AdaptiveTests);
}
}
break;
case ViewPortalResultsGridNames.InProgressTests:
if (isAdvancedSearchExpanded)
{
if (Data.TestContent != null)
{
TestContent.Clear();
TestContent.SendKeys(Data.TestContent);
}
if (Data.TestCreatorFirstName != null)
{
TestCreatorFirstName.Clear();
TestCreatorFirstName.SendKeys(Data.TestCreatorFirstName);
}
if (Data.TestCreatorLastName != null)
{
TestCreatorLastName.Clear();
TestCreatorLastName.SendKeys(Data.TestCreatorLastName);
}
if (Data.StandardSet != null)
{
StandardSet.SelectByText(Data.StandardSet);
}
if (Data.AdaptiveTests != null)
{
AdaptiveTests.SelectByText(Data.AdaptiveTests);
}
}
else
{
if (Data.DataCollectionStatus != null)
{
DataCollectionStatus.SelectByText(Data.DataCollectionStatus);
}
}
break;
case ViewPortalResultsGridNames.ScheduledTests:
if (isAdvancedSearchExpanded)
{
if (Data.DataCollectionStatus != null)
{
DataCollectionStatus.SelectByText(Data.DataCollectionStatus);
}
if (Data.TestContent != null)
{
TestContent.Clear();
TestContent.SendKeys(Data.TestContent);
}
if (Data.TestCreatorFirstName != null)
{
TestCreatorFirstName.Clear();
TestCreatorFirstName.SendKeys(Data.TestCreatorFirstName);
}
if (Data.TestCreatorLastName != null)
{
TestCreatorLastName.Clear();
TestCreatorLastName.SendKeys(Data.TestCreatorLastName);
}
if (Data.StandardSet != null)
{
StandardSet.SelectByText(Data.StandardSet);
}
if (Data.AdaptiveTests != null)
{
AdaptiveTests.SelectByText(Data.AdaptiveTests);
}
}
break;
case ViewPortalResultsGridNames.RecommendedTests:
if (isAdvancedSearchExpanded)
{
if (Data.TestContent != null)
{
TestContent.Clear();
TestContent.SendKeys(Data.TestContent);
}
if (Data.TestCreatorFirstName != null)
{
TestCreatorFirstName.Clear();
TestCreatorFirstName.SendKeys(Data.TestCreatorFirstName);
}
if (Data.TestCreatorLastName != null)
{
TestCreatorLastName.Clear();
TestCreatorLastName.SendKeys(Data.TestCreatorLastName);
}
if (Data.StandardSet != null)
{
StandardSet.SelectByText(Data.StandardSet);
}
if (Data.AdaptiveTests != null)
{
AdaptiveTests.SelectByText(Data.AdaptiveTests);
}
}
else
{
if (Data.TestCategory != null)
{
TestCategory.SelectByText(Data.TestCategory);
}
}
break;
default:
throw new ArgumentOutOfRangeException();
}
}
public async void OnLoaded()
{
this.Downloads = new List <DownloadViewModel>();
Downloads.Add(new DownloadViewModel("Basic")
{
FileName = "BASIC",
ChnName = "基础系列",
FullFileName = "BASIC.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=BASIC.zip", HOST),
Progress = 0,
Size = 85,
Mode = "standard",
});
Downloads.Add(new DownloadViewModel("BRM")
{
FileName = "BRM",
ChnName = "黑石山的火焰",
FullFileName = "BRM.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=BRM.zip", HOST),
Progress = 0,
Size = 5,
Mode = "standard",
});
Downloads.Add(new DownloadViewModel("GVG")
{
FileName = "GVG",
ChnName = "地精大战侏儒",
FullFileName = "GVG.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=GVG.zip", HOST),
Progress = 0,
Size = 25,
Mode = "wild",
});
Downloads.Add(new DownloadViewModel("LOE")
{
FileName = "LOE",
ChnName = "探险者协会",
FullFileName = "LOE.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=LOE.zip", HOST),
Progress = 0,
Size = 9,
Mode = "standard",
});
Downloads.Add(new DownloadViewModel("NAX")
{
FileName = "NAX",
ChnName = "纳克萨玛斯",
FullFileName = "NAX.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=NAX.zip", HOST),
Progress = 0,
Size = 5,
Mode = "wild",
});
Downloads.Add(new DownloadViewModel("OG")
{
FileName = "OG",
ChnName = "古神的低语",
FullFileName = "OG.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=OG.zip", HOST),
Progress = 0,
Size = 28,
Mode = "standard",
});
Downloads.Add(new DownloadViewModel("AT")
{
FileName = "AT",
ChnName = "冠军的试炼",
FullFileName = "AT.zip",
Address = string.Format("http://{0}/HSDecks/Home/Download?ImageName=AT.zip", HOST),
Progress = 0,
Size = 26,
Mode = "standard",
});
foreach (var set in Downloads)
{
var s = await ApplicationData.Current.LocalFolder.TryGetItemAsync(set.FullFileName);
if (s != null)
{
set.Complete();
}
}
StandardSet = Downloads.Where(p => p.Mode == "standard").ToList();
WildSet = Downloads.Where(p => p.Mode == "wild").ToList();
StandardSet.ForEach(p => p.PropertyChanged += this.NotifyStandardSetCount);
WildSet.ForEach(p => p.PropertyChanged += this.NotifyWildSetCount);
Downloads.ForEach(p => p.PropertyChanged += this.UpdateCardImage);
await refreshPageAsync();
await DeckInitializing();
}
