public async Task <IEnumerable> AllExamDates()
{
List <MinExamDto> examDtos = new List <MinExamDto>();
using (var command = _context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "select id, date from exams group by date;";
command.CommandType = CommandType.Text;
await _context.Database.OpenConnectionAsync();
using (var result = await command.ExecuteReaderAsync())
{
while (await result.ReadAsync())
{
MinExamDto minExamDto = new MinExamDto()
{
Id = result.GetInt32(0),
Date = result.GetString(1)
};
examDtos.Add(minExamDto);
}
return(examDtos);
}
}
}
public async Task <List <MinExamDto> > GetExamDateswithSession()
{
List <MinExamDto> examList = new List <MinExamDto>();
using (var command = _context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "SELECT id,date,session from exams group by date,session;";
command.CommandType = CommandType.Text;
await _context.Database.OpenConnectionAsync();
using (var reader = await command.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
MinExamDto minExamDto = new MinExamDto()
{
Id = reader.GetInt32(0),
Date = reader.GetString(1),
Session = reader.GetString(2)
};
examList.Add(minExamDto);
}
}
}
return(examList);
}
public async Task UpdateExamDate(MinExamDto minExamDto)
{
Console.WriteLine($"{minExamDto.Id} {minExamDto.Date}");
var data = await _context.Exams.FirstOrDefaultAsync(x => x.Id == minExamDto.Id);
await _context.Database.ExecuteSqlInterpolatedAsync($"update exams set Date={minExamDto.Date} where Date={data.Date};");
await _context.Database.ExecuteSqlInterpolatedAsync($"update semester set Date={minExamDto.Date} where Date={data.Date};");
}
public async Task <IActionResult> UpdateExams(MinExamDto minExamDto)
{
try
{
await _seatingRepository.UpdateExamDate(minExamDto);
return(Ok(new { res = "Success !!!" }));
}
catch (Exception e)
{
Console.WriteLine(e);
return(BadRequest(new { res = "Error Occured" }));
}
}
