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);
}
private void Fill(string ShopName)
{
cShopTools tmpTools = new cShopTools();
cShop ShopDetails = tmpTools.GetShopDetails(ShopName);
groupBoxShop.Text = ShopDetails.ShopName;
txtDescription.Text = ShopDetails.Description;
lblURL.Text = ShopDetails.URL;
txtBrands.Text = ShopDetails.MainBrands;
lblIndoorRange.Text = ShopDetails.IndoorRange;
lblOutdoorRange.Text = ShopDetails.OutdoorRange;
lblBowTuning.Text = ShopDetails.BowTuning;
lbl3Drange.Text = ShopDetails.a3DRange;
lblFletching.Text = ShopDetails.Fletching;
lblSales.Text = ShopDetails.Sales;
lblArea.Text = ShopDetails.Area;
lblGPS.Text = ShopDetails.GPS;
}
