private PrefferedRoomForGroupEntity CreatePrefferedRoomForGroupEntity() { int id; int Group = int.Parse(group_combobx.Text); int SubGroup = int.Parse(subgroup_combobx.Text); string RoomName = roomname_txtbx.Text; id = prefferedRoomForGroups.Last().id + 1; prefferedRoomForGroupEntity = new PrefferedRoomForGroupEntity(id, Group, SubGroup, RoomName); return(prefferedRoomForGroupEntity); }
private void add_btn__Click(object sender, RoutedEventArgs e) { try { prefferedRoomForGroupEntity = CreatePrefferedRoomForGroupEntity(); _prefferedRoomForGroupViewModel.SavePrefferedRoomForGroupData(prefferedRoomForGroupEntity); MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG"); ClearAll(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void SaveData(PrefferedRoomForGroupEntity prefferedRoomForGroup) { using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString)) { try { con.Execute("INSERT INTO PrefferedRoomForGroup (id,GroupNumber,SubGroupNumber,RoomName) values (@id,@GroupNumber,@SubGroupNumber, @RoomName)", prefferedRoomForGroup); } catch (Exception e) { MessageBox.Show(e.Message); } } }
public void SavePrefferedRoomForGroupData(PrefferedRoomForGroupEntity prefferedRoomForGroup) { _prefferedRoomForGroupData.SaveData(prefferedRoomForGroup); }