PushData() public method

public PushData ( SqlCommand command ) : void
command System.Data.SqlClient.SqlCommand
return void
DatabaseProvider Class Documentation
Exemplo n.º 1
0
        public void Update(Analysis analysis)
        {
            const string query   = "UPDATE Analysis SET Analysis= @Analysis WHERE AnalysisId = @AnalysisId";
            var          command = new SqlCommand(query);

            command.Parameters.Add("@@Analysis", SqlDbType.NText);
            command.Parameters["@@Analysis"].Value = new JsonFormatter().ToJson(analysis);
            command.Parameters.AddWithValue("@AnalysisId", analysis.Id);

            _databaseProvider.PushData(command);
        }
Exemplo n.º 2
0
        public void Remove(Template template)
        {
            new AnalysisProvider(_databaseProvider).Remove(template);

            const string query   = "DELETE FROM Template WHERE Name=@Name";
            var          command = new SqlCommand(query);

            command.Parameters.Add("@Name", SqlDbType.NVarChar);
            command.Parameters["@Name"].Value = template.Name;

            _databaseProvider.PushData(command);
        }
Exemplo n.º 3
0
        public void Update(Person person)
        {
            const string query = "UPDATE Persons SET FirstName = @FirstName, LastName=@LastName, MiddleName=@MiddleName, " +
                                 "BirthDate=@BirthDate WHERE PersonId=@PersonId";

            var command = new SqlCommand(query);

            AddMainParameters(command, person);
            command.Parameters["@PersonId"].Value = person.Id;

            _databaseProvider.PushData(command);
        }