public void SaveData(ParallelSessionEntity parallelSession)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("INSERT INTO ParallelSession (ParallelSessionId, Ses1, Ses2, Day, STime, ETime) values (@ParallelSessionId, @Ses1, @Ses2, @Day, @STime, @ETime)", parallelSession);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public void UpdateData(ParallelSessionEntity parallelSession)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("UPDATE ParallelSession SET Ses1=@Ses1, Ses2=@Ses2, Day=@Day, STime=@STime, ETime=@ETime WHERE ParallelSessionId=@ParallelSessionId", parallelSession);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
private void add_btn__Click(object sender, RoutedEventArgs e)
{
try
{
parallelSessionEntity = CreateParellelSessionEntity();
parallelSessionViewModel.SaveParallelSessionData(parallelSessionEntity);
MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG");
ClearAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private ParallelSessionEntity CreateParellelSessionEntity()
{
int ParallelSessionId;
ParallelSessionId = parallelSessions.Last().ParallelSessionId + 1;
string Ses1 = session1_combobx.Text;
string Ses2 = session2_combobx.Text;
string Day = day_combobx.Text;
string STime = starttime_combobx.Text;
string ETime = endtime_combobx.Text;
parallelSessionEntity = new ParallelSessionEntity(ParallelSessionId, Ses1, Ses2, Day, STime, ETime);
return(parallelSessionEntity);
}
public void UpdateParallelSessionData(ParallelSessionEntity parallelSession)
{
_parallelSessionData.UpdateData(parallelSession);
}
public void SaveParallelSessionData(ParallelSessionEntity parallelSession)
{
_parallelSessionData.SaveData(parallelSession);
}
