private PrefferedRoomForSubjectEntity CreatePrefferedRoomForSubjectEntity()
{
int id;
string SubjectName = subjectname_combobx.Text;
string TagName = tagname_combobx.Text;
string RoomName = roomname_txtbx.Text;
id = prefferedRoomForSubjects.Last().id + 1;
prefferedRoomForSubjectEntity = new PrefferedRoomForSubjectEntity(id, SubjectName, TagName, RoomName);
return(prefferedRoomForSubjectEntity);
}
private void add_btn__Click(object sender, RoutedEventArgs e)
{
try
{
prefferedRoomForSubjectEntity = CreatePrefferedRoomForSubjectEntity();
_prefferedRoomForSubjectViewModel.SavePrefferedRoomForSubjectData(prefferedRoomForSubjectEntity);
MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG");
ClearAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SaveData(PrefferedRoomForSubjectEntity prefferedRoomForSubject)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("INSERT INTO PrefferedRoomForSubject (id,SubjectName,TagName,RoomName) values (@id,@SubjectName,@TagName, @RoomName)", prefferedRoomForSubject);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public void SavePrefferedRoomForSubjectData(PrefferedRoomForSubjectEntity prefferedRoomForSubject)
{
_prefferedRoomForSubjectData.SaveData(prefferedRoomForSubject);
}
