protected void Button1_Click(object sender, EventArgs e)
{
AdminDomain adminDomain = new AdminDomain();
AdminDAO adminDAO = new AdminDAO();
PictureBA pictureBA = new PictureBA();
string filePath = FileUpload1.PostedFile.FileName;
Stream fileStream = FileUpload1.PostedFile.InputStream;
adminDomain.setTitle(title.Text);
adminDomain.setPictureType(pictureBA.pictureType(filePath));
adminDomain.setPicture(pictureBA.pictureToByte(fileStream));
adminDAO.uploadImage(adminDomain);
}
public AdminDomain getHomePageImage()
{
SqlConnection mySqlConnection = sqlQueryConn.getSqlConnection();
AdminDomain adminDomain = new AdminDomain();
string query = "SELECT * FROM [admin_image] where id = 1";
using (mySqlConnection)
{
SqlCommand cmd = new SqlCommand(query, mySqlConnection);
mySqlConnection.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
adminDomain.setId((int)rdr["id"]);
adminDomain.setTitle(rdr["name"].ToString());
adminDomain.setPicture((byte[])rdr["image"]);
adminDomain.setPictureType(rdr["image_type"].ToString());
}
rdr.Close();
}
return adminDomain;
}
public void uploadImage(AdminDomain AdminDomain)
{
SqlConnection mySqlConnection = sqlQueryConn.getSqlConnection();
mySqlConnection.Open();
string query = "INSERT INTO [admin_image] (name, image, image_type) VALUES (@name, @image, @type)";
try
{
SqlCommand cmd = new SqlCommand(query, mySqlConnection);
cmd.Parameters.Add("name", SqlDbType.NChar).Value = AdminDomain.getTitle();
cmd.Parameters.Add("image", SqlDbType.VarBinary).Value = AdminDomain.getPicture();
cmd.Parameters.Add("type", SqlDbType.NChar).Value = AdminDomain.getPictureType();
cmd.ExecuteNonQuery();
}
catch (System.IO.IOException e)
{
}
finally
{
mySqlConnection.Close();
}
}