private bool Check(StylistVo sv) { if (sv.StylistName != null && sv.AdditionalPrice != null && sv.PersonalDay != null) { return(true); } MessageBox.Show("빈칸이 존재합니다."); return(false); }
private void ExecuteDeleteMethod(object obj) { if (SelectedStylist.StylistId == 0) { MessageBox.Show("미용사를 선택해주세요"); return; } _stylistRepository.RemoveStylist(SelectedStylist.StylistId); StylistList.Remove(SelectedStylist); SelectedStylist = new StylistVo(); }
public StylistViewModel() { _stylistRepository = StylistRepository.SR; _selectedStylist = new StylistVo(); _selectedStylist.StylistId = 0; StylistList = new ObservableCollection <StylistVo>(_stylistRepository.GetStylistsFromLocal()); InsertCommand = new Command(ExecuteInsertMethod, CanExecuteMethod); ModifyCommand = new Command(ExecuteModifyMethod, CanExecuteMethod); DeleteCommand = new Command(ExecuteDeleteMethod, CanExecuteMethod); InitalizeCommand = new Command(ExecuteInitalizeMethod, CanExecuteMethod); }
public bool UpdateStylist(StylistVo s) { MySqlDataAdapter adapter = new MySqlDataAdapter(_sql, _conn.Msc); DataTable table = _ds.Tables[0]; DataRow row = table.Select().Single(x => (uint)x["stylistId"] == s.StylistId); row["stylistName"] = s.StylistName; row["additionalPrice"] = s.AdditionalPrice; row["personalDay"] = s.PersonalDay; if (Save(adapter) == -1) { return(false); } return(true); }
public bool InsertStylist(StylistVo s) { MySqlDataAdapter adapter = new MySqlDataAdapter(_sql, _conn.Msc); DataTable table = _ds.Tables[0]; DataRow row = table.NewRow(); row["stylistId"] = s.StylistId; row["stylistName"] = s.StylistName; row["additionalPrice"] = s.AdditionalPrice; row["personalDay"] = s.PersonalDay; table.Rows.Add(row); if (Save(adapter) == -1) { return(false); } return(true); }
public List <StylistVo> GetStylists() { List <StylistVo> list = new List <StylistVo>(); _ds = new DataSet(); _sql = "SELECT * FROM stylist"; MySqlDataAdapter adapter = new MySqlDataAdapter(_sql, _conn.Msc); adapter.Fill(_ds, "stylist"); foreach (DataRow r in _ds.Tables[0].Rows) { StylistVo s = new StylistVo(); s.StylistId = (uint)r["stylistId"]; s.StylistName = r["stylistName"] as string; s.AdditionalPrice = (uint)r["additionalPrice"]; s.PersonalDay = (byte)r["personalDay"]; list.Add(s); } return(list); }
private void ExecuteInitalizeMethod(object obj) { SelectedStylist = new StylistVo(); IsSelected = true; }