public void ShouldDeleteDeviceForExistingEntry() { using (var context = new ServerDatabaseContext()) { context.Devices.Add(new Device { Id = 1, Description = "Device 1" }); context.Devices.Add(new Device { Id = 2, Description = "Device 2" }); context.Devices.Add(new Device { Id = 300, Description = "Device 300" }); context.SaveChanges(); } var requestHandler = new DeleteDeviceRequestHandler(); var response = (DeleteDeviceDataResponse)requestHandler.Handle(new DeleteDeviceDataRequest { Identifier = 2 }); response.Identifier.Should().Be(2); response.ResponseCode0.Should().Be(0); response.ResponseCode1.Should().Be(0); using (var context = new ServerDatabaseContext()) { var devices = context.Devices.ToList(); devices.Should().HaveCount(2); devices.Find(x => x.Id == 2).Should().BeNull(); } }
public JsonResult GetListBackups(string Login) { List <BackupElem> backups = new List <BackupElem>(); using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { UserTable user = databaseContext.UserTables.Where(u => u.Login == Login).FirstOrDefault(); List <BackupTable> backupTables = databaseContext.BackupTables.ToList(); if (backupTables != null) { foreach (var elem in backupTables) { if (elem.UserId == user.UserId) { backups.Add(new BackupElem { DateOfCreate = (DateTime)elem.DateOfCreate, DBMSName = "", Name = elem.BackupName }); } } } } return(Json(backups.ToArray(), JsonRequestBehavior.AllowGet)); }
public void ShouldReturnErrorResponseCodeIfIdIsUnknown() { using (var context = new ServerDatabaseContext()) { context.Rooms.Add(new Room { Id = 1, Description = "Room 1" }); context.Rooms.Add(new Room { Id = 2, Description = "Room 2" }); context.Rooms.Add(new Room { Id = 300, Description = "Room 300" }); context.SaveChanges(); } var requestHandler = new GetRoomDescriptionRequestHandler(); var response = (GetRoomDescriptionDataResponse)requestHandler.Handle(new GetRoomDescriptionDataRequest { Identifier = 99 }); response.ResponseCode0.Should().Be(0x01); response.ResponseCode1.Should().Be(0x00); response.Identifier.Should().Be(0); response.Description.Should().Be(""); }
public void ShouldUpdateDeviceDescriptionForExistingEntry() { const string newDeviceDescription = "New device"; using (var context = new ServerDatabaseContext()) { context.Devices.Add(new Device { Id = 1, Description = "Device 1" }); context.Devices.Add(new Device { Id = 2, Description = "Device 2" }); context.Devices.Add(new Device { Id = 300, Description = "Device 300" }); context.SaveChanges(); } var requestHandler = new RenameDeviceDescriptionRequestHandler(); requestHandler.Handle(new RenameDeviceDescriptionDataRequest { Identifier = 2, Description = newDeviceDescription }); using (var context = new ServerDatabaseContext()) { context.Devices.Find(2).Description.Should().Be(newDeviceDescription); } }
public void ShouldReturnErrorResponseCodeIfIdIsUnknown() { using (var context = new ServerDatabaseContext()) { context.Devices.Add(new Device { Id = 1, Description = "Device 1" }); context.Devices.Add(new Device { Id = 2, Description = "Device 2" }); context.Devices.Add(new Device { Id = 300, Description = "Device 300" }); context.SaveChanges(); } var requestHandler = new RenameDeviceDescriptionRequestHandler(); var response = (RenameDeviceDescriptionDataResponse)requestHandler.Handle(new RenameDeviceDescriptionDataRequest { Identifier = 99, Description = "New device" }); response.ResponseCode0.Should().Be(0x01); response.ResponseCode1.Should().Be(0x00); response.Identifier.Should().Be(99); }
public bool ExchangeNew(string LoginSender, string LoginCreator, int IsOneWay) { using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { UserTable creator = databaseContext.UserTables.Where(u => u.Login == LoginCreator).FirstOrDefault(); UserTable sender = databaseContext.UserTables.Where(u => u.Login == LoginSender).FirstOrDefault(); bool isOne = false; if (IsOneWay == 1) { isOne = true; } DatabaseExchangeTable exchange = new DatabaseExchangeTable { IsCreatorDone = false, IsOneWay = isOne, IsSenderAccept = null, IsSenderDone = false, UserCreatorId = creator.UserId, UserSenderId = sender.UserId }; if (IsOneWay == 1) { exchange.IsSenderDone = true; } databaseContext.DatabaseExchangeTables.Add(exchange); databaseContext.SaveChanges(); } return(true); }
public void ShouldReturnErrorResponseCodeIfIdIsUnknown() { using (var context = new ServerDatabaseContext()) { context.Devices.Add(new Device { Id = 1, Description = "Device 1" }); context.Devices.Add(new Device { Id = 2, Description = "Device 2" }); context.Devices.Add(new Device { Id = 300, Description = "Device 300" }); context.SaveChanges(); } var requestHandler = new DeleteDeviceRequestHandler(); var response = (DeleteDeviceDataResponse)requestHandler.Handle(new DeleteDeviceDataRequest { Identifier = 99 }); response.ResponseCode0.Should().Be(0x01); response.ResponseCode1.Should().Be(0x00); response.Identifier.Should().Be(0); using (var context = new ServerDatabaseContext()) { var devices = context.Devices.ToList(); devices.Should().HaveCount(3); } }
private void MigrateDatabase() { using (var db = new ServerDatabaseContext()) { // db.Database.EnsureDeleted(); db.Database.Migrate(); } }
public IResponse Handle(IRequest request) { using (var context = new ServerDatabaseContext()) { return(new GetAllRoomsDataResponse { Identifiers = context.Rooms.Select(x => x.Id).ToArray() }); } }
public void init() { var opBuilder = new DbContextOptionsBuilder <ServerDatabaseContext>(); var conStringBuilder = new SqliteConnectionStringBuilder(); conStringBuilder.DataSource = @"..\..\..\DBIO.db"; opBuilder.UseSqlite(conStringBuilder.ConnectionString); _context = new ServerDatabaseContext(opBuilder.Options); _userManager = new UserManager(_context); }
public ServerAPM(string IPAddress = "127.0.0.1", int port = 8001, int bufferSize = 1024) : base(System.Net.IPAddress.Parse(IPAddress), port) { Buffer_size = bufferSize; var opBuilder = new DbContextOptionsBuilder <ServerDatabaseContext>(); var conStringBuilder = new SqliteConnectionStringBuilder(); conStringBuilder.DataSource = @"..\..\..\DBIO.db"; opBuilder.UseSqlite(conStringBuilder.ConnectionString); this.context = new ServerDatabaseContext(opBuilder.Options); this.um = new UserManager(this.context); }
protected DatabaseTestBase() { ServerDatabaseContext.Options = new DbContextOptionsBuilder <ServerDatabaseContext>() .UseInMemoryDatabase("Testing") .Options; using (var context = new ServerDatabaseContext()) { context.Database.EnsureDeleted(); } }
//Возвращает true, если такого пользователя в базе данных не существует private bool IsLoginFromBase(string login) { using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { var query = databaseContext.UserTables.FirstOrDefault(u => u.Login == login); if (query != null) { return(true); } } return(false); }
public bool RegistrationUser(RegistrationData data) { using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { UserTable user = databaseContext.UserTables.FirstOrDefault(u => u.Login == data.Login && u.Md5 == data.Md5); if (user == null) { return(false); } else { return(true); } } }
public IResponse Handle(IRequest request) { var dataRequest = (GetDeviceDescriptionDataRequest)request; using (var context = new ServerDatabaseContext()) { var device = context.Devices.Find(dataRequest.Identifier); return(device == null ? new GetDeviceDescriptionDataResponse { Description = "", Identifier = 0, ResponseCode0 = 0x01, ResponseCode1 = 0x00 } : new GetDeviceDescriptionDataResponse { Description = device.Description, Identifier = device.Id }); } }
public IResponse Handle(IRequest request) { var dataRequest = (GetRoomDescriptionDataRequest)request; using (var context = new ServerDatabaseContext()) { var room = context.Rooms.Find(dataRequest.Identifier); return(room == null ? new GetRoomDescriptionDataResponse { Description = "", Identifier = 0, ResponseCode0 = 0x01, ResponseCode1 = 0x00 } : new GetRoomDescriptionDataResponse { Description = room.Description, Identifier = room.Id }); } }
public JsonResult GetExchangesToExchange(string Login) { List <ListExchangesData> exchangesDatas = new List <ListExchangesData>(); using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { UserTable user = databaseContext.UserTables.Where(u => u.Login == Login).FirstOrDefault(); List <DatabaseExchangeTable> exchanges = databaseContext.DatabaseExchangeTables.ToList(); if (exchanges != null) { foreach (var elem in exchanges) { if ((elem.UserCreatorId == user.UserId && !elem.IsCreatorDone) || (elem.UserSenderId == user.UserId && (!elem.IsSenderDone || elem.IsSenderAccept == null))) { ListExchangesData data = new ListExchangesData { ExchangeId = elem.DatabaseExchangeId, IsCreatorDone = elem.IsCreatorDone, IsIAmCreator = false, IsOneWay = elem.IsOneWay, IsSenderAccept = elem.IsSenderAccept, IsSenderDone = elem.IsSenderDone, LoginCreatorOrSender = "" }; if (user.UserId == elem.UserCreatorId) { data.IsIAmCreator = true; UserTable userTo = databaseContext.UserTables.First(u => u.UserId == elem.UserSenderId); data.LoginCreatorOrSender = userTo.Login; } else { UserTable userTo = databaseContext.UserTables.First(u => u.UserId == elem.UserCreatorId); data.LoginCreatorOrSender = userTo.Login; } exchangesDatas.Add(data); } } } } ExchangesDataArray array = new ExchangesDataArray(exchangesDatas.ToArray()); return(Json(array, JsonRequestBehavior.AllowGet)); }
public bool ExchangeAccept(int Id, int Accepting) { using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { DatabaseExchangeTable exchange = databaseContext.DatabaseExchangeTables.Where(u => u.DatabaseExchangeId == Id).FirstOrDefault(); if (Accepting == 0) { exchange.IsSenderAccept = false; } else { exchange.IsSenderAccept = true; } databaseContext.SaveChanges(); } return(true); }
public bool ExchangeDone(int Id, int Doned) { using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { DatabaseExchangeTable exchange = databaseContext.DatabaseExchangeTables.Where(u => u.DatabaseExchangeId == Id).FirstOrDefault(); if (Doned == 0) { exchange.IsSenderDone = false; } else { exchange.IsCreatorDone = true; } databaseContext.SaveChanges(); } return(true); }
public IResponse Handle(IRequest request) { var dataRequest = (CreateRoomDataRequest)request; Room room; using (var context = new ServerDatabaseContext()) { room = new Room { Description = dataRequest.Description }; context.Rooms.Add(room); context.SaveChanges(); } return(new CreateRoomDataResponse { Identifier = room.Id, ClientObjectIdentifier = dataRequest.ClientObjectIdentifier }); }
public void ShouldCreateNewRoom() { var requestHandler = new CreateRoomRequestHandler(); var response = (CreateRoomDataResponse)requestHandler.Handle(new CreateRoomDataRequest { ClientObjectIdentifier = 0x54, Description = "New room description" }); response.ClientObjectIdentifier.Should().Be(0x54); response.Identifier.Should().Be(0x01); using (var context = new ServerDatabaseContext()) { var rooms = context.Rooms.ToList(); rooms.Should().HaveCount(1); rooms[0].Description.Should().Be("New room description"); rooms[0].Id.Should().Be(0x01); } }
public IResponse Handle(IRequest request) { var dataRequest = (CreateDeviceDataRequest)request; Device device; using (var context = new ServerDatabaseContext()) { device = new Device { Description = dataRequest.Description }; context.Devices.Add(device); context.SaveChanges(); } return(new CreateDeviceDataResponse { Identifier = device.Id, ClientObjectIdentifier = dataRequest.ClientObjectIdentifier }); }
public JsonResult GetLoginsToExchange(string Login) { List <string> logins = new List <string>(); using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { List <UserTable> userTables = databaseContext.UserTables.ToList(); foreach (var elem in userTables) { if (elem.Login != Login) { logins.Add(elem.Login); } } } ListLoginsData listLoginsData = new ListLoginsData(logins.ToArray()); return(Json(listLoginsData, JsonRequestBehavior.AllowGet)); }
public bool RegistrationUser(RegistrationData data) { if (IsLoginFromBase(data.Login)) { return(false); } using (ServerDatabaseContext databaseContext = new ServerDatabaseContext()) { databaseContext.UserTables.Add(new UserTable() { Login = data.Login, Md5 = data.Md5, DateEditDatabase = null, DateEditSetting = null }); databaseContext.SaveChanges(); GenerateStructDirectoryes(data.Login); } return(true); }
public IResponse Handle(IRequest request) { var dataRequest = (DeleteDeviceDataRequest)request; using (var context = new ServerDatabaseContext()) { var device = context.Devices.Find(dataRequest.Identifier); if (device == null) { return new DeleteDeviceDataResponse { Identifier = 0, ResponseCode0 = 0x01, ResponseCode1 = 0x00 } } ; context.Remove(device); context.SaveChanges(); return(new DeleteDeviceDataResponse { Identifier = device.Id }); } } }
public IResponse Handle(IRequest request) { var dataRequest = (DeleteRoomDataRequest)request; using (var context = new ServerDatabaseContext()) { var room = context.Rooms.Find(dataRequest.Identifier); if (room == null) { return new DeleteRoomDataResponse { RoomIdentifier = 0, ResponseCode0 = 0x01, ResponseCode1 = 0x00 } } ; context.Remove(room); context.SaveChanges(); return(new DeleteRoomDataResponse { RoomIdentifier = room.Id }); } } }
public IResponse Handle(IRequest request) { var dataRequest = (RenameDeviceDescriptionDataRequest)request; using (var context = new ServerDatabaseContext()) { var device = context.Devices.Find(dataRequest.Identifier); if (device == null) { return new RenameDeviceDescriptionDataResponse { Identifier = dataRequest.Identifier, ResponseCode0 = 0x01, ResponseCode1 = 0x00 } } ; device.Description = dataRequest.Description; context.SaveChanges(); return(new RenameDeviceDescriptionDataResponse { Identifier = device.Id }); } } }
public IResponse Handle(IRequest request) { var dataRequest = (RenameRoomDescriptionDataRequest)request; using (var context = new ServerDatabaseContext()) { var room = context.Rooms.Find(dataRequest.Identifier); if (room == null) { return new RenameRoomDescriptionDataResponse { RoomIdentifier = dataRequest.Identifier, ResponseCode0 = 0x01, ResponseCode1 = 0x00 } } ; room.Description = dataRequest.Description; context.SaveChanges(); return(new RenameRoomDescriptionDataResponse { RoomIdentifier = room.Id }); } } }
public void ShouldReturnAllRoomIds() { using (var context = new ServerDatabaseContext()) { context.Rooms.Add(new Room { Id = 1 }); context.Rooms.Add(new Room { Id = 2 }); context.Rooms.Add(new Room { Id = 300 }); context.SaveChanges(); } var requestHandler = new GetAllRoomsRequestHandler(); var response = (GetAllRoomsDataResponse)requestHandler.Handle(new GetAllRoomsDataRequest()); response.Identifiers.Should().HaveCount(3); response.Identifiers[0].Should().Be(1); response.Identifiers[1].Should().Be(2); response.Identifiers[2].Should().Be(300); }
public void ShouldReturnRoomDescriptionForExistingEntry() { using (var context = new ServerDatabaseContext()) { context.Rooms.Add(new Room { Id = 1, Description = "Room 1" }); context.Rooms.Add(new Room { Id = 2, Description = "Room 2" }); context.Rooms.Add(new Room { Id = 300, Description = "Room 300" }); context.SaveChanges(); } var requestHandler = new GetRoomDescriptionRequestHandler(); var response = (GetRoomDescriptionDataResponse)requestHandler.Handle(new GetRoomDescriptionDataRequest { Identifier = 2 }); response.Identifier.Should().Be(2); response.Description.Should().Be("Room 2"); }