public List <List <ParameterData> > GetAnalogSignalsById(int id) { var parameterData = new List <List <ParameterData> >(); //init parameterData for (int j = 0; j < 3; j++) { parameterData.Add(new List <ParameterData>()); } //write data from arhive to parameterData using (var repoUnit = new RepoUnit()) { var block = repoUnit.BlockLog.FindFirstBy(blc => blc.Id == id); for (int i = 0; i < 3; i++) { parameterData[i].AddRange(block.AnalogSignalLogs.Where(signal => signal.NodeId == i + 1).Select(s => new ParameterData { Name = s.SignalType.Type, Value = s.SignalValue.ToString() })); } /* parameterData.AddRange(block.AnalogSignalLogs.Select(signal => new ParameterData * { * Name = signal.SignalType.Type, * Value = signal.SignalValue.ToString() * })); */ } return(parameterData); }
public void SetUp() { DiMvc.Register(); Ioc.RegisterType<IConfig, FakeConfig>(); _config = Ioc.Resolve<IConfig>() as FakeConfig; _users = new List<User>() { new User { Email = "*****@*****.**", FullName = "aaa ddd", FirstName = "aaa", LastName = "ddd"}, new User { Email = "*****@*****.**", FullName = "aaa bbb", FirstName = "aaa", LastName = "bbb"} }; _repoUnit = new RepoUnit(); _users.ForEach(_repoUnit.User.Save); var userService = new UserService(_repoUnit, null); Ioc.RegisterInstance<UserService>(userService); var mock = new Mock<ControllerContext>(); mock.Setup(p => p.HttpContext.Session).Returns(new Mock<HttpSessionStateBase>().Object); _usersController = new UsersController(userService) { ControllerContext = mock.Object }; _config.PageSize = 1; }
public GeneralLogData GetGeneralLogLineById(int id) { GeneralLog glog; GeneralLogData logData = new GeneralLogData(); string line; using (var repoUnit = new RepoUnit()) { glog = repoUnit.GeneralLog.FindFirstBy(gl => gl.Id == id); } logData.Text = glog.Date.ToShortDateString() + " " + glog.Date.ToString("HH:mm:ss") + " " + glog.LogLine; logData.ShortText = glog.LogShortLine; switch (glog.GeneralLogTypeId) { case 1: logData.TypeColor = Color.LimeGreen; break; case 2: logData.TypeColor = Color.Orange; break; case 3: logData.TypeColor = Color.Red; break; } return(logData); }
public List<OnPlotClickData> FindDataByIdAndDate(int fanNum, DateTime date) { var propertyList = new List<OnPlotClickData>(); try { using (var repoUnit = new RepoUnit()) { var fansLogRepo = repoUnit.FanLog; var fansLogId = fansLogRepo.Load().Where(n => n.FanNumber == fanNum && n.Date == date).Max(n => n.Id); var fansLog = fansLogRepo.Find(fansLogId); propertyList.Add(new OnPlotClickData { Property = "Время приема параметров", Value = fansLog.Date.ToString() }); propertyList.Add(new OnPlotClickData { Property = "Вентиляторная установка №", Value = fanNum.ToString() }); propertyList.Add(new OnPlotClickData { Property = "Вентилятор 1", Value = fansLog.Fan1State.State }); propertyList.Add(new OnPlotClickData { Property = "Вентилятор 2", Value = fansLog.Fan2State.State }); propertyList.AddRange(fansLog.DoorsLogs.Select(doorLog => new OnPlotClickData { Property = doorLog.DoorType.Type, Value = doorLog.DoorState.State })); propertyList.AddRange(fansLog.AnalogSignalLogs.Select(signal => new OnPlotClickData { Property = signal.SignalType.Type, Value = signal.SignalValue.ToString() })); } } catch (Exception) { //nothing in Db } return propertyList; }
public void SetUp() { _users = new List<User>() { new User { Email = "*****@*****.**", FullName = "aaa ddd", FirstName = "aaa", LastName = "ddd", Live = LiveStatuses.Active, ApproveState = ApproveStates.Approved, Role = Roles.Simple }, new User { Email = "*****@*****.**", FullName = "aaa bbb", FirstName = "aaa", LastName = "bbb", Live = LiveStatuses.Active, ApproveState = ApproveStates.Approved, Role = Roles.Admin } }; var mock = new Mock<ControllerContext>(); mock.Setup(p => p.HttpContext.Session).Returns(new Mock<HttpSessionStateBase>().Object); DiMvc.Register(); Ioc.RegisterType<IUserRepository, UserRepository>(); _repoUnit = new RepoUnit(); var lastRecord = _repoUnit.User.Load(); _lastDbRecordId = !lastRecord.Any() ? 0 : lastRecord.Max(user => user.Id); _users.ForEach(user => _repoUnit.User.Save(user)); var service = new UserService(_repoUnit, null) { //PageSize = lastRecord.Count() + _users.Count //Prevent paging }; _usersController = new UsersController(service); _usersController.ControllerContext = mock.Object; }
public void SetUp() { //Map interfaces for further modifications DiMvc.Register(); Ioc.RegisterType<IUserRepository, UserRepository>(); Ioc.RegisterType<ICryptoProvider, KeccakCryptoProvider>(); Ioc.RegisterType<ISaltProvider, RandomSaltProvider>(); var cryptoProvider = Ioc.Resolve<ICryptoProvider>(); var saltProvider = Ioc.Resolve<ISaltProvider>(); _membershipProvider = new CalendarMembershipProvider(cryptoProvider, saltProvider); _userPassword = "******"; _userSalt = saltProvider.GetSalt(SALT_LENGTH); var keccak = cryptoProvider.GetHashWithSalt(_userPassword, _userSalt); _repoUnit = Ioc.Resolve<RepoUnit>(); _user = new User { Email = "*****@*****.**", FirstName = "Sherlock", LastName = "Holmes", PasswordHash = keccak, PasswordSalt = _userSalt, Role = Roles.Simple }; _repoUnit.User.Save(_user); }
public void SetUp() { FakeDi.Register(); _repoUnit = new RepoUnit(); _rules = new UsersRules(_repoUnit); _generator = new SequentialGenerator<DateTime> { Direction = GeneratorDirection.Ascending }; }
public override bool IsUserInRole(string email, string roleName) { using (var unit = new RepoUnit()) { var user = unit.User.Get(u => u.Email == email); return user != null && user.Role.ToString().Equals(roleName); } }
public void SetUp() { Database.SetInitializer<MineContext>(new MineDbInitializer()); var mc = new MineContext(); mc.Database.Initialize(true); _uow = new RepoUnit(); }
public override string[] GetRolesForUser(string email) { using (var unit = new RepoUnit()) { var user = unit.User.Get(u => u.Email == email); var role = user == null ? Models.Roles.Simple : user.Role; return new[] { role.ToString() }; } }
public void InsertData(string data) { var paramsTable = _msgParser.Parse(data); using (var repoUnit = new RepoUnit()) { repoUnit.FanLog.Save(MapToFanLog(paramsTable)); repoUnit.Commit(); } }
public BlockLog GetBlockLogById(int id) { BlockLog block; using (var repoUnit = new RepoUnit()) { block = repoUnit.BlockLog.FindFirstBy(blc => blc.Id == id); } return(block); }
public List <int> GetBlocksIds(DateTime from, DateTime till) { var ids = new List <int>(); using (var repoUnit = new RepoUnit()) { ids.AddRange(repoUnit.BlockLog.Load(blc => blc.Date > from && blc.Date < till).Select(r => r.Id)); } return(ids); }
public void SetUp() { _repoUnit = new RepoUnit(); Ioc.RegisterInstance<RepoUnit>(_repoUnit); _users.Values.ToList().ForEach(_repoUnit.User.Save); _service = new EventSavingService(_repoUnit); Ioc.RegisterInstance<EventSavingService>(_service); }
public List <int> GetGeneralLogIds(DateTime from, DateTime till) { var ids = new List <int>(); using (var repoUnit = new RepoUnit()) { ids.AddRange(repoUnit.GeneralLog.Load(gl => gl.Date > from && gl.Date < till).Select(r => r.Id)); } return(ids); }
public List<string> GetDigitSignalNames() { var names = new List<string>(); using (var unit = new RepoUnit()) { names.AddRange(unit.DoorType.Load().Select(s => s.Type).ToList()); } return names; }
public List <DateTime> GetBlocksDateTimes(DateTime from, DateTime till) { var dates = new List <DateTime>(); using (var repoUnit = new RepoUnit()) { dates.AddRange(repoUnit.BlockLog.Load(blc => blc.Date > from && blc.Date < till).Select(r => r.Date)); } return(dates); }
public List <string> GetAnalogSignalsNames() { var names = new List <string>(); using (var repoUnit = new RepoUnit()) { names.AddRange(repoUnit.AnalogSignal.Load().Select(an => an.Type)); } return(names); }
public void SetUp() { DiMvc.Register(); Ioc.RegisterType<ITeamRepository, TeamRepository>(); _unit = new RepoUnit(); _unit.Team.Save(new Team { Name = ".NET", Description = ".NET"}); _unit.Team.Save(new Team { Name = "PHP", Description = "PHP" }); _teamController = new TeamController(new TeamService(_unit)); }
public List<Parameter> GetAnalogSignals(int fanObjectNum) { var parameters = new List<Parameter>(); using (var unit = new RepoUnit()) { if (isFanLogEmpty(unit, fanObjectNum)) return null; var analogSignals = unit.FanLog.LastRecord(f => f.FanNumber == fanObjectNum).AnalogSignalLogs.ToList(); parameters.AddRange(analogSignals.Select(signal => new Parameter {Name = signal.SignalType.Type, Value = signal.SignalValue})); } return parameters; }
public List <List <ParameterData> > GetAnalogSignals(DateTime from, DateTime till) { var parameterData = new List <List <ParameterData> >(); using (var repoUnit = new RepoUnit()) { var blocks = repoUnit.BlockLog.Load(blc => blc.Date > from && blc.Date < till); parameterData.AddRange(blocks.Select(block => block.AnalogSignalLogs.Select(b => new ParameterData { Name = b.SignalType.Type, Value = b.SignalValue.ToString() }).ToList()).ToList()); } return(parameterData); }
public void SetupFixture() { FakeDi.Register(); _config = Config.Instance as FakeConfig; var repoUnit = new RepoUnit(); Ioc.RegisterInstance<RepoUnit>(repoUnit); _rooms.Values.ToList().ForEach(repoUnit.Room.Save); _roomService = new RoomService(repoUnit); Ioc.RegisterInstance<RoomService>(_roomService); }
public void FillGeneralLog(string line, string shortLine, GeneralLogEventType type) { var generalLog = new GeneralLog { Date = DateTime.Now, GeneralLogTypeId = Convert.ToInt32(type), LogLine = line, LogShortLine = shortLine }; using (var repoUnit = new RepoUnit()) { repoUnit.GeneralLog.Save(generalLog); } }
public void Setup() { DiMvc.Register(); Ioc.RegisterType<IUserRepository, UserRepository>(); _repoUnit = Ioc.Resolve<RepoUnit>(); _userService = new UserService(_repoUnit, Ioc.Resolve<ContactService>()); //Save last record id for post test database cleaning var lastRecord = _repoUnit.User.Load().ToList().LastOrDefault(); _lastDbRecordId = lastRecord == null ? 0 : lastRecord.Id; }
public void GenerateClients(RepoUnit repoUnit, int count = 1000) { for (var i = 1; i < count; i++) { var user = new User { Email = string.Format("test{0}@gmail.com", i), FirstName = "Test" + i, LastName = "Test", Role = Roles.Simple, Live = LiveStatuses.Active, ApproveState = ApproveStates.Approved }; repoUnit.User.Save(user); } }
public FanObject GetFanObject(int fanOjbectNum) { var fanObjectVm = new FanObject {FanObjectId = fanOjbectNum}; using (var unit = new RepoUnit()) { if (isFanLogEmpty(unit, fanOjbectNum)) return null; var fanLog = unit.FanLog.LastRecord(f => f.FanNumber == fanOjbectNum); fanObjectVm.Parameters.AddRange( fanLog.AnalogSignalLogs.Select( s => new Parameter { Name = s.SignalType.Type, Value = s.SignalValue, State = SystemStateService.GetParameterState(s.SignalType.Type,s.SignalValue) })); fanObjectVm.Doors.AddRange(fanLog.DoorsLogs.Select(d => new Door {Type = d.DoorType.Type, State = d.DoorState.State, StateId = d.DoorStateId, TypeId = d.DoorTypeId})); fanObjectVm.WorkingFanNumber = GetWorkingFanNumber(fanLog.Fan1State_Id, fanLog.Fan2State_Id); fanObjectVm.Date = fanLog.Date; } return fanObjectVm; }
public List <ParameterData> GetOutputSignalsByIdArchiv(int id) { var parameterData = new List <ParameterData>(); using (var repoUnit = new RepoUnit()) { var block = repoUnit.BlockLog.FindFirstBy(blc => blc.Id == id); var byteList = new List <byte?> { block.OutputSignalsLogs.First().Vio7, block.OutputSignalsLogs.First().Vio8, block.OutputSignalsLogs.First().Vio9, block.OutputSignalsLogs.First().Vio11, block.OutputSignalsLogs.First().Vio12 }; foreach (var _byte in byteList) { byte?b = _byte; if (b == null) { for (int i = 0; i < 8; i++) { parameterData.Add(new ParameterData { Name = "", Value = "нет данных" }); } } else { for (int i = 0; i < 8; i++) { parameterData.Add(new ParameterData { Name = "", Value = (b & 0x01) == 1 ? Convert.ToString(0) : Convert.ToString(1) }); b = (byte)(b >> 1); } } } } return(parameterData); }
public override string[] GetUsersInRole(string roleName) { bool roleFound = RoleExists(roleName); if (!roleFound) { throw new NotImplementedException(); } Models.Roles searchedRole; Enum.TryParse(roleName, out searchedRole); using (var unit = new RepoUnit()) { var usersInRole = unit.User.Get(u => u.Role == searchedRole); if (usersInRole == null) return null; var usersInRoleEmails = usersInRole.Email; return new[] {usersInRoleEmails}; } }
public List <ParameterData> GetInputSignalsById(int id) { var parameterData = new List <ParameterData>(); using (var repoUnit = new RepoUnit()) { var block = repoUnit.BlockLog.FindFirstBy(blc => blc.Id == id); var byteList = new List <byte?> { block.InputSignalsLogs.First().Vio0, block.InputSignalsLogs.First().Vio1, block.InputSignalsLogs.First().Vio2, block.InputSignalsLogs.First().Vio3 }; foreach (var _byte in byteList) { byte?b = _byte; if (b == null) { for (int i = 0; i < 8; i++) { parameterData.Add(new ParameterData { Name = "", Value = "нет данных" }); } } else { for (int i = 0; i < 8; i++) { parameterData.Add(new ParameterData { Name = "", Value = (b & 0x01) == 1 ? "Лог '0'" : "Лог '1'" }); b = (byte)(b >> 1); } } } } return(parameterData); }
public void Setup() { FakeDi.Register(); _repoUnit = new RepoUnit(); Ioc.RegisterInstance<RepoUnit>(_repoUnit); _teams = new List<Team> { new Team {Name = ".NET", Description = ".NET team"}, new Team {Name = ".PHP", Description = ".PHP team"}, new Team {Name = ".C++", Description = ".C++ team"} }; _teams.ForEach(_repoUnit.Team.Save); _config = Config.Instance as FakeConfig; _config.PageSize = _teams.Count; _teamService = new TeamService(_repoUnit); Ioc.RegisterInstance<TeamService>(_teamService); }
public void SetUpFixture() { FakeDi.Register(); _config = Config.Instance as FakeConfig; //Create and populate repository instance _repository = new RepoUnit(); Ioc.RegisterInstance<RepoUnit>(_repository); _users = new List<User> { new User {Email = "*****@*****.**", FirstName = "Saveli", LastName = "Bondini", Role = Roles.Simple, ApproveState = ApproveStates.Approved, Live = LiveStatuses.Active}, new User {Email = "*****@*****.**", FirstName = "Dima", LastName = "Rossi", Role = Roles.Simple, ApproveState = ApproveStates.Approved, Live = LiveStatuses.Active}, new User {Email = "*****@*****.**", FirstName = "Dima", LastName = "Prohorov", Role = Roles.Simple, ApproveState = ApproveStates.Approved, Live = LiveStatuses.Active}, new User {Email = "*****@*****.**", FirstName = "Alex", LastName = "Sinov", Role = Roles.Simple, ApproveState = ApproveStates.Approved, Live = LiveStatuses.Active} }; _users.ForEach(_repository.User.Save); _userService = new UserService(_repository, Ioc.Resolve<ContactService>()); Ioc.RegisterInstance<UserService>(_userService); }
public void SetUpFixture() { FakeDi.Register(); var team = new Team { Name = ".NET", Description = ".NET TEAM" }; var repoUnit = new RepoUnit(); Ioc.RegisterInstance<RepoUnit>(repoUnit); _teamService = new TeamService(repoUnit); Ioc.RegisterInstance<TeamService>(_teamService); _teamService.CreateTeam(new TeamEditVm(team)); //Setup Team controller and mock http context var dummyRequestContext = new RequestContext(new Mock<HttpContextBase>().Object, new RouteData()); _teamController = Ioc.Resolve<TeamController>(); _teamController.Url = new UrlHelper(dummyRequestContext); }
public HomeService(UsersRules rules, RepoUnit unit, EventSavingService calendarEventService) { _savingService = calendarEventService; _rules = rules; _unit = unit; var users = unit.User.Load(); if (!users.Any()) { var defaultUser = new User { BirthDate = null, Email = "Admin", FirstName = "Admin", LastName = "Admin", Role = Roles.Admin, PasswordHash = "Admin", PasswordSalt = "", Live = LiveStatuses.Active, ApproveState = ApproveStates.Approved }; unit.User.Save(defaultUser); } }
public EmailEventReminder(RepoUnit repoUnit, EmailSender emailSender) { _unit = repoUnit; _emailSender = emailSender; }
public void ShowDoor(PlotModel plotModel, int fanObjectId, string doorName, DateTime from, DateTime to) { try { using (var repoUnit = new RepoUnit()) { var tmp = repoUnit.FanLog.Load().Where(f => f.FanNumber == fanObjectId && f.Date > from && f.Date < to) .Select(f => new { Date = f.Date, Door = f.DoorsLogs.FirstOrDefault(a => a.DoorType.Type == doorName) }) .Select(s => new OxyPlotData { DateTime = s.Date, Value = s.Door.DoorState.State == "Открыт" ? 1 : s.Door.DoorState.State == "Закрыт" ? 0 : 0.5, ParamName = s.Door.DoorType.Type }); LoadData(plotModel, tmp.ToList()); } } catch (Exception ex) { } }
public void ShowSignal(PlotModel plotModel, int fanObjectId, string paramName, DateTime from, DateTime to) { try { using (var repoUnit = new RepoUnit()) { var tmp = repoUnit.FanLog.Load().Where(f => f.FanNumber == fanObjectId && f.Date > from && f.Date < to) .Select(f => new { Date = f.Date, AnalogSignal = f.AnalogSignalLogs.FirstOrDefault(a => a.SignalType.Type == paramName) }) .Select(s => new OxyPlotData { DateTime = s.Date, Value = s.AnalogSignal.SignalValue, ParamName = s.AnalogSignal.SignalType.Type }); LoadData(plotModel, tmp.ToList()); } } catch(Exception ex) {} }
public void FillDataBase(List <Parameters> parameters) { if (_fillDataBase == 1) { var analogSignals = new List <AnalogSignalLog>(); int j = 0; foreach (var param in parameters) { analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 1, SignalValue = -param.s }); analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 2, SignalValue = -param.s_two }); analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 3, SignalValue = param.v }); analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 4, SignalValue = param.a }); analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 5, SignalValue = param.tok_anchor }); analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 6, SignalValue = param.tok_excitation }); analogSignals.Add(new AnalogSignalLog { NodeId = j + 1, SignalTypeId = 7, SignalValue = param.defence_diagram }); j++; } var inputSignals = new InputSignalsLog { Vio0 = parameters[_mineConfig.LeadingController - 1].AuziDIByteList[0], Vio1 = parameters[_mineConfig.LeadingController - 1].AuziDIByteList[1], Vio2 = parameters[_mineConfig.LeadingController - 1].AuziDIByteList[2], Vio3 = parameters[_mineConfig.LeadingController - 1].AuziDIByteList[3] }; var outputSignals = new OutputSignalsLog { Vio7 = parameters[_mineConfig.LeadingController - 1].AuziDOByteList[0], Vio8 = parameters[_mineConfig.LeadingController - 1].AuziDOByteList[1], Vio9 = parameters[_mineConfig.LeadingController - 1].AuziDOByteList[2], Vio11 = parameters[_mineConfig.LeadingController - 1].AuziDOByteList[3], Vio12 = parameters[_mineConfig.LeadingController - 1].AuziDOByteList[4] }; var blockLog = new BlockLog { Date = DateTime.Now, AnalogSignalLogs = analogSignals, InputSignalsLogs = new Collection <InputSignalsLog> { inputSignals }, OutputSignalsLogs = new Collection <OutputSignalsLog> { outputSignals } }; using (var repoUnit = new RepoUnit()) { repoUnit.BlockLog.Save(blockLog); } _fillDataBase = 0; } }
public UserService(RepoUnit unit, ContactService contactService) { _contactService = contactService; _unit = unit; }
public override bool ValidateUser(string userEmail, string password) { using (var unit = new RepoUnit()) { var user = unit.User.Get(u => u.Email == userEmail); if (user == null) return false; var passwordSalt = user.PasswordSalt; var passwordHash = _crypto.GetHashWithSalt(password, passwordSalt); if (user.PasswordHash == passwordHash) return true; } return false; }
public List<OnPlotClickData> HistoryFind(int fanLogId) { var propertyList = new List<OnPlotClickData>(); try { using (var repoUnit = new RepoUnit()) { var fansLogRepo = repoUnit.FanLog; var fansLog = fansLogRepo.Load().FirstOrDefault(n=> n.Id == fanLogId); propertyList.Add(new OnPlotClickData { Property = "Время приема параметров", Value = fansLog.Date.ToString() }); propertyList.Add(new OnPlotClickData { Property = "Вентилятор 1", Value = fansLog.Fan1State.State }); propertyList.Add(new OnPlotClickData { Property = "Вентилятор 2", Value = fansLog.Fan2State.State }); propertyList.AddRange(fansLog.DoorsLogs.Select(doorLog => new OnPlotClickData { Property = doorLog.DoorType.Type, Value = doorLog.DoorState.State })); propertyList.AddRange(fansLog.AnalogSignalLogs.Select(signal => new OnPlotClickData { Property = signal.SignalType.Type, Value = signal.SignalValue.ToString() })); } } catch (Exception ex) { //nothing in Db } return propertyList; }
public List<int> HistoryGetRecordsCount(int fanNum, DateTime dateFrom, DateTime dateTill) { using (var repoUnit = new RepoUnit()) { var fansLogRepo = repoUnit.FanLog; var fansLogId = fansLogRepo.Load() .Where(n => n.FanNumber == fanNum && n.Date >= dateFrom && n.Date <= dateTill) .Select(n => n.Id); return fansLogId.ToList(); } }
private bool isFanLogEmpty(RepoUnit unit, int fanObjectNum) { return unit == null || !unit.FanLog.Load(f => f.FanNumber == fanObjectNum).Any(); }