<%@ Page Language="C#" %>
<%@ import namespace="System.IO" %>
<%@ import Namespace="System.Drawing.Imaging" %>
<%@ import Namespace="System.Drawing" %>

<script runat="server">
  void UploadBut_Click(Object sender, EventArgs args)
  {
  	   DateTime MyDate = DateTime.Now; 	   
	   String UploadedFile = PhotoUpload.PostedFile.FileName;	
	   String FilePath = Request.PhysicalApplicationPath + "\\files\\";	
	   
	   int ExtractPos =	UploadedFile.LastIndexOf("\\") + 1;	 
	   String UploadedFileName =  MyDate.ToString("ddMMyyhhmmss") + "_" + UploadedFile.Substring(ExtractPos,UploadedFile.Length - ExtractPos);
	   
       PhotoUpload.PostedFile.SaveAs(FilePath + UploadedFileName );
	   
      String ImageName = "thumb_" + UploadedFileName;

	  	ImageName = Regex.Replace(ImageName, ".jpg", "");
		ImageName = Regex.Replace(ImageName, ".gif", "");
		ImageName = Regex.Replace(ImageName, ".jpeg", "");
		ImageName = Regex.Replace(ImageName, ".png", "");
	  	ImageName = Regex.Replace(ImageName, ".JPG", ""); // Should not have to do this!
		ImageName = Regex.Replace(ImageName, ".GIF", ""); // Need to figure out LCase in C#
		ImageName = Regex.Replace(ImageName, ".JPEG", ""); // OR need to IgnoreCase
		ImageName = Regex.Replace(ImageName, ".PNG", ""); // For now this will do.

      Int32 ImageWidth = 125;
      Stream ImageStream = PhotoUpload.PostedFile.InputStream;
    
      if ( PhotoUpload.PostedFile.FileName != "") 
      {
        SaveUploadImageAsJpeg(ImageStream, FilePath, ImageName, ImageWidth);
        SaveUploadImageAsGif(ImageStream, FilePath, ImageName, ImageWidth);
        SaveUploadImageAsPng(ImageStream, FilePath, ImageName, ImageWidth);
      }
  }

  void SaveUploadImageAsJpeg(Stream ImageStream, String FilePath, String ImageName, Int32 ImageWidth)
  {        
      String Extension = ".jpg";
      String MimeType = "image/jpeg";
      long Quality = 95;
      UploadImage(ImageStream, FilePath, ImageName, ImageWidth, Extension, MimeType, Quality);
  }

  void SaveUploadImageAsGif(Stream ImageStream, String FilePath, String ImageName, Int32 ImageWidth)
  {            
      String Extension = ".gif";
      String MimeType = "image/gif";
      long Quality = 100;
      UploadImage(ImageStream, FilePath, ImageName, ImageWidth, Extension, MimeType, Quality);
  }

  void SaveUploadImageAsPng(Stream ImageStream, String FilePath, String ImageName, Int32 ImageWidth)
  {            
      String Extension = ".png";
      String MimeType = "image/png";
      long Quality = 0; // has no effect on png files
      UploadImage(ImageStream, FilePath, ImageName, ImageWidth, Extension, MimeType, Quality);
  }    

  void UploadImage(Stream ImageStream, String FilePath, String ImageName, Int32 ImageWidth, String Extension, String MimeType, long Quality )
  {            
      try
      {                
          System.Drawing.Image UploadedImage = System.Drawing.Image.FromStream(ImageStream);
      
          Int32 old_height = UploadedImage.Height;
          Int32 old_width = UploadedImage.Width;
      
          Int32 new_width  = ImageWidth; 
          Int32 new_height = (Int32) Math.Ceiling( (old_height * new_width)/old_width );
      
          Bitmap smallerImg = new Bitmap(new_width, new_height);    
          Graphics g = Graphics.FromImage(smallerImg);
          g.DrawImage(UploadedImage, 0, 0, new_width, new_height);
      
          UploadedImage.Dispose();
      
          if ( !Extension.Equals(".png") )
          {
              EncoderParameters myParams = new EncoderParameters(1);
              myParams.Param[0] = new EncoderParameter(System.Drawing.Imaging.Encoder.Quality, Quality );                
              smallerImg.Save( FilePath + ImageName + Extension, GetEncoderInfo(MimeType), myParams);        
          }
          else
          {
              smallerImg.Save(  FilePath + ImageName + Extension , ImageFormat.Png);                    
          }
          smallerImg.Dispose();        
      }
      finally {  }
  }
      
  private ImageCodecInfo GetEncoderInfo(string mimeType)
  {
      int j;
      ImageCodecInfo[] encoders;
      encoders = ImageCodecInfo.GetImageEncoders();
      for(j = 0; j < encoders.Length; ++j)
      {
          if(encoders[j].MimeType == mimeType)
          {
              return encoders[j];
          }
      }
      return null;
  }

  // Validate the uploaded file is an image (.jpg, .jpeg, .gif)
  void ValidatePicture(Object src, ServerValidateEventArgs args)
  {                
      args.IsValid = false;
      String fileName = PhotoUpload.PostedFile.FileName.ToLower();
      if (fileName == "" || (fileName.IndexOf(".jpg") > -1) || (fileName.IndexOf(".jpeg") > -1) || (fileName.IndexOf(".gif") > -1)) args.IsValid = true;
  }  
  
</script>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
  <title></title>
</head>

<body>
<form id="MainForm" enctype="multipart/form-data" runat="server">
  <table cellpadding="4" cellspacing="0" border="0">
      <tr><td colspan="2" height="5"></td></tr>
      <tr>
          <td valign="top">Photo:</td>
          <td> 
            <input id="PhotoUpload" runat="server" type="File" class="formcopy" />
            <asp:customvalidator enableclientscript="false" cssclass="formcopy" display="dynamic" runat="server" text="* must be a .jpg, .jpeg, or .gif" controlToValidate="PhotoUpload" onservervalidate="ValidatePicture" />
          </td>
      </tr>
  </table>                    
  <br />
  <table cellpadding="4" cellspacing="0" border="0">
      <tr>
          <td><asp:button ID="AddSaveButton" text="Upload" onclick="UploadBut_Click" cssclass="formcopy" runat="server" /></td>
          <td></td>
      </tr>
  </table>
</form>
</body>
</html>

RegexOptions.IgnoreCase

quote:

---

Can't help with the 2nd problem now :). What is the issue, the DB insertion?

---

ImageName = Regex.Replace(ImageName, ".jpg", "", RegexOptions.IgnoreCase);

using System;
using System.Data;
using System.Data.SqlClient;

class SnitzExample
{
    public static void Main()
    {
       SqlConnection sCon = new SqlConnection("Initial Catalog=MyDB;Data Source=localhost;Integrated Security=SSPI;");
       SqlCommand sCmd = new SqlCommand("Your Query goes here", sCon); // build the SQL there and create the command

       sCon.Open();

       sCmd.ExecuteNonQuery();  //This will execute the append query

       sCon.Close();
    }
}

 void SendToDB(String FilePath, String UploadedFileName)
{
    OleDbConnection conImages;
    OleDbCommand cmdImgIns;
    string myConnString;
    string strSQL;
    
    myConnString = "Provider=SQLOLEDB;Data Source=SERVER; Initial Catalog=burningsoulsforum;User Id=******;Password=******; Connect Timeout=15;Network Library=dbmssocn;";
    conImages = new OleDbConnection( myConnString );
    
    strSQL = "INSERT INTO FORUM_IMAGES (I_LOC, I_MID) VALUES ('" + UploadedFileName + "', 2)";
    cmdImgIns = new OleDbCommand( strSQL, conImages );
    
    conImages.Open(); 
    cmdImgIns.ExecuteNonQuery();
    conImages.Close();
}

quote:

---

Originally posted by ruirib

I'm not sure what you mean, exactly. You want to read the info from the DB and show it a text area?

---

window.opener.document.PostTopic.Message.value+= '[img]uploaded/' + '<%=strFolder%>' + '/' + fname + '[/img]'

	private void Page_Load(object sender, System.EventArgs e)
   	{

		 String myString="Testing";
                 String myScript;

  		 myScript = "<script>" + "alert( '"+ myString + "');" + "</script>";
		 Page.RegisterStartupScript("ClientScript", myScript);
	}