public async Task <ActionResult <WorkItemResponse> > FindOwnWork([FromBody] ViewWorkRequest request)
{
WorkItemResponse workItem = new WorkItemResponse();
workItem.totalpage = 0;
workItem.pagenum = request.pagenum;
workItem.worklist = new List <WorkResponse>();
var start = (request.pagenum - 1) * request.pagesize;
var end = request.pagenum * request.pagesize - 1;
//取得存在cookie的当前账户id
var stu_id = Int32.Parse(User.Identity.Name);
string search = '%' + request.query + '%';
var temp = await WorkAccessor.FindOwnWork(search, stu_id);
if (temp != null)
{
for (int i = 0; i < temp.total; i++)
{
workItem.totalpage++;
if (i >= start && i <= end)
{
WorkResponse a = _mapper.Map <WorkResponse>(temp.workItem[i]);
var s = await TakesAccessor.FindInfo(stu_id, a.work_id);
a.status = s.status;
workItem.worklist.Add(a);
}
}
return(Ok(workItem));
}
return(Ok(-1));
}
public async Task <int> Getresign([FromBody] FindworkRequest request)
{
//判断request里是否满足前置条件
if (!ModelState.IsValid)
{
return(-1);
}
var user_id = Int32.Parse(User.Identity.Name);
if (await UserAccessor.CheckRole(user_id) != Role.Student)
{
return(-2);
}
TakesEntity entity = new TakesEntity();
entity.work_id = request.work_id;
entity.student_id = user_id;
MessageEntity temp_entity = new MessageEntity();
var work_name = await WorkAccessor.GetWorkName(request.work_id);
var student_name = await UserAccessor.GetUserName(user_id);
temp_entity.message_type = 0;
temp_entity.content = student_name + "同学辞去" + work_name + "工作。";
temp_entity.sender_id = user_id;
temp_entity.receiver_id = await WorkAccessor.GetTeacher(request.work_id);
var num = await TakesAccessor.GetRegion(entity);
await MessageAccessor.Create(temp_entity, 1);
return(num);
}
//[AllowAnonymous]
public async Task <ActionResult <ApplyResponse> > ProManageApp(ManageApplyRequest request)
{
var pro_id = Int32.Parse(User.Identity.Name);
if (await UserAccessor.CheckRole(pro_id) == Role.Student)
{
return(BadRequest(new { message = "Students cannot manage application." }));
}
ApplyEntity ae = await ApplyAccessor.Read(request.apply_id);
if (ae == null)
{
return(BadRequest(new { message = "Apply id not found." }));
}
if (ae.status != Constants.ApplyStatus.Applying)
{
return(BadRequest(new { message = "Application have been managed." }));
}
var success_change = await ApplyAccessor.SetApplyStatus(request.apply_id, request.status);
if (success_change > 0)
{
ae.status = request.status; //减少查询
ApplyResponse ar = _mapper.Map <ApplyResponse>(ae);
// 未检查id是否存在
ar.student_name = await UserAccessor.GetUserName(ae.student_id);
ar.teacher_name = await UserAccessor.GetUserName(ae.teacher_id);
ar.work_name = await WorkAccessor.GetWorkName(ae.work_id);
if (request.status == Constants.ApplyStatus.Accepted)
{
// 录用，创建takes
var take = new TakesEntity
{
work_name = ar.work_name,
student_id = ae.student_id,
work_id = ae.work_id,
work_time = await WorkAccessor.GetWorkTotalTime(ae.work_id)
};
await TakesAccessor.Create(take);
}
return(ar);
}
return(BadRequest(new { message = "Update failed" }));
}
//[AllowAnonymous]
public async Task <ActionResult <LeaveResponse> > ProManageLeave(ManageLeaveRequest request)
{
var pro_id = Int32.Parse(User.Identity.Name);
if (await UserAccessor.CheckRole(pro_id) == Constants.Role.Student)
{
return(BadRequest(new { message = "Students cannot manage leave application." }));
}
LeaveEntity le = await LeaveAccessor.Read(request.leave_id);
if (le == null)
{
return(BadRequest(new { message = "Leave id not found." }));
}
if (le.status != Constants.ApplyStatus.Applying)
{
return(BadRequest(new { message = "The application have been managed." }));
}
var success_change = await LeaveAccessor.SetLeaveStatus(request.leave_id, request.status);
if (success_change > 0)
{
le.status = request.status; //减少查询
LeaveResponse lr = _mapper.Map <LeaveResponse>(le);
// 未检查id是否存在
lr.student_name = await UserAccessor.GetUserName(le.student_id);
//lr.teacher_name = await UserAccessor.GetUserName(le.teacher_id);
lr.work_name = await WorkAccessor.GetWorkName(le.work_id);
if (request.status == Constants.ApplyStatus.Accepted)
{
// 录用，更新takes
await TakesAccessor.UpdateAbsent(le.student_id, le.work_id, le.leave_duration);
}
return(lr);
}
return(BadRequest(new { message = "Update failed" }));
}
public async Task <int> Deleteresign([FromBody] FindworkRequest request)
{
//判断request里是否满足前置条件
if (!ModelState.IsValid)
{
return(-1);
}
var user_id = Int32.Parse(User.Identity.Name);
if (await UserAccessor.CheckRole(user_id) != Role.Student)
{
return(-2);
}
TakesEntity entity = new TakesEntity();
entity.work_id = request.work_id;
entity.student_id = user_id;
var num = await TakesAccessor.Delete(entity);
return(num);
}
public async Task <ActionResult <UserInfoResponse> > GetUserInfo()
{
//取得存在cookie的当前账户id
var u_id = Int32.Parse(User.Identity.Name);
//查找当前id是否存在user
var temp = await UserAccessor.Read(u_id);
if (temp != null)
{
var user_res = _mapper.Map <UserInfoResponse>(temp);
if (temp.user_role == Constants.Role.Student)
{
//is student
user_res.nof_apply = await ApplyAccessor.GetNumOfApp(u_id); //count(apply.apply_id)
user_res.income = await SalaryAccessor.GetSumOfSalary(u_id); //sum(salary.num)
var waa = await TakesAccessor.GetSumOfWorkAndAbsent(u_id);
user_res.nof_absent = waa.sum_absent_num; //sum(takes.absent_num)
user_res.work_time = waa.sum_work_time; //sum(takes.work_time)
user_res.absent_time = waa.sum_absent_time; //sume(takes.absent_time)
}
else
{
//not student
user_res.nof_apply = 0;
user_res.nof_absent = 0;
user_res.work_time = 0;
user_res.income = 0;
user_res.absent_time = 0;
}
return(Ok(user_res));
}
//未找到user
return(BadRequest(new { message = "cannot find the user" }));
}
