public void UpdateEmail(UserProfileData userProfileData) { try { using (uow = new VendorAPIRepository()) { User user = uow.UserRepository.Get().Where(x => x.UserID == userProfileData.UserId).FirstOrDefault(); if (user != null) { user.Email = userProfileData.Email; uow.UserRepository.Update(user); uow.Save(); } } } catch (Exception ex) { } }
public void AddProvider(List <ServiceProviderEntity> serviceProviderEntityList) { try { ServiceProvider serviceProvider = null; ServiceProviderIssue serviceProviderIssue = null; using (uow = new VendorAPIRepository()) { if (serviceProviderEntityList != null && serviceProviderEntityList.Count > 0) { foreach (var serviceProviderEntity in serviceProviderEntityList) { bool isStatusExists = uow.StatusRepository.Get().Any(x => x.StatusName == serviceProviderEntity.Status); if (!isStatusExists) { Status status = new Status(); status.StatusName = serviceProviderEntity.Status; uow.StatusRepository.Insert(status); uow.Save(); } bool isPhaseExists = uow.PhaseRepository.Get().Any(x => x.Phase1 == serviceProviderEntity.Phase); if (!isPhaseExists) { Phase phase = new Phase(); phase.Phase1 = serviceProviderEntity.Phase; uow.PhaseRepository.Insert(phase); uow.Save(); } bool isTypeExists = uow.TypeRepository.Get().Any(x => x.Type1 == serviceProviderEntity.Type); if (!isTypeExists) { Type type = new Type(); type.Type1 = serviceProviderEntity.Type; uow.TypeRepository.Insert(type); uow.Save(); } serviceProvider = uow.ServiceProviderRepository.Get().Where(x => x.VendorCode == serviceProviderEntity.VendorCode).FirstOrDefault(); if (serviceProvider != null) { serviceProvider.Name = serviceProviderEntity.Name; serviceProvider.StatusID = uow.StatusRepository.Get().Where(s => s.StatusName.Trim() == serviceProviderEntity.Status.Trim()).Select(y => y.StatusID).FirstOrDefault(); serviceProvider.GoLiveDate = serviceProviderEntity.GoLiveDate; serviceProvider.ProjectManagerID = 1; serviceProvider.PhaseID = uow.PhaseRepository.Get().Where(s => s.Phase1.Trim() == serviceProviderEntity.Phase.Trim()).Select(y => y.PhaseID).FirstOrDefault(); serviceProvider.Fees = serviceProviderEntity.Fees; serviceProvider.TypeID = uow.TypeRepository.Get().Where(s => s.Type1.Trim() == serviceProviderEntity.Type.Trim()).Select(y => y.TypeID).FirstOrDefault(); serviceProvider.Update = serviceProviderEntity.Update; uow.ServiceProviderRepository.Update(serviceProvider); } else { serviceProvider = new ServiceProvider(); serviceProvider.VendorCode = serviceProviderEntity.VendorCode; serviceProvider.Name = serviceProviderEntity.Name; serviceProvider.StatusID = uow.StatusRepository.Get().Where(s => s.StatusName.Trim() == serviceProviderEntity.Status.Trim()).Select(y => y.StatusID).FirstOrDefault(); serviceProvider.GoLiveDate = serviceProviderEntity.GoLiveDate; serviceProvider.ProjectManagerID = 1; serviceProvider.PhaseID = uow.PhaseRepository.Get().Where(s => s.Phase1.Trim() == serviceProviderEntity.Phase.Trim()).Select(y => y.PhaseID).FirstOrDefault(); serviceProvider.Fees = serviceProviderEntity.Fees; serviceProvider.TypeID = uow.TypeRepository.Get().Where(s => s.Type1.Trim() == serviceProviderEntity.Type.Trim()).Select(y => y.TypeID).FirstOrDefault(); serviceProvider.Update = serviceProviderEntity.Update; uow.ServiceProviderRepository.Insert(serviceProvider); } uow.Save(); if (serviceProviderEntity.IssuesList != null && serviceProviderEntity.IssuesList.Count > 0) { foreach (var issue in serviceProviderEntity.IssuesList) { serviceProviderIssue = uow.ServiceProviderIssueRepository.Get().Where(x => x.VendorCode == issue.VendorCode && x.IssueItem == issue.Item).FirstOrDefault(); if (serviceProviderIssue != null) { serviceProviderIssue.VendorCode = serviceProviderEntity.VendorCode; serviceProviderIssue.IssueItem = issue.Item; serviceProviderIssue.Issue = issue.Issue; serviceProviderIssue.Owner = issue.Owner; uow.ServiceProviderIssueRepository.Update(serviceProviderIssue); } else { serviceProviderIssue = new ServiceProviderIssue(); serviceProviderIssue.VendorCode = serviceProviderEntity.VendorCode; serviceProviderIssue.IssueItem = issue.Item; serviceProviderIssue.Issue = issue.Issue; serviceProviderIssue.Owner = issue.Owner; uow.ServiceProviderIssueRepository.Insert(serviceProviderIssue); } } uow.Save(); } } UploadExcelLog uploadExcelLog = new UploadExcelLog(); uploadExcelLog.UserId = 1;//need to dynamic uploadExcelLog.UploadDate = DateTime.Now; uow.UploadExcelLogRepository.Insert(uploadExcelLog); uow.Save(); } } } catch (Exception ex) { } }