public async Task <IActionResult> AssignModuleToUser(int UserID, int ModuleID) { var role = from modules in _context.Modules where modules.ModuleID == ModuleID select modules; var user = from users in _context.Users where users.UserID == UserID select users; var userDisplay = from users in _context.ModuleUsers where users.ModuleID == ModuleID select users.User; ModuleUser userModule = new ModuleUser();//UserID, _context.Users.Find(UserID), ModuleID, _context.Modules.Find(ModuleID)); userModule.UserID = UserID; userModule.User = _context.Users.Find(UserID); userModule.ModuleID = ModuleID; userModule.Module = _context.Modules.Find(ModuleID); _context.Entry(userModule).State = EntityState.Added; //TODO catch exception from them already demoing for the module if (ModelState.IsValid) { _context.ModuleUsers.Add(userModule); await _context.SaveChangesAsync(); //TODO query to find correct users return(View("UserDetails", _context.Users.Find(UserID))); } return(View("UserDetails", _context.Users.Find(UserID))); }
/// <summary> /// For inserting user modules in database. /// </summary> /// <param name="objLocationEmailContact"></param> /// <returns></returns> public bool AddUserModule(ModuleList objModuleUser) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool IsSuccessfull = false; using (PortalDbEntities portalEntities = new PortalDbEntities()) { ModuleUser usermodule = new ModuleUser(); usermodule.userId = objModuleUser.UserID; usermodule.moduleId = objModuleUser.ModuleID; portalEntities.ModuleUsers.Add(usermodule); /// Insert the Record in Respected Table. portalEntities.SaveChanges(); /// Check the Chenges in Table After Record Insertion. IsSuccessfull = true; } return(IsSuccessfull); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
public async Task <IActionResult> ConfirmProposal(int UserID, int ModuleID) { var proposal = from proposals in _context.Proposal where proposals.UserID == UserID && proposals.ModuleID == ModuleID select proposals; Proposal tmpProposal = proposal.Single(); tmpProposal.Approved = true; User tmpUser = _context.Users.Find(tmpProposal.UserID); Module tmpModule = _context.Modules.Find(tmpProposal.ModuleID); ModuleUser moduleUser = new ModuleUser(UserID, tmpUser, ModuleID, tmpModule); var userDisplay = from users in _context.ModuleUsers where users.ModuleID == ModuleID select users.User; //TODO catch exception from them already demoing for the module if (ModelState.IsValid) { _context.ModuleUsers.Add(moduleUser); await _context.SaveChangesAsync(); return(View("ModuleDemonstrators", Tuple.Create(tmpModule, userDisplay.ToList()))); } return(View("ModuleDemonstrators", Tuple.Create(tmpModule, userDisplay.ToList()))); }
public static void AddUser(string connectionId, ModuleUser currentUser, int userId) { LoggedInUsers user = new LoggedInUsers(); user.ConnectionId = connectionId; user.UserId = userId; user.User = currentUser; onLineUserList.Add(user); }
public async Task <IActionResult> LogHoursFinal(int UserID, int ModuleID, double hoursWorked, double hoursAllocated) { ModuleUser moduleUser = _context.ModuleUsers.Find(ModuleID, UserID); moduleUser.HoursWorked = moduleUser.HoursWorked + hoursWorked; _context.Entry(moduleUser).State = EntityState.Added; //TODO catch exception from them already demoing for the module if (ModelState.IsValid) { _context.ModuleUsers.Update(moduleUser); await _context.SaveChangesAsync(); //Redirects to the "Users" action of the controller "User" return(RedirectToAction("Users", "User")); } return(RedirectToAction("Users", "User")); }
public IActionResult LogHoursModuleSelect(int UserID, int ModuleID) { var moduleUsers = from mU in _context.ModuleUsers where (mU.ModuleID == ModuleID) && (mU.UserID == UserID) select mU; ModuleUser moduleUser = new ModuleUser(); moduleUser.Module = _context.Modules.Find(ModuleID); moduleUser.ModuleID = ModuleID; moduleUser.User = _context.Users.Find(UserID); moduleUser.UserID = UserID; foreach (var item in moduleUsers) { if (item.ModuleID == ModuleID && item.UserID == UserID) { moduleUser.HoursAllocated = item.HoursAllocated; moduleUser.HoursWorked = item.HoursWorked; } } return(View("LogHoursFinal", moduleUser)); }
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) { await _userManager.AddToRoleAsync(user, "Student"); _logger.LogInformation("User created a new account with password."); //await _emailSender.SendEmailAsync(Input.Email, "", ""); var registeredUser = await _userManager.FindByEmailAsync(Input.Email); ModuleUser newUser = new ModuleUser(); newUser.FirstName = Input.FirstName; newUser.LastName = Input.LastName; newUser.AspNetUserId = registeredUser.Id; newUser.Email = Input.Email; _context.ModuleUser.AddRange(newUser); await _context.SaveChangesAsync(); 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()); }
public void Setup() { function = new ModuleUser(new AuctionDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <AuctionDBContext> ())); list = null; }
public UserController(AuctionDBContext context) { this._context = context; userfunction = new ModuleUser(this._context); this.errorResquest = new ErrorResquest(); }
public static void Initialize(AllocationContext context) { context.Database.EnsureCreated(); if (context.Users.Any()) { return; } var users = new User[] { new User { FirstName = "Carson", LastName = "Alexander" }, new User { FirstName = "Meredith", LastName = "Alonso" }, new User { FirstName = "Arturo", LastName = "Anand" }, new User { FirstName = "Gytis", LastName = "Barzdukas" }, new User { FirstName = "Peggy", LastName = "Justice" }, new User { FirstName = "Laura", LastName = "Norman" }, new User { FirstName = "Nino", LastName = "Olivetto" }, /*new Student{FirstMidName="Meredith",LastName="Alonso",EnrollmentDate=DateTime.Parse("2002-09-01")}, * new Student{FirstMidName="Arturo",LastName="Anand",EnrollmentDate=DateTime.Parse("2003-09-01")}, * new Student{FirstMidName="Gytis",LastName="Barzdukas",EnrollmentDate=DateTime.Parse("2002-09-01")}, * new Student{FirstMidName="Yan",LastName="Li",EnrollmentDate=DateTime.Parse("2002-09-01")}, * new Student{FirstMidName="Peggy",LastName="Justice",EnrollmentDate=DateTime.Parse("2001-09-01")}, * new Student{FirstMidName="Laura",LastName="Norman",EnrollmentDate=DateTime.Parse("2003-09-01")}, * new Student{FirstMidName="Nino",LastName="Olivetto",EnrollmentDate=DateTime.Parse("2005-09-01")}*/ }; foreach (User u in users) { context.Users.Add(u); } context.SaveChanges(); var Modules = new Module[] { new Module { ModuleID = 1050, Name = "Chemistry" }, new Module { ModuleID = 4022, Name = "Microeconomics" }, new Module { ModuleID = 4041, Name = "Macroeconomics" }, new Module { ModuleID = 1045, Name = "Calculus" }, new Module { ModuleID = 3141, Name = "Trigonometry" }, new Module { ModuleID = 2021, Name = "Composition" }, new Module { ModuleID = 2042, Name = "Literature" } }; foreach (Module c in Modules) { context.Modules.Add(c); } context.SaveChanges(); var Moduleusers = new ModuleUser[] { new ModuleUser { UserID = 1, ModuleID = 4022 }, new ModuleUser { UserID = 1, ModuleID = 4041 }, new ModuleUser { UserID = 2, ModuleID = 1045 }, new ModuleUser { UserID = 2, ModuleID = 3141 }, new ModuleUser { UserID = 2, ModuleID = 2021 }, new ModuleUser { UserID = 3, ModuleID = 1050 }, new ModuleUser { UserID = 4, ModuleID = 1050 }, new ModuleUser { UserID = 4, ModuleID = 4022 }, new ModuleUser { UserID = 5, ModuleID = 4041 }, new ModuleUser { UserID = 6, ModuleID = 1045 }, new ModuleUser { UserID = 7, ModuleID = 3141 }, }; ModuleUser ModuleUser = new ModuleUser(); ModuleUser.UserID = 1; ModuleUser.ModuleID = 1050; context.ModuleUsers.Add(ModuleUser); foreach (ModuleUser c in Moduleusers) { context.ModuleUsers.Add(c); } context.SaveChanges(); var skills = new Skill[] { new Skill(1, "Java"), new Skill(2, "C"), new Skill(3, "C++"), new Skill(4, "ARM Assembly"), new Skill(5, "Go"), }; foreach (Skill c in skills) { context.Skills.Add(c); } context.SaveChanges(); }