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