public static List <TicketPesquisa> PesquisarTicket2(string categoria, string assunto, string departamento, string usuario, string usuarioResponsavel, string prioridade, string sortBy, int startIndex, int pageSize, out int count)
{
using (SynsTicketContext context = new SynsTicketContext())
{
var dados = from ticket in context.TicketEntity
join usuario1 in context.UsuarioEntity on ticket.UsuarioId equals usuario1.UsuarioId
join usuario2 in context.UsuarioEntity on ticket.UsuarioResponsavelId equals usuario2.UsuarioId into usuario2Left
from usuario2 in usuario2Left.DefaultIfEmpty()
join departamento1 in context.DepartamentoEntity on ticket.DepartamentoId equals departamento1.DepartamentoId
orderby ticket.DataCadastro
select new TicketPesquisa()
{
TicketId = ticket.TicketId,
Assunto = ticket.Assunto,
DepartamentoId = ticket.DepartamentoId,
UsuarioResponsavel = ticket.UsuarioResponsavelId,
UsuarioId = ticket.UsuarioId,
Prioridade = ticket.Prioridade,
Categoria = ticket.CategoriaId,
Usuario = ticket.UsuarioId,
departamento = departamento1.Descricao,
usuario = usuario1.Nome,
usuarioResponsavel = usuario2.Nome,
Ticket2Id = ticket.TicketId,
Ticket3Id = ticket.TicketId,
Ticket4Id = ticket.TicketId,
};
if (!string.IsNullOrWhiteSpace(categoria))
{
dados = dados.Where(a => a.Categoria.Equals(categoria));
}
if (!string.IsNullOrWhiteSpace(assunto))
{
dados = dados.Where(a => a.Assunto.Contains(assunto));
}
if (!string.IsNullOrWhiteSpace(prioridade))
{
dados = dados.Where(a => a.Prioridade.Equals(prioridade));
}
if (!string.IsNullOrWhiteSpace(assunto))
{
dados = dados.Where(a => a.Assunto.Contains(assunto));
}
if (!string.IsNullOrWhiteSpace(departamento))
{
dados = dados.Where(a => a.Departamento.Contains(departamento));
}
return(dados.OrderBy(sortBy).Page(startIndex, pageSize, out count));
}
}
//
// GET: /Sistema/
public ActionResult Index()
{
using (SynsTicketContext context = new SynsTicketContext())
{
return(View(context.SistemaEntity.ToList()));
}
}
//public ActionResult Index()
//{
// return View(UsuarioBusiness.Pesquisar(""));
//}
public ActionResult GetUsuarioPerfil(string query)
{
using (SynsTicketContext context = new SynsTicketContext())
{
var dados = context.UsuarioPerfilEntity.Where(v => v.Descricao.Contains(query)).ToList();
return(Json(dados, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Editar(int id)
{
using (SynsTicketContext context = new SynsTicketContext())
{
var sistema = context.SistemaEntity.FirstOrDefault(a => a.SistemaId == id);
return(View(sistema));
}
}
public ActionResult Excluir(int id)
{
using (SynsTicketContext context = new SynsTicketContext())
{
var entity = context.SistemaEntity.FirstOrDefault(a => a.SistemaId == id);
context.SistemaEntity.Remove(entity);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Login(UsuarioLoginModel model)
{
using (SynsTicketContext context = new SynsTicketContext())
{
var usuario = context.UsuarioEntity.FirstOrDefault(u => u.Login == model.Login && u.Senha == model.Senha);
if (usuario != null)
{
FormsAuthentication.SetAuthCookie(model.Login, false);
return(RedirectToAction("Index"));
}
return(View(model));
}
}
public ActionResult Inserir(SistemaEntity model)
{
if (ModelState.IsValid)
{
using (SynsTicketContext context = new SynsTicketContext())
{
model.UsuarioCadId = 1;
model.DataHoraCad = DateTime.Now;
model.Ativo = true;
context.SistemaEntity.Add(model);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(model));
}
public ActionResult Editar(SistemaEntity model)
{
if (ModelState.IsValid)
{
using (SynsTicketContext context = new SynsTicketContext())
{
var entry = context.Entry <SistemaEntity>(model);
entry.State = System.Data.Entity.EntityState.Modified;
entry.Entity.DataHoraCad = DateTime.Now;
entry.Entity.UsuarioCadId = 1;
entry.Entity.Ativo = true;
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(model));
}
