private LecturerNAEntity CreateLectureNAEntity() { int LecturerId; LecturerId = lecturerNAs.Last().LecturerId + 1; string Lecturer = lecturer_combobx.Text; string Day = day_combobx.Text; string STime = starttime_combobx.Text; string ETime = endtime_combobx.Text; lecturerNAEntity = new LecturerNAEntity(LecturerId, Lecturer, Day, STime, ETime); return(lecturerNAEntity); }
private void add_btn__Click(object sender, RoutedEventArgs e) { try { lecturerNAEntity = CreateLectureNAEntity(); lecturerNAViewModel.SaveLecturerNAData(lecturerNAEntity); MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG"); ClearAll(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void SaveData(LecturerNAEntity LecturerNA) { using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString)) { try { con.Execute("INSERT INTO LecturerNA (LecturerId, Lecturer, Day, STime, ETime) values (@LecturerId, @Lecturer, @Day, @STime, @ETime)", LecturerNA); } catch (Exception e) { MessageBox.Show(e.Message); } } }
public void UpdateData(LecturerNAEntity LecturerNA) { using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString)) { try { con.Execute("UPDATE LecturerNA SET Lecturer=@Lecturer, Day=@Day, STime=@STime, ETime=@ETime WHERE LecturerId=@LecturerId", LecturerNA); } catch (Exception e) { MessageBox.Show(e.Message); } } }
public void UpdateLecturerNAData(LecturerNAEntity lecturerNa) { _lecturerNAData.UpdateData(lecturerNa); }
public void SaveLecturerNAData(LecturerNAEntity lecturerNa) { _lecturerNAData.SaveData(lecturerNa); }