private async Task SetHWStatusAsync(int hwID, HWStatus status) { try { var cmd = this.sqlConnection.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "update homework set status = @status where hw_id = @hw_id"; cmd.Parameters.Add("@status", MySqlDbType.Int16); cmd.Parameters.Add("@hw_id", MySqlDbType.Int32); cmd.Parameters["@status"].Value = (int)status; cmd.Parameters["@hw_id"].Value = hwID; await cmd.ExecuteNonQueryAsync(); } catch (Exception e) { logger.LogError(e.Message); throw new Exception("Action Failed!"); } }
private async Task <List <HWTime> > GetHWTimeListAsync(HWStatus status) { try { var cmd = this.sqlConnection.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "select hw_id, course_id, title, startTime, endTime from homework where status = @status"; cmd.Parameters.Add("@status", MySqlDbType.Int16); cmd.Parameters["@status"].Value = (int)status; using var reader = await cmd.ExecuteReaderAsync(); var resList = new List <HWTime>(); while (await reader.ReadAsync()) { var id = Convert.ToInt32(reader["hw_id"]); var title = Convert.ToString(reader["title"]); var courseID = Convert.ToInt32(reader["course_id"]); var startTime = Convert.ToDateTime(reader["startTime"]); var endTime = Convert.ToDateTime(reader["endTime"]); resList.Add(new HWTime() { ID = id, Title = title, CourseID = courseID, StartTime = startTime, EndTime = endTime, Status = status }); } return(resList); } catch (Exception e) { logger.LogError(e.Message); throw new Exception("Action Failed!"); } }