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);
}
