public Wall GetWall(long walId)
{
try
{
string query = @"SELECT walId, walName, walDescription, walImage
FROM Wall
WHERE walId = @walId";
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@walId", walId);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
var image = ImageToByteConverter.ConvertToByteArray(new Bitmap(Rage.Addservice.Persistence.Properties.Resources.default_wall_image));
return(new Wall()
{
Id = (dr[0] == null || dr[0] == DBNull.Value) ? (long?)null : Convert.ToInt64(dr[0]),
Name = (dr[1] == null || dr[1] == DBNull.Value) ? null : Convert.ToString(dr[1]),
Description = (dr[2] == null || dr[2] == DBNull.Value) ? null : Convert.ToString(dr[2]),
Image = (dr[3] == null || dr[3] == DBNull.Value) ? image : (Byte[])dr[3]
});
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
throw new Exception("Error GetWall: " + ex.Message);
}
}
public List <Wall> GetWalls()
{
try
{
string query = @"SELECT walId, walName, walDescription, walImage
FROM Wall";
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
List <Wall> walls = new List <Wall>();
var image = ImageToByteConverter.ConvertToByteArray(new Bitmap(Rage.Addservice.Persistence.Properties.Resources.default_wall_image));
while (dr.Read())
{
walls.Add(new Wall()
{
Id = (dr[0] == null || dr[0] == DBNull.Value) ? (long?)null : Convert.ToInt64(dr[0]),
Name = (dr[1] == null || dr[1] == DBNull.Value) ? null : Convert.ToString(dr[1]),
Description = (dr[2] == null || dr[2] == DBNull.Value) ? null : Convert.ToString(dr[2]),
Image = (dr[3] == null || dr[3] == DBNull.Value) ? image : (Byte[])dr[3]
});
}
return(walls.Count > 0 ? walls : null);
}
}
}
catch (Exception ex)
{
throw new Exception("Error GetWalls: " + ex.Message);
}
}