public IActionResult Index(TimeLogViewModel vm) { if (ModelState.IsValid) { // Get the maximum PK in Log int maxLogId = 0; if (_context.Log.Any()) { maxLogId = _context.Log.Max(t => t.LogId); } // Get the maximum PK in UserLog int userLogMaxId = 0; if (_context.UserLog.Any()) { userLogMaxId = _context.UserLog.Max(t => t.UserLogId); } // The date selected by the user (goes in Log) DateTime enteredDate = DateTime.Parse(vm.date); // Write the Log record Log Log = new Log { Date = enteredDate, TimeInId = vm.TimeInID }; _context.Add(Log); _context.SaveChanges(); int tempLogId = 0; tempLogId = (maxLogId + 1); int count = (vm.SelectedIDArray).Count; UserLog[] tempULog = new UserLog[count]; string[] userkeys = new string[count]; userkeys = (vm.SelectedIDArray).ToArray(); for (int i = 0; i < ((vm.SelectedIDArray).Count); i++) { userLogMaxId += 1; tempULog[i] = TimeLogSupport.createUserLogRecord(tempLogId, userkeys[i], userLogMaxId); _context.Add(tempULog[i]); } _context.SaveChanges(); return(RedirectToAction("ShowLog", vm)); } return(View()); }
public async Task <IActionResult> Create([Bind("DepartmentId,DepartmentLeaderId,NumMembers,DepartmentName,DepartmentLead,DeputyId,Deputy")] DepartmentViewModel viewModel) { if (ModelState.IsValid) { Department department = new Department { DepartmentId = viewModel.DepartmentId, DepartmentLeaderId = viewModel.DepartmentLeaderId, NumMembers = viewModel.NumMembers, DepartmentName = viewModel.DepartmentName, DepartmentLead = viewModel.DepartmentLead, DeputyId = viewModel.DeputyId, Deputy = viewModel.Deputy }; _context.Add(department); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["DepartmentLeaderId"] = new SelectList(_context.User, "UserId", "DisplayName", viewModel.DepartmentLeaderId); ViewData["DeputyId"] = new SelectList(_context.User, "UserId", "DisplayName", viewModel.DeputyId); return(View(viewModel)); }
public async Task <IActionResult> Create([Bind("UserId,AccessFailedCount,ConcurrencyStamp,Email,EmailConfirmed,LockoutEnabled,LockoutEnd,NormalizedEmail,NormalizedUserName,PasswordHash,PhoneNumber,PhoneNumberConfirmed,SecurityStamp,TwoFactorEnabled,UserName,Discriminator,DisplayName,DateJoinedDept,DateOfBirth,Surname,FirstName,HomeNumber,WorkNumber,PhysicalAddress,GenderId,Approved,DriverLicence,Street,City,Province,PostalCode")] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["GenderId"] = new SelectList(_context.Gender, "GenderId", "Gname", user.GenderId); return(View(user)); }
public async Task <IActionResult> Create([Bind("LanguageId,Language1,Proficiency,PrimaryLanguage,UserId")] LanguageViewModel viewModel) { if (ModelState.IsValid) { Language language = new Language { Language1 = viewModel.Language1, Proficiency = viewModel.Proficiency, PrimaryLanguage = viewModel.PrimaryLanguage, UserId = _userId }; _context.Add(language); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(viewModel)); }
public async Task <IActionResult> Create([Bind("Name,Surname,RelationshipType,KinId,Email1,PhoneNumber1,WorkNumber1")] NextOfKinViewModel viewModel) { if (ModelState.IsValid) { NextOfKin nextOfKin = new NextOfKin { KinId = viewModel.KinId, UserId = _userId, Name = viewModel.Name, Surname = viewModel.Surname, PhoneNumber = viewModel.PhoneNumber1, WorkNumber = viewModel.WorkNumber1, Email = viewModel.Email1, RelationshipType = viewModel.RelationshipType }; _context.Add(nextOfKin); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(viewModel)); }
public IActionResult AttributeSet(AttributeSetViewModel vm) { /**************************** Code Segment 1 - Entering data into AttributeUserBridge table *****************/ // Count of positive attributes selected int bridgeCount = (vm.PosAttribute).Count; AttributeUserBridge[] attrUserBridge = new AttributeUserBridge[bridgeCount]; int[] attributeIds = new int[bridgeCount]; attributeIds = (vm.PosAttribute).ToArray(); for (int a = 0; a < ((vm.PosAttribute).Count); a++) { attrUserBridge[a] = UserScreeningSupport.createAttributeRecord(_userId, attributeIds[a]); _context.Add(attrUserBridge[a]); } _context.SaveChanges(); /** Code Segment 1 End **/ /*************************** Code Segment 2 - Entering data for NegAttributeUserBridge Table ****************************/ // Count of negative attributes selected int nbridgeCount = (vm.NegAttribute).Count; NegAttributeUserBridge[] negAttriUserBridge = new NegAttributeUserBridge[nbridgeCount]; int[] negAttributeIds = new int[nbridgeCount]; negAttributeIds = (vm.NegAttribute).ToArray(); for (int i = 0; i < ((vm.NegAttribute).Count); i++) { negAttriUserBridge[i] = UserScreeningSupport.createNegAttributeRecord(_userId, negAttributeIds[i]); _context.Add(negAttriUserBridge[i]); } _context.SaveChanges(); /** Code Segment 2 End **/ return(View()); }
public async Task <IActionResult> Create([Bind("ChurchMemberId,FirstName,LastName,DateOfBirth,Day,Month,Year,CellPhone,HomePhone,WorkPhone,Email,DateRegistered,AgeGroupId,RelationshipId,GenderId,Street,City,Province,PostalCode,OccupationId,NumDepInPreSchool,NumDepInPrimary,NumDepInHighSchool,NumDepInTertiary,AnswerToQ1,AnswerToQ2,AnswerToQ3,AnswerToQ4,AnswerToQ5,AnswerToQ6")] ChurchMembersViewModel viewModel) { if (ModelState.IsValid) { if (viewModel.Year == 0) { viewModel.DateOfBirth = viewModel.Day + "/" + viewModel.Month; } else { viewModel.DateOfBirth = viewModel.Day + "/" + viewModel.Month + "/" + viewModel.Year; } viewModel.DateRegistered = DateTime.Now; ChurchMember churchMember = new ChurchMember { ChurchMemberId = viewModel.ChurchMemberId, FirstName = viewModel.FirstName, LastName = viewModel.LastName, DateOfBirth = viewModel.DateOfBirth, Month = viewModel.Month, Year = viewModel.Year, Day = viewModel.Day, CellPhone = viewModel.CellPhone, HomePhone = viewModel.HomePhone, WorkPhone = viewModel.WorkPhone, Email = viewModel.Email, DateRegistered = viewModel.DateRegistered, AgeGroupId = viewModel.AgeGroupId, RelationshipId = viewModel.RelationshipId, GenderId = viewModel.GenderId, Street = viewModel.Street, City = viewModel.City, Province = viewModel.Province, PostalCode = viewModel.PostalCode, OccupationId = viewModel.OccupationId, NumDepInPreSchool = viewModel.NumDepInPreSchool, NumDepInPrimary = viewModel.NumDepInPrimary, NumDepInHighSchool = viewModel.NumDepInHighSchool, NumDepInTertiary = viewModel.NumDepInTertiary, AnswerToQ1 = viewModel.AnswerToQ1, AnswerToQ2 = viewModel.AnswerToQ2, AnswerToQ3 = viewModel.AnswerToQ3, AnswerToQ4 = viewModel.AnswerToQ4, AnswerToQ5 = viewModel.AnswerToQ5, AnswerToQ6 = viewModel.AnswerToQ6, }; _context.Add(churchMember); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["AgeGroupId"] = new SelectList(_context.AgeGroup, "AgroupId", "AgeRange", viewModel.AgeGroupId); ViewData["GenderId"] = new SelectList(_context.Gender, "GenderId", "Gname", viewModel.GenderId); ViewData["OccupationId"] = new SelectList(_context.Occupation, "OccupationId", "Occupation1", viewModel.OccupationId); ViewData["RelationshipId"] = new SelectList(_context.RelationshipStatus, "RelationshipId", "RelationshipCategory", viewModel.RelationshipId); return(View(viewModel)); }