Пример #1
0
        static public List <MarketEntity> suitablePlayers(List <MarketEntity> all, MarketEntity find)
        {
            List <MarketEntity> isSuitable = new List <MarketEntity>();

            foreach (var entity in all)
            {
                if (find.MarketValue >= entity.MarketValue && find.Position == entity.Position)
                {
                    isSuitable.Add(entity);
                }
            }

            return(isSuitable);
        }
Пример #2
0
        public static void insert(MarketEntity newPlayer)
        {
            string sqlExpression   = "INSERT INTO Players VALUES (@name, @position, @age, @marketValue, @nation, @club, @salary)";
            List <SqlParameter> sp = new List <SqlParameter>()
            {
                new SqlParameter()
                {
                    ParameterName = "@name", SqlDbType = SqlDbType.NVarChar, Value = newPlayer.Name
                },
                new SqlParameter()
                {
                    ParameterName = "@position", SqlDbType = SqlDbType.NVarChar, Value = newPlayer.Position
                },
                new SqlParameter()
                {
                    ParameterName = "@age", SqlDbType = SqlDbType.Int, Value = newPlayer.Age
                },
                new SqlParameter()
                {
                    ParameterName = "@marketValue", SqlDbType = SqlDbType.Money, Value = newPlayer.MarketValue
                },
                new SqlParameter()
                {
                    ParameterName = "@nation", SqlDbType = SqlDbType.NVarChar, Value = newPlayer.Nation
                },
                new SqlParameter()
                {
                    ParameterName = "@club", SqlDbType = SqlDbType.NVarChar, Value = newPlayer.Club
                },
                new SqlParameter()
                {
                    ParameterName = "@salary", SqlDbType = SqlDbType.Money, Value = newPlayer.Salary
                }
            };

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand command = new SqlCommand(sqlExpression, connection);
                if (sp.Count > 0)
                {
                    foreach (SqlParameter param in sp)
                    {
                        command.Parameters.Add(param);
                    }
                }
                command.ExecuteNonQuery();
            }
        }
Пример #3
0
        public void addPlayer(object sender, EventArgs args)
        {
            inputValidation();

            MarketEntity newPlayer = new MarketEntity()
            {
                Name        = name.Text,
                Position    = position.Text ?? " ",
                Age         = int.Parse(age.Text),
                MarketValue = decimal.Parse(marketValue.Text.Replace('.', ',')),
                Nation      = nation.Text ?? " ",
                Club        = club.Text ?? " ",
                Salary      = decimal.Parse(salary.Text.Replace('.', ','))
            };

            Database.insert(newPlayer);
        }
Пример #4
0
        public void sendData(object sender, EventArgs args)
        {
            MarketEntity find = new MarketEntity();

            inputValidation();
            find.Position    = position.Text;
            find.MarketValue = Decimal.Parse(budget.Text.Replace('.', ','));

            List <MarketEntity> all        = Database.getDatabase();
            List <MarketEntity> isSuitable = Market.suitablePlayers(all, find);

            Session["list"] = isSuitable;

            if (isSuitable.Any())
            {
                Response.Redirect("Result.aspx");
            }
            else
            {
                Response.Redirect("Error.aspx");
            }
        }