private void button2_Click(object sender, EventArgs e)
{
int nomStr = dataGridView1.CurrentCell.RowIndex;
if (textBox1.Text == "")
{
MessageBox.Show("Ввидите вопрос!");
}
else
{
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Soderzhanie SET dopolnit = " + "'" + textBox1.Text + "'" + " Where kod_ek = " + Dannie.KodEk + " AND kod_r = " + Convert.ToInt32(dataGridView1.Rows[nomStr].Cells[0].Value.ToString()), sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
up();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("Заполните поля!");
}
else
{
int prcV = Convert.ToInt32(dataGridView1.Rows[0].Cells[0].Value.ToString());
int prcDV = Convert.ToInt32(dataGridView1.Rows[0].Cells[1].Value.ToString());
if ((prcV + prcDV) > 100)
{
MessageBox.Show("Сумма процентов должна быть не более 100!");
}
else
{
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Nastrojki SET kol_vop = " + Convert.ToInt32(textBox1.Text) + ", kol_dop = " + Convert.ToInt32(textBox2.Text), sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
}
}
private void SynchronizeButton_Click(object sender, EventArgs e)
{
// Call the synchronize method to synchronize
// data between local and remote databases.
//<snippetOCS_CS_ExtendDesigner_Form_AddHandlers>
NorthwindCacheSyncAgent syncAgent = new NorthwindCacheSyncAgent();
NorthwindCacheClientSyncProvider clientSyncProvider =
(NorthwindCacheClientSyncProvider)syncAgent.LocalProvider;
clientSyncProvider.AddHandlers();
Microsoft.Synchronization.Data.SyncStatistics syncStats =
syncAgent.Synchronize();
//</snippetOCS_CS_ExtendDesigner_Form_AddHandlers>
// After synchronizing the data, refill the
// table in the dataset.
this.customersTableAdapter.Fill(this.northwindDataSet.Customers);
//<snippetOCS_CS_ExtendDesigner_Form_MessageBoxShow>
MessageBox.Show("Changes downloaded: " +
syncStats.TotalChangesDownloaded.ToString() +
Environment.NewLine +
"Changes uploaded: " + syncStats.TotalChangesUploaded.ToString());
//</snippetOCS_CS_ExtendDesigner_Form_MessageBoxShow>
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox2.BackColor == SystemColors.Window)
{
int nomStr = dataGridView1.CurrentCell.RowIndex;
if (textBox2.Text == "")
{
MessageBox.Show("Ввидите вопрос!");
}
else
{
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Soderzhanie SET ocenka = " + "'" + textBox2.Text + "'" + " Where kod_ek = " + Dannie.KodEk + " AND kod_r = " + Convert.ToInt32(dataGridView1.Rows[nomStr].Cells[0].Value.ToString()), sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
up();
}
}
else
{
MessageBox.Show("Некорректный ввод оценки", "Ошибка ввода", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void sync()
{
Cursor.Current = Cursors.WaitCursor;
Entretien.Client.WebReference.EntretienSyncService svcProxy = new Entretien.Client.WebReference.EntretienSyncService();
Microsoft.Synchronization.Data.ServerSyncProviderProxy syncProxy =
new Microsoft.Synchronization.Data.ServerSyncProviderProxy(svcProxy);
// Call SyncAgent.Synchronize() to initiate the synchronization process.
// Synchronization only updates the local database, not your project's data source.
EntretienSyncAgent syncAgent = new EntretienSyncAgent();
syncAgent.RemoteProvider = syncProxy;
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
// TODO: Reload your project data source from the local database (for example, call the TableAdapter.Fill method).
clientTableAdapter.Fill(entretienlDataSet.Client);
// Show synchronization statistics
MessageBox.Show("Changes downloaded: " + syncStats.TotalChangesDownloaded.ToString()
+ "\r\nChanges Uploaded: " + syncStats.TotalChangesUploaded.ToString());
Cursor.Current = Cursors.Default;
}
private void dobEk()
{
Form1 formGlavn = new Form1();
SqlConnection sc = new SqlConnection(formGlavn.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("INSERT INTO Ekzamen(data) VALUES ('" + dateTimePicker1.Value.Date + "'" + " )", sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
private void dobKomis()
{
int nomStr = dataGridView1.CurrentCell.RowIndex;
Form1 formGlavn = new Form1();
SqlConnection sc = new SqlConnection(formGlavn.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("INSERT INTO Komissiya(kod_ek, kod_k) VALUES (" + Dannie.KodEk + ", " + Convert.ToInt32(dataGridView1.Rows[nomStr].Cells[0].Value.ToString()) + " )", sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
ChliniEk();
}
private void button8_Click(object sender, EventArgs e)
{
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Soderzhanie SET balli = " + itog + " Where kod_r=" + Dannie.KodRabot + " AND kod_ek = " + Dannie.KodEk, sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
int nomStr = dataGridView1.CurrentCell.RowIndex;
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Voprosi SET ek = 'False' Where kod_vop = " + Convert.ToInt32(dataGridView2.Rows[nomStr].Cells[0].Value.ToString()), sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
EkzVop();
}
private void button2_Click(object sender, EventArgs e)
{
int s = dataGridView1.CurrentCell.RowIndex;
string d = dataGridView1.Rows[s].Cells[0].Value.ToString();
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Rabotni SET otmetka='false' Where kod_r=" + d, sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
up();
}
private void dobVop()
{
if (textBox1.Text == "") MessageBox.Show("Заполните поле!");
else
{
Form1 formGlavn = new Form1();
SqlConnection sc = new SqlConnection(formGlavn.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("INSERT INTO Voprosi(vopros, kod_p) VALUES ('" + textBox1.Text + "', " + Dannie.KodV + " )", sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
}
public void dobRabotni()
{
if (textBox1.Text == "" || textBox2.Text == "" || comboBox1.Text == "" || comboBox2.Text == "" || comboBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "")
{
MessageBox.Show("Заполните все поле!");
}
else
{
Form1 formGlavn = new Form1();
SqlConnection sc = new SqlConnection(formGlavn.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("INSERT INTO Rabotni(fio, nom_ud, otm_o_sdch, kod_dolzh, kod_kv, kod_vd, email, otmetka, Password1) VALUES ('" + textBox1.Text + "', '" + textBox2.Text + "', '" + textBox3.Text + "', '" + comboBox3.SelectedValue + "', '" + comboBox1.SelectedValue + "', '" + comboBox2.SelectedValue + "', '" + textBox4.Text + "', 'False', '" + textBox5.Text + "' )", sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
}
private void redPril()
{
if (textBox1.Text == "")
{
MessageBox.Show("Заполните поле!");
}
else
{
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Prilozheniya SET prilozh = " + "'" + textBox1.Text + "'" + " Where kod_pr=" + "'" + Dannie.KodPrilog + "'", sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
}
private void redDolzh()
{
if (textBox1.Text == "")
{
MessageBox.Show("Заполните поле!");
}
else
{
Form1 f1 = new Form1();
SqlConnection sc = new SqlConnection(f1.connect);
SqlCommand cmd;
sc.Open();
cmd = new SqlCommand("UPDATE Rabotni SET fio=" + "'" + textBox1.Text + "', nom_ud='" + textBox2.Text + "', kod_dolzh ='" + comboBox3.SelectedValue + "', kod_kv ='" + comboBox1.SelectedValue + "', kod_vd ='" + comboBox2.SelectedValue + "', email ='" + textBox4.Text + "', Password1 ='" + textBox5.Text + "' Where kod_r=" + "'" + Dannie.KodR + "'", sc);
cmd.ExecuteNonQuery();
sc.Close();
//Синхронизация с базой -------------------------------------------------
LocalDataCache1SyncAgent syncAgent = new LocalDataCache1SyncAgent();
Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
//-----------------------------------------------------------------------
this.Close();
}
}
