public virtual string Add(MasterData data) { var newMasterData = new TESTENTITY() { Id = "123", STRING = data.city, ISACTIVE = SafeConvert.ToInt64(data.isActive), COMMENT = data.comment, TESTENTITY2ID = data.combobox, REGISTERTIME = data.registerTime, }; var Id = testRepository.Insert(newMasterData).Id; // testRepository.InsertOrUpdate(newMasterData); return(Id); // testRepository.Update(t => t.Id == "57627fde-0332-4db0-9036-ce3ec5e48496", t => // new TESTENTITY() // { // // COMMENT = DateTime.Now.ToString("HH:mm:ss") // } // ); //throw new Exception(); //test2Repository.Update(t => t.Id == "123",t => new TESTENTITY2() { // Text = DateTime.Now.ToString("HH:mm:ss tt zz") //}); return(null); }
//Test in tow module???? public void TransactionInMultipleRepository() { var rep = Resolve <ITestRepository>(); var rep2 = Resolve <ITest2Repository>(); var appService = Resolve <ITransactionAppService>(); var guid = Guid.NewGuid().ToString(); var testEntity = new TESTENTITY() { Id = guid, TESTENTITY2ID = guid, COLNUMINT = 1, ISACTIVE = 1 }; var testEntity2 = new TESTENTITY2() { Id = guid, CREATEDATE = DateTime.Now }; appService.MultipleAction(testEntity, testEntity2); Assert.NotNull(rep.FirstOrDefault(t => t.Id == guid)); Assert.NotNull(rep2.FirstOrDefault(t => t.Id == guid)); rep.Delete(testEntity); rep2.Delete(testEntity2); guid = Guid.NewGuid().ToString(); testEntity.Id = guid; testEntity2.Id = guid; Assert.Throws <TestTransactionException>(() => appService.MultipleActionWhenException(testEntity, testEntity2)); Assert.Null(rep.FirstOrDefault(t => t.Id == guid)); //rep.Delete(testEntity); //rep2.Delete(testEntity2); }
public int MultipleAction(TESTENTITY testEntity, TESTENTITY2 testEntity2) { var result = (this.testRepository.Insert(testEntity).Id != null ? 1 : 0); result += (this.test2Repository.Insert(testEntity2).Id != null ? 1 : 0); return(result); }
public void UpdateByExpressionFixbug() { var rep = Resolve <ITestRepository>(); var guid = Guid.NewGuid().ToString(); var now = DateTime.Now; var initData = new TESTENTITY() { Id = guid, TESTENTITY2ID = "guid" + "2", COLNUMINT = 1, ISACTIVE = 1 }; rep.Insert(initData); var constValue = "123"; var id = rep.Update(rr => rr.Id == guid && rr.CREATEDATE <= now, RR => new TESTENTITY() { TESTENTITY2ID = RR.TESTENTITY2ID + initData.TESTENTITY2ID, COMMENT = "123321" }); var updatedData = rep.FirstOrDefault(t => t.Id == guid); Assert.Equal(updatedData.TESTENTITY2ID, initData.TESTENTITY2ID + initData.TESTENTITY2ID); }
public int MultipleActionWhenException(TESTENTITY testEntity, TESTENTITY2 testEntity2) { var result = (this.testRepository.Insert(testEntity).Id != null ? 1 : 0); throw new TestTransactionException(); //return (this.testRepository.Insert(testEntity).Id != null ? 1 : 0) + (this.test2Repository.Insert(testEntity2).Id != null ? 1 : 0); }
public void UpdateByExpression() { var rep = Resolve <ITestRepository>(); var guid = Guid.NewGuid().ToString(); var now = DateTime.Now; var initData = new TESTENTITY() { Id = guid, TESTENTITY2ID = "guid" + "2", COLNUMINT = 1, ISACTIVE = 1 }; rep.Insert(initData); rep.Update(rr => rr.Id == guid, RR => new TESTENTITY() { TESTENTITY2ID = "guid" + "2", }); var constValue = "123"; var id = rep.Update(rr => rr.Id == guid && rr.CREATEDATE <= now, RR => new TESTENTITY() { TESTENTITY2ID = RR.TESTENTITY2ID + constValue, COMMENT = "123321" }); var updatedData = rep.FirstOrDefault(t => t.Id == guid); Assert.Equal(updatedData.TESTENTITY2ID, initData.TESTENTITY2ID + "123"); var inputPlus = "inputPlus"; var id1 = rep.Update(t => t.Id == guid, t => new TESTENTITY() { TESTENTITY2ID = t.TESTENTITY2ID + inputPlus }); Assert.Equal(rep.FirstOrDefault(t => t.Id == guid).TESTENTITY2ID, updatedData.TESTENTITY2ID + inputPlus); var testEntity = rep.FirstOrDefault(t => t.Id == guid); var setGuid = Guid.NewGuid().ToString(); testEntity.TESTENTITY2ID = setGuid; rep.Update(testEntity); Assert.Equal(testEntity.TESTENTITY2ID, setGuid); }
public void OneToOneMethod() { var list = new List <MyClassModel>(); var list2 = new List <MyClassModel2>(); // var groupList = list.GroupJoin(list2,t => t.MyClass2Id, p => p.id, (inner, outer) => new { inner, outer} ) // .SelectMany(joinResult => joinResult.outer.DefaultIfEmpty(), // (a,b) => { // a.inner, // b // } // ) var rep = Resolve <ITestRepository>(); var rep2 = Resolve <ITest2Repository>(); var rep3 = Resolve <ITestRepository3>(); var relationStr = "testEntityStr"; var testEntity2 = new TESTENTITY2() { Id = System.Guid.NewGuid().ToString(), CREATEDATE = DateTime.Now, CREATER = "testEntity2", UPDATER = relationStr }; var testEntity = new TESTENTITY() { Id = System.Guid.NewGuid().ToString(), TESTENTITY2ID = testEntity2.Id, STRING = relationStr, CREATEDATE = DateTime.Now, }; var testEntity3 = new TESTENTITY3() { Id = System.Guid.NewGuid().ToString(), TESTENTITYID = testEntity.Id, TESTENTITYID1 = "2", CREATER = relationStr, CREATEDATE = DateTime.Now, }; var testEntity31 = new TESTENTITY3() { Id = System.Guid.NewGuid().ToString(), TESTENTITYID = testEntity.Id, TESTENTITYID1 = "1", CREATER = relationStr, CREATEDATE = DateTime.Now, }; rep.Insert(testEntity); rep2.Insert(testEntity2); rep3.Insert(testEntity3); rep3.Insert(testEntity31); var firstData2 = rep.GetMultLeftJoin(); var firstData = rep.GetTestEntity2Text(); var firstData1 = rep.GetTESTENTITY3s(); rep.Delete(testEntity); rep2.Delete(testEntity2); rep3.Delete(testEntity3); // var firstData2 = Resolve<TestRepository3>().GetContextTable().SelectToDynamicList((TESTENTITY3 t) => t.TESTENTITY); }