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); }
public List <ServiceVo> GetServices() { List <ServiceVo> list = new List <ServiceVo>(); _ds = new DataSet(); MySqlDataAdapter adapter = new MySqlDataAdapter(_sql, _conn.Msc); adapter.Fill(_ds, "Service"); foreach (DataRow r in _ds.Tables[0].Rows) { ServiceVo service = new ServiceVo(); service.ServiceId = (ushort)r["serviceId"]; service.ServiceName = r["serviceName"] as string; service.ServicePrice = (uint)r["servicePrice"]; service.ServiceTime = (ushort)r["serviceTime"]; service.ServiceDescription = r["serviceDescription"] as string; list.Add(service); } return(list); }
private bool Check(ServiceVo sv) { if (sv.ServiceName != null && sv.ServiceDescription != null) { return(true); } MessageBox.Show("빈칸이 존재합니다."); return(false); }
private void ExecuteDeleteMethod(object obj) { if (SelectedService.ServiceId == 0) { MessageBox.Show("서비스를 선택해주세요"); return; } _serviceRepository.DeleteService(SelectedService.ServiceId); ServiceList.Remove(SelectedService); SelectedService = new ServiceVo(); }
public ServiceViewModel() { _serviceRepository = ServiceRepository.SR; _selectedService = new ServiceVo(); _selectedService.ServiceId = 0; ServiceList = new ObservableCollection <ServiceVo>(_serviceRepository.GetServicesFromLocal()); InsertCommand = new Command(ExecuteInsertMethod, CanExecuteMethod); ModifyCommand = new Command(ExecuteModifyMethod, CanExecuteMethod); DeleteCommand = new Command(ExecuteDeleteMethod, CanExecuteMethod); InitalizeCommand = new Command(ExecuteInitalizeMethod, CanExecuteMethod); }
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); }
private void ExecuteInsertMethod(object obj) { if (!Check(SelectedService)) { return; } else { _serviceRepository.InsertService(SelectedService); ServiceList.Add(SelectedService); ServiceList = new ObservableCollection <ServiceVo>(_serviceRepository.GetServices()); SelectedService = new ServiceVo(); } }
public bool UpdateService(ServiceVo s) { MySqlDataAdapter adapter = new MySqlDataAdapter(_sql, _conn.Msc); DataTable table = _ds.Tables[0]; DataRow row = table.Select().Single(x => (ushort)x["serviceId"] == s.ServiceId); row["serviceName"] = s.ServiceName; row["servicePrice"] = s.ServicePrice; row["serviceTime"] = s.ServiceTime; row["serviceDescription"] = s.ServiceDescription; if (Save(adapter) == -1) { return(false); } return(true); }
public bool InsertService(ServiceVo s) { MySqlDataAdapter adapter = new MySqlDataAdapter(_sql, _conn.Msc); DataTable table = _ds.Tables[0]; DataRow row = table.NewRow(); row["serviceId"] = s.ServiceId; row["serviceName"] = s.ServiceName; row["servicePrice"] = s.ServicePrice; row["serviceTime"] = s.ServiceTime; row["serviceDescription"] = s.ServiceDescription; table.Rows.Add(row); if (Save(adapter) == -1) { return(false); } return(true); }
private void ExecuteInitalizeMethod(object obj) { SelectedService = new ServiceVo(); IsSelected = true; }