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(); } } }
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; }
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; }
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; } }
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; } }
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; //} }
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; //} }
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(); } } }
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(); } } }
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; } } }
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"; } } } }
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; } } }
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"; } } } }