asp.net upload image file to achieve security image watermark and write to the database

  • 2020-05-10 18:00:51
  • OfStack


//  Involving namespaces  
using System; 
using System.Collections; 
using System.ComponentModel; 
using System.Data; 
using System.Data.SqlClient; 
using System.Drawing; 
using System.Drawing.Drawing2D; 
using System.Drawing.Imaging; 
using System.Web; 
using System.Configuration; 

//  methods  
public void AddUser(string PersonName, string PersonEmail, string PersonSex, string PersonDOB, string PersonImage, string PersonImageType) 
{ 
string strImageType = userImage.PostedFile.ContentType; 
Stream ImageStream = userImage.PostedFile.InputStream; 

//  watermarking -----------------> 
string wImageFile = Server.MapPath("/bkwww/image/HomeSign.gif"); //  The watermark to be added  
Image sImage = Image.FromStream(ImageStream); //  from  Http  Input stream creation  image 
Image wImage = Image.FromFile(wImageFile); 

//  drawing  
Graphics g = Graphics.FromImage(sImage); 
g.DrawImage(wImage, new Rectangle(0, 0, wImage.Width, wImage.Height), 0, 0, wImage.Width, wImage.Height, GraphicsUnit.Pixel); 

//  Save and will  image  into  byte[] 
MemoryStream ms=new MemoryStream(); 
byte[] myImage=null; 
sImage.Save(ms, ImageFormat.Gif); 
myImage = ms.GetBuffer(); 
//------------------------> 



//  Write to database  
string strConn = ConfigurationSettings.AppSettings["ConnectionString"]; 
SqlConnection myConnection = new SqlConnection(strConn); 
SqlCommand myCommand = new SqlCommand("sp_person_isp", myConnection); 
myCommand.CommandType = CommandType.StoredProcedure; 

myCommand.Parameters.Add("@PersonEmail", SqlDbType.VarChar, 255).Value = PersonEmail; 
myCommand.Parameters.Add("@PersonName", SqlDbType.VarChar, 255).Value = PersonName; 
myCommand.Parameters.Add("@PersonSex", SqlDbType.Char, 1); 
if(sexMale.Checked) 
myCommand.Parameters["@PersonSex"].Value = "M"; 
else 
myCommand.Parameters["@PersonSex"].Value = "F"; 
myCommand.Parameters.Add("@PersonDOB", SqlDbType.DateTime).Value = PersonDOB; 
myCommand.Parameters.Add("@PersonImage", SqlDbType.Image).Value = myImage; 
myCommand.Parameters.Add("@PersonImageType", SqlDbType.VarChar, 255).Value = ImageType; 

try 
{ 
myConnection.Open(); 
myCommand.ExecuteNonQuery(); 
myConnection.Close(); 
Response.Write(" Add success! "); 
} 
catch(System.Exception SqlEx) 
{ 
Response.Write(" Add failed! "+SqlEx.ToString()); 
} 
}

Related articles: