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