public DataSet getCandidateList(int exam_id) { try { this.connection = DBHandler.getConnection(); } catch (Exception e) { MessageBox.Show(e.Message.ToString()); } if (connection.State.ToString() == "Closed") { connection.Open(); } SqlCommand newCmd = connection.CreateCommand(); newCmd.Connection = connection; newCmd.CommandType = CommandType.Text; newCmd.CommandText = "select candidate_id from candidate_exam where candidate_exam_id = '" + exam_id + "' ;"; SqlDataAdapter da = new SqlDataAdapter(newCmd); DataSet ds = new DataSet(); da.Fill(ds); connection.Close(); return(ds); }
private void btnSignin_Click(object sender, EventArgs e) { if ((txtUserId.Text == "" || txtPassWord.Text == "")) { MessageBox.Show("Text fields must be filled", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { string EntUserID = txtUserId.Text; string EntPassword = txtPassWord.Text; try { this.connection = DBHandler.getConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } if (connection.State.ToString() == "Closed") { connection.Open(); } DataSet DS = USR.getPassword(txtUserId.Text); foreach (DataRow row in DS.Tables[0].Rows) { for (int i = 0; i < DS.Tables[0].Columns.Count; i++) { userlevel = row[0].ToString().Trim(); password = row[1].ToString().Trim(); username = row[2].ToString().Trim(); } } if (EntPassword == password) { logDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-ddThh:mm:sszzz")); Main main = new Main(username, userlevel, txtUserId.Text, logDate); main.Show(); this.Hide(); //DWHZYWAQSR if (USR.InsertLogRecord(txtUserId.Text, logDate)) { alertLogTracker.ContentText = "Login Tracked : " + logDate; alertLogTracker.Show(); } else { alertLogTracker.ContentText = "Failure Occured ..!"; alertLogTracker.Show(); } } else { MessageBox.Show("Incorrect LogIn Information!Please Re-Enter Username and Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }