/*
* public void UpdateTimeTable(string EditTime, string ID, string TimeTableName)
* {
* // 시간표 다시 저장할 때 쓰는 쿼리
* string sql = "Update UserTimeTable SET EditTime = '" + EditTime + "' Where ID = '" + ID + "' and TimeTableName = N'" + TimeTableName + "'";
* db.Execute(sql);
* }
*/
public void UpdateTimeTable(UserTimeTable _userTimeTable)
{
// 시간표 다시 저장할 때 쓰는 쿼리
string sql = "Update UserTimeTable SET EditTime = '" + _userTimeTable.EditTime + "' Where ID = '" + _userTimeTable.ID + "' and TimeTableName = N'" + _userTimeTable.TimeTableName + "'";
db.Execute(sql, _userTimeTable);
}
public void UpdateUserTimeTable(UserTimeTable _userTimeTable)
{
// 시간표 이름 수정할 때 쓰는 쿼리
// 보류. 아직 개발 중 =
string sql = "UPDATE UserTimeTable SET TimeTableName = N'" + _userTimeTable.TimeTableName + "' WHERE ID = '" + _userTimeTable.ID + "'";
db.Execute(sql, _userTimeTable);
}
public void Put([FromBody] UserTimeTable _userTimeTable)
{
_repo.UpdateUserTimeTable(_userTimeTable);
}
public void Post([FromBody] UserTimeTable _userTimeTable)
{
_repo.PostTimeTable(_userTimeTable);
}
public void PostTimeTable(UserTimeTable _userTimeTable)
{
string sql = "Insert Into UserTimeTable (ID, TimeTableName, SaveTime, EditTime) Values (@ID, @TimeTableName, @SaveTime, @EditTime)";
db.Execute(sql, _userTimeTable);
}