int setIDpEdit(string d) { int res = 0; var row = dgv_clients.SelectedCells[0].OwningRow.Cells; if (!Exists("poluchatel", "pFIO", d, "IDp", ref res)) { ClientsList.cmd.CommandText = "insert into poluchatel (pFIO, IDc) values ('" + row[7].Value.ToString() + "', " + ClientsList.cities.Find(x => x.name == row[8].Value.ToString()).id + ")"; } else { ClientsList.cmd.CommandText = "update poluchatel set pFIO = '" + row[7].Value.ToString() + "', IDc = " + ClientsList.cities.Find(x => x.name == row[8].Value.ToString()).id + " where IDp = " + idP; } ClientsList.Open(); MessageBox.Show(ClientsList.cmd.CommandText); ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); Exists("poluchatel", "pFIO", d, "IDp", ref res); return(res); }
int setIDkEdit(string d) { int res = 0; var row = dgv_clients.SelectedCells[0].OwningRow.Cells; if (Exists("klient", "kfio", d, "IDk", ref res)) { ClientsList.cmd.CommandText = "update klient set kfio = '" + row[0].Value.ToString() + "', kserialnumber = '" + row[1].Value.ToString() + "', IDc = " + ClientsList.cities.Find(x => x.name == row[8].Value.ToString()).id + " where IDk = " + idK; } else { ClientsList.cmd.CommandText = "insert into klient (kfio, kserialnumber, IDc) values ('" + row[0].Value.ToString() + "', '" + row[1].Value.ToString() + "', " + ClientsList.cities.Find(x => x.name == row[2].Value.ToString()).id + ")"; } ClientsList.Open(); MessageBox.Show(ClientsList.cmd.CommandText); ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); Exists("klient", "kfio", row[0].Value.ToString(), "IDk", ref res); return(res); }
private void btn_register_Click(object sender, EventArgs e) { ClientsList.Open(); ClientsList.cmd.CommandText = "insert into user (ulogin, upass) values ('" + tb_login.Text + "', '" + tb_pwd.Text + "')"; ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); MessageBox.Show("Регистрация прошла успешно."); }
void setTypes() { var row = dgv_clients.SelectedCells[0].OwningRow.Cells; ClientsList.cmd.CommandText = "update dostavka set tdost = '" + row[6].Value.ToString() + "'"; ClientsList.Open(); ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); }
int setIDp(string dp) { string stRes; int res = 0; var row = dgv_clients.SelectedCells[0].OwningRow.Cells; if (!Exists("poluchatel", "pFIO", dp, "IDp", ref res)) { ClientsList.Open(); ClientsList.cmd.CommandText = "insert into poluchatel (pFIO, IDc) values ('" + row[7].Value.ToString() + "', " + ClientsList.cities.Find(x => x.name == row[8].Value.ToString()).id + ")"; ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); Exists("poluchatel", "pFIO", dp, "IDp", ref res); } return(res); }
int setIDk(string dk) { string stRes; int res = 0; var row = dgv_clients.SelectedCells[0].OwningRow.Cells; if (!Exists("klient", "kfio", dk, "IDk", ref res)) { ClientsList.Open(); ClientsList.cmd.CommandText = "insert into klient (kfio, kserialnumber, IDc) values ('" + row[0].Value.ToString() + "', '" + row[1].Value.ToString() + "', " + ClientsList.cities.Find(x => x.name == row[2].Value.ToString()).id + ")"; ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); Exists("klient", "kfio", dk, "IDk", ref res); } return(res); }
bool Exists(string t, string c, string v, string r, ref int result) { bool res = true; ClientsList.Open(); ClientsList.cmd.CommandText = "select " + r + " from " + t + " where " + c + " = '" + v + "'"; MessageBox.Show(ClientsList.cmd.CommandText); result = 0; ClientsList.reader = ClientsList.cmd.ExecuteReader(); while (ClientsList.reader.Read()) { result = (int)ClientsList.reader[0]; } if (result == 0) { res = false; } ClientsList.c.Close(); return(res); }
private void btn_create(object sender, EventArgs e) { var dd = (dgv_clients.SelectedCells[0].OwningRow.Cells[6] as DataGridViewComboBoxCell); string dk = dgv_clients.SelectedCells[0].OwningRow.Cells[0].Value.ToString(); //sender string dp = dgv_clients.SelectedCells[0].OwningRow.Cells[7].Value.ToString(); //recipient int idd, idk, idu, idp; idd = dd.Items.IndexOf(dd.Value) + 1; idu = Auth.userID; idk = setIDk(dk); idp = setIDp(dp); //new request ClientsList.Open(); ClientsList.cmd.CommandText = "insert into zayavka (IDd, IDk, IDu, IDp) values (" + idd + ", " + idk + ", " + idu + ", " + idp + ")"; MessageBox.Show(ClientsList.cmd.CommandText); Clipboard.SetText(ClientsList.cmd.CommandText); ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); Close(); }
private void btn_edit(object sender, EventArgs e) { var dd = (dgv_clients.SelectedCells[0].OwningRow.Cells[6] as DataGridViewComboBoxCell); string dk = dgv_clients.SelectedCells[0].OwningRow.Cells[0].Value.ToString(); //sender string dp = dgv_clients.SelectedCells[0].OwningRow.Cells[7].Value.ToString(); //recipient int idd, idk, idu, idp; idd = dd.Items.IndexOf(dd.Value) + 1; idu = Auth.userID; idk = setIDkEdit(dk); idp = setIDpEdit(dp); setTypes(); //edit request ClientsList.Open(); ClientsList.cmd.CommandText = "update zayavka set IDd = " + idd + ", IDk = " + idk + ", IDu = " + idu + ", IDp = " + idp + " where IDz = " + idZ; MessageBox.Show(ClientsList.cmd.CommandText); Clipboard.SetText(ClientsList.cmd.CommandText); ClientsList.cmd.ExecuteNonQuery(); ClientsList.c.Close(); Close(); }
private void btn_login_Click(object sender, EventArgs e) { ClientsList.Open(); ClientsList.cmd.CommandText = "select IDu, ulogin from user where upass = '******'"; ClientsList.reader = ClientsList.cmd.ExecuteReader(); while (ClientsList.reader.Read()) { userID = (int)ClientsList.reader[0]; log = ClientsList.reader[1].ToString(); } ClientsList.reader.Close(); ClientsList.c.Close(); if (log != null) { ClientsList f = new ClientsList(); Hide(); f.Show(); } else { MessageBox.Show("Ошибка"); } }