protected void getReviews()
{
Classes.UserInfo ui = new Classes.UserInfo();
Tuple <int[], DataTable> result = ui.reviews(Convert.ToInt32(Page.RouteData.Values["Id"].ToString()));
int[] rateCount = result.Item1;
DataTable dt = result.Item2;
if (dt.Rows.Count != 0)
{
LabelRateOne.Text = rateCount[0].ToString();
LabelRateTwo.Text = rateCount[1].ToString();
LabelRateThree.Text = rateCount[2].ToString();
LabelRateFour.Text = rateCount[3].ToString();
LabelRateFive.Text = rateCount[4].ToString();
RepeaterReviews.DataSource = dt;
RepeaterReviews.DataBind();
}
else
{
LabelReviewsNoRecord.Visible = true;
LabelReviewsNoRecord.Text = "There is no review!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserId"] != null)
{
int providerId = Convert.ToInt32(Session["ProviderId"]);
int skillId = Convert.ToInt32(Session["SkillReviewed"]);
int count = 0;
string connString = ConfigurationManager.ConnectionStrings["UserDetailsConnectionString"].ConnectionString;
using (SqlConnection connect = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("select count(*) from tblReviews where ReviewedUserId=@ReviewedUserId and ReviewedSkillId=@ReviewedSkillID"))
{
cmd.Connection = connect;
connect.Open();
cmd.Parameters.AddWithValue("@ReviewedUserId", providerId);
cmd.Parameters.AddWithValue("@ReviewedSkillID", skillId);
count = Convert.ToInt32(cmd.ExecuteScalar().ToString());
}
}
if (count == 0)
{
lblMessage.Text = "No Reviews Till now";
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = "5;url=ProviderProfile.aspx";
this.Page.Controls.Add(meta);
}
RepeaterReviews.DataSource = GetReviews("Select u.Name,r.Review from tblUsers as u inner join tblReviews as r on r.ReviewerId=u.Id where ReviewedUserId = " + providerId + " and ReviewedSkillId = " + skillId + "");
RepeaterReviews.DataBind();
}
else
{
Response.Redirect("Login.aspx");
}
}
protected void getReviews()
{
Classes.Reviews r = new Classes.Reviews();
Tuple <int[], DataTable> result = r.reviews(profileId);
int[] rateCount = result.Item1;
DataTable dt = result.Item2;
if (dt.Rows.Count != 0)
{
LabelRateOne.Text = rateCount[0].ToString();
LabelRateTwo.Text = rateCount[1].ToString();
LabelRateThree.Text = rateCount[2].ToString();
LabelRateFour.Text = rateCount[3].ToString();
LabelRateFive.Text = rateCount[4].ToString();
RepeaterReviews.DataSource = dt;
RepeaterReviews.DataBind();
HiddenFieldReviewsStatus.Value = "1";
}
else
{
HiddenFieldReviewsStatus.Value = "0";
}
}
