Esempio n. 1
0
        public async Task <IHttpActionResult> Puttbl_Requirements(int id, tbl_Requirements tbl_Requirements)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tbl_Requirements.col_RequirementID)
            {
                return(BadRequest());
            }

            db.Entry(tbl_Requirements).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tbl_RequirementsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Esempio n. 2
0
        public async Task <IHttpActionResult> Posttbl_Requirements(tbl_Requirements tbl_Requirements)
        {
            LogApi.Log(User.Identity.GetUserId(), "PostRequirement " + User.Identity.GetUserName());

            var id = User.Identity.GetUserId();

            tbl_Requirements.col_PostedBy = id;
            tbl_Requirements.col_RequirementPostedDate = DateTime.Now;
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tbl_Requirements.Add(tbl_Requirements);
            await db.SaveChangesAsync();

            try
            {
                var tokens = db.tbl_DeviceIds;
                foreach (var d in tokens)
                {
                    Notifications.NotifyAsync(d.col_DeviceToken, "Requirement", "New Requirement: " + tbl_Requirements.col_RequirementCategory + "#" + tbl_Requirements.col_RequirementDescription + "#" + id);
                }
            }
            catch (Exception ex)
            {
                return(Ok("Failed"));
            }
            return(Ok("Posted"));
        }
Esempio n. 3
0
        public async Task <IHttpActionResult> Gettbl_Requirements(int id)
        {
            tbl_Requirements tbl_Requirements = await db.tbl_Requirements.FindAsync(id);

            if (tbl_Requirements == null)
            {
                return(NotFound());
            }

            return(Ok(tbl_Requirements));
        }
Esempio n. 4
0
        public async Task <IHttpActionResult> Deletetbl_Requirements(int id)
        {
            LogApi.Log(User.Identity.GetUserId(), "DeleteRequirement " + User.Identity.GetUserName());

            tbl_Requirements tbl_Requirements = await db.tbl_Requirements.FindAsync(id);

            if (tbl_Requirements == null)
            {
                return(NotFound());
            }

            db.tbl_Requirements.Remove(tbl_Requirements);
            await db.SaveChangesAsync();

            return(Ok("Deleted"));
        }