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));
}
}
