public IHttpActionResult Delete(Guid?Id)
        {
            if (Id == null || Id == Guid.Empty)
            {
                return(BadRequest("Not a valid appointment id"));
            }

            using (var ctx = new usrEntities3())
            {
                var cita = ctx.cita
                           .Where(s => s.Id == Id)
                           .FirstOrDefault();
                if (cita != null)
                {
                    ctx.Entry(cita).State = System.Data.Entity.EntityState.Deleted;
                    ctx.SaveChanges();
                }
                else
                {
                    return(NotFound());
                }
            }

            return(Ok());
        }
        public IHttpActionResult Put(cita cita)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Not a valid data"));
            }

            using (var ctx = new usrEntities3())
            {
                var existingcita = ctx.cita.Where(s => s.Id == cita.Id).FirstOrDefault <cita>();

                if (existingcita != null)
                {
                    existingcita.titulo     = cita.titulo;
                    existingcita.inicio     = cita.inicio;
                    existingcita.estatus    = cita.estatus;
                    existingcita.IdTipoCita = cita.IdTipoCita;

                    ctx.SaveChanges();
                }
                else
                {
                    return(NotFound());
                }
            }
            return(Ok());
        }
 public override bool ValidateUser(string username, string password)
 {
     using (var db = new usrEntities3())
     {
         var pass = SeguridasdUtilidades.GetSha1(password);
         return(db.usuario.Any(o => o.pasword == pass && o.loger == username));
     }
 }
 public override MembershipUser GetUser(string username, bool userIsOnline)
 {
     using (var db = new usrEntities3())
     {
         //var user = db.usuario.FirstOrDefault(o => o.loger == username);
         //return user == null ? null : new UsuarioMembership( user);
         var user = db.usuario.FirstOrDefault(o => o.loger == username);
         return(user == null ? null : new UsuarioMembership(user));
     }
 }
        public HttpResponseMessage Get()
        {
            using (usrEntities3 entities = new usrEntities3())
            {
                DateTime hoy     = DateTime.Now;
                var      eventos = (from cita in entities.cita select new { title = cita.titulo, start = cita.inicio, tipo = cita.TiposCitas.nombre }).ToList();

                return(new HttpResponseMessage()
                {
                    Content = new StringContent(JArray.FromObject(eventos).ToString(), Encoding.UTF8, "application/json")
                });
            }
        }
        public IHttpActionResult PostNewCitas(cita cita)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Not a valid model"));
            }

            using (var ctx = new usrEntities3())
            {
                ctx.cita.Add(new cita()
                {
                    Id         = Guid.NewGuid(),
                    titulo     = cita.titulo,
                    inicio     = cita.inicio,
                    estatus    = "active",
                    IdTipoCita = cita.IdTipoCita
                });

                ctx.SaveChanges();
            }

            return(Ok());
        }
Exemplo n.º 7
0
        // GET: Citas
        //AUTENTICO INDEX

        /*public ActionResult Index()
         * {
         *  return View();
         * }*/
        //index con la 'primera prueba de api web

        /*public ActionResult Index()
         * {
         *  //return View();
         *  using (usrEntities entities = new usrEntities())
         *  {
         *      return Json(entities.cita.ToList(), JsonRequestBehavior.AllowGet);
         *  }
         * }*/
        //INDEX con las api's
        // GET: Student
        public ActionResult Index()
        {
            List <cita> lista = new List <cita>();

            using (usrEntities3 entities = new usrEntities3())
            {
                lista = entities.cita.ToList();
            }
            // IEnumerable<cita> cita = null;

            /*using (var client = new HttpClient())
             * {
             *  client.BaseAddress = new Uri("http://localhost:44336/api/Citas");
             *  //HTTP GET
             *  var responseTask = client.GetAsync("cita");
             *  responseTask.Wait();
             *
             *  var result = responseTask.Result;
             *  if (result.IsSuccessStatusCode)
             *  {
             *      var readTask = result.Content.ReadAsAsync<IList<cita>>();
             *      readTask.Wait();
             *
             *      cita = readTask.Result;
             *  }
             *  else //web api sent error response
             *  {
             *      //log response status here..
             *
             *      cita = Enumerable.Empty<cita>();
             *
             *      ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
             *  }
             * }*/
            return(View(lista));    //return View();
        }