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