//Add new Gallery image and info
protected void lnkaddImage_Click(object sender, EventArgs e)
{
try
{
string ImageDescription = txtdescription.Text.Trim();
if (ImageDescription == "")
{
lblmsg.Text = "*Please Enter Image Description";
}
else if (fufImage.HasFiles == false)
{
lblmsg.Text = " *Please select a file to upload";
}
else
{
foreach (var file in fufImage.PostedFiles)
{
ImageInfoData data = new ImageInfoData();
data.ImageName = file.FileName;
data.ImageExtension = file.FileName.Substring(file.FileName.LastIndexOf('.'));
data.ImageSize = file.ContentLength;
data.ImageType = file.ContentType;
data.ImageDescription = ImageDescription;
// only .jpeg or .png imgaes are allowed to upload
if (file.ContentType == "image/jpeg" || file.ContentType == "image/png")
{
System.Drawing.Image img = System.Drawing.Image.FromStream(file.InputStream);
int height = img.Height;
int width = img.Width;
if (height == 440 && width == 640) // images with specified dimensions to be uploaded
{
int id = new ImageInfoAction().AddPhoto(data); //Method calling to add galley image and info
if (id != 0)
{
string path = Server.MapPath("~/Image/Gallery/" + data.ImageSize + data.ImageName);
file.SaveAs(path);
ViewImages();
txtdescription.Text = "";
lblmsg.Text = " *Files is Uploaded! ";
}
}
else
{
lblmsg.Text = "Please choose image(s) in proper dimensions 640 x 440";
}
}
else
{
lblmsg.Text = "Please choose a .JPEG or .PNG file only";
}
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
public Image ConvertFromImageInfoDataToImage(ImageInfoData imageInfoData)
{
Image image = new Image
{
AuctionId = imageInfoData.AuctionId,
FileName = imageInfoData.FileName,
Description = imageInfoData.Description,
};
return(image);
}
/// <summary>
/// Get images from database.
/// </summary>
/// <param name="auctionId"></param>
/// <returns></returns>
public List <ImageInfoData> GetImages(int auctionId)
{
//Set isolation level
var options = new TransactionOptions
{
IsolationLevel = IsolationLevel.ReadCommitted
};
// SQL query
string getAuctions = "SELECT * FROM Image WHERE Auction_Id = @auctionId";
//Create auctions list to return.
List <ImageInfoData> images = new List <ImageInfoData>();
//Create transaction.
using (var scope = new TransactionScope(TransactionScopeOption.Required, options))
{
using (var conn = new SqlConnection(_connectionString))
{
try
{
//Open connection to database.
conn.Open();
using (var cmdGAuctions = new SqlCommand(getAuctions, conn))
{
cmdGAuctions.Parameters.AddWithValue("auctionId", auctionId);
SqlDataReader reader = cmdGAuctions.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ImageInfoData imageInfoData = ToImageInfoObject(reader.GetInt32(1), reader.GetString(2), reader.GetDateTime(3),
reader.GetString(4), reader.GetString(5));
images.Add(imageInfoData);
}
}
reader.Close();
}
//If everything went well, will commit.
scope.Complete();
}
catch (TransactionAbortedException e)
{
throw e;
}
finally
{
scope.Dispose();
}
}
}
return(images);
}
// Add Image to Gallery
protected void lnkaddTest_Click(object sender, EventArgs e)
{
try
{
string CategoryId = ddlCategory.SelectedValue;
if (CategoryId.Contains("-1"))
{
lblmsg.Text = "*Category is required!";
}
else if (fuImage.HasFiles == false)
{
lblmsg.Text = " *Image is required!";
}
else
{
foreach (var file in fuImage.PostedFiles)
{
ImageInfoData data = new ImageInfoData();
data.ImageName = file.FileName;
data.ImageExtension = file.FileName.Substring(file.FileName.LastIndexOf('.'));
data.ImageSize = file.ContentLength;
data.ImageType = file.ContentType;
data.CategoryId = int.Parse(CategoryId);
//Only images of .jpeg, .jpg and .png type are allowed
if (file.ContentType == "image/jpeg" || file.ContentType == "image/jpg" || file.ContentType == "image/png")
{
int id = new ImageInfoAction().AddPhoto(data);
if (id != 0)
{
string path = Server.MapPath("~/Admin/Gallery/" + data.ImageName);
file.SaveAs(path);
ViewImages();
ddlCategory.SelectedIndex = 0;
lblmsg.Text = " *Tattoo image added! ";
}
}
else
{
lblmsg.Text = "Please choose a .JPEG or .PNG image only";
}
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
/// <summary>
/// Makes an object of ImageInfoData.
/// </summary>
/// <returns>ImageInfoData</returns>
private ImageInfoData ToImageInfoObject(int auctionId, string imgUrl, DateTime dateAdded,
string description, string fileName)
{
ImageInfoData imageInfoData = new ImageInfoData
{
AuctionId = auctionId,
ImgUrl = imgUrl,
DateAdded = dateAdded,
Description = description,
FileName = fileName
};
return(imageInfoData);
}
public int AddPhoto(ImageInfoData idata)
{
crazyTattoosEntities apData = new crazyTattoosEntities();
ImageInfo data = new ImageInfo();
data.ImageName = idata.ImageName;
data.ImageExtension = idata.ImageName.Substring(idata.ImageName.LastIndexOf('.'));
data.ImageSize = idata.ImageSize;
data.ImageType = idata.ImageType;
data.CategoryId = idata.CategoryId;
apData.ImageInfoes.Add(data);
int ans = apData.SaveChanges();
return(ans);
}
//Add Gallery images
public int AddPhoto(ImageInfoData idata)
{
NZEduEntities apData = new NZEduEntities();
ImageInfo data = new ImageInfo();
data.ImageName = idata.ImageName;
data.ImageExtension = idata.ImageName.Substring(idata.ImageName.LastIndexOf('.'));
data.ImageSize = idata.ImageSize;
data.ImageType = idata.ImageType;
data.ImageDescription = idata.ImageDescription;
apData.ImageInfoes.Add(data);
int ans = apData.SaveChanges();
return(ans);
}
