Esempio n. 1
0
        public IHttpActionResult GetStory(string id)
        {
            var db = new PetaPoco.Database("AGSoftware");

            Entities.Storytime storytime = db.SingleOrDefault <Entities.Storytime>("Select * From StoryTime Where StorytimeId = @0", id);

            if (storytime != null)
            {
                return(Ok(storytime));
            }
            else
            {
                return(NotFound());
            }
        }
Esempio n. 2
0
        public IHttpActionResult Post([FromUri] string id, [FromBody] Entities.Storytime storytime)
        {
            var db = new PetaPoco.Database("AGSoftware");

            storytime.DateCreated   = System.DateTime.Now;
            storytime.UserId        = Storytime.Providers.UserHelper.GetUserId(this.User.Identity.Name);
            storytime.UsersNotified = false;
            db.Insert(storytime);

            if (storytime.StorytimeType == StorytimeType.Group)
            {
                StorytimeGroup storytimegroup = new StorytimeGroup();
                storytimegroup.StorytimeId   = storytime.StorytimeId;
                storytimegroup.UserGroupId   = storytime.UserGroupId;
                storytimegroup.UsersNotified = false;
                db.Insert(storytimegroup);

                return(Ok(storytime.StorytimeId));
            }
            else if (storytime.StorytimeType == StorytimeType.User)
            {
                StorytimeUserList storytimeuserlist = new StorytimeUserList();

                foreach (AspNetUsers user in storytime.Users)
                {
                    storytimeuserlist.StorytimeId  = storytime.StorytimeId;
                    storytimeuserlist.UserId       = user.Id;
                    storytimeuserlist.UserNotified = false;
                    db.Insert(storytimeuserlist);
                }

                storytimeuserlist.StorytimeId  = storytime.StorytimeId;
                storytimeuserlist.UserId       = storytime.UserId;
                storytimeuserlist.UserNotified = false;
                db.Insert(storytimeuserlist);

                return(Ok(storytime.StorytimeId));
            }
            else
            {
                return(BadRequest("StorytimeType is invalid"));
            }
        }