/// <summary> /// CREATE PROJECTS /// </summary> /// <param name="title"></param> /// <param name="details"></param> /// <param name="expectedCompletationDate"></param> /// <param name="tenantId"></param> public void CreateProjects(string title, string details, DateTime?expectedCompletationDate, int?tenantId) { ProjectCore.DAL.Models.ProjectCoreContext _context = new ProjectCore.DAL.Models.ProjectCoreContext(); _context.Projects.Add(new ProjectCore.DAL.Models.Projects { Title = title, Details = details, ExpectedCompletionDate = expectedCompletationDate, TenantId = tenantId, CreatedAt = DateTime.Now }); _context.SaveChanges(); }
/// <summary> /// update project /// </summary> /// <param name="id"></param> /// <param name="title"></param> /// <param name="details"></param> /// <param name="expectedCompletationDate"></param> public void UpdateProjects(int id, string title, string details, DateTime?expectedCompletationDate) { ProjectCore.DAL.Models.ProjectCoreContext _context = new ProjectCore.DAL.Models.ProjectCoreContext(); var projectEF = _context.Projects.Where(x => x.Id == id).FirstOrDefault(); //(from _projects in _context.Projects // where _projects.Id == id // select _projects).FirstOrDefault(); projectEF.Title = title; projectEF.Details = details; projectEF.ExpectedCompletionDate = expectedCompletationDate; projectEF.UpdatedAt = DateTime.Now; _context.SaveChanges(); }
/// <summary> /// update project /// </summary> /// <param name="id"></param> /// <param name="title"></param> /// <param name="details"></param> /// <param name="expectedCompletationDate"></param> public void DeleteProjects(int?id) { ProjectCore.DAL.Models.ProjectCoreContext _context = new ProjectCore.DAL.Models.ProjectCoreContext(); //validamos dependencias de la tabla proyectos if (_context.Artifacts.Any(x => x.ProjectId == id) || _context.UserProjects.Any(x => x.ProjectId == id)) { return; } var projectEF = _context.Projects.Where(x => x.Id == id).FirstOrDefault(); _context.Projects.Remove(projectEF); //(from _projects in _context.Projects // where _projects.Id == id // select _projects).FirstOrDefault(); _context.SaveChanges(); }