public string AddOrUpdateBorrowBookOrder(BorrowBookOrder order) { string orderID = (order.OrderID == "") ? GenerateBookBorrowOrderID(order) : order.OrderID; string err = AddOrUpdateOrderBasicInfo(order, orderID); if (err != "") { return(err); } err = AddOrUpdateVIPInOrder(orderID, order.GetVipID(), true); if (err != "") { return(err); } Table <DAL.BookBorrowOrder> bkBorrowOrderTable = GetBookBorrowOrderTable(); var matchedRes = (from borrowOrder in bkBorrowOrderTable where borrowOrder.orderID == orderID select borrowOrder).FirstOrDefault(); if (matchedRes == null) { DAL.BookBorrowOrder data = new DAL.BookBorrowOrder(); try { data.orderID = orderID; bkBorrowOrderTable.InsertOnSubmit(data); bkBorrowOrderTable.Context.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } err = AddOrUpdateBooksInBorrowOrder(orderID, order.Books); if (err != "") { return(err); } return(""); }
private void bunifuTileButton_Execute_Click(object sender, EventArgs e) { string err = ""; if (mode == "view") { this.Close(); return; } if (mode == "delete") { ThreadManager.DisplayLoadingScreen(); err = manager.DeleteOrder(bunifuCustomTextbox_BillCode.Text); ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay(err, "Cancel order successfully", "Cancel order failed"); return; } ThreadManager.DisplayLoadingScreen(); if (mode == "update") { Order order = new Order(); order.OrderID = bunifuCustomTextbox_BillCode.Text; order.DateCreated = Convert.ToDateTime(bunifuCustomTextbox_CurentTime.Text); int temp = 0; int.TryParse(bunifuCustomTextbox_Priority.Text, out temp); order.PriorityNumber = temp; order.TotalPayment = double.Parse(bunifuMetroTextbox_GrandTotal.Text); order.ChargedMoney = double.Parse(bunifuMetroTextbox_ChangeGiven.Text); order.Status = bunifuDropdown_Status.selectedValue; if (bunifuCheckbox_VIPChecker.Checked) { order.SetVipID(bunifuCustomTextbox_VIP.Text); } else { order.SetVipID(""); } err = manager.AddOrUpdateOrderBasicInfo(order, order.OrderID); ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay(err, "Update order successfully", "Update order failed"); return; } if (bunifuImageButton_ChooseDish_Drink.Enabled == true) { DishOrder order = new DishOrder(); try { order.OrderID = bunifuCustomTextbox_BillCode.Text; order.DateCreated = Convert.ToDateTime(bunifuCustomTextbox_CurentTime.Text); int temp = 0; int.TryParse(bunifuCustomTextbox_Priority.Text, out temp); order.PriorityNumber = temp; order.TotalPayment = double.Parse(bunifuMetroTextbox_GrandTotal.Text); order.ChargedMoney = double.Parse(bunifuMetroTextbox_ChangeGiven.Text); order.Status = bunifuDropdown_Status.selectedValue; if (bunifuCheckbox_VIPChecker.Checked) { order.SetVipID(bunifuCustomTextbox_VIP.Text); } else { order.SetVipID(""); } order.OrderItems = (List <Food>)bunifuCustomTextbox__list_selectedDishesDrinks.Tag; } catch (Exception ex) { ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay(ex.Message, "", "Extract data falied"); return; } err = manager.AddOrUpdateDishOrder(order); ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay(err, "Add dish order successfully", "Add dish order failed"); } else if (bunifuImageButton_ChooseBook.Enabled == true) { BorrowBookOrder order = new BorrowBookOrder(); try { order.OrderID = bunifuCustomTextbox_BillCode.Text; order.DateCreated = Convert.ToDateTime(bunifuCustomTextbox_CurentTime.Text); int temp = 0; int.TryParse(bunifuCustomTextbox_Priority.Text, out temp); order.PriorityNumber = temp; order.TotalPayment = double.Parse(bunifuMetroTextbox_GrandTotal.Text); order.ChargedMoney = double.Parse(bunifuMetroTextbox_ChangeGiven.Text); order.Status = bunifuDropdown_Status.selectedValue; if (bunifuCheckbox_VIPChecker.Checked) { order.SetVipID(bunifuCustomTextbox_VIP.Text); } else { ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay("No VIP ID input", "", "This feature require a VIP ID to be used"); return; } order.Books = (List <Book>)bunifuCustomTextbox__list_selectedBooks.Tag; err = manager.AddOrUpdateBorrowBookOrder(order); ErrorManager.MessageDisplay(err, "Add book borrow order successfully", "Add book borrow order failed"); } catch (Exception ex) { ErrorManager.MessageDisplay(ex.Message, "", "Extract data falied"); ThreadManager.CloseLoadingScreen(); return; } ThreadManager.CloseLoadingScreen(); } else if (bunifuCheckbox_BorrowedBookCode.Checked == true) { ReturnBookOrder order = (ReturnBookOrder)bunifuCustomTextbox_BorrowedBookInfo.Tag; try { order.OrderID = bunifuCustomTextbox_BillCode.Text; order.DateCreated = Convert.ToDateTime(bunifuCustomTextbox_CurentTime.Text); int temp = 0; int.TryParse(bunifuCustomTextbox_Priority.Text, out temp); order.PriorityNumber = temp; order.TotalPayment = double.Parse(bunifuMetroTextbox_GrandTotal.Text); order.ChargedMoney = double.Parse(bunifuMetroTextbox_ChangeGiven.Text); order.Status = bunifuDropdown_Status.selectedValue; if (bunifuCheckbox_VIPChecker.Checked) { order.SetVipID(bunifuCustomTextbox_VIP.Text); } err = manager.AddOrUpdateReturnBookOrder(order); ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay(err, "Add book return order successfully", "Add book return order failed"); } catch (Exception ex) { ThreadManager.CloseLoadingScreen(); ErrorManager.MessageDisplay(ex.Message, "", "Extract data falied"); return; } } if (err == "") { this.Close(); } }