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