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