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; }