private void DMPID_TextBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && DMPID_TextBox.Focus() == true)
{
OperatorLogin_Button_Click(null, null);
}
}
private void Clear()
{
EmployeeName_TextBox.Clear();
EmployeePassword_TextBox.Clear();
DMPID_TextBox.Clear();
EmployeeName_TextBox.ReadOnly = false;
EmployeePassword_TextBox.ReadOnly = false;
DMPID_TextBox.ReadOnly = false;
}
/********************************************************************************************************************
*
* 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 EmployeeName_ComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
DMPID_TextBox.Clear();
if (EmployeeName_ComboBox.Text == "Ryan Garland" || EmployeeName_ComboBox.Text == "Dale Worline" || EmployeeName_ComboBox.Text == "Sean Pleiman" || EmployeeName_ComboBox.Text == "Nick Gill")
{
AdminButtons_GroupBox.Visible = true;
TestFormsGroupBox.Visible = true;
}
else if (EmployeeName_ComboBox.Text != "Ryan Garland" || EmployeeName_ComboBox.Text != "Dale Worline" || EmployeeName_ComboBox.Text != "Sean Pleiman" || EmployeeName_ComboBox.Text != "Nick Gill")
{
AdminButtons_GroupBox.Visible = false;
TestFormsGroupBox.Visible = false;
}
EmployeeName_TextBox.Text = EmployeeName_ComboBox.Text;
_needUpdate = false;
}
private void EmployeeName_ComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
EmployeeName_TextBox.Clear();
DMPID_TextBox.Clear();
if (EmployeeName_ComboBox.Text == "Ryan Garland" || EmployeeName_ComboBox.Text == "Dale Worline" || EmployeeName_ComboBox.Text == "Sean Pleiman" || EmployeeName_ComboBox.Text == "Nick Gill")
{
Login_GroupBox.Visible = true;
Test_GroupBox.Visible = true;
EmployeeName_TextBox.Text = EmployeeName_ComboBox.Text;
}
else if (EmployeeName_ComboBox.Text != "Ryan Garland" || EmployeeName_ComboBox.Text != "Dale Worline" || EmployeeName_ComboBox.Text != "Sean Pleiman" || EmployeeName_ComboBox.Text != "Nick Gill")
{
Login_GroupBox.Visible = false;
Test_GroupBox.Visible = false;
EmployeeName_TextBox.Text = EmployeeName_ComboBox.Text;
}
}
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);
}
}
