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