public ActionResult SelectNewCompetency(string CompetencyID, string searchstring) { try { int RoleID = (int)Session["RoleID"]; AssocieteDriverAndComepetency selectCompetency = new AssocieteDriverAndComepetency(); string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName); selectCompetency.SearchedUserDetails = new SearchedUserDetails(); CommonMethodsDAL Commondal = new CommonMethodsDAL(); selectCompetency.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role); ConfigurationDAL configDAL = new ConfigurationDAL(); List <Competencies> NewSelectCompetency = new List <Competencies>(); if (CompetencyID != "") { string CompetencyIDWithcomma = CompetencyID.TrimEnd(','); string[] CompetencyIDArray = CompetencyIDWithcomma.Split(','); int[] myInts = Array.ConvertAll(CompetencyIDArray, s => int.Parse(s)); NewSelectCompetency = configDAL.getNewSelectCompetency(myInts, RoleID); } else { HRMSDBEntities dbContext = new HRMSDBEntities(); NewSelectCompetency = (from c in dbContext.tbl_PA_Competency_Master select new Competencies { OrderNo = c.OrderNo, CompetencyID = c.CompetencyID, Parameter = c.Competency, Description = c.Description, RoleID = RoleID, Checked = false }).Distinct().ToList(); } if (searchstring != "") { List <Competencies> competencyListwithsearch = NewSelectCompetency.FindAll(x => x.Parameter.ToLower().Contains(searchstring.ToLower())); selectCompetency.CompetencyList = competencyListwithsearch; selectCompetency.RecordsCount = competencyListwithsearch.Count; } else { selectCompetency.CompetencyList = NewSelectCompetency; selectCompetency.RecordsCount = NewSelectCompetency.Count; } return(PartialView("_SelectCompetencies", selectCompetency)); } catch { throw; } }
public ActionResult ShowHistoryRMGDocUploads(int documentId, string uploadType) { HRMSDBEntities dbContext = new HRMSDBEntities(); UploadsDAL uploads = new UploadsDAL(); List <Tbl_RMG_DocumentDetail> objHRDocDetails = new List <Tbl_RMG_DocumentDetail>(); Tbl_RMG_Documents objhRDoc = new Tbl_RMG_Documents(); List <UploadHRDocumentsViewModel> objDocList = new List <UploadHRDocumentsViewModel>(); int uploadTypeId = dbContext.Tbl_HR_UploadType.Where(x => x.UploadType == uploadType).FirstOrDefault().UploadTypeId; try { objhRDoc = uploads.GetRMGDocument(documentId); objHRDocDetails = uploads.GetRMGDocumentHistoryForDisplay(documentId); foreach (Tbl_RMG_DocumentDetail eachDocDetail in objHRDocDetails) { UploadHRDocumentsViewModel dd = new UploadHRDocumentsViewModel() { DocumentID = eachDocDetail.DocumentId, Comments = eachDocDetail.Comments, FileDescription = eachDocDetail.FileDescription, FileName = eachDocDetail.FileName, UploadedBy = uploads.GetUploadNameFromUploadById(HttpContext.User.Identity.Name), UploadedDate = (eachDocDetail.UploadedDate).Value, FilePath = eachDocDetail.FilePath, UploadTypeId = uploadTypeId }; objDocList.Add(dd); } UploadHRDocumentsViewModel dd1 = new UploadHRDocumentsViewModel() { DocumentID = objhRDoc.DocumentId, Comments = objhRDoc.Comments, FileDescription = objhRDoc.FileDescription, FileName = objhRDoc.FileName, UploadedBy = uploads.GetUploadNameFromUploadById(HttpContext.User.Identity.Name), UploadedDate = (objhRDoc.UploadedDate).Value, FilePath = objhRDoc.FilePath, UploadTypeId = uploadTypeId }; objDocList.Add(dd1); return(PartialView("_ShowHRDocHistory", objDocList)); } catch (Exception Ex) { throw Ex; } }
public string GetUploadTypeTextFromDocIdRMG(int documentId) { string uploadTypeText = string.Empty; HRMSDBEntities dbContext = new HRMSDBEntities(); try { var uploadTypeId = (from ut in dbContext.Tbl_RMG_Documents where ut.DocumentId == documentId select ut.UploadTypeId).FirstOrDefault(); uploadTypeText = GetUploadTypeSelectedText(uploadTypeId); return(uploadTypeText); } catch (Exception) { throw; } }
public ActionResult SelectRoles(string roleID) { try { int competencyID = (int)Session["competencyID"]; ApplicableRolesViewModel applicablerole = new ApplicableRolesViewModel(); string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName); applicablerole.SearchedUserDetails = new SearchedUserDetails(); CommonMethodsDAL Commondal = new CommonMethodsDAL(); applicablerole.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role); ConfigurationDAL configDAL = new ConfigurationDAL(); List <ApplicableRole> NewSelectRole = new List <ApplicableRole>(); if (roleID != "") { string roleIDWithcomma = roleID.TrimEnd(','); string[] roleidArray = roleIDWithcomma.Split(','); int[] myInts = Array.ConvertAll(roleidArray, s => int.Parse(s)); NewSelectRole = configDAL.getNewSelectRole(myInts, competencyID); } else { HRMSDBEntities dbContext = new HRMSDBEntities(); NewSelectRole = (from e in dbContext.HRMS_tbl_PM_Role orderby e.RoleDescription ascending select new ApplicableRole { CompetencyID = competencyID, RoleID = e.RoleID, Role = e.RoleDescription }).ToList(); } applicablerole.ApplicableRoles = NewSelectRole; return(PartialView("_SelectRoles", applicablerole)); } catch { throw; } }
public ActionResult DeleteRMGUploadDetails(int documentId) { UploadsDAL uploads = new UploadsDAL(); HRMSDBEntities dbContext = new HRMSDBEntities(); bool udd = false; try { var parentDoc = dbContext.Tbl_RMG_Documents.Where(x => x.DocumentId == documentId).FirstOrDefault(); var versionDocs = dbContext.Tbl_RMG_DocumentDetail.Where(x => x.DocumentId == documentId).ToList(); string rootFolder = (UploadFileLocationRMG); string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocIdRMG(parentDoc.DocumentId)); if (versionDocs != null) { foreach (var d in versionDocs) { string versionDocFilepath = Path.Combine(subfolderpath, d.FileName); if (System.IO.File.Exists(versionDocFilepath)) { System.IO.File.Delete(versionDocFilepath); } } } string Filepath = Path.Combine(subfolderpath, parentDoc.FileName); if (System.IO.File.Exists(Filepath)) { System.IO.File.Delete(Filepath); } udd = uploads.DeleteRMGUploadDetails(documentId); return(Json(udd, JsonRequestBehavior.AllowGet)); } catch (Exception) { udd = false; return(Json(udd, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Action will fire when user clicks on the Filename,to download the file, /// when viewing the history/Details view of files /// </summary> /// <param name="filename"></param> /// <returns></returns> public ActionResult DownloadHRFile(string filename, int uploadTypeId) { HRMSDBEntities dbContext = new HRMSDBEntities(); UploadsDAL RMGupload = new UploadsDAL(); string Loginemployeecode = string.Empty; string[] loginemployeerole = { }; EmployeeDAL empdal = new EmployeeDAL(); int employeeID = empdal.GetEmployeeID(Membership.GetUser().UserName); HRMS_tbl_PM_Employee loginrolescheck = empdal.GetEmployeeDetails(employeeID); Loginemployeecode = loginrolescheck.EmployeeCode; loginemployeerole = Roles.GetRolesForUser(Loginemployeecode); try { if (loginemployeerole.Contains("RMG")) { var documentformchild = (from document in dbContext.Tbl_RMG_Documents join documentDetails in dbContext.Tbl_RMG_DocumentDetail on document.DocumentId equals documentDetails.DocumentId where document.UploadTypeId == uploadTypeId && documentDetails.FileName == filename select documentDetails).FirstOrDefault(); var documentfromparent = (from document in dbContext.Tbl_RMG_Documents where document.UploadTypeId == uploadTypeId && document.FileName == filename select document).FirstOrDefault(); string rootFolder = (UploadFileLocationRMG); string[] FileExtention = filename.Split('.'); string contentType = "application/" + FileExtention[1]; if (documentformchild != null) { string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocIdRMG(documentformchild.DocumentId)); string Filepath = Path.Combine(subfolderpath, filename); if (!System.IO.File.Exists(Filepath)) { throw new Exception(); } return(File(Filepath, contentType, filename)); } else { string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocIdRMG(documentfromparent.DocumentId)); string Filepath = Path.Combine(subfolderpath, filename); if (!System.IO.File.Exists(Filepath)) { throw new Exception(); } return(File(Filepath, contentType, filename)); } } else { var documentformchild = (from document in dbContext.Tbl_HR_Documents join documentDetails in dbContext.Tbl_HR_DocumentDetail on document.DocumentId equals documentDetails.DocumentId where document.UploadTypeId == uploadTypeId && documentDetails.FileName == filename select documentDetails).FirstOrDefault(); var documentfromparent = (from document in dbContext.Tbl_HR_Documents where document.UploadTypeId == uploadTypeId && document.FileName == filename select document).FirstOrDefault(); string rootFolder = (UploadFileLocation); string[] FileExtention = filename.Split('.'); string contentType = "application/" + FileExtention[1]; if (documentformchild != null) { string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocId(documentformchild.DocumentId)); string Filepath = Path.Combine(subfolderpath, filename); if (!System.IO.File.Exists(Filepath)) { throw new Exception(); } return(File(Filepath, contentType, filename)); } else { string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocId(documentfromparent.DocumentId)); string Filepath = Path.Combine(subfolderpath, filename); if (!System.IO.File.Exists(Filepath)) { throw new Exception(); } return(File(Filepath, contentType, filename)); } } } catch (Exception) { ConfigurationViewModel model = new ConfigurationViewModel(); model.SearchedUserDetails = new SearchedUserDetails(); string employeeCode = Membership.GetUser().UserName; string[] role = Roles.GetRolesForUser(employeeCode); if (employeeCode != null) { CommonMethodsDAL Commondal = new CommonMethodsDAL(); model.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role); } return(PartialView("_FileNotFound", model)); } }
/// <summary> /// / /// </summary> /// <param name="documentId"></param> /// <returns></returns> public ActionResult DeleteHRDocsSelected(List <string> filenames) { UploadsDAL uploads = new UploadsDAL(); HRMSDBEntities dbContext = new HRMSDBEntities(); string Loginemployeecode = string.Empty; string[] loginemployeerole = { }; EmployeeDAL empdal = new EmployeeDAL(); int employeeID = empdal.GetEmployeeID(Membership.GetUser().UserName); HRMS_tbl_PM_Employee loginrolescheck = empdal.GetEmployeeDetails(employeeID); Loginemployeecode = loginrolescheck.EmployeeCode; loginemployeerole = Roles.GetRolesForUser(Loginemployeecode); bool result = false; try { if (loginemployeerole.Contains("RMG")) { if (filenames != null) { foreach (string filename in filenames) { var documentformchild = (from document in dbContext.Tbl_RMG_Documents join documentDetails in dbContext.Tbl_RMG_DocumentDetail on document.DocumentId equals documentDetails.DocumentId where documentDetails.FileName == filename select documentDetails).FirstOrDefault(); string rootFolder = (UploadFileLocationRMG); string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocIdRMG(documentformchild.DocumentId)); string Filepath = Path.Combine(subfolderpath, filename); if (System.IO.File.Exists(Filepath)) { System.IO.File.Delete(Filepath); } result = uploads.DeleteRMGDocsSelected(filename); } } return(Json(result, JsonRequestBehavior.AllowGet)); } else { if (filenames != null) { foreach (string filename in filenames) { var documentformchild = (from document in dbContext.Tbl_HR_Documents join documentDetails in dbContext.Tbl_HR_DocumentDetail on document.DocumentId equals documentDetails.DocumentId where documentDetails.FileName == filename select documentDetails).FirstOrDefault(); string rootFolder = (UploadFileLocation); string subfolderpath = Path.Combine(rootFolder, GetUploadTypeTextFromDocId(documentformchild.DocumentId)); string Filepath = Path.Combine(subfolderpath, filename); if (System.IO.File.Exists(Filepath)) { System.IO.File.Delete(Filepath); } result = uploads.DeleteHRDocsSelected(filename); } } return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception) { result = false; return(Json(result, JsonRequestBehavior.AllowGet)); } }