//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;
}
}
