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