public MatchReportDto GetMatchReportByID(int id)
{
try
{
using (SqlConnection conn = DataConnection.GetConnection())
{
conn.Open();
string query = "SELECT * From Matchreport WHERE Id=@id";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
MatchReportDto matchreport = new MatchReportDto();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
matchreport.Id = (int)reader["Id"];
matchreport.Title = (string)reader["Title"];
matchreport.Date = (DateTime)reader["Date"];
matchreport.Report = (string)reader["Report"];
}
}
return(matchreport);
}
}
catch (SqlException)
{
throw new GetMatchReportFailedException("An unexpected error occured.");
}
}
public List <MatchReportDto> GetAllMatchReports()
{
try
{
using (SqlConnection conn = DataConnection.GetConnection())
{
conn.Open();
string query = "SELECT * FROM Matchreport Where userId = 1";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
List <MatchReportDto> AllReports = new List <MatchReportDto>();
foreach (DataRow dr in dt.Rows)
{
MatchReportDto matchreports = new MatchReportDto();
int.TryParse(dr[0].ToString(), out int id);
matchreports.Id = id;
int.TryParse(dr[1].ToString(), out int Userid);
matchreports.Title = dr[2].ToString();
matchreports.Report = dr[3].ToString();
matchreports.Date = (DateTime)dr[4];
AllReports.Add(matchreports);
}
return(AllReports);
}
}
catch (SqlException)
{
throw new GetMatchReportFailedException("An unexpected error occured.");
}
}
internal static MatchReportDto GetMatchReportDTO(MatchReport matchreport)
{
MatchReportDto dto = new MatchReportDto
{
Id = matchreport.Id,
Date = matchreport.Date,
Title = matchreport.Title,
Report = matchreport.Report,
UserId = matchreport.UserId
};
return(dto);
}
public void AddMatchReport(MatchReportDto matchreport)
{
try
{
using (SqlConnection connection = DataConnection.GetConnection())
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO [Matchreport] (Title ,UserId ,Date, Report) VALUES (@Title ,@UserId ,@Date, @Report)";
command.Parameters.AddWithValue("@Title", matchreport.Title);
command.Parameters.AddWithValue("@UserId", 1);
command.Parameters.AddWithValue("@Date", matchreport.Date);
command.Parameters.AddWithValue("@Report", matchreport.Report);
command.ExecuteNonQuery();
}
}
catch (SqlException)
{
throw new AddMatchReportFailedException("An unexpected error occured.");
}
}
internal static MatchReport GetMatchReportFromDTO(MatchReportDto dto)
{
return(new MatchReport(dto.Id, dto.Date, dto.Title, dto.Report, dto.UserId));
}
public void DeleteMatchReport(MatchReportDto matchReport)
{
throw new NotImplementedException();
}
