private void dataGridMappings_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return; // header clicked
}
if (e.ColumnIndex == dataGridMappings.Columns["buttonColumn"].Index)
{
// Your logic here. You can gain access to any cell value via DataGridViewCellEventArgs
int Id = Convert.ToInt32(dataGridMappings["Id", e.RowIndex].Value);
instrumentMapping.DeleteMapping(Id);
var dataSource = instrumentMapping.GetBrokerInstrumentMapping();
dataGridMappings.DataSource = dataSource;
MessageBox.Show(this, "Mapping deleted successfully.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (e.ColumnIndex == dataGridMappings.Columns["buttonColumnEdit"].Index)
{
// Your logic here. You can gain access to any cell value via DataGridViewCellEventArgs
int Id = Convert.ToInt32(dataGridMappings["Id", e.RowIndex].Value);
tabControl1.TabPages.Insert(2, updateTab);
tabControl1.SelectedTab = updateTab;
result = instrumentMapping.GetBrokerInstrumentMapping(Id);
BindUpdateComboBox();
comboUpdateBroker.SelectedValue = result.BrokerId;
comboUpdateInstrument.SelectedValue = result.InstrumentId;
txtUpdateBIC.Text = result.BrokerInstrumentCode;
chkUpdatePrices.Checked = result.FeedPrices;
chkUpdateTrades.Checked = result.FeedTrades;
}
}
public List <clsBrokerInstrumentDetail> SearchMapping()
{
List <clsBrokerInstrumentDetail> listDetail = new List <clsBrokerInstrumentDetail>();
// We use these three SQLite objects:
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;
// create a new database connection:
sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;");
// open the connection:
sqlite_conn.Open();
// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();
// First lets build a SQL-Query again:
sqlite_cmd.CommandText = $"SELECT * FROM tblBrokerInstrumentMapping where FeedPrices='True' and FeedTrades='True'";
// Now the SQLiteCommand object can give us a DataReader-Object:
sqlite_datareader = sqlite_cmd.ExecuteReader();
// The SQLiteDataReader allows us to run through the result lines:
while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read
{
clsBrokerInstrumentDetail model = new clsBrokerInstrumentDetail();
model.Id = Convert.ToInt32(sqlite_datareader["Id"]);
model.InstrumentId = Convert.ToInt32(sqlite_datareader["InstrumentId"]);
model.BrokerId = Convert.ToInt32(sqlite_datareader["BrokerId"]);
model.BrokerInstrumentCode = Convert.ToString(sqlite_datareader["BrokerInstrumentCode"]);
var broker = GetBroker(model.BrokerId);
model.BrokerCode = broker.BrokerCode;
model.BrokerDescription = broker.BrokerDescription;
var instrument = GetInstrument(model.InstrumentId);
model.InstrumentCode = instrument.InstrumentCode;
model.InstrumentDescription = instrument.InstrumentDescription;
listDetail.Add(model);
}
// We are ready, now lets cleanup and close our connection:
DisposeConnection(sqlite_conn, sqlite_cmd, sqlite_datareader);
return(listDetail);
}