public object GetSystemById(string systemID) { Guid sid = new Guid(systemID); var sysytem = SystemRepository.GetQueryable().FirstOrDefault(s => s.SystemID == sid); return(sysytem.SystemName); }
public HomeController(ConsoleApplicationWrapper <MinecraftMessageParser> wrapper, UserRepository userRepository, SystemRepository systemRepository, IHostingEnvironment env) { _wrapper = wrapper; _userRepository = userRepository; _systemRepository = systemRepository; _hostingEnvironment = env; }
public bool CreateEventLog(string EventName, string EventDescription, string OperateUser, Guid TargetSystem, string userPC) { var systemname = SystemRepository.GetQueryable().Where(s => s.SystemID == TargetSystem).Select(s => new { systemname = s.SystemName }); if (systemname.ToArray().Length > 0) { var EventLogs = new SystemEventLog() { EventLogID = Guid.NewGuid(), EventLogTime = DateTime.Now.ToString(), EventType = "1", EventName = EventName, EventDescription = EventDescription, FromPC = userPC, OperateUser = OperateUser, TargetSystem = systemname.ToArray()[0].systemname }; SystemEventLogRepository.Add(EventLogs); SystemEventLogRepository.SaveChanges(); return(true); } else { return(false); } }
/// <summary> /// Displays the user profile. /// </summary> /// <param name="userId">The userId.</param> /// <returns></returns> public UserProfileBO DisplayUserProfile(int userId) { UserProfileBO userProfile = new UserProfileBO(); UserMaster user = UserRepository.DisplayUserProfile(userId); List <UserWeddingSubscriptionBO> userWeddingSubscriptions = new List <UserWeddingSubscriptionBO>(); AddressMasterBO address = new AddressMasterBO(); ObjectMapper.Map(SystemRepository.GetAddressDetailsByType((int)AspectEnums.AddressOwnerType.User, userId), address); ObjectMapper.Map(user, userProfile); // userProfile.UserWeddingSubscriptions = userWeddingSubscriptions; userProfile.Address = address; RoleMaster role = user.UserRoles.Where(k => !k.isDeleted).ToList().Count > 0 ? user.UserRoles.Where(k => !k.isDeleted).ToList()[0].RoleMaster : null; userProfile.RoleID = role != null ? role.RoleID : 0; userProfile.userRoleID = user.UserRoles.Where(k => !k.isDeleted).FirstOrDefault().UserRoleID; if (!String.IsNullOrEmpty(userProfile.ImagePath)) { userProfile.ImagePath = userProfile.ImagePath; // AppUtil.GetServerMobileImages(userProfile.ImagePath, AspectEnums.ImageFileTypes.User); } else { userProfile.ImagePath = "~/content/images/users/avatar.png"; } userProfile.IsAdmin = UserRepository.IsAdminRole(Convert.ToInt32(userProfile.RoleID)); userProfile.Mobile = EncryptionEngine.DecryptString(userProfile.Mobile); userProfile.Phone = EncryptionEngine.DecryptString(userProfile.Phone); userProfile.Email = EncryptionEngine.DecryptString(userProfile.Email); userProfile.LoginName = EncryptionEngine.DecryptString(userProfile.LoginName); return(userProfile); }
/// <summary> /// Batch method to send notification /// </summary> /// //VC20140819 private void BatchNotifications() { try { DateTime CurrentDateTime = DateTime.Now; List <long> NotificationServiceID = new List <long>();//To update context after notification var Registration_IDsJSON = ""; var groupedData = SystemRepository.GetNotificationService(CurrentDateTime).GroupBy(x => new { x.PushNotificationMessage, x.NotificationID }).ToList(); // LogTraceEngine.WriteLogWithCategory("Notification service Called and count : " + groupedData.Count + "curent date time =" + CurrentDateTime.ToLongDateString(), AppVariables.AppLogTraceCategoryName.NotificationListener); AndroiddNotificationManager pushNotifier = new AndroiddNotificationManager(); foreach (var notification in groupedData) //Iterate Grouped data on Notification ID { NotificationServiceID.AddRange(notification.Select(x => x.NotificationServiceID)); Registration_IDsJSON = String.Join(",", notification.Select(x => "\"" + x.AndroidID + "\"").ToArray()); string response = pushNotifier.SendNotification(Registration_IDsJSON, notification.Key.PushNotificationMessage, 1); //Send for Notification systemRepository.UpdateNotificationServiceResponse(NotificationServiceID, response, notification.Key.NotificationID.Value, CurrentDateTime); //Update Context } } catch (Exception ex) { LogTraceEngine.WriteLogWithCategory("Batch Notification service Called and exception occured : Database string : " + dataAccess.ConnectionString + " " + ex.Message, AppVariables.AppLogTraceCategoryName.NotificationListener); } }
public RACEMastersDTO GetRaceMasters(long userID, int roleID) { RACEMastersDTO result = new RACEMastersDTO(); if (SystemRepository.IsDownloadAuthorized(userID, AspectEnums.DownloadService.RACE) == true) { List <RaceBrandMasterDTO> lstBrands = new List <RaceBrandMasterDTO>();; List <RaceProductCategoryDTO> lstProductCategory = new List <RaceProductCategoryDTO>(); List <RacePOSMMasterDTO> lstPOSM = new List <RacePOSMMasterDTO>(); List <RaceFixtureMasterDTO> lstFixtures = new List <RaceFixtureMasterDTO>(); List <RaceBrandCategoryMappingDTO> lstBrandCategoryMapping = new List <RaceBrandCategoryMappingDTO>(); List <RacePOSMProductMappingDTO> lstPOSMProductMapping = new List <RacePOSMProductMappingDTO>(); ObjectMapper.Map(ActivityRepository.GetRaceBrandMaster(), lstBrands); ObjectMapper.Map(ActivityRepository.GetRaceProductCategory(), lstProductCategory); ObjectMapper.Map(ActivityRepository.GetRacePOSMMaster(), lstPOSM); ObjectMapper.Map(ActivityRepository.GetRaceFixtureMaster(), lstFixtures); ObjectMapper.Map(ActivityRepository.GetRaceBrandCategoryMapping(), lstBrandCategoryMapping); ObjectMapper.Map(ActivityRepository.GetRacePOSMProductMappings(), lstPOSMProductMapping); result.BrandCategoryMapping = lstBrandCategoryMapping; result.BrandMaster = lstBrands; result.FixtureMaster = lstFixtures; result.POSMMaster = lstPOSM; result.ProductCategory = lstProductCategory; result.POSMProductMapping = lstPOSMProductMapping; } return(result); }
/// <summary> /// Method to insert email record into database /// </summary> /// <param name="email">email entity</param> /// <returns>returns boolean status</returns> public bool InsertEmailRecord(EmailServiceDTO email) { EmailService emailDetail = new EmailService(); ObjectMapper.Map(email, emailDetail); return(SystemRepository.InsertEmailRecord(emailDetail)); }
public object GetSystemById(string systemID) { //Guid sid = new Guid(systemID); var sysytem = SystemRepository.GetQueryable().FirstOrDefault(s => s.SYSTEM_ID.Trim() == systemID); return(sysytem.SYSTEM_NAME); }
public object GetDetails(string userName, string systemID, string cityID) { //Guid cityid = new Guid(cityID); //Guid systemid = new Guid(systemID); //var user = UserRepository.GetQueryable().FirstOrDefault(u => u.USER_NAME == userName); //var userSystemId = UserSystemRepository.GetQueryable().Where(us => us.USER_USER_ID == user.USER_ID // && us.AUTH_SYSTEM.SYSTEM_ID == systemID && us.CITY_CITY_ID == cityID).Select(us => us.USER_SYSTEM_ID); ////string userSystemId = userSystemIds.Single().Trim(); //var userSystems = UserSystemRepository.GetQueryable().Where(us => !userSystemId.Any(uid => uid == us.USER_SYSTEM_ID) // && us.USER_USER_ID == user.USER_ID && us.AUTH_CITY.CITY_ID == cityID); //var userSystem = userSystems.Where(u => userSystems.Any(us => us.AUTH_USER_MODULE.Any(um => um.AUTH_USER_FUNCTION.Any(uf => // uf.USER_MODULE_USER_MODULE_ID== um.USER_MODULE_ID && uf.IS_ACTIVE == "1") || um.IS_ACTIVE == "1") || us.IS_ACTIVE == "1")) // .Select(us => new {us.AUTH_SYSTEM.SYSTEM_ID, us.AUTH_SYSTEM.SYSTEM_NAME, us.AUTH_SYSTEM.DESCRIPTION, Status =us.AUTH_CITY.IS_ACTIVE=="0" ? "启用" : "禁用" }); //return userSystem.ToArray(); var user = UserRepository.GetQueryable().FirstOrDefault(u => u.USER_NAME == userName); var userSystem = UserSystemRepository.GetQueryable(); var system = SystemRepository.GetQueryable(); var qq = from a in system from b in userSystem where (a.SYSTEM_ID == b.SYSTEM_SYSTEM_ID) select new{ a.SYSTEM_NAME, a.DESCRIPTION, STATUS = a.STATUS == "1"?"启用":"未启用", b.CITY_CITY_ID, b.SYSTEM_SYSTEM_ID, b.USER_USER_ID, b.IS_ACTIVE }; var userUseSysem = qq.Where(p => p.CITY_CITY_ID == cityID && !p.SYSTEM_SYSTEM_ID.Contains(systemID) && p.IS_ACTIVE == "1" && p.USER_USER_ID == user.USER_ID); return(userUseSysem.Distinct().ToArray()); }
public static void GetPageInfo() { IWebNewsDbConnectionFactory _connectionFactory = new WebNewsDbConnectionFactory(ConfigurationManager.ConnectionStrings["WebNews"].ConnectionString, SqlServer2014OrmLiteDialectProvider.Instance); ISystemRepository _systemRepository = new SystemRepository(_connectionFactory); if (Authentication.GetHomePageInfo() == null) { var homePageInfo = _systemRepository.GetPageInfo(new Models.Filter { Lang = Authentication.GetLanguageCode() }); var partners = _systemRepository.GetMedias(new Models.Filter { ExtraInfo = Domain.Entities.Medium.TYPE_PARTER, Lang = "all" }); var banners = _systemRepository.GetMedias(new Models.Filter { ExtraInfo = Domain.Entities.Medium.TYPE_BANNER, Lang = "all" }); var branches = _systemRepository.GetMedias(new Models.Filter { ExtraInfo = Domain.Entities.Medium.TYPE_BRANCH, Lang = "all" }); var logo = _systemRepository.GetMedias(new Models.Filter { ExtraInfo = Domain.Entities.Medium.TYPE_LOGO, Lang = "all" }); var menus = _systemRepository.GetMenu("FE"); Authentication.MarkHomePageInfo(homePageInfo); Authentication.MarkPartners(partners); Authentication.MarkBanners(banners); Authentication.MarkBranches(branches); Authentication.MarkLogo(logo); Authentication.MarkMenuFE(menus); } }
public object GetSystemParameter(int page, int rows, string parameterName, string parameterValue, string remark, string userName, string SystemID) { IQueryable <SystemParameter> systemParameterQuery = SystemParameterRepository.GetQueryable(); IQueryable <THOK.Authority.DbModel.System> systemQuery = SystemRepository.GetQueryable(); var systemParameter = systemParameterQuery.Join(systemQuery, s => s.SystemID, s1 => s1.SystemID, (s, s1) => new { s.Id, s.ParameterName, s.ParameterValue, s.Remark, s.UserName, SystemName = s1.SystemName }) .Join(systemQuery, c => c.SystemName, s2 => s2.SystemName, (c, s2) => new { c.Id, c.ParameterName, c.ParameterValue, c.Remark, c.SystemName, c.UserName, SystemID = s2.SystemName }) .Where(p => p.ParameterName.Contains(parameterName) && p.ParameterValue.Contains(parameterValue) && p.Remark.Contains(remark)) .OrderBy(p => p.Id).AsEnumerable() .Select(p => new { Id = p.Id, p.ParameterName, p.ParameterValue, p.Remark, p.UserName, p.SystemID, SystemName = p.SystemID == null ? "" : p.SystemName }); int total = systemParameter.Count(); systemParameter = systemParameter.Skip((page - 1) * rows).Take(rows); return(new { total, rows = systemParameter.ToArray() }); }
public ConsoleApplicationWrapper(IOptions <ApplicationSettings> options, SystemRepository systemRepository, IServiceProvider serviceProvider) { _bdsDirectory = options.Value.BdsPath; _startDirectory = options.Value.StartDirectory; _restartOnFailure = options.Value.RestartOnFailure; _maxOutputRetained = options.Value.MaxOutputRetained; _serviceProvider = serviceProvider; }
public CommandInterpreter (OutputWriter writer, SystemRepository systemRepository, HardwareFactory hardwareFactory, SoftwareFactory softwareFactory) { this.writer = writer; this.systemRepository = systemRepository; this.hardwareFactory = hardwareFactory; this.softwareFactory = softwareFactory; }
public void shouldCreateSystemComponentObject() { SystemRepository systemRepository = new SystemRepository(); SystemBuilder systemBuilder = new SystemBuilder(systemRepository); SystemComponent sm = systemRepository.Create(); Assert.NotNull(sm); Assert.IsType <SystemComponent>(sm); }
public bool InitUserSystemInfo(string userID, string cityID, string systemID) { var user = UserRepository.GetQueryable().Single(u => u.UserID == new Guid(userID)); var city = CityRepository.GetQueryable().Single(c => c.CityID == new Guid(cityID)); var system = SystemRepository.GetQueryable().Single(s => s.SystemID == new Guid(systemID)); InitUserSystem(user, city, system); return(true); }
public bool InitUserSystemInfo(string userID, string cityID, string systemID) { var user = UserRepository.GetQueryable().Single(u => u.USER_ID == userID); var city = CityRepository.GetQueryable().Single(c => c.CITY_ID == cityID); var system = SystemRepository.GetQueryable().Single(s => s.SYSTEM_ID == systemID); InitUserSystem(user, city, system); return(true); }
public PatientEduService(PatientEduRepository repository, DoctorRepository doctorRepository, CourseRepository courseRepository, SystemRepository systemRepository, MessageRepository messageRepository, IUnitWork unitWork, IOptions <MyOptions> optionsAccessor) { _unitWork = unitWork; _optionsAccessor = optionsAccessor.Value; _repository = repository; _doctorRepository = doctorRepository; _courseRepository = courseRepository; _systemRepository = systemRepository; _messageRepository = messageRepository; }
public EnhancedCommandInterpreter (OutputWriter writer, SystemRepository systemRepository, DumpRepository dumpRepository, HardwareFactory hardwareFactory, SoftwareFactory softwareFactory) : base(writer, systemRepository, hardwareFactory, softwareFactory) { this.dumpRepository = dumpRepository; }
public void InitRoleSys(string roleID, string cityID, string systemID) { IQueryable <THOK.Authority.DbModel.Role> queryRole = RoleRepository.GetQueryable(); IQueryable <THOK.Authority.DbModel.City> queryCity = CityRepository.GetQueryable(); IQueryable <THOK.Authority.DbModel.System> querySystem = SystemRepository.GetQueryable(); var role = queryRole.Single(i => i.RoleID == new Guid(roleID)); var city = queryCity.Single(i => i.CityID == new Guid(cityID)); var system = querySystem.Single(i => i.SystemID == new Guid(systemID)); InitRoleSystem(role, city, system); }
public static void CreateSystem() { Console.WriteLine("Enter the user id to get subordinates:"); int userID = Convert.ToInt32(Console.ReadLine()); SystemRepository sr = new SystemRepository(); SystemBuilder sm = new SystemBuilder(sr); sm.BuildSystem(); Console.Write(sm.getSubord(userID)); Console.ReadLine(); }
/// <summary> /// IsKeyValid /// </summary> /// <param name="key"> </param> /// <param name="system"></param> /// <returns></returns> public bool IsKeyValid(Guid key, out CIS_System system) { var systemRepo = new SystemRepository(); system = systemRepo.SelectAllAsList().FirstOrDefault(x => x.KeyValue.ToString().Equals(key.ToString())); if (system == null) { return(false); } return(true); }
public void InitRoleSys(string roleID, string cityID, string systemID) { IQueryable <AUTH_ROLE> queryRole = RoleRepository.GetQueryable(); IQueryable <AUTH_CITY> queryCity = CityRepository.GetQueryable(); IQueryable <AUTH_SYSTEM> querySystem = SystemRepository.GetQueryable(); var role = queryRole.Single(i => i.ROLE_ID == roleID); var city = queryCity.Single(i => i.CITY_ID == cityID); var system = querySystem.Single(i => i.SYSTEM_ID == systemID); InitRoleSystem(role, city, system); }
public string GetWeddingCommonFieldDisplayText(int DisplayValue, string SubType) { List <CommonSetupBO> commonValues = new List <CommonSetupBO>(); if (CommonFields == null) { ObjectMapper.Map(SystemRepository.GetCommonSetup(0, null, Convert.ToString((int)AspectEnums.CommonTableMainType.Wedding)), commonValues); CommonFields = commonValues; } return(CommonFields.Where(x => x.DisplayValue == DisplayValue && x.SubType == SubType).FirstOrDefault().DisplayText); }
public async Task TestSystemRepo_GetGamesBySystem() { //Arrange SystemRepository TestRepo = CreateSystemTestRepo("GamesBySystem", true); //Act var result = await TestRepo.GetGamesBySystem(_SystemNumber - 1); //Assert Assert.IsTrue(result.Count() == 1); }
public async Task TestSystemRepo_Exists() { //Arrange SystemRepository TestRepo = CreateSystemTestRepo("SystemExists"); //Act var result = await TestRepo.Exist(_SystemNumber - 1); //Subtract one since it starts at 0 //Assert Assert.IsTrue(result); }
public void TestSystemRepo_GetAll() { //Arrange SystemRepository TestRepo = CreateSystemTestRepo("SystemGetAll"); //Act var result = TestRepo.GetAll(); //Assert Assert.IsTrue(result.Count() == _SystemNumber); }
public bool Save(string systemId, string systemName, string description, string status) { //Guid sid = new Guid(systemId); var system = SystemRepository.GetQueryable() .FirstOrDefault(i => i.SYSTEM_ID == systemId); system.SYSTEM_NAME = systemName; system.DESCRIPTION = description; system.STATUS = status; SystemRepository.SaveChanges(); return(true); }
public async Task TestSystemRepo_GetSingle() { //Arrange SystemRepository TestRepo = CreateSystemTestRepo("SystemGetSingle"); //Act var result = await TestRepo.Find(_SystemNumber - 1); //Subtract one since it starts at 0 //Assert Assert.IsTrue(result.Id == (_SystemNumber - 1)); Assert.IsTrue(result.SystemName == _SystemName + (_SystemNumber - 1).ToString()); }
public bool Save(string systemId, string systemName, string description, bool status) { Guid sid = new Guid(systemId); var system = SystemRepository.GetQueryable() .FirstOrDefault(i => i.SystemID == sid); system.SystemName = systemName; system.Description = description; system.Status = status; SystemRepository.SaveChanges(); return(true); }
public object GetSingleContentTxt(string helpId) { Guid newId = new Guid(helpId); var system = SystemRepository.GetQueryable().FirstOrDefault(i => i.SystemID == newId); var help = HelpContentRepository.GetQueryable().FirstOrDefault(i => i.ID == newId); if (system != null) { help = HelpContentRepository.GetQueryable().FirstOrDefault(i => i.Module.System_SystemID == newId); } return(help != null ? new { help.ContentText } : new { ContentText = "" }); }