public void InsertImage()
{
Images2 aImage = new Images2();
aImage.ImageName = imageNameTextBox.Text;
aImage.Description = descriptionTextBox.Text;
if (imageFileUpload.HasFile)
{
string extension = System.IO.Path.GetExtension(imageFileUpload.FileName);
if (extension.ToLower() != ".png" && extension.ToLower() != ".jpg" && extension.ToLower() != ".jpeg")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Popup", "alert('Invalid image formet');", true);
}
else
{
aImage.ImagePath = "ImageStore/" + Path.GetFileName(imageFileUpload.PostedFile.FileName);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Popup", "alert('Select Image file');", true);
}
String message = aImageManager.InsertImage(aImage);
imageFileUpload.SaveAs(Server.MapPath("~/ImageStore/" + imageFileUpload.FileName));
ScriptManager.RegisterStartupScript(this, this.GetType(), "Popup", "alert('" + message + "');", true);
// GetAllImage();
imageNameTextBox.Text = String.Empty;
descriptionTextBox.Text = String.Empty;
}
public string InsertImage(Images2 image)
{
int message = aImageGateway.InsertImage(image);
if (message > 0)
{
return("Image saved Successfully.");
}
else
{
return("Opps !!!!! Error Image is not save");
}
}
public int InsertImage(Images2 image)
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "INSERT INTO tbl_Image VALUES('" + image.ImageName + "', '" + image.ImagePath + "', '" + image.Description + "')";
//insert image
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public List <Images2> GetAllImage()
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "SELECT * FROM tbl_Image";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader aReader = command.ExecuteReader();
List <Images2> aImageList = new List <Images2>();
while (aReader.Read())
{
Images2 aImage = new Images2();
aImage.ImageName = aReader["ImageName"].ToString();
aImage.ImagePath = aReader["Image"].ToString();
aImage.Description = aReader["Discription"].ToString();
aImageList.Add(aImage);
}
aReader.Close();
connection.Close();
return(aImageList);
}
