/// <summary>
/// method to check whether the task is valid to close.
/// </summary>
/// <param name="taskItem"></param>
/// <returns></returns>
public bool IsTaskValid(TaskDetailModel taskItem)
{
var taskItems = _taskDetailsRepository.GetAllTasks().Result;
var isValid = !taskItems.Any(t => t.ParentTaskId == taskItem.Id && t.EndTask == false);
return(isValid);
}
public ActionResult Create(TaskDetailModel model)
{
// Insert the new task into the database
_insertNewTaskCommandHandler.Handle(new InsertNewTaskCommand(model.Title, model.Description, model.JobType, model.MoneyOffer, model.WorkPeriod, HttpContext.Session.GetInt32("userid").Value));
// Redirect to User Profile page so user can view the new task in there list of offered postings
return(RedirectToAction("Index", "UserProfile"));
}
public bool Create(TaskViewModel vm, Guid userId)
{
//往taskdetail插入数据
//把TaskViewModel转换成TaskDetialModel
var m = new TaskDetailModel {
TaskID = Guid.Parse(vm.p), DetailNo = vm.p2,
};
var m1 = new TaskScoreModel {
TaskID = m.TaskID, Score = 0
};
var tid = vm.p;
var seq = Convert.ToInt32(vm.p1);
//查询其他数据:
//根据tid和seq获取tArticleID
var task = (TaskArticleModel)tadb.Read(tid, seq);
//根据tArticleID获取tArticleNo
var taid = task.ArticleID;
var tano = task.ArticleNo;
m.ArticleID = taid;
m.ArticleNo = tano;
//根据tArticleID 和 DetailNo 获取 tDetailID
var articleDetail = (ArticleDetailModel)addb.Read(taid.ToString(), m.DetailNo);
m.DetailID = articleDetail.ID;
//根据tArticleID获取AnswerNo
var answer = (ArticleAnswerModel)andb.Read(taid.ToString());
m.AnswerNo = answer.cNo;
db.Create(m, vm.p1);
if (vm.p1 == "5")
{
//这里要计算一下m1的Score
var list = db.List(tid).Cast <TaskDetailModel>();
var score = list.Where(x => x.DetailNo == x.AnswerNo).Count();
m1.UserID = userId;
m1.Score = score;
sdb.Create(m1);
int p = score;
if (score == 5)
{
p++;
}
uplogic.CreatePoint(userId, p);
}
//如果是最后一个,还要往taskscore插入数据
return(true);
}
private IModel Read(Dictionary <string, object> r)
{
var m = new TaskDetailModel();
var type = typeof(TaskDetailModel);
var guid = new Guid(r["cID"].ToString());
PropertyInfo pi = type.BaseType.GetProperty("ID");
pi.SetValue(m, guid);
m.TaskID = new Guid(r["cTaskID"].ToString());
m.ArticleID = new Guid(r["cArticleID"].ToString());
m.ArticleNo = r["cArticleNo"].ToString();
m.DetailID = Guid.Parse(r["cDetailID"].ToString());
m.DetailNo = r["cDetailNo"].ToString();
m.AnswerNo = r["cAnswerNo"].ToString();
return(m);
}
public bool Create(TaskDetailModel m, TaskScoreModel m1)
{
var x = new TaskScoreDB().GetCreateSQL();
var sql1 = string.Format(cSql, Guid.NewGuid(), m.TaskID, m.ArticleID, m.ArticleNo, m.DetailID, m.DetailNo, m.AnswerNo);
var sql2 = string.Format(x, Guid.NewGuid(), m1.TaskID, m1.Score);
var sql3 = string.Format(db.GetUpdateSQL(), m.TaskID, Common.Seed);
var sqls = new List <string>();
sqls.Add(sql1);
sqls.Add(sql2);
sqls.Add(sql3);
var result = utility.Exec(sqls.ToArray());
return(result.Item1);
}
// GET: TaskDetail/Details/5
public ActionResult Details(int id)
{
// Get task by TaskId
var task = _getTaskByIdQueryHandler.Handle(new GetTaskByIdQuery(id));
// Create and match the data from Task to TaskDetailModel
var taskModel = new TaskDetailModel();
taskModel.Id = task.Id;
taskModel.Title = task.Title;
taskModel.Description = task.Description;
taskModel.JobType = task.JobType;
taskModel.MoneyOffer = task.MoneyOffer;
taskModel.WorkPeriod = task.WorkPeriod;
taskModel.OffererId = task.OffererId;
// Return Details view with the corresponding model
return(View(taskModel));
}
//List<TaskModel> l_task1 = new List<TaskModel>()
// {
// new TaskModel(){ TaskID = 2, ProjectID = 1, TaskName = "Icon Creation", StartDate = new DateTime(), EndDate = new DateTime(), Priority = 15, Status = "InProgress", ParentID = 2 },
// new TaskModel(){ TaskID = 1003,ProjectID = 7, TaskName = "Task 1", StartDate = new DateTime(), EndDate = new DateTime(), Priority = 15, Status = "InProgress", ParentID = 2 },
// };
public List <TaskDetailModel> Get()
{
List <TaskDetailModel> l_TaskDetailModels = new List <TaskDetailModel>();
using (masterEntities mstEntities = new masterEntities())
{
List <Task> l_task = new List <Task>();
l_task = mstEntities.Tasks.Select(x => x).ToList();
//List<TaskModel> l_task = new List<TaskModel>();
//l_task = l_task1.Select(x => x).ToList();
if (l_task?.Count > 0)
{
foreach (var task in l_task)
{
TaskDetailModel taskDetailmodel = new TaskDetailModel();
taskDetailmodel.TaskEndDate = task.EndDate;
taskDetailmodel.TaskPriority = Convert.ToInt32(task.Priority);
taskDetailmodel.TaskProjectID = Convert.ToInt32(task.Project);
taskDetailmodel.TaskProjectName = mstEntities.Projects.Where(t => t.Project_ID == task.Project_ID).Select(x => x.ProjectName).FirstOrDefault();
taskDetailmodel.TaskStartDate = task.StartDate;
taskDetailmodel.TaskStatus = task.Status;
taskDetailmodel.TaskID = task.Task_ID;
taskDetailmodel.TaskName = task.TaskName;
taskDetailmodel.ParentTaskID = Convert.ToInt32(task.Parent_ID);
taskDetailmodel.ParentTaskName = mstEntities.Tasks.Where(t => t.Task_ID == task.Parent_ID).Select(x => x.TaskName).FirstOrDefault();
l_TaskDetailModels.Add(taskDetailmodel);
}
}
};
return(l_TaskDetailModels);
}
/// <summary>
/// Method to update the task details
/// </summary>
/// <param name="id">taskid</param>
/// <param name="taskItem">taskdetail</param>
/// <returns></returns>
public async Task UpdateTaskDetails(int id, TaskDetailModel taskItem)
{
await _taskDetailsRepository.Update(id, taskItem);
}
/// <summary>
/// Method to add task details
/// </summary>
/// <param name="taskItem">task detail</param>
/// <returns></returns>
public async Task <int> AddTaskDetails(TaskDetailModel taskItem)
{
return(await _taskDetailsRepository.Insert(taskItem));
}
