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