/// <summary>
/// AssemblyConfiguration method implementation
/// </summary>
public bool SetAssemblyConfiguration(AssemblyConfiguration cfg, AssemblyConfiguration newcfg)
{
using (var cnx = new SqlConnection(ConnectString()))
{
string upd = "UPDATE dbo.AssemblyConfiguration SET AssemblyFulldescription = @AssemblyFulldescription, AssemblyTypeDescription = @AssemblyTypeDescription, TraceResolve = @TraceResolve, Selected = @Selected, ClaimsExt=@ClaimsExt WHERE AssemblyFulldescription = @OldAssemblyFulldescription AND AssemblyTypeDescription = @OldAssemblyTypeDescription";
string ins = "INSERT INTO dbo.AssemblyConfiguration (AssemblyFulldescription, AssemblyTypeDescription, TraceResolve, Selected, ClaimsExt) VALUES (@AssemblyFulldescription, @AssemblyTypeDescription, @TraceResolve, @Selected, @ClaimsExt)";
cnx.Open();
if (cfg != null) // Update
{
if (cnx.Execute(upd, new { AssemblyFulldescription = newcfg.AssemblyFulldescription, AssemblyTypeDescription = newcfg.AssemblyTypeDescription, TraceResolve = newcfg.TraceResolve, Selected = newcfg.Selected, ClaimsExt = newcfg.ClaimsExt, OldAssemblyFulldescription = cfg.AssemblyFulldescription, OldAssemblyTypeDescription = cfg.AssemblyTypeDescription }) >= 1)
{
return(true);
}
else // do insert not probable
{
return(cnx.Execute(ins, new { AssemblyFulldescription = newcfg.AssemblyFulldescription, AssemblyTypeDescription = newcfg.AssemblyTypeDescription, TraceResolve = newcfg.TraceResolve, Selected = newcfg.Selected, ClaimsExt = newcfg.ClaimsExt }) == 1);
}
}
else // Insert
{
if (cnx.Execute(upd, new { AssemblyFulldescription = newcfg.AssemblyFulldescription, AssemblyTypeDescription = newcfg.AssemblyTypeDescription, TraceResolve = newcfg.TraceResolve, Selected = newcfg.Selected, ClaimsExt = newcfg.ClaimsExt, OldAssemblyFulldescription = newcfg.AssemblyFulldescription, OldAssemblyTypeDescription = newcfg.AssemblyTypeDescription }) >= 1)
{
return(true);
}
else // do insert
{
return(cnx.Execute(ins, new { AssemblyFulldescription = newcfg.AssemblyFulldescription, AssemblyTypeDescription = newcfg.AssemblyTypeDescription, TraceResolve = newcfg.TraceResolve, Selected = newcfg.Selected, ClaimsExt = newcfg.ClaimsExt }) == 1);
}
}
}
}
/// <summary>
/// DeleteDomainConfiguration method implementation
/// </summary>
public bool DeleteAssemblyConfiguration(AssemblyConfiguration cfg)
{
using (var cnx = new SqlConnection(ConnectString()))
{
string del = "DELETE FROM dbo.AssemblyConfiguration WHERE AssemblyFulldescription = @AssemblyFulldescription AND AssemblyTypeDescription = @AssemblyTypeDescription";
cnx.Open();
if (cnx.Execute(del, new { AssemblyFulldescription = cfg.AssemblyFulldescription, AssemblyTypeDescription = cfg.AssemblyTypeDescription }) >= 1)
{
return(true);
}
else
{
return(false);
}
}
}