//public List<cCompoundBow> GetBowSpecs(string BowName) public cCompoundBow GetBowSpecs(string BowName) { if (BowName != "") { cDataController db = new cDataController(); db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db"); //Name,MinDrawLength,MaxDrawLength,MinDrawWeight,MaxDrawWeight,AxleToAxle,Weight,BraceHeight,Letoff,IBOSpeed DataTable dtTmp = db.ExecuteQuery("select * from Bows where Name='" + BowName + "'"); foreach (DataRow row in dtTmp.Rows) { string Name; double MinDrawLength, MaxDrawLength, MinDrawWeight, MaxDrawWeight, AxleToAxle, Weight, BraceHeight, LetOff, IBOSpeed; Name = row["Name"].ToString(); MinDrawLength = Convert.ToDouble(row["MinDrawLength"].ToString()); MaxDrawLength = Convert.ToDouble(row["MaxDrawLength"].ToString()); MinDrawWeight = Convert.ToDouble(row["MinDrawWeight"].ToString()); MaxDrawWeight = Convert.ToDouble(row["MaxDrawWeight"].ToString()); AxleToAxle = Convert.ToDouble(row["AxleToAxle"].ToString()); Weight = Convert.ToDouble(row["Weight"].ToString()); BraceHeight = Convert.ToDouble(row["BraceHeight"].ToString()); // fix db or try catch LetOff = Convert.ToDouble(row["Letoff"].ToString()); IBOSpeed = Convert.ToDouble(row["IBOSpeed"].ToString()); cCompoundBow tmpCompoundBow = new cCompoundBow(Name, MinDrawLength, MaxDrawLength, MinDrawWeight, MaxDrawWeight, AxleToAxle, Weight, BraceHeight, LetOff, IBOSpeed); return(tmpCompoundBow); } } return(null); }
private void Populate() { cDataController db = new cDataController(); db.OpenDatabase("./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select Name from Arrows"); foreach (DataRow row in dtTmp.Rows) { for (int i = 0; i < dtTmp.Columns.Count; i++) { comboBoxUsrShafts.Items.Add(row[i]); } } dtTmp = db.ExecuteQuery("select Name from Nocks"); foreach (DataRow row in dtTmp.Rows) { for (int i = 0; i < dtTmp.Columns.Count; i++) { comboBoxUsrNock.Items.Add(row[i]); } } dtTmp = db.ExecuteQuery("select Name from Inserts"); foreach (DataRow row in dtTmp.Rows) { for (int i = 0; i < dtTmp.Columns.Count; i++) { comboBoxUsrInsert.Items.Add(row[i]); } } dtTmp = db.ExecuteQuery("select Name from NockAdapters"); foreach (DataRow row in dtTmp.Rows) { for (int i = 0; i < dtTmp.Columns.Count; i++) { comboBoxUsrNockAdapter.Items.Add(row[i]); } } dtTmp = db.ExecuteQuery("select Name from Fletches"); foreach (DataRow row in dtTmp.Rows) { comboBoxUsrFletches.Items.Add(row["Name"]); } }
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 cBroadheads FindBroadhead(string BroadheadID) { cBroadheads tmpTip = new cBroadheads(); cDataController db = new cDataController(); db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select * from broadheads where broadheadID = " + BroadheadID); foreach (DataRow row in dtTmp.Rows) { tmpTip = new cBroadheads(row["BroadheadID"].ToString(), row["Manufacturer"].ToString(), row["TipName"].ToString(), row["Type"].ToString(), row["BladeCount"].ToString(), row["Grains"].ToString(), row["CuttingDiameter"].ToString()); } return(tmpTip); }
private void HuntingWorx_Load(object sender, EventArgs e) { cDataController db = new cDataController(); db.OpenDatabase("./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select * from Species"); foreach (DataRow row in dtTmp.Rows) { //for (int i = 0; i < dtTmp.Columns.Count; i++) listBoxUsrSpecies.Items.Add(row["GeneralName"]); //comboBoxUsrShafts.Items.Add(row[i]); } }
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); }
public List <cBroadheads> GetBroadheads(string query) { List <cBroadheads> lReturnValue = new List <cBroadheads>(); cDataController db = new cDataController(); db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select * from broadheads " + query + " order by Manufacturer"); foreach (DataRow row in dtTmp.Rows) { cBroadheads tmpTip = new cBroadheads(row["BroadheadID"].ToString(), row["Manufacturer"].ToString(), row["TipName"].ToString(), row["Type"].ToString(), row["BladeCount"].ToString(), row["Grains"].ToString(), row["CuttingDiameter"].ToString()); lReturnValue.Add(tmpTip); } return(lReturnValue); }
public cShop GetShopDetails(string ShopName) { if (ShopName != "") { cDataController db = new cDataController(); db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select * from shops where ShopName='" + ShopName + "'"); foreach (DataRow row in dtTmp.Rows) { // string inShopName, string inDescription, string inMainBrands, string inArea, string inGPS, string inIndoorRange, string inOutdoorRange, string ina3Drange,string inBowTuning, string inFletching, string inEnabled, string inPromoted, string inURL cShop tmpShopDetails = new cShop(row["ShopName"].ToString(), row["Description"].ToString(), row["MainBrands"].ToString(), row["Area"].ToString(), row["GPS"].ToString(), row["IndoorRange"].ToString(), row["OutdoorRange"].ToString(), row["i3DRange"].ToString(), row["Sales"].ToString(), row["BowTuning"].ToString(), row["Fletching"].ToString(), row["Promoted"].ToString(), row["Enabled"].ToString(), row["URL"].ToString()); return(tmpShopDetails); } } return(null); }
public List <string> FindBows(string query) { List <string> lReturnValue = new List <string>(); cDataController db = new cDataController(); db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db"); string tquery = "select * from Bows where " + query + " order by Name"; DataTable dtTmp = db.ExecuteQuery(tquery); foreach (DataRow row in dtTmp.Rows) { lReturnValue.Add(row["Name"].ToString()); } return(lReturnValue); }
public List <string> GetBows() { List <string> lReturnValue = new List <string>(); cDataController db = new cDataController(); db.OpenDatabase(Directory.GetCurrentDirectory().ToString() + "./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select Name from Bows order by Name"); foreach (DataRow row in dtTmp.Rows) { for (int i = 0; i < dtTmp.Columns.Count; i++) { lReturnValue.Add(row[i].ToString()); } } return(lReturnValue); }
private double GetComboBoxValue(ComboBox cbInput, string sSearch) { string tmpSearch = cbInput.Text; double dRetvalue = 0; cDataController db = new cDataController(); db.OpenDatabase("./data/AW.db"); string query = "select * from " + sSearch + " where Name='" + tmpSearch + "'"; //MessageBox.Show(query); DataTable dtTmp = db.ExecuteQuery(query); foreach (DataRow row in dtTmp.Rows) { dRetvalue = Convert.ToDouble(row["Weight"]); } return(dRetvalue); }
private void GetInfo(string sName) { if (sName != "") { cDataController db = new cDataController(); db.OpenDatabase("./data/AW.db"); DataTable dtTmp = db.ExecuteQuery("select * from Species where GeneralName='" + sName + "'"); foreach (DataRow row in dtTmp.Rows) { txtSysSpecie.Text = row["GeneralName"].ToString(); txtSysConservationStatus.Text = row["ConservationStatus"].ToString(); txtSysFemaleMaxWeight.Text = row["FemaleWeightMax"].ToString(); txtSysFemaleMinWeight.Text = row["FemaleWeightMin"].ToString(); txtSysMaleMaxWeight.Text = row["MaleWeightMax"].ToString(); txtSysMaleMinWeight.Text = row["MaleWeightMin"].ToString(); txtSysHeightMax.Text = row["HeightMax"].ToString(); txtSysHeightMin.Text = row["HeightMin"].ToString(); txtSysLengthMax.Text = row["LengthMax"].ToString(); txtSysLengthMin.Text = row["LengthMin"].ToString(); txtSysDescription.Text = row["Description"].ToString(); string Image1 = "./img/" + row["Image1"].ToString(); //string Image1 = "\""+Directory.GetCurrentDirectory() + "\\img\\" + row["Image1"].ToString()+"\""; //MessageBox.Show(Image1); //pictureBox.ImageLocation = Image1; //ArcheryWorx.Properties.Resources.Right_Tear; //this.pictureBox1.Image = Image.FromFile(PicURI); pictureBoxMain.Image = Image.FromFile(Image1); pictureBoxMain.Refresh(); } } else { MessageBox.Show("No Animal Selected"); } }