public TDetail GetTById(int id)
{
using (var ctx = new ApplicationDbContext())
{
TamcTymcSamples entity = ctx.TamcTymcSamples.SingleOrDefault(e => e.TId == id);
if (entity.Employee != null)
{
return(new TDetail
{
TId = entity.TId,
IsComplete = entity.IsComplete,
DueOnDate = entity.DueOnDate,
CompletedOnDate = entity.CompletedOnDate,
Employee = entity.Employee.FirstName + " " + entity.Employee.LastName
});
}
else
{
return(new TDetail
{
TId = entity.TId,
IsComplete = entity.IsComplete,
DueOnDate = entity.DueOnDate,
CompletedOnDate = entity.CompletedOnDate
});
}
}
}
//END OF TEST
public bool DeleteT(int id)
{
using (var ctx = new ApplicationDbContext())
{
TamcTymcSamples entity = ctx.TamcTymcSamples.SingleOrDefault(e => e.TId == id);
ctx.TamcTymcSamples.Remove(entity);
return(ctx.SaveChanges() == 1);
}
}
//TEST
public bool UpdateTCompletedBy(TEdit model)
{
using (var ctx = new ApplicationDbContext())
{
TamcTymcSamples entity = ctx.TamcTymcSamples.SingleOrDefault(e => e.TId == model.TId);
//entity.DueOnDate = model.DueOnDate;
entity.CompletedOnDate = DateTime.Now;
entity.IsComplete = true;
entity.EmployeeId = model.EmployeeId;
return(ctx.SaveChanges() == 1);
}
}
public bool TCreate(TCreate model)
{
TamcTymcSamples entity = new TamcTymcSamples()
{
DueOnDate = model.DueOnDate,
IsComplete = false
};
using (var ctx = new ApplicationDbContext())
{
ctx.TamcTymcSamples.Add(entity);
return(ctx.SaveChanges() == 1);
}
}
