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