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