public void bind_rating()
{
if (Session["User_Id"] != null)
{
bl.User_id = Session["User_Id"].ToString();
}
else
{
if (Request.Cookies["User_Id"] != null)
{
Session["User_Id"] = Request.Cookies["User_Id"].Value;
bl.User_id = Request.Cookies["User_Id"].Value;
}
}
dt = dl.select_Insert_user_rating(bl);
if (dt.table.Rows.Count > 0 && dt.table.Rows[0]["RatingCount"].ToString() != "0")
{
//Rating1.CurrentRating = Convert.ToInt32(dt.table.Rows[0]["AverageRating"]);
//ViewState["Rating"] = Convert.ToInt32(dt.table.Rows[0]["AverageRating"]);
//txt_Heading.Text = dt.table.Rows[0]["headline"].ToString();
//txt_review.Text = dt.table.Rows[0]["review"].ToString();
// submit_review.Text = "Update Review";
submit_review.Text = "Submit";
GridView2.DataSource = dt.table;
GridView2.DataBind();
}
else
{
GridView2.DataSource = dt.table;
GridView2.DataBind();
}
dtt = dl.select_user_rating();
if (dtt.table.Rows.Count > 0)
{
lblRatingStatus.Text = string.Format("{0} Users have rated. Average Rating {1}", dtt.table.Rows[0]["RatingCount"], dtt.table.Rows[0]["AverageRating"]);
}
}
public void Review()
{
olu_ba_layer bl = new olu_ba_layer();
olu_da_layer dl = new olu_da_layer();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
ReturnClass.ReturnDataTable dtt = new ReturnClass.ReturnDataTable();
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
dt = dl.select_user_rating();
StringBuilder htmlTable = new StringBuilder();
string file_id = null;
if (dt.table.Rows.Count > 0)
{
foreach (DataRow row in dt.table.Rows)
{
bl.User_idd = row["user_id"].ToString();
if (row["user_type"].ToString() == "USER")
{
dtt = dl.bind_review_user_file_id(bl);
if (dtt.table.Rows.Count > 0)
{
file_id = dtt.table.Rows[0]["file_id"].ToString();
}
else
{
file_id = "8";
}
}
else
{
bl.User_idd = row["user_id"].ToString();
dtt = dl.bind_testimonial_file_id(bl);
if (dtt.table.Rows.Count > 0)
{
file_id = dtt.table.Rows[0]["file_id"].ToString();
}
else
{
file_id = "7";
}
}
htmlTable.AppendLine(" <div class=\"product left clearfix mb-40\">");
htmlTable.AppendLine("<div class=\"product-image\">");
if (row["user_type"].ToString() == "USER")
{
htmlTable.AppendLine("<img class=\"img-responsive llol\" alt=\"\" src=\"Handler_user.ashx?id=" + file_id + "\" width=\"35px\" height=\"35px\" /></div>");
}
else
{
htmlTable.AppendLine("<img class=\"img-responsive llol\" alt=\"\" src=\"Handler.ashx?id=" + file_id + "\" width=\"35px\" height=\"35px\" /></div>");
}
htmlTable.AppendLine("<div class=\"product-description\">");
htmlTable.AppendLine(" <div class=\"product-title\">");
int lol = Convert.ToInt32(row["AverageRating"]);
if (lol == 1)
{
htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i>");
}
else if (lol == 2)
{
htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i>");
}
else if (lol == 3)
{
htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i>");
}
else if (lol == 4)
{
htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i>");
}
else if (lol == 5)
{
htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i>");
}
htmlTable.AppendLine("</div>");
// htmlTable.AppendLine("<h5>" + row["name"] + " </h5></div>");
htmlTable.AppendLine("<div class=\"product-price\">");
htmlTable.AppendLine("<b>" + row["headline"] + " - </b><ins>" + row["review"] + "</ins></div>");
htmlTable.AppendLine("<div class=\"product-rate\">");
htmlTable.AppendLine("<h5>" + row["name"] + " </h5></div>");
//int lol =Convert.ToInt32(row["AverageRating"]);
//if (lol == 1)
// {
// htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i>");
//}
//else if (lol == 2)
//{
// htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i>");
//}
//else if (lol == 3)
//{
// htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i><i class=\"fa fa-star-o\"></i>");
//}
//else if (lol == 4)
//{
// htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star-o\"></i>");
//}
//else if (lol == 5)
//{
// htmlTable.AppendLine("<i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i><i class=\"fa fa-star\"></i>");
//}
// htmlTable.AppendLine("</div></div></div>");
htmlTable.AppendLine("</div></div>");
Literal2.Text = htmlTable.ToString();
}
}
}
