private void buttonSaveChange_Click(object sender, EventArgs e)
{
//departmentDataTable.AcceptChanges();
//dataAdapter.Update((DataTable)bindingSourceDepartment.DataSource);
//sqlQuery = "update department(address, phone, e_mail) set values (" + dataGridDepartment.CurrentCell.Value + ", " + dataGridDepartment.CurrentCell.Value + ", " + dataGridDepartment.CurrentCell.Value + ") where " + dataGridDepartment.CurrentCell.RowIndex + " = id_department";
//DBAction.updateDataTable(ref dataAdapterDepartment, sqlQuery);
//dataAdapter.UpdateCommamd((DataTable)bindingSourceDepartment.DataSource);
departmentDataAdapter = new NpgsqlDataAdapter();
#region parameteters.add
deleteCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_department";
insertCommand.Parameters.Add("@Address", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "address";
insertCommand.Parameters.Add("@Phone", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "phone";
insertCommand.Parameters.Add("@Email", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "e_mail";
updateCommand.Parameters.Add("@Address", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "address";
updateCommand.Parameters.Add("@Phone", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "phone";
updateCommand.Parameters.Add("@Email", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "e_mail";
updateCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_department";
#endregion
departmentDataAdapter.UpdateCommand = updateCommand;
departmentDataAdapter.DeleteCommand = deleteCommand;
departmentDataAdapter.InsertCommand = insertCommand;
DBAction.updateDataTable(departmentDataAdapter, table);
getTableDepartment();
}
public void dataAdapterCommand()
{
bookDataAdapter = new NpgsqlDataAdapter();
#region parameteters.add
deleteCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_library_cipher";
insertCommand.Parameters.Add("@Author", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "author";
insertCommand.Parameters.Add("@Name", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "name_book";
insertCommand.Parameters.Add("@Year", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "year_book";
insertCommand.Parameters.Add("@Pages", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "number_of_pages";
insertCommand.Parameters.Add("@Copies", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "number_of_copies";
insertCommand.Parameters.Add("@Department", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_department";
updateCommand.Parameters.Add("@Author", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "author";
updateCommand.Parameters.Add("@Name", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "name_book";
updateCommand.Parameters.Add("@Year", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "year_book";
updateCommand.Parameters.Add("@Pages", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "number_of_pages";
updateCommand.Parameters.Add("@Copies", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "number_of_copies";
updateCommand.Parameters.Add("@Department", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_department";
updateCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_library_cipher";
#endregion
bookDataAdapter.UpdateCommand = updateCommand;
bookDataAdapter.DeleteCommand = deleteCommand;
bookDataAdapter.InsertCommand = insertCommand;
DBAction.updateDataTable(bookDataAdapter, table);
getTableBook();
}
private void buttonSaveChange_Click(object sender, EventArgs e)
{
readersDataAdapter = new NpgsqlDataAdapter();
#region parameteters.add
deleteCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_library_kard";
insertCommand.Parameters.Add("@NameReader", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "name_reader";
insertCommand.Parameters.Add("@Address", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "home_address";
insertCommand.Parameters.Add("@Phone", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "phone";
insertCommand.Parameters.Add("@Email", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "e_mail";
updateCommand.Parameters.Add("@NameReader", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "name_reader";
updateCommand.Parameters.Add("@Address", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "home_address";
updateCommand.Parameters.Add("@Phone", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "phone";
updateCommand.Parameters.Add("@Email", NpgsqlTypes.NpgsqlDbType.Varchar).SourceColumn = "e_mail";
updateCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_library_kard";
#endregion
readersDataAdapter.UpdateCommand = updateCommand;
readersDataAdapter.DeleteCommand = deleteCommand;
readersDataAdapter.InsertCommand = insertCommand;
DBAction.updateDataTable(readersDataAdapter, table);
getTableReaders();
}
public void dataAdapterCommand()
{
#region parameteters.add
deleteCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_booking";
insertCommand.Parameters.Add("@LibraryCipher", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = DBAction.libraryDS.Tables[table].Columns[1].ToString();
insertCommand.Parameters.Add("@LibraryCard", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = DBAction.libraryDS.Tables[table].Columns[2].ToString();
insertCommand.Parameters.Add("@DateBooking", NpgsqlTypes.NpgsqlDbType.Date).SourceColumn = DBAction.libraryDS.Tables[table].Columns[3].ToString();
insertCommand.Parameters.Add("@Department", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = DBAction.libraryDS.Tables[table].Columns[4].ToString();
updateCommand.Parameters.Add("@DateBooking", NpgsqlTypes.NpgsqlDbType.Date).SourceColumn = "date_booking";
updateCommand.Parameters.Add("@Department", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_department";
updateCommand.Parameters.Add("@Id", NpgsqlTypes.NpgsqlDbType.Integer).SourceColumn = "id_booking";
#endregion
bookingDataAdapter.UpdateCommand = updateCommand;
bookingDataAdapter.DeleteCommand = deleteCommand;
bookingDataAdapter.InsertCommand = insertCommand;
DBAction.updateDataTable(bookingDataAdapter, table);
getTableBooking();
}