private void btnAddRecord_Click(object sender, EventArgs e)
{
ArrayList alObjects = new ArrayList();
mylib ml = new mylib();
int post, UserID, PhtoID;
byte[] imageData;
foreach (DataGridViewRow row in dataGridView1.Rows) {
if (Convert.ToBoolean(row.Cells[0].Value) == true) {
DataGridViewCell cell = row.Cells[2];
alObjects.Add(cell.Value.ToString());
string val = alObjects[(alObjects.Count - 1)].ToString();
}
}
string cbVal = cbPosts.SelectedValue.ToString();
string typeSecureVal = typeSecure.SelectedValue.ToString();
int typeSecureInt = Convert.ToInt32(typeSecureVal);
//if (cbVal != null) MessageBox.Show(cbVal);
//else MessageBox.Show("Должность не выбрана.", "Ошибка заполнения формы");
//if (alObjects.Count == 0) MessageBox.Show("Ни один объект допуска не выбран", "Ошибка заполнения формы");
imageData = File.ReadAllBytes(pictureBox1.ImageLocation);
post = Convert.ToInt32(cbVal);
string prns = "'" + tbFirstName.Text + "','" + tbLastName.Text + "','" + tbFatherName.Text + "','" + tbTabelNum.Text + "','" + post + "'";
UserID = ml.insert("INSERT INTO users (fname,lname,ftname,tabnum,post) VALUES (" + prns + ")", "Yes");
PhtoID = ml.insert_image(imageData, UserID, "Yes");
ml.insert("INSERT INTO UsersPosts (postid,userid) VALUES ('" + cbVal + "','" + UserID + "')");
//string card_column_prns = null;
string card_values_prns = "'" + UserID + "','" + typeSecureInt + "','" + PhtoID + "'";
int CID = ml.insert("INSERT INTO cards (uid,type,photo) VALUES (" + card_values_prns + ")","Yes");
int i = 1;
foreach (var obj in alObjects) {
int objID = Convert.ToInt32(obj);
ml.insert("INSERT INTO UsersObjects (uid,oid,cid) VALUES ('" + UserID + "','" + objID + "','" + CID + "')");
//card_column_prns += ",obj0" + i.ToString();
//card_values_prns += ",'" + objID.ToString() + "'";
i++;
}
}
