//protected void Rating1_Changed(object sender, AjaxControlToolkit.RatingEventArgs e)
//{
// // Response.Write("<script>alert(\"you have rated this property as "+e.Value.ToString()+"\")</script>");
// Response.Write("you have rated this property as " + e.Value.ToString() + "");
// lblmsg.Text = "you have rated this property as " + e.Value.ToString() + "";
//}
protected void Rating1_Changed1(object sender, RatingEventArgs e)
{
user_id = Convert.ToInt32(Session["id"]);
try
{
con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\webdata.mdf;Integrated Security=True;MultipleActiveResultSets=true");
//i have used MultipleActiveResultSets=true in connectionstring for allowing multiple resultset.
con.Open();
if (cnt1 == 1)
{
SqlCommand sq = new SqlCommand("update tblrating set rating=" + e.Value + " where property_id=" + id + " and userid=" + user_id + "", con);
Response.Write(sq.CommandText);
sq.ExecuteNonQuery();
con.Close();
}
else
{
SqlCommand sq = new SqlCommand("insert into tblrating (rating,property_id,userip,userid) values(" + e.Value + "," + id + ",'" + myip + "'," + user_id + ")", con);
Response.Write(sq.CommandText);
sq.ExecuteNonQuery();
con.Close();
}
}
catch
{
msg.InnerHtml = "Sorry, something went wrong";
}
}
protected void Rating5_Changed(object sender, RatingEventArgs e)
{
if (e.Value == "2")
{
Rating5.CurrentRating = 10;
}
}
protected void RatingChanged(object sender, RatingEventArgs e)
{
//Rating r =(Rating) sender ;
//r.ReadOnly = true;
//string str= r.GetCallbackResult();
//int a = 10;
}
protected void elemRating_Changed(object sender, RatingEventArgs e)
{
// Actualize CurrentRating properties
elemRating.CurrentRating = ValidationHelper.GetInteger(e.Value, 0);
GetCurrentRating();
// Throw the rating event
OnRating();
}
protected void Rating1_Click1(object sender, RatingEventArgs e)
{
if (lastVal != Int32.Parse(e.Value))
{
lastVal = Int32.Parse(e.Value);
System.Diagnostics.Debug.WriteLine("entrei na merda do botao" + e.Value);
Auxiliar.Played(HttpContext.Current.User.Identity.Name.ToString(), Int32.Parse(Request.QueryString["id"]), Int32.Parse(e.Value));
Label2.Text = Auxiliar.GetAvgScore(Int32.Parse(Request.QueryString["id"])).ToString();
}
}
protected void productRating_Changed(object sender, RatingEventArgs e)
{
if (NopContext.Current.User == null || NopContext.Current.User.IsGuest)
{
lblProductRatingResult.Text = GetLocaleResourceString("Products.OnlyRegisteredUsersCanRating");
e.CallbackResult = GetLocaleResourceString("Products.OnlyRegisteredUsersCanRating");
}
else
{
ProductManager.SetProductRating(this.ProductId, int.Parse(e.Value));
lblProductRatingResult.Text = GetLocaleResourceString("Products.RatingWillBeUpdatedVerySoon");
e.CallbackResult = "Update done. Value = " + e.Value;
}
}
protected void Rating1_Changed(object sender, RatingEventArgs e)
{
string s = "select * from tbl_rating where user_id=" + Session["usid"] + " and product_id='" + e.Tag + "'";
DataTable dt = obj.GetDataTable(s);
if (dt.Rows.Count > 0)
{
}
else
{
string insqry = "insert into tbl_rating(user_id,product_id,rate_value)values(" + Session["usid"] + "," + e.Tag + "," + e.Value + ")";
obj.ExceuteCommand(insqry);
filldetails();
}
}
protected void Rating_Changed(object sender, RatingEventArgs args)
{
int rating;
if (!int.TryParse(args.Value, out rating))
{
return;
}
UserRating = rating;
UpdateDisplay();
if (RatingChanged != null)
{
RatingChanged(this, EventArgs.Empty);
}
}
protected void productRating_Changed(object sender, RatingEventArgs e)
{
if (NopContext.Current.User == null && this.CustomerService.AllowAnonymousUsersToSetProductRatings)
{
this.CustomerService.CreateAnonymousUser();
}
if (NopContext.Current.User == null || (NopContext.Current.User.IsGuest && !this.CustomerService.AllowAnonymousUsersToSetProductRatings))
{
lblProductRatingResult.Text = GetLocaleResourceString("Products.OnlyRegisteredUsersCanRating");
e.CallbackResult = GetLocaleResourceString("Products.OnlyRegisteredUsersCanRating");
}
else
{
this.ProductService.SetProductRating(this.ProductId, int.Parse(e.Value));
lblProductRatingResult.Text = GetLocaleResourceString("Products.RatingWillBeUpdatedVerySoon");
e.CallbackResult = "Update done. Value = " + e.Value;
}
}
protected void OnRatingChanged(object sender, RatingEventArgs e)
{
int rowIndex = ((sender as Rating).NamingContainer as GridViewRow).RowIndex;
int fruitId = Convert.ToInt32(gvFruits.DataKeys[rowIndex].Value);
string constr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO EventRating VALUES(@id, @Rating)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@id", fruitId);
cmd.Parameters.AddWithValue("@Rating", e.Value);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void productRating_Changed(object sender, RatingEventArgs e)
{
//Thread.Sleep(400);
//e.CallbackResult = "Update done. Value = " + e.Value + " Tag = " + e.Tag;
string howSpicy = "";
switch (productRating.CurrentRating)
{
case 1:
howSpicy = "Không tốt";
lblResponse.ForeColor = System.Drawing.Color.Red;
break;
case 2:
howSpicy = "Bình thường";
lblResponse.ForeColor = System.Drawing.Color.BlueViolet;
break;
case 3:
howSpicy = "Tốt";
lblResponse.ForeColor = System.Drawing.Color.Blue;
break;
case 4:
howSpicy = "Rất tốt";
lblResponse.ForeColor = System.Drawing.Color.Green;
break;
case 5:
howSpicy = "Hoàn hảo";
lblResponse.ForeColor = System.Drawing.Color.OrangeRed;
break;
}
Page.Title = title;
lblResponse.Text = "<b>" + howSpicy + "</b>";
}
protected void OnRatingChanged(object sender, RatingEventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["Data Source=192.168.1.2;Initial Catalog=AjaxSamples;Persist Security Info=True;User ID=sa;Password=oIIoAdmin"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO UserRatings VALUES(@Rating)"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Rating", e.Value);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
Response.Redirect(Request.Url.AbsoluteUri);
DataTable dt = this.GetData("SELECT ISNULL(AVG(Rating), 0) AverageRating, COUNT(Rating) RatingCount FROM UserRatings");
// Rating1.CurrentRating = Convert.ToInt32(dt.Rows[0]["AverageRating"]);
// lblRatingStatus.Text = string.Format("{0} Users have rated. Average Rating {1}", dt.Rows[0]["RatingCount"], dt.Rows[0]["AverageRating"]);
}
protected void RatingControlPlaylist_OnRate(object sender, RatingEventArgs e)
{
string id = Request.QueryString["id"];
try
{
if (id != null)
{
int intId = int.Parse(id);
var newRating = new Rating()
{
Value = e.RatingValue,
UserId = Page.User.Identity.GetUserId(),
PlaylistId = intId
};
ratings.Add(newRating);
ratings.SaveChanges();
}
}
catch (Exception)
{
}
}
protected void RatingAccuracy_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void RatingHabbit_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
/// <summary>
/// Run custom code when the user rates something and then return a custom string
/// to the JavaScript client
/// </summary>
/// <param name="sender">Rating control</param>
/// <param name="e">RatingEventArgs</param>
protected void ThaiRating_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
e.CallbackResult = "Update done. Value = " + e.Value + " Tag = " + e.Tag;
}
protected void RatingInitiative_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void RatingInnovation_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void Rating1_Changed(object sender, RatingEventArgs e)
{
}
protected void ThaiRating_Changed(object sender, RatingEventArgs e)
{
try
{
if (_productId == -1)
{
return;
}
if (!CustomerSession.CurrentCustomer.RegistredUser)
{
lblRatingInfo.Visible = true;
lblRatingInfo.Text = Resources.Resource.Client_Details_VotesCanRegUsers;
return;
}
var userId = CustomerSession.CurrentCustomer.Id;
using (var db = new SQLDataAccess())
{
//--------------------------------------------------
db.cmd.CommandText = "[Catalog].[sp_GetCOUNT_Ratio]";
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.Parameters.Clear();
db.cmd.Parameters.AddWithValue("@CustomerId", userId);
db.cmd.Parameters.AddWithValue("@ProductID", ProductId);
db.cnOpen();
if (SQLDataHelper.GetInt(db.cmd.ExecuteScalar()) >= 1)
{
db.cnClose();
ThaiRating.ReadOnly = true;
lblRatingInfo.Visible = true;
return;
}
//--------------------------------------------------
db.cmd.CommandText = "[Catalog].[sp_AddRatio]";
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.Parameters.Clear();
db.cmd.Parameters.AddWithValue("@ProductID", ProductId);
db.cmd.Parameters.AddWithValue("@ProductRatio", Convert.ToInt32(e.Value));
db.cmd.Parameters.AddWithValue("@CustomerId", userId);
db.cmd.ExecuteNonQuery();
//--------------------------------------------------
db.cmd.CommandText = "[Catalog].[sp_GetCOUNTRatioByProductID]";
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.Parameters.Clear();
db.cmd.Parameters.AddWithValue("@ProductID", ProductId);
lblSummRating.Text = @"(" + SQLDataHelper.GetString(db.cmd.ExecuteScalar()) + @" " + Resources.Resource.Client_Details_Votes + @")";
//--------------------------------------------------
db.cmd.CommandText = "[Catalog].[sp_GetAVGRatioByProductID]";
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.Parameters.Clear();
db.cmd.Parameters.AddWithValue("@ProductID", ProductId);
int intNewRatioValue = SQLDataHelper.GetInt(db.cmd.ExecuteScalar());
ThaiRating.CurrentRating = intNewRatioValue;
//--------------------------------------------------
db.cmd.CommandText = "[Catalog].[sp_UpdateProductRatio]";
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.Parameters.Clear();
db.cmd.Parameters.AddWithValue("@ProductID", ProductId);
db.cmd.Parameters.AddWithValue("@Ratio", intNewRatioValue);
db.cmd.ExecuteNonQuery();
db.cnClose();
}
ThaiRating.ReadOnly = true;
lblRatingInfo.Visible = true;
lblRatingInfo.Text = Resources.Resource.Client_Details_YourVoiceTaken;
}
catch (Exception ex)
{
//Debug.LogError(ex, sender, e);
Debug.LogError(ex);
}
}
protected void RatingKnowledge_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void RatingOrderliness_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void RatingChanged(object sender, RatingEventArgs e)
{
int ProductID = int.Parse(e.Tag);
string Rate = e.Value;
}
protected void Rating4_Changed(object sender, RatingEventArgs e)
{
e.CallbackResult = ((Rating)sender).ID + ";" + e.Value + ";" + e.Tag;
}
protected void Rating_AbsErro_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void RatingReliability_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void RatingAttendance_Changed(object sender, RatingEventArgs e)
{
Thread.Sleep(400);
}
protected void Rating_Set(object sender, RatingEventArgs args)
{
ViewState[RATINGKEY] = args.Value;
}
protected void Rating1_Click(object sender, RatingEventArgs e)
{
}
protected void OnRatingChanged(object sender, RatingEventArgs e)
{
hfRating.Value = e.Value;
Response.Write("<script>alert('Thank You...For giving us Rating')</script>");
}
