private void loadImageToolStripMenuItem_Click(object sender, EventArgs e) { try { Image_Record_Exists = false; image_entry_id = 0; CAMI_ID = 0; OFDImage = new OpenFileDialog(); OFDImage.Title = "Please select Image."; OFDImage.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF"; if (OFDImage.ShowDialog() == DialogResult.OK) { try { //check if record exists Reader_String = ""; Reader_String = "SELECT CAMI_ID FROM CAM_IMAGES WHERE ((CAMI_COMPNUM = " + Sys_Company + ")AND(CAMI_SITENUM = " + Sys_Site + ")AND(CAMI_BUILDNUM = " + Sys_Building + ")AND(CAMI_CAMNUM = " + Sys_Camera + ")AND(CAMI_ENTRYNUM = " + Sys_Entry + "))"; Reader = usedb.ExecuteQuery(Reader_String); while (Reader.Read()) { CAMI_ID = (int)Reader["CAMI_ID"]; Image_Record_Exists = true; } Reader.Close(); Image_New = Image.FromFile(OFDImage.FileName); if (Image_Record_Exists == false) //new record { Reader_String = ""; Reader_String = "SELECT MAX(CAMI_ID)FROM CAM_IMAGES"; Reader = usedb.ExecuteQuery(Reader_String); if (Reader.Read() == true) { results = Reader[0].ToString(); if (results == "") { image_entry_id = 1; } else { image_entry_id = Convert.ToInt32(results) + 1; } } Reader.Close(); Apt_String = "INSERT INTO CAM_IMAGES(CAMI_ID,CAMI_COMPNUM,CAMI_SITENUM,CAMI_BUILDNUM,CAMI_CAMNUM,CAMI_ENTRYNUM,CAMI_DATE,CAMI_IMGDEVICE)VALUES(" + image_entry_id + "," + Sys_Company + "," + Sys_Site + "," + Sys_Building + "," + Sys_Camera + "," + Sys_Entry + ",'" + DateTime.Now + "',@Image)"; Apt = usedb.Image_Insert(Apt_String, Image_New); } else //insert new record { Apt_String = ""; Apt_String = "UPDATE CAM_IMAGES SET CAMI_IMGDEVICE = @Image WHERE ((CAMI_COMPNUM = " + Sys_Company + ")AND(CAMI_SITENUM = " + Sys_Site + ")AND(CAMI_BUILDNUM = " + Sys_Building + ")AND(CAMI_CAMNUM = " + Sys_Camera + ")AND(CAMI_ENTRYNUM = " + Sys_Entry + ")AND(CAMI_ID = " + CAMI_ID + "))"; Apt = usedb.Image_Insert(Apt_String, Image_New); } PBDevice.Image = Image_New; OFDImage.Dispose(); } catch (Exception ex) { Write_Log("An error has occured.\nError: " + Convert.ToString(ex)); } } } catch (Exception ex) { Write_Log("An error has occured.\nError: " + Convert.ToString(ex)); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)