protected void FillNoms(string n_id) { div_nom.InnerHtml = ""; //string sql = "Select ns.id as id, (Select CONCAT(fname, ' ', lname) from org_structure where id=ns.to_id) as toName,(Select CONCAT(fname, ' ', lname) from org_structure where id=ns.from_id) as fromName, n.title as title, ns.time as time, ns.notes as notes, n.icon as icon from eng_nom_submissions as ns, eng_nominations as n where eng_nom_submissions.nom_id = eng_nominations.id order by ns.time desc"; string sql = "Select ns.id as id, ns.to_id as to_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.to_id) as toName, ns.from_id as from_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.from_id) as fromName, (Select title from eng_nominations where id=ns.nom_id) as title, DATEADD(hour, -5, ns.time) as time, ns.notes as notes, (Select icon from eng_nominations where id=ns.nom_id) as icon, ns.nom_id as nom_id from eng_nom_submissions as ns where ns.nom_id = @nom_id AND (MONTH(DATEADD(hour, -5, time)) = MONTH(DATEADD(hour, -5, GetDate())) AND YEAR(DATEADD(hour, -5, time)) = YEAR(DATEADD(hour, -5, GetDate()))) order by ns.time desc"; SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@nom_id", n_id); DataTable dt = Eng_Data.eng_Datatable(sql, parms); foreach (DataRow dr in dt.Rows) { string id = dr.ItemArray[0].ToString(); string to_id = dr.ItemArray[1].ToString(); string toname = dr.ItemArray[2].ToString(); string from_id = dr.ItemArray[3].ToString(); string fromname = dr.ItemArray[4].ToString(); string title = dr.ItemArray[5].ToString(); string time = dr.ItemArray[6].ToString(); string notes = dr.ItemArray[7].ToString(); string icon = dr.ItemArray[8].ToString(); string nom_id = dr.ItemArray[9].ToString(); string format = "<div class='news_item'><a href='/nominations.aspx?id={8}'><img style='float:left;margin:-7px 5px;border:1px solid #CCC;' src='{7}' /></a><a href='/directory/profile.aspx?id={0}'>{1}<a> Nominated <a href='/directory/profile.aspx?id={2}'>{3}<a> for the {4} award on {5}<br /><i>{6}</i></div>"; div_nom.InnerHtml += string.Format(format, from_id, fromname, to_id, toname, title, time, notes, icon, nom_id); } }
protected void ButtonSend_Click(object sender, EventArgs e) { string sql = "Insert into eng_feedback (feedback, [user], url) VALUES (@feedback, @user, @url)"; SqlParameter[] parms = new SqlParameter[3]; parms[0] = new SqlParameter("@feedback", TextBoxMessage.Text); parms[1] = new SqlParameter("@user", User.Identity.Name.ToString()); parms[2] = new SqlParameter("@url", Request.UrlReferrer.AbsolutePath.ToString()); int TotalFeedback = Eng_Data.eng_Count("Select count(id) from eng_feedback where [user] = '" + User.Identity.Name.ToString() + "' AND time >= CAST(CURRENT_TIMESTAMP AS DATE) and time < DATEADD(DD, 1, CAST(CURRENT_TIMESTAMP AS DATE)) ", new SqlParameter[0]); if (TotalFeedback < 5) { Eng_Data.eng_Update(sql, parms); SuccessText += " You have earned 5 points for submitting today! (" + (TotalFeedback + 1) + " submission(s))"; Eng_Data.eng_AddPoints(User.Identity.Name.ToString(), 5, "Submitting Feedback."); } else if (TotalFeedback > 4) { Eng_Data.eng_Update(sql, parms); SuccessText += " You have earned your maximum feedback points for the day."; } HtmlForm form = Page.FindControl("MailForm") as HtmlForm; if (form != null) { form.Controls.Clear(); WebControl textControl = CreateCentredText(); textControl.ForeColor = Color.FromArgb(0, 51, 51); if (textControl != null) { form.Controls.Add(textControl); } } }
protected void GetLikes(string id) { string sql = "Select [user] from eng_likes where ns_id = " + id + ""; DataTable dt = new DataTable(); dt = Eng_Data.eng_Datatable(sql, new SqlParameter[0]); foreach (DataRow dr in dt.Rows) { foreach (string i in dr.ItemArray) { Tuple <string, string> t = Eng_Data.getUserFullName(i); string pic = "unknown"; if (System.IO.File.Exists(HttpContext.Current.Server.MapPath("/content/images/sycom/employees/icons/" + t.Item1 + t.Item2.Replace("'", "") + ".jpg"))) { pic = t.Item1 + t.Item2.Replace("'", ""); } else { pic = "unknown"; } nom_likes.InnerHtml += "<a href='/directory/profile.aspx?id=" + i + "'><img src='/content/images/sycom/employees/icons/" + pic + ".jpg' height='20px' width='20px' />" + t.Item1 + " " + t.Item2 + "</a><br />"; } } }
protected void BindData() { string sql = "Select * from eng_townhall order by time desc"; lv_thq.DataSource = Eng_Data.eng_Datatable(sql, new SqlParameter[0]); lv_thq.DataBind(); }
protected void GetGames() { string sql = "Select id, title, embed from eng_games"; SqlParameter[] parms = new SqlParameter[0]; ddl_games.DataSource = Eng_Data.eng_Datatable(sql, parms); ddl_games.DataBind(); }
protected void FillDDL_What() { string sql = "Select id, title, icon from eng_nominations where isactive=1 and isnom=1"; SqlParameter[] parms = new SqlParameter[0]; cb_what.DataSource = Eng_Data.eng_Datatable(sql, parms); cb_what.DataBind(); }
protected void FillCertifications() { Object x = Eng_Data.GetSingle("eng_users_profile", "certifications", "userid='" + User.Identity.Name.ToString() + "'"); foreach (string y in x.ToString().Split(',')) { tk_Certifications.Tokens.Add(y); } }
protected void GetCards() { SqlParameter[] parms = new SqlParameter[0]; string sql = "Select id, CONCAT(fname, ' ',lname) as employee, email, title, reports_to, location, department, hiredate from eng_users where is_active = 1"; DataTable dt = Eng_Data.eng_Datatable(sql, parms); cv_Employees.DataSource = dt; cv_Employees.DataBind(); }
protected void FillDDL_Who() { string sql = "Select email, CONCAT(lname, ', ', fname) as name from eng_users where is_active=1 order by lname"; SqlParameter[] parms = new SqlParameter[0]; DataTable dt = Eng_Data.eng_Datatable(sql, parms); cb_who.DataSource = dt; cb_who.DataBind(); }
protected void FillDesc() { DataTable dt = Eng_Data.eng_Datatable("Select icon, title, description from eng_nominations where isactive=1 and isnom=1", new SqlParameter[0]); string format = "<p><img src=\"{0}\" alt=\"{1}\" /> {1} <br />{2}</p>"; foreach (DataRow dr in dt.Rows) { div_nom_desc.InnerHtml += string.Format(format, dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString(), dr.ItemArray[2].ToString()); } }
protected void GetMembers(string id) { string sql = "Select member_id from eng_camp_members where camp_id=" + id; DataTable dt = Eng_Data.eng_Datatable(sql, new System.Data.SqlClient.SqlParameter[0]); foreach (DataRow dr in dt.Rows) { camp_members.InnerHtml += "<a href='/Directory/Profile.aspx?id=" + dr.ItemArray[0].ToString() + "'>" + dr.ItemArray[0].ToString() + "</a>"; } }
public int GetLikeCount(string id) { int i = Eng_Data.eng_Count("Select count(id) from eng_likes where ns_id=" + id, new SqlParameter[0]); if (i == -1) { i = 0; } return(i); }
public bool IsLiked(object ns_id) { string u = User.Identity.Name.ToString(); //string u = "*****@*****.**"; //welcome.InnerHtml = user; //Select user from eng_points where ns_id = ns_id //Return a list of users bool l = Eng_Data.eng_Exists("Select id from eng_likes where [user]='" + u + "' AND ns_id=" + ns_id + ""); return(l); }
protected void UpdateButton_Click(object sender, EventArgs e) { string sql = "Insert into eng_feedback (feedback, user, time) VALUES (@feedback, @user, NOW())"; SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@feedback", TextBoxMessage.Text); parms[1] = new SqlParameter("@user", User.Identity.Name.ToString()); Eng_Data.eng_Update(sql, parms); lbl_results.Text = "Feedback Sent. Thank you for your help!"; }
protected string GetSubordinates(string email, int id, int iteration) { iteration++; string parenttemplate = "<div class=\"stiff-chart-level\" data-level=\"0{0}\"><div class=\"stiff-child\" data-child-from=\"{1}\"><ul>{2}</ul></div></div>"; string sql = "Select id, email, fname, lname, title from eng_users where is_active=1 and reports_to='" + email + "'"; SqlParameter[] p = new SqlParameter[0]; DataTable d = Eng_Data.eng_Datatable(sql, p); string par = string.Format(parenttemplate, iteration + 1, id, getChildren(d, id, iteration)); return(par); }
//public string IsLiked(object ns_id) //{ // string user = User.Identity.Name.ToString(); // List<string> users = new List<string>(); // //Select user from eng_points where ns_id = ns_id // //Return a list of users // bool l = true; // Eng_Data.eng_ListOfStrings("Select user_id from eng_points where nom_id = " + ns_id + "", new SqlParameter[0]).Any; // foreach(string u in users.) // return l; //} protected void BindNews() { //string UName = "*****@*****.**"; string sql = "Select ns.id as id, ns.to_id as to_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.to_id) as toName, ns.from_id as from_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.from_id) as fromName, (Select title from eng_nominations where id=ns.nom_id) as title, DATEADD(hour, -4, ns.time) as time, left(ns.notes, 200) as notes, (Select icon from eng_nominations where id=ns.nom_id) as icon, ns.nom_id as nom_id, (Select count(id) from eng_likes where ns_id = ns.id) as liked from eng_nom_submissions as ns where MONTH(DATEADD(hour, -5, time)) = MONTH(DATEADD(hour, -5, GETDATE())) AND YEAR(DATEADD(hour, -5, time)) = YEAR(DATEADD(hour, -5, GETDATE())) order by ns.time desc"; //Response.Write(sql); SqlParameter[] parms = new SqlParameter[0]; DataTable dt = Eng_Data.eng_Datatable(sql, parms); lv_events.DataSource = dt; lv_events.DataBind(); }
protected void GetTrophies(string user) { object uid = Eng_Data.GetSingleInt("eng_users", "id", "email='" + user + "'"); string sql = "Select n.icon as Icon from eng_nominations as n, eng_winners as w where n.id=w.nom_id and w.winner_id = '" + uid.ToString() + "' "; SqlParameter[] parms = new SqlParameter[0]; DataTable dt = Eng_Data.eng_Datatable(sql, parms); foreach (DataRow dr in dt.Rows) { trophy.InnerHtml += "<img class='img_trophy' src='" + dr.ItemArray[0].ToString() + "' />"; } }
protected string GetMyCampaigns() { string x = ""; string sql = "Select id, title from eng_campaigns where owner_id='" + User.Identity.Name.ToString() + "'"; DataTable dt = Eng_Data.eng_Datatable(sql, new SqlParameter[0]); foreach (DataRow dr in dt.Rows) { x += "<a href='/campaign/campaign.aspx?id=" + dr.ItemArray[0].ToString() + "'>" + dr.ItemArray[1].ToString() + "</a><br />"; } //Select from eng_campaigns where owner_id = Current User Email ID //Select from eng_campaigns_members where member_id = Current Email ID return(x); }
protected void btn_Submit_Click(object sender, EventArgs e) { //Create New Campaign // SQL = SqlParameter[] parms = new SqlParameter[5]; parms[0] = new SqlParameter("@title", txtTitle.Text); parms[1] = new SqlParameter("@description", ASPxHtmlEditor1.Html.ToString()); parms[2] = new SqlParameter("@owner_id", User.Identity.Name.ToString()); parms[3] = new SqlParameter("@status", "Open"); parms[4] = new SqlParameter("@keywords", tb_Keywords.Value.ToString()); string sql = "Insert into eng_campaigns (title, description, owner_id, status, keywords) VALUES(@title, @description, @owner_id, @status, @keywords)"; Eng_Data.eng_Update(sql, parms); }
protected void submitButton_Click(object sender, EventArgs e) { string user = User.Identity.Name.ToString(); string result = Eng_Data.SubmitNomination(user, Request.QueryString["id"].ToString(), cb_what.Value.ToString(), description.Value.ToString()); if (result == "") { Response.Redirect(Request.RawUrl); } else { Response.Write(result); } }
protected void submitButton_Click(object sender, EventArgs e) { string user = User.Identity.Name.ToString(); string nominees = token_who.Value.ToString(); string[] noms = nominees.Split(','); foreach (string nom in noms) { string result = Eng_Data.SubmitNomination(user, nom, cb_what.Value.ToString(), description.Value.ToString()); } Response.Redirect(Request.RawUrl); //Response.Write(nominees); }
protected void GetWinners() { string sql = "Select u.fname, u.lname, n.name from eng_users, "; SqlParameter[] parms = new SqlParameter[0]; DataTable dt = Eng_Data.eng_Datatable(sql, parms); foreach (DataRow dr in dt.Rows) { foreach (object item in dr.ItemArray) { div_results.InnerHtml += item.ToString(); } div_results.InnerHtml += "<br />"; } }
protected void FillLeaderBoards_AllTime() { string sql = string.Empty; string sql_2 = string.Empty; string sql_3 = string.Empty; string sql_4 = string.Empty; string sql_5 = string.Empty; string sql_6 = string.Empty; DateTime d = DateTime.Now; sql = "SELECT DENSE_RANK() OVER (ORDER BY SUM(p.points) DESC) AS rank, SUM(p.points) as points, (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where is_active=1 AND email=p.user_id) as name, p.user_id as user_id FROM eng_points as p Group BY user_id"; sql_6 = "SELECT DENSE_RANK() OVER (ORDER BY COUNT(id) DESC) AS rank, count(id) as count, (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where is_active=1 AND email=p.to_id) as name, p.to_id as user_id FROM eng_nom_submissions as p where nom_id =5 Group BY to_id"; sql_5 = "SELECT DENSE_RANK() OVER (ORDER BY COUNT(id) DESC) AS rank, count(id) as count, (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where is_active=1 AND email=p.to_id) as name, p.to_id as user_id FROM eng_nom_submissions as p where nom_id =6 Group BY to_id"; sql_4 = "SELECT DENSE_RANK() OVER (ORDER BY COUNT(id) DESC) AS rank, count(id) as count, (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where is_active=1 AND email=p.to_id) as name, p.to_id as user_id FROM eng_nom_submissions as p where nom_id =3 Group BY to_id"; sql_3 = "SELECT DENSE_RANK() OVER (ORDER BY COUNT(id) DESC) AS rank, count(id) as count, (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where email=p.to_id) as name, p.to_id as user_id FROM eng_nom_submissions as p where nom_id =2 Group BY to_id"; sql_2 = "SELECT DENSE_RANK() OVER (ORDER BY COUNT(id) DESC) AS rank, count(id) as count, (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where is_active=1 AND email=p.to_id) as name, p.to_id as user_id FROM eng_nom_submissions as p where nom_id =1 Group BY to_id"; //Response.Write(sql); //string sql = "Select TOP 10 SUM(p.points) as points, (SELECT DENSE_RANK() OVER (ORDER BY points DESC) AS rank FROM (SELECT CustomerID, COUNT(*) AS TotCnt as rank), (Select CONCAT(u.fname, ' ',u.lname) from eng_users as u where email=p.user_id) as name, p.user_id as user_id from eng_points as p group by p.user_id order by points desc"; SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@d", d); at_1.DataSource = Eng_Data.eng_Datatable(sql, parms); at_1.DataBind(); SqlParameter[] parms2 = new SqlParameter[1]; parms2[0] = new SqlParameter("@d", d); at_2.DataSource = Eng_Data.eng_Datatable(sql_2, parms2); at_2.DataBind(); SqlParameter[] parms3 = new SqlParameter[1]; parms3[0] = new SqlParameter("@d", d); at_3.DataSource = Eng_Data.eng_Datatable(sql_3, parms3); at_3.DataBind(); SqlParameter[] parms4 = new SqlParameter[1]; parms4[0] = new SqlParameter("@d", d); at_4.DataSource = Eng_Data.eng_Datatable(sql_4, parms4); at_4.DataBind(); SqlParameter[] parms5 = new SqlParameter[1]; parms5[0] = new SqlParameter("@d", d); at_5.DataSource = Eng_Data.eng_Datatable(sql_5, parms5); at_5.DataBind(); SqlParameter[] parms6 = new SqlParameter[1]; parms6[0] = new SqlParameter("@d", d); at_6.DataSource = Eng_Data.eng_Datatable(sql_6, parms6); at_6.DataBind(); }
//public static int iteration = 0; protected void Page_Load(object sender, EventArgs e) { string outstring = ""; string template = "<div class=\"stiff-chart-level\" data-level=\"0{0}\"><div class=\"stiff-main-parent\"><ul><li data-parent=\"{1}\"><div class=\"the-chart\"><img src = \"/content/images/sycom/employees/icons/{2}{3}.jpg\" alt=\"\"><p>{2} {3}</p>{4}</div></li></ul></div></div>"; string sql = "Select id, email, fname, lname, title from eng_users where is_active=1 and email='*****@*****.**'"; SqlParameter[] p = new SqlParameter[0]; DataTable d = Eng_Data.eng_Datatable(sql, p); foreach (DataRow dr in d.Rows) { outstring = string.Format(template, 1, dr.ItemArray[0].ToString(), dr.ItemArray[2].ToString(), dr.ItemArray[3].ToString(), dr.ItemArray[4].ToString()); outstring += GetSubordinates(dr.ItemArray[1].ToString(), Convert.ToInt32(dr.ItemArray[0]), 1); } //output.InnerHtml = outstring; cinner.InnerHtml = outstring + cinner.InnerHtml; }
protected void BindNews(string uid) { //string sql = "Select ns.id as id, ns.to_id as to_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.to_id) as toName, ns.from_id as from_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.from_id) as fromName, (Select title from eng_nominations where id=ns.nom_id) as title, DATEADD(hour, -5, ns.time) as time, left(ns.notes, 200) as notes, (Select icon from eng_nominations where id=ns.nom_id) as icon, ns.nom_id as nom_id from eng_nom_submissions as ns where (to_id = @uid OR from_id = @uid) AND MONTH(DATEADD(hour, -5, time)) = MONTH(DATEADD(hour, -5, GETDATE())) AND YEAR(DATEADD(hour, -5, time)) = YEAR(DATEADD(hour, -5, GETDATE())) order by ns.time desc"; string sql = "Select ns.id as id, ns.to_id as to_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.to_id) as toName, ns.from_id as from_id, (Select CONCAT(fname, ' ', lname) from eng_users where email=ns.from_id) as fromName, (Select title from eng_nominations where id=ns.nom_id) as title, DATEADD(hour, -5, ns.time) as time, left(ns.notes, 200) as notes, (Select icon from eng_nominations where id=ns.nom_id) as icon, ns.nom_id as nom_id from eng_nom_submissions as ns where (to_id = @uid) order by ns.time desc"; SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@uid", uid); DataTable dt = Eng_Data.eng_Datatable(sql, parms); lv_events.DataSource = dt; lv_events.DataBind(); if (dt.Rows.Count == 0) { eng_no_nom.Visible = true; eng_no_nom.InnerHtml += "<div class='news_item'>This person has not been nominated or nominated anyone else. Lets get them engaged. Be the first to nominate this person and receive bonus points!</div>"; } }
protected void GetTitle(string nid) { string sql = "Select title, description, icon from eng_nominations where id=@id"; SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@id", nid); DataTable dt = Eng_Data.eng_Datatable(sql, parms); foreach (DataRow dr in dt.Rows) { string title = dr.ItemArray[0].ToString(); string description = dr.ItemArray[1].ToString(); string icon = dr.ItemArray[2].ToString(); string format = "<img style='float:left;margin:-7px 5px;border:1px solid #CCC;' src='{2}' /><h1>{0}</h1><h4>{1}</h4>"; div_title.InnerHtml += string.Format(format, title, description, icon); } }
protected void SubmitQuestion() { string question = mem_question.Text; string user = ""; if (cb_anon.Checked) { user = "******"; } else { user = User.Identity.Name.ToString(); } SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@user", user); parms[1] = new SqlParameter("@question", question); string sql = "Insert into eng_townhall ([user], question) VALUES (@user, @question)"; Eng_Data.eng_Update(sql, parms); Eng_Data.eng_AddPoints(User.Identity.Name.ToString(), 5, "TownHall Question Submission"); mem_question.Text = ""; div_results.InnerHtml += "Thanks for your question!<br />"; }
protected void GetCampaign(string id) { string sql = "Select id, title, description, owner_id, status, keywords from eng_campaigns where id=" + id; DataTable dt = Eng_Data.eng_Datatable(sql, new System.Data.SqlClient.SqlParameter[0]); foreach (DataRow dr in dt.Rows) { //for(int i = 0; i < dr.ItemArray.Count(); i++) //{ // camp_container.InnerHtml +=dr.ItemArray[i].ToString() + "<br />--------------<br />"; //} camp_container.InnerHtml += "<span style='camp_header'>Campaign for " + dr.ItemArray[1].ToString() + "</span>"; camp_container.InnerHtml += "<br /> Created by <i>" + dr.ItemArray[3].ToString() + "</i><br />"; camp_container.InnerHtml += "<div class='campaignContent'><pre>" + dr.ItemArray[2].ToString() + "</pre></div>"; camp_container.InnerHtml += "Status: <i>" + dr.ItemArray[4].ToString() + "</i><br />"; string[] keys = dr.ItemArray[5].ToString().Split(','); foreach (string k in keys) { camp_container.InnerHtml += "<a href=CampaignSearch.aspx?key=" + k + ">" + k + "</a>"; } } GetMembers(id); }
public static string BuildProfile(string id) { string profile = ""; string sql = "Select email, fname, lname, title, hiredate from eng_users where email=@id"; SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@id", id); DataTable dt = Eng_Data.eng_Datatable(sql, parms); foreach (DataRow dr in dt.Rows) { string uid = dr.ItemArray[0].ToString(); string fname = dr.ItemArray[1].ToString(); string lname = dr.ItemArray[2].ToString(); string title = dr.ItemArray[3].ToString(); DateTime hiredate = (DateTime)(Convert.ToDateTime(dr.ItemArray[4])); int svc = YearCalc(hiredate, DateTime.Now); string rc = ""; if (svc > 19) { rc = "style='background: linear-gradient(#F79E05 0%, #8F5408 100%)'"; } else if (svc > 14) { rc = "style='background: linear-gradient(#2989d8 0%, #1e5799 100%)'"; } else if (svc > 9) { rc = "style='background: linear-gradient(#F70505 0%, #8F0808 100%)'"; } else if (svc > 4) { rc = "style='background: linear-gradient(#9BC90D 0%, #79A70A 100%)'"; } else if (svc > 0) { rc = "style='background: linear-gradient(#B6BAC9 0%, #808080 100%)'"; } else if (svc == 0) { rc = "style='visibility:hidden'"; } ; /*Gold - 20 Years background: linear-gradient(#F79E05 0%, #8F5408 100%);*/ /*Blue - 15 Years background: linear-gradient(#2989d8 0%, #1e5799 100%);*/ /*Red - 10 Years background: linear-gradient(#F70505 0%, #8F0808 100%);*/ /*Green - 5 Years background: linear-gradient(#9BC90D 0%, #79A70A 100%);*/ /*Grey - 1 Year background: linear-gradient(#B6BAC9 0%, #808080 100%);*/ string ribbonFormat = "<div class=\"ribbon\"><span {7}>{6}</span></div>"; string m = ""; if (svc > 1) { m = "s"; } string pic = ""; if (System.IO.File.Exists(HttpContext.Current.Server.MapPath("/content/images/sycom/employees/icons/" + fname + lname.Replace("'", "") + ".jpg"))) { pic = fname + lname.Replace("'", ""); } else { pic = "unknown"; } string format = "<div class='profile_box_main' onclick=\"document.location.href='/directory/profile.aspx?id={0}'\">" + ribbonFormat + "<p class=p_image><img src=\"/content/images/sycom/employees/icons/{9}.jpg\" width='45' height='45' /></p><p class=p_name>{1} {2}</p> Points: {4}</div>"; profile += string.Format(format, uid, fname, lname, title, Eng_Data.GetPoints(uid), ribbonFormat, svc + " Year" + m, rc, hiredate.ToLongDateString(), pic); } return(profile); }
protected void BuildProfile(string id) { BindNews(id); string sql = "Select u.email, u.fname, u.lname, u.title, u.hiredate, (select SUM(points) from eng_points where [user_id] = u.email) as TotalPoints from eng_users as u where u.email=@id"; SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@id", id); DataTable dt = Eng_Data.eng_Datatable(sql, parms); foreach (DataRow dr in dt.Rows) { string uid = dr.ItemArray[0].ToString(); string fname = dr.ItemArray[1].ToString(); string lname = dr.ItemArray[2].ToString(); string title = dr.ItemArray[3].ToString(); string Totalpoints = dr.ItemArray[5].ToString(); DateTime hiredate = (DateTime)(Convert.ToDateTime(dr.ItemArray[4])); int svc = Years(hiredate, DateTime.Now); string rc = ""; if (svc > 19) { rc = "style='background: linear-gradient(#F79E05 0%, #8F5408 100%)'"; } else if (svc > 14) { rc = "style='background: linear-gradient(#2989d8 0%, #1e5799 100%)'"; } else if (svc > 9) { rc = "style='background: linear-gradient(#F70505 0%, #8F0808 100%)'"; } else if (svc > 4) { rc = "style='background: linear-gradient(#9BC90D 0%, #79A70A 100%)'"; } else if (svc > 0) { rc = "style='background: linear-gradient(#B6BAC9 0%, #808080 100%)'"; } else if (svc == 0) { rc = "style='visibility:hidden'"; } ; /*Gold - 20 Years background: linear-gradient(#F79E05 0%, #8F5408 100%);*/ /*Blue - 15 Years background: linear-gradient(#2989d8 0%, #1e5799 100%);*/ /*Red - 10 Years background: linear-gradient(#F70505 0%, #8F0808 100%);*/ /*Green - 5 Years background: linear-gradient(#9BC90D 0%, #79A70A 100%);*/ /*Grey - 1 Year background: linear-gradient(#B6BAC9 0%, #808080 100%);*/ string ribbonFormat = "<div class=\"ribbon\"><span {7}>{6}</span></div>"; string m = ""; if (svc > 1) { m = "s"; } string pic = ""; if (System.IO.File.Exists(HttpContext.Current.Server.MapPath("/content/images/sycom/employees/icons/" + fname + lname.Replace("'", "") + ".jpg"))) { pic = fname + lname.Replace("'", ""); } else { pic = "unknown"; } string format = "<div class='profile_box'>" + ribbonFormat + "<p class=p_image><img src=\"/content/images/sycom/employees/icons/{9}.jpg\" width='90' height='90' /></p><p class=p_name>{1} {2}</p><p class=p_title>{3}</p></div><div class='profile_points'>Current Points: {4}<br />Lifetime Points: {10}</div>DOH:{8}"; profile.InnerHtml += string.Format(format, uid, fname, lname, title, Eng_Data.GetPoints(uid), ribbonFormat, svc + " Year" + m, rc, hiredate.ToLongDateString(), pic, Totalpoints); } }