private void add_btn__Click(object sender, RoutedEventArgs e)
{
try
{
subGroupNAEntity = CreateGroupNAEntity();
subGroupNAViewModel.SaveSubGroupNAData(subGroupNAEntity);
MessageBoxResult result = MessageBox.Show("Successfully Added!", "BBTG");
ClearAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private SubGroupNAEntity CreateGroupNAEntity()
{
int SubGroupId;
SubGroupId = subGroupNAs.Last().SubGroupId + 1;
string SubGroupNumber = subgroup_combobx.Text;
string Day = day_combobx.Text;
string STime = starttime_combobx.Text;
string ETime = endtime_combobx.Text;
subGroupNAEntity = new SubGroupNAEntity(SubGroupId, SubGroupNumber, Day, STime, ETime);
return(subGroupNAEntity);
}
public void SaveData(SubGroupNAEntity SubGroupNA)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("INSERT INTO SubGroupNA (SubGroupId, SubGroupNumber, Day, STime, ETime) values (@SubGroupId, @SubGroupNumber, @Day, @STime, @ETime)", SubGroupNA);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public void UpdateData(SubGroupNAEntity SubGroupNA)
{
using (IDbConnection con = new SQLiteConnection(AppData.ConnectionString))
{
try
{
con.Execute("UPDATE SubGroupNA SET SubGroupNumber=@SubGroupNumber, Day=@Day, STime=@STime, ETime=@ETime WHERE SubGroupId=@SubGroupId", SubGroupNA);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public void UpdateSubGroupNAData(SubGroupNAEntity subgroupNa)
{
_subgroupNAData.UpdateData(subgroupNa);
}
public void SaveSubGroupNAData(SubGroupNAEntity subgroupNa)
{
_subgroupNAData.SaveData(subgroupNa);
}
