public void CreateTableAdapter()
{
_workerTable.Clear();
_adapter = new SqlDataAdapter(@"SELECT* FROM workers", SingleConnection.NewConnection());
_adapter.Fill(_workerTable);
_dataGridView.DataSource = _workerTable;
}
public void CreateTableAdapter()
{
try
{
string tmp = @"SELECT C.id as [ID], C.date as [Дата платежа], C.cost as [Сумма], W.name as [Водитель], C.note as [Примечание]
FROM cleaning_works AS C, workers AS W WHERE C.fk=W.id;";
_cleanTable.Clear();
_adapter = new SqlDataAdapter(tmp, SingleConnection.NewConnection());
_adapter.Fill(_cleanTable);
_dataGridView.DataSource = _cleanTable;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
public CleaningWorks(DataGridView dataGridView, Label clean, Label pay, Label itog, MaskedTextBox maskedTextBox,
DateTimePicker dateTimePicker, TextBox textBox, ComboBox comboBox)
{
SingleConnection.NewConnection();
_connect = new WG_db();
_connect.cleaning_works.Load();
_cleanTable = new DataTable();
_dataGridView = dataGridView;
_maskedTextBox = maskedTextBox;
_dateTimePicker = dateTimePicker;
_textBox = textBox;
_comboBox = comboBox;
_cleansumm = clean;
_paysumm = pay;
_itogsumm = itog;
Summ();
}
public void InsertCommand()
{
try
{
SqlCommand _insert = new SqlCommand(@"INSERT INTO workers (name, phone ) VALUES (@name, @phone);", SingleConnection.NewConnection());
_insert.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 100));
_insert.Parameters.Add(new SqlParameter("@phone", SqlDbType.VarChar, 16));
_insert.Parameters["@name"].SourceVersion = DataRowVersion.Current;
_insert.Parameters["@phone"].SourceVersion = DataRowVersion.Current;
_insert.Parameters["@name"].SourceColumn = "name";
_insert.Parameters["@phone"].SourceColumn = "phone";
_adapter.InsertCommand = _insert;
SqlCommandBuilder _builder = new SqlCommandBuilder(_adapter);
_adapter.Update(_workerTable);
CreateTableAdapter();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Workers(DataGridView dataGridView)
{
SingleConnection.NewConnection();
_workerTable = new DataTable();
_dataGridView = dataGridView;
}