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