private void dgv_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1 && e.Button == MouseButtons.Middle)
{
string name = dgv.Columns[e.ColumnIndex].Name;
for (int i = 0; i < tbl.el_list.Count; i++)
{
if (name == tbl.el_list[i].name && tbl.el_list[i].cmbox)
{
Element el = tbl.el_list[i];
GroupChangeForm frm = new GroupChangeForm(el);
frm.ShowDialog();
Application.DoEvents();
if (frm.Acept)
{
int new_index = frm.id;
List <int> ids = new List <int>();
for (int j = 0; j < dgv.RowCount; j++)
{
ids.Add((int)dgv.Rows[j].Cells[0].Value);
}
foreach (var VARIABLE in ids)
{
string req = "update itemtable set " + el.name + " = " + new_index + " where ID=" +
VARIABLE;
SQL_Class.Execute(req);
Logs.add_upload_log(VARIABLE, el.name, el.addtable, SQL_Class.ReadValueInt32("select " + el.name + " from itemtable where ID=" + VARIABLE), new_index);
}
Load_Data_With_Filters();
}
}
}
}
}
private void status21_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Status2", "status2table", pr.base_el.Status2id, status21.SelectedItem.ToString());
upload(status21.SelectedItem.ToString(), pr.base_el.Status2id, "Status2", "status2table");
}
private void text5_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Text5", pr.base_el.Text5, t5.Text);
upload(t5.Text, pr.base_el.Text5, "Text5");
}
private void text6_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Text6", pr.base_el.Text6, t6.Text);
upload(t6.Text, pr.base_el.Text6, "Text6");
}
private void text3_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Text3", pr.base_el.Text3, t3.Text);
upload(t3.Text, pr.base_el.Text3, "Text3");
}
private void text4_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Text4", pr.base_el.Text4, t4.Text);
upload(t4.Text, pr.base_el.Text4, "Text4");
}
private void text1_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Text", pr.base_el.Text, t1.Text);
upload(t1.Text, pr.base_el.Text, "Text");
}
private void text2_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Text2", pr.base_el.Text2, t2.Text);
upload(t2.Text, pr.base_el.Text2, "Text2");
}
private void date_up_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Date", pr.base_el.date.ToString(), date1.Value.ToString());
upload(date1.Value, pr.base_el.date, "Date");
}
private void prise_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Prise", pr.base_el.Prise, prise1.Text);
upload(prise1.Text, pr.base_el.Prise, "Prise");
}
private void os_up_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "OS", "ostable", pr.base_el.OSID, os1.SelectedItem.ToString());
upload(os1.SelectedItem.ToString(), pr.base_el.OSID, "OS", "ostable");
}
private void place20_up_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Place2", "place2table", pr.base_el.Place2id, place21.SelectedItem.ToString());
upload(place21.SelectedItem.ToString(), pr.base_el.Place2id, "Place2", "place2table");
}
private void type_up_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Type", "typetable", pr.base_el.Typeid, type1.SelectedItem.ToString());
upload(type1.SelectedItem.ToString(), pr.base_el.Typeid, "Type", "typetable");
}
private void mark_up_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Mark", "marktable", pr.base_el.Markid, mark1.SelectedItem.ToString());
upload(mark1.SelectedItem.ToString(), pr.base_el.Markid, "Mark", "marktable");
}
private void ser20_up_but_Click(object sender, EventArgs e)
{
Logs.add_upload_log(pr.base_el.ID, "Serial2", pr.base_el.Serial2, ser21.Text);
upload(ser21.Text, pr.base_el.Serial2, "Serial2");
}