public static void EditTask(TaskWork task)
{
using (var _context = new DbGantChartContext())
{
var taskdb = (from t in _context.TaskWorks.Include(x => x.Users)
where t.ID == task.ID
select t).Single();
taskdb.Title = task.Title;
taskdb.description = task.description;
taskdb.FromDate = task.FromDate;
taskdb.ToDate = task.ToDate;
taskdb.PercentCompleted = task.PercentCompleted;
taskdb.Priority = task.Priority;
taskdb.Url = task.Url;
taskdb.Users.Clear();
foreach (User user in task.Users)
{
var userdb = (from u in _context.Users.Include(u => u.Tasks)
where u.UserName == user.UserName
select u).Single();
taskdb.Users.Add(userdb);
}
_context.SaveChanges();
}
}
public static List <User> GetListUser(string username)
{
using (var _context = new DbGantChartContext())
{
var user = _context.Users.Where(u => u.UserName.Contains(username));
return(user.ToList());
}
}
public static void AddUser(User user)
{
using (var _context = new DbGantChartContext())
{
_context.Users.Add(user);
_context.SaveChanges();
}
}
public static User GetUser(string username)
{
using (var _context = new DbGantChartContext())
{
var dbUser = (from u in _context.Users.Include("Tasks.Users")
where u.UserName == username
select u).SingleOrDefault();
return(dbUser);
}
}
public static TaskWork GetTask(int ID)
{
using (var _context = new DbGantChartContext())
{
var task = (from t in _context.TaskWorks.Include(x => x.Users)
where t.ID == ID
select t).Single();
return(task);
}
}
public static List <TaskWork> GetListTask()
{
using (var _context = new DbGantChartContext())
{
var task = (from t in _context.TaskWorks.Include(t => t.Users)
select t).ToList();
return(task);
}
}
public static void DeleteUser(User user)
{
using (var _context = new DbGantChartContext())
{
var dbUser = (from u in _context.Users.Include(x => x.Tasks)
where u.UserName == user.UserName
select u).SingleOrDefault();
_context.Users.Remove(dbUser);
_context.SaveChanges();
}
}
public static void DeleteTask(int ID)
{
using (var _context = new DbGantChartContext())
{
var task = (from t in _context.TaskWorks.Include(x => x.Users)
where t.ID == ID
select t).Single();
_context.TaskWorks.Remove(task);
_context.SaveChanges();
}
}
public static List <User> GetListUser()
{
using (var _context = new DbGantChartContext())
{
var users = _context.Users
.Include(t => t.Tasks);
var listUser = from u in users
select u;
return(listUser.ToList());
}
}
public static int UpdateUser(User user)
{
using (var _context = new DbGantChartContext())
{
if (GetUser(user.UserName) == null)
{
return(-1);
}
_context.Users.AddOrUpdate(user);
_context.SaveChanges();
return(1);
}
}
private void btDelete_Click(object sender, EventArgs e)
{
if (dataTasks.SelectedRows.Count == 0)
{
return;
}
using (var _context = new DbGantChartContext())
{
for (int i = 0; i < dataTasks.SelectedRows.Count; i++)
{
TaskController.DeleteTask(Convert.ToInt32(dataTasks.SelectedRows[i].Cells["cId"].Value));
}
}
HienThi(TaskController.GetListTask());
}
private void btDelete_Click(object sender, EventArgs e)
{
if (dataUser.SelectedRows.Count == 0)
{
return;
}
using (var _context = new DbGantChartContext())
{
for (int i = 0; i < dataUser.SelectedRows.Count; i++)
{
string str = dataUser.SelectedRows[i].Cells["cUserName"].Value.ToString();
User user = _context.Users.Find(str);
UserController.DeleteUser(user);
}
}
RefreshControll();
}
public static void AddTask(TaskWork taskWork)
{
using (var _context = new DbGantChartContext())
{
TaskWork taskWork1 = new TaskWork();
foreach (User user in taskWork.Users)
{
var userdb = (from u in _context.Users.Include(u => u.Tasks)
where u.UserName == user.UserName
select u).Single();
userdb.Tasks.Add(taskWork);
}
taskWork.Users.Clear();
_context.TaskWorks.Add(taskWork);
_context.SaveChanges();
}
}
