private PrefferedRoomForSessionEntity CreatePrefferedRoomForSessionEntity()
        {
            int    id;
            int    Session  = int.Parse(session_combobx.Text);
            string RoomName = roomname_txtbx.Text;

            id = prefferedRoomForSessions.Last().id + 1;

            prefferedRoomForSessionEntity = new PrefferedRoomForSessionEntity(id, Session, RoomName);
            return(prefferedRoomForSessionEntity);
        }
 public void SaveData(PrefferedRoomForSessionEntity prefferedRoomForSession)
 {
     using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
     {
         try
         {
             con.Execute("INSERT INTO PrefferedRoomForSession (id,SessionId, RoomName) values (@id,@SessionId, @RoomName)", prefferedRoomForSession);
         }
         catch (Exception e)
         {
             MessageBox.Show(e.Message);
         }
     }
 }
 private void add_btn__Click(object sender, RoutedEventArgs e)
 {
     try
     {
         prefferedRoomForSessionEntity = CreatePrefferedRoomForSessionEntity();
         _prefferedRoomForSessionViewModel.SavePrefferedRoomForSessionData(prefferedRoomForSessionEntity);
         MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG");
         ClearAll();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 public void SavePrefferedRoomForSessionData(PrefferedRoomForSessionEntity prefferedRoomForSession)
 {
     _prefferedRoomForSessionData.SaveData(prefferedRoomForSession);
 }