public async Task <IActionResult> OnPostAsync(string returnUrl = null)
{
returnUrl = returnUrl ?? Url.Content("~/");
if (ModelState.IsValid)
{
var user = new IdentityUser {
UserName = Input.Email, Email = Input.Email
};
var result = await _userManager.CreateAsync(user, Input.Password);
if (result.Succeeded)
{
_logger.LogInformation("User created a new account with password.");
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
var callbackUrl = Url.Page(
"/Account/ConfirmEmail",
pageHandler: null,
values: new { userId = user.Id, code = code },
protocol: Request.Scheme);
await _emailSender.SendEmailAsync(Input.Email, "Confirm your email",
$"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>.");
#region tenant
var _contest = new DAL.Models.ProjectCoreContext();
_contest.Tenants.Add(new DAL.Models.Tenants
{
Name = Input.Organization,
CreatedAt = DateTime.Now,
Plan = Input.Plan
});
_contest.SaveChanges();
var aspNetUser = _contest.AspNetUsers.Where(x => x.UserName.Equals(Input.Email)).FirstOrDefault();
aspNetUser.TenantId = _contest.Tenants.Max(x => x.Id);
_contest.SaveChanges();
await _userManager.AddToRoleAsync(user, "Admin");
#endregion
// await _signInManager.SignInAsync(user, isPersistent: false);
return(LocalRedirect(returnUrl));
}
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
// If we got this far, something failed, redisplay form
return(Page());
}
/// <summary>
/// UPDATE PROJECT
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="details"></param>
/// <param name="expectedCompletionDate"></param>
public void UpdateProjects(int id,
string title,
string details,
DateTime?expectedCompletionDate)
{
DAL.Models.ProjectCoreContext _context = new 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 = expectedCompletionDate;
projectEF.UpdatedAt = DateTime.Now;
//UPDATE Projects
//SET Title = '', Details = '', ExpectedCompletionDate = '', UpdatedAt = '')
//WHERE Id = x
//aplica todos los cambios detectados a nivel de objetos en la bd
_context.SaveChanges();
}
public void CreateTasks(string title,
string details,
DateTime?expirationDate,
bool?isComplete,
int?effort,
int?remainingWork,
int?stateId,
int?activityId,
int?priorityId,
int?projectId)
{
DAL.Models.ProjectCoreContext _contex = new DAL.Models.ProjectCoreContext();
_contex.Tasks.Add(new DAL.Models.Tasks
{
Title = title,
Details = details,
ExpirationDate = expirationDate,
IsCompleted = isComplete,
Effort = effort,
RemainingWork = remainingWork,
StateId = stateId,
ActivityId = activityId,
PriorityId = priorityId,
ProjectId = projectId
});
_contex.SaveChanges();
}
public void DeleteProject(int id)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var proje = _context.Projects.Where(x => x.Id == id).FirstOrDefault();
_context.Projects.Remove(proje);
_context.SaveChanges();
}
public List <Models.BD.Tasks> GetTask(int?projectId, int?id)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
//Linq
var listTasks = (from _tasks in _context.Tasks
join _states in _context.States on _tasks.StateId equals _states.Id
join _activities in _context.Activities on _tasks.ActivityId equals _activities.Id
join _priorities in _context.Priorities on _tasks.PriorityId equals _priorities.Id
// where _tasks.Active == true
select new Models.BD.Tasks
{
Id = _tasks.Id,
Title = _tasks.Title,
Details = _tasks.Details,
ExpirationDate = _tasks.ExpirationDate,
IsCompleted = _tasks.IsCompleted,
Effort = _tasks.Effort,
RemainingWork = _tasks.RemainingWork,
StateId = _tasks.StateId,
States = new Models.BD.States
{
Name = _states.Name
},
PriorityId = _tasks.PriorityId,
Priorities = new Models.BD.Priorities
{
Name = _priorities.Name
},
ActivityId = _tasks.ActivityId,
Activities = new Models.BD.Activities
{
Name = _activities.Name
},
ProjectId = _tasks.ProjectId
}).ToList();
if (projectId != null)
{
listTasks = listTasks.Where(x => x.ProjectId == projectId).ToList();
}
if (id != null)
{
listTasks = listTasks.Where(x => x.Id == id).ToList();
}
return(listTasks);
}
public void UpdateProject(int id, string title, string details, DateTime expectedCompletionDate)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var proje = _context.Projects.Where(x => x.Id == id).FirstOrDefault();
proje.Title = title;
proje.Details = details;
proje.ExpectedCompletionDate = expectedCompletionDate;
proje.UpdatedAt = DateTime.Now;
_context.SaveChanges();
}
public void CreatedProjects(string title, string details, DateTime?expetedCompletionDate, int?tenantId)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
_context.Projects.Add(new DAL.Models.Projects
{
Title = title,
Details = details,
ExpectedCompletionDate = expetedCompletionDate,
TenantId = tenantId,
CreatedAt = DateTime.Now
});
_context.SaveChangesAsync();
}
public void DeleteProjects(int?id)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
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);
_context.SaveChangesAsync();
}
public List <Models.DB.Priorities> GetPriorities()
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var listPriorities = (from _priorities in _context.Priorities
where _priorities.Active == true
select new Models.DB.Priorities
{
Id = _priorities.Id,
Name = _priorities.Name,
Active = _priorities.Active
}).ToList();
return(listPriorities);
}
public List <Models.DB.Tasks> GetTasks(int?projectId, int?id)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var listTask = (from _task in _context.Tasks
join _states in _context.States on _task.StateId equals _states.Id
join _activities in _context.Activities on _task.ActivityId equals _activities.Id
join _priorities in _context.Priorities on _task.PriorityId equals _priorities.Id
select new Models.DB.Tasks
{
Id = _task.Id,
Title = _task.Title,
Details = _task.Details,
ExpirationDate = _task.ExpirationDate,
IsCompleted = _task.IsCompleted,
Effort = _task.Effort,
RemainingWork = _task.RemainingWork,
StateId = _task.StateId,
State = new Models.DB.States
{
Name = _states.Name,
},
PriorityId = _task.PriorityId,
Priority = new Models.DB.Priorities
{
Name = _priorities.Name
},
ActivityId = _task.ActivityId,
Activity = new Models.DB.Activities
{
Name = _activities.Name
},
ProjectId = _task.ProjectId
}).ToList();
if (projectId != null)
{
listTask = listTask.Where(x => x.ProjectId == projectId).ToList();
}
if (id != null)
{
listTask = listTask.Where(x => x.Id == id).ToList();
}
return(listTask);
}
public List <Models.BD.States> GetStates()
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var listStates = (from _states in _context.States
where _states.Active == true
select new Models.BD.States
{
Id = _states.Id,
Name = _states.Name,
Active = _states.Active
}).ToList();
return(listStates);
}
public void UpdateProjects(int id,
string title,
string details, DateTime?expectedCompletionDate)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var projectEF = _context.Projects.Where(x => x.Id == id).FirstOrDefault();
projectEF.Title = title;
projectEF.Details = details;
projectEF.ExpectedCompletionDate = expectedCompletionDate;
projectEF.UpdatedAt = DateTime.Now;
//aplica todo los cambio en la BD
_context.SaveChanges();
}
public void DeleteProjects(int?id)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
//validamos dependencias de la tabla Projects
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);
//aplica todo los cambio en la BD
_context.SaveChanges();
}
/// <summary>
/// GET TENANTS BY USER
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public List <Models.DB.Tenants> GetTenants(string userId)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var listTenants = (from _tenants in _context.Tenants
join _aspNetUsers in _context.AspNetUsers on _tenants.Id equals _aspNetUsers.TenantId
where _aspNetUsers.Id.Equals(userId)
select new Models.DB.Tenants {
Id = _tenants.Id,
Name = _tenants.Name,
Plan = _tenants.Plan,
CreatedAt = _tenants.CreatedAt,
UpdatedAt = _tenants.UpdatedAt
}).ToList();
return(listTenants);
}
public List <Models.BD.Activities> GetActivities()
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
//Linq
var listActivities = (from _activities in _context.Activities
where _activities.Active == true
select new Models.BD.Activities
{
Id = _activities.Id,
Name = _activities.Name,
Active = _activities.Active
}).ToList();
return(listActivities);
}
public void DeleteProjects(int?id)
//string title,
//string details, DateTime? expectedCompletionDate)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
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);
//aplica todo los cambio en la BD
_context.SaveChanges();
}
public void CreateTask(Logica.Models.BindingModel.TaskCreateBindingModel model)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
_context.Tasks.Add(new DAL.Models.Tasks
{
Title = model.Title,
Details = model.Details,
ExpirationDate = model.ExpirationDate,
IsCompleted = model.IsCompleted,
Effort = model.Effort,
RemainingWork = model.RemainingWork,
StateId = model.StateId,
ActivityId = model.ActivityId,
ProjectId = model.ProjectId,
PriorityId = model.PriorityId
});
_context.SaveChanges();
}
/// <summary>
/// DELETE PROJECTS
/// </summary>
/// <param name="id"></param>
public void DeleteProjects(int?id)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
//validamos dependencias de la tabla projects
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);
//DELETE FROM Projects
//WHERE Id = X
//aplica todos los cambios detectados a nivel de objetos en la bd
_context.SaveChanges();
}
public List <Models.DB.Projects> GetProjects(int?id,
int?tenantId,
string userId = null)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
var listProjectsEF = (from _projects in _context.Projects
select _projects).ToList();
if (id != null)
{
listProjectsEF = listProjectsEF.Where(x => x.Id == id).ToList();
}
if (tenantId != null)
{
listProjectsEF = listProjectsEF.Where(x => x.TenantId == tenantId).ToList();
}
if (!string.IsNullOrEmpty(userId))
{
listProjectsEF = (from _projects in listProjectsEF
join _userProjects in _context.UserProjects on _projects.Id equals _userProjects.ProjectId
where _userProjects.UserId.Equals(userId)
select _projects).ToList();
}
var listProjects = (from _projects in listProjectsEF
select new Models.DB.Projects
{
Id = _projects.Id,
Title = _projects.Title,
Details = _projects.Details,
ExpectedCompletionDate = _projects.ExpectedCompletionDate,
TenantId = _projects.TenantId,
CreatedAt = _projects.CreatedAt,
UpdatedAt = _projects.UpdatedAt
}).ToList();
return(listProjects);
}
/// <summary>
/// CREATE PROJECTS
/// </summary>
/// <param name="title"></param>
/// <param name="details"></param>
/// <param name="expectedCompletionDate"></param>
/// <param name="tenantId"></param>
public void CreateProjects(string title,
string details,
DateTime?expectedCompletionDate,
int?tenantId)
{
DAL.Models.ProjectCoreContext _context = new DAL.Models.ProjectCoreContext();
_context.Projects.Add(new DAL.Models.Projects
{
Title = title,
Details = details,
ExpectedCompletionDate = expectedCompletionDate,
TenantId = tenantId,
CreatedAt = DateTime.Now
});
//INSERT INTO Projects(Title, Details, ExpectedCompletionDate, TenantId, CreatedAt)
//VALUES('','','YYYY-MM-DD', 1, 'YYYY-MM-DD')
//aplica todos los cambios detectados a nivel de objetos en la bd
_context.SaveChanges();
}
