public string ExecuteRating(string data) { try { DataTable ds = new DataTable();; DataRating dataDetail = JsonConvert.DeserializeObject <DataRating>(data); if (HttpContext.Session.GetInt32(Comon.GlobalClient.CustomerID) == null) { return("0"); } int CustomerID = (int)HttpContext.Session.GetInt32(Comon.GlobalClient.CustomerID); using (Models.ExecuteDataBase confunc = new Models.ExecuteDataBase()) { ds = confunc.ExecuteDataTable("[YYY_sp_Rating_Insert]", CommandType.StoredProcedure , "@MovieID", SqlDbType.Int, dataDetail.MovieID , "@Note", SqlDbType.NVarChar, dataDetail.NoteRating , "@Rating", SqlDbType.Decimal, dataDetail.RatingMoive , "@CusID", SqlDbType.Int, CustomerID); } return(ds.Rows[0][0].ToString()); } catch (Exception ex) { return("[]"); } }
//Auto increment voor unit test data public int Insert(DataRating rating) { int id = GetId(); rating.RatingID = id; Ratings.Add(rating); return(id); }