public ActionResult RegisterCandidate(CandidateRegister candidate)
{
NoBordersDB db = new NoBordersDB();
var checkmail = db.Users.SingleOrDefault(x => x.email == candidate.email);
string message = "";
//check if email is allready created
if (checkmail == null)
{
try
{
if (ModelState.IsValid)
{
//calling stored procedure
CandidateRegisterDL candDL = new CandidateRegisterDL();
candDL.registerCandidate(candidate);
var user = db.CandidateProfiles.Single(x => x.Email == candidate.email);
Session["candidate_id"] = user.Id_candidate;
Session["user_name"] = user.First_name + " " + user.Last_name;
return(RedirectToAction("userProfile", "user"));
}
return(View());
}
catch
{
return(View());
}
}
message = "This address is allready in use,please insert other email.";
ViewBag.Message = message;
return(View());
}
public async Task <IActionResult> Post([FromBody] CandidateRegister model)
{
if (!ModelState.IsValid)
{
return(Ok(GetModelValidationResponse <object>()));
}
try
{
if (HttpContext.User.Identity.IsAuthenticated)
{
model.Id = int.Parse(User.Identity.Name);
}
var result = await candidateService.InsertOrUpdateAsync(model);
return(Ok(GetResponse(result, model.Id > 0 ? System.Net.HttpStatusCode.OK : System.Net.HttpStatusCode.Created)));
}
catch (System.Exception ex)
{
log.Error(ex.Message, ex);
return(Ok(GetExceptionResponse <object>(ex)));
}
}
public override async Task <IEnumerable <Candidate> > GetByFilterAsync(BaseEntityFilter filter, ISorter <Candidate> sorter = null)
{
return(await databaseExecuterService.RunStoredProcedureAsync(GetByFilterProc, (reader) =>
{
var filteredList = new List <Candidate>();
do
{
if (reader.HasRows)
{
var entity = new CandidateRegister();
entity.ParseData(reader);
filteredList.Add(entity);
}
if (sorter != null)
{
filteredList = new List <Candidate>(sorter.Sort(filteredList));
}
} while (reader.Reader.Read()); //we activate the read after as the first one is done in the base DB class
return filteredList;
}, GetEntityProperties(filter)));
}
public void GetCandidateEmails_Of_Register_Should_Call_GetCandidateEmails_Of_Provider()
{
var candidateProvider = new MockCandidateProvider();
var candidateRegister = new CandidateRegister(candidateProvider);
candidateRegister.GetCandidateEmails();
Check.That(candidateProvider.GetEmailsReturn).IsTrue();
}
public void Register_Should_Call_HasAlready()
{
var candidateProvider = new MockCandidateProvider();
var candidateRegister = new CandidateRegister(candidateProvider);
candidateRegister.Register(new Candidate(Email.Of(RegisDuboisEmail)));
Check.That(candidateProvider.HasAlreadyWasCalled).IsTrue();
}
public void Register_Should_Test_How_Many_Time_GetCandidateEmail_From_Provider_Is_Called()
{
var candidateProvider = new SpyCandidateProvider();
var candidateRegister = new CandidateRegister(candidateProvider);
var emailsReceiveFromTheFirstCalled = candidateRegister.GetCandidateEmails();
var emailsReceiveFromTheSecondCalled = candidateRegister.GetCandidateEmails();
Check.That(candidateProvider.GetEmailsCallCount).IsEqualTo(2);
}
public void Register_Should_Test_How_Many_Time_HasAlready_From_Provider_Is_Called()
{
var candidateProvider = new SpyCandidateProvider();
var candidateRegister = new CandidateRegister(candidateProvider);
candidateRegister.Register(new Candidate(Email.Of(RegisDuboisEmail)));
Check.That(candidateProvider.HasAlreadyCallCount).IsEqualTo(1);
}
private static void Init()
{
var candidateProvider = new CandidateProvider();
candidateRegister = new CandidateRegister(candidateProvider);
checkinProvider = new CheckinProvider();
taxiOrganizers = new List <TaxiOrganizer>();
}
public void Register_Should_Not_Call_AddCandidate_When_HasAlready_Return_True()
{
var candidateProvider = new MockCandidateProvider();
candidateProvider.HasAlreadyReturn = true;
var candidateRegister = new CandidateRegister(candidateProvider);
candidateRegister.Register(new Candidate(Email.Of(RegisDuboisEmail)));
Check.That(candidateProvider.HasAlreadyWasCalled).IsTrue();
Check.That(candidateProvider.AddCandidateWasCalled).IsFalse();
}
public bool registerCandidate(CandidateRegister candidate)
{
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", candidate.email);
cmd.Parameters.AddWithValue("@firstname", candidate.first_name);
cmd.Parameters.AddWithValue("@lastname", candidate.last_name);
cmd.Parameters.AddWithValue("@password", candidate.password);
conn.Open();
int i = cmd.ExecuteNonQuery();
conn.Close();
if (i > 1)
{
return true;
}
else
return false;
}
}
