public Chat GetById(int id)
{
try
{
using (var con = new SqlConnection(Env.ConnectionString))
{
con.Open();
var cmdString = "SELECT * FROM Chatbericht WHERE Id = @id";
var command = new SqlCommand(cmdString, con);
command.Parameters.AddWithValue("@id", id);
var reader = command.ExecuteReader();
Chat chat = null;
while (reader.Read())
{
var gsql = new GebruikerSqlContext();
var grepo = new GebruikerRepository(gsql);
var g1 = grepo.GetById(reader.GetInt32(1));
var g2 = grepo.GetById(reader.GetInt32(2));
chat = new Chat(reader.GetInt32(0), g1, g2, reader.GetDateTime(3), reader.GetString(4));
}
con.Close();
return(chat);
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public List <Chat> GetAll()
{
try
{
List <Chat> chats = new List <Chat>();
using (var con = new SqlConnection(Env.ConnectionString))
{
con.Open();
var cmdString = "SELECT * FROM Chatbericht";
var command = new SqlCommand(cmdString, con);
var reader = command.ExecuteReader();
while (reader.Read())
{
var gsql = new GebruikerSqlContext();
var grepo = new GebruikerRepository(gsql);
var g1 = grepo.GetById(reader.GetInt32(1));
var g2 = grepo.GetById(reader.GetInt32(2));
var chat = new Chat(reader.GetInt32(0), g1, g2, reader.GetDateTime(3), reader.GetString(4));
chats.Add(chat);
}
con.Close();
return(chats);
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}