public List <WorkDoneandPlans> GetWorkDoneAndPlansbyDate(User user, DateTime dateTime)
{
var plans = from plan in db.Plans
join work in db.TodoLists on plan.work_id equals work.id
where plan.work_plan_time == dateTime.Date && work.user_id == user.id
orderby plan.id ascending
select new WorkDoneandPlans
{
PlanDate = plan.work_plan_time,
Priority = work.priority,
RequestNumber = work.request_number,
AddDate = plan.add_time,
PlanID = plan.id
};
List <WorkDoneandPlans> workDoneandPlans = plans.ToList();
for (int i = 0; i < workDoneandPlans.Count(); i++)
{
WorkDone workDone = GetWorkDoneByPlanID(workDoneandPlans[i].PlanID);
if (workDone != null)
{
workDoneandPlans[i].WorkDescription = workDone.description;
workDoneandPlans[i].WorkDoneDate = workDone.workDoneTime.Value;
}
}
return(workDoneandPlans);
}
public byte EditWorkDone(WorkDone workDone)
{
if (!db.WorkDones.Any(x => x.id == workDone.id))
{
return(0);
}
db.WorkDones.Attach(workDone);
db.Entry(workDone).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
public void MoveWorkToWorkDone(WorkDone workdone)
{
db.WorkDones.Add(workdone);
db.SaveChanges();
}
public void RemoveWorkdone(WorkDone workdone)
{
db.WorkDones.Remove(workdone);
db.SaveChanges();
}
