private void loginButton_Click(object sender, EventArgs e) { PC_Cafe_OrderEntities1 context = new PC_Cafe_OrderEntities1(); List <Customer> customers = context.Customers.ToList(); foreach (var x in customers) { if (x.회원id == idTextbox.Text && x.패스워드 == pwTextbox.Text) { OrderForm orderForm = new OrderForm(); LoginInfo.loginId = x.회원id; LoginInfo.customerNumber = x.회원번호; orderForm.Show(); } else if (x.회원id != idTextbox.Text != true) { MessageBox.Show("아이디와 패스워드를 확인하세요"); break; } else if (idTextbox.Text == string.Empty) { MessageBox.Show("아이디를 입력하세요"); break; } else if (pwTextbox.Text == String.Empty) { MessageBox.Show("비밀번호를 입력하세요"); break; } } }
private void OrderForm_Load(object sender, EventArgs s) { //MessageBox.Show("Test"); PC_Cafe_OrderEntities1 context = new PC_Cafe_OrderEntities1(); var query = from x in context.Foods select new FoodReportItem { FoodName = x.음식이름, Price = x.가격 }; List <FoodReportItem> foodlist = query.ToList(); foodBindingSource.DataSource = foodlist; var query1 = from x in context.Orders select new ChartItem { FoodName = x.Food.음식이름, Count = x.수량 }; List <ChartItem> list = query1.ToList(); List <ChartItem> sumChartItems = list.GroupBy(x => x.FoodName).Select( x => new ChartItem { FoodName = x.Key, Count = x.Sum(y => y.Count) }).ToList(); chartBindingSource.DataSource = sumChartItems; }
private void CheckButton_Click(object sender, EventArgs e) { db = new PC_Cafe_OrderEntities1(); List <Customer> customers = db.Customers.ToList(); bool isSame = false; foreach (var customer in customers) { if (customer.회원id.Equals(idTextbox.Text) == true) { isSame = true; break; } } if (isSame == true) { MessageBox.Show("아이디 중복입니다!"); } else { MessageBox.Show("사용가능한 아이디입니다!"); } }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { FoodReportItem item = (FoodReportItem)dataGridView1.CurrentRow.DataBoundItem; bool isExist = false; int selectedIndex = 0; foreach (ListViewItem x in orderList.Items) { if (item.FoodName == x.Text) { isExist = true; break; } selectedIndex++; } if (isExist == true) { int count = int.Parse(orderList.Items[selectedIndex].SubItems[2].Text); count++; int price = int.Parse(orderList.Items[selectedIndex].SubItems[1].Text); orderList.Items[selectedIndex].SubItems[2].Text = count.ToString(); orderList.Items[selectedIndex].SubItems[1].Text = (price + item.Price).ToString(); } else { ListViewItem listitem = new ListViewItem(item.FoodName); listitem.SubItems.Add(item.Price.ToString()); listitem.SubItems.Add("1"); orderList.Items.Add(listitem); PC_Cafe_OrderEntities1 context = new PC_Cafe_OrderEntities1(); var query = from x in context.Foods where x.음식이름 == item.FoodName select x.음식id; foodIdList.Add(query.ToList()[0]); } int sum = 0; foreach (ListViewItem x in orderList.Items) { sum += int.Parse(x.SubItems[1].Text); } totalPrice.Text = sum.ToString(); }
private void Insert() { db = new PC_Cafe_OrderEntities1(); Customer newCustomer = new Customer(); newCustomer.회원id = idTextbox.Text; newCustomer.패스워드 = pwTextbox.Text; newCustomer.성명 = nameTextbox.Text; newCustomer.전화번호 = cellphoneTextbox.Text; newCustomer.이메일 = mailTextbox.Text; newCustomer.잔여시간 = 0; //newCustomer.회원번호 = 100; db.Customers.Add(newCustomer); db.SaveChanges(); }
private void OrderOkButton_Click(object sender, EventArgs e) { PC_Cafe_OrderEntities1 context = new PC_Cafe_OrderEntities1(); int a = 0; foreach (ListViewItem x in orderList.Items) { Order order = new Order(); order.수량 = int.Parse(x.SubItems[2].Text); order.음식id = foodIdList[a]; a++; order.회원번호 = LoginInfo.customerNumber; order.주문날짜시간 = DateTime.Now; context.Orders.Add(order); } context.SaveChanges(); foodIdList.Clear(); orderList.Items.Clear(); MessageBox.Show("주문이 완료되었습니다!!"); }
private void chartButton_Click(object sender, EventArgs e) { PC_Cafe_OrderEntities1 context = new PC_Cafe_OrderEntities1(); }
private void SignUpForm_Load(object sender, EventArgs e) { db = new PC_Cafe_OrderEntities1(); }