public void testimonial()
{
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.bind_testimonial();
StringBuilder htmlTable = new StringBuilder();
string file_id = null;
if (dt.table.Rows.Count > 0)
{
foreach (DataRow row in dt.table.Rows)
{
bl.User_id = 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=\"grid-item photography branding\">");
htmlTable.AppendLine("<div class=\"item\">");
htmlTable.AppendLine("<div class=\"testimonial theme-bg bottom_pos\">");
htmlTable.AppendLine("<div class=\"testimonial-avatar\">");
htmlTable.AppendLine("<img src=\"online_user/Handler.ashx?id=" + file_id + "\" width=\"100\" height=\"104px\" /> </div>");
htmlTable.AppendLine("<div class=\"testimonial-info\">" + row["testimonial"] + "</div>");
htmlTable.AppendLine("<div class=\"author-info\"><strong>" + row["name"] + " <br><span>Cell Salts User</span></strong> </div>");
htmlTable.AppendLine("</div></div></div>");
// Literal1.Text = htmlTable.ToString();
}
}
}
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();
}
}
}
