Esempio n. 1
0
        public ValueDataResponse <Project> UpdateProject(UpsertProject project)
        {
            ValueDataResponse <Project> response = new ValueDataResponse <Project>();

            try
            {
                var projectsExists = _appContext.Projects.Where(x => x.Id != project.Id && x.ProjectReference == project.ProjectReference).FirstOrDefault();

                if (projectsExists == null)
                {
                    Project pro         = _mapper.Map <Project>(project);
                    var     result      = _appContext.Projects.Where(x => x.Id == project.Id).FirstOrDefault();
                    var     projectList = _appContext.LookUpProjectXrefs.Where(x => x.ProjectId == project.Id).ToList();
                    _appContext.LookUpProjectXrefs.RemoveRange(projectList);
                    _appContext.SaveChanges();
                    foreach (var sId in project.StoreIds)
                    {
                        _appContext.LookUpProjectXrefs.Add(new LookUpProjectXref {
                            StoreId = sId, ProjectId = pro.Id
                        });
                    }

                    if (result != null)
                    {
                        result.SiteId           = project.SiteId;
                        result.ProjectReference = project.ProjectReference;
                        result.Name1            = project.Name1;
                        result.Name2            = project.Name2;
                        result.ProjectDetails   = project.ProjectDetails;
                        result.IsActive         = project.IsActive;
                        result.CreatedBy        = project.CreatedBy;
                        result.CreatedDate      = project.CreatedDate;
                        result.UpdatedBy        = project.UpdatedBy;
                        result.UpdatedDate      = project.UpdatedDate;

                        foreach (var req in project.ProjectRepositories)
                        {
                            if (req.FileName != null)
                            {
                                string ModuleName = "Project";
                                var    now        = DateTime.Now;
                                var    yearName   = now.ToString("yyyy");
                                var    monthName  = now.Month.ToString("d2");
                                var    dayName    = now.ToString("dd");

                                FileUploadService repo = new FileUploadService();

                                string FolderLocation = "FileRepository";
                                string ServerRootPath = _config.Value.ServerRootPath;

                                string Location = ServerRootPath + @"\" + FolderLocation + @"\" + yearName + @"\" + monthName + @"\" + dayName + @"\" + ModuleName;

                                byte[] FileBytes = Convert.FromBase64String(req.FileName);

                                req.FileName = repo.UploadFile(FileBytes, req.FileExtention, Location);

                                req.FileLocation = Path.Combine(yearName, monthName, dayName, ModuleName);

                                ProjectRepository pros = new ProjectRepository();
                                {
                                    pros.ProjectId     = pro.Id;
                                    pros.FileName      = req.FileName;
                                    pros.FileLocation  = req.FileLocation;
                                    pros.FileExtention = req.FileExtention;
                                    pros.DocumentType  = req.DocumentTypeId;
                                    pros.CreatedBy     = req.CreatedBy;
                                    pros.CreatedDate   = DateTime.Now;
                                    pros.UpdatedBy     = req.UpdatedBy;
                                    pros.UpdatedDate   = DateTime.Now;
                                }
                                _appContext.ProjectRepositories.Add(pros);
                            }
                        }
                        _appContext.SaveChanges();
                        if (pro != null)
                        {
                            response.Result          = pro;
                            response.IsSuccess       = true;
                            response.AffectedRecords = 1;
                            response.EndUserMessage  = "Project Updated Successfully";
                        }
                        else
                        {
                            response.IsSuccess       = true;
                            response.AffectedRecords = 0;
                            response.EndUserMessage  = "Project Update Failed";
                        }
                    }
                }
                else
                {
                    response.IsSuccess       = false;
                    response.AffectedRecords = 0;
                    response.EndUserMessage  = "Project Reference is Already Exists";
                }
            }
            catch (Exception ex)
            {
                response.IsSuccess       = false;
                response.AffectedRecords = 0;
                response.EndUserMessage  = ex.InnerException == null ? ex.Message : ex.InnerException.Message;
                response.Exception       = ex;
            }
            return(response);
        }
Esempio n. 2
0
        public ValueDataResponse <Project> Update(UpsertProject project)
        {
            // Project pro = _mapper.Map<Project>(project);

            return(_unitOfWork.Projects.UpdateProject(project));
        }