protected void Submit_Click(object sender, EventArgs e) { List <PastTeams> pastteams = new List <PastTeams>(); String playerID = TeamsConnection.transferedPlayerId(ddlPlayers.SelectedValue, ddlTeams.SelectedValue); String newTeam = ddlTeams2.SelectedValue; String formerTeam = ddlTeams.SelectedValue; String lb = loanedBy.Text; using (TransactionScope tran = new TransactionScope()) { if (ptlabel.Visible || PastTeamsFlag2.Checked) { int psts = Convert.ToInt16(PastTeamsNumber.Text); if (psts > 0) { bool fl = false; String team = null; String country = null; foreach (TextBox t in ts) { if (!fl) { team = GetValue(t.ID); fl = true; } else { country = GetValue(t.ID); pastteams.Add(new PastTeams(playerID, team, country)); fl = false; } } TeamsConnection.addPastTeamsOfNewPlayer(pastteams); } } if (!TeamsConnection.isPastTeam(playerID, formerTeam) && !PastTeamsFlag.Checked && !formerTeam.Equals("Εκτός Βάσης")) { pastteams.Clear(); pastteams.Add(new PastTeams(playerID, formerTeam, "Ελλάδα")); TeamsConnection.addPastTeamsOfNewPlayer(pastteams); } TeamsConnection.transferPlayerToTeam(playerID, newTeam, lb); tran.Complete(); } }