public void Update(AbstractConnection connection, AbstractTransaction transaction, UPrintDataSet dataSet)
{
adapter = new NpgsqlDataAdapter();
adapter.SelectCommand = new NpgsqlCommand(selection, connection.GetConnection(), transaction.GetTransaction());
adapter.Fill(dataSet, "person");
adapter.InsertCommand = new NpgsqlCommand(insertion, connection.GetConnection(), transaction.GetTransaction());
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "login", ParameterName = "@login"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "password", ParameterName = "@password"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "name", ParameterName = "@name"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "type", ParameterName = "@type"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "active", ParameterName = "@active"
});
adapter.UpdateCommand = new NpgsqlCommand(updation, connection.GetConnection(), transaction.GetTransaction());
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "login", ParameterName = "@login"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "password", ParameterName = "@password"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "name", ParameterName = "@name"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "type", ParameterName = "@type"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "active", ParameterName = "@active"
});
adapter.DeleteCommand = new NpgsqlCommand(deletion, connection.GetConnection(), transaction.GetTransaction());
adapter.DeleteCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
NpgsqlCommandBuilder commandBuilder = new NpgsqlCommandBuilder(adapter);
adapter.Update(dataSet, "person");
}
public void Update(AbstractConnection connection, AbstractTransaction transaction, UPrintDataSet dataSet)
{
adapter = new NpgsqlDataAdapter();
adapter.SelectCommand = new NpgsqlCommand(selection, connection.GetConnection(), transaction.GetTransaction());
adapter.Fill(dataSet, "task");
adapter.InsertCommand = new NpgsqlCommand(insertion, connection.GetConnection(), transaction.GetTransaction());
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "name", ParameterName = "@name"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "person", ParameterName = "@person"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "job", ParameterName = "@job"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "date_add", ParameterName = "@date_add"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "time_start", ParameterName = "@time_start"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "time_end", ParameterName = "@time_end"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "status", ParameterName = "@status"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "printer", ParameterName = "@printer"
});
adapter.UpdateCommand = new NpgsqlCommand(updation, connection.GetConnection(), transaction.GetTransaction());
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "name", ParameterName = "@name"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "person", ParameterName = "@person"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "job", ParameterName = "@job"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "date_add", ParameterName = "@date_add"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "time_start", ParameterName = "@time_start"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "time_end", ParameterName = "@time_end"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "status", ParameterName = "@status"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "printer", ParameterName = "@printer"
});
adapter.DeleteCommand = new NpgsqlCommand(deletion, connection.GetConnection(), transaction.GetTransaction());
adapter.DeleteCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
NpgsqlCommandBuilder commandBuilder = new NpgsqlCommandBuilder(adapter);
adapter.Update(dataSet, "task");
}
//private static NLog.Logger logger = NLog.LogManager.GetCurrentClassLogger();
public void Read(AbstractConnection connection, AbstractTransaction transaction, UPrintDataSet dataSet)
{
adapter = new NpgsqlDataAdapter();
adapter.SelectCommand = new NpgsqlCommand(selection, connection.GetConnection(), transaction.GetTransaction());
adapter.Fill(dataSet, "person");
}
public void Update(AbstractConnection connection, AbstractTransaction transaction, UPrintDataSet dataSet)
{
adapter = new NpgsqlDataAdapter();
//adapter.SelectCommand = new NpgsqlCommand(selection, connection.GetConnection(), transaction.GetTransaction());
//adapter.Fill(dataSet, "job");
adapter.InsertCommand = new NpgsqlCommand(insertion, connection.GetConnection(), transaction.GetTransaction());
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "name", ParameterName = "@name"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "date_add", ParameterName = "@date_add"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "description", ParameterName = "@description"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "person", ParameterName = "@person"
});
adapter.InsertCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "model", ParameterName = "@model"
});
adapter.UpdateCommand = new NpgsqlCommand(updation, connection.GetConnection(), transaction.GetTransaction());
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "name", ParameterName = "@name"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "date_add", ParameterName = "@date_add"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "description", ParameterName = "@description"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "person", ParameterName = "@person"
});
adapter.UpdateCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "model", ParameterName = "@model"
});
adapter.DeleteCommand = new NpgsqlCommand(deletion, connection.GetConnection(), transaction.GetTransaction());
adapter.DeleteCommand.Parameters.Add(new NpgsqlParameter()
{
SourceColumn = "id", ParameterName = "@id"
});
NpgsqlCommandBuilder commandBuilder = new NpgsqlCommandBuilder(adapter);
adapter.Update(dataSet, "job");
}