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);
}
