public static bool updateTicket(Tickets Model)
{
bool result;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var ticket = context.TICKETS.FirstOrDefault(t => t.Id == Model.Id);
try
{
ticket.IssueId = Model.IssueId;
ticket.DestinationDivisionId = Model.DestinationDivisionId;
ticket.OrganizacionId = Model.OrganizacionId;
ticket.RequestDepartamentId = Model.RequestDepartamentId;
ticket.UserAssigned = Model.UserAssigned;
ticket.UserRequestId = Model.UserRequestId;
ticket.Titulo = Model.Titulo;
ticket.Descripcion = Model.Descripcion;
ticket.Fecha_Modificacion = DateTime.Now;
context.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
}
return(result);
}
public static List <TICKETS1_DTO> GetAll()
{
List <TICKETS1_DTO> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.TICKETS1.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <TICKETS1_DTO>();
}
return(list);
}
public static Grupos GetGrupoByPrimaryKey(int Id)
{
Grupos Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.GRUPOS.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static User_Groups GetUserGroupsByPrimaryKey(int UserId, int GroupId)
{
User_Groups Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USER_GROUPS.SingleOrDefault(a => a.UserId == UserId && a.GroupId == GroupId);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <User_Groups> GetAll()
{
List <User_Groups> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USER_GROUPS.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <User_Groups>();
}
return(list);
}
public static Usuarios GetUsuarioByPrimaryKey(int UserId)
{
Usuarios Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USUARIOS.SingleOrDefault(a => a.id == UserId);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <Spc_Get_Ticket_By_Usr_Request> GetTicketByUserRequest(string userName)
{
List <Spc_Get_Ticket_By_Usr_Request> Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.SPC_GET_TICKET_BY_USR_REQUEST(userName).ToList();
Obj = queryResult.Count > 0 ? queryResult.Select(x => x.ToModel()).ToList() : new List <Spc_Get_Ticket_By_Usr_Request>();
}
return(Obj);
}
public static List <Spc_Get_All_Tickets_With_Descrip> GetAllWithDescrip()
{
List <Spc_Get_All_Tickets_With_Descrip> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.SPC_GET_ALL_TICKETS_WITH_DESCRIP().ToList();
list = queryResult.Count > 0 ? queryResult.Select(x => x.ToModel()).ToList() : new List <Spc_Get_All_Tickets_With_Descrip>();
}
return(list);
}
public static List <Tickets_Respuesta> GetAll()
{
List <Tickets_Respuesta> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.TICKETS_RESPUESTA.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <Tickets_Respuesta>();
}
return(list);
}
public static User_Followed_User GetUserGroupsByPrimaryKey(int UserId, int UserIdFollowed)
{
User_Followed_User Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USER_FOLLOWED_USER.SingleOrDefault(a => a.UserID == UserId && a.UserIdFollowed == UserIdFollowed);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <User_Followed_User> GetAll()
{
List <User_Followed_User> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USER_FOLLOWED_USER.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <User_Followed_User>();
}
return(list);
}
public static Organizacion GetOrganizacionByPrimaryKey(int Id)
{
Organizacion Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.ORGANIZACION.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static Departamentos GetDivisionByPrimaryKey(int Id)
{
Departamentos Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.DEPARTAMENTOS.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <Departamentos> GetAll()
{
List <Departamentos> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.DEPARTAMENTOS.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <Departamentos>();
}
return(list);
}
public static Prioridad GetPrioridadByPrimaryKey(int Id)
{
Prioridad Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.PRIORIDAD.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static Tickets_Respuesta GetTicketsRespuestaByPrimaryKey(int IdTicket, int IdPregunta)
{
Tickets_Respuesta Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.TICKETS_RESPUESTA.SingleOrDefault(a => a.IdTickets == IdTicket && a.IdPregunta == IdPregunta);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static Usuarios GetUsuario(string usuario)
{
Usuarios Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USUARIOS.SingleOrDefault(a => a.Usuario == usuario);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static Tickets GetTicketByPrimaryKey(int Id)
{
Tickets Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.TICKETS.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static Issues GetIssueByPrimaryKey(int Id)
{
Issues Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.ISSUES.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <Prioridad> GetAll()
{
List <Prioridad> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.PRIORIDAD.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <Prioridad>();
}
return(list);
}
public static Preguntas GetPreguntaByPrimaryKey(int Id)
{
Preguntas Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.PREGUNTAS.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <Usuarios_Seguidos> GetAll()
{
List <Usuarios_Seguidos> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USUARIOS_SEGUIDOS.ToList();
list = queryResult.Count > 0 ? queryResult.Select(x => x.ToModel()).ToList(): new List <Usuarios_Seguidos>();
}
return(list);
}
public static Division GetDivisionByPrimaryKey(int Id)
{
Division Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.DIVISION.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <Preguntas> GetAll()
{
List <Preguntas> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.PREGUNTAS.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <Preguntas>();
}
return(list);
}
public static List <Division> GetAll()
{
List <Division> list;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.DIVISION.ToList();
list = queryResult.Count > 0 ? ToModels(queryResult) : new List <Division>();
}
return(list);
}
public static Estatus GetEstatusByPrimaryKey(int Id)
{
Estatus Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.ESTATUS.SingleOrDefault(a => a.Id == Id);
Obj = ToModel(queryResult);
}
return(Obj);
}
public static List <Spc_Get_Tickets_User_Followed_Result> GetTicketsFromUsersFollowed(int UsrId)
{
List <Spc_Get_Tickets_User_Followed_Result> Obj;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.SPC_GET_TICKETS_USER_FOLLOWED(UsrId).ToList();
Obj = queryResult.Count > 0 ? queryResult.Select(x => x.ToModel()).ToList() : new List <Spc_Get_Tickets_User_Followed_Result>();
}
return(Obj);
}
public static bool UserIsFollowed(Usuarios_Seguidos rel)
{
bool result;
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USUARIOS_SEGUIDOS.SingleOrDefault(u => u.UserFollowedId == rel.UserFollowedId && u.UserId == rel.UserId);
result = queryResult != null? true : false;
}
return(result);
}
public static List <Issues> GetAll()
{
List <Issues> result = new List <Issues>();
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.ISSUES.ToList();
result = queryResult.Count > 0 ? ToModels(queryResult) : new List <Issues>();
}
return(result);
}
public static Usuarios GetUsuarioByPrimaryKey(int id)
{
Usuarios result = new Usuarios();
using (HelpDeskApfEntities context = new HelpDeskApfEntities())
{
var queryResult = context.USUARIOS.SingleOrDefault(x => x.id == id);
result = queryResult.ToModel();
}
return(result);
}
