public JObject Login(string usuario, string clave) { logs.Add(string.Format("Entro al login de usuario")); logs = saveLogs(logs); ASISTENCIAS_CAMMESA_ENTITIES ctx = new ASISTENCIAS_CAMMESA_ENTITIES(); logs.Add(string.Format("Creo el contexto")); logs = saveLogs(logs); //ODBCDataService dataservice = new ODBCDataService(); //USUARIO usuarioODBC = new USUARIO(); try { USUARIO user = ctx.USUARIO.FirstOrDefault(p => (p.USUARIO1 == usuario && p.CLAVE == clave)); if (user != null) { var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; JObject jsonObject = new JObject(); jsonObject.Add("id", user.ID); jsonObject.Add("nombre", user.NOMBRE); jsonObject.Add("apellido", user.APELLIDO); jsonObject.Add("usuario", user.USUARIO1); jsonObject.Add("clave", user.CLAVE); // JObject json = JObject.Parse(user.ToJson<USUARIO>()); return jsonObject; } else { // var str = "{}"; // JObject j = JObject.Parse(str); return null; } // return await dataService.GetDocumentByID("AsistenciaCammesa", "Asistencia", clave, valor); } catch (Exception ex) { logs.Add(string.Format("Exception in Login InnerException:{0}, Message:{1}, TargetSite:{2}, Source:{3}, StackTrace: {4}", ex.InnerException, ex.Message, ex.TargetSite, ex.Source, ex.StackTrace)); logs = saveLogs(logs); var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(string.Format("Requested collection may be empty or Null")), StatusCode = HttpStatusCode.NotFound, ReasonPhrase = "Requested collection may be empty or Null" }; logs.Add(string.Format("El resultado de la conexion a la base MONGO, HttpResponseMessage: {0}", resp)); logs = saveLogs(logs); throw new HttpResponseException(resp); } }
public List<JObject> GetTareas(string usuario) { logs.Add(string.Format("Entro al login de usuario")); logs = saveLogs(logs); ASISTENCIAS_CAMMESA_ENTITIES ctx = new ASISTENCIAS_CAMMESA_ENTITIES(); logs.Add(string.Format("Creo el contexto")); logs = saveLogs(logs); try { var usu = Convert.ToInt32(usuario); // db.Items.Where(x => x.userid == user_ID).Select(x => x.Id).Distinct(); List<TAREA> tareas = ctx.TAREA.Where(p => p.ID_USUARIO == usu && p.ESTADO == 0 && p.DELETE == 0).ToList(); List<JObject> list = new List<JObject>(); if (tareas.Count > 0) { foreach (TAREA tarea in tareas) { JObject jsonObject = new JObject(); jsonObject.Add("id", tarea.ID); jsonObject.Add("fecha", tarea.FECHA); jsonObject.Add("asunto", tarea.ASUNTO); jsonObject.Add("prioridad", tarea.PRIORIDAD); jsonObject.Add("estado", tarea.ESTADO); jsonObject.Add("tecnico", tarea.USUARIO.APELLIDO); jsonObject.Add("tarea", tarea.TAREA1); list.Add(jsonObject); } return list; } else { return null; } } catch (Exception ex) { logs.Add(string.Format("Exception in Login InnerException:{0}, Message:{1}, TargetSite:{2}, Source:{3}, StackTrace: {4}", ex.InnerException, ex.Message, ex.TargetSite, ex.Source, ex.StackTrace)); logs = saveLogs(logs); var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(string.Format("Requested collection may be empty or Null")), StatusCode = HttpStatusCode.NotFound, ReasonPhrase = "Requested collection may be empty or Null" }; logs.Add(string.Format("El resultado de la conexion a la base MONGO, HttpResponseMessage: {0}", resp)); logs = saveLogs(logs); throw new HttpResponseException(resp); } }