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