private void DaftarMenu_CellClick(object sender, DataGridViewCellEventArgs e) { BestSeller.ClearSelection(); grpbxPesan.Enabled = true; makanan = DaftarMenu.Rows[e.RowIndex].Cells[0].Value.ToString(); Gambar(makanan); }
public List <BestSeller> GetBestsellers() { var products = from p in _context.Products select p; List <BestSeller> bestSellers = new List <BestSeller>(); Dictionary <int, int> orderItemsDic = new Dictionary <int, int>(); var orderItems = _context.OrderItems.ToList(); foreach (var oi in orderItems) { int count = 0; if (orderItemsDic.ContainsKey(oi.Product_ID)) { count = oi.Quantity + orderItemsDic[oi.Product_ID]; orderItemsDic[oi.Product_ID] = count; } else { orderItemsDic.Add(oi.Product_ID, oi.Quantity); } } int first = 0, second = 0, third = 0, firstV = 0, secondV = 0, thirdV = 0; first = orderItemsDic.OrderByDescending(x => x.Value).First().Key; second = orderItemsDic.OrderByDescending(x => x.Value).Skip(1).First().Key; third = orderItemsDic.OrderByDescending(x => x.Value).Skip(2).First().Key; firstV = orderItemsDic.OrderByDescending(x => x.Value).First().Value; secondV = orderItemsDic.OrderByDescending(x => x.Value).Skip(1).First().Value; thirdV = orderItemsDic.OrderByDescending(x => x.Value).Skip(2).First().Value; BestSeller bs1 = new BestSeller { ProductName = products.FirstOrDefault(p => p.Product_ID == first).ProductName, Quantity = firstV, Total = products.FirstOrDefault(p => p.Product_ID == first).SellingPrice *firstV }; BestSeller bs2 = new BestSeller { ProductName = products.FirstOrDefault(p => p.Product_ID == second).ProductName, Quantity = secondV, Total = products.FirstOrDefault(p => p.Product_ID == second).SellingPrice *secondV }; BestSeller bs3 = new BestSeller { ProductName = products.FirstOrDefault(p => p.Product_ID == third).ProductName, Quantity = thirdV, Total = products.FirstOrDefault(p => p.Product_ID == third).SellingPrice *thirdV }; bestSellers.Add(bs1); bestSellers.Add(bs2); bestSellers.Add(bs3); return(bestSellers); }
private void Form1_Load(object sender, EventArgs e) { SqlDataAdapter da = new SqlDataAdapter("select NamaMenu, Cast(HargaMenu as decimal) Harga from Menu", conn); DataSet ds = new DataSet(); da.Fill(ds, "Menu"); DaftarMenu.DataSource = ds.Tables["Menu"]; da = new SqlDataAdapter("select Top 2 NamaMenu, HargaMenu from Menu order by Populer desc", conn); ds = new DataSet(); da.Fill(ds, "Menu"); BestSeller.DataSource = ds.Tables["Menu"]; lblTotalPesanan.Text = "0"; DaftarMenu.Enabled = false; BestSeller.Enabled = false; TombolBayar.Enabled = false; cmbbxNoMeja.Enabled = true; DaftarMenu.ClearSelection(); BestSeller.ClearSelection(); DaftarPesanan.ClearSelection(); DaftarPesanan.DataSource = null; pictureBox1.Image = null; }
/// <summary> /// Returns a System.String containing an Xml representation of the specified property of the current object /// </summary> /// <param name="property">name of a specific property that is to be written out as Xml. /// If this value is filled in, only the <id/> node and the node for property are output. /// At the time of this writing, this is only used for product_pictures. /// </param> /// <returns></returns> public string ToXml(string property) { var xml = new XElement(_objectName); xml.Add(new XElement("id", Id.ToString())); if ((property == null || property == "product_type_id") && LogBits.BitTest(Enums.Logfield.ProductTypeId)) { xml.Add(new XElement("product_type_id", (int)ProductTypeId)); } if ((property == null || property == "name_nl") && Name_NL != null && LogBits.BitTest(Enums.Logfield.PublicProductName_NL)) { xml.Add(new XElement("name_nl", Name_NL)); } //if ((property == null || property == "name_en") && Name_EN != null && LogBits.BitTest(Enums.Logfield.PublicProductName_EN)) // xml.Add(new XElement("name_en", Name_EN)); if ((property == null || property == "songs") && LogBits.BitTest(Enums.Logfield.SongSortOrder)) { xml.Add(new XElement("songs", from song in Songs select new XElement(XElement.Parse(song.ToXml())))); } if ((property == null || property == "subtitle_nl") && LogBits.BitTest(Enums.Logfield.Subtitle_NL)) { xml.Add(new XElement("subtitle_nl", Subtitle_NL)); } if ((property == null || property == "author_id") && LogBits.BitTest(Enums.Logfield.AuthorId)) { xml.Add(new XElement("author_id", AuthorId.ToString())); } if ((property == null || property == "arranger_id") && LogBits.BitTest(Enums.Logfield.ArrangerId)) { xml.Add(new XElement("arranger_id", ArrangerId.ToString())); } if ((property == null || property == "manufacturer_id") && LogBits.BitTest(Enums.Logfield.ManufacturerId)) { xml.Add(new XElement("manufacturer_id", ManufacturerId.ToString())); } if ((property == null || property == "instrument_id") && LogBits.BitTest(Enums.Logfield.InstrumentId)) { xml.Add(new XElement("instrument_id", InstrumentId.ToString())); } if ((property == null || property == "sell_price") && !SalesPrice.IsNullOrZero() && LogBits.BitTest(Enums.Logfield.SalesPrice)) { xml.Add(new XElement("sell_price", SalesPrice)); } if ((property == null || property == "reference") && LogBits.BitTest(Enums.Logfield.ReferenceNumber)) { xml.Add(new XElement("reference", ReferenceNumber)); } if ((property == null || property == "isbn") && LogBits.BitTest(Enums.Logfield.Isbn)) { xml.Add(new XElement("isbn", Isbn)); } if ((property == null || property == "ismn") && LogBits.BitTest(Enums.Logfield.Ismn)) { xml.Add(new XElement("ismn", Ismn)); } if ((property == null || property == "ean") && LogBits.BitTest(Enums.Logfield.Ean)) { xml.Add(new XElement("ean", Ean)); } if ((property == null || property == "upc") && LogBits.BitTest(Enums.Logfield.Upc)) { xml.Add(new XElement("upc", Upc)); } if ((property == null || property == "language_id") && LogBits.BitTest(Enums.Logfield.LanguageId)) { xml.Add(new XElement("language_id", LanguageId != null ? ((int)LanguageId).ToString() : String.Empty)); } if ((property == null || property == "binding_id") && LogBits.BitTest(Enums.Logfield.BindingId)) { xml.Add(new XElement("binding_id", BindingId.ToString())); } if ((property == null || property == "grade_level") && LogBits.BitTest(Enums.Logfield.GradeLevel)) { xml.Add(new XElement("grade_level", GradeLevel)); } if ((property == null || property == "product_series_id") && LogBits.BitTest(Enums.Logfield.SeriesId)) { xml.Add(new XElement("product_series_id", SeriesId.ToString())); } if ((property == null || property == "nr_of_pages") && LogBits.BitTest(Enums.Logfield.Pages)) { xml.Add(new XElement("nr_of_pages", Pages.ToString())); } if ((property == null || property == "tax_rate_id") && LogBits.BitTest(Enums.Logfield.TaxRateId)) { xml.Add(new XElement("tax_rate_id", ((int)TaxRateId).ToString())); } if ((property == null || property == "product_pictures") && LogBits.BitTest(Enums.Logfield.ProductPictureFilename)) { xml.Add(new XElement("product_pictures", from picture in ProductPictures select new XElement(XElement.Parse(picture.ToXml())))); } if ((property == null || property == "description_nl") && LogBits.BitTest(Enums.Logfield.Description_NL)) { xml.Add(new XElement("description_nl", Description_NL)); } if ((property == null || property == "weight") && LogBits.BitTest(Enums.Logfield.Weight)) { xml.Add(new XElement("weight", Weight.ToString())); } if ((property == null || property == "length") && LogBits.BitTest(Enums.Logfield.Length)) { xml.Add(new XElement("length", Length.ToString())); } if ((property == null || property == "width") && LogBits.BitTest(Enums.Logfield.Width)) { xml.Add(new XElement("width", Width.ToString())); } if ((property == null || property == "height") && LogBits.BitTest(Enums.Logfield.Height)) { xml.Add(new XElement("height", Height.ToString())); } if ((property == null || property == "product_categories") && LogBits.BitTest(Enums.Logfield.ProductCategory)) { xml.Add(new XElement("product_categories", from category in ProductCategories select new XElement("product_category", new XElement("id", category.Id), new XElement("test", Test.ToInt())))); } if ((property == null || property == "internal_stock_qty") && LogBits.BitTest(Enums.Logfield.InternalStock)) { xml.Add(new XElement("internal_stock_qty", InternalStock.ToString())); } if ((property == null || property == "external_stock_qty") && LogBits.BitTest(Enums.Logfield.ExternalStock)) { xml.Add(new XElement("external_stock_qty", ExternalStock != null ? ExternalStock.ToString() : "1")); } if ((property == null || property == "supplier_id") && LogBits.BitTest(Enums.Logfield.SupplierId)) { xml.Add(new XElement("supplier_id", SupplierId.ToString())); } if ((property == null || property == "promotion") && LogBits.BitTest(Enums.Logfield.Promotion)) { xml.Add(new XElement("promotion", Promotion.ToInt().ToString())); } if ((property == null || property == "highlight_on_home") && LogBits.BitTest(Enums.Logfield.HighlightOnHome)) { xml.Add(new XElement("highlight_on_home", HighlightOnHome.ToInt().ToString())); } if ((property == null || property == "available") && LogBits.BitTest(Enums.Logfield.ActiveInWebshop)) { xml.Add(new XElement("available", ActiveInWebshop.ToInt().ToString())); } if ((property == null || property == "bestseller") && LogBits.BitTest(Enums.Logfield.BestSeller)) { xml.Add(new XElement("bestseller", BestSeller.ToInt().ToString())); } if ((property == null || property == "minimum_order_qty") && LogBits.BitTest(Enums.Logfield.MinimumOrderQty)) { xml.Add(new XElement("minimum_order_qty", (MinimumOrderQuantity != 0) ? MinimumOrderQuantity.ToString() : String.Empty)); } if ((property == null || property == "teacher_discount") && LogBits.BitTest(Enums.Logfield.WebshopTeacherDiscount)) { xml.Add(new XElement("teacher_discount", TeacherDiscount.ToString())); } if ((property == null || property == "reseller_discount") && LogBits.BitTest(Enums.Logfield.WebshopResellerDiscount)) { xml.Add(new XElement("reseller_discount", ResellerDiscount.ToString())); } if ((property == null || property == "search_keywords") && LogBits.BitTest(Enums.Logfield.SearchKeywords)) { xml.Add(new XElement("search_keywords", SearchKeywords)); } if ((property == null || property == "store_pickup_only") && LogBits.BitTest(Enums.Logfield.StorePickupOnly)) { xml.Add(new XElement("store_pickup_only", StorePickupOnly.ToInt().ToString())); } if ((property == null || property == "test")) { xml.Add(new XElement("test", Test.ToInt())); } if ((property == null || property == "created") && LogBits.BitTest(Enums.Logfield.CreateDttm)) { xml.Add(new XElement("created", (!CreatedDttm.IsNullOrDefault()) ? ((DateTime)CreatedDttm).ToString("yyyy-MM-dd HH:mm:ss") : String.Empty)); } if ((property == null || property == "updated") && LogBits.BitTest(Enums.Logfield.UpdateDttm)) { xml.Add(new XElement("updated", (!UpdatedDttm.IsNullOrDefault()) ? ((DateTime)UpdatedDttm).ToString("yyyy-MM-dd HH:mm:ss") : String.Empty)); } if ((property == null || property == "deleted") && LogBits.BitTest(Enums.Logfield.DeleteDttm)) { xml.Add(new XElement("deleted", (!DeletedDttm.IsNullOrDefault()) ? ((DateTime)DeletedDttm).ToString("yyyy-MM-dd HH:mm:ss") : String.Empty)); } string xmlString = xml.ToString(); return(xmlString); }
private static Boolean KawigiEdit_RunTest(int testNum, string[] p0, Boolean hasAnswer, string p1) { Console.Write("Test " + testNum + ": [" + "{"); for (int i = 0; p0.Length > i; ++i) { if (i > 0) { Console.Write(","); } Console.Write("\"" + p0[i] + "\""); } Console.Write("}"); Console.WriteLine("]"); BestSeller obj; string answer; obj = new BestSeller(); DateTime startTime = DateTime.Now; answer = obj.findBestSeller(p0); DateTime endTime = DateTime.Now; Boolean res; res = true; Console.WriteLine("Time: " + (endTime - startTime).TotalSeconds + " seconds"); if (hasAnswer) { Console.WriteLine("Desired answer:"); Console.WriteLine("\t" + "\"" + p1 + "\""); } Console.WriteLine("Your answer:"); Console.WriteLine("\t" + "\"" + answer + "\""); if (hasAnswer) { res = answer == p1; } if (!res) { Console.WriteLine("DOESN'T MATCH!!!!"); } else if ((endTime - startTime).TotalSeconds >= 2) { Console.WriteLine("FAIL the timeout"); res = false; } else if (hasAnswer) { Console.WriteLine("Match :-)"); } else { Console.WriteLine("OK, but is it right?"); } Console.WriteLine(""); return res; }