public void PutCharacteristic(string name, string value, int IdNote)
{
Characteristic character;
try
{
character = _dataCharacter.GetBy("Name", name.ToString()).First();
}
catch (InvalidOperationException)
{
_dataCharacter.Add(new Characteristic()
{
Name = name
});
character = _dataCharacter.GetBy("Name", name.ToString()).First();
}
_dataNoteCharacter.Add(new Note_Characteristic()
{
Id_Characteristic = character.Id_Characteristic,
Id_Note = IdNote,
Value = value
});
}
public CharacteristicHelper GetCharacteristic(int id)
{
IEnumerable <Note_Characteristic> characteristicsOfNote = _dataNoteCharacter.GetBy("Id_Note", id.ToString());
IEnumerable <Characteristic> characteristics = _dataCharacter.Get().Join(characteristicsOfNote, f => f.Id_Characteristic,
f => f.Id_Characteristic, (f1, f2) => f1);
CharacteristicHelper helper = new CharacteristicHelper()
{
Characteristics = characteristics,
CharacteristicsOfNote = characteristicsOfNote
};
return(helper);
}
public object GetLikeEnable(int id, string noteOrFile)
{
string login = User.Identity.Name.ToString();
if (noteOrFile == "note")
{
if (_dataNoteInfo.GetBy("Login", login).Where(a => a.Id_Note == id).Count() > 0)
{
return(_dataNoteInfo.GetBy("Login", login).Where(a => a.Id_Note == id).First());
}
}
else if (noteOrFile == "file")
{
if (_dataFileInfo.GetBy("Login", login).Where(a => a.Id_File == id).Count() > 0)
{
return(_dataFileInfo.GetBy("Login", login).Where(a => a.Id_File == id).First());
}
}
else
{
throw new ArgumentException("wrong description if likes");
}
return(Ok());
}
public NoteInfoHelper GetNoteInfo(int id)
{
IEnumerable <File> files = _dataFile.GetBy("Id_Note", id.ToString()).Where(f => f.Status == "Принято");
IEnumerable <Note_Characteristic> characteristicsOfNote = _dataNoteCharacter.GetBy("Id_Note", id.ToString());
List <Characteristic> characteristics = new List <Characteristic>();
foreach (var ch in characteristicsOfNote)
{
characteristics.Add(_dataCharacter.GetBy("Id_Characteristic", ch.Id_Characteristic.ToString()).First());
}
NoteInfoHelper helper = new NoteInfoHelper()
{
Characteristics = characteristics,
CharacteristicsOfNote = characteristicsOfNote,
Files = files
};
return(helper);
}
public Note GetRecord(int id)
{
Note rec = _dataNote.GetBy("Id_Note", id.ToString()).First();
return(rec);
}
public User Get(string login)
{
return(_dataUserInfo.GetBy("Login", login.ToString()).First());
}