/// <summary>
/// This method is called to get all the applicants data.
/// </summary>
/// <returns>List of Applicant data.</returns>
public IEnumerable <ApplicantDetails> GetApplicantDetails()
{
var applist = _context.Database.ExecuteSqlRaw("exec ApplicantViewAll _ID");
using (MySqlConnection sqlCon = new MySqlConnection(ConnectionString))
{
sqlCon.Open();
MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter("ApplicantViewAll", sqlCon);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
List <ApplicantDetails> applicantsList = new List <ApplicantDetails>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
ApplicantDetails applicantDetails = new ApplicantDetails();
applicantDetails.ID = Convert.ToInt32(dataTable.Rows[i]["ID"]);
applicantDetails.Name = dataTable.Rows[i]["Name"].ToString();
applicantDetails.FamilyName = dataTable.Rows[i]["FamilyName"].ToString();
applicantDetails.Address = dataTable.Rows[i]["Address"].ToString();
applicantDetails.EmailAddress = dataTable.Rows[i]["EmailAddress"].ToString();
applicantDetails.CountryOfOrigin = dataTable.Rows[i]["CountryOfOrigin"].ToString();
applicantDetails.Age = Convert.ToInt32(dataTable.Rows[i]["Age"].ToString());
applicantDetails.Hired = Convert.ToBoolean(dataTable.Rows[i]["Hired"]);
applicantsList.Add(applicantDetails);
}
return(applicantsList.ToList());
}
//return _context.Applicant.ToList();
}
/// <summary>
/// This method is called to get the data of a specific record.
/// </summary>
/// <param name="id"></param>
/// <param name="applicantDetails"></param>
/// <returns>Return applicant data according to the id received.</returns>
public bool TryGetApplicant(int id, out ApplicantDetails applicantDetails)
{
using (MySqlConnection sqlCon = new MySqlConnection(ConnectionString))
{
sqlCon.Open();
MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter("ApplicantViewByID", sqlCon);
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("_ID", id);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
ApplicantDetails applicant = new ApplicantDetails();
applicant.ID = Convert.ToInt32(dataTable.Rows[0]["ID"]);
applicant.Name = dataTable.Rows[0]["Name"].ToString();
applicant.FamilyName = dataTable.Rows[0]["FamilyName"].ToString();
applicant.Address = dataTable.Rows[0]["Address"].ToString();
applicant.EmailAddress = dataTable.Rows[0]["EmailAddress"].ToString();
applicant.CountryOfOrigin = dataTable.Rows[0]["CountryOfOrigin"].ToString();
applicant.Age = Convert.ToInt32(dataTable.Rows[0]["Age"].ToString());
applicant.Hired = Convert.ToBoolean(dataTable.Rows[0]["Hired"]);
applicantDetails = applicant;
return(applicantDetails != null);
}
//applicantDetails = _context.Applicant.Find(id);
//return (applicantDetails != null);
}
private ActionResult ApplicantDetails_Render(string formId, ApplicantDetails details)
{
return(NavigableView <ApplicantDetailsModel>(formId, Sections.ApplicantDetails, (m, f) =>
{
m.ApplicantDetails = details ?? f.ApplicantDetails;
}));
}
public Task <ApplicantDetails> LoadApplicantDetails(ApplicantDetails entity)
{
return(DbContext.ApplicantDetails
.Where(x => x.LastName.ToLower() == entity.LastName.ToLower())
.Where(x => x.DateOfBirth.Date == entity.DateOfBirth.Date)
.FirstOrDefaultAsync(x => x.FirstName.ToLower() == entity.FirstName.ToLower()));
}
public static ApplicantDetails NewValid(Action <ApplicantDetails> mutator = null)
{
var value = new ApplicantDetails
{
Title = "test title",
FirstName = "test first name",
OtherNames = "test other names",
SurnameOrFamilyName = "test surname or family name",
DateOfBirth = DomainRegistry.NowUtc().Date.AddYears(-19),
PreviouslyLookedAfter = false,
FullTimeEducation = false,
NationalInsuranceNumber = "AB123456C",
CurrentAddress = AddressBuilder.NewValid("applicant"),
EmailAddress = "*****@*****.**",
PhoneNumer = "01234 567 890",
MobilePhoneNumber = "12345 678 901",
};
if (mutator != null)
{
mutator(value);
}
return(value);
}
public void SubmitShouldUpdateUserDetailsWhenExistingUser()
{
var mockRepo = new Mock <IApplicantDetailsRepository>();
var loadResult = new ApplicantDetails
{
Id = 1,
FirstName = "test",
AnnualIncome = 20000
};
loadResult.Initialize();
mockRepo.Setup(x => x.LoadApplicantDetails(It.IsAny <ApplicantDetails>())).ReturnsAsync(loadResult);
var controller = new SearchController(mockRepo.Object, new CardsRepository());
var newApplicant = new ApplicantDetails
{
FirstName = "test",
DateOfBirth = new DateTime(2002, 01, 10),
AnnualIncome = 40000
};
var result = controller.Create(newApplicant);
Assert.IsInstanceOf <RedirectToActionResult>(result.Result);
Assert.AreEqual(loadResult.GuId, ((RedirectToActionResult)result.Result).RouteValues["guid"]);
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created For : To get applicant details by Applicant id
/// Created Date : 03-04-2020
/// </summary>
/// <param name="ApplicantId"></param>
/// <returns></returns>
public ApplicantDetails GetApplicantDetails(long ApplicantId)
{
var ApplicantDetails = new ApplicantDetails();
try
{
if (ApplicantId > 0)
{
ApplicantDetails = Context.spGetApplicantAllDetails(ApplicantId).
Select(x => new ApplicantDetails()
{
ApplicantName = x.API_FirstName + " " + x.API_LastName,
JobTitle = x.JBT_JobTitle,
LocationName = x.LocationName,
}).FirstOrDefault();
}
else
{
return(null);
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public ApplicantDetails GetApplicantDetails(long ApplicantId)", "Exception while getting the details of applicant", ApplicantId);
throw;
}
return(ApplicantDetails);
}
public async Task <IActionResult> EditAsync(int id, ApplicantDetails applicantDetails)
{
logger.LogInformation($"Applicant with ID: {id} Updated.");
await _repository.PutApplicantDetails(id, applicantDetails);
return(Ok());
}
public async Task <IActionResult> CreateAsync([FromBody] ApplicantDetails applicantDetails)
{
Boolean valid = false;
var country = await RESTCountriesAPI.GetCountryByFullNameAsync(applicantDetails.CountryOfOrigin);
logger.LogInformation(country.Name);
if (country.Name.ToUpper() == applicantDetails.CountryOfOrigin.ToUpper())
{
valid = true;
}
if (valid)
{
logger.LogInformation("New applicant is added.");
await _repository.AddApplicantDetailsAsync(applicantDetails);
logger.LogInformation(nameof(GetById), new { id = applicantDetails.ID }, applicantDetails);
return(CreatedAtAction(nameof(GetById), new { id = applicantDetails.ID }, applicantDetails));
}
else
{
logger.LogInformation($"{applicantDetails.CountryOfOrigin} is not a valid country");
return(BadRequest());
}
}
public async Task <IActionResult> Create([Bind("FirstName,LastName,DateOfBirth,AnnualIncome")] ApplicantDetails applicantDetails)
{
if (ModelState.IsValid)
{
var existingApplicantDetails = await ApplicantDetailsRepository.LoadApplicantDetails(applicantDetails);
if (existingApplicantDetails == null)
{
applicantDetails.Initialize();
await ApplicantDetailsRepository.Create(applicantDetails);
}
else
{
existingApplicantDetails.AnnualIncome = applicantDetails.AnnualIncome;
await ApplicantDetailsRepository.Update(existingApplicantDetails);
}
var guid = applicantDetails.GuId;
if (existingApplicantDetails != null)
{
guid = existingApplicantDetails.GuId;
}
return(RedirectToAction(nameof(Selection), new { guid }));
}
return(View(applicantDetails));
}
/// <summary>
/// This method is called whenever there is a post request to add data.
/// </summary>
/// <param name="applicantDetails"></param>
public async Task <int> AddApplicantDetailsAsync(ApplicantDetails applicantDetails)
{
using (MySqlConnection sqlCon = new MySqlConnection(ConnectionString))
{
sqlCon.Open();
MySqlCommand SqlCommand = new MySqlCommand("ApplicantAddorEdit", sqlCon);
SqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlCommand.Parameters.AddWithValue("_ID", applicantDetails.ID);
SqlCommand.Parameters.AddWithValue("_Name", applicantDetails.Name);
SqlCommand.Parameters.AddWithValue("_FamilyName", applicantDetails.FamilyName);
SqlCommand.Parameters.AddWithValue("_Address", applicantDetails.Address);
SqlCommand.Parameters.AddWithValue("_CountryOfOrigin", applicantDetails.CountryOfOrigin);
SqlCommand.Parameters.AddWithValue("_EmailAddress", applicantDetails.EmailAddress);
SqlCommand.Parameters.AddWithValue("_Age", applicantDetails.Age);
SqlCommand.Parameters.AddWithValue("_Hired", Convert.ToBoolean(applicantDetails.Hired));
return(await SqlCommand.ExecuteNonQueryAsync());
}
// int rowsAffected = 0;
//_context.Applicant.Add(applicantDetails);
//rowsAffected = await _context.SaveChangesAsync();
//return rowsAffected;
}
public NextSection AddApplicantDetails(ApplicantDetails applicantDetails)
{
Validate(applicantDetails);
ApplicantDetails = applicantDetails;
return(OnSectionCompleted(Sections.ApplicantDetails));
}
public ActionResult DeleteConfirmed(byte id)
{
ApplicantDetails applicantDetails = _context.ApplicantDetails.Find(id);
_context.ApplicantDetails.Remove(applicantDetails);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
public NextSection AddApplicantDetails(ApplicantDetails applicantDetails)
{
Validate(applicantDetails);
ApplicantDetails = applicantDetails;
OnUserIdentified(applicantDetails.EmailAddress);
return(OnSectionCompleted(Sections.ApplicantDetails));
}
private static void Validate(ApplicantDetails applicantDetails)
{
var ctx = new ValidationContext <ApplicantDetails>(applicantDetails);
ctx.Required(m => m.FullName, "Please supply a Full name");
ctx.Required(m => m.Address.Line1, "Please supply an Address line 1");
ctx.Required(m => m.Address.Postcode, "Please supply a Postcode");
ctx.ThrowIfError();
}
public static bool ShouldAskForNationalInsuranceNumber(ApplicantDetails applicantDetails)
{
var age = applicantDetails.Age();
if (age < 16)
{
return(false);
}
return(true);
}
public static bool ShouldAskEducationQuestion(ApplicantDetails applicantDetails)
{
var age = applicantDetails.Age();
if (!age.HasValue)
{
return(false);
}
return(age == 18 || age == 19);
}
public static bool ShouldAskCareQuestion(ApplicantDetails applicantDetails)
{
var age = applicantDetails.Age();
if (!age.HasValue)
{
return(false);
}
return(age >= 18 && age < 25);
}
public ActionResult Edit([Bind(Include = "ApplicantDetailsId,PhoneNumber,Age,Bio,Experience,Education,Projects,Languages")] ApplicantDetails applicantDetails)
{
if (ModelState.IsValid)
{
_context.Entry(applicantDetails).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ApplicantDetailsId = new SelectList(_context.Applicants, "ApplicantId", "FirstName", applicantDetails.ApplicantDetailsId);
return(View(applicantDetails));
}
public ActionResult ApplicantDetails(string id, ApplicantDetails applicantDetails)
{
var cmd = new AddApplicantDetails
{
FormId = id,
ApplicantDetails = applicantDetails,
};
return(Exec(cmd,
success: next => RedirectNext(next),
failure: () => ApplicantDetails_Render(id, applicantDetails)));
}
public ActionResult Ajax_DobChanged(ApplicantDetails applicantDetails)
{
var config = Exec(new FindApplicantDetailsConfig {
ApplicantDetails = applicantDetails
});
return(AjaxActions(new[]
{
AjaxAction.ShowHideFormGroup <ApplicantDetails>(m => m.PreviouslyLookedAfter, config.ShouldAskCareQuestion),
AjaxAction.ShowHideFormGroup <ApplicantDetails>(m => m.FullTimeEducation, config.ShouldAskEducationQuestion),
AjaxAction.ShowHideFormGroup <ApplicantDetails>(m => m.NationalInsuranceNumber, config.ShouldAskForNationalInsuranceNumber),
}));
}
public async Task <ActionResult> ApplicantDetail(int id)
{
var result = new ApplicantDetails();
if (User.Identity.IsAuthenticated)
{
result = await _context.ApplicantDetails.Include(o => o.Vehicle).ThenInclude(o => o.VehicleImages).Include(o => o.Vehicle)
.ThenInclude(o => o.VehicleTypes).Include(o => o.Vehicle).ThenInclude(o => o.VehicleRatings)
.Include(o => o.User).Include(o => o.ApplicantsFinancedEquipments).Include(o => o.ApplicantVehicles).ThenInclude(o => o.VehicleTypes)
.Include(o => o.ApplicantsCreditReferences).Include(o => o.ApplicantsGuarantors)
.Include(o => o.ApplicantsInsurances).Where(o => o.Id == id).FirstOrDefaultAsync();
}
return(View(result));
}
// GET: ApplicantDetails/Details/5
public ActionResult Details(byte?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ApplicantDetails applicantDetails = _context.ApplicantDetails.Find(id);
if (applicantDetails == null)
{
return(HttpNotFound());
}
return(View(applicantDetails));
}
public IActionResult SaveApplicantDetails(ApplicantDetails applicant)
{
var adminId = HttpContext.Session.GetInt32("Id");
if (adminId.HasValue)
{
_context.Entry(applicant).State = applicant.Id > 0 ? EntityState.Modified : EntityState.Added;
_context.SaveChanges();
return(RedirectToAction("ApplicantDetails"));
}
else
{
return(RedirectToAction("LogIn", "Admin"));
}
}
public ActionResult Edit(byte?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ApplicantDetails applicantDetails = _context.ApplicantDetails.Find(id);
if (applicantDetails == null)
{
return(HttpNotFound());
}
ViewBag.ApplicantDetailsId = new SelectList(_context.Applicants, "ApplicantId", "FirstName", applicantDetails.ApplicantDetailsId);
return(View(applicantDetails));
}
public void SubmitShouldCreateUserDetails()
{
var mockRepo = new Mock <IApplicantDetailsRepository>();
mockRepo.Setup(x => x.LoadApplicantDetails(It.IsAny <ApplicantDetails>())).ReturnsAsync((ApplicantDetails)null);
var controller = new SearchController(mockRepo.Object, new CardsRepository());
var newApplicant = new ApplicantDetails
{
FirstName = "test"
};
var result = controller.Create(newApplicant);
Assert.IsInstanceOf <RedirectToActionResult>(result.Result);
}
public async Task <ActionResult> SignUp(ApplicantSignUpViewModel model)
{
if (ModelState.IsValid)
{
ApplicantDetails user = new ApplicantDetails
{
UserName = model.Email,
Firstname = model.FirstName,
Lastname = model.LastName,
Email = model.Email,
//Password = model.Password,
PhoneNumber = model.Mobile
};
var result = await _userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
//ReviewerDetails r = new ReviewerDetails
//{
// Age = model.Age,
// UserId = user.Id,
// Name = model.Name
//};
//_context.Add(r);
//await _context.SaveChangesAsync();
await _signinManager.SignInAsync(user, isPersistent : false);
return(RedirectToAction("LogIn", "ApplicantDetails"));
}
// If there are any errors, add them to the ModelState object
// which will be displayed by the validation summary tag helper
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
else
{
return(View("Index"));
}
//return RedirectToAction("", "RecruiterDetails");
return(View(model));
}
public ActionResult AddApplicant(int?id)
{
var adminId = HttpContext.Session.GetInt32("Id");
if (adminId.HasValue)
{
var applicant = new ApplicantDetails();
if (id.HasValue)
{
applicant = _context.ApplicantDetails.FirstOrDefault(o => o.Id == id);
}
return(View(applicant));
}
else
{
return(RedirectToAction("LogIn", "Admin"));
}
}
public NextSection AddIdentity(string userId)
{
ValidateIdentity(userId);
var existingForm = new FindLatestApplication {
UserId = userId
}.Find();
if (existingForm == null)
{
throw new DomainException("Could not find any existing application for the supplied email");
}
UserId = userId;
var fullName = new StringBuilder();
fullName.Append(existingForm.ApplicantDetails.FirstName);
if (!string.IsNullOrEmpty(existingForm.ApplicantDetails.OtherNames))
{
fullName.AppendFormat(" {0}", existingForm.ApplicantDetails.OtherNames);
}
fullName.AppendFormat(" {0}", existingForm.ApplicantDetails.SurnameOrFamilyName);
ExistingApplicantDetails = new ApplicantDetails
{
Title = existingForm.ApplicantDetails.Title,
FullName = fullName.ToString(),
Address = existingForm.ApplicantDetails.CurrentAddress,
MobilePhoneNumber = existingForm.ApplicantDetails.MobilePhoneNumber,
HomePhoneNumer = existingForm.ApplicantDetails.PhoneNumer,
EmailAddress = existingForm.ApplicantDetails.EmailAddress,
Age = existingForm.ApplicantDetails.Age(),
};
ExistingPaymentDetails = new PaymentDetails
{
HasBankAccount = existingForm.PaymentDetails.HasBankAccount,
};
return(OnSectionCompleted(Sections.Identity));
}
public ActionResult ApplicantDetails(string id, ApplicantDetails applicantDetails)
{
// Retrieve the formid (session identifier) that we saved prior to leaving BSG and entering GOV.UKVerify site
if (Request.Cookies["formId"] != null && id == null)
{
System.Web.HttpCookie aCookie = Request.Cookies["formId"];
id = aCookie.Value;
}
var cmd = new AddApplicantDetails
{
FormId = id,
ApplicantDetails = applicantDetails,
};
return(Exec(cmd,
success: next => RedirectNext(next),
failure: () => ApplicantDetails_Render(id, applicantDetails)));
}