public void AddReviewEntry(ReviewEntry reviewEntry)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
db.ReviewEntries.Add(reviewEntry);
db.SaveChanges();
}
}
private ReviewEntry CreateReviewEntry(ReviewInformation reviewInformation)
{
ReviewEntry reviewEntry = new ReviewEntry
{
userId = reviewInformation.userName + reviewInformation.hospitalId.ToString(),
userName = reviewInformation.userName,
userRating = reviewInformation.Rating,
userFeedback = reviewInformation.userFeedback,
hospitalId = reviewInformation.hospitalId,
isValid = true
};
return(reviewEntry);
}
public ActionResult Overview(ReviewInformation reviewInformation)
{
if (reviewInformation == null || reviewInformation.userName == null)
{
return(View("Error", null));
}
int id = reviewInformation.hospitalId;
ReviewEntry review = CreateReviewEntry(reviewInformation);
if (review != null)
{
this.DbQueryHandler.AddReviewEntry(review);
}
ModelState.Clear();
var model = ModelGenerator.GenerateHospitalDataModel(id);
return(View(model));
}
protected void Page_Load(object sender, EventArgs e)
{
cnString = ConfigurationSettings.AppSettings["connectionstring"].ToString();
string jokeId = Request.QueryString["jokeId"];
string ratingFromUser = Request.QueryString["rating"];
double ratingFromUserDouble = Double.Parse(ratingFromUser);
ratingFromUserDouble = ratingFromUserDouble*10;
int ratingFromUserInt = (int)ratingFromUserDouble;
ratingFromUserDouble = (double)ratingFromUserInt / (double)10;
MySqlConnection cn = new MySqlConnection(cnString);
try
{
DateTime dt = DateTime.Now;
string date = String.Format("{0:s}", dt);
string sqlstringInsert = "INSERT INTO jokesRating(JokeId,JokeRating,DateAdded) Values(" ;
sqlstringInsert += jokeId+ ", '" + ratingFromUserDouble + "','" + date + "')" ;
//Response.Write(sqlstringInsert + "<br>");
cn.Open();
MySqlCommand command = new MySqlCommand(sqlstringInsert, cn);
command.ExecuteNonQuery();
cn.Close();
string sqlstringSelect = "SELECT * FROM jokesRating where JokeId=" + jokeId + " order by DateAdded";
MySqlDataAdapter dr = new MySqlDataAdapter(sqlstringSelect, cn);
DataSet ds = new DataSet();
dr.Fill(ds, "jokes");
float oldRating = 0;
float newRating = 0;
int oldRatingNum = 0;
int newRatingNum = 0;
foreach( DataRow row in ds.Tables["jokes"].Rows )
{
String dateStr = row["DateAdded"].ToString() ;
DateTime dateAdded = DateTime.Parse(dateStr);
float rowRate = float.Parse( row["JokeRating"].ToString() );
if ( dateAdded < DateTime.Now.AddDays(-7) )
{
oldRating += rowRate ;
oldRatingNum++;
}
else
{
newRating += rowRate;
newRatingNum++;
}
}
float totalRating = 0.0f;
int totalRatingNum = (oldRatingNum + newRatingNum);
if ( newRating > 0 && oldRatingNum > 0)
totalRating = (float)newRating/ (float)newRatingNum * 0.7f + (float)oldRating / (float)oldRatingNum * 0.3f;
else if ( newRating > 0 )
totalRating = (float)newRating/ (float)newRatingNum ;
else if (oldRatingNum > 0 )
totalRating = (float)oldRating / (float)oldRatingNum;
//Response.Write(totalRating + "<br>");
string sqlstringUpdate = "UPDATE jokes set StarRating='" + totalRating + "', numOfVotes=" + totalRatingNum + " where id=" + jokeId;
//Response.Write(sqlstringUpdate + "<br>");
cn.Open();
MySqlCommand commandUpdate = new MySqlCommand(sqlstringUpdate, cn);
commandUpdate.ExecuteNonQuery();
cn.Close();
ReviewEntry obj = new ReviewEntry();
obj.reviewStars = totalRating;
obj.numOfVotes = totalRatingNum;
Response.Write(JsonConvert.SerializeObject( obj ) );
/*
DataSet ds = new DataSet();
dr.Fill(ds, "jokes");
DataRow row = ds.Tables["jokes"].Rows[0];
//Response.Write(row["rating"].ToString());
int rating = Int32.Parse( row["rating"].ToString() );
rating++;
string sqlstringUpdate = "UPDATE jokes SET rating = " + rating + " where id =" + jokeId;
cn.Open();
MySqlCommand command = new MySqlCommand(sqlstringUpdate, cn);
command.ExecuteNonQuery();*/
// Explicitly dispose the SelectCommand instance
dr.SelectCommand.Dispose();
dr.Dispose();
}
catch(Exception _Exception)
{
Response.Write(_Exception.ToString());
}
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
}
protected void Page_Load(object sender, EventArgs e)
{
string jokeId = Request.QueryString["jokeId"];
string ratingFromUser = Request.QueryString["rating"];
MySqlConnection cn = new MySqlConnection(cnString);
try
{
DateTime dt = DateTime.Now;
string date = String.Format("{0:s}", dt);
string sqlstringInsert = "INSERT INTO jokesRating(JokeId,JokeRating,DateAdded) Values(";
sqlstringInsert += jokeId + ", '" + ratingFromUser + "','" + date + "')";
//Response.Write(sqlstringInsert + "<br>");
cn.Open();
MySqlCommand command = new MySqlCommand(sqlstringInsert, cn);
command.ExecuteNonQuery();
cn.Close();
string sqlstringSelect = "SELECT * FROM jokesRating where JokeId=" + jokeId + " order by DateAdded";
MySqlDataAdapter dr = new MySqlDataAdapter(sqlstringSelect, cn);
DataSet ds = new DataSet();
dr.Fill(ds, "jokes");
double oldRating = 0;
double newRating = 0;
int oldRatingNum = 0;
int newRatingNum = 0;
foreach (DataRow row in ds.Tables["jokes"].Rows)
{
String dateStr = row["DateAdded"].ToString();
DateTime dateAdded = DateTime.Parse(dateStr);
double rowRate = double.Parse(row["JokeRating"].ToString());
if (dateAdded < DateTime.Now.AddDays(-7))
{
oldRating += rowRate;
oldRatingNum++;
}
else
{
newRating += rowRate;
newRatingNum++;
}
}
double totalRating = 0.0;
if (newRating > 0 && oldRatingNum > 0)
{
totalRating = (double)newRating / (double)newRatingNum * 0.7 + (double)oldRating / (double)oldRatingNum * 0.3;
}
else if (newRating > 0)
{
totalRating = (double)newRating / (double)newRatingNum;
}
else if (oldRatingNum > 0)
{
totalRating = (double)oldRating / (double)oldRatingNum;
}
//Response.Write(totalRating + "<br>");
string sqlstringUpdate = "UPDATE jokes set StarRating='" + totalRating + "' where id=" + jokeId;
//Response.Write(sqlstringUpdate + "<br>");
cn.Open();
MySqlCommand commandUpdate = new MySqlCommand(sqlstringUpdate, cn);
commandUpdate.ExecuteNonQuery();
cn.Close();
ReviewEntry obj = new ReviewEntry();
obj.reviewStars = totalRating;
Response.Write(JsonConvert.SerializeObject(obj));
/*
* DataSet ds = new DataSet();
* dr.Fill(ds, "jokes");
*
* DataRow row = ds.Tables["jokes"].Rows[0];
* //Response.Write(row["rating"].ToString());
* int rating = Int32.Parse( row["rating"].ToString() );
* rating++;
* string sqlstringUpdate = "UPDATE jokes SET rating = " + rating + " where id =" + jokeId;
*
* cn.Open();
* MySqlCommand command = new MySqlCommand(sqlstringUpdate, cn);
* command.ExecuteNonQuery();*/
// Explicitly dispose the SelectCommand instance
dr.SelectCommand.Dispose();
dr.Dispose();
}
catch (Exception _Exception)
{
Response.Write(_Exception.ToString());
}
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
}
