public static string H(PEIMS d) { if (Util.UserID == 0) { throw new Exception("SessionExpired"); } JObject o = new JObject(); o["view"] = Util.GetData(String.Format("select top 1 * from people where id = {0} and class>0", d.sid[0]), false); return(o.ToString()); }
public static string H(PEIMS d) { JObject o = new JObject(); #region test studnets if (d.sr == "*") { } if (d.sr == "profile") { o["gradDate"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select GraduationDate from Graduates where id= {0}", d.sid[0]))); o["email"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select email from Graduates where id= {0}", d.sid[0]))); o["homePhone"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select HomePhone from Graduates where id= {0}", d.sid[0]))); o["gradDate"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select GraduationDate from Graduates where id= {0}", d.sid[0]))); o["birthDate"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select BirthDate from Graduates where id= {0}", d.sid[0]))); o["gender"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select Gender from Graduates where id= {0}", d.sid[0]))); o["race"] = JObject.Parse(Util.SelectJSON(String.Format(@"Select Race from Graduates where id= {0}", d.sid[0]))); int dec = Convert.ToInt32(d.sid[0]) % 100000; string url = Util.GetData(@"SELECT (SELECT concat('https://',Domain,'/database/photo.asp?pid=') FROM Campuses WHERE CampusID=People.Campus) DomainName FROM People WHERE People.ID=" + d.sid[0], "") + Util.EncPhoto(dec.ToString()); o["url"] = url; } #endregion #region KS if (d.sr == "ks") { //o[d.sr] = "test"; HttpContext.Current.Session.Abandon(); HttpContext.Current.Session.Clear(); } #endregion return(o.ToString()); }