コード例 #1
0
        public async Task <IHttpActionResult> PostONLINEUSER(ONLINEUSER oNLINEUSER)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.ONLINEUSERS.Add(oNLINEUSER);

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateException)
            {
                //if (ONLINEUSERExists(oNLINEUSER.ID))
                //{
                //    return Conflict();
                //}
                //else
                //{
                //    throw;
                //}
            }

            return(CreatedAtRoute("DefaultApi", new { id = oNLINEUSER.ID }, oNLINEUSER));
        }
コード例 #2
0
        public async Task <IHttpActionResult> PutONLINEUSER(int id, ONLINEUSER oNLINEUSER)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != oNLINEUSER.ID)
            {
                return(BadRequest());
            }

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

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

            return(StatusCode(HttpStatusCode.NoContent));
        }
コード例 #3
0
        public async Task <IHttpActionResult> GetONLINEUSER(int id)
        {
            ONLINEUSER oNLINEUSER = await db.ONLINEUSERS.FindAsync(id);

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

            return(Ok(oNLINEUSER));
        }
コード例 #4
0
        public Task <int> SetOnline(string userName)
        {
            int data = db.ONLINEUSERS.Where(s => s.USERINFO.USER_NAME == userName).Count();

            if (data == 0)
            {
                ONLINEUSER newObj = new ONLINEUSER();
                newObj.USERID          = db.USERINFOes.Where(s => s.USER_NAME == userName).Select(s => s.ID).FirstOrDefault();
                db.Entry(newObj).State = EntityState.Added;
                return(db.SaveChangesAsync());
            }
            return(Task.FromResult(0));
        }
コード例 #5
0
        public async Task <IHttpActionResult> DeleteONLINEUSER(int id)
        {
            ONLINEUSER oNLINEUSER = await db.ONLINEUSERS.FindAsync(id);

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

            db.ONLINEUSERS.Remove(oNLINEUSER);
            await db.SaveChangesAsync();

            return(Ok(oNLINEUSER));
        }