public cArcherEvent FindArcherEvent(string EventID)
{
cArcherEvent tmpEventEntry = new cArcherEvent();
cDataController db = new cDataController();
db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db");
DataTable dtTmp = db.ExecuteQuery("select * from ArcherHistory where AcherHistory = " + EventID);
foreach (DataRow row in dtTmp.Rows)
{
tmpEventEntry = new cArcherEvent(row["ArcherHistory"].ToString(), row["ArcherName"].ToString(), row["Organization"].ToString(), row["EventName"].ToString(), row["EventDate"].ToString(), row["Note"].ToString(), row["Score"].ToString());
}
return(tmpEventEntry);
}
public List <cArcherEvent> GetArcherEvent(string query)
{
List <cArcherEvent> lReturnValue = new List <cArcherEvent>();
cArcherEvent tmpEventEntry = new cArcherEvent();
cDataController db = new cDataController();
db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db");
DataTable dtTmp = db.ExecuteQuery("select * from ArcherHistory " + query + "");
foreach (DataRow row in dtTmp.Rows)
{
tmpEventEntry = new cArcherEvent(row["ArcherHistory"].ToString(), row["ArcherName"].ToString(), row["Organization"].ToString(), row["EventName"].ToString(), row["EventDate"].ToString(), row["Note"].ToString(), row["Score"].ToString());
lReturnValue.Add(tmpEventEntry);
}
return(lReturnValue);
}
