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