public ActionResult deleteFolder(int fID)
{
FolderDAO.DeleteFolder(fID);
return(Redirect("~/Users/Folder"));
}
public void DeleteFolderTest()
{
// FolderDAO.DeleteFolder(1);
var folder = FolderDAO.GetFolder(1);
Assert.IsNull(folder, "Папка не удалена");
}
public void SaveOrUpdateFolderTest()
{
SecurityContext.AuthenticateMe("*****@*****.**", "111111");
var commonDocumentsID = FolderDAO.GetFolderIDCommon(false);
object folderID = 0;
DemoData.ListFolders[0].ParentFolderID = commonDocumentsID;
DemoData.ListFolders[1].ParentFolderID = commonDocumentsID;
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[0]);
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[1]);
DemoData.ListFolders[2].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[2]);
DemoData.ListFolders[3].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[3]);
DemoData.ListFolders[4].ParentFolderID = commonDocumentsID;
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[4]);
DemoData.ListFolders[5].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[5]);
DemoData.ListFolders[6].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[6]);
DemoData.ListFolders[7].ParentFolderID = commonDocumentsID;
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[7]);
DemoData.ListFolders[8].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[8]);
DemoData.ListFolders[9].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[9]);
DemoData.ListFolders[10].ParentFolderID = commonDocumentsID;
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[10]);
DemoData.ListFolders[11].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[11]);
DemoData.ListFolders[12].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[12]);
DemoData.ListFolders[13].ParentFolderID = folderID;
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[13]);
DemoData.ListFolders[14].ParentFolderID = folderID;
folderID = FolderDAO.SaveFolder(DemoData.ListFolders[14]);
DemoData.ListFolders[15].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[15]);
DemoData.ListFolders[16].ParentFolderID = folderID;
FolderDAO.SaveFolder(DemoData.ListFolders[16]);
Console.WriteLine(folderID);
}
public ActionResult openFolder2(int pId)
{
int p = FolderDAO.getParentFolderid(pId);
Session["prevPid"] = p;
Session["pid"] = p;
Session["folderName"] = FolderDAO.getFoldernameByid(p);
return(Redirect("~/Users/Folder"));
}
public AllVideoViewModel(FolderDAO folderDAO, FileDAO fileDAO, SettingDAO settingDAO)
{
this.folderDAO = folderDAO;
this.fileDAO = fileDAO;
this.GeneralSetting = settingDAO.SettingCache.General;
this.CreateModels();
this.CreateCommands();
this.RegisterMessages();
}
public List <Folder> GetAll(int userId, int parentFolderId = -1)
{
FolderDAO folderDAO = new FolderDAO();
var folders = folderDAO.GetAll();
var activeAndRootFolders = (from folder in folders
where folder.IsActive == true && folder.ParentFolderId == parentFolderId && folder.CreatedBy == userId
select folder).ToList <Folder>();
return(activeAndRootFolders);
}
public TaxonomyService(string context)
{
// TODO: REFACTOR
this._familyDAO = new FamilyDAO(context);
this._genusDAO = new GenusDAO(context);
this._speciesDAO = new SpeciesDAO(context);
this._cropForCwrDAO = new CropForCwrDAO(context);
this._cwrMapDAO = new CwrMapDAO(context);
this._cwrTraitDAO = new CwrTraitDAO(context);
this._folderDAO = new FolderDAO(context);
this._citationDAO = new CitationDAO(context);
this._referenceDAO = new ReferenceDAO(context);
this._regulationDAO = new RegulationDAO(context);
this._reportDAO = new ReportDAO(context);
}
public TaxonomyService(string context)
{
this._familyDAO = new FamilyDAO(context);
this._genusDAO = new GenusDAO(context);
this._speciesDAO = new SpeciesDAO(context);
this._cropForCwrDAO = new CropForCwrDAO(context);
this._cwrMapDAO = new CwrMapDAO(context);
this._cwrTraitDAO = new CwrTraitDAO(context);
this._folderDAO = new FolderDAO(context);
this._authorDAO = new AuthorDAO(context);
this._citationDAO = new CitationDAO(context);
this._referenceDAO = new ReferenceDAO(context);
this._regulationDAO = new RegulationDAO(context);
this._reportDAO = new ReportDAO(context);
this.geographyDAO = new GeographyDAO(context);
}
public ActionResult NewFolder()
{
String folderName = Request["folderName"];
FolderDTO f = new FolderDTO();
f.folderName = folderName;
f.createdOn = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
f.parentFolderId = Convert.ToInt32(Session["pid"]);
if (FolderDAO.Save(f) == 1)
{
return(Redirect("~/Users/Home"));
}
return(Redirect("~/Users/Home"));
}
private long GetOrganizationId(long datasetId)
{
long id = 0;
try
{
var folder = new FolderDAO();
id = folder.GetOrganizationIdForFolderId(datasetId);
}
catch (Exception ex)
{
Tracer.Error(
"ExportOption Startup Worker: On beginWork failed to set organization id for job run id:{0}, exception:{1}",
PipelineId, ex);
}
return(id);
}
public void Delete(int id)
{
FolderDAO dao = new FolderDAO();
var folder = dao.GetById(id);
folder.IsActive = false;
folder.Update();
FileDAO fileDAO = new FileDAO();
var allfiles = fileDAO.GetAll();
var files = (from file in allfiles
where file.ParenFolderId == id
select file).ToList <Entities.File>();
foreach (var file in files)
{
file.IsActive = false;
file.Update();
}
}
public CitationDAO(string context)
{
_context = context;
_folderDAO = new FolderDAO(context);
}
public Object DownloadMeta(int id, int userid)
{
FolderDAO folderDAO = new FolderDAO();
FileDAO fileDAO = new FileDAO();
var allfolders = folderDAO.GetAll();
var folders = (from folder in allfolders
where folder.CreatedBy == userid
select folder).ToList();
var allfiles = fileDAO.GetAll();
var files = (from file in allfiles
where file.CreatedBy == userid
select file).ToList();
Folder currentFolder = null;
if (id == -1)
{
currentFolder = new Folder();
currentFolder.Id = -1;
}
else
{
currentFolder = (from folder in folders
where folder.Id == id
select folder).FirstOrDefault();
if (currentFolder == null)
{
return(new HttpResponseMessage(HttpStatusCode.NotFound));;
}
}
Document document = new Document();
Section section = document.AddSection();
TraverseFolders(currentFolder, ref folders, ref files, ref section);
PdfDocumentRenderer pdf = new PdfDocumentRenderer(false, PdfSharp.Pdf.PdfFontEmbedding.Always);
pdf.Document = document;
pdf.RenderDocument();
var rootPath = HttpContext.Current.Server.MapPath("~/UploadedFiles");
var uid = Guid.NewGuid() + ".pdf";
var fileSavePath = Path.Combine(rootPath, uid);
pdf.PdfDocument.Save(fileSavePath);
HttpResponseMessage resp = new HttpResponseMessage(HttpStatusCode.OK);
byte[] fileStream = System.IO.File.ReadAllBytes(fileSavePath);
System.IO.File.Delete(fileSavePath);
System.IO.MemoryStream ms = new MemoryStream(fileStream);
resp.Content = new ByteArrayContent(fileStream);
resp.Content.Headers.ContentDisposition = new System.Net.Http.Headers.ContentDispositionHeaderValue("attachment");
var type = MimeTypeMap.GetMimeType(".pdf");
resp.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue(type);
resp.Content.Headers.ContentDisposition.FileName = "meta-data.pdf";
return(resp);
}
public static int DeleteUser(int fid)
{
return(FolderDAO.DeleteUser(fid));
}
public ActionResult DownloadMeta()
{
int pId = Convert.ToInt32(Request["pid"]);
List <FolderDTO> folders = new List <FolderDTO>();
folders = FolderDAO.GetAllFolders(pId);
List <FolderDTO> tempfolders = new List <FolderDTO>();
foreach (var folder in folders)
{
tempfolders.AddRange(FolderDAO.GetAllFolders(folder.folderId));
}
folders.AddRange(tempfolders);
List <FileDTO> files;
files = FileDAO.GetAllFiles(pId);
List <FileDTO> tempfiles = new List <FileDTO>();
foreach (var file in files)
{
tempfiles.AddRange(FileDAO.GetAllFiles(file.parentFolderId));
}
files.AddRange(tempfiles);
PdfDocument pdf = new PdfDocument();
pdf.Info.Title = "Meta Data";
PdfPage pdfPage = pdf.AddPage();
XGraphics graph = XGraphics.FromPdfPage(pdfPage);
XFont font = new XFont("Times New Roman", 10, XFontStyle.Regular);
int i = 0;
int j = 0;
foreach (var folder in folders)
{
string foldername = FolderDAO.getFoldernameByid(folder.parentFolderId);
if (folder.parentFolderId == 0)
{
foldername = "Root";
}
graph.DrawString("Name: " + folder.folderName.ToString(), font, XBrushes.Black, new XRect(i, j, 250, 220), XStringFormats.TopLeft);
graph.DrawString("Type: FOLDER", font, XBrushes.Black, new XRect(i, j + 10, 250, 220), XStringFormats.TopLeft);
graph.DrawString("Parent: " + foldername, font, XBrushes.Black, new XRect(i, j + 20, 250, 220), XStringFormats.TopLeft);
j = j + 40;
}
foreach (var file in files)
{
string foldername = FolderDAO.getFoldernameByid(file.parentFolderId);
if (file.parentFolderId == 0)
{
foldername = "Root";
}
graph.DrawString("Name: " + file.fileName, font, XBrushes.Black, new XRect(i, j, 250, 220), XStringFormats.TopLeft);
graph.DrawString("Type: FILE", font, XBrushes.Black, new XRect(i, j + 10, 250, 220), XStringFormats.TopLeft);
graph.DrawString("Size: " + file.fileSizeInKb + " KB", font, XBrushes.Black, new XRect(i, j + 20, 250, 220), XStringFormats.TopLeft);
graph.DrawString("Parent: " + foldername, font, XBrushes.Black, new XRect(i, j + 30, 250, 220), XStringFormats.TopLeft);
j = j + 50;
}
string pdfFilename = "MetaData.pdf";
//pdf.Save(pdfFilename);
//var file = pdf;
var ext = ".pdf";
var uniqueName = "MetaData" + ext;
var rootPath = Server.MapPath("~/UploadedFiles");
var fileSavePath = System.IO.Path.Combine(rootPath, uniqueName);
pdf.Save(fileSavePath);
// Session["image"] = uniqueName;
return(Download("MetaData.pdf"));
}
public static int Update(this Folder Folder)
{
FolderDAO dao = new FolderDAO();
return(dao.Update(Folder));
}
public void GetFolderPath()
{
var parts = FolderDAO.GetParentFolders(15);
}
public void MoveFoldersCheck()
{
FolderDAO.CanMoveOrCopy(new object[] { 19 }, 15).ToList().ForEach(item => Console.WriteLine(item));
}
public static int DeleteFolder(int id)
{
return(FolderDAO.DeleteFolder(id));
}
public FolderDAOIntegrationTests(String key) : base(key)
{
dao = new FolderDAO(key);
}
public FolderDAOIntegrationTests() : base()
{
dao = new FolderDAO(_conStringName);
}
public JsonResult detailasjson2(int pId)
{
return(Json(FolderDAO.GetAllFolders2(pId), JsonRequestBehavior.AllowGet));
}
public static int Delete(this Folder Folder)
{
FolderDAO dao = new FolderDAO();
return(dao.Delete(Folder.Id));
}
public static int Save(this Folder Folder)
{
FolderDAO dao = new FolderDAO();
return(dao.Insert(Folder));
}
public void GetFolderByIDTest()
{
var folder = FolderDAO.GetFolder(1);
Console.WriteLine(folder.Title);
}
public void CopyFoldersTest()
{
FolderDAO.CopyFolder(160, 180);
}
public static FolderDTO FindFolderName(String fname, int uid, int pid)
{
return(FolderDAO.FindFolderName(fname, uid, pid));
}
