protected void Page_Load(object sender, EventArgs e) { sLayoutParam = "<GetWork TSID=\"" + Request["ID"] + "\" NonWork=\"" + Request["nonwork"] + "\" OtherWork=\"" + Request["otherwork"] + "\"/>"; sLayoutParamShort = "<GetWork TSID=\"" + Request["ID"] + "\" NonWork=\"" + Request["nonwork"] + "\" OtherWork=\"" + Request["otherwork"] + "\""; sLayoutParam = System.Web.HttpUtility.HtmlEncode(System.Web.HttpUtility.HtmlEncode(sLayoutParam)); sLayoutParamShort = System.Web.HttpUtility.HtmlEncode(sLayoutParamShort); TSUID = Request["ID"]; try { if (Request["nonwork"] == "true") { NonWork = "true"; } } catch { } try { if (Request["otherwork"] == "true") { OtherWork = "true"; } } catch { } EPMLiveCore.API.ViewManager views = null; if (NonWork == "true") { views = TimesheetAPI.GetNonWorkViews(Web); } else { views = TimesheetAPI.GetWorkViews(Web); } Views = views.ToJSON(); int counter = 0; foreach (KeyValuePair <string, Dictionary <string, string> > key in views.Views) { try { if (key.Value["Default"].ToLower() == "true") { CurrentView = key.Key; CurrentViewId = "V" + counter; } } catch { } counter++; } siteurl = SPContext.Current.Web.Url; try { SPList lstMyWork = Web.Site.RootWeb.Lists.TryGetList("My Work"); SortedList sl = new SortedList(); if (lstMyWork != null) { foreach (SPField field in lstMyWork.Fields) { if (field.Reorderable) { sl.Add(field.Title, field.InternalName); } } } foreach (DictionaryEntry de in sl) { var li = new System.Web.UI.WebControls.ListItem(de.Key.ToString(), de.Value.ToString()); if (de.Value.ToString() == "Title") { li.Selected = true; } ddlField.Items.Add(li); } } catch { } //SPSecurity.RunWithElevatedPrivileges(delegate() //{ // SqlConnection cn = new SqlConnection(EPMLiveCore.CoreFunctions.getConnectionString(Web.Site.WebApplication.Id)); // cn.Open(); // SqlCommand cmd = new SqlCommand("spTSGetTimesheet", cn); // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@tsuid", TSUID); // DataSet ds = new DataSet(); // SqlDataAdapter da = new SqlDataAdapter(cmd); // da.Fill(ds); // foreach(DataRow dr in ds.Tables[2].Rows) // { // CurItems += ",\"" + dr["LIST_UID"].ToString() + "." + dr["ITEM_ID"].ToString() + "\""; // } // cn.Close(); //}); ////CurItems = "[" + CurItems.Trim(',') + "]"; try { AddJsHooks(); } catch { } }