public void findview()
{
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
olu_da_layer dl = new olu_da_layer();
dt = dl.select_visit_counter();
if (dt.table.Rows.Count > 0)
{
divMyID.Attributes["data-to"] = dt.table.Rows[0]["visit_counter"].ToString();
}
}
public void GetFileUpload()
{
olu_ba_layer bl = new olu_ba_layer();
olu_da_layer dl = new olu_da_layer();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
try
{
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;
}
}
//bl.Panjiyan_category_id = "pic";
//dt = dl.Getfileupload(bl);
//if (dt.table.Rows.Count > 0)
//{
// Image1.Visible = true;
// byte[] bytes = (byte[])(dt.table.Rows[0][5]);
// string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
// Image1.ImageUrl = "data:image/jpg;base64," + base64String;
//}
//else
//{
bl.Panjiyan_category_id = "pic";
dt = dl.Getfileuploadforprofilepic(bl);
Image1.Visible = true;
byte[] bytes = (byte[])(dt.table.Rows[0][5]);
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image1.ImageUrl = "data:image/jpg;base64," + base64String;
// }
}
catch (NullReferenceException)
{
// Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel2, "Your Session Has Expired Please Login Again", "../Logout.aspx");
}
}
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 Getnewmessage_new()
{
olu_ba_layer bl = new olu_ba_layer();
olu_da_layer dl = new olu_da_layer();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
try
{
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.newmessage_update_new(bl);
if (dt.table.Rows.Count > 0 && dt.table.Rows[0]["newmessage"].ToString() != "0")
{
// lbl_new_message.Text = dt.table.Rows[0]["newmessage"].ToString();
// newbadge.Visible = true;
}
else
{
// newbadge.Visible = false;
}
}
catch (NullReferenceException)
{
// Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel2, "Your Session Has Expired Please Login Again", "../Logout.aspx");
}
}
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();
}
}
}
public void Getnewmessage()
{
olu_ba_layer bl = new olu_ba_layer();
olu_da_layer dl = new olu_da_layer();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
try
{
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;
}
}
if (Session["login_time_new"] != null)
{
bl.Logintimeformessage = Session["login_time_new"].ToString();
}
else
{
if (Request.Cookies["login_time_new"] != null)
{
Session["login_time_new"] = Request.Cookies["login_time_new"].Value;
bl.Logintimeformessage = Request.Cookies["login_time_new"].Value;
}
else
{
}
}
dt = dl.newmessage_update(bl);
if (dt.table.Rows.Count > 0)
{
// lbl_new_message.Text = dt.table.Rows.Count.ToString();
Session["userlbl_new_message"] = dt.table.Rows.Count.ToString();
Response.Cookies["userlbl_new_message"].Value = dt.table.Rows.Count.ToString();
Response.Cookies["userlbl_new_message"].Expires = DateTime.Now.AddDays(365);
// newbadge.Visible = true;
}
else
{
if (Session["userlbl_new_message"] == null)
{
// newbadge.Visible = false;
}
else
{
int i = Convert.ToInt32(Session["userlbl_new_message"].ToString());
int f = i;
Session["userlbl_new_message"] = f.ToString();
Response.Cookies["userlbl_new_message"].Value = f.ToString();
Response.Cookies["userlbl_new_message"].Expires = DateTime.Now.AddDays(365);
if (f > 0)
{
// lbl_new_message.Text = f.ToString();
}
else
{
// newbadge.Visible = false;
}
}
}
}
catch (NullReferenceException)
{
// Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel2, "Your Session Has Expired Please Login Again", "../Logout.aspx");
}
}
