private ConsecutiveSessionEntity CreateConsecutiveSessionEntity()
{
int ConsId;
ConsId = consecutiveSessions.Last().ConsId + 1;
string Ses1 = consecutive_session1_combobx.Text;
string Ses2 = consecutive_session2_combobx.Text;
consecutiveSessionEntity = new ConsecutiveSessionEntity(ConsId, Ses1, Ses2);
return(consecutiveSessionEntity);
}
public void SaveData(ConsecutiveSessionEntity ConsecutiveSession)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("INSERT INTO ConsecutiveSession (ConsId, Ses1, Ses2) values (@ConsId, @Ses1, @Ses2)", ConsecutiveSession);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public void UpdateData(ConsecutiveSessionEntity ConsecutiveSession)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("UPDATE ConsecutiveSession SET Ses1=@Ses1, Ses2=@Ses2 WHERE ConsId=@ConsId", ConsecutiveSession);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
private void add_btn__Click(object sender, RoutedEventArgs e)
{
try
{
consecutiveSessionEntity = CreateConsecutiveSessionEntity();
consecutiveSessionViewModel.SaveConsecutiveSessionData(consecutiveSessionEntity);
MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG");
ClearAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void UpdateConsecutiveSessionData(ConsecutiveSessionEntity consecutiveSession)
{
_consecutiveSessionData.UpdateData(consecutiveSession);
}
public void SaveConsecutiveSessionData(ConsecutiveSessionEntity consecutiveSession)
{
_consecutiveSessionData.SaveData(consecutiveSession);
}
