public AllTasks GetAllArchivedTasksById(string currentUserId)
{
AllTasks allTasks = new AllTasks();
using (var db = new TaskModelEntities())
{
var query = db.Tasks.Where(x => x.IsCompleted == true);
var tasks = query.OrderBy(x => x.DueDate).ToList();
foreach (var task in tasks)
{
if (task.IsCompleted && task.UserId == currentUserId)
{
allTasks.Tasks.Add(new TaskModel()
{
Name = task.Name,
DateCompleted = task.DateCompleted,
DateStart = task.DateStart,
Description = task.Description,
DueDate = task.DueDate,
EstimateDuration = int.Parse(task.EstimatedDuration),
IsCompleted = task.IsCompleted,
Tags = new List <string>()
{
task.Tag1, task.Tag2, task.Tag3
},
TaskId = task.id,
TaskValue = task.TaskValue
});
}
}
}
return(allTasks);
}
public void EditTaskById(int id, TaskModel model)
{
using (var db = new TaskModelEntities())
{
TaskModelDAL.Task taskToEdit = new TaskModelDAL.Task()
{
Name = model.Name,
DateCompleted = model.DateCompleted,
DateStart = model.DateStart,
Description = model.Description,
DueDate = model.DueDate,
EstimatedDuration = model.EstimateDuration.ToString(),
id = holderID,
IsCompleted = model.IsCompleted,
Tag1 = model.Tags[0],
Tag2 = model.Tags[1],
Tag3 = model.Tags[2]
};
DeleteTaskById(model.TaskId);
db.Tasks.Add(taskToEdit);
db.SaveChanges();
}
}
public void ArchiveTask(TaskModel model)
{
using (var db = new TaskModelEntities())
{
TaskModelDAL.Task taskToEdit = new TaskModelDAL.Task()
{
Name = model.Name,
DateCompleted = DateTime.Now,
DateStart = model.DateStart,
Description = model.Description,
DueDate = model.DueDate,
EstimatedDuration = model.EstimateDuration.ToString(),
id = holderID,
IsCompleted = !model.IsCompleted,
TaskValue = model.TaskValue,
Tag1 = model.Tags[0],
Tag2 = model.Tags[1],
Tag3 = model.Tags[2],
UserId = model.UserId
};
DeleteTaskById(model.TaskId);
db.Tasks.Add(taskToEdit);
try
{
db.SaveChanges();
}
catch (Exception e)
{
string s = e.Message;
}
}
}
public void AddTask(TaskModel model)
{
using (var db = new TaskModelEntities())
{
var query = db.Tasks.Select(x => x);
model.TaskId = query.Count();
TaskModelDAL.Task taskToAdd = new TaskModelDAL.Task()
{
Name = model.Name,
DateCompleted = model.DateCompleted,
DateStart = DateTime.Now,
Description = model.Description,
DueDate = model.DueDate,
EstimatedDuration = model.EstimateDuration.ToString(),
id = model.TaskId,
IsCompleted = false,
Tag1 = model.Tags[0],
Tag2 = "",
Tag3 = "",
TaskValue = model.TaskValue,
UserId = model.UserId
};
db.Tasks.Add(taskToAdd);
db.SaveChanges();
}
}
public AllTasks GetAllTasks()
{
AllTasks allTasks = new AllTasks();
using (var db = new TaskModelEntities())
{
var query = db.Tasks.Select(x => x);
var tasks = query.OrderBy(x => x.DueDate).ToList();
foreach (var task in tasks)
{
if (!task.IsCompleted)
{
allTasks.Tasks.Add(new TaskModel()
{
Name = task.Name,
DateCompleted = task.DateCompleted,
DateStart = task.DateStart,
Description = task.Description,
DueDate = task.DueDate,
EstimateDuration = int.Parse(task.EstimatedDuration),
IsCompleted = task.IsCompleted,
Tags = new List <string>()
{
task.Tag1, task.Tag2, task.Tag3
},
TaskId = task.id
});
}
}
}
return(allTasks);
}
public void DeleteTaskById(int id)
{
using (var db = new TaskModelEntities())
{
var task = db.Tasks.Where(x => x.id == holderID).First();
db.Tasks.Remove(task);
db.SaveChanges();
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public JsonResult IntegralInfo2(Guid teacherid, string xzqid, Guid schoolid)
{
TaskModelEntities task = new TaskModelEntities();
//获取学分
object[] paras = new SqlParameter[1];
paras[0] = new SqlParameter("@UserID", teacherid);
Decimal TotalScore = task.Database.SqlQuery <Decimal>(
"select isnull(Sum(TaskScore),0) TotalScore from UCHome_UserIntergral where UserID=@UserID",
paras).FirstOrDefault();
//获取等级
object[] paras2 = new SqlParameter[1];
paras2[0] = new SqlParameter("@Scores", TotalScore);
LevelInfo LevelInfo = task.Database.SqlQuery <LevelInfo>(
"select min(pindex) Pindex,min(Scores) Score,min(pindex)+1 Lindex from UCHome_IntegralLevel where Scores>@Scores",
paras2).FirstOrDefault();
//积分排名
object[] paras3 = new SqlParameter[1];
paras3[0] = new SqlParameter("@UserID", teacherid);
long citynum =
task.Database.SqlQuery <long>(
"select Number from (select ROW_NUMBER() over(order by Sum(TaskScore) desc) Number, UserID UserID,Sum(TaskScore) ACount from UCHome_UserIntergral a inner join Teacher_ZZJG0101 b on a.UserID=b.JSID group by UserID) a where UserID=@UserID",
paras3).FirstOrDefault();
//区级排名
object[] paras4 = new SqlParameter[2];
paras4[0] = new SqlParameter("@UserID", teacherid);
paras4[1] = new SqlParameter("@AreaCode", xzqid);
long areanum =
task.Database.SqlQuery <long>(
"select Number from (select ROW_NUMBER() over(order by Sum(TaskScore) desc) Number, UserID UserID,Sum(TaskScore) ACount from UCHome_UserIntergral a inner join Teacher_ZZJG0101 b on a.UserID=b.JSID inner join basic_zzxx0101 c on b.XXID=c.XXID where c.XZQHM=@AreaCode group by UserID) a where UserID=@UserID",
paras4).FirstOrDefault();
//areanum = anos.Count(a => a.AreaCode == areacode && a.Number < citynum);
//校级排名
object[] paras5 = new SqlParameter[2];
paras5[0] = new SqlParameter("@UserID", teacherid);
paras5[1] = new SqlParameter("@XXID", schoolid);
long schoolnum =
task.Database.SqlQuery <long>(
"select Number from (select ROW_NUMBER() over(order by Sum(TaskScore) desc) Number, UserID UserID,Sum(TaskScore) ACount from UCHome_UserIntergral a inner join Teacher_ZZJG0101 b on a.UserID=b.JSID where b.XXID=@XXID group by UserID) a where UserID=@UserID",
paras5).FirstOrDefault();
JsonResult jsonResult = new JsonResult
{
Data = new
{
UserID = teacherid,
TotalScore = TotalScore,
Level = LevelInfo == null ? 1 : LevelInfo.Pindex,
LLevel = LevelInfo == null ? 1 : LevelInfo.Lindex,
Score = LevelInfo == null ? 1 : LevelInfo.Score,
CityNum = citynum,
AreaNum = areanum,
SchoolNum = schoolnum,
}
};
return(Json(jsonResult, JsonRequestBehavior.AllowGet));
}