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