public uint InsertLedger(LedgerVo lv)
{
_conn.Msc.Open();
_sql = "INSERT INTO ledger(ledgerNum,resNum,sum) VALUES(@ledgerNum,@resNum,@sum)";
MySqlCommand cmd = new MySqlCommand(_sql, _conn.Msc);
cmd.Parameters.AddWithValue("@ledgerNum", lv.LedgerNum);
cmd.Parameters.AddWithValue("@resNum", lv.ResNum);
cmd.Parameters.AddWithValue("@sum", lv.Sum);
if (cmd.ExecuteNonQuery() == -1) //실패시
{
_conn.Msc.Close();
return(0);
}
uint recentId = (uint)cmd.LastInsertedId;
_conn.Msc.Close();
return(recentId); //성공시
}
private void ExcuteInsertMethod(object obj)
{
if (SelRes.StylistId == 0)
{
MessageBox.Show("선택된 예약이 없습니다.");
return;
}
LedgerVo l = new LedgerVo();
if (UserPoint < ConsumePoint)
{
MessageBox.Show("적립금이 부족합니다.");
return;
}
if (ConsumePoint > Sum)
{
MessageBox.Show("사용할 적립금이 실제 가격보다 더 많습니다.");
return;
}
l.ResNum = SelRes.ResNum;
l.Sum = Sum;
_ledgerRepository.InsertLedger(l);
UserVo user = _userList.Single(x => x.UserTel == SelRes.UserTel);
user.Point += Point;
user.Point -= ConsumePoint;
_userRepository.UpdateUser(user);
ReservationVo r = ResList.Single(x => x.ResNum == SelRes.ResNum);
r.IsPaid = true;
_reservationRepository.UpdateReservation(r);
MessageBox.Show("결제 완료");
// ResList = new ObservableCollection<ReservationVo>(_reservationRepository.GetReservations());
}
