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 = "" });
}
