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");
}
}
}
