public void RateItem(Ratings obj,bool isRated)
{
String q;
SqlConnection con = new SqlConnection(new ProjectUtilities().cons());
SqlCommand c;
con.Open();
if (isRated)
{
//Ratings obj = new Ratings().getRated(id);
//obj.totalraters++;
//obj.totalratings += rated;
q = "Update Ratings Set TotalRatings=@tr,TotalRaters=@trr Where Pid=@id";
c = new SqlCommand(q, con);
c.Parameters.Add("@tr", obj.totalratings);
c.Parameters.Add("@trr", obj.totalraters);
c.Parameters.Add("@id", obj.id);
c.ExecuteNonQuery();
con.Close();
}
else
{
q = "Insert into Ratings Values(@id,@tr,@trr)";
c = new SqlCommand(q, con);
c.Parameters.Add("@tr", obj.totalratings);
c.Parameters.Add("@trr", 1);
c.Parameters.Add("@id", id);
c.ExecuteNonQuery();
con.Close();
}
}
public Ratings getRated(int id)
{
String q = "Select * from Ratings where Pid=@id";
SqlConnection con = new SqlConnection(new ProjectUtilities().cons());
SqlCommand c = new SqlCommand(q, con);
con.Open();
c.Parameters.Add("@id", id);
SqlDataReader r = c.ExecuteReader();
r.Read();
Ratings obj = new Ratings();
obj.id = id;
obj.totalratings = int.Parse(r["TotalRatings"].ToString());
obj.totalraters = int.Parse(r["TotalRaters"].ToString());
obj.netratings = 0;
con.Close();
return obj;
}
protected void ProdRating_Changed()
{
int rating = ProdRating.CurrentRating;
Ratings o = new Ratings();
int id = int.Parse(Request.QueryString["pid"].ToString());
bool isRated = o.isRated(id);
o.id = id;
if (isRated)
{
o = o.getRated(id);
o.totalraters++;
o.totalratings += rating;
o.RateItem(o, isRated);
}
else
{
o.totalratings = rating;
o.totalraters = 1;
o.RateItem(o, isRated);
}
//ProdRating.Enabled = false;
ProdRating.ReadOnly = true;
}
private void setRatings()
{
String s = Request.QueryString["pid"].ToString();
Ratings o = new Ratings();
if (o.isRated(int.Parse(s)))
{
o = o.getRated(int.Parse(s));
ProdRating.CurrentRating = (int)(o.totalratings / o.totalraters);
RatingLabel.InnerText = "Average User Ratings : ";
}
else
{
RatingLabel.InnerText = "Be The First To Rate This Product !";
}
}