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