public SqlQueryBase(DapperUnitOfWork unitOfWork)
{
UnitOfWork = unitOfWork;
}
public void TestInit()
{
IApplicationUnitOfWork unitOfWork = new DapperUnitOfWork();
ICommunityRepository communityReposity = new CommunityRepository(unitOfWork);
_areaContract = new AreaService(unitOfWork, communityReposity);
}
private void DemoUnitOfWork()
{
using (var uow = new DapperUnitOfWork(_connection))
{
#region --- 第一次交易 ---
// 介面型 + 泛型 (混搭)
var banknoteVaultRepository = uow.GetRepository <IBanknoteVaultRepository>();
var vault = new BanknoteVault()
{
TagId = 10000,
Number01 = 1,
Number02 = 2,
Number03 = 3,
Number04 = 4,
Number05 = 5,
};
banknoteVaultRepository.Add(vault); // 新增資料
vault.Number01 += 10;
banknoteVaultRepository.Update(vault); // 更新資料
// 找TagId
//var findVault = banknoteVaultRepository.FindTagId(10000);
// 介面型
var memberRepository = uow.GetRepository <IMemberRepository>();
var member = new Member
{
Name = "Frank",
Age = 28,
Phone = "123456789",
Address = "Hello"
};
memberRepository.Add(member);
// 泛型 (同上方) CRUD
var employeesRepository = uow.GetGenericRepository <Employees>();
var employees = new Employees()
{
Name = "Darren",
Title = "SoftWare Engineer"
};
employeesRepository.Add(employees);
//throw new Exception("Don't save the Member and Employees.");
// 儲存資料
uow.Save();
#endregion
#region --- 第二次交易 ---
member = new Member
{
Name = "Jimpo",
Age = 18,
Phone = "1222",
Address = "Hello~"
};
memberRepository.Add(member);
employees = new Employees()
{
Name = "1K",
Title = "SoftWare Engineer"
};
employeesRepository.Add(employees);
// 儲存資料
uow.Save();
#endregion
#region --- 第三次交易(失敗) ---
// 故意測試，此筆交易是否會成功
var employeesRepositoryNew = uow.GetGenericRepository <Employees>();
employeesRepository.Add(new Employees()
{
Name = "Mario", Title = "Engineer"
});
throw new Exception("Don't save the Member and Employees.");
// 儲存資料
uow.Save();
#endregion
}
}
public DapperConnection(DapperUnitOfWork context)
{
_context = context;
}
public TransferRepository()
{
IUnitOfWork unitOfWork = new DapperUnitOfWork();
_unitOfWork = (DapperUnitOfWork)unitOfWork;
}
/// <summary> Constructor. </summary>
/// <param name="dataService"> The data service. </param>
/// <param name="parentUnitOfWork"> The parent unit of work. </param>
public DapperIdentityUnitOfWork(DapperDataService dataService, DapperUnitOfWork parentUnitOfWork) : base(
dataService, parentUnitOfWork)
{
}
public DapperRepositoryBase(DapperUnitOfWork unitOfWork)
{
UnitOfWork = unitOfWork;
}
public TransacaoRepository()
{
IUnitOfWork unidadeDeTrabalho = new DapperUnitOfWork();
_unidadeDeTrabalho = (DapperUnitOfWork)unidadeDeTrabalho;
}
public PersonRepository(DapperUnitOfWork unitOfWork)
: base(unitOfWork)
{
}
public DapperRepositoryBase(DapperUnitOfWork unitOfWork) : base(unitOfWork)
{
EnableNamedParams = true;
ForceDateTimesToUtc = true;
}
/// <summary>Constructor.</summary>
/// <param name="dataService"> The data service. </param>
/// <param name="parentUnitOfWork"> The parent unit of work. </param>
public DapperDataProtectionUnitOfWork(DapperDataService dataService, DapperUnitOfWork parentUnitOfWork) : base(
dataService, parentUnitOfWork)
{
}
