// 2016 Method of converting XML results to Vest Action
public static VestActions dataRowToVestAction(DataRow dr)
{
VestActions va = new VestActions();
try
{
va.WebID = Convert.ToInt32(getStringSafe(dr, "ID"));
va.Description = (string)dr["Description"];
va.DateStamp = DateTime.Now; // DateTime.Parse((string)dr["TimeStamp"]);
va.Vest = getStringSafe(dr, "Vest");
va.ChampionshipName = (string)dr["Championship"];
va.EventCode = getStringSafe(dr, "EventCode");
va.Position = Convert.ToInt32(getStringSafe(dr, "Position"));
string time = getStringSafe(dr, "Time");
if (!string.IsNullOrWhiteSpace(time))
{
va.Time = TimeSpan.Parse(time);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Failed to generate vest from DataRow");
System.Diagnostics.Debug.WriteLine("\t" + ex.Message);
return(null);
}
return(va);
}
private void InsertPlaceholderResult(VestActions va)
{
if (string.IsNullOrWhiteSpace(va.EventCode))
{
return;
}
Championship CChampionship = ((App)App.Current).CurrentChampionship.Championship;
AEvent Event = CChampionship.listAllEvents().Where(e => e.ShortName == va.EventCode).FirstOrDefault();
if (Event == null)
{
// do nothing as the event could not be found so ignore this VestAction
return;
}
try
{
Event.AddPlaceholderResult();
isProcessed = true;
}
catch (Exception)
{
throw new ArgumentException("Failed to enter placeholder result for: " + Event.Name);
}
}
private void DeleteResult(VestActions va)
{
if (va.Vest == null)
{
return;
}
Championship CChampionship = ((App)App.Current).CurrentChampionship.Championship;
List <ACompetitor> Competitors = CChampionship.getCompetitor(va.Vest);
if (Competitors.Count == 0)
{
// Competitor could not be found
// We don't have to hold here.
// We will assume this is an error on the data input part and ignore this request.
//isProcessed = true;
}
else if (Competitors.Count == 1)
{
// one competitor was found
throw new NotImplementedException();
}
else if (Competitors.Count > 1)
{
// more than one competitor was found
throw new NotImplementedException();
}
}
private void getRawResultsData()
{
rawResults = new List <VestActions>();
//webGetData getData = new webGetData("VestActions.aspx");
//DataSet ds = getData.getDataSet();
// Load XML File from OneDrive Local directory
string ChampionshipName = ((App)App.Current).CurrentChampionship.Name;
//string fileName = @"D:\OneDrive\Championship Solutions\" + ChampionshipName + "_Results.xml";
string onedrivePath = @"C:\Users\Frase\OneDrive";
string tempPath = @"\Championship Solutions\" + ChampionshipName + "_Results.xml";
string fileName = onedrivePath + tempPath;
try
{
string t;
const string userRoot = "HKEY_CURRENT_USER";
//const string subkey =@"Software\Microsoft\CurrentVersion\SkyDrive";
const string subkey = @"Software\SyncEngines\Providers\OneDrive\Personal";
const string keyName = userRoot + "\\" + subkey;
t = (string)Registry.GetValue(keyName, "MountPoint", fileName);
if (t == null)
{
throw new Exception("Not onedrive path found");
}
if (t != onedrivePath)
{
fileName = t + tempPath;
}
}
catch
{ }
if (System.IO.File.Exists(fileName))
{
DataSet ds = new DataSet();
ds.ReadXml(fileName);
if (ds.Tables.Count == 1)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
VestActions va = dataRowToVestAction(dr);
if (va != null)
{
rawResults.Add(va);
}
}
}
}
}
// added so that a manual entry of a vest number could take place
// 2017-12-16
private void InsertResult(string Vest)
{
var va = new VestActions( )
{
Vest = Vest, Description = "InsertResultVest"
};
if (InsertResult(va))
{
// processed
Championship CChampionship = ((App)App.Current).CurrentChampionship.Championship;
CChampionship.AddVestAction(va);
}
else
{
MessageBox.Show("Failed to insert result");
}
}
private void DeletePlaceholderResult(VestActions va)
{
if (string.IsNullOrWhiteSpace(va.EventCode))
{
return;
}
Championship CChampionship = ((App)App.Current).CurrentChampionship.Championship;
AEvent Event = CChampionship.listAllEvents().Where(e => e.ShortName == va.EventCode).FirstOrDefault();
if (Event == null)
{
// do nothing as the event could not be found so ignore this VestAction
return;
}
throw new NotImplementedException();
}
private bool InsertResult(VestActions va)
{
if (va.Vest == null)
{
return(false);
}
Championship CChampionship = ((App)App.Current).CurrentChampionship.Championship;
List <ACompetitor> Competitors = CChampionship.getCompetitor(va.Vest);
if (Competitors.Count == 0)
{
// Competitor could not be found
// We must hold here until a vest has been entered or this VestAction has been overwritten
// (added to the processed set)
if (va.Vest == "001")
{
va.EventCode = "MB";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
va.Save( );
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
return(true);
}
if (va.Vest == "002")
{
va.EventCode = "MG";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
if (va.Vest == "003")
{
va.EventCode = "JB";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
if (va.Vest == "004")
{
va.EventCode = "JG";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
if (va.Vest == "005")
{
va.EventCode = "IB";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
if (va.Vest == "006")
{
va.EventCode = "IG";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
if (va.Vest == "007")
{
va.EventCode = "SB";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
if (va.Vest == "008")
{
va.EventCode = "SG";
InsertPlaceholderResult(va);
va.statusDescription = string.Format("Placeholder for {0}", va.EventCode);
MessageBox.Show("A placeholder has been entered for " + va.EventCode);
va.Save( );
return(true);
}
va.statusDescription = string.Format("A competitor could not be found for vest {0}", va.Vest);
MessageBox.Show("A competitor could not be found for vest " + va.Vest);
return(false);
}
else if (Competitors.Count == 1)
{
// one competitor was found
try
{
Competitors[0].CompetingIn.AddResult(Competitors[0]);
va.statusDescription = string.Format("Competitor Added: {0} {1}", Competitors[0].getName(), Competitors[0].CompetingIn.Name);
va.Save( );
isProcessed = true;
return(true);
}
catch (Exception ex)
{
if (!string.IsNullOrWhiteSpace(va.statusDescription))
{
va.statusDescription += string.Format("Error State: {0}", ex.Message);
}
else
{
va.statusDescription = string.Format("Error State: {0}", ex.Message);
}
MessageBox.Show("Failed to insert a vest" + va.Vest + "because: " + ex.Message);
va.Save( );
return(false);
}
}
else if (Competitors.Count > 1)
{
// more than one competitor was found
va.statusDescription = "Error State: More than one competitor was returned";
MessageBox.Show("More than one competitor was found for vest " + va.Vest);
va.Save( );
return(false);
}
return(false);
}
