public void Dispose()
{
importRepo.Dispose();
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["PrismDatabase"];
HibernateUtil.Initialize(settings.ConnectionString, false);
}
public FirstSetupRepo()
{
this.session = HibernateUtil.OpenSession(false);
this.userRepo = new UserRepository(session);
this.projectRepo = new ProjectRepository(session);
this.certificateTypeRepo = new InspectorCertificateTypeRepository(session);
this.seemTypeRepo = new SeamTypeRepository(session);
this.permissionRepo = new PermissionRepository(session);
this.roleRepo = new RoleRepository(session);
this.categoryRepo = new CategoryRepository(session);
this.jointOperationRepo = new JointOperationRepository(session);
this.pipeTestsRepo = new PipeTestRepository(session);
this.sizeTypeRepo = new MillPipeSizeTypeRepository(session);
this.plateManRepo = new PlateManufacturerRepository(session);
this.heatRepo = new HeatRepository(session);
this.plateRepo = new PlateRepository(session);
this.purchaseRepo = new PurchaseOrderRepository(session);
this.railRepo = new RailcarRepository(session);
this.pipeRepo = new PipeRepository(session);
this.inspectorRepo = new InspectorRepository(session);
this.pipeTestResultRepo = new PipeTestResultRepository(session);
this.welderRepo = new WelderRepository(session);
componentTypeRepo = new ComponentTypeRepository(session);
componentRepo = new ComponentRepository(session);
releaseRepo = new ReleaseNoteRepository(session);
this.cannedMessageRepo = new CannedMessageRepository(session);
}
public IList GetByHQL(string hql, ArrayList lists)
{
try
{
ISession session = HibernateUtil.OpenSession();
IQuery query = session.CreateQuery(hql);
for (int i = 0; i < lists.Count; i++)
{
query.SetParameter(i, lists[i]);
}
return(query.List());
}
catch (Exception ex)
{
throw ex;
}
finally
{
HibernateUtil.CloseSession();
}
return(null);
}
public TEntity GetById(int id)
{
using (var session = HibernateUtil.SessionFactory(connectionString).OpenSession())
{
return(session.Get <TEntity>(id));
}
}
public List <TEntity> GetAll()
{
using (var session = HibernateUtil.SessionFactory(connectionString).OpenSession())
{
return(session.Query <TEntity>().ToList());
}
}
public IEnumerable <ServidorAtivo> ListaServidoresAtivos()
{
using (var s = HibernateUtil.GetSessionFactory().OpenSession())
{
var sql = new StringBuilder();
sql.AppendLine(
"SELECT [Nome],[categoriaDescricao][Categoria],[Matricula],[cargoDescricao][CargoEfetivo],")
.AppendLine("[cargoComissaoDescricao][CargoEmComissao],[LotacaoAtual],[admissao] [Nomeacao],")
.AppendLine("[posse][Exercicio],[AprovadoNoEstagio] [Estavel] FROM [organizador].[dbo].[vwPessoa]")
.AppendLine(" where vinculo = 1 and categoria in(1,2,3,4)");
var query = s.CreateSQLQuery(sql.ToString());
query.AddScalar("Nome", NHibernateUtil.String)
.AddScalar("Categoria", NHibernateUtil.String)
.AddScalar("Matricula", NHibernateUtil.String)
.AddScalar("CargoEfetivo", NHibernateUtil.String)
.AddScalar("CargoEmComissao", NHibernateUtil.String)
.AddScalar("LotacaoAtual", NHibernateUtil.String)
.AddScalar("Nomeacao", NHibernateUtil.DateTime)
.AddScalar("Exercicio", NHibernateUtil.DateTime)
.AddScalar("Estavel", NHibernateUtil.String)
.SetResultTransformer(Transformers.AliasToBean(typeof(ServidorAtivo)));
return(query.List <ServidorAtivo>() as List <ServidorAtivo>);
}
}
public IList <Employee> GetEmployeesByName(string name)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
return(s.Query <Employee>().Where(e => e.Name.Contains(name)).ToList());
}
}
public IList <TEntity> GetAll()
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
return(s.Query <TEntity>().ToList());
}
}
public TEntity GetById(Guid id)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
return(s.Get <TEntity>(id));
}
}
public int QttyOfDependentsForEachEmployee(Guid id)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
return(s.Query <Dependent>().Where(d => d.Employee.Id == id).Count());
}
}
/// <summary>
/// Implementação do método genérico para listar todas as informaçõed de uma consulta específica do banco
/// </summary>
/// <param name="id">Identificador do registro</param>
/// <returns></returns>
public T ObterPorId(K id)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
return(ObterPorId(s, id));
}
}
/// <summary>
/// Implementação do método genérico para listar todos as informações de uma consulta do banco
/// </summary>
public ICollection <T> ListarTodos()
{
using (ISession sessao = HibernateUtil.GetSessionFactory().OpenSession())
{
return(ListarTodos(sessao));
}
}
public T Find(int Id)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
return((T)s.Get(typeof(T), Id));
}
}
public IEnumerable <AntiguidadeDefensor> ListaAntiguidadeDefensores()
{
using (var s = HibernateUtil.GetSessionFactory().OpenSession())
{
var query = s.CreateSQLQuery(
"SELECT [IdQuadroCargo],[Ocupado],[Ordem],[IdCargo],[InicioCargo],[SiglaCargo],[DescricaoCargo],[NomeDefensor],[DataPosse],[DataUltimaPromocao],[TotalDiasEstado],[TotalDiasPublico],[TotalDiasAposentado] FROM [" +
DbSci + "].[SITE].[VW_CONSULTA_ANTIGUIDADE_DEFENSOR] ORDER BY IdCargo, Ordem");
query.AddScalar("IdQuadroCargo", NHibernateUtil.Int32)
.AddScalar("Ocupado", NHibernateUtil.Int32)
.AddScalar("Ordem", NHibernateUtil.Int32)
.AddScalar("IdCargo", NHibernateUtil.Int32)
.AddScalar("InicioCargo", NHibernateUtil.DateTime)
.AddScalar("SiglaCargo", NHibernateUtil.String)
.AddScalar("DescricaoCargo", NHibernateUtil.String)
.AddScalar("NomeDefensor", NHibernateUtil.String)
.AddScalar("DataPosse", NHibernateUtil.DateTime)
.AddScalar("DataUltimaPromocao", NHibernateUtil.DateTime)
.AddScalar("TotalDiasEstado", NHibernateUtil.Int32)
.AddScalar("TotalDiasPublico", NHibernateUtil.Int32)
.AddScalar("TotalDiasAposentado", NHibernateUtil.Int32)
.SetResultTransformer(Transformers.AliasToBean(typeof(AntiguidadeDefensor)));
return(query.List <AntiguidadeDefensor>() as List <AntiguidadeDefensor>);
}
}
public List <TarefaDto> FindAll(DateTime DataIni, DateTime DataFim, int IdUsuario)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
var query = from t in s.Query <Tarefa>()
where t.DataHoraInicio >= DataIni &&
t.DataHoraInicio <= DataFim &&
t.Usuario.IdUsuario == IdUsuario
orderby t.DataHoraInicio ascending
select t;
List <TarefaDto> lista = new List <TarefaDto>();
foreach (var t in query.ToList())
{
lista.Add(
new TarefaDto()
{
Codigo = t.IdTarefa,
Titulo = t.Titulo,
Descricao = t.Descricao,
DataHoraInicio = t.DataHoraInicio,
DataHoraFim = t.DataHoraFim,
Categoria = t.Categoria.Nome,
Usuario = t.Usuario.Nome
}
);
}
return(lista);
}
}
public DataImporter(IImportRepository importRepo, IHasher hasher, IEncryptor encryptor)
: base(hasher, encryptor)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["PrismDatabase"];
HibernateUtil.Initialize(settings.ConnectionString, true);
this.importRepo = Program.Kernel.Get <IImportRepository>();
}
public ActionResult Index()
{
using (ISession session = HibernateUtil.OpenSession())
{
ViewData["employees"] = session.QueryOver <Employee>().List();
}
return(View("Home"));
}
public IQuery BuildQuery(string queryst, object[] parameters, ISession session, bool native = false, string queryAlias = null)
{
var result = HibernateUtil.TranslateQueryString(queryst, parameters);
queryst = result.query;
parameters = result.Parameters;
var query = native ? session.CreateSQLQuery(queryst) : session.CreateQuery(queryst);
if (!native)
{
query.SetFlushMode(FlushMode.Never);
}
query.SetTimeout(MetadataProvider.GlobalProperties.QueryTimeout());
LogQuery(queryst, queryAlias, parameters);
if (result.Parameters == null)
{
return(query);
}
for (var i = 0; i < result.Parameters.Length; i++)
{
if (queryst.Contains(":p" + i))
{
if (parameters[i] == null)
{
query.SetParameter("p" + i, parameters[i], NHibernateUtil.String);
}
else
{
var asEnumerable = parameters[i] as IEnumerable;
if (asEnumerable != null)
{
query.SetParameterList("p" + i, (IEnumerable)parameters[i]);
}
else
{
query.SetParameter("p" + i, parameters[i]);
}
}
}
else
{
if (parameters[i] != null)
{
if (parameters[i] is Int32)
{
query.SetParameter(i, parameters[i], new Int32Type());
}
else
{
query.SetParameter(i, parameters[i]);
}
}
}
}
return(query);
}
public void Insert(TEntity obj)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
ITransaction t = s.BeginTransaction();
s.Save(obj);
t.Commit();
}
}
public void Remove(TEntity obj)
{
using (var session = HibernateUtil.SessionFactory(connectionString).OpenSession())
{
var transaction = session.BeginTransaction();
session.Delete(obj);
transaction.Commit();
}
}
public Guid GetRoleIdByType(string roleType)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
var result = s.Query <Role>().SingleOrDefault(r => r.RoleType == roleType);
return(result.Id);
}
}
public void Delete(Produto p)
{ //Não é necessario dar new pois o objeto é statico
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
ITransaction t = s.BeginTransaction();
s.Delete(p);
t.Commit();
}
}
public void Update(T obj)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
ITransaction t = s.BeginTransaction();
s.Update(obj);
t.Commit();
}
}
/// <summary>
/// Implementação do método genérico para alteração de informações de um objeto em banco
/// </summary>
/// <param name="obj">Modelo a ser alterado</param>
public void Alterar(T obj)
{
using (ISession sessao = HibernateUtil.GetSessionFactory().OpenSession())
{
ITransaction transacao = sessao.BeginTransaction();
Alterar(sessao, obj);
transacao.Commit();
}
}
public Produto FindById(int IdProduto)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
var query = from p in s.Query <Produto>()
where p.IdProduto == IdProduto
select p;
return(query.FirstOrDefault());
}
}
public List <Produto> FindAll()
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
var query = from p in s.Query <Produto>()
select p;
return(query.ToList());
}
}
public ICollection <T> FindAll()
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
//LINQ - Language Integrated Query
var query = from obj in s.Query <T>()
select obj;
//retornar os dados...
return(query.ToList());
}
}
public Estoque ObterPorIdComposto(int IdProd, int IdFreezer)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
var query = s.Query <Estoque>()
.Where(p => p.Produto.Id == IdProd && p.Freezer.Id == IdFreezer)
.FirstOrDefault();
return(query);
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
HibernateUtil.Init();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
}
public bool HasLogin(string Login)
{
using (ISession s = HibernateUtil.GetSessionFactory().OpenSession())
{
//SQL -> select count(*) from Usuario where Login = ?
var query = from u in s.Query <Usuario>()
where u.Login.Equals(Login)
select u;
//retornar a quantidade obtida...
return(query.Count() > 0);
}
}
internal static IDA0 GetInstance(string configFileName)
{
HibernateUtil util = null;
try
{
if (LoggingService.IsDebugEnabled)
{
LoggingService.DebugFormatted("将获得配置文件为'{0}.cfg.xml'DAO对象", new object[] { configFileName });
}
util = new HibernateUtil(configFileName);
}
catch (Exception exception)
{
LoggingService.Error("Cannot create dao : " + configFileName + "\r\n", exception);
throw exception;
}
return util;
}