public async Task <IActionResult> Add([FromForm] ProjectDeploymentDTOAddWithFile projectDeploymentDTOAddWithFile)
        {
            if (projectDeploymentDTOAddWithFile.file == null)
            {
                return(BadRequest("Invalid file, it must not null"));
            }
            long size = projectDeploymentDTOAddWithFile.file.Length;

            if (size == 0)
            {
                return(BadRequest("Invalid file"));
            }
            var documentFolderName = myAppSettingsOptions.DeploymentDocuments;
            var fileName           = projectDeploymentDTOAddWithFile.file.FileName;

            ProjectDeploymentDTOAdd projectDeploymentDTOAdd = new ProjectDeploymentDTOAdd();

            projectDeploymentDTOAdd.ProjectId      = projectDeploymentDTOAddWithFile.ProjectId;
            projectDeploymentDTOAdd.DeploymentDate = projectDeploymentDTOAddWithFile.DeploymentDate;
            projectDeploymentDTOAdd.ServerId       = projectDeploymentDTOAddWithFile.ServerId;
            projectDeploymentDTOAdd.Features       = projectDeploymentDTOAddWithFile.Features;
            projectDeploymentDTOAdd.Version        = projectDeploymentDTOAddWithFile.Version;
            projectDeploymentDTOAdd.ActualFileName = fileName;
            projectDeploymentDTOAdd.Notes          = projectDeploymentDTOAddWithFile.Notes;

            var result = _IProjectDeploymentRepository.Add(projectDeploymentDTOAdd);

            var filePathDocument = AppContext.BaseDirectory + documentFolderName + "\\" + result.StoreAsFileName;

            using (var stream = System.IO.File.Create(filePathDocument))
            {
                await projectDeploymentDTOAddWithFile.file.CopyToAsync(stream);
            }
            return(Ok(result));
        }
        public ProjectDeploymentDTODetails Add(ProjectDeploymentDTOAdd obj)
        {
            var result = _context.ProjectDeploymentDTODetails.FromSqlRaw("Exec ProjectDeployment_Insert {0},{1},{2},{3},{4},{5},{6}", obj.ProjectId, obj.DeploymentDate.ToString("dd-MMM-yyyy"), obj.ServerId, obj.Features, obj.Version, obj.ActualFileName, obj.Notes).ToList().FirstOrDefault();

            return(result);
        }