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