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