public string saveImage(ImageFile imageUp)
{
try
{
using (EventrixDBDataContext db = new EventrixDBDataContext())
{
var query = from image in db.GuestImages where image.GuestImageId.Equals(imageUp.ImageId) select image;
if (query.Count() == 0)
{
GuestImage fileToSave = new GuestImage();
fileToSave.Name = imageUp.ImageName;
fileToSave.Location = imageUp.Location;
fileToSave.Size = (int)imageUp.FileSize;
fileToSave.DateUploaded = imageUp.DateUploaded;
fileToSave.ContentType = imageUp.ContentType;
fileToSave.G_ID = Convert.ToInt32(imageUp.EventID);
db.GuestImages.InsertOnSubmit(fileToSave);
db.SubmitChanges();
}
else if (query.Count() == 1)
{
return("File Exist");
}
}
return("Success File Uploaded");
}
catch (NullReferenceException ex)
{
return(ex.Message);
}
catch (Exception)
{
return("Failed Upload Failed");
}
}
//Edit Profile picture from the client directory & WCF database
public string editProfilePic(string guestId, string ImageName, string fileSize, string location, string fileExtention)
{
int _id = Convert.ToInt32(guestId);
GuestImage fileToSave = null;
string response = "";
try
{
using (EventrixDBDataContext db = new EventrixDBDataContext())
{
var query = from image in db.GuestImages where image.G_ID == _id select image;
foreach (GuestImage img in query)
{
fileToSave = img;
}
fileToSave.Name = ImageName;
fileToSave.Location = "Prototype_TNT_Der1/Prototype_TNT_Der1/Events/" + _id + "/Profile_Pic/" + location;
fileToSave.Size = Convert.ToInt32(fileSize);
fileToSave.DateUploaded = DateTime.Now.ToString();
fileToSave.ContentType = fileExtention;
fileToSave.G_ID = Convert.ToInt32(_id);
if (query.Count() == 1)
{
db.SubmitChanges();
response = "Success File Uploaded";
}
else if (query.Count() == 0)
{
response = "User Image Not Found";
}
return(response);
}
}
catch (NullReferenceException ex)
{
return(ex.Message);
}
catch (Exception)
{
return("Failed Upload Failed");
}
}
