public HttpResponseMessage Post([FromBody] taskTable tt) { try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { if (tt.taskid > 0) { entities.taskTables.Add(tt); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, tt); message.Headers.Location = new Uri(Request.RequestUri + "/" + tt.taskid.ToString()); return(message); } else { var message = Request.CreateResponse(HttpStatusCode.LengthRequired); return(message); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public bool Post4Testing(int all) { taskTable tt = new taskTable(); tt.taskid = 5; try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { if (tt.taskid > 0) { entities.taskTables.Add(tt); entities.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { return(true); } }
public HttpResponseMessage Put([FromBody] taskTable tt) { try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.taskTables.FirstOrDefault(u => u.taskid == tt.taskid); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "TaskID = " + tt.taskid.ToString() + " not found to update.")); } else { if (tt.status != null) { entity.status = tt.status; } if (tt.enddate != null) { entity.enddate = tt.enddate; } if (tt.startdate != null) { entity.startdate = tt.startdate; } if (tt.priority != null) { entity.priority = tt.priority; } if (tt.taskdesc != null) { entity.taskdesc = tt.taskdesc; } if (tt.projectid != null) { entity.projectid = tt.projectid; } entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public bool Put4Testing(int all) { taskTable tt = new taskTable(); tt.taskid = 5; tt.projectid = 5; tt.priority = 10; tt.status = "In Progress"; using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.taskTables.FirstOrDefault(u => u.taskid == tt.taskid); if (entity == null) { return(false); } else { if (tt.status != null) { entity.status = tt.status; } if (tt.enddate != null) { entity.enddate = tt.enddate; } if (tt.startdate != null) { entity.startdate = tt.startdate; } if (tt.priority != null) { entity.priority = tt.priority; } if (tt.taskdesc != null) { entity.taskdesc = tt.taskdesc; } if (tt.projectid != null) { entity.projectid = tt.projectid; } entities.SaveChanges(); return(true); } } }