private void candidateSignInButton_Click(object sender, EventArgs e)
{
CandidateLogin aCandidateLogin = new CandidateLogin();
aCandidateLogin.CandidateName = candidateNameTextBox.Text;
aCandidateLogin.CandidatePassword = candidatePasswordTextBox.Text;
if (candidateNameTextBox.Text == "" || candidatePasswordTextBox.Text == "")
{
MessageBox.Show("Please fill up required the field");
}
else
{
LoginManager aLoginManager = new LoginManager();
bool candidateLoginPermission = aLoginManager.GivePermitToCandidateToLogin(aCandidateLogin);
if (candidateLoginPermission)
{
Hide();
CandidateUI aCandidateUi = new CandidateUI(aCandidateLogin.CandidateName);
aCandidateUi.Show();
}
else
{
MessageBox.Show("Invalid Candidate Name or Password");
}
}
}
public static Candidateviewmodal RegisterUser(Candidateviewmodal model)
{
using (QuizContext cntxt = new QuizContext())
{
if (!cntxt.Candidates.Any(o => o.CandidateName == model.CandidateName))
{
Candidate cndate = new Candidate();
cndate.CandidateName = model.CandidateName;
cndate.Password = model.Password;
cndate.CandidateEmail = model.EmailID;
cndate.AddedDate = DateTime.Now;
cntxt.Candidates.Add(cndate);
cntxt.SaveChanges();
CandidateLogin cndlog = new CandidateLogin();
cndlog.CandidateId = cndate.CandidateId;
cndlog.LogDate = DateTime.Now;
cntxt.CandidateLogins.Add(cndlog);
cntxt.SaveChanges();
model.isValidUser = true;
model.LoginMessage = "Candidate Sucessfully Added";
model.isValidUser = true;
model.CandidateId = model.CandidateId;
}
else
{
model.isValidUser = false;
model.LoginMessage = "User Name Already Used;Try another name ";
}
}
return(model);
}
public static Candidateviewmodal LoginUser(Candidateviewmodal model)
{
model.isValidUser = false;
model.LoginMessage = "Wrong Username or password ";
using (QuizContext cntxt = new QuizContext())
{
var q = from can in cntxt.Candidates
where can.CandidateName == model.CandidateName && can.Password == model.Password
select can;
foreach (var element in q)
{
CandidateLogin cndlog = new CandidateLogin();
cndlog.CandidateId = element.CandidateId;
cndlog.LogDate = DateTime.Now;
cntxt.CandidateLogins.Add(cndlog);
model.isValidUser = true;
model.LoginMessage = "Candidate Sucessfully Added";
model.isValidUser = true;
model.CandidateId = element.CandidateId;
}
cntxt.SaveChanges();
}
return(model);
}
public bool GivePermitToCandidateToLogin(DAL.DAO.CandidateLogin aCandidateLogin)
{
LoginGateway aLoginGateway = new LoginGateway();
aLoginGateway.ConfirmConnection();
CandidateLogin bCandidateLogin = new CandidateLogin();
bCandidateLogin = aLoginGateway.CheckCandidateLoginInfo(aCandidateLogin.CandidateName, aCandidateLogin.CandidatePassword);
if (bCandidateLogin.CandidateName == aCandidateLogin.CandidateName && bCandidateLogin.CandidatePassword == aCandidateLogin.CandidatePassword)
{
return(true);
}
return(false);
//bool permitMessage = aLoginGateway.CheckCandidateLoginInfo(aCandidateLogin);
//return permitMessage;
}
internal CandidateLogin CheckCandidateLoginInfo(string candidateName, string candidatePassword)
{
aSqlConnection.Open();
string query = "SELECT * FROM t_candidate WHERE candidate_name = '" + candidateName + "' and candidate_password ='******' ";
SqlCommand aCommand = new SqlCommand(query, aSqlConnection);
SqlDataReader aReader = aCommand.ExecuteReader();
CandidateLogin aCandidateLogin = new CandidateLogin();
while (aReader.Read())
{
aCandidateLogin.CandidateName = aReader["candidate_name"].ToString();
aCandidateLogin.CandidatePassword = aReader["candidate_password"].ToString();
}
aSqlConnection.Close();
return(aCandidateLogin);
}
