//Import attachment file
private void ImportContractAttachment(List <string> fileList, string resurceType, Guid contractGuid, Guid resourceGuid, bool isDelete)
{
var destinationPath = string.Empty;
foreach (var item in fileList)
{
var folder = _documentManagementService.GetFolderByKey("Contract", contractGuid, resurceType);
var contractResourceFile = _contractResourceFileService.GetFilePathByResourceIdAndKeys(resurceType, contractGuid);
if (contractResourceFile != null)
{
destinationPath = rootPath + contractResourceFile.FilePath + "/";
var fileSize = new System.IO.FileInfo(item).Length.ToString();
var outPutPath = _importFileService.MoveAttachment(item, destinationPath, isDelete);
if (!string.IsNullOrWhiteSpace(outPutPath))
{
var isCSV = Path.GetExtension(item) == ".csv" ? true : false;
ContractResourceFile contractFile = new ContractResourceFile();
contractFile.ContractResourceFileGuid = Guid.NewGuid();
contractFile.ResourceGuid = contractGuid;
contractFile.CreatedBy = loggedUser;
contractFile.CreatedOn = DateTime.UtcNow;
contractFile.Keys = resurceType;
contractFile.IsActive = true;
contractFile.IsCsv = isCSV;
contractFile.IsDeleted = false;
contractFile.UpdatedBy = loggedUser;
contractFile.UpdatedOn = DateTime.Now;
contractFile.ContentResourceGuid = resourceGuid;
contractFile.IsFile = true;
contractFile.ResourceType = "Contract";
contractFile.UploadFileName = Path.GetFileName(item);
contractFile.FilePath = outPutPath.Replace(rootPath, "");
contractFile.FileSize = fileSize;
if (folder != null)
{
contractFile.ParentId = contractResourceFile.ContractResourceFileGuid;
}
_contractsService.InsertContractFile(contractFile);
}
}
}
}
public bool UpdateContractFile(ContractResourceFile file)
{
var insertSql = @"UPDATTE [dbo].[ContractResourceFile]
SET
ResourceGuid = @ResourceGuid,
UploadFileName = @UploadFileName,
Keys = @Keys,
MimeType = @MimeType,
IsActive = @IsActive,
IsDeleted = @IsDeleted,
CreatedBy = @CreatedBy,
UpdatedBy = @UpdatedBy,
CreatedOn = @CreatedOn,
IsCsv =@IsCsv
WHERE ContractResourceFileGuid = @ContractResourceFileGuid
)";
_context.Connection.Execute(insertSql, file);
return(true);
}
public bool InsertContractFile(ContractResourceFile file)
{
var insertSql = @"INSERT INTO [dbo].[ContractResourceFile]
VALUES
(
@ResourceGuid,
@Keys,
@UploadFileName,
@MimeType,
@IsActive,
@IsDeleted,
@CreatedBy,
@UpdatedBy,
@CreatedOn,
@IsCsv,
)";
_context.Connection.Execute(insertSql, file);
return(true);
}
private void AuditLogForUploadDownload(ContractResourceFile file, string type)
{
var keys = file.Keys;
string additionalInformation = string.Empty;
string additionalInformationURl = string.Empty;
string resource = string.Empty;
if (keys.Equals(ResourceType.Contract.ToString()))
{
var contractEntity = _contractsService.GetContractEntityByContractId(file.ResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, ResourceType.Contract.ToString().ToLower() + " File");
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Contract/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> Contract No:{1} </br> Project No:{2} </br> Contract Title:{3} </br> File Name:{4}", ResourceType.Contract.ToString(), contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
else if (keys.Equals(ResourceType.TaskOrder.ToString()))
{
var contractEntity = _contractsService.GetContractEntityByContractId(file.ResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, ResourceType.TaskOrder.ToString().ToLower() + " File");
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Project/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> TaskOrder No:{1} </br> Project No:{2} </br> TaskOrder Title:{3} </br> File Name:{4}", ResourceType.Contract.ToString(), contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
else if (keys.Equals(ResourceType.ContractModification.ToString()))
{
var contractModificationEntity = _contractModificationService.GetDetailById(file.ContentResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, "Contract Mod File");
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Contract/Details/" + contractModificationEntity.ContractGuid);
resource = string.Format("{0} </br> Mod No: {1} </br> Mod Title:{2}</br> File Name:{3}", "Contract Mod", contractModificationEntity.ModificationNumber, contractModificationEntity.ModificationTitle, file.UploadFileName);
}
else if (keys.Equals(ResourceType.TaskOrderModification.ToString()))
{
var contractModificationEntity = _contractModificationService.GetDetailById(file.ContentResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, "TaskOrder Mod File");
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Project/Details/" + contractModificationEntity.ContractGuid);
resource = string.Format("{0} </br> Mod No: {1} </br> Mod Title:{2}</br> File Name:{3}", "Contract Mod", contractModificationEntity.ModificationNumber, contractModificationEntity.ModificationTitle, file.UploadFileName);
}
else if (keys.Equals(ResourceType.EmployeeBillingRates.ToString()))
{
var contractEntity = _contractsService.GetContractEntityByContractId(file.ResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, "Employee Billing Rates File");
if (contractEntity.ParentContractGuid == Guid.Empty || contractEntity.ParentContractGuid == null)
{
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Contract/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> Contract No:{1} </br> Project No:{2} </br> Contract Title:{3} </br> File Name:{4}", "Employee Billing Rates", contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
else
{
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Project/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> TaskOrder No:{1} </br> Project No:{2} </br> TaskOrder Title:{3} </br> File Name:{4}", "Employee Billing Rates", contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
}
else if (keys.Equals(ResourceType.WorkBreakDownStructure.ToString()))
{
var contractEntity = _contractsService.GetContractEntityByContractId(file.ResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, "Work BreakDown Structure File");
if (contractEntity.ParentContractGuid == Guid.Empty || contractEntity.ParentContractGuid == null)
{
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Contract/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> Contract No:{1} </br> Project No:{2} </br> Contract Title:{3} </br> File Name:{4}", "Work BreakDown Structure", contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
else
{
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Project/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> TaskOrder No:{1} </br> Project No:{2} </br> TaskOrder Title:{3} </br> File Name:{4}", "Work BreakDown Structure", contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
}
else if (keys.Equals(ResourceType.LaborCategoryRates.ToString()))
{
var contractEntity = _contractsService.GetContractEntityByContractId(file.ResourceGuid);
additionalInformation = string.Format("{0} {1} the {2}", User.FindFirst("fullName").Value, type, "Labor Category Rates File");
if (contractEntity.ParentContractGuid == Guid.Empty || contractEntity.ParentContractGuid == null)
{
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Contract/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> Contract No:{1} </br> Project No:{2} </br> Contract Title:{3} </br> File Name:{4}", "Labor Category Rates", contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
else
{
additionalInformationURl = _configuration.GetSection("SiteUrl").Value + ("/Project/Details/" + contractEntity.ContractGuid);
resource = string.Format("{0} </br> TaskOrder No:{1} </br> Project No:{2} </br> TaskOrder Title:{3} </br> File Name:{4}", "Labor Category Rates", contractEntity.ContractNumber, contractEntity.ProjectNumber, contractEntity.ContractTitle, file.UploadFileName);
}
}
AuditLogHandler.InfoLog(_logger, User.FindFirst("fullName").Value, UserHelper.CurrentUserGuid(HttpContext), file, resource, file.ContractResourceFileGuid, UserHelper.GetHostedIp(HttpContext), "File " + type, Guid.Empty, "Successful", "", additionalInformation, additionalInformationURl);
}
