private void button10_Click(object sender, EventArgs e) { var form = new ContForm(); { var getReq = "SELECT * FROM Nazarov_Abonent"; var contactAdapter = new SqlDataAdapter(getReq, address_and_else); var dict = new Dictionary <int, string>(); var providerTbl = new DataTable(); contactAdapter.Fill(providerTbl); foreach (DataRow row in providerTbl.Rows) { string s = row["name"].ToString() + row["second name"].ToString() + row["third name"].ToString(); dict.Add((int)row["Id"], s); } form.MeanData = dict; } { var getReq = "SELECT * FROM Nazarov_Contact"; var Adapter = new SqlDataAdapter(getReq, address_and_else); var dict = new Dictionary <int, string>(); var Tbl = new DataTable(); Adapter.Fill(Tbl); foreach (DataRow row in Tbl.Rows) { dict.Add((int)row["Id"], row["phone"].ToString()); } form.PhoneData = dict; } if (form.ShowDialog() == DialogResult.OK) { var conn = new SqlConnection(address_and_else); conn.Open(); var request = "INSERT INTO Nazarov_Abon_Contact_Buff" + "(abon_id, cont_id)" + " VALUES " + "('" + form.AbId + "', '" + form.PhoneId + "')"; var com = new SqlCommand(request, conn); com.ExecuteNonQuery(); conn.Close(); UpdateAll(); } }
private void Button12_Click(object sender, EventArgs e) { var rov = dgrv_phone_list.SelectedRows.Count > 0 ? dgrv_phone_list.SelectedRows[0] : null; if (rov == null) { MessageBox.Show("Строчку выбери", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var old_abid = rov.Cells["Id"].Value.ToString(); var old_prid = rov.Cells["Id1"].Value.ToString(); var form = new ContForm(); { var getReq = "SELECT * FROM Nazarov_Abonent"; var contactAdapter = new SqlDataAdapter(getReq, address_and_else); var dict = new Dictionary <int, string>(); var providerTbl = new DataTable(); contactAdapter.Fill(providerTbl); int index = 0; foreach (DataRow row in providerTbl.Rows) { string s = row["name"].ToString() + " " + row["second name"].ToString() + " " + row["third name"].ToString(); dict.Add((int)row["Id"], s); if ((int)row["Id"] == int.Parse(old_abid)) { index = dict.Count - 1; } } form.MeanData = dict; form.Ab.SelectedIndex = index; index = 0; { getReq = "SELECT * FROM Nazarov_Contact"; var Adapter = new SqlDataAdapter(getReq, address_and_else); dict = new Dictionary <int, string>(); var Tbl = new DataTable(); Adapter.Fill(Tbl); foreach (DataRow row in Tbl.Rows) { dict.Add((int)row["Id"], row["phone"].ToString()); if ((int)row["Id"] == int.Parse(old_prid)) { index = dict.Count - 1; } } form.PhoneData = dict; form.Phone.SelectedIndex = index; } if (form.ShowDialog() == DialogResult.OK) { var conn = new SqlConnection(address_and_else); conn.Open(); //var request = "INSERT INTO Nazarov_Abon_Contact_Buff" + "(abon_id, cont_id)" + " VALUES " + "('" + form.AbId + "', '" + form.PhoneId + "')"; //var request = "UPDATE Nazarov_Abon_Contact_Buff SET abon_id ='" + form.AbId + "', form.AbId ='" + form.PhoneId + "', povider_id ='" + provider_id.ToString() + "' WHERE Id=" + id + ";"; var request = "DELETE FROM Nazarov_Abon_Contact_Buff WHERE abon_id=" + old_abid + " AND cont_id=" + old_prid; var com = new SqlCommand(request, conn); com.ExecuteNonQuery(); request = "INSERT INTO Nazarov_Abon_Contact_Buff (abon_id, cont_id) VALUES ('" + form.AbId + "', '" + form.PhoneId + "')"; com = new SqlCommand(request, conn); com.ExecuteNonQuery(); conn.Close(); UpdateAll(); } } }