public List<FileModel> getMyDocsModel() { List<FileModel> modelList = new List<FileModel>(); try { var allFiles = from filetabel in db.DX_FILES where filetabel.ownerid == SessionKeyMgmt.UserId && filetabel.isarchived == false select filetabel; if (null != allFiles && allFiles.ToList().Count >= 1) { foreach (DX_FILES file in allFiles) { DX_FILEVERSION fileversion = db.DX_FILEVERSION.Single(versionObj => versionObj.fileid == file.fileid && versionObj.versionnumber == file.latestversion); FileModel filemodel = new FileModel(); filemodel.FileID = file.fileid.ToString(); filemodel.FileName = file.filename; filemodel.Owner = file.ownerid; filemodel.CreationDate = file.creationdate.ToString(); filemodel.Description = fileversion.description; filemodel.FileVersion = file.latestversion; filemodel.LockedBy = file.lockedby; filemodel.IsLocked = (bool)file.islocked; modelList.Add(filemodel); } } else { ModelState.AddModelError("", "No Files available for view"); } } catch (Exception) { ModelState.AddModelError("", "Error getting the document list"); } return modelList; }
private List<FileModel> getArchivedDocsModel() { List<FileModel> model = new List<FileModel>(); try { var archivedfiles = from filetable in db.DX_FILES where filetable.isarchived == true && filetable.ownerid == SessionKeyMgmt.UserId select filetable; if (archivedfiles != null && archivedfiles.ToList().Count > 0) { foreach (DX_FILES file in archivedfiles) { DX_FILEVERSION fileversion = db.DX_FILEVERSION.Single(versionObj => versionObj.fileid == file.fileid && versionObj.versionnumber == file.latestversion); FileModel archfile = new FileModel(); archfile.FileID = (file.fileid).ToString(); archfile.FileName = file.filename; archfile.FileVersion = file.latestversion; archfile.Description = fileversion.description; archfile.CreationDate = (file.creationdate).ToString(); model.Add(archfile); } } else { ModelState.AddModelError("", "No files have been archived by you"); } } catch { ModelState.AddModelError("", "Error getting the archived documents"); } return model; }
private List<FileModel> getDeptDocsModel(string dept) { int deptid = DbCommonQueries.getDepartmentId(dept, db); List<FileModel> modelList = new List<FileModel>(); try { //get all the files for the current user which he has inherited. var files = from filetable in db.DX_FILES join userprev in db.DX_PRIVILEGE on filetable.fileid equals userprev.fileid where userprev.userid == SessionKeyMgmt.UserId && userprev.reason=="inherit" select filetable; //filter the files based the department requested var allFiles = from fileTable in files join userdept in db.DX_USERDEPT on fileTable.ownerid equals userdept.userid where userdept.deptid == deptid select fileTable; //if no files exist, throw an error. if (null != allFiles && allFiles.ToList().Count >= 1) { foreach (DX_FILES file in allFiles) { DX_FILEVERSION fileversion = db.DX_FILEVERSION.Single(versionObj => versionObj.fileid == file.fileid && versionObj.versionnumber == file.latestversion); FileModel filemodel = new FileModel(); filemodel.FileID = file.fileid.ToString(); filemodel.FileName = file.filename; filemodel.Owner = file.ownerid; filemodel.CreationDate = file.creationdate.ToString(); filemodel.Description = fileversion.description; filemodel.FileVersion = file.latestversion; filemodel.IsLocked = Convert.ToBoolean(file.islocked); filemodel.LockedBy = file.lockedby; modelList.Add(filemodel); } } else { ModelState.AddModelError("", "No Department Files available for view"); } } catch (Exception ex) { ModelState.AddModelError("", "Error getting the department document list " + ex.Message); } return modelList; }
public ActionResult ArchivedFiles() { List<FileModel> modelList = new List<FileModel>(); try { var allFiles = from filetabel in db.DX_FILES where filetabel.ownerid == SessionKeyMgmt.UserId && filetabel.isarchived==true select filetabel; if (null != allFiles && allFiles.ToList().Count >= 1) { foreach (DX_FILES file in allFiles) { //what is ur strategy to get the latest version of the files // For the current file, get details about the latest version DX_FILEVERSION fileversion = db.DX_FILEVERSION.Single(versionObj => versionObj.fileid == file.fileid && versionObj.versionnumber == file.latestversion); FileModel filemodel = new FileModel(); filemodel.FileID = file.fileid.ToString(); filemodel.FileName = file.filename; filemodel.Owner = file.ownerid; filemodel.CreationDate = file.creationdate.ToString(); filemodel.Description = fileversion.description; filemodel.FileVersion = file.latestversion; filemodel.IsLocked = Convert.ToBoolean(file.islocked); filemodel.LockedBy = file.lockedby; modelList.Add(filemodel); } return View("ArchivedFiles", modelList); } else { ModelState.AddModelError("", "No Files available for view"); } return View("ArchivedFiles", modelList); } catch (Exception ex) { ModelState.AddModelError("", "Error getting the document list " + ex.Message); } return View("ArchivedFiles", modelList); }