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