private void LoadPreviousValues(object sender, RoutedEventArgs e)
{
if (Ratings == null)
{
Ratings = new RatingsModel();
}
else
{
TB_MyRating.Text = Ratings.MyRating;
TB_AmazonRating.Text = Ratings.AmazonRating;
TB_GoodReadsRating.Text = Ratings.GoodReadsRating;
}
}
public RatingsModel GetRatings(double userId)
{
var model = new RatingsModel();
var url = this.WorkerUrls.First();
var str = url.ToString() + "/Service/Ratings?userId=" + userId;
var start = DateTime.Now;
model.Ratings = RequestHelper.Get <Collection <Rating> >(str);
model.ElapsedTime = DateTime.Now.Subtract(start).TotalMilliseconds;
return(model);
}
public ActionResult StudentReviews(RatingsModel Data)
{
string usn = Session["USN"].ToString();
RNSITEntities1 db = new RNSITEntities1();
List <GetTeacherDetailsByUSN_Result> details = db.GetTeacherDetailsByUSNFunction(usn).ToList();
int counter = db.ValidS.Single(s => s.USN == usn).COUNTER;
var RID = details.ElementAt(counter).CombId;
RID_TABLE t = Data;
t.RID = details.ElementAt(counter).CombId;
db.RID_TABLE.Add(t);
var validS = db.ValidS.Single(s => s.USN == usn);
validS.COUNTER = ++counter;
db.SaveChanges();
return(RedirectToAction("StudentReviews", "Student"));
}
public ActionResult StudentReviews()
{
string usn = Session["USN"].ToString();
RNSITEntities1 db = new RNSITEntities1();
List <GetTeacherDetailsByUSN_Result> details = db.GetTeacherDetailsByUSNFunction(usn).ToList();
int counter = db.ValidS.Single(s => s.USN == usn).COUNTER;
if (counter < details.Count)
{
RatingsModel ratingsModel = new RatingsModel();
ratingsModel.Subcode = details.ElementAt(counter).SubCode;
ratingsModel.SubName = details.ElementAt(counter).SubName;
ratingsModel.TeacherName = details.ElementAt(counter).TeacherName;
return(View("Ratings", ratingsModel));
}
else
{
return(RedirectToAction("ReviewCompleted", "student"));
}
}
public ActionResult AddRating(RatingsModel Chuu2, int?id)
{
using (SqlConnection Rikka = new SqlConnection(Dekomori.GetConnection()))
{
Rikka.Open();
string Takanashi = @"INSERT INTO RSG_Ratings VALUES (@RSG_RID, @RSG_UserID, @RSG_Cleanliness, @RSG_CustomerService, @RSG_FoodQuality, @RSG_Remarks, @RSG_DateAdded)";
using (SqlCommand WickedEye = new SqlCommand(Takanashi, Rikka))
{
WickedEye.Parameters.AddWithValue("@RSG_RID", id);
WickedEye.Parameters.AddWithValue("@RSG_UserID", Session["userid"].ToString());
WickedEye.Parameters.AddWithValue("@RSG_Cleanliness", Chuu2.Cleanliness);
WickedEye.Parameters.AddWithValue("@RSG_CustomerService", Chuu2.CustomerService);
WickedEye.Parameters.AddWithValue("@RSG_FoodQuality", Chuu2.FoodQuality);
WickedEye.Parameters.AddWithValue("@RSG_Remarks", Chuu2.Remarks);
WickedEye.Parameters.AddWithValue("@RSG_DateAdded", DateTime.Now);
WickedEye.ExecuteNonQuery();
return(RedirectToAction("Index"));
}
}
}
/// <summary>
/// Gets the ratings.
/// </summary>
/// <param name="userId">The user id.</param>
/// <returns>A ratings collection model.</returns>
public RatingsModel GetRatings(double userId)
{
var model = new RatingsModel();
model.Ratings = new Collection <Rating>();
var query =
@"select title, movie_id, rating
from ratings
inner join movies
on movie_id = id
where user_id = @userId";
var command = new SqlCommand(query, this.Connection);
command.Parameters.Add(new SqlParameter("@userId", userId));
var start = DateTime.Now;
this.Connection.Open();
using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
var r = new Rating();
r.MovieTitle = (string)reader["title"];
r.MovieId = (Int64)reader["movie_id"];
r.Stars = (decimal)reader["rating"];
model.Ratings.Add(r);
}
}
model.ElapsedTime = DateTime.Now.Subtract(start).TotalMilliseconds;
return(model);
}
// Add Rating
public ActionResult AddRating()
{
RatingsModel Chuu2 = new RatingsModel();
return(View(Chuu2));
}
public void PostRatingsModel([FromBody] RatingsModel ratingsModel)
{
_context.ratingsModels.Add(ratingsModel);
_context.SaveChanges();
}
public void PostRatingsModel([FromBody] RatingsModel ratingsModel)
{
_ratingInterface.PostRatingsModel(ratingsModel);
}
public ActionResult ReviewCompleted(RatingsModel Data)
{
return(View());
}
