//metoda do zaznaczenia elementów z bazy danych usera w liscie rozwijanej (sport) protected void SelectCheckBox() { List <string> sporty = new List <string>(); string userid = Session["userid"].ToString(); sporty = Usr.GetSporty(userid); if (sporty.Count > 0) { CheckBoxList checkedListBox1 = (CheckBoxList)pnlCustomers.FindControl("cblCustomerList"); foreach (ListItem li in checkedListBox1.Items) { if (sporty.Contains(li.Text)) { li.Selected = true; } } } if (sporty.Count == 1) { divDDL.InnerText = "1 element"; } else if (sporty.Count < 5) { divDDL.InnerText = sporty.Count + " elementy"; } else { divDDL.InnerText = sporty.Count + " elementów"; } }
//metoda updajtująca tabelę User_Sport protected void Update_User_Sport_Table(object sender, EventArgs e) { System.Threading.Thread.Sleep(2000); string userid = Session["userid"].ToString(); int selectedSportsNumber = 0; List <string> sporty = Usr.GetSporty(userid); CheckBoxList checkedListBox1 = (CheckBoxList)pnlCustomers.FindControl("cblCustomerList"); foreach (ListItem li in checkedListBox1.Items) { if (li.Selected && !sporty.Contains(li.Text)) { try { Usr.ExecuteCommandInsert(li.Value, userid); selectedSportsNumber++; } catch (Exception ex) { HttpContext.Current.Trace.Write(ex.Message); } } else if (!li.Selected && sporty.Contains(li.Text)) { try { Usr.ExecuteCommandDelete(li.Value, userid); } catch (Exception ex) { HttpContext.Current.Trace.Write(ex.Message); } } else if (li.Selected && sporty.Contains(li.Text)) { selectedSportsNumber++; } } if (selectedSportsNumber == 1) { divDDL.InnerText = "1 element"; } else if (selectedSportsNumber < 5 && selectedSportsNumber > 0) { divDDL.InnerText = selectedSportsNumber + " elementy"; } else { divDDL.InnerText = selectedSportsNumber + " elementów"; } }
protected void SelectSporty() { string userid = Request.QueryString["userid"]; List <string> sporty = Usr.GetSporty(userid); Label sportyUsera = (Label)FormView1.FindControl("Sporty"); if (sporty != null) { sportyUsera.Text = string.Join(", ", sporty); } else { sportyUsera.Visible = false; } }