public List <IndividualSession> GetAllIndividualSessionsFromUser(long id)
{
var sessions = new List <IndividualSession>();
var SQL = "SELECT * FROM IndividualSessions WHERE examineeId = @Id";
using var sqlConn = GetSqlConnection();
using var sqlCmd = GetSqlCommand(SQL, sqlConn);
sqlCmd.Parameters.Add("Id", SqlDbType.BigInt).Value = id;
sqlConn.Open();
using var reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
var session = new IndividualSession
{
Id = Convert.ToInt64(reader["Id"].ToString()),
Ability = (float)Convert.ToDouble(reader["Ability"].ToString()),
StartTime = reader["StartTime"].ToString(),
EndTime = reader["EndTime"].ToString(),
ExamineeId = Convert.ToInt64(reader["ExamineeId"].ToString()),
SessionId = Convert.ToInt64(reader["SessionId"].ToString())
};
sessions.Add(session);
}
return(sessions);
}
public async Task <ActionResult> UpdateIndividualSession(IndividualSession individualSession)
{
await Task.Run(() => new IndividualSessionBLL
{
IndividualSessionDAL = new IndividualSessionDAL()
}.UpdateIndividualSession(individualSession));
return(Ok());
}
public void InsertIndividualSession(IndividualSession individualSession)
{
var SQL = "INSERT INTO IndividualSessions " +
"(Ability, StartTime, EndTime, ExamineeId, SessionId) " +
"VALUES (@Ability, @StartTime, @EndTime, @ExamineeId, @SessionId)";
using var sqlConn = GetSqlConnection();
using var sqlCmd = GetSqlCommand(SQL, sqlConn);
sqlConn.Open();
sqlCmd.Parameters.Add("@Ability", SqlDbType.Float).Value = individualSession.Ability;
sqlCmd.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = DateTime.Parse(individualSession.StartTime);
sqlCmd.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = DateTime.Parse(individualSession.EndTime);
sqlCmd.Parameters.Add("@ExamineeId", SqlDbType.BigInt).Value = individualSession.ExamineeId;
sqlCmd.Parameters.Add("@SessionId", SqlDbType.BigInt).Value = individualSession.SessionId;
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}
public void UpdateIndividualSession(IndividualSession individualSession)
{
var SQL = "UPDATE IndividualSessions " +
"SET Ability=@ability, StartTime=@startTime, EndTime=@endTime, ExamineeId=@examineeId, SessionId=@sessionId " +
"WHERE Id = @id";
using var sqlConn = GetSqlConnection();
using var sqlCmd = GetSqlCommand(SQL, sqlConn);
sqlConn.Open();
sqlCmd.Parameters.Add("@id", SqlDbType.BigInt).Value = individualSession.Id;
sqlCmd.Parameters.Add("@ability", SqlDbType.Float).Value = individualSession.Ability;
sqlCmd.Parameters.Add("@startTime", SqlDbType.DateTime).Value = individualSession.StartTime;
sqlCmd.Parameters.Add("@endTime", SqlDbType.DateTime).Value = individualSession.EndTime;
sqlCmd.Parameters.Add("@examineeId", SqlDbType.BigInt).Value = individualSession.ExamineeId;
sqlCmd.Parameters.Add("@sessionId", SqlDbType.BigInt).Value = individualSession.SessionId;
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}
public void UpdateIndividualSession(IndividualSession individualSession)
{
IndividualSessionDAL.UpdateIndividualSession(individualSession);
}
public void InsertIndividualSession(IndividualSession individualSession)
{
IndividualSessionDAL.InsertIndividualSession(individualSession);
}
