public void DeleteTurno(IEnumerable<Model.TurnoModel> turnos) { using (var entity = new GestorDocumentEntities()) { foreach (Model.TurnoModel p in turnos) { GET_TURNO result = null; try { result = (from o in entity.GET_TURNO where o.IdTurno == p.IdTurno select o).First(); } catch (Exception) { throw; } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); UpdateSyncLocal("GET_TURNO", entity); } }
public Model.StatusAsuntoModel GetStatusAsuntoMod(Model.StatusAsuntoModel statusasunto) { using (var entity = new GestorDocumentEntities()) { if (statusasunto != null) { //Validar si el elemento ya existe CAT_STATUS_ASUNTO result = null; try { result = (from o in entity.CAT_STATUS_ASUNTO where o.StatusName == statusasunto.StatusName && o.IsActive == true select o).First(); } catch (Exception ex) { ; } if (result == null) { statusasunto = null; } } } return statusasunto; }
public List<InstruccionModel> GetInstruccions() { List<InstruccionModel> Instruccions = new List<InstruccionModel>(); using (var entity = new GestorDocumentEntities()) { try { (from o in entity.CAT_INSTRUCCION where o.IsActive == true select o).OrderBy(o => o.InstruccionName).ToList().ForEach(p => { Instruccions.Add(new Model.InstruccionModel() { IdInstruccion = p.IdInstruccion, CveInstruccion = p.CveInstruccion, InstruccionName = p.InstruccionName, IsActive = p.IsActive, LastModifiedDate = p.LastModifiedDate, IsModified = p.IsModified }); }); } catch (Exception) { ; } } return Instruccions; }
public void DeleteExpediente(IEnumerable<Model.ExpedienteModel> expedientes) { using (var entity = new GestorDocumentEntities()) { foreach (Model.ExpedienteModel p in expedientes) { GET_EXPEDIENTE result = null; try { result = (from o in entity.GET_EXPEDIENTE where o.IdExpediente == p.IdExpediente select o).First(); } catch (Exception) { throw; } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); UpdateSyncLocal("GET_EXPEDIENTE", entity); } }
public IEnumerable<Model.MenuModel> GetMenu(long IdRol) { ObservableCollection<Model.MenuModel> menu = new ObservableCollection<Model.MenuModel>(); using (var entity = new GestorDocumentEntities()) { try { (from o in entity.APP_MENU join rm in entity.APP_ROL_MENU on o.IdMenu equals rm.IdMenu join r in entity.APP_ROL on rm.IdRol equals r.IdRol where rm.IsActive == true && r.IdRol ==IdRol select o).ToList().ForEach(p => { menu.Add(new Model.MenuModel() { IdMenu = p.IdMenu, IdMenuParent = p.IdMenuParent, MenuName = p.MenuName, IsActive = p.IsActive, IsModified = p.IsModified, LastModifiedDate = p.LastModifiedDate, ServerLastModifiedDate = p.ServerLastModifiedDate, PathMenu = p.PathMenu }); }); } catch (Exception) { ; } } return menu; }
public List<TipoDocumentoModel> GetTipoDocumentos() { List<TipoDocumentoModel> tipodocumentos = new List<TipoDocumentoModel>(); using (var entity = new GestorDocumentEntities()) { try { (from o in entity.CAT_TIPO_DOCUMENTO where o.IsActive == true select o).OrderBy(o => o.TipoDocumentoName).ToList().ForEach(p => { tipodocumentos.Add(new Model.TipoDocumentoModel() { IdTipoDocumento = p.IdTipoDocumento, TipoDocumentoName = p.TipoDocumentoName, //IsActive = p.IsActive, //LastModifiedDate = p.LastModifiedDate, //IsModified = p.IsModified }); }); } catch (Exception) { ; } } return tipodocumentos; }
public Model.RolModel getRol(long idUsuario) { Model.RolModel rol = new Model.RolModel(); try { using (var entity=new GestorDocumentEntities()) { APP_ROL res; res = (from r in entity.APP_ROL join ur in entity.APP_USUARIO_ROL on r.IdRol equals ur.IdRol join u in entity.APP_USUARIO on ur.IdUsuario equals u.IdUsuario where u.IdUsuario == idUsuario select r).FirstOrDefault(); if (res != null) { rol.IdRol = res.IdRol; rol.RolName = res.RolName; } } } catch (Exception) { } return rol; }
public void DeleteDocumentos(IEnumerable<Model.DocumentosModel> documentos) { using (var entity = new GestorDocumentEntities()) { foreach (Model.DocumentosModel p in documentos) { GET_DOCUMENTOS result = null; try { result = (from o in entity.GET_DOCUMENTOS where o.IdDocumento == p.IdDocumento select o).First(); } catch (Exception) { ; } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); UpdateSyncLocal("GET_DOCUMENTOS", entity); } }
public void DeleteDestinatarioCcp(IEnumerable<Model.DestinatarioCcpModel> destinatariosCcp) { using (var entity = new GestorDocumentEntities()) { foreach (Model.DestinatarioCcpModel p in destinatariosCcp) { REL_DESTINATARIO_CCP result = null; try { result = (from o in entity.REL_DESTINATARIO_CCP where o.IdDestinatarioCcp == p.IdDestinatarioCcp select o).First(); } catch (Exception) { ; } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); UpdateSyncLocal("REL_DESTINATARIO_CCP", entity); } }
/// <summary> /// Ejecuta el stored SP_DASHBOARD_ATENDIDOS_INDICADOR que trae el calculo de los asuntos atendidos dentro y fuera de tiempo /// </summary> /// <param name="Determinantes">Lista de signatarios (determinantes externos)</param> /// <returns>AtendidoIndicadorModel con la cantidad de asuntos atendidos dentro y fueta de tiempo en base a la fecha actual (sistema)</returns> public Model.DashBoardModel.AtendidoIndicadorModel GetAtendidos(ObservableCollection<Model.DeterminanteModel> Determinantes) { Model.DashBoardModel.AtendidoIndicadorModel Atendido = null; //Obtener CSV string signatarios = this.GetSignatariosCSV(Determinantes); try { using (var entity = new GestorDocumentEntities()) { var atend = entity.SpDashboardAtendidosIndicador(signatarios).FirstOrDefault(); if (atend != null) { Atendido = new AtendidoIndicadorModel() { Dentro = (int)atend.AtendidosDentroVencimiento, Fuera = (int)atend.AtendidosFueraVencimiento }; } } } catch (Exception) { //TODO Log } return Atendido; }
public System.Collections.ObjectModel.ObservableCollection<DeterminanteModel> GetDeterminante() { ObservableCollection<Model.DeterminanteModel> filtroSignatarios = new ObservableCollection<Model.DeterminanteModel>(); try { using (var entity = new GestorDocumentEntities()) { (from d in entity.CAT_DETERMINANTE orderby d.DeterminanteName ascending select d).ToList().ForEach(row => { Model.DeterminanteModel d = new Model.DeterminanteModel() { IdDeterminante = row.IdDeterminante, DeterminanteName = row.DeterminanteName, IsActive = false }; filtroSignatarios.Add(d); }); } } catch (Exception) { filtroSignatarios = null; } return filtroSignatarios; }
public IEnumerable<Model.RolModel> GetDestinatarios() { ObservableCollection<Model.RolModel> filtroDestinatarios = new ObservableCollection<Model.RolModel>(); using (var entity = new GestorDocumentEntities()) { try { (from r in entity.APP_ROL where r.IdRol != 10 select r).OrderBy(o => o.RolName).ToList().ForEach(row => { Model.RolModel r = new Model.RolModel() { IdRol = row.IdRol, RolName = row.RolName, IsActive = false }; filtroDestinatarios.Add(r); }); } catch (Exception) { filtroDestinatarios = null; } return filtroDestinatarios; } }
public List<StatusAsuntoModel> GetStatusAsuntos() { List<Model.StatusAsuntoModel> statusasuntos = new List<StatusAsuntoModel>(); using (var entity = new GestorDocumentEntities()) { try { (from o in entity.CAT_STATUS_ASUNTO where o.IsActive == true select o).OrderBy(o => o.StatusName).ToList().ForEach(p => { statusasuntos.Add(new Model.StatusAsuntoModel() { IdStatusAsunto = p.IdStatusAsunto, StatusName = p.StatusName, //IsActive = p.IsActive, //LastModifiedDate = p.LastModifiedDate, //IsModified = p.IsModified }); }); } catch (Exception) { ; } } return statusasuntos; }
/// <summary> /// Retorna el usuario en base a un mail y un password. Retorna null si el usuario y pass no coinciden /// </summary> /// <param name="userMail"></param> /// <param name="password"></param> /// <returns></returns> public Model.UsuarioModel GetUsuario(string userMail, string password) { Model.UsuarioModel um = null; using (var entity = new GestorDocumentEntities()) { try { var res = (from o in entity.APP_USUARIO where o.UsuarioCorreo == userMail && o.UsuarioPwd == password select o).First<APP_USUARIO>(); um = new Model.UsuarioModel() { IdUsuario = res.IdUsuario, UsuarioCorreo = res.UsuarioCorreo, Apellido = res.Apellido, Area = res.Area, Nombre = res.Nombre, Puesto = res.Puesto, UsuarioPwd = res.UsuarioPwd, IsActive = res.IsActive, Rol = this.getRol(res.IdUsuario) }; } catch (Exception ex) { ; } } return um; }
public void DeleteSignatario(IEnumerable<Model.SignatarioModel> signatarios) { using (var entity = new GestorDocumentEntities()) { foreach (Model.SignatarioModel p in signatarios) { REL_SIGNATARIO result = null; try { result = (from o in entity.REL_SIGNATARIO where o.IdSignatario == p.IdSignatario select o).First(); } catch (Exception) { } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); UpdateSyncLocal("REL_SIGNATARIO", entity); } }
public Model.TipoDeterminanteModel GetTipoDeterminanteMod(Model.TipoDeterminanteModel tipodeterminante) { using (var entity = new GestorDocumentEntities()) { if (tipodeterminante != null) { //Validar si el elemento ya existe CAT_TIPO_DETERMINANTE result = null; try { result = (from o in entity.CAT_TIPO_DETERMINANTE where o.TipoDeterminanteName == tipodeterminante.TipoDeterminanteName && o.IsActive == true select o).First(); } catch (Exception ex) { ; } if (result == null) { tipodeterminante = null; } } } return tipodeterminante; }
public Model.TurnoModel GetTurnoAdd(Model.TurnoModel turno) { using (var entity = new GestorDocumentEntities()) { if (turno != null) { //Validar si el elemento ya existe GET_TURNO result = null; try { result = (from o in entity.GET_TURNO where o.IdTurno == turno.IdTurno select o).First(); } catch (Exception ex) { ; } if (result == null) { turno = null; } } } return turno; }
public void DeleteStatusAsunto(IEnumerable<Model.StatusAsuntoModel> statusasuntos) { using (var entity = new GestorDocumentEntities()) { foreach (Model.StatusAsuntoModel p in statusasuntos) { CAT_STATUS_ASUNTO result = null; try { result = (from o in entity.CAT_STATUS_ASUNTO where o.IdStatusAsunto == p.IdStatusAsunto select o).First(); } catch (Exception) { throw; } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); } }
public void DeleteTipoDeterminante(IEnumerable<Model.TipoDeterminanteModel> tipodeterminantes) { using (var entity = new GestorDocumentEntities()) { foreach (Model.TipoDeterminanteModel p in tipodeterminantes) { CAT_TIPO_DETERMINANTE result = null; try { result = (from o in entity.CAT_TIPO_DETERMINANTE where o.IdTipoDeterminante == p.IdTipoDeterminante select o).First(); } catch (Exception) { throw; } if (result != null) { result.IsActive = false; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); } } entity.SaveChanges(); } }
public IEnumerable<Model.DeterminanteModel> GetSignatarios() { ObservableCollection<Model.DeterminanteModel> filtroSignatarios = new ObservableCollection<Model.DeterminanteModel>(); try { using (var entity = new GestorDocumentEntities()) { (from d in entity.CAT_DETERMINANTE select d).OrderBy(o=> o.DeterminanteName).ToList().ForEach(row => { Model.DeterminanteModel d = new Model.DeterminanteModel() { IdDeterminante = row.IdDeterminante, DeterminanteName = row.DeterminanteName, IsActive = false }; filtroSignatarios.Add(d); }); } } catch (Exception) { filtroSignatarios = null; } return filtroSignatarios; }
public IEnumerable<Model.PrioridadModel> GetPrioridad() { ObservableCollection<Model.PrioridadModel> filtroPrioridad = new ObservableCollection<Model.PrioridadModel>(); try { using (var entity = new GestorDocumentEntities()) { (from p in entity.CAT_PRIORIDAD select p).OrderBy(o=> o.PrioridadName).ToList().ForEach(row => { Model.PrioridadModel p = new Model.PrioridadModel() { IdPrioridad = row.IdPrioridad, PrioridadName = row.PrioridadName, IsActive = false }; filtroPrioridad.Add(p); }); } } catch (Exception) { } return filtroPrioridad; }
public Model.DestinatarioCcpModel GetDestinatarioCcpMod(Model.DestinatarioCcpModel destinatarioCcp) { using (var entity = new GestorDocumentEntities()) { if (destinatarioCcp != null) { //Validar si el elemento ya existe REL_DESTINATARIO_CCP result = null; try { result = (from o in entity.REL_DESTINATARIO_CCP where o.IdDestinatarioCcp == destinatarioCcp.IdDestinatarioCcp && o.IdRol == destinatarioCcp.IdRol && o.IdAsunto == destinatarioCcp.IdAsunto select o).First(); } catch (Exception ex) { ; } if (result == null) { destinatarioCcp = null; } } } return destinatarioCcp; }
public Model.SignatarioModel GetSignatarioMod(Model.SignatarioModel signatario) { using (var entity = new GestorDocumentEntities()) { if (signatario != null) { //Validar si el elemento ya existe REL_SIGNATARIO result = null; try { result = (from o in entity.REL_SIGNATARIO where o.IdSignatario == signatario.IdSignatario && o.IsActive == true && o.IdDeterminante == signatario.IdDeterminante select o).First(); } catch (Exception ex) { ; } if (result == null) { signatario = null; } } } return signatario; }
public IEnumerable<Model.DocumentosModel> GetDocumentos(long IdTurno) { ObservableCollection<Model.DocumentosModel> Documentos = new ObservableCollection<Model.DocumentosModel>(); using (var entity = new GestorDocumentEntities()) { try { (from a in entity.GET_ASUNTO join t in entity.GET_TURNO on a.IdAsunto equals t.IdAsunto join o in entity.GET_DOCUMENTOS on t.IdTurno equals o.IdTurno where o.IsActive == true && t.IdTurno ==IdTurno select o).ToList().ForEach(p => { Documentos.Add(new Model.DocumentosModel() { IdDocumento = p.IdDocumento, DocumentoName = p.DocumentoName, DocumentoPath = p.DocumentoPath, Extencion = p.Extencion, IsActive = p.IsActive, IdTurno = p.IdTurno, Fecha = p.Fecha, IdExpediente = p.IdExpediente, IdTipoDocumento = p.IdTipoDocumento, TipoDocumento = new Model.TipoDocumentoModel() { TipoDocumentoName = p.CAT_TIPO_DOCUMENTO.TipoDocumentoName }, IsDocumentoOriginal = p.IsDocumentoOriginal }); }); } catch (Exception) { ; } } return Documentos; }
public int GetRespuestaTurnos(long IdAsunto) { int result = 0; using (var entity = new GestorDocumentEntities()) { try { result = (from t in entity.GET_TURNO where t.IdAsunto == IdAsunto && !t.IsTurnado && !t.IsAtendido select t).Count(); } catch (Exception) { ; } } return result; }
/// <summary> /// Ejecuta el spGetTablero para obtener la informacion del tablero principal. /// </summary> /// <param name="IdRol"></param> /// <returns></returns> public List<TableroModel> GetTablero(long IdRol) { List<TableroModel> items = new List<TableroModel>(); try { using (var entity=new GestorDocumentEntities()) { entity.spGetTablero(IdRol).ToList().ForEach(row => { items.Add(new TableroModel() { IdTablero = row.IdTablero, Categoria = row.CATEGORIA, Total = (int)row.TOTAL }); }); } } catch (Exception) { } return items; }
public IEnumerable<Model.DestinatarioCcpModel> GetDestinatariosCcp(long IdAsunto) { ObservableCollection<Model.DestinatarioCcpModel> destinatarioCcp = new ObservableCollection<Model.DestinatarioCcpModel>(); using (var entity = new GestorDocumentEntities()) { try { (from o in entity.REL_DESTINATARIO_CCP join r in entity.APP_ROL on o.IdRol equals r.IdRol join or in entity.CAT_ORGANIGRAMA on o.IdRol equals or.IdRol where o.IsActive == true && o.IdAsunto == IdAsunto select new { o, or }).ToList().ForEach(p => { destinatarioCcp.Add(new Model.DestinatarioCcpModel() { IdDestinatarioCcp = p.o.IdDestinatarioCcp, IdRol = p.o.IdRol, Rol = new Model.RolModel() { IdRol = p.o.IdRol , RolName = p.o.APP_ROL.RolName , Organigrama = new Model.OrganigramaModel() { IdJerarquia = p.or.IdJerarquia, JerarquiaName = p.or.JerarquiaName, JerarquiaTitular =p.or.JerarquiaTitular } }, IdAsunto = p.o.IdAsunto, IsActive = p.o.IsActive, LastModidiedDate = p.o.LastModifiedDate, IsModified = p.o.IsModified, ServerLastModifiedDate = p.o.ServerLastModifiedDate }); }); } catch (Exception) { ; } } return destinatarioCcp; }
public void InsertDestinatarioCcp(IEnumerable<Model.DestinatarioCcpModel> destinatariosCcp) { using (var entity = new GestorDocumentEntities()) { foreach (Model.DestinatarioCcpModel p in destinatariosCcp) { REL_DESTINATARIO_CCP result = null; try { result = (from o in entity.REL_DESTINATARIO_CCP where o.IdDestinatarioCcp == p.IdDestinatarioCcp select o).First(); } catch (Exception) { ; } if (result == null) { entity.REL_DESTINATARIO_CCP.AddObject( new REL_DESTINATARIO_CCP() { IdDestinatarioCcp = p.IdDestinatarioCcp , IdRol = p.IdRol , IdAsunto = p.IdAsunto , IsActive = p.IsActive , IsModified = true , LastModifiedDate = new UNID().getNewUNID() } ); } } entity.SaveChanges(); UpdateSyncLocal("REL_DESTINATARIO_CCP", entity); } }
public void UpdateDestinatarioCcp(Model.DestinatarioCcpModel destinatarioCcp) { using (var entity = new GestorDocumentEntities()) { if (destinatarioCcp != null) { REL_DESTINATARIO_CCP result = null; try { result = (from o in entity.REL_DESTINATARIO_CCP where o.IdDestinatarioCcp == destinatarioCcp.IdDestinatarioCcp select o).First(); } catch (Exception ex) { ; } if (result != null) { result.IdDestinatarioCcp = destinatarioCcp.IdDestinatarioCcp; result.IdRol = destinatarioCcp.IdRol; result.IdAsunto = destinatarioCcp.IdAsunto; result.IsModified = true; result.LastModifiedDate = new UNID().getNewUNID(); entity.SaveChanges(); UpdateSyncLocal("REL_DESTINATARIO_CCP", entity); } } } }
public void InsertDestinatarioCcp(Model.DestinatarioCcpModel destinatarioCcp) { using (var entity = new GestorDocumentEntities()) if (destinatarioCcp != null) { //Validar si el elemento ya existe REL_DESTINATARIO_CCP result = null; try { result = (from o in entity.REL_DESTINATARIO_CCP where o.IdDestinatarioCcp == destinatarioCcp.IdDestinatarioCcp select o).First(); } catch (Exception ex) { ; } if (result == null) { entity.REL_DESTINATARIO_CCP.AddObject( new REL_DESTINATARIO_CCP() { IdDestinatarioCcp = destinatarioCcp.IdDestinatarioCcp, IdRol = destinatarioCcp.IdRol, IdAsunto = destinatarioCcp.IdAsunto, IsModified = true, LastModifiedDate = new UNID().getNewUNID() } ); entity.SaveChanges(); UpdateSyncLocal("REL_DESTINATARIO_CCP", entity); } } }