public void DeleteSubjectInTimeTable(TimeTableClassNumber timeTableClassNumber)
{
string sql = "DELETE FROM TimeTableClassNumber WHERE ID = '" + timeTableClassNumber.ID + "' AND TimeTableName = N'" + timeTableClassNumber.TimeTableName + "' AND ClassNumber = '" + timeTableClassNumber.ClassNumber + "'";
db.Execute(sql, timeTableClassNumber);
}
public void PostTimeTable(TimeTableClassNumber _timeTableClassNumber)
{
string sql = "Insert Into TimeTableClassNumber (ID, TimeTableName, ClassNumber) Values (@ID, @TimeTableName, @ClassNumber)";
db.Execute(sql, _timeTableClassNumber);
}
public void Delete([FromBody] TimeTableClassNumber timeTableClassNumber)
{
_repo.DeleteSubjectInTimeTable(timeTableClassNumber);
}
public void Post([FromBody] TimeTableClassNumber _timeTalbeClassNumber)
{
_repo.PostTimeTable(_timeTalbeClassNumber);
}
public void PostTimeTable(TimeTableClassNumber _timeTableClassNumber)
{
string sql = "Insert Into UserTimeTable (NO, TimeTableClassNumber) Values (@NO, @TimeTableClassNumber)";
db.Execute(sql, _timeTableClassNumber);
}
