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)); }
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)); }
public async Task <IHttpActionResult> GetONLINEUSER(int id) { ONLINEUSER oNLINEUSER = await db.ONLINEUSERS.FindAsync(id); if (oNLINEUSER == null) { return(NotFound()); } return(Ok(oNLINEUSER)); }
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)); }
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)); }