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);
}
