protected override Nile.Movie AddCore(Nile.Movie movie)
{
using (var conn = new SqlConnection(_connectionString))
{
var cmd = new SqlCommand("AddMovie", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@title", movie.Title);
cmd.Parameters.AddWithValue("@length", movie.Length);
cmd.Parameters.AddWithValue("@description", movie.Description);
var parm = cmd.CreateParameter();
parm.ParameterName = "@isOwned";
parm.DbType = System.Data.DbType.Boolean;
parm.Value = movie.IsOwned;
cmd.Parameters.Add(parm);
conn.Open();
var result = cmd.ExecuteScalar();
var id = Convert.ToInt32(result);
movie.Id = id;
}
return(movie);
}
protected override Nile.Movie UpdateCore(Nile.Movie movie)
{
using (var conn = new SqlConnection(_connectionString))
{
var cmd = new SqlCommand("UpdateMovie", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", movie.Id);
cmd.Parameters.AddWithValue("@title", movie.Title);
cmd.Parameters.AddWithValue("@Description", movie.Description);
cmd.Parameters.AddWithValue("@Length", movie.Length);
cmd.Parameters.AddWithValue("@isOwned", movie.IsOwned);
conn.Open();
cmd.ExecuteNonQuery();
};
return(movie);
}
protected override IEnumerable <Nile.Movie> GetAllCore()
{
var items = new List <Nile.Movie>();
using (var conn = new SqlConnection(_connectionString))
{
var cmd = new SqlCommand("GetAllMovies", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
var ds = new DataSet();
var da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
if (ds.Tables.Count == 1)
{
foreach (var row in ds.Tables[0].Rows.OfType <DataRow>())
{
var movie = new Nile.Movie()
{
Id = Convert.ToInt32(row["Id"]),
Title = row.Field <string>("Title"),
IsOwned = row.Field <bool>("IsOwned"),
Description = row.Field <string>("Description"),
Length = row.Field <int>("Length")
};
items.Add(movie);
}
;
}
;
};
return(items);
}
