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);
}
}
