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