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(); } } }