public ActionResult Create(string name, int grade, int length, string summary, string actor)
{
// movie_actor ma = new movie_actor(actor);
// movie_actor ma_two = new movie_actor(actor_two);
movie_data new_movie = new movie_data();
new_movie.Name = name;
new_movie.Grade = grade;
new_movie.Length = length;
new_movie.Summary = summary;
movie_actor actor_ = new movie_actor(actor);
new_movie.movie_actor.Add(actor_);
// m.movie_actor.Add(ma_one);
//m.movie_actor.Add(ma_two);
using (_db = new DatahanteringEntities())
{
_db.movie_data.Add(new_movie);
_db.SaveChanges();
}
return(RedirectToAction("Movie", "Movie"));
;
}
public ActionResult Delete(int[] ids)
{
if (ids != null)
{
movie_data md = new movie_data()
{
ID = ids[0]
};
using (_db = new DatahanteringEntities())
{
_db.movie_data.Attach(md);
_db.movie_data.Remove(_db.movie_data.Single(m => m.ID == md.ID));
_db.SaveChanges();
}
}
List <MovieViewModel> list = getMovies();
return(View("movie", list));
}
private List <MovieViewModel> getMovies(int?sortby = null)
{
String sortByParam = "Name";
if (sortby == 0)
{
sortByParam = "Name asc";
}
if (sortby == 1)
{
sortByParam = "Grade asc";
}
if (sortby == 2)
{
sortByParam = "Length asc";
}
List <MovieViewModel> list = new List <MovieViewModel>();
using (_db = new DatahanteringEntities())
{
Debugger.NotifyOfCrossThreadDependency();
//var getMovie = from md in _db.movie_data
// orderby md.Name
// select md;
//string sortBy = "Name";
string query = null;
using (SqlConnection conn = new SqlConnection())
{
query = "getMovieRows '" + sortByParam + " asc'";
conn.ConnectionString = "Data Source=DESKTOP-BPPIJVQ\\JDB;Initial Catalog=Datahantering;Integrated Security=True;";
conn.Open();
using (SqlCommand cmd = new SqlCommand("getMovieRows", conn))
{
cmd.Parameters.Add("@OrderByClause", SqlDbType.VarChar).Value = sortByParam;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
MovieViewModel mvd = new MovieViewModel();
mvd.ID = (int)reader["ID"];
mvd.Name = reader["Name"].ToString();
mvd.Grade = (int)reader["Grade"];
mvd.Length = (int)reader["Length"];
mvd.Summary = reader["Summary"].ToString();
mvd.Actor = reader["Actor"].ToString();
list.Add(mvd);
}
conn.Close();
}
}
}
// }
//}
//var query = from md in _db.movie_data
// join ma in _db.movie_actor on md.ID equals ma.movieID
// select new { md, ma };
//foreach (var row in query)
//{
// MovieViewModel mvd = new MovieViewModel();//{row.md.ID, row.md.Name, row.md.Grade, row.md.Length, row.md.Summary, row.ma.Actor.ToString() };
// mvd.ID = row.md.ID;
// mvd.Name = row.md.Name;
// mvd.Grade = row.md.Grade;
// mvd.Length = row.md.Length;
// mvd.Summary = row.md.Summary;
// mvd.Actor = row.ma.Actor;
// list.Add(mvd);
//}
//var query = from md in _db.movie_data
// join ma in _db.movie_actor on md.ID equals ma.movieID
// select new { md, ma };
}
return(list);
}
