// Involve namespace
using System;
using ;
using ;
using ;
using ;
using ;
using .Drawing2D;
using ;
using ;
using ;
// method
public void AddUser(string PersonName, string PersonEmail, string PersonSex, string PersonDOB, string PersonImage, string PersonImageType)
{
string strImageType = ;
Stream ImageStream = ;
// Add watermark -------------------------->
string wImageFile = ("/bkwww/image/"); // The watermark image to be added
Image sImage = (ImageStream); // Create image from Http input stream
Image wImage = (wImageFile);
// Drawing
Graphics g = (sImage);
(wImage, new Rectangle(0, 0, , ), 0, 0, , , );
// Save and convert image to byte[]
MemoryStream ms=new MemoryStream();
byte[] myImage=null;
(ms, );
myImage = ();
//------------------------>
// Write to the database
string strConn = ["ConnectionString"];
SqlConnection myConnection = new SqlConnection(strConn);
SqlCommand myCommand = new SqlCommand("sp_person_isp", myConnection);
= ;
("@PersonEmail", , 255).Value = PersonEmail;
("@PersonName", , 255).Value = PersonName;
("@PersonSex", , 1);
if()
["@PersonSex"].Value = "M";
else
["@PersonSex"].Value = "F";
("@PersonDOB", ).Value = PersonDOB;
("@PersonImage", ).Value = myImage;
("@PersonImageType", , 255).Value = ImageType;
try
{
();
();
();
("Add successfully!");
}
catch( SqlEx)
{
("Add failed!" +());
}
}