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 UserEntity GetProfileData(int userId) { UserEntity userEntity = new UserEntity(); using (uow = new VendorAPIRepository()) { userEntity = uow.UserRepository.Get().Where(z => z.UserID == userId).Select(x => new UserEntity { UserID = userId, UserRoleID = Convert.ToInt32(x.UserRoleID), FirstName = x.FirstName, LastName = x.LastName, Email = x.Email, PhoneNo = x.PhoneNo }).FirstOrDefault(); } return(userEntity); }
public UserEntity GetPassword(UserEntity userEntity) { using (uow = new VendorAPIRepository()) { userEntity = uow.UserRepository.Get().Where(urp => urp.Email == userEntity.Email) .Select(x => new UserEntity { UserID = Convert.ToInt32(x.UserID), Username = x.Username, Password = x.Password, UserRoleID = Convert.ToInt32(x.UserRoleID), FirstName = x.FirstName, LastName = x.LastName, Email = x.Email, PhoneNo = x.PhoneNo }).FirstOrDefault(); } return(userEntity); }
public UserEntity LoginUser(UserEntity userEntity) { using (uow = new VendorAPIRepository()) { //isUserValid = uow.UserRepository.Get().Any(x => x.Username == userEntity.Username && x.Password == userEntity.Password); userEntity = uow.UserRepository.Get().Where(urp => urp.Username == userEntity.Username && CommonHelper.Decrypt(urp.Password) == userEntity.Password) .Select(x => new UserEntity { UserID = Convert.ToInt32(x.UserID), Username = x.Username, Password = x.Password, UserRoleID = Convert.ToInt32(x.UserRoleID), FirstName = x.FirstName, LastName = x.LastName, Email = x.Email, PhoneNo = x.PhoneNo }).FirstOrDefault(); } return(userEntity); }
public DashboardData GetDashboardData() { DashboardData dashboardData = new DashboardData(); using (uow = new VendorAPIRepository()) { List <ServiceProviderEntity> serviceProviders = GetServiceProviders(); try { dashboardData.SPBeingWhiteListed = serviceProviders.Where(x => x.PhaseId == 5).Count(); dashboardData.NumberOfSPTesting = serviceProviders.Where(x => x.PhaseId == 1).Count(); dashboardData.ProvidersInProduction = serviceProviders.Where(x => x.StatusId == 3).Count(); dashboardData.ProviderWentLiveLastWeek = serviceProviders.Where(x => x.StatusId == 3).Count(); dashboardData.QAGoLive = serviceProviders.Where(x => x.PhaseId == 2).Count(); int noOfSPBillcount = 0; double Totabill = 0.00; foreach (var item in serviceProviders) { try { Convert.ToDouble(item.Fees.Replace("$", "")); noOfSPBillcount++; } catch { } try { Convert.ToDouble(item.Fees.Replace("$", "")); Totabill += Convert.ToDouble(item.Fees.Replace("$", "")); } catch { } } dashboardData.NoOfSPBilled = noOfSPBillcount; dashboardData.SPBilledTotalAmount = String.Format("{0:#,0.00}", Totabill); } catch (Exception ex) { } } return(dashboardData); }
public UserProfileData GetUserProfileData(int userId) { UserProfileData userProfileData = new UserProfileData(); using (uow = new VendorAPIRepository()) { UserEntity userEntity = GetProfileData(userId); try { userProfileData.UserId = userId; userProfileData.UserRoleId = userEntity.UserRoleID; userProfileData.FirstName = userEntity.FirstName; userProfileData.LastName = userEntity.LastName; userProfileData.Email = userEntity.Email; userProfileData.PhoneNo = userEntity.PhoneNo; } catch (Exception ex) { } } return(userProfileData); }
public List <ServiceProviderEntity> GetServiceProviders() { List <ServiceProviderEntity> serviceProviderEntities = new List <ServiceProviderEntity>(); using (uow = new VendorAPIRepository()) { serviceProviderEntities = uow.ServiceProviderRepository.Get() .Join(uow.StatusRepository.Get(), spr => spr.StatusID, stp => stp.StatusID, (spr, stp) => new { spr, stp }) .Join(uow.UserRepository.Get(), upr => upr.spr.ProjectManagerID, utp => utp.UserID, (upr, utp) => new { upr, utp }) .Join(uow.PhaseRepository.Get(), ppr => ppr.upr.spr.PhaseID, ptp => ptp.PhaseID, (ppr, ptp) => new { ppr, ptp }) .Join(uow.TypeRepository.Get(), tpr => tpr.ppr.upr.spr.PhaseID, ttp => ttp.TypeID, (tpr, ttp) => new { tpr, ttp }) .Select(sprd => new ServiceProviderEntity { VendorCode = sprd.tpr.ppr.upr.spr.VendorCode, Fees = sprd.tpr.ppr.upr.spr.Fees, GoLiveDate = sprd.tpr.ppr.upr.spr.GoLiveDate, Name = sprd.tpr.ppr.upr.spr.Name.ToString(), Update = sprd.tpr.ppr.upr.spr.Update.ToString(), StatusId = sprd.tpr.ppr.upr.stp.StatusID, Status = sprd.tpr.ppr.upr.stp.StatusName, ProjectManager = sprd.tpr.ppr.utp.Username, PhaseId = sprd.tpr.ptp.PhaseID, Phase = sprd.tpr.ptp.Phase1, TypeId = sprd.ttp.TypeID, Type = sprd.ttp.Type1, IssuesList = sprd.tpr.ppr.upr.spr.ServiceProviderIssues.Select(spis => new IssuesEntity { VendorCode = spis.VendorCode, Issue = spis.Issue, Item = spis.IssueItem, Owner = spis.Owner }).ToList() }) .ToList(); } return(serviceProviderEntities); }
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) { } }