/// <summary>
/// Insert image record
/// </summary>
/// <param name="image">Image model</param>
public void Create(Images image)
{
using (var command = new SqlCommand("CreateImage", _connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Photo", image.PhotoImage);
command.Parameters.AddWithValue("@OwnerId", image.OwnerId);
command.Parameters.AddWithValue("@CarId", image.CarId);
command.ExecuteNonQuery();
}
}
public static Images Map(SqlDataReader record)
{
if (record == null) throw new ArgumentNullException("record");
var image = new Images
{
Id = (int)record["Id"],
PhotoImage = (byte[])record["Photo"],
OwnerId = (int)record["OwnerId"],
CarId = (int)record["CarId"]
};
return image;
}