private void ExecuteInsertRSMethod(object obj) { if (SelectedService == null) { MessageBox.Show("추가할 서비스를 선택해주세요."); return; } List <ReservedServiceVo> list = _reservedServiceRepository.GetReservedServices(SelectedRes.ResNum); if (list.FirstOrDefault(x => (x.SerId == SelectedService.ServiceId)) != null) { MessageBox.Show("이미 존재하는 서비스입니다."); return; } ReservedServiceVo rv = new ReservedServiceVo(); rv.ResNum = SelectedRes.ResNum; rv.SerId = SelectedService.ServiceId; ServiceVo s = ServiceList.Single(x => x.ServiceId == rv.SerId); ushort serviceTime = s.ServiceTime; if (HasReservations(SelectedRes.StylistId, SelectedRes.EndAt, SelectedRes.EndAt + new TimeSpan(serviceTime / 60, serviceTime % 60, 0))) { MessageBox.Show("이미 예약이 존재한 시간대입니다."); return; } _reservedServiceRepository.InsertReservedService(rv); ServiceCommands.Add(new DataCommandViewModel <ReservedServiceVo>(SelectedService.ServiceName, new Command(RemoveRS), rv)); TimeSpan ts = new TimeSpan(SelectedService.ServiceTime / 60, SelectedService.ServiceTime % 60, 0); SelectedRes.EndAt = SelectedRes.EndAt + ts; _reservationRepository.UpdateReservation(SelectedRes); }
private void ExecuteRemoveMethod(ReservedServiceVo rsv) { if (!Check(SelectedRes)) { return; } _reservedServiceRepository.RemoveReservedService(rsv.ResNum, rsv.SerId); }
public void Upload() { _resRep.InsertReservation(ReservationVo); uint id = _resRep.GetRecentNum(); foreach (ServiceVo service in ResServices) { ReservedServiceVo reservedService = new ReservedServiceVo(); reservedService.ResNum = id; reservedService.SerId = service.ServiceId; _reservedServiceRepository.InsertReservedService(reservedService); } }
private void RemoveRS(object obj) { ReservedServiceVo rsv = (ReservedServiceVo)obj; _reservedServiceRepository.RemoveReservedService(rsv.ResNum, rsv.SerId); ServiceCommands.Remove(ServiceCommands.Single(x => (x.Data == rsv))); ServiceVo s = ServiceList.Single(x => x.ServiceId == rsv.SerId); ReservationVo r = ResList.Single(x => x.ResNum == rsv.ResNum); TimeSpan ts = new TimeSpan(s.ServiceTime / 60, s.ServiceTime % 60, 0); r.EndAt = r.EndAt - ts; _reservationRepository.UpdateReservation(r); }
public bool InsertReservedService(ReservedServiceVo rsv) { _conn.Msc.Open(); _sql = "INSERT INTO reservedservice(resNum,serId) VALUES(@resNum,@serId)"; MySqlCommand cmd = new MySqlCommand(_sql, _conn.Msc); cmd.Parameters.AddWithValue("@resNum", rsv.ResNum); cmd.Parameters.AddWithValue("@serId", rsv.SerId); if (cmd.ExecuteNonQuery() == -1) { _conn.Msc.Close(); return(false); } _conn.Msc.Close(); return(true); }
public List <ReservedServiceVo> GetReservedServices() { _conn.Msc.Open(); List <ReservedServiceVo> list = new List <ReservedServiceVo>(); _sql = "SELECT * FROM reservedservice"; MySqlCommand cmd = new MySqlCommand(_sql, _conn.Msc); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ReservedServiceVo rsv = new ReservedServiceVo(); rsv.ResNum = (uint)rdr["resNum"]; rsv.SerId = (ushort)rdr["serId"]; list.Add(rsv); } _conn.Msc.Close(); return(list); }