// private DecoderContext db = new DecoderContext();
public int? AddDecoder(Decoder decoder)
{
DecoderContext db = null;
try
{
db = new DecoderContext();
decoder.UpdateFieldsFromXml();
db.Decoders.Add(decoder);
db.SaveChanges();
return decoder.Id;
}
finally
{
db?.Dispose();
}
}
public void DeleteDecoder(int? id)
{
DecoderContext db = null;
try
{
db = new DecoderContext();
var decoder = db.Decoders.Find(id);
if (decoder != null)
{
db.Decoders.Remove(decoder);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("L'ID envoyée ne correspond à aucun décodeur dans la base de donnée");
}
}
finally
{
db?.Dispose();
}
}
public List<Decoder> FindDescendants(int? id)
{
DecoderContext db = null;
try
{
db = new DecoderContext();
var decoder = db.Decoders.Find(id);
if (decoder != null)
{
var names = new List<string>();
var decoders = new List<Decoder> { decoder };
// names.AddRange(decoder.FindDescendants());
var firsts = decoder.FindDescendants();
foreach (var name in firsts)
{
if (!names.Exists(x => x == name))
{
names.Add(name);
}
}
for (var i = 0; i < names.Count; i++)
{
var curName = names[i];
var descendant = db.Decoders.Single(d => d.Name == curName);
var namesToAdd = descendant.FindDescendants();
foreach (var name in namesToAdd)
{
if (!names.Exists(x => x == name))
{
names.Add(name);
}
}
decoders.Add(descendant);
}
return decoders;
/*var decoders = new List<Decoder>();
foreach (var name in names)
{
decoders.Add(db.Decoders.Find(name));
}
return decoders;*/
}
else
{
throw new KeyNotFoundException();
}
}
finally
{
db?.Dispose();
}
}
public bool UpdateDecoder(Decoder updatedDecoder)
{
DecoderContext db = null;
var mustRefreshToolbox = false;
try
{
db = new DecoderContext();
updatedDecoder.UpdateFieldsFromXml();
var decoder = db.Decoders.Find(updatedDecoder.Id);
if (decoder != null)
{
/*decoder.Name = updatedDecoder.Name;
decoder.Version = updatedDecoder.Version;
decoder.Category = updatedDecoder.Category;
decoder.Tags = updatedDecoder.Tags;
decoder.Xml = updatedDecoder.Xml;
decoder.Code = updatedDecoder.Code;
decoder.FrenchSpec = updatedDecoder.FrenchSpec;
decoder.UpdateFieldsFromXml();*/
if (decoder.Name != updatedDecoder.Name || decoder.Version != updatedDecoder.Version
|| decoder.Category != updatedDecoder.Category
|| decoder.Parameters != updatedDecoder.Parameters || decoder.Tags != updatedDecoder.Tags
|| decoder.Editable != updatedDecoder.Editable)
{
mustRefreshToolbox = true;
}
//TODO DO NOT OVERRIDE CODE AND SPEC
db.Entry(decoder).CurrentValues.SetValues(updatedDecoder);
db.SaveChanges();
return mustRefreshToolbox;
}
else
{
throw new KeyNotFoundException();
}
}
finally
{
db?.Dispose();
}
}
public Decoder GetDecoder(int? id)
{
DecoderContext db = null;
try
{
db = new DecoderContext();
var decoder = db.Decoders.Find(id);
if (decoder != null)
{
return decoder;
}
else
{
throw new KeyNotFoundException("L'ID envoyée ne correspond à aucun décodeur dans la base de donnée");
}
}
finally
{
db?.Dispose();
}
}
public Dictionary<string, List<BlockInfos>> GetCategoryInfos()
{
DecoderContext db = null;
try
{
db = new DecoderContext();
/* Dictionary<string, List<BlockInfos>> categoryInfos = db.Decoders
//.Select(d => new { d.Category, callInfos = new CallInfos(d.Id, d.Name, d.Parameters, d.Tags, d.Editable) })
.GroupBy(d => d.Category, d => new BlockInfos(d.Id, d.Name, d.Parameters, d.Tags, d.Editable))
.ToDictionary(g => g.Key, g => g.ToList());*/
var fromServer =
db.Decoders.Select(
d => new { d.Category, d.Id, d.Name, d.Parameters, d.Tags, d.Version, d.Editable }).ToList();
var categoryInfos =
fromServer.GroupBy(
d => d.Category,
d => new BlockInfos((int)d.Id, d.Name, d.Category, d.Parameters, d.Tags, d.Version, d.Editable))
.ToDictionary(d => d.Key, d => d.ToList());
return categoryInfos;
}
finally
{
db?.Dispose();
}
}
public IEnumerable<BlockInfos> GetAllBlockInfos()
{
DecoderContext db = null;
try
{
db = new DecoderContext();
var fromServer =
db.Decoders.ToList()
.Select(
d =>
new BlockInfos((int)d.Id, d.Name, d.Category, d.Parameters, d.Tags, d.Version, d.Editable));
return fromServer;
}
finally
{
db?.Dispose();
}
}
public List<string> FindProcedureUsages(int? id)
{
DecoderContext db = null;
try
{
db = new DecoderContext();
var decoder = db.Decoders.Find(id);
if (decoder != null)
{
var proceduresThatUseIt =
db.Decoders.Where(d => d.BlocklyDef.Contains("<mutation name=\"" + decoder.Name + "\">"))
.Select(d => d.Name)
.ToList();
return proceduresThatUseIt;
}
else
{
throw new KeyNotFoundException();
}
}
finally
{
db?.Dispose();
}
}