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); }