private void buttonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.DB.EnableStatistics = true;
DataLayer.Employee employee = es.GetEmployee(int.Parse(textBoxEID.Text));
RefreshStatistics(DataLayer.DB.LastStatistics);
DataLayer.DB.EnableStatistics = false;
textBoxFName.Text = employee.FirstName;
textBoxLName.Text = employee.LastName;
textBoxDName.Text = employee.DepartmentName;
labelDeptId.Text = employee.DepartmentId.ToString();
labelOldName.Text = employee.DepartmentName; // for concurrency
DataLayer.ApplicationLog.Add5("Searched for user id: " + textBoxEID.Text);
DataTable tableLog = DataLayer.ApplicationLog.GetLog("WinDemo Application");
dataGridViewAppLog.DataSource = tableLog;
}
catch (SqlException sqlex)
{
// Connection error...
System.Windows.Forms.MessageBox.Show(this, sqlex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch { }
}
protected void LinkButtonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(TextBoxEID.Text));
TextBoxFName.Text = employee.FirstName;
TextBoxLName.Text = employee.LastName;
TextBoxDepartment.Text = employee.DepartmentName;
LabelDeptId.Text = employee.DepartmentId.ToString();
hfOldDeptName.Value = employee.DepartmentName;
DataLayer.ApplicationLog.Add4("Searched for user id: " + TextBoxEID.Text);
GridViewAppLog.DataSource = DataLayer.ApplicationLog.GetLog("ASPDemo Application");
GridViewAppLog.DataBind();
}
catch (SqlException sqlex)
{
// Connection error...
LabelError.Text = sqlex.Message;
}
catch { }
}
private void btnGetEmp_Click(object sender, EventArgs e)
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(txtEID.Text));
txtFName.Text = employee.FirstName;
txtLName.Text = employee.LastName;
txtDeptName.Text = employee.DepartmentName;
}
protected void linkGO_Click(object sender, EventArgs e)
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(txtEID.Text));
TxtFName.Text = employee.FirstName;
txtLName.Text = employee.LastName;
txtDept.Text = employee.DepartmentName;
}
protected void LinkButtonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(TextBoxEID.Text));
TextBoxFName.Text = employee.FirstName;
TextBoxLName.Text = employee.LastName;
TextBoxDepartment.Text = employee.DepartmentName;
}
catch { }
}
private void buttonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(textBoxEID.Text));
textBoxFName.Text = employee.FirstName;
textBoxLName.Text = employee.LastName;
textBoxDName.Text = employee.DepartmentName;
}
catch { }
}
private void linkLabelUpdateDepartmentName_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
try
{
// A search must first be performed
if (textBoxEID.Text.Length > 0 && textBoxDName.Text.Length > 0)
{
DataLayer.Employees employees = new DataLayer.Employees();
int deptId = int.Parse(labelDeptId.Text);
employees.UpdateDepartmentName(deptId, textBoxDName.Text);
}
}
catch { }
}
protected void LinkButtonUpdateDepartmentName_Click(object sender, EventArgs e)
{
try
{
// A search must first be performed
if (TextBoxEID.Text.Length > 0 && TextBoxDName.Text.Length > 0)
{
DataLayer.Employees employees = new DataLayer.Employees();
int deptId = int.Parse(LabelDeptId.Text);
employees.UpdateDepartmentName(deptId, TextBoxDName.Text);
}
}
catch { }
}
private void buttonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(textBoxEID.Text));
textBoxFName.Text = employee.FirstName;
textBoxLName.Text = employee.LastName;
textBoxDName.Text = employee.DepartmentName;
labelDeptId.Text = employee.DepartmentId.ToString();
DataLayer.ApplicationLog.Add4("Search for user id: " + textBoxEID.Text);
}
catch { }
}
protected void LinkButtonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(TextBoxEID.Text));
TextBoxFName.Text = employee.FirstName;
TextBoxLName.Text = employee.LastName;
TextBoxDepartment.Text = employee.DepartmentName;
LabelDeptId.Text = employee.DepartmentId.ToString();
DataLayer.ApplicationLog.Add4("Searched for user id: " + TextBoxEID.Text);
}
catch { }
}
protected void LinkButtonGo_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(TextBox1.Text));
TextBoxFName.Text = employee.FirstName;
TextBoxLName.Text = employee.LastName;
TextBoxDepartment.Text = employee.DepartmentName;
DataLayer.ApplicationLog.Add("Searched for user id: " + TextBox1.Text);
}
catch (Exception)
{
throw;
}
}
protected void LinkButtonUpdateDepartmentName_Click(object sender, EventArgs e)
{
try
{
// A search must first be performed
if (TextBoxEID.Text.Length > 0 &&
TextBoxDepartment.Text.Length > 0)
{
DataLayer.Employees employees = new DataLayer.Employees();
int deptId = int.Parse(LabelDeptId.Text);
employees.UpdateDepartmentName(deptId, TextBoxDepartment.Text, hfOldDeptName.Value);
}
}
catch (SqlException sqlex)
{
// Connection error...
LabelError.Text = sqlex.Message;
}
catch { }
}
private void linkLabelUpdateDepartmentName_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
try
{
// A search must first be performed
if (textBoxEID.Text.Length > 0 &&
textBoxDName.Text.Length > 0)
{
DataLayer.Employees employees = new DataLayer.Employees();
int deptId = int.Parse(labelDeptId.Text);
employees.UpdateDepartmentName(deptId, textBoxDName.Text);
}
}
catch (SqlException sqlex)
{
// Connection error...
System.Windows.Forms.MessageBox.Show(this, sqlex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch { }
}
private void buttonGetEmployee_Click(object sender, EventArgs e)
{
try
{
DataLayer.Employees es = new DataLayer.Employees();
DataLayer.Employee employee = es.GetEmployee(int.Parse(textBoxEID.Text));
textBoxFName.Text = employee.FirstName;
textBoxLName.Text = employee.LastName;
textBoxDName.Text = employee.DepartmentName;
labelDeptId.Text = employee.DepartmentId.ToString();
DataLayer.ApplicationLog.Add4("Searched for user id: " + textBoxEID.Text);
}
catch (SqlException sqlex)
{
// Connection error...
System.Windows.Forms.MessageBox.Show(this, sqlex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch { }
}
