public bool Post4Testing(int all) { usersTable ut = new usersTable(); ut.userid = 5; try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { if (ut.userid > 0) { entities.usersTables.Add(ut); entities.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { return(false); } }
public HttpResponseMessage Post([FromBody] usersTable ut) { try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { if (ut.userid > 0) { entities.usersTables.Add(ut); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, ut); message.Headers.Location = new Uri(Request.RequestUri + "/" + ut.userid.ToString()); return(message); } else { var message = Request.CreateResponse(HttpStatusCode.LengthRequired); return(message); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <usersTable> Get() { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { return(entities.usersTables.ToList()); } }
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); } }
//------------Testing Methods------------------// public int Get4Testing(int all) { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { return(entities.taskTables.ToList().Count); } }
public IEnumerable <parentTask> Get() { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { return(entities.parentTasks.ToList()); } }
public bool Post4Testing(int all) { projectTable pt = new projectTable(); pt.projectid = 5; pt.projectdesc = "Testing"; pt.priority = 12; try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { if (pt.projectid > 0) { entities.projectTables.Add(pt); entities.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { return(false); } }
public bool Put4Testing(int all) { usersTable ut = new usersTable(); ut.userid = 5; ut.firstname = "Testing1"; ut.lastname = "Testing1"; ut.employeeid = 0; try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.usersTables.FirstOrDefault(u => u.userid == ut.userid); if (entity == null) { return(false); } else { if (ut.firstname != null) { entity.firstname = ut.firstname; } if (ut.lastname != null) { entity.lastname = ut.lastname; } if (ut.employeeid != null) { entity.employeeid = ut.employeeid; } if (ut.projectid != null) { entity.projectid = ut.projectid; } if (ut.taskid != null) { entity.taskid = ut.taskid; } entities.SaveChanges(); return(true); } } } catch (Exception ex) { return(false); } }
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); } } }
//[HttpPut] //public HttpResponseMessage UpdateProjectId([FromBody]usersTable ut) //{ // try // { // using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) // { // var entity = entities.usersTables.FirstOrDefault(u => u.userid == ut.userid); // if (entity == null) // { // return Request.CreateErrorResponse(HttpStatusCode.NotFound, "UserId = " + ut.userid + " not found to update."); // } // else // { // entity.projectid = ut.projectid; // entities.SaveChanges(); // return Request.CreateResponse(HttpStatusCode.OK, entity); // } // } // } // catch (Exception ex) // { // return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex); // } //} public HttpResponseMessage Put([FromBody] usersTable ut) { try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.usersTables.FirstOrDefault(u => u.userid == ut.userid); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "UserId = " + ut.userid.ToString() + " not found to update.")); } else { if (ut.firstname != null) { entity.firstname = ut.firstname; } if (ut.lastname != null) { entity.lastname = ut.lastname; } if (ut.employeeid != null) { entity.employeeid = ut.employeeid; } if (ut.projectid != null) { entity.projectid = ut.projectid; } if (ut.taskid != null) { entity.taskid = ut.taskid; } entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public bool Put4Testing(int all) { projectTable pt = new projectTable(); pt.projectid = 5; pt.priority = 19; pt.startdate = new DateTime().Date; try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.projectTables.FirstOrDefault(proj => proj.projectid == pt.projectid); if (entity == null) { return(false); } else { if (pt.projectdesc != null) { entity.projectdesc = pt.projectdesc; } if (pt.priority != null) { entity.priority = pt.priority; } if (pt.startdate != null) { entity.startdate = pt.startdate; } if (pt.enddate != null) { entity.enddate = pt.enddate; } entities.SaveChanges(); return(true); } } } catch (Exception ex) { return(false); } }
public bool GetbyRow4Testing(int userid) { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.usersTables.FirstOrDefault(ut => ut.userid == userid); if (entity != null) { return(false); } else { return(true); } } }
public HttpResponseMessage Get(int id) { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.usersTables.FirstOrDefault(ut => ut.userid == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "User ID " + entity.userid + " not found")); } } }
public bool Delete4Testing(int deleteRow) { try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.usersTables.FirstOrDefault(u => u.userid == deleteRow); if (entity == null) { return(false); } else { entities.usersTables.Remove(entity); entities.SaveChanges(); return(true); } } } catch (Exception ex) { return(false); } }
public HttpResponseMessage Delete(int id) { try { using (DataAccessLayer.ProjectMgrEntities entities = new DataAccessLayer.ProjectMgrEntities()) { var entity = entities.usersTables.FirstOrDefault(u => u.userid == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "UserID = " + id.ToString() + " not found to delete")); } else { entities.usersTables.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }