internal EditContext(ExecutionView view, Source source, string code)
{
_view = view;
Code = code;
Strips = new StripManager(Code);
_source = source;
}
public List<Figuur> GetFiguren()
{
List<Figuur> figuren = new List<Figuur>();
var manager = new StripManager();
using (var conStrip = manager.GetConnection())
{
using (var comFiguren = conStrip.CreateCommand())
{
comFiguren.CommandType = CommandType.Text;
comFiguren.CommandText = "select * from Figuren";
conStrip.Open();
using (var rdrFiguren = comFiguren.ExecuteReader())
{
Int32 IDPos = rdrFiguren.GetOrdinal("ID");
Int32 NaamPos = rdrFiguren.GetOrdinal("Naam");
Int32 VersiePos = rdrFiguren.GetOrdinal("Versie");
while (rdrFiguren.Read())
{
figuren.Add(new Figuur(rdrFiguren.GetInt32(IDPos),
rdrFiguren.GetString(NaamPos),
rdrFiguren.GetValue(VersiePos)));
}
}
}
}
return figuren;
}
internal EditContext(EditContext toClone)
{
_removedNodes = new HashSet <INodeAST>(toClone._removedNodes);
_source = toClone._source;
Strips = new StripManager(toClone.Strips);
IsCommited = toClone.IsCommited;
Code = toClone.Code;
}
public void SChrijfWijzigingen(List<Figuur> figuren)
{
var manager = new StripManager();
using (var conStrip = manager.GetConnection())
{
using (var comUpdate = conStrip.CreateCommand())
{
comUpdate.CommandType = CommandType.Text;
comUpdate.CommandText = "update figuren set Naam=@naam where ID=@id and Versie=@versie";
var parNaam = comUpdate.CreateParameter();
parNaam.ParameterName = "@naam";
comUpdate.Parameters.Add(parNaam);
var parVersie = comUpdate.CreateParameter();
parVersie.ParameterName = "@versie";
comUpdate.Parameters.Add(parVersie);
var parID = comUpdate.CreateParameter();
parID.ParameterName = "@id";
comUpdate.Parameters.Add(parID);
conStrip.Open();
foreach (var eenFiguur in figuren)
{
parNaam.Value = eenFiguur.Naam;
parVersie.Value = eenFiguur.Versie;
parID.Value = eenFiguur.ID;
if( comUpdate.ExecuteNonQuery() == 0)
{
throw new Exception("Iemand was je voor");
}
}
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SourceTest"/> class.
/// </summary>
/// <param name="test">The test.</param>
internal SourceTest(string test)
{
_strips = new StripManager(test);
}
public abstract void Initialize(StripManager m, RuntimePluginConfig rp);
