private static async Task loadTestDataAsync()
{
await loadInitDataAsync();
var initDb = DbSettings.GetConnection("init");
await Task.Run(() =>
{
using (var initdb = new CarWashDb(initDb.ConnectionString))
{
using (var db = GetDb())
{
db.BeginTransaction();
db.BulkCopy(initdb.Workers.ToList());
db.BulkCopy(initdb.Services.ToList());
db.BulkCopy(initdb.Pricelists.ToList());
db.BulkCopy(initdb.PricelistItems.ToList());
db.BulkCopy(initdb.Discountlists.ToList());
db.BulkCopy(initdb.DiscountlistItems.ToList());
db.BulkCopy(initdb.Clients.ToList());
db.BulkCopy(initdb.CarModels.ToList());
db.BulkCopy(initdb.Cars.ToList());
db.CommitTransaction();
}
}
});
}
private static void tryDropTable <T>(CarWashDb db) where T : class
{
try
{
db.DropTable <T>();
}
catch
{
}
}
private static void tryCreateTable <T>(CarWashDb db) where T : class
{
try
{
db.CreateTable <T>();
}
catch
{
}
}
private static async Task loadInitDataAsync()
{
var initDb = DbSettings.GetConnection("init");
await Task.Run(() =>
{
using (var initdb = new CarWashDb(initDb.ConnectionString))
{
using (var db = GetDb())
{
var x = initdb.DbPatches.ToList();
db.BeginTransaction();
db.BulkCopy(initdb.DbPatches.ToList());
db.BulkCopy(initdb.DbSettings.ToList());
db.BulkCopy(initdb.Users.ToList());
db.BulkCopy(initdb.Apps.ToList());
db.CommitTransaction();
}
}
});
}
public DiscountlistManager(CarWashDb db) : base(db)
{
}
public OrderManager(CarWashDb db) : base(db)
{
}
public AppItemManager(CarWashDb db) : base(db)
{
}
public DbSettingManager(CarWashDb db)
{
_db = db;
}
public CarModelManager(CarWashDb db) : base(db)
{
}
public ClientManager(CarWashDb db) : base(db)
{
}
public UserManager(CarWashDb db) : base(db)
{
}
public void SetDb(CarWashDb db)
{
_db = db;
}
public PricelistManager(CarWashDb db) : base(db)
{
}
public static ValidationResult Validate <V, T>(this T entity, string validationRuleSet, CarWashDb db) where V : class, new() where T : class
{
var validator = new V() as DbValidator <T>;
validator.SetDb(db);
var validationResult = DefaultValidatorExtensions.Validate(validator, entity, ruleSet: validationRuleSet);
return(validationResult);
}
public static void ValidateAndThrow <V, T>(this T entity, string validationRuleSet, CarWashDb db) where V : class, new() where T : class
{
var validationResult = Validate <V, T>(entity, validationRuleSet, db);
if (!validationResult.IsValid)
{
throw new CarWashValidationException(validationResult.Errors);
}
}
public static void ValidateAndThrow <V, T>(this T entity, CarWashDb db) where V : class, new() where T : class
{
entity.ValidateAndThrow <V, T>("default", db);
}
public static ValidationResult Validate <V, T>(this T entity, CarWashDb db) where V : class, new() where T : class
{
return(entity.Validate <V, T>("default", db));
}
public ServiceManager(CarWashDb db) : base(db)
{
}
public EntityManager(CarWashDb db)
{
_db = db;
}
public WorkerManager(CarWashDb db) : base(db)
{
}
public DbValidator(CarWashDb db)
{
_db = db;
}
