Exemplo n.º 1
0
        public void Save(Employee e, FixedPayCalculator c)
        {
            var cmd = _connection.CreateCommand();

            cmd.CommandType = CommandType.Text;
            cmd.CommandText =
                " UPDATE Employees SET" +
                " PayCalculatorType = @PayCalculatorType," +
                " MonthlySalary = @MonthlySalary" +
                " WHERE Id = @Id;";
            cmd.Parameters.Add(new SqlParameter("PayCalculatorType", c.GetType().Name));
            cmd.Parameters.Add(new SqlParameter("MonthlySalary", c.MonthlySalary));
            cmd.Parameters.Add(new SqlParameter("Id", e.Id));

            cmd.ExecuteNonQuery();
        }