private void button4_Click(object sender, EventArgs e) { string ID_klienta = null; string Familia = null; string Imia = null; string Otchestvo = null; string Nomer_pasporta = null; string Ceria_pasporta = null; string Data_sdachi = null; string Data_vidachi_pasporta = null; try { ID_klienta = ID_klient.Text; Familia = Famili.Text; Imia = Imi.Text; Otchestvo = Otchestv.Text; Nomer_pasporta = Nomer_pasport.Text; Ceria_pasporta = Ceria_pasport.Text; Data_sdachi = Data_sdach.Text; Data_vidachi_pasporta = Data_vidachi_pasport.Text; } catch (Exception exc) { MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int n = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); Data_vidachi_pasporta = Data_vidachi_pasport.Text; string query = "update dbo.Klienti set Familia = '" + Familia + "', Imia = '" + Imia + "', Otchestvo = '" + Otchestvo + "', Nomer_pasporta = '" + Nomer_pasporta + "', Ceria_pasporta = '" + Ceria_pasporta + "', Data_sdachi = '" + Data_sdachi + "', Data_vidachi_pasporta = '" + Data_vidachi_pasporta + "' where ID_klienta = '" + ID_klienta + "'"; int? result = DBConnectionService.SendCommandToSqlServer(query); if (result != null && result > 0) { MessageBox.Show("Done", "Object is updated", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button4_Click(object sender, EventArgs e) { string ID_tovara = null; string ID_kategorii = null; string Nazvanie = null; string Opisanie = null; string Srok_eksplotacii = null; string Sostoianie_prodaji = null; string Kachestvo_tovara = null; string Srok_otkladivania_tovara_v_nedelah = null; try { ID_tovara = ID_tovar.Text; ID_kategorii = ID_kategori.Text; Nazvanie = Nazvani.Text; Opisanie = Opisani.Text; Srok_eksplotacii = Srok_eksplotaci.Text; Sostoianie_prodaji = Sostoianie_prodaj.Text; Kachestvo_tovara = Kachestvo_tovar.Text; Srok_otkladivania_tovara_v_nedelah = Srok_otkladivania_tovara_v_nedela.Text; } catch (Exception exc) { MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int n = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); string query = "Update dbo.Tovar set Nazvanie = '" + Nazvanie + "',Srok_otkladivania_tovara_v_nedelah ='" + Srok_otkladivania_tovara_v_nedelah + "', Srok_eksplotacii = '" + Srok_eksplotacii + "', Kachestvo_tovara = '" + Kachestvo_tovara + "', Opisanie = '" + Opisanie + "', Sostoianie_prodaji = '" + Sostoianie_prodaji + "' where ID_tovara = '" + ID_tovara + "'"; int? result = DBConnectionService.SendCommandToSqlServer(query); if (result != null && result > 0) { MessageBox.Show("Done", "Object is Updated", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button3_Click(object sender, EventArgs e) { string ID_tovara = null; string ID_kategorii = null; string Nazvanie = null; string Opisanie = null; string Srok_eksplotacii = null; string Sostoianie_prodaji = null; string Kachestvo_tovara = null; string Srok_otkladivania_tovara_v_nedelah = null; try { ID_tovara = ID_tovar.Text; ID_kategorii = ID_kategori.Text; Nazvanie = Nazvani.Text; Opisanie = Opisani.Text; Srok_eksplotacii = Srok_eksplotaci.Text; Sostoianie_prodaji = Sostoianie_prodaj.Text; Kachestvo_tovara = Kachestvo_tovar.Text; Srok_otkladivania_tovara_v_nedelah = Srok_otkladivania_tovara_v_nedela.Text; } catch (Exception exc) { MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string query = "INSERT INTO Tovar(ID_tovara,ID_kategorii,Nazvanie,Opisanie,Srok_eksplotacii,Sostoianie_prodaji,Kachestvo_tovara,Srok_otkladivania_tovara_v_nedelah) " + "values(" + $"'{ID_tovara}','{ID_kategorii}','{Nazvanie}','{Opisanie}','{Srok_eksplotacii}','{Sostoianie_prodaji}','{Kachestvo_tovara}','{Srok_otkladivania_tovara_v_nedelah}'" + ")"; int?result = DBConnectionService.SendCommandToSqlServer(query); if (result != null && result > 0) { MessageBox.Show("Done", "Saving object", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button3_Click(object sender, EventArgs e) { string ID_klienta = null; string Familia = null; string Imia = null; string Otchestvo = null; string Nomer_pasporta = null; string Ceria_pasporta = null; string Data_sdachi = null; string Data_vidachi_pasporta = null; try { ID_klienta = ID_klient.Text; Familia = Famili.Text; Imia = Imi.Text; Otchestvo = Otchestv.Text; Nomer_pasporta = Nomer_pasport.Text; Ceria_pasporta = Ceria_pasport.Text; Data_sdachi = Data_sdach.Text; Data_vidachi_pasporta = Data_vidachi_pasport.Text; } catch (Exception exc) { MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string query = "INSERT INTO Klienti(ID_klienta,Familia,Imia,Otchestvo,Nomer_pasporta,Ceria_pasporta,Data_sdachi,Data_vidachi_pasporta) " + "values(" + $"'{ID_klienta}','{Familia}','{Imia}','{Otchestvo}','{Nomer_pasporta}','{Ceria_pasporta}','{Data_sdachi}','{Data_vidachi_pasporta}'" + ")"; int?result = DBConnectionService.SendCommandToSqlServer(query); if (result != null && result > 0) { MessageBox.Show("Done", "Saving object", MessageBoxButtons.OK, MessageBoxIcon.Information); } }