/* * 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); } }