/// <summary> /// returns a List of all information about the products (limit:200) /// </summary> private async Task<List<Product>> GetFullProductsAsync() { MySqlDataReader reader = this.Query("SELECT * FROM gk_pricing ORDER BY product ASC LIMIT 0,200"); List<Product> list = new List<Product>(); while (await reader.ReadAsync()) { Product product = new Product(); try { product.comment = reader.GetString("comment"); } catch { } product.ID = reader.GetInt32("ID"); product.price = reader.GetDouble("price"); product.product = reader.GetString("product"); list.Add(product); } reader.Close(); this.Close(); return list; }
/// <summary> /// Basing on the submitted Form, check which elements are dirty (changes) /// </summary> public List<Product> CheckDirtyElements() { // Get number of Elements int amount = int.Parse((string)Request.Form["ctl00$MainContent$entryCount"]); List<Product> list = new List<Product>(); // Check one by one... for (int i=0;i<amount;i++) { if ((string)Request.Form["ctl00$MainContent$repProd$ctl"+i.ToString("D2")+"$textName"] != (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textNameOld"] || (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textComment"] != (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textCommentOld"] || (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textPrice"] != (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textPriceOld"]) { //Response.Write("Test"); // Found a dirty item, Create a User for this and store data int id = (int.Parse((string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textID"])); Product product = new Product(); product.comment = (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textComment"]; try { string debtString = (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textPrice"]; //debtString = debtString.Replace(",", "."); //product.price = Double.Parse(debtString, System.Globalization.NumberStyles.AllowDecimalPoint, System.Globalization.CultureInfo.InvariantCulture); product.price = Global.String2Double(debtString); //Response.Write(product.price); /*System.Globalization.CultureInfo EnglishCulture = new System.Globalization.CultureInfo("en-EN"); product.price = Double.Parse(debtString, System.Globalization.NumberStyles.Float, EnglishCulture);*/ } catch { // not valid double value StateMessage = "Please provide valid values for price! (Aborting)"; return new List<Product>(); } product.ID = id; product.product = (string)Request.Form["ctl00$MainContent$repProd$ctl" + i.ToString("D2") + "$textName"]; if (product.comment == null) product.comment = String.Empty; list.Add(product); } // Todo: Deletions } return list; }