/// <summary> /// Gets all the images available in the DB /// </summary> /// <returns>returns the images available in the DB</returns> /// <remarks>Only call this method if you have to as retrieving all images can take a short while</remarks> public List <OSAEImage> GetImages() { List <OSAEImage> imageList = new List <OSAEImage>(); using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString)) { try { connection.Open(); MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images", connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { OSAEImage osaeImage = new OSAEImage(); osaeImage.ID = reader.GetUInt32("image_id"); osaeImage.Name = reader.GetString("image_name"); osaeImage.Type = reader.GetString("image_type"); osaeImage.Data = (byte[])reader.GetValue(1); imageList.Add(osaeImage); } } catch (Exception e) { // Exceptions should be caught by calling application throw new Exception("API - GetImages - Failed: " + e.Message, e); } } return(imageList); }
/// <summary> /// Gets an image from the DB /// </summary> /// <param name="imageId">The id of the image to get</param> /// <returns>the requested image</returns> public OSAEImage GetImage(int imageId) { OSAEImage osaeImage = new OSAEImage(); if (Common.TestConnection()) { using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images WHERE image_id = " + imageId, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { osaeImage.ID = reader.GetUInt32("image_id"); osaeImage.Name = reader.GetString("image_name"); osaeImage.Type = reader.GetString("image_type"); osaeImage.Data = (byte[])reader.GetValue(1); } else { logging.AddToLog("API - Failed to get requested image from DB: " + imageId.ToString(), true); } } } return(osaeImage); }
/// <summary> /// Gets all the images available in the DB /// </summary> /// <returns>returns the images available in the DB</returns> /// <remarks>Only call this method if you have to as retrieving all images can take a short while</remarks> public List <OSAEImage> GetImages() { List <OSAEImage> imageList = new List <OSAEImage>(); if (Common.TestConnection()) { using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString)) { try { connection.Open(); MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images", connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { OSAEImage osaeImage = new OSAEImage(); osaeImage.ID = reader.GetUInt32("image_id"); osaeImage.Name = reader.GetString("image_name"); osaeImage.Type = reader.GetString("image_type"); osaeImage.Data = (byte[])reader.GetValue(1); imageList.Add(osaeImage); } } catch (Exception e) { logging.AddToLog("API - GetImages - Failed \r\n\r\n" + e.Message, true); } } } return(imageList); }
public void Load_Screen(string sScreen) { try { while (updatingScreen) { System.Threading.Thread.Sleep(100); } loadingScreen = true; //this.Log.Debug("Loading screen: " + sScreen); stateImages.Clear(); propLabels.Clear(); navImages.Clear(); clickImages.Clear(); cameraViewers.Clear(); canGUI.Children.Clear(); browserFrames.Clear(); gCurrentScreen = sScreen; OSAEObjectPropertyManager.ObjectPropertySet(gAppName, "Current Screen", sScreen, "GUI"); OSAE.OSAEImageManager imgMgr = new OSAE.OSAEImageManager(); string imgID = OSAEObjectPropertyManager.GetObjectPropertyValue(sScreen, "Background Image").Value; OSAE.OSAEImage img = imgMgr.GetImage(imgID); //sPath = OSAEApi.APIpath + OSAEApi.GetObjectPropertyValue(sScreen, "Background Image").Value; //byte[] byteArray = File.ReadAllBytes(sPath); if (img.Data != null) { var imageStream = new MemoryStream(img.Data); var bitmapImage = new BitmapImage(); bitmapImage.BeginInit(); bitmapImage.StreamSource = imageStream; bitmapImage.EndInit(); canGUI.Background = new ImageBrush(bitmapImage); canGUI.Height = bitmapImage.Height; canGUI.Width = bitmapImage.Width; } //Thread threadLoad = new Thread(() => Load_Objects(sScreen)); //threadLoad.Start(); Load_Objects(sScreen); loadingScreen = false; //this.Log.Debug("Loading screen complete: " + sScreen); } catch (Exception ex) { this.Log.Error("Failed to load screen: " + sScreen, ex); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (fileUpload.HasFile) { try { if (System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".jpg" && System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".png" && System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".jpeg") { // wrong file type return; } else { if (fileUpload.PostedFile.ContentLength < 102400) { OSAEImage img = new OSAEImage(); img.Data = fileUpload.FileBytes; img.Name = txtName.Text; img.Type = System.IO.Path.GetExtension(fileUpload.FileName).ToLower().Substring(1); var imageManager = new OSAE.OSAEImageManager(); imageManager.AddImage(img); loadImages(); } else { // file to big return; } } } catch (Exception ex) { } } }
protected void btnAdd_Click(object sender, EventArgs e) { if (fileUpload.HasFile) { try { if (System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".jpg" && System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".png" && System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".jpeg" && System.IO.Path.GetExtension(fileUpload.FileName).ToLower() != ".gif") { Master.Log.Error("Image not added, Wrong file type"); return; // wrong file type } else { if (fileUpload.PostedFile.ContentLength < 2502400) //202400 { OSAEImage img = new OSAEImage(); img.Data = fileUpload.FileBytes; img.Name = txtName.Text; img.Type = System.IO.Path.GetExtension(fileUpload.FileName).ToLower().Substring(1); var imageManager = new OSAE.OSAEImageManager(); imageManager.AddImage(img); loadImages(); } else { Master.Log.Error("Image not added, file is to large."); return; //file to big } } } catch (Exception ex) { } } }
/// <summary> /// Adds an image to the DB /// </summary> /// <param name="osaeImage">The image information to add</param> public int AddImage(OSAEImage osaeImage) { return(AddImage(osaeImage.Name, osaeImage.Type, osaeImage.Data)); }
/// <summary> /// Gets an image from the DB /// </summary> /// <param name="imageId">The id of the image to get</param> /// <returns>the requested image</returns> public OSAEImage GetImage(int imageId) { OSAEImage osaeImage = new OSAEImage(); if (Common.TestConnection()) { using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString)) { MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images WHERE image_id = " + imageId, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { osaeImage.ID = reader.GetUInt32("image_id"); osaeImage.Name = reader.GetString("image_name"); osaeImage.Type = reader.GetString("image_type"); osaeImage.Data = (byte[])reader.GetValue(1); } else { logging.AddToLog("API - Failed to get requested image from DB: " + imageId.ToString(), true); } } } return osaeImage; }
/// <summary> /// Adds an image to the DB /// </summary> /// <param name="osaeImage">The image information to add</param> public int AddImage(OSAEImage osaeImage) { return AddImage(osaeImage.Name, osaeImage.Type, osaeImage.Data); }
/// <summary> /// Gets all the images available in the DB /// </summary> /// <returns>returns the images available in the DB</returns> /// <remarks>Only call this method if you have to as retrieving all images can take a short while</remarks> public List<OSAEImage> GetImages() { List<OSAEImage> imageList = new List<OSAEImage>(); if (Common.TestConnection()) { using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString)) { try { connection.Open(); MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images", connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { OSAEImage osaeImage = new OSAEImage(); osaeImage.ID = reader.GetUInt32("image_id"); osaeImage.Name = reader.GetString("image_name"); osaeImage.Type = reader.GetString("image_type"); osaeImage.Data = (byte[])reader.GetValue(1); imageList.Add(osaeImage); } } catch (Exception e) { logging.AddToLog("API - GetImages - Failed \r\n\r\n" + e.Message, true); } } } return imageList; }
/// <summary> /// Gets all the images available in the DB /// </summary> /// <returns>returns the images available in the DB</returns> /// <remarks>Only call this method if you have to as retrieving all images can take a short while</remarks> public List<OSAEImage> GetImages() { List<OSAEImage> imageList = new List<OSAEImage>(); using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString)) { try { connection.Open(); MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images", connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { OSAEImage osaeImage = new OSAEImage(); osaeImage.ID = reader.GetUInt32("image_id"); osaeImage.Name = reader.GetString("image_name"); osaeImage.Type = reader.GetString("image_type"); osaeImage.Data = (byte[])reader.GetValue(1); imageList.Add(osaeImage); } } catch (Exception e) { // Exceptions should be caught by calling application throw new Exception("API - GetImages - Failed: " + e.Message, e); } } return imageList; }