public void AddLandOwner(LandOwner o, int farmerId) { using (var scope = new TransactionScope()) { farmerVersionRepo.UpdateWhatWhere(new { EndDate = DateTime.Now }, new { farmerId, EndDate = DBNull.Value }); o.FarmerVersionId = farmerVersionRepo.Insert(new FarmerVersion { FarmerId = farmerId, StartDate = DateTime.Now }); landOwnerRepo.Insert(o); scope.Complete(); } }
private async Task <string> LandOwnerSelection(LandOwner landOwners) { var AllOwner = await _landOwnerRepository.GetAll(); string strowner = ""; foreach (var item in AllOwner) { if (item.OwnerID == landOwners.OwnerID) { strowner += string.Format("<Option Value={0} selected >{1}</Option>", item.OwnerID, item.Name + " " + item.Family); } else { strowner += string.Format("<Option Value={0} >{1}</Option>", item.OwnerID, item.Name + " " + item.Family); } } return(strowner); }
public int CreateLandOwner(LandOwner o) { using (var scope = new TransactionScope()) { var farmerId = farmerRepo.Insert(new Farmer { FType = FarmerType.LandOwner }); var v = new FarmerVersion { FarmerId = farmerId, StartDate = DateTime.Now }; o.FarmerVersionId = farmerVersionRepo.Insert(v); landOwnerRepo.Insert(o); scope.Complete(); return(farmerId); } }