private void JobListLogin() { if (EmployeeName_TextBox.Text == "" && DMPID_TextBox.Text == "") { ListBox.Items.Add("Please Enter Your Name and DMP ID to Login"); } else if (EmployeeName_TextBox.Text == "") { ListBox.Items.Add("Enter Employee Name to Login"); } else if (DMPID_TextBox.Text == "") { ListBox.Items.Add("Enter DMP ID to Login"); } else if (EmployeeName_TextBox.Text != "" && DMPID_TextBox.Text != "") { try { SqlConnection JobListConnection = new SqlConnection(SQL_Connection); SqlCommand SQL_JobList = new SqlCommand("Select * from [dbo].[Admin] where EmployeeName=@EmployeeName and EmployeePassword=@EmployeePassword", JobListConnection); SQL_JobList.Parameters.AddWithValue("@EmployeeName", EmployeeName_TextBox.Text); SQL_JobList.Parameters.AddWithValue("@EmployeePassword", DMPID_TextBox.Text); JobListConnection.Open(); SqlDataAdapter adapt = new SqlDataAdapter(SQL_JobList); DataSet ds = new DataSet(); adapt.Fill(ds); JobListConnection.Close(); int count = ds.Tables[0].Rows.Count; if (count == 1) { JobList jobList = new JobList(); jobList.User_TextBox.Text = EmployeeName_TextBox.Text; jobList.Clock_TextBox.Text = Clock_TextBox.Text; jobList.DMPID_TextBox.Text = DMPID_TextBox.Text; ListBox.Items.Clear(); jobList.Show(); jobList.Focus(); OpenNewForm(); } else { ListBox.Items.Add("Access to Job List Denied"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }