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