/// <summary>
/// 更改某个id相同的Task的信息
/// </summary>
/// <param name="updateTask"></param>
/// <returns></returns>
public async Task <bool> UpdateTaskAsync(MyDatabaseContext.Task updateTask)
{
using (var db = new MyDatabaseContext())
{
var task = await db.Tasks.SingleOrDefaultAsync(m => m.ID == updateTask.ID);
if (task != null)
{
task.Date = updateTask.Date;
task.Begin = updateTask.Begin;
task.DefaultTime = updateTask.DefaultTime;
task.FinishTime = updateTask.FinishTime;
task.FinishFlag = updateTask.FinishFlag;
task.UserID = updateTask.UserID;
task.Introduction = updateTask.Introduction;
await db.SaveChangesAsync();
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 返回一个task类型对象(无id)
/// </summary>
/// <param name="Date"></param>
/// <param name="Begin"></param>
/// <param name="DefaultTime"></param>
/// <param name="FinishTime"></param>
/// <param name="Introduction"></param>
/// <param name="FinishFlag"></param>
/// <param name="UserID"></param>
/// <returns></returns>
public MyDatabaseContext.Task GetTask(string Date, string Begin, int DefaultTime, int FinishTime, string Introduction, int FinishFlag, int UserID)
{
var temp = new MyDatabaseContext.Task();
temp.Date = Date;
temp.Begin = Begin;
temp.DefaultTime = DefaultTime;
temp.FinishTime = FinishTime;
temp.FinishFlag = FinishFlag;
temp.UserID = UserID;
temp.Introduction = Introduction;
return(temp);
}
/// <summary>
/// 新增一个Task到数据库中
/// </summary>
/// <param name="newTask"></param>
/// <returns></returns>
public async Task <bool> AddTaskAsync(MyDatabaseContext.Task newTask)
{
using (var db = new MyDatabaseContext())
{
var Announcement = await db.Tasks.FirstOrDefaultAsync(m => m.Date == newTask.Date && m.Begin == newTask.Begin);
if (Announcement == null)
{
db.Tasks.Add(newTask);
await db.SaveChangesAsync();
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 更改某个id相同的Task的信息:只变更introduction
/// </summary>
/// <param name="updateTask"></param>
/// <returns></returns>
public async Task <bool> UpdateTaskIntroductionAsync(MyDatabaseContext.Task updateTask)
{
using (var db = new MyDatabaseContext())
{
var task = await db.Tasks.SingleOrDefaultAsync(m => m.ID == updateTask.ID);
if (task != null)
{
task.Introduction = updateTask.Introduction;
await db.SaveChangesAsync();
return(true);
}
else
{
return(false);
}
}
}
