/*
* public static int GetIdNTH(string name)
* {
* using (var _context = new QuanLyProjectEntities())
* {
* var user = (from u in _context.Tasks
* where u.ID == id
* select u).ToList();
* if (user.Count == 1)
* {
* return user[0];
* }
* else
* {
* return null;
* }
* }
* }
*/
public static bool DeleteTask(Models.Task task)
{
using (var _context = new QuanLyProjectEntities())
{
//xoa list
var dbtask = (from u in _context.Tasks
where u.ID == task.ID
select u).SingleOrDefault();
/*
* foreach (var task in dbuser.TaskWorks)
* {
* foreach (var u in task.Resources)
* {
* if (u.ID == user.ID)
* {
* task.Users.Remove(u);
* break;
* }
* }
* }
*/
_context.Tasks.Remove(dbtask);
_context.SaveChanges();
return(true);
}
}
public static bool DeleteProject(Project project)
{
using (var _context = new QuanLyProjectEntities())
{
//xoa list
var dbpro = (from u in _context.Projects
where u.ID == project.ID
select u).SingleOrDefault();
//xoa task
using (var _context2 = new QuanLyProjectEntities())
{
var dbtask = (from u in _context2.Tasks
where u.IDProject == project.ID
select u).ToList();
for (int i = 0; i < dbtask.Count; i++)
{
_context2.Tasks.Remove(dbtask[i]);
}
_context2.SaveChanges();
//return true;
}
_context.Projects.Remove(dbpro);
_context.SaveChanges();
return(true);
}
}
public static bool AddAccount(Account account)
{
using (var _context = new QuanLyProjectEntities())
{
_context.Accounts.AddOrUpdate(account);
_context.SaveChanges();
return(true);
}
}
public static bool AddProject(Project project)
{
using (var _context = new QuanLyProjectEntities())
{
_context.Projects.AddOrUpdate(project);
_context.SaveChanges();
return(true);
}
}
public static bool AddTask(Models.Task tasks)
{
using (var _context = new QuanLyProjectEntities())
{
_context.Tasks.AddOrUpdate(tasks);
_context.SaveChanges();
return(true);
}
}
public static bool CheckAccount(string tk, string mk)
{
using (var _context = new QuanLyProjectEntities())
{
var user = (from u in _context.Accounts
where u.TenDangNhap == tk && u.MatKhau == mk
select u).ToList();
if (user.Count == 1)
{
return(true);
}
return(false);
}
}
public static int GetIDProject()
{
using (var _context = new QuanLyProjectEntities())
{
var id = (from t in _context.Projects
select t.ID).ToList();
if (id.Count <= 0)
{
return(1);
}
else
{
return(id.Max() + 1);
}
}
}
public static bool AddResource(Resource re)
{
try
{
using (var context = new QuanLyProjectEntities())
{
context.Resources.Add(re);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static Project GetProject(int id)
{
using (var _context = new QuanLyProjectEntities())
{
var user = (from u in _context.Projects
where u.ID == id
select u).ToList();
if (user.Count == 1)
{
return(user[0]);
}
else
{
return(null);
}
}
}
public static List <Project> GetListProject()
{
using (var _context = new QuanLyProjectEntities())
{
var project = (from u in _context.Projects.AsEnumerable()
select u)
.Select(x => new Project
{
ID = x.ID,
TenProject = x.TenProject,
NgayBatDau = x.NgayBatDau,
NgayKetThuc = x.NgayKetThuc,
Tasks = x.Tasks
}).ToList();
return(project);
}
}
public static List <Resource> getListResource()
{
using (var _context = new QuanLyProjectEntities())
{
var user = (from u in _context.Resources.AsEnumerable()
select u)
.Select(x => new Resource
{
ID = x.ID,
Ten = x.Ten,
NgaySinh = x.NgaySinh,
VaiTro = x.VaiTro,
SoDienThoai = x.SoDienThoai,
Mail = x.Mail,
}).ToList();
return(user);
}
}
public static List <Models.Task> GetListTask(int idPro)
{
using (var _context = new QuanLyProjectEntities())
{
var task = (from u in _context.Tasks.AsEnumerable()
where u.IDProject == idPro
select u)
.Select(x => new Models.Task
{
ID = x.ID,
IDProject = x.IDProject,
IDResource = x.IDResource,
TenCongViec = x.TenCongViec,
MoTa = x.MoTa,
NgayBatDau = x.NgayBatDau,
NgayKetThuc = x.NgayKetThuc,
}).ToList();
return(task);
}
}
public static bool DeleteResource(Resource user)
{
using (var _context = new QuanLyProjectEntities())
{
//xoa list
var dbuser = (from u in _context.Resources
where u.ID == user.ID
select u).SingleOrDefault();
/*
* foreach (var u in _context.Tasks)
* {
* if (u.IDResource == user.ID)
* {
* u.IDResource = null;
* break;
* }
* }
*/
_context.Resources.Remove(dbuser);
_context.SaveChanges();
return(true);
}
}
