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