public void Test4()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
//var wheelCube = new WheelCube { Code = "3" };
//var st = session.Save(wheelCube);
//session.Clear();
//session.Dispose();
//session = connection.GetSessionFactory().OpenSession();
//var ss = session.QueryOver<WheelCube>().List();
return;
var certificate = session.Query <Certificate>().Fetch(x => x.Group).ThenFetch(x => x.Students).ToList().First();
session.Dispose();
certificate.Group.Students.Clear();
//var student = new Student { Name = "the new maratoss", Group = certificate.Group };
//certificate.Group.Students.Add(student);
session = connection.GetSessionFactory().OpenSession();
session.Update(certificate);
session.Flush();
session.Dispose();
}
public void Test9()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
var user = new User {
Name = "maratoss"
};
var user_2 = new User {
Name = "maratoss 2"
};
using (ITransaction tr = session.BeginTransaction())
{
session.Save(user);
session.Save(user_2);
tr.Commit();
}
using (ITransaction tr = session.BeginTransaction())
{
session.Delete(user);
session.Delete(user_2);
tr.Commit();
}
}
public void Test2()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
var planCertificate =
session.Query <PlanCertificate>()
.Fetch(x => x.CertificateQuality)
.Where(x => x.Rn == 1008161275L).ToList().First();
var dto = planCertificate.MapTo <PlanCertificateDto>();
planCertificate = dto.MapTo <PlanCertificate>();
session.Clear();
session.Dispose();
session = connection.GetSessionFactory().OpenSession();
ITransaction tr = session.BeginTransaction();
var repository = new RepositoryFactory(session).Create <PlanCertificate>();
var attachDoc = new CertificateQualityAttachedDocument
{
BData = new byte[] { 1, 2, 3 },
AttachedDocumentType = new AttachedDocumentType {
Rn = 760351674
},
Document = 437790479,
Note = "ololo",
// UnitCode = "QUALITY_CERTIFICATE",
Catalog = new Catalog(465000873)
};
planCertificate.CertificateQuality.AttachedDocuments.Add(attachDoc);
string cqGuid = Guid.NewGuid().ToString();
string pcGuid = Guid.NewGuid().ToString();
planCertificate.CertificateQuality.Note = cqGuid;
planCertificate.Note = pcGuid;
var pc = session.Merge(planCertificate);
var cq = session.Merge(planCertificate.CertificateQuality);
session.Update(pc);
session.Update(cq);
tr.Commit();
tr.Dispose();
session.Dispose();
}
public void Test()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
var cert = session.Query <Certificate>()
.Fetch(x => x.Group)
.ThenFetch(x => x.Students)
.First();
cert.Group.Students[0].TermPapers.DoForEach(x => { });
session.Clear();
session.Dispose();
session = connection.GetSessionFactory().OpenSession();
ITransaction transaction = session.BeginTransaction();
var paper = new TermPaper {
Name = "ALALA", Student = cert.Group.Students[0]
};
cert.Group.Students[0].TermPapers.Add(paper);
var group = session.Merge(cert.Group);
session.Update(group);
session.Update(group.Certificate);
transaction.Commit();
transaction.Dispose();
session.Dispose();
return;
var certificate = session.Query <Certificate>().Fetch(x => x.Group).ThenFetch(x => x.Students).ToList().First();
session.Dispose();
certificate.Group.Students.Clear();
//var student = new Student { Name = "the new maratoss", Group = certificate.Group };
//certificate.Group.Students.Add(student);
session = connection.GetSessionFactory().OpenSession();
session.Update(certificate);
session.Flush();
session.Dispose();
}
public void Test5()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
var doc = new AttachedDocument
{
AttachedDocumentType = new AttachedDocumentType {
Rn = 813609324
},
BData = new byte[] { 1, 2, 3 },
Code = "Code",
Catalog = new Catalog(465000873),
Document = 437790479,
Note = "1",
// UnitCode = "Contracts"
};
session.Save(doc);
return;
// var planCertificate =
// session.Query<PlanCertificate>()
// .Fetch(x => x.CertificateQuality)
// .ThenFetchMany(x => x.ChemicalIndicatorValues)
// .Where(x => x.Rn == 1008028460L).ToList().First();
//
// var dto = planCertificate.MapTo<PlanCertificateDto>();
// planCertificate = dto.MapTo<PlanCertificate>();
//
// session.Clear();
// session.Dispose();
//
//
// session = connection.GetSessionFactory().OpenSession();
//
// planCertificate.Rn = 0;
// planCertificate.CertificateQuality.Rn = 0;
//
//
// planCertificate.CertificateQuality.AttachedDocuments.Add(doc);
//
//
// var repository = new RepositoryFactory(session).Create<PlanCertificate>();
// repository.Insert(planCertificate);
//
// session.Flush();
// session.Dispose();
}
public void Test11()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
ITransaction tr = session.BeginTransaction();
var user = new User {
Name = "ALALALLA"
};
session.Save(user);
}
public void Test3()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
ITransaction transaction = session.BeginTransaction();
TestData.ActSelectionOfProbeGenerator(session);
transaction.Commit();
transaction.Dispose();
session.Dispose();
}
public void ConnectToDb()
{
INhConnection connection = new NhConnection();
connection.Connecting("parus", "q", "dupparus");
using (ISessionFactory sessionFactory = connection.GetSessionFactory())
using (ISession session = sessionFactory.OpenSession())
{
var login = session.CreateSQLQuery("select user from dual")
.UniqueResult <string>();
Assert.That(login, Is.EqualTo("parus").IgnoreCase);
}
}
public void Test6()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
var cq = session.Get <PlanReceiptOrder>(1008067627L);
var dto = cq.MapTo <PlanReceiptOrderDto>();
session.Dispose();
session = connection.GetSessionFactory().OpenSession();
cq = session.Get <PlanReceiptOrder>(1008067627L);
var dto2s = cq.MapTo <PlanReceiptOrderWithoutPlanCertificateDto>();
}
public void t()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
var cq = session.QueryOver <CertificateQuality>().Where(x => x.Rn == 1008334353L).UnderlyingCriteria.UniqueResult <CertificateQuality>();
var map = cq.MapTo <CertificateQualityDto>();
var usDto =
map.MapTo <UI.Entities.CertificateQualityDomain.ManufacturersCertificateDomain.CertificateQuality>();
var us =
usDto.MapTo <CertificateQualityDto>();
us = us;
}
public void Test10()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting("112BAITULLIN", "1", "dupparus");
ISession session = connection.GetSessionFactory().OpenSession();
var pm = new UI.Entities.PermissionMaterialDomain.PermissionMaterial {
Rn = 1008338040
};
var pmDto = pm.MapTo <PermissionMaterialDto>();
var pmClient = pmDto.MapTo <UI.Entities.PermissionMaterialDomain.PermissionMaterial>();
session.Dispose();
var pmEx = new UI.Entities.PermissionMaterialDomain.PermissionMaterialExtension {
PermissionMaterial = pmClient
};
pmEx.AcceptToDate = new DateTime(2013, 05, 05);
var user = new UI.Entities.PermissionMaterialDomain.PermissionMaterialExtensionUser
{
RnUser = 484082568L,
PermissionMaterialExtension = pmEx,
Fullname = "fullname",
UserPsdepName = "UserPsdepName",
UserDept = "123",
};
pmEx.PmeUsers.Add(user);
var pmeDto = pmEx.MapTo <PermissionMaterialExtensionDto>();
var srvPM = pmeDto.MapTo <ParusModel.Entities.PermissionMaterialDomain.PermissionMaterialExtension>();
session = connection.GetSessionFactory().OpenSession();
session.Save(srvPM);
session.Flush();
}
public void Test2()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
//IQuery Q = session.GetNamedQuery("Get_Links")
// //.SetResultTransformer(new ToListResultTransformer());
// //session.CreateSQLQuery("").ad
// .SetParameter("RN", 253655604)
// .SetParameter("Direction", DirectionFind.Forward);
// IQuery Q = session.CreateSQLQuery(" select PKG_UDO_UTIL.F_GetLinks()1 as ret from dual ").AddEntity(typeof(LinkDto));
//typeof(LinkDto);
var sp = new GetLinks(253655604, DirectionFind.Backward);
var Q = session.ExecuteSp(sp);
var result = Q.List();
//var query = MockRepository.GenerateMock<IQueryOver<LinkDto, LinkDto>>();
//query.Stub(x => x.List<LinkDto>()).Return();
}
public void Test8()
{
var connection = new NhConnection("hibernate.cfg.xml");
connection.Connecting();
ISession session = connection.GetSessionFactory().OpenSession();
// CreditSlip creditSlip = SampleEntity.CreateCreditSlip();
var creditSlip =
session.QueryOver <CreditSlip>()
.Where(x => x.State == CreditSlipState.NotFulfilled)
.Take(1)
.UnderlyingCriteria.UniqueResult <CreditSlip>();
CreditSlipSpecification creditSlipSpec_1 = SampleEntity.CreateCreditSlipSpecification(creditSlip, session);
CreditSlipSpecification creditSlipSpec_2 = SampleEntity.CreateCreditSlipSpecification(creditSlip, session);
creditSlipSpec_1.SerNumb = "new ser numb qqq";
creditSlipSpec_2.SerNumb = "new ser numb zzz 2";
creditSlip.CreditSlipSpecifications.Add(creditSlipSpec_1);
creditSlip.CreditSlipSpecifications.Add(creditSlipSpec_2);
using (ITransaction tr = session.BeginTransaction())
{
session.Save(creditSlipSpec_1);
tr.Commit();
}
using (ITransaction tr = session.BeginTransaction())
{
session.Delete(creditSlipSpec_1);
session.Delete(creditSlipSpec_2);
tr.Commit();
}
}