private void btnPay_Click(object sender, EventArgs e) { string phrase = txtCash.Text; double number; bool isNumeric = double.TryParse(phrase, out number); if ((phrase.Length < 9) && (isNumeric == true)) { if ((Convert.ToInt32(txtCash.Text) > -1) && (Convert.ToDouble(txtCash.Text) >= Globals.AmountDue)) { Payment pay = new Payment(); Payment_Type type = db.Payment_Type.FirstOrDefault(c => c.Payment_Description == "Cash"); pay.Payment_Amount = Convert.ToDouble(Globals.AmountDue); pay.Payment_Date = DateTime.Today; pay.Payment_Type_ID = type.Payment_Type_ID; db.Payments.Add(pay); db.SaveChanges(); Globals.SalesPaymentID = pay.Payment_ID; btnEatIn.Visible = true; lblChangeNew.Text = (Convert.ToDouble(txtCash.Text) - Globals.AmountDue).ToString(); } else { MessageBox.Show("Error: Cash can't be less than one/Cash not enough"); } } else { MessageBox.Show("Error: Cash not numeric,please anter a numeric value(integer)"); } }
private void button1_Click(object sender, EventArgs e) { string phrase = txtOrderNo.Text; double number; bool isNumeric = double.TryParse(phrase, out number); if ((phrase.Length < 9) && (isNumeric == true)) { if (Convert.ToInt32(txtOrderNo.Text) > -1) { int id = Convert.ToInt32(txtOrderNo.Text); DeliveryTable orderD = db.DeliveryTables.FirstOrDefault(c => c.OrderId == id); if (orderD == null) { MessageBox.Show("Order not found"); return; } Payment pay = new Payment(); Payment_Type type = db.Payment_Type.FirstOrDefault(c => c.Payment_Description == "Cash"); pay.Payment_Amount = Convert.ToDouble(Globals.AmountDue); pay.Payment_Date = DateTime.Today; db.Payments.Add(pay); db.SaveChanges(); Globals.SalesPaymentID = pay.Payment_ID; Customer_Order order = new Customer_Order(); string name = orderD.customerName; dynamic num = orderD.customerContact; int contact = num; Customer custom = db.Customers.FirstOrDefault(c => (c.Customer_Name == name) && (c.Customer_Contact_Number == contact)); //Object Declaration---------------------------------// try { Company_Information inf = db.Company_Information.FirstOrDefault(c => c.Company_Info_ID == 1); //-----------------------------------------------------// //Order Details insert------------------------------------// order.Order_Status = "D"; order.Order_Date = DateTime.Now; order.Payment_ID = 2;// db.Payments.LastOrDefault().Payment_ID; order.Delivery_Status_ID = 1; order.OrderNotes = orderD.orderNotesf; order.OrderTotal = orderD.orderTotal; order.TotalItems = orderD.totalItemsf; order.Sale_Vat_Amount = Globals.vatAmountDelivery; order.Customer_ID = custom.Customer_ID; //---------------------------------------------------------// db.Customer_Order.Add(order); db.SaveChanges(); } catch (Exception i) { MessageBox.Show(Convert.ToString(i)); } int orderNo = orderD.OrderId; var combos = from obj in db.DeliveryLines where (obj.orderId == orderNo) && (obj.comboItemId != null) select new { itemId = obj.comboItemId, itemQuantity = obj.comboItemQuantity }; foreach (var item in combos) { //MessageBox.Show(Convert.ToString(order.Order_ID)+ " " + Convert.ToString(order.Order_ID)); Customer_Order_Line orderLine = new Customer_Order_Line(); orderLine.Customer_Order_ID = order.Order_ID; orderLine.Combo_Quantity = item.itemQuantity; orderLine.Combo_ID = item.itemId; db.Customer_Order_Line.Add(orderLine); } var menus = from obj2 in db.DeliveryLines where (obj2.orderId == orderNo) && (obj2.menuItemId != null) select new { itemId = obj2.menuItemId, itemQuantity = obj2.menuItemQuantity }; foreach (var item2 in menus) { //MessageBox.Show(Convert.ToString( item.itemQuantity) + Convert.ToString(item.itemId)); Customer_Order_Line orderLine = new Customer_Order_Line(); orderLine.Customer_Order_ID = order.Order_ID; orderLine.Menu_Item_Quantity = item2.itemQuantity; orderLine.Menu_Item_ID = item2.itemId; db.Customer_Order_Line.Add(orderLine); } var stocks = from obj3 in db.DeliveryLines where (obj3.orderId == orderNo) && (obj3.stockItemId != null) select new { itemId = obj3.stockItemId, itemQuantity = obj3.stockItemQuantity }; foreach (var item3 in stocks) { Customer_Order_Line orderLine = new Customer_Order_Line(); orderLine.Customer_Order_ID = order.Order_ID; orderLine.Menu_Item_Quantity = item3.itemQuantity; orderLine.Menu_Item_ID = item3.itemId; db.Customer_Order_Line.Add(orderLine); } db.SaveChanges(); Globals.ComboItems.Clear(); Globals.MenuItems.Clear(); Globals.StockItems.Clear(); Globals.refresher = true; Globals.AmountDue = 0; this.Close(); int id2 = Globals.LogedUser; Employee emp = db.Employees.FirstOrDefault(c => c.Employee_ID == id2); Audit ad = new Audit(); ad.Audit_Name = emp.Employee_Name; ad.Audit_Table = "Customer_Order"; ad.Audit_Description = "Order Processing"; ad.User_ID = Globals.LogedUser; ad.transactionNumber = order.Order_ID; ad.auditDate = DateTime.Now; db.Audits.Add(ad); db.SaveChanges(); MessageBox.Show("Order created successfully"); } else { MessageBox.Show("Error: Order number can't be less than one"); } } else { MessageBox.Show("Error: Order number should be numerical"); } }