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 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 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 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 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);
}
}
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 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 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 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 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 = (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 = (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 = (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 = (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");
}
public JsonResult GetListFilesInfo([FromBody] ListFileInfoData list)
{
//Формирование полного пути
string mainPath = Request.MapPath("..//data//" + list.Login);
//Получение массивов путей к файлам
string[] masb = Directory.GetFiles(mainPath + "\\Backups");
string[] masp = Directory.GetFiles(mainPath + "\\Photos");
string[] masd = Directory.GetFiles(mainPath + "\\Documents");
string[] masm = Directory.GetFiles(mainPath);
//Получение списков имен файлов
List <string> backupFileNames = new List <string>();
List <string> photoFileNames = new List <string>();
List <string> documentFileNames = new List <string>();
List <string> mainFileNames = new List <string>();
foreach (var elem in masb)
{
FileInfo infFile = new FileInfo(elem);
backupFileNames.Add(infFile.Name);
}
foreach (var elem in masp)
{
FileInfo infFile = new FileInfo(elem);
photoFileNames.Add(infFile.Name);
}
foreach (var elem in masd)
{
FileInfo infFile = new FileInfo(elem);
documentFileNames.Add(infFile.Name);
}
foreach (var elem in masm)
{
FileInfo infFile = new FileInfo(elem);
mainFileNames.Add(infFile.Name);
}
if (list.FilesInfo != null)
{
foreach (var elem in list.FilesInfo)
{
switch (elem.FileType)
{
case FileToUpload.Settings:
{
using (ServerDatabaseContext databaseContext = new ServerDatabaseContext())
{
UserTable user = databaseContext.UserTables.FirstOrDefault(u => u.Login == list.Login);
if (user.DateEditSetting == null || elem.DateChange - user.DateEditSetting.Value > TimeSpan.FromMinutes(1))
{
user.DateEditSetting = DateTime.Now;
databaseContext.SaveChanges();
elem.IsUpload = true;
}
else if (user.DateEditSetting.Value - elem.DateChange > TimeSpan.FromMinutes(1))
{
if (System.IO.File.Exists(mainPath + "\\" + elem.NameFile))
{
elem.IsDownload = true;
}
}
if (mainFileNames.Contains(elem.NameFile))
{
mainFileNames.Remove(elem.NameFile);
}
}
break;
}
case FileToUpload.Database:
{
using (ServerDatabaseContext databaseContext = new ServerDatabaseContext())
{
UserTable user = databaseContext.UserTables.FirstOrDefault(u => u.Login == list.Login);
if (user.DateEditDatabase == null || elem.DateChange - user.DateEditDatabase.Value > TimeSpan.FromMinutes(1))
{
user.DateEditDatabase = DateTime.Now;
databaseContext.SaveChanges();
elem.IsUpload = true;
}
else if (user.DateEditDatabase.Value - elem.DateChange > TimeSpan.FromMinutes(1))
{
if (System.IO.File.Exists(mainPath + "\\" + elem.NameFile))
{
elem.IsDownload = true;
}
}
if (mainFileNames.Contains(elem.NameFile))
{
mainFileNames.Remove(elem.NameFile);
}
}
break;
}
case FileToUpload.Backup:
{
if (!backupFileNames.Contains(elem.NameFile))
{
using (ServerDatabaseContext databaseContext = new ServerDatabaseContext())
{
UserTable user = databaseContext.UserTables.FirstOrDefault(u => u.Login == list.Login);
databaseContext.BackupTables.Add(new BackupTable {
BackupName = elem.NameFile, DateOfCreate = DateTime.Now,
UserId = user.UserId
});
databaseContext.SaveChanges();
elem.IsUpload = true;
}
}
else
{
backupFileNames.Remove(elem.NameFile);
}
break;
}
case FileToUpload.Document:
{
if (!documentFileNames.Contains(elem.NameFile))
{
elem.IsUpload = true;
}
else
{
documentFileNames.Remove(elem.NameFile);
}
break;
}
case FileToUpload.Photo:
{
if (!photoFileNames.Contains(elem.NameFile))
{
elem.IsUpload = true;
}
else
{
photoFileNames.Remove(elem.NameFile);
}
break;
}
}
}
}
List <FileInfoData> newList = list.FilesInfo.ToList();
if (documentFileNames.Count > 0)
{
foreach (var elem in documentFileNames)
{
newList.Add(new FileInfoData
{
DateChange = DateTime.Now,
FileType = FileToUpload.Document,
IsChanged = false,
IsDownload = true,
IsUpload = false,
NameFile = elem,
PathFile = ""
});
}
}
if (photoFileNames.Count > 0)
{
foreach (var elem in photoFileNames)
{
newList.Add(new FileInfoData
{
DateChange = DateTime.Now,
FileType = FileToUpload.Photo,
IsChanged = false,
IsDownload = true,
IsUpload = false,
NameFile = elem,
PathFile = ""
});
}
}
if (mainFileNames.Count > 0)
{
foreach (var elem in mainFileNames)
{
FileToUpload fileTo;
if (elem == "Settings.bin")
{
fileTo = FileToUpload.Settings;
}
else
{
fileTo = FileToUpload.Database;
}
newList.Add(new FileInfoData
{
DateChange = DateTime.Now,
FileType = fileTo,
IsChanged = false,
IsDownload = true,
IsUpload = false,
NameFile = elem,
PathFile = ""
});
}
}
list = new ListFileInfoData(newList.ToArray());
return(Json(list));
}
public virtual void Commit()
{
_context.SaveChanges();
}