[TransactionAttribute(TransactionMode.Manual)]
[RegenerationAttribute(RegenerationOption.Manual)]
public class ParametersDialogCommand : IExternalCommand
{
public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
Statistic.SendStatistic("P", "PC" );
\...
..../
return Result.Succeeded;
}
}
public static class Statistic
{
public static void SendStatistic(string plaginName, string buttonName)
{
StatisticElement element = new StatisticElement()
{
\...
..../
};
try
{
SendStatistic(element);
}
catch (Exception e){ new ExceptionWindow(e); }
}
private static void SendStatistic(StatisticElement element)
{
using (StatisticContext db = new StatisticContext())
{
db.StatisticElements.Add(element);
db.SaveChanges();
}
}
}
public class StatisticContext : DbContext
{
public DbSet<StatisticElement> StatisticElements { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseNpgsql("Host=192.168.5.71; Port=5432; Database=StatisticElements; Username=user; Password=pas");
}
}