private int InsertBlobToFileLocationStorage(BlobModel blobModel, string type)
{
FileLocationStorage locStorage = new FileLocationStorage()
{
DateAdded = DateTime.Now,
FileLocation = blobModel.FileURI,
FileName = blobModel.FileName,
Type = type.ToUpper()
};
dbObject.FileLocationStorages.Add(locStorage);
dbObject.SaveChanges();
return(locStorage.FileID);
}
/*
* Deletes the selected the image of an announcement and deletes it from database and the azure blob storage.
* */
public ActionResult RemoveAnnouncementBlob(string file, int?fileID)
{
try
{
if (User.IsInRole("Administrator"))
{
if (file == null || fileID == null)
{
return(RedirectToAction("Announcement", "WebsiteContent"));
}
else
{
if (websiteActions.DeleteAnnouncementFile(file)) //para kung hindi nabura yung image, hindi na buburahin sa database
{
AnnouncementResource announcementResource = websiteActions.GetAnnouncementResourceByFileID((int)fileID);
websiteActions.DeleteFromAnnouncementResources(announcementResource);
FileLocationStorage fileLocationStorage = websiteActions.GetFileLocationStorageByFileID((int)fileID);
websiteActions.DeleteFromFileLocationStorage(fileLocationStorage);
return(RedirectToAction("Announcements", "Admin"));
}
else
{
TempData["errorMessage"] = "There was an error in the server. Please try again";
return(RedirectToAction("Announcement", "WebsiteContent"));
}
//actions2.DeleteAnnouncementFile(file);
}
}
else
{
TempData["errorMessage"] = "Sorry you do not have access.";
return(RedirectToAction("Announcement", "WebsiteContent"));
}
}
catch (Exception e)
{
TempData["errorMessage"] = "There was an error in removing the photo you have selected.";
return(RedirectToAction("Announcement", "WebsiteContent"));
}
}
/*
* Deletes the selected uploaded requiremensts from the database and azure blob storage.
* */
public ActionResult DeleteRequestBlob(string fileName, int?fileID)
{
try
{
if (User.IsInRole("Student"))
{
if (fileName == null || fileID == null)
{
return(RedirectToAction("RequestStatus"));
}
else
{
if (studentActions.DeleteRequestBlob(fileName))
{
RequestResource requestResource = studentActions.GetRequestResourceByFileID((int)fileID);
studentActions.DeleteFromRequestResource(requestResource);
FileLocationStorage fileLocationStorage = studentActions.GetFileLocationStorageByFileID((int)fileID);
studentActions.DeleteFromFileLocationStorage(fileLocationStorage);
return(RedirectToAction("EditRequest", new { requestID = requestResource.RequestID }));
}
TempData["errorMessage"] = "There was an error in the server. Please try again.";
return(RedirectToAction("RequestStatus"));
}
}
else
{
TempData["errorMessage"] = "Sorry you do not have access.";
return(RedirectToAction("Announcement", "WebsiteContent"));
}
}
catch (Exception e)
{
TempData["errorMessage"] = "There was an error in deletings. Please try again, thank you!";
return(RedirectToAction("RequestStatus"));
}
}
/*
* Removes a selected a file from an uploaded downloadable form. And deletes from the database.
* */
public ActionResult RemoveFormBlob(string fileName, int?fileID)
{
try
{
if (User.IsInRole("Administrator"))
{
if (fileName == null || fileID == null)
{
return(RedirectToAction("DownloadableForms"));
}
else
{
if (websiteActions.DeleteFormFile(fileName))
{
FormsResource formResource = websiteActions.GetFormResourceByFileID((int)fileID);
websiteActions.DeleteFromFormResource(formResource);
FileLocationStorage fileLocationStorage = websiteActions.GetFileLocationStorageByFileID((int)fileID);
websiteActions.DeleteFromFileLocationStorage(fileLocationStorage);
return(RedirectToAction("Forms", "Admin"));
}
TempData["errorMessage"] = "There was an error in the server. Please try again.";
return(RedirectToAction("Forms", "Admin"));
}
}
else
{
TempData["errorMessage"] = "Sorry you do not have access.";
return(RedirectToAction("DownloadableForms", "WebsiteContent"));
}
}
catch (Exception e)
{
TempData["errorMessage"] = "There was an error in deleting the form";
return(RedirectToAction("DownloadableForms", "WebsiteContent"));
}
}
/*
* Deletes the whole downloadable form from the database including the file.
* */
public ActionResult DeleteForm(int?formID)
{
try
{
if (User.IsInRole("Administrator"))
{
if (formID == null)
{
return(RedirectToAction("DownloadableForms", "WebsiteContent"));
}
else
{
Form form = websiteActions.GetFormByID((int)formID);
FormsResource formResource = form.FormsResources.Where(model => model.FormID == formID).FirstOrDefault();
FileLocationStorage fileLocationStorage = websiteActions.GetFileLocationStorageByFileID(formResource.FileID);
if (websiteActions.DeleteFormFile(fileLocationStorage.FileName))
{
websiteActions.DeleteFromFormResource(formResource);
websiteActions.DeleteFromFileLocationStorage(fileLocationStorage);
websiteActions.DeleteFromForms(form);
}
return(RedirectToAction("Forms", "Admin"));
}
}
else
{
TempData["errorMessage"] = "Sorry you do not have access.";
return(RedirectToAction("DownloadableForm", "WebsiteContent"));
}
}
catch (Exception e)
{
TempData["errorMessage"] = "There was an error in deleting the form.";
return(RedirectToAction("DownloadableForms", "WebsiteContent"));
}
}
public void DeleteFromFileLocationStorage(FileLocationStorage fileLocationStorage)
{
dbObject.FileLocationStorages.Remove(fileLocationStorage);
dbObject.SaveChanges();
}