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"); }