private void button1_Click_1(object sender, EventArgs e) { AddImage newImage = new AddImage(); newImage.Show(); this.Hide(); }
private void bttnAddTag_Click(object sender, EventArgs e) { try { String inputTag = txtboxTag.Text; inputTag = inputTag.ToLower(); string sqlSearchTags = "SELECT * FROM tblTags"; SqlConnection conn = new SqlConnection(@"Server=(local);Integrated Security=True;MultipleActiveResultSets=true;Database=ImageBaseDataBase"); conn.Open(); SqlCommand command = new SqlCommand(sqlSearchTags); command.Connection = conn; SqlDataReader dataReader = command.ExecuteReader(); bool duplicate = false; while (dataReader.Read()) { if (dataReader.GetString(0) == inputTag) { duplicate = true; } } dataReader.Close(); conn.Close(); if (duplicate == true) { MessageBox.Show("This tag already exists", "Error"); } else { String sqlInsertTag = "INSERT INTO tblTags VALUES ('" + inputTag + "')"; conn.Open(); command = new SqlCommand(sqlInsertTag); command.Connection = conn; command.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Tag added"); AddImage newImage = new AddImage(); newImage.Show(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show("Could not connect to database"); } }
private void bttnAddImage_Click(object sender, EventArgs e) { int checkedItems = 0; foreach (object itemChecked in chkboxlistTags.CheckedItems) { checkedItems++; } checkedItems++; if (txtboxImageFIleAddress.Text == "" || txtboxName.Text == "") { MessageBox.Show("Please ensure that you have entered a name and selected an image to upload", "Error"); } else if (checkedItems == 0) { MessageBox.Show("At least one tag must be selected", "Error"); } else { try { string sqlImageSelectQuery = "SELECT imgImageID FROM tblImage "; SqlConnection conn = new SqlConnection(@"Server=(local);Integrated Security=True;MultipleActiveResultSets=true;Database=ImageBaseDataBase"); conn.Open(); SqlCommand selectCommand = new SqlCommand(sqlImageSelectQuery); selectCommand.Connection = conn; SqlDataReader result = selectCommand.ExecuteReader(); int nextImageID = 0; while (result.Read()) { nextImageID = result.GetInt32(0); } nextImageID++; string[] imageTags = new string[checkedItems]; int i = 0; foreach (object itemChecked in chkboxlistTags.CheckedItems) { imageTags[i] = itemChecked.ToString(); i++; } string sqlInsertTagsQuery = "INSERT INTO tblImageTags VALUES ('" + nextImageID + "', '" + imageTags[i] + "')"; SqlCommand insertTagsCommand = new SqlCommand(); insertTagsCommand.Connection = conn; for (i = 0; i < imageTags.Length; i++) { sqlInsertTagsQuery = sqlInsertTagsQuery = "INSERT INTO tblImageTags VALUES ('" + nextImageID + "', '" + imageTags[i] + "')"; insertTagsCommand = new SqlCommand(sqlInsertTagsQuery); insertTagsCommand.Connection = conn; insertTagsCommand.ExecuteNonQuery(); } string date = DateTime.Now.ToString("dd/mm/yyyy"); byte[] img = null; FileStream fs = new FileStream(txtboxImageFIleAddress.Text, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); img = br.ReadBytes((int)fs.Length); string sqlInsertImageQuery = "INSERT INTO tblImage VALUES ('" + nextImageID + "', '" + txtboxName.Text + "', '" + date + "', '" + Login.getUser() + "', 'unmoderated', @imgImageFile)"; SqlCommand insertCommand = new SqlCommand(sqlInsertImageQuery); insertCommand.Connection = conn; insertCommand.Parameters.Add(new SqlParameter("imgImageFile", img)); insertCommand.ExecuteNonQuery(); MessageBox.Show("UploadedImage added successfully!", "Success"); AddImage newWindow = new AddImage(); newWindow.Show(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show("Could not connect to database"); } } }