private void AddPayment(List <Drink> OrderedDrink, payments.paymentMethod paymentMethod) { string menuList = OrderedDrinkListString(OrderedDrink); if (PayMessage(menuList)) { // DB에 값 전달(이름,카테고리,결제타입,결제금액,결제시간) foreach (Drink drink in OrderedDrink) { for (int i = 0; i < drink.Count; i++) { //To-Do Connect Database using Starbucks.Analytics statics.AddPayment(drink.Name, drink.Category, paymentMethod, drink.Price, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)); } } // Analytics Window의 Data 를 Refresh 함 App.analytics?.RefreshData(); if (paymentMethod == payments.paymentMethod.CARD) { App.socketController?.sendMessage("@" + App.loginID + "#[스타벅스 실시간 결제 알림]\n결제 수단: 카드\n결제 금액:" + SetTotalPrice().ToString()); } else { App.socketController?.sendMessage("@" + App.loginID + "#[스타벅스 실시간 결제 알림]\n결제 수단: 현금\n결제 금액:" + SetTotalPrice().ToString()); } BackHome(); } }
public void AddPayment(string payMenu, string category, payments.paymentMethod payMethod, int payAmount, string payTime) { connection.ExcuteQuery("INSERT INTO payment (category, paymentMethod, paymentfor, paymentAmount, paymentDate) VALUES ('" + category + "', '" + payMethod + "', '" + payMenu + "', '" + payAmount + "', '" + payTime + "');"); }