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 { }
        }