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("Ошибка");
}
}