public void CreateRating(int customerID, int rating, int movieID)
{
using (CinemaEntities database = new CinemaEntities())
{
Rating newRating = database.Rating.Create();
//obecna data
DateTime myDateTime = DateTime.Now;
//format daty poprawny do sql
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm");
newRating.Rating_ID = Convert.ToInt32(database.sp_getSeqRatingID().FirstOrDefault());
newRating.Customer_ID = customerID;
newRating.Movie_ID = movieID;
newRating.Stars = rating;
newRating.Date = DateTime.Parse(sqlFormattedDate);
database.Rating.Add(newRating);
database.SaveChanges();
}
}
