Exemple #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //check login
            int UserId = 0;

            if (Request.Cookies["VC"] != null)
            {
                string VC = Request.Cookies["VC"].Values["VC"];
                Classes.LoginSession ls = new Classes.LoginSession();
                UserId = ls.getUserId(VC);
                if (UserId == 0) //if user not logged in redirect to login
                {
                    Response.Redirect("~/Login/Events/Add");
                }
                else
                {
                    Session["UserId"] = UserId.ToString();
                }
            }
            else
            {
                Response.Redirect("~/Login/Events/Add");
            }

            if (!IsPostBack)
            {
                Classes.Locations l = new Classes.Locations();
                DataTable dtCountries = l.countriesList();

                List<System.Web.UI.WebControls.ListItem> countries = new List<System.Web.UI.WebControls.ListItem>();
                DropDownListCountry.Items.Add(new ListItem("Select Country", "0"));
                for (int i = 0; i < dtCountries.Rows.Count; i++)
                {
                    DropDownListCountry.Items.Add(new ListItem(dtCountries.Rows[i]["CountryName"].ToString(), dtCountries.Rows[i]["CountryId"].ToString()));
                }

                Classes.UserInfo ui = new Classes.UserInfo();
                int locationId = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                if (locationId == 0)
                {
                    DropDownListCountry.SelectedValue = "0";
                }
                else
                {
                    int cityId = locationId;

                    DataTable dtLocation = l.locationInfoOnlyId(locationId);

                    locationCity(Convert.ToInt32(dtLocation.Rows[0]["StateId"].ToString()));
                    locationState(Convert.ToInt32(dtLocation.Rows[0]["CountryId"].ToString()));
                    DropDownListCountry.SelectedValue = dtLocation.Rows[0]["CountryId"].ToString();
                    DropDownListState.SelectedValue = dtLocation.Rows[0]["StateId"].ToString();
                    DropDownListCity.SelectedValue = locationId.ToString();
                }
            }

        }
        protected void Page_Load(object sender, EventArgs e)
        {
            //check login
            int UserId = 0;

            if (Request.Cookies["VC"] != null)
            {
                string VC = Request.Cookies["VC"].Values["VC"];
                Classes.LoginSession ls = new Classes.LoginSession();
                UserId = ls.getUserId(VC);
                if (UserId == 0) //if user not logged in redirect to login
                {
                    Response.Redirect("~/Login/Events/Add");
                }
                else
                {
                    Session["UserId"] = UserId.ToString();
                }
            }
            else
            {
                Response.Redirect("~/Login/Events/Add");
            }

            if (!IsPostBack)
            {
                Classes.Locations l           = new Classes.Locations();
                DataTable         dtCountries = l.countriesList();

                List <System.Web.UI.WebControls.ListItem> countries = new List <System.Web.UI.WebControls.ListItem>();
                DropDownListCountry.Items.Add(new ListItem("Select Country", "0"));
                for (int i = 0; i < dtCountries.Rows.Count; i++)
                {
                    DropDownListCountry.Items.Add(new ListItem(dtCountries.Rows[i]["CountryName"].ToString(), dtCountries.Rows[i]["CountryId"].ToString()));
                }

                Classes.UserInfo ui = new Classes.UserInfo();
                int locationId      = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                if (locationId == 0)
                {
                    DropDownListCountry.SelectedValue = "0";
                }
                else
                {
                    int cityId = locationId;

                    DataTable dtLocation = l.locationInfoOnlyId(locationId);

                    locationCity(Convert.ToInt32(dtLocation.Rows[0]["StateId"].ToString()));
                    locationState(Convert.ToInt32(dtLocation.Rows[0]["CountryId"].ToString()));
                    DropDownListCountry.SelectedValue = dtLocation.Rows[0]["CountryId"].ToString();
                    DropDownListState.SelectedValue   = dtLocation.Rows[0]["StateId"].ToString();
                    DropDownListCity.SelectedValue    = locationId.ToString();
                }
            }
        }
Exemple #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //check login
            int UserId = 0;

            if (Request.Cookies["VC"] != null)
            {
                string VC = Request.Cookies["VC"].Values["VC"];
                Classes.LoginSession ls = new Classes.LoginSession();
                UserId = ls.getUserId(VC);
                if (UserId == 0) //if user not logged in redirect to login
                {
                    Response.Redirect("~/Login/Events/Add");
                }
                else
                {
                    Session["UserId"] = UserId.ToString();
                }
            }
            else
            {
                Response.Redirect("~/Login/Events/Add");
            }

            Classes.UserInfo ui = new Classes.UserInfo();
            int locationId      = ui.locationIdByUserId(UserId);

            Classes.Locations   l       = new Classes.Locations();
            Tuple <int, string> result1 = l.locationUsersCount(locationId);
            int    locationUsersCount   = result1.Item1;
            string locationName         = result1.Item2;
            int    minLocationUsers     = Convert.ToInt32(ConfigurationManager.AppSettings["MinLocationUsers"].ToString());

            Page.Title                          = "Hi!";
            HiddenFieldTitle.Value              = "Hi!";
            HiddenFieldSmiley.Value             = ":)";
            HiddenFieldMessage.Value            = "How are you doing today? Where can I redirect you?!";
            HiddenFieldLinksNumber.Value        = "1";
            HiddenFieldLocationUsersCount.Value = locationUsersCount.ToString();
            HiddenFieldMinLocationUsers.Value   = minLocationUsers.ToString();
            HiddenFieldLocation.Value           = locationName;

            Classes.Done d = new Classes.Done();
            Tuple <string, string, string, string> result = d.doneItem("A", "");

            HiddenFieldLink1Text.Value  = result.Item1;
            HiddenFieldLink1Url.Value   = result.Item2;
            HiddenFieldLink1Image.Value = result.Item3;
            HiddenFieldLink1Color.Value = result.Item4;
        }
Exemple #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //check login
            int UserId = 0;

            if (Request.Cookies["VC"] != null)
            {
                string VC = Request.Cookies["VC"].Values["VC"];
                Classes.LoginSession ls = new Classes.LoginSession();
                UserId = ls.getUserId(VC);
                if (UserId == 0) //if user not logged in redirect to login
                {
                    Response.Redirect("~/Login/Events/Add");
                }
                else
                {
                    Session["UserId"] = UserId.ToString();
                }
            }
            else
            {
                Response.Redirect("~/Login/Events/Add");
            }

            Classes.UserInfo ui = new Classes.UserInfo();
            int locationId = ui.locationIdByUserId(UserId);

            Classes.Locations l = new Classes.Locations();
            Tuple<int, string> result1 = l.locationUsersCount(locationId);
            int locationUsersCount = result1.Item1;
            string locationName = result1.Item2;
            int minLocationUsers = Convert.ToInt32(ConfigurationManager.AppSettings["MinLocationUsers"].ToString());

            Page.Title = "Hi!";
            HiddenFieldTitle.Value = "Hi!";
            HiddenFieldSmiley.Value = ":)";
            HiddenFieldMessage.Value = "How are you doing today? Where can I redirect you?!";
            HiddenFieldLinksNumber.Value = "1";
            HiddenFieldLocationUsersCount.Value = locationUsersCount.ToString();
            HiddenFieldMinLocationUsers.Value = minLocationUsers.ToString();
            HiddenFieldLocation.Value = locationName;

            Classes.Done d = new Classes.Done();
            Tuple<string, string, string, string> result = d.doneItem("A", "");
            HiddenFieldLink1Text.Value = result.Item1;
            HiddenFieldLink1Url.Value = result.Item2;
            HiddenFieldLink1Image.Value = result.Item3;
            HiddenFieldLink1Color.Value = result.Item4;
        }
Exemple #5
0
        protected void feedCity()
        {
            int userId = Convert.ToInt32(Session["UserId"]);
            Classes.UserInfo ui = new Classes.UserInfo();
            int locationId = ui.locationIdByUserId(userId);

            Classes.Feed f = new Classes.Feed();
            DataTable dt = f.eventsCity(locationId);

            if (dt.Rows.Count > 0)
            {
                RepeaterCity.DataSource = dt;
                RepeaterCity.DataBind();
            }
            else
            {
                //LabelNoRecord.Visible = true;
            }
        }
Exemple #6
0
        protected void feedCity()
        {
            int userId = Convert.ToInt32(Session["UserId"]);

            Classes.UserInfo ui = new Classes.UserInfo();
            int locationId      = ui.locationIdByUserId(userId);

            Classes.Feed f  = new Classes.Feed();
            DataTable    dt = f.eventsCity(locationId);

            if (dt.Rows.Count > 0)
            {
                RepeaterCity.DataSource = dt;
                RepeaterCity.DataBind();
            }
            else
            {
                //LabelNoRecord.Visible = true;
            }
        }
Exemple #7
0
        protected void feedCity(int mode, Int64 eventId)
        {
            int userId = Convert.ToInt32(Session["UserId"]);

            Classes.UserInfo ui = new Classes.UserInfo();
            int locationId      = ui.locationIdByUserId(userId);

            //{
            //    HiddenFieldStatus.Value = "0";
            //    HiddenFieldSmiley.Value = ":)";
            //    HiddenFieldMessage.Value = "Unfortunatly there is no event in your city to show now!";
            //    HiddenFieldLinksNumber.Value = "4";

            //    Classes.Done d = new Classes.Done();
            //    Tuple<string, string, string, string> result2 = d.doneItem("A", "");
            //    HiddenFieldLink1Text.Value = result2.Item1;
            //    HiddenFieldLink1Url.Value = result2.Item2;
            //    HiddenFieldLink1Image.Value = result2.Item3;
            //    HiddenFieldLink1Color.Value = result2.Item4;

            //    result2 = d.doneItem("C", "");
            //    HiddenFieldLink2Text.Value = result2.Item1;
            //    HiddenFieldLink2Url.Value = result2.Item2;
            //    HiddenFieldLink2Image.Value = result2.Item3;
            //    HiddenFieldLink2Color.Value = result2.Item4;

            //    result2 = d.doneItem("E", "");
            //    HiddenFieldLink3Text.Value = result2.Item1;
            //    HiddenFieldLink3Url.Value = result2.Item2;
            //    HiddenFieldLink3Image.Value = result2.Item3;
            //    HiddenFieldLink3Color.Value = result2.Item4;

            //    result2 = d.doneItem("F", "");
            //    HiddenFieldLink4Text.Value = result2.Item1;
            //    HiddenFieldLink4Url.Value = result2.Item2;
            //    HiddenFieldLink4Image.Value = result2.Item3;
            //    HiddenFieldLink4Color.Value = result2.Item4;
            //}
        }
Exemple #8
0
        protected void feedCity(int mode, Int64 eventId)
        {
            int userId = Convert.ToInt32(Session["UserId"]);
            Classes.UserInfo ui = new Classes.UserInfo();
            int locationId = ui.locationIdByUserId(userId);

            //{
            //    HiddenFieldStatus.Value = "0";
            //    HiddenFieldSmiley.Value = ":)";
            //    HiddenFieldMessage.Value = "Unfortunatly there is no event in your city to show now!";
            //    HiddenFieldLinksNumber.Value = "4";

            //    Classes.Done d = new Classes.Done();
            //    Tuple<string, string, string, string> result2 = d.doneItem("A", "");
            //    HiddenFieldLink1Text.Value = result2.Item1;
            //    HiddenFieldLink1Url.Value = result2.Item2;
            //    HiddenFieldLink1Image.Value = result2.Item3;
            //    HiddenFieldLink1Color.Value = result2.Item4;

            //    result2 = d.doneItem("C", "");
            //    HiddenFieldLink2Text.Value = result2.Item1;
            //    HiddenFieldLink2Url.Value = result2.Item2;
            //    HiddenFieldLink2Image.Value = result2.Item3;
            //    HiddenFieldLink2Color.Value = result2.Item4;

            //    result2 = d.doneItem("E", "");
            //    HiddenFieldLink3Text.Value = result2.Item1;
            //    HiddenFieldLink3Url.Value = result2.Item2;
            //    HiddenFieldLink3Image.Value = result2.Item3;
            //    HiddenFieldLink3Color.Value = result2.Item4;

            //    result2 = d.doneItem("F", "");
            //    HiddenFieldLink4Text.Value = result2.Item1;
            //    HiddenFieldLink4Url.Value = result2.Item2;
            //    HiddenFieldLink4Image.Value = result2.Item3;
            //    HiddenFieldLink4Color.Value = result2.Item4;
            //}
        }
Exemple #9
0
        protected void getDataLocation()
        {
            hidePanels();
            PanelLocation.Visible = true;

            DataTable dt = new DataTable();
            DataSet ds = new DataSet();
            SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
            SqlDataAdapter sda = new SqlDataAdapter("sp_settingsLocationGet", sqlConn);
            sda.SelectCommand.CommandType = CommandType.StoredProcedure;
            sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]);

            //try
            //{
                sda.Fill(ds);
                dt = ds.Tables[0];
            //}
            //catch (Exception ex)
            //{

            //}
            //finally
            //{
                sqlConn.Close();
                sda.Dispose();
                sqlConn.Dispose();
            //}

            if (dt.Rows.Count == 0)// Profile doesn't exist
            {
                Response.Redirect("~/Error/NoProfileForSettings");
            }
            else
            {
                if (!IsPostBack)
                {
                    Classes.Locations l = new Classes.Locations();
                    DataTable dtCountries = l.countriesList();

                    List<System.Web.UI.WebControls.ListItem> countries = new List<System.Web.UI.WebControls.ListItem>();
                    DropDownListCountry.Items.Add(new ListItem("Select Country", "0"));
                    for (int i = 0; i < dtCountries.Rows.Count; i++)
                    {
                        DropDownListCountry.Items.Add(new ListItem(dtCountries.Rows[i]["CountryName"].ToString(), dtCountries.Rows[i]["CountryCode"].ToString()));
                    }

                    Classes.UserInfo ui = new Classes.UserInfo();
                    int locationId = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                    if (locationId == 0)
                    {
                        DropDownListCountry.SelectedValue = "0";
                    }
                    else
                    {
                        string countryCode = l.locationInfoOnlyId(locationId);

                        locationCity(countryCode);
                        DropDownListCountry.SelectedValue = countryCode;
                        DropDownListCity.SelectedValue = locationId.ToString();
                    }

                    DataTable dtLocation = l.getLocationInfoByCityId(Convert.ToInt32(dt.Rows[0]["LocationId"].ToString()));
                    if (dtLocation.Rows.Count == 0)
                    {
                        LabelLocation.Text = "Not Available!";
                    }
                    else
                    {
                        LabelLocation.Text = dtLocation.Rows[0]["CityName"].ToString();
                    }
                }

                if (dt.Rows[0]["LocationId"].ToString() == "0")
                {
                    DropDownListCountry.SelectedValue = "0";
                }
                else
                {
                    int cityId = Convert.ToInt32(dt.Rows[0]["LocationId"].ToString());
                    DataTable dtLocation = new DataTable();
                    DataSet dsLocation = new DataSet();
                    SqlConnection sqlConnLocation = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
                    SqlDataAdapter sdaLocation = new SqlDataAdapter("sp_locationInfoOnlyId", sqlConnLocation);
                    sdaLocation.SelectCommand.CommandType = CommandType.StoredProcedure;
                    sdaLocation.SelectCommand.Parameters.Add("@CityId", SqlDbType.Int).Value = cityId;

                    //try
                    //{
                        sdaLocation.Fill(dsLocation);
                        dtLocation = dsLocation.Tables[0];
                    //}
                    //catch (Exception ex)
                    //{

                    //}
                    //finally
                    //{
                        sqlConnLocation.Close();
                        sdaLocation.Dispose();
                        sqlConnLocation.Dispose();
                    //}

                    locationCity(dtLocation.Rows[0]["CountryCode"].ToString());
                    DropDownListCountry.SelectedValue = dtLocation.Rows[0]["CountryCode"].ToString();
                    DropDownListCity.SelectedValue = dt.Rows[0]["LocationId"].ToString();
                }

            }
        }
Exemple #10
0
        protected void getDataLocation()
        {
            hidePanels();
            PanelLocation.Visible = true;

            DataTable      dt      = new DataTable();
            DataSet        ds      = new DataSet();
            SqlConnection  sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
            SqlDataAdapter sda     = new SqlDataAdapter("sp_settingsLocationGet", sqlConn);

            sda.SelectCommand.CommandType = CommandType.StoredProcedure;
            sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]);

            //try
            //{
            sda.Fill(ds);
            dt = ds.Tables[0];
            //}
            //catch (Exception ex)
            //{

            //}
            //finally
            //{
            sqlConn.Close();
            sda.Dispose();
            sqlConn.Dispose();
            //}

            if (dt.Rows.Count == 0)// Profile doesn't exist
            {
                Response.Redirect("~/Error/NoProfileForSettings");
            }
            else
            {
                if (!IsPostBack)
                {
                    Classes.Locations l           = new Classes.Locations();
                    DataTable         dtCountries = l.countriesList();

                    List <System.Web.UI.WebControls.ListItem> countries = new List <System.Web.UI.WebControls.ListItem>();
                    DropDownListCountry.Items.Add(new ListItem("Select Country", "0"));
                    for (int i = 0; i < dtCountries.Rows.Count; i++)
                    {
                        DropDownListCountry.Items.Add(new ListItem(dtCountries.Rows[i]["CountryName"].ToString(), dtCountries.Rows[i]["CountryCode"].ToString()));
                    }

                    Classes.UserInfo ui = new Classes.UserInfo();
                    int locationId      = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                    if (locationId == 0)
                    {
                        DropDownListCountry.SelectedValue = "0";
                    }
                    else
                    {
                        string countryCode = l.locationInfoOnlyId(locationId);

                        locationCity(countryCode);
                        DropDownListCountry.SelectedValue = countryCode;
                        DropDownListCity.SelectedValue    = locationId.ToString();
                    }

                    DataTable dtLocation = l.getLocationInfoByCityId(Convert.ToInt32(dt.Rows[0]["LocationId"].ToString()));
                    if (dtLocation.Rows.Count == 0)
                    {
                        LabelLocation.Text = "Not Available!";
                    }
                    else
                    {
                        LabelLocation.Text = dtLocation.Rows[0]["CityName"].ToString();
                    }
                }

                if (dt.Rows[0]["LocationId"].ToString() == "0")
                {
                    DropDownListCountry.SelectedValue = "0";
                }
                else
                {
                    int            cityId          = Convert.ToInt32(dt.Rows[0]["LocationId"].ToString());
                    DataTable      dtLocation      = new DataTable();
                    DataSet        dsLocation      = new DataSet();
                    SqlConnection  sqlConnLocation = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
                    SqlDataAdapter sdaLocation     = new SqlDataAdapter("sp_locationInfoOnlyId", sqlConnLocation);
                    sdaLocation.SelectCommand.CommandType = CommandType.StoredProcedure;
                    sdaLocation.SelectCommand.Parameters.Add("@CityId", SqlDbType.Int).Value = cityId;

                    //try
                    //{
                    sdaLocation.Fill(dsLocation);
                    dtLocation = dsLocation.Tables[0];
                    //}
                    //catch (Exception ex)
                    //{

                    //}
                    //finally
                    //{
                    sqlConnLocation.Close();
                    sdaLocation.Dispose();
                    sqlConnLocation.Dispose();
                    //}

                    locationCity(dtLocation.Rows[0]["CountryCode"].ToString());
                    DropDownListCountry.SelectedValue = dtLocation.Rows[0]["CountryCode"].ToString();
                    DropDownListCity.SelectedValue    = dt.Rows[0]["LocationId"].ToString();
                }
            }
        }
Exemple #11
0
        protected void ButtonSearch_Click(object sender, EventArgs e)
        {
            switch (HiddenFieldSearchType.Value)
            {
            case "1":     //username
            {
                Classes.Search s  = new Classes.Search();
                DataTable      dt = s.searchUsername(TextBoxUsername.Text);

                if (dt.Rows.Count == 0)
                {
                    PanelUsername.Visible         = false;
                    PanelResult.Visible           = false;
                    HiddenFieldSearchStatus.Value = "0";
                }
                else
                {
                    RepeaterUsername.DataSource = dt;
                    RepeaterUsername.DataBind();

                    PanelUsername.Visible         = true;
                    PanelResult.Visible           = false;
                    HiddenFieldSearchStatus.Value = "1";
                }
                break;
            }

            case "2":     //hashtag
            {
                Classes.UserInfo ui = new Classes.UserInfo();
                int locationId      = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                Classes.Search s  = new Classes.Search();
                DataTable      dt = s.searchHashtag(TextBoxTag.Text, locationId);

                if (dt.Rows.Count == 0)
                {
                    PanelResult.Visible           = false;
                    HiddenFieldSearchStatus.Value = "0";
                }
                else
                {
                    RepeaterResult.DataSource = dt;
                    RepeaterResult.DataBind();

                    PanelUsername.Visible         = false;
                    PanelResult.Visible           = true;
                    HiddenFieldSearchStatus.Value = "1";
                }
                break;
            }

            case "3":     //type
            {
                Classes.UserInfo ui = new Classes.UserInfo();
                int locationId      = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                Classes.Search s  = new Classes.Search();
                DataTable      dt = s.searchType(Convert.ToInt32(HiddenFieldTypeId.Value), locationId);

                if (dt.Rows.Count == 0)
                {
                    PanelResult.Visible           = false;
                    HiddenFieldSearchStatus.Value = "0";
                }
                else
                {
                    RepeaterResult.DataSource = dt;
                    RepeaterResult.DataBind();

                    PanelUsername.Visible         = false;
                    PanelResult.Visible           = true;
                    HiddenFieldSearchStatus.Value = "1";
                }
                break;
            }
            }
        }
Exemple #12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //check login
            int UserId = 0;

            if (Session["UserId"] != null)
            {
                UserId = Convert.ToInt32(Session["UserId"]);
            }
            else
            {
                if (Request.Cookies["VC"] != null)
                {
                    string VC = Request.Cookies["VC"].Values["VC"];
                    Classes.LoginSession ls = new Classes.LoginSession();
                    UserId = ls.getUserId(VC);
                    if (UserId == 0) //if user not logged in redirect to login
                    {
                        Response.Redirect("~/Login/Search");
                    }
                    else
                    {
                        Session["UserId"] = UserId.ToString();
                    }
                }
                else
                {
                    Response.Redirect("~/Login/Search");
                }
            }


            if (!IsPostBack)
            {
                Classes.UserInfo ui = new Classes.UserInfo();
                LabelLocation.Text = ui.getUserLocationInfoByUserId(UserId);

                string keyword = "";

                try
                {
                    keyword = Page.RouteData.Values["Keyword"].ToString();
                }
                catch
                {
                }
                finally
                {
                }

                if (keyword.Length > 0)
                {
                    int locationId = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                    Classes.Search s  = new Classes.Search();
                    DataTable      dt = s.searchHashtag(keyword, locationId);
                    TextBoxTag.Text             = keyword;
                    HiddenFieldSearchType.Value = "2";

                    if (dt.Rows.Count == 0)
                    {
                        PanelResult.Visible           = false;
                        HiddenFieldSearchStatus.Value = "0";
                    }
                    else
                    {
                        RepeaterResult.DataSource = dt;
                        RepeaterResult.DataBind();

                        PanelUsername.Visible         = false;
                        PanelResult.Visible           = true;
                        HiddenFieldSearchStatus.Value = "1";
                    }
                }
            }
        }
Exemple #13
0
        protected void ButtonSearch_Click(object sender, EventArgs e)
        {
            switch (HiddenFieldSearchType.Value)
            {
                case "1": //username
                    {
                        Classes.Search s = new Classes.Search();
                        DataTable dt = s.searchUsername(TextBoxUsername.Text);

                        if (dt.Rows.Count == 0)
                        {
                            PanelUsername.Visible = false;
                            PanelResult.Visible = false;
                            HiddenFieldSearchStatus.Value = "0";
                        }
                        else
                        {
                            RepeaterUsername.DataSource = dt;
                            RepeaterUsername.DataBind();

                            PanelUsername.Visible = true;
                            PanelResult.Visible = false;
                            HiddenFieldSearchStatus.Value = "1";
                        }
                        break;
                    }
                case "2": //hashtag
                    {
                        Classes.UserInfo ui = new Classes.UserInfo();
                        int locationId = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                        Classes.Search s = new Classes.Search();
                        DataTable dt = s.searchHashtag(TextBoxTag.Text, locationId);

                        if (dt.Rows.Count == 0)
                        {
                            PanelResult.Visible = false;
                            HiddenFieldSearchStatus.Value = "0";
                        }
                        else
                        {
                            RepeaterResult.DataSource = dt;
                            RepeaterResult.DataBind();

                            PanelUsername.Visible = false;
                            PanelResult.Visible = true;
                            HiddenFieldSearchStatus.Value = "1";
                        }
                        break;
                    }
                case "3": //type
                    {
                        Classes.UserInfo ui = new Classes.UserInfo();
                        int locationId = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                        Classes.Search s = new Classes.Search();
                        DataTable dt = s.searchType(Convert.ToInt32(HiddenFieldTypeId.Value), locationId);

                        if (dt.Rows.Count == 0)
                        {
                            PanelResult.Visible = false;
                            HiddenFieldSearchStatus.Value = "0";
                        }
                        else
                        {
                            RepeaterResult.DataSource = dt;
                            RepeaterResult.DataBind();

                            PanelUsername.Visible = false;
                            PanelResult.Visible = true;
                            HiddenFieldSearchStatus.Value = "1";
                        }
                        break;
                    }
            }
        }
Exemple #14
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //check login
            int UserId = 0;
            if (Session["UserId"] != null)
            {
                UserId = Convert.ToInt32(Session["UserId"]);
            }
            else
            {
                if (Request.Cookies["VC"] != null)
                {
                    string VC = Request.Cookies["VC"].Values["VC"];
                    Classes.LoginSession ls = new Classes.LoginSession();
                    UserId = ls.getUserId(VC);
                    if (UserId == 0) //if user not logged in redirect to login
                    {
                        Response.Redirect("~/Login/Search");
                    }
                    else
                    {
                        Session["UserId"] = UserId.ToString();
                    }
                }
                else
                {
                    Response.Redirect("~/Login/Search");
                }
            }


            if (!IsPostBack)
            {
                Classes.UserInfo ui = new Classes.UserInfo();
                LabelLocation.Text = ui.getUserLocationInfoByUserId(UserId);

                string keyword = "";

                try
                {
                    keyword = Page.RouteData.Values["Keyword"].ToString();
                }
                catch
                {

                }
                finally
                {
                   
                }

                if (keyword.Length > 0)
                {
                    int locationId = ui.locationIdByUserId(Convert.ToInt32(Session["UserId"]));

                    Classes.Search s = new Classes.Search();
                    DataTable dt = s.searchHashtag(keyword, locationId);
                    TextBoxTag.Text = keyword;
                    HiddenFieldSearchType.Value = "2";

                    if (dt.Rows.Count == 0)
                    {
                        PanelResult.Visible = false;
                        HiddenFieldSearchStatus.Value = "0";
                    }
                    else
                    {
                        RepeaterResult.DataSource = dt;
                        RepeaterResult.DataBind();

                        PanelUsername.Visible = false;
                        PanelResult.Visible = true;
                        HiddenFieldSearchStatus.Value = "1";
                    }
                }
            }
        }