public ReturnBool delete_subject(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Subject_id", ur.Subject_id)
};
query = @"delete from subjects where Subject_id=@Subject_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnClass.ReturnDataTable INTSUB_video_id(olu_ba_layer co)
{
query = "SELECT IFNULL(MAX(CAST(SUBSTRING(video_id,7,4) as UNSIGNED INTEGER)),0) as pid from video_topic_wise WHERE year(date_time) = @c_year AND month(date_time)=@c_month ";
MySqlParameter[] pr = new MySqlParameter[] {
new MySqlParameter("c_year", co.C_year),
new MySqlParameter("c_month", co.C_month),
};
dt = db.executeSelectQuery(query, pr);
return(dt);
}
public ReturnBool delete_class(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Class_id", ur.Class_id)
};
query = @"delete from classes where Class_id=@Class_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnDataTable get_class_code(olu_ba_layer ur)
{
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Class_Name", ur.Class_id)
};
query = @"select * from classes where Class_Name=@Class_Name ";
dt = db.executeSelectQuery(query, pm);
return(dt);
}
public ReturnBool delete_Video(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("video_id", ur.Video_id)
};
query = @"delete from video_topic_wise where video_id=@video_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool delete_topic(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Topic_id", ur.Topic_id)
};
query = @"delete from topics_wise_subject where Topic_id=@Topic_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool update_class(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Class_Name", ur.Category),
new MySqlParameter("Class_id", ur.Class_id)
};
query = @"update classes set Class_Name=@Class_Name where Class_id=@Class_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnDataTable get_subject_id(olu_ba_layer ur)
{
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Name", ur.Desc + "%"),
new MySqlParameter("class_id", ur.Class_code)
};
query = @"select * from subjects s where s.class_id=@class_id and subject_name like @Name ";
dt = db.executeSelectQuery(query, pm);
return(dt);
}
public ReturnBool update_subject(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Subject_Name", ur.Category),
new MySqlParameter("Subject_id", ur.Subject_id),
new MySqlParameter("class_id", ur.Class_id)
};
query = @"update subjects set Subject_Name=@Subject_Name,class_id=@class_id where Subject_id=@Subject_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnDataTable get_class_videos(olu_ba_layer ur)
{
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Subject_id", ur.Symptom_id)
};
query = @"select * from topics_wise_subject t
join video_topic_wise v on v.Topic_id=t.Topic_id
where t.Subject_id=@Subject_id";
dt = db.executeSelectQuery(query, pm);
return(dt);
}
public ReturnBool update_topic(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Topic_Name", ur.Headline),
new MySqlParameter("Subject_id", ur.Subject_id),
new MySqlParameter("Topic_Description", ur.Description),
new MySqlParameter("Topic_id", ur.Topic_id)
};
query = @"update topics_wise_subject set Topic_Name=@Topic_Name,Topic_Description=@Topic_Description,Subject_id=@Subject_id where Topic_id=@Topic_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public void bind_class_id()
{
olu_ba_layer bl = new olu_ba_layer();
olu_da_layer_new dl = new olu_da_layer_new();
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["class"] != null)
{
bl.Class_id = Session["class"].ToString();
}
else
{
if (Request.Cookies["class"] != null)
{
Session["class"] = Request.Cookies["class"].Value;
bl.Class_id = Request.Cookies["class"].Value;
}
}
if (Session["stream"] != null)
{
bl.Stream_id = Session["stream"].ToString();
}
else
{
if (Request.Cookies["stream"] != null)
{
Session["stream"] = Request.Cookies["stream"].Value;
bl.Stream_id = Request.Cookies["stream"].Value;
}
}
dt = dl.get_class_code(bl);
if (dt.table.Rows.Count > 0)
{
Session["Class_id"] = dt.table.Rows[0]["Class_id"].ToString();
Response.Cookies["Class_id"].Value = Session["Class_id"].ToString();
Response.Cookies["Class_id"].Expires = DateTime.Now.AddDays(365);
}
}
public ReturnBool Insert_class(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Class_id", ur.Class_id),
new MySqlParameter("Class_Name", ur.Category),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
query = @"INSERT INTO classes(Class_id,Class_Name,client_ip,user_id,date_time)
VALUES(@Class_id,@Class_Name,@client_ip,@user_id,@date_time)";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool Insert_topic(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Topic_id", ur.Topic_id),
new MySqlParameter("Subject_id", ur.Subject_id),
new MySqlParameter("Topic_Name", ur.Headline),
new MySqlParameter("Topic_Description", ur.Description),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
query = @"INSERT INTO topics_wise_subject(Topic_id,Subject_id,Topic_Name,Topic_Description,client_ip,user_id,date_time)
VALUES(@Topic_id,@Subject_id,@Topic_Name,@Topic_Description,@client_ip,@user_id,@date_time)";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool update_Video(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("video_id", ur.Video_id),
new MySqlParameter("Topic_id", ur.Topic_id),
new MySqlParameter("video_heading", ur.Headline),
new MySqlParameter("video_description", ur.Description),
new MySqlParameter("video_url", ur.User_type),
new MySqlParameter("contentType", ur.Mime_type),
new MySqlParameter("path", ur.Panjiyan_category_id),
new MySqlParameter("extension", ur.File_extn)
};
query = @"update video_topic_wise set Topic_id=@Topic_id,video_heading=@video_heading,video_description=@video_description,video_url=@video_url,contentType=@contentType,path=@path,extension=@extension where video_id=@video_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
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 ReturnBool Insert_Video(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("video_id", ur.Video_id),
new MySqlParameter("Topic_id", ur.Topic_id),
new MySqlParameter("video_heading", ur.Headline),
new MySqlParameter("video_description", ur.Description),
new MySqlParameter("video_url", ur.User_type),
new MySqlParameter("contentType", ur.Mime_type),
new MySqlParameter("path", ur.Panjiyan_category_id),
new MySqlParameter("extension", ur.File_extn),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
query = @"INSERT INTO video_topic_wise(video_id,Topic_id,video_heading,video_description,video_url,contentType,path,extension,client_ip,user_id,date_time)
VALUES(@video_id,@Topic_id,@video_heading,@video_description,@video_url,@contentType,@path,@extension,@client_ip,@user_id,@date_time)";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
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");
}
}
