/// <summary> /// adding item to order /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonOrderItemsInOrderTab_Click(object sender, EventArgs e) { if (textBoxOrderNumberInOrderTab.Text == "" || !(comboBoxOrderItemsInAddOrderTab.SelectedIndex > -1)) { MessageBox.Show("please enter value by double click on the order \n Or choosing product"); } else { using (testDBEntities db = new testDBEntities()) { t_Items item = db.t_Items.Where(x => x.ItemDescription.Equals(comboBoxOrderItemsInAddOrderTab.Text)).FirstOrDefault(); model_OrdersItem.t_Items = item; t_Orders order = db.t_Orders.Where(x => x.ID == model_t_Orders.ID).FirstOrDefault(); long order_id = order.ID; model_OrdersItem.t_Orders = order; db.OrdersItems.Add(model_OrdersItem); db.SaveChanges(); evalTotalAmount(order_id); ClearDataGridView_t_Orders(); populateDataGridView_t_Orders(); MessageBox.Show("Added Successfully"); } } }
/// <summary> /// evaluting total amount in order after add/del item /// </summary> /// <param name="order_id"></param> private void evalTotalAmount(long order_id) { using (testDBEntities db = new testDBEntities()) { //MessageBox.Show(m_order_item.t_Orders.ID.ToString()); List <OrdersItem> all_OrdersItems = db.OrdersItems.Where(x => x.t_Orders.ID == order_id).ToList <OrdersItem>(); decimal total = 0; foreach (OrdersItem order_item in all_OrdersItems) { total += (decimal)order_item.t_Items.ItemPrice; } t_Orders order = db.t_Orders.Where(x => x.ID == order_id).FirstOrDefault(); order.TotalAmount = total; db.Entry(order).State = EntityState.Modified; db.SaveChanges(); } }
/// <summary> /// insert data to textbox's by clicking on row of datagridview /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataGridViewOrders_DoubleClick(object sender, EventArgs e) { if (dataGridViewOrders.CurrentRow.Index != -1) { model_t_Orders.ID = Convert.ToInt32(dataGridViewOrders.CurrentRow.Cells["_ID"].Value); using (testDBEntities db = new testDBEntities()) { model_t_Orders = db.t_Orders.Where(x => x.ID == model_t_Orders.ID).FirstOrDefault(); textBoxRefaundAmount.Text = model_t_Orders.RefaundAmount.ToString(); textBoxOrders_CustName.Text = model_t_Orders.CustomerName; textBoxOrdersCust_Adress.Text = model_t_Orders.CustomerAddress; textBoxCustomerPhone.Text = model_t_Orders.CustomerPhone; textBoxOrdersToatl.Text = model_t_Orders.TotalAmount.ToString(); dateTimePickerOrders.Text = model_t_Orders.OrderDate.ToString(); textBoxOrdersCustomerCity.Text = model_t_Orders.CustomerCity; textBoxOrderNumberInOrderTab.Text = model_t_Orders.OrderNumber; } } }