/******************************************************************************************************************** * * Buttons Region End * ********************************************************************************************************************/ #endregion /******************************************************************************************************************** * * Methods Region Start * -- Total: 8 * * - OperatorLogin * - AdminLogin * - ReportViewLogin * - JobListLogin * - CellControlLogin * - BrakePressID * - OpenNewForm * ********************************************************************************************************************/ #region private void OperatorLogin() { 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 OperatorLogin = new SqlConnection(SQL_Connection); SqlCommand Login_Command = new SqlCommand("Select * from [dbo].[Employee] where EmployeeName=@EmployeeName and EmployeePassword=@EmployeePassword", OperatorLogin); Login_Command.Parameters.AddWithValue("@EmployeeName", EmployeeName_ComboBox.Text); Login_Command.Parameters.AddWithValue("@EmployeePassword", DMPID_TextBox.Text); OperatorLogin.Open(); SqlDataAdapter adapt = new SqlDataAdapter(Login_Command); DataSet ds = new DataSet(); adapt.Fill(ds); LoginGridView.DataSource = ds.Tables[0]; OperatorLogin.Close(); int count = ds.Tables[0].Rows.Count; if (count == 1) { User_Program UserProgram = new User_Program(); UserProgram.User_TextBox.Text = EmployeeName_TextBox.Text; UserProgram.Clock_TextBox.Text = Clock_TextBox.Text; UserProgram.DMPID_TextBox.Text = DMPID_TextBox.Text; DMPID_TextBox.Clear(); EmployeeName_TextBox.Clear(); EmployeeName_ComboBox.Text = ""; ListBox.Items.Clear(); UserProgram.Show(); UserProgram.Focus(); OpenNewForm(); } else { ListBox.Items.Add("Please Check DMP ID Entered"); } } catch (Exception e) { //ListBox.Items.Add("Log In Failed. Employee Not Found.\n" + e.ToString()); } } }
private void OperatorLogin() { if (EmployeeName_TextBox.Text == null && DMPID_TextBox.Text == null) { ListBox.Items.Add("Please Enter Your Name and DMP ID to Login"); } else if (EmployeeName_TextBox.Text == null) { ListBox.Items.Add("Enter Employee Name to Login"); } else if (DMPID_TextBox.Text == null) { ListBox.Items.Add("Enter DMP ID to Login"); } try { SqlConnection OperatorLogin = new SqlConnection(SQL_Connection); SqlCommand Login_Command = new SqlCommand("Select * from [dbo].[Employee] where EmployeeName=@EmployeeName and DMPID=@DMPID", OperatorLogin); Login_Command.Parameters.AddWithValue("@EmployeeName", EmployeeName_TextBox.Text); Login_Command.Parameters.AddWithValue("@DMPID", DMPID_TextBox.Text); OperatorLogin.Open(); SqlDataAdapter adapt = new SqlDataAdapter(Login_Command); DataSet ds = new DataSet(); adapt.Fill(ds); LoginGridView.DataSource = ds.Tables[0]; OperatorLogin.Close(); int count = ds.Tables[0].Rows.Count; if (count == 1) { User_Program UserProgram = new User_Program(); UserProgram.User_TextBox.Text = EmployeeName_TextBox.Text; UserProgram.Clock_TextBox.Text = Clock_TextBox.Text; //UserProgram.UserNumber_TextBox = DMPID_TextBox.Text; UserProgram.User_TextBox.ReadOnly = true; UserProgram.Clock_TextBox.ReadOnly = true; //this.Hide(); DMPID_TextBox.Clear(); ListBox.Items.Clear(); foreach (DataGridViewRow number in LoginGridView.Rows) { UserProgram.DMPID_TextBox.Text = number.Cells[2].Value.ToString(); break; } ListBox.Items.Add("Login Successful"); UserProgram.Show(); UserProgram.Focus(); OpenNewForm(); } else { ListBox.Items.Add("Log In Failed. Employee Not Found."); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }