public static EF.Employee GetEmployee(int BusinessEntityId)
{
EF.AdventureWorksEntities efdataContext = new EF.AdventureWorksEntities();
EF.Employee emp = efdataContext.Employees.Where(x => x.BusinessEntityID == BusinessEntityId).FirstOrDefault();
return(emp);
}
private void dlg_PersonelDetay_Load(object sender, EventArgs e)
{
dgv_Email.ClearSelection();
//DataSet ds = EmployeeBLL.SelectEmployeeDetails(BusinessEntityID);
EF.Employee employee = EmployeeBLL.GetEmployee(BusinessEntityID);
lbl_Id.Text = BusinessEntityID.ToString();
lbl_HireDate.Text = employee.HireDate.ToString();
lbl_Name.Text = employee.Person.FirstName;
lbl_Surname.Text = employee.Person.LastName;
txt_JobTitle.Text = employee.JobTitle;
selectedEmployee.BusinessEntityID = BusinessEntityID;
//selectedEmployee.HireDate = DateTime.Parse(ds.Tables[0].Rows[0]["HireDate"].ToString());
//selectedEmployee.JobTitle = ds.Tables[0].Rows[0]["JobTitle"].ToString();
//dgv_Adres.DataSource = null;
//dgv_Adres.DataSource = ds.Tables[1];
//dgv_Adres.ClearSelection();
dgv_Tel.DataSource = null;
dgv_Tel.DataSource = employee.Person.PersonPhones.ToList();
dgv_Tel.ClearSelection();
dgv_Email.DataSource = null;
dgv_Email.DataSource = employee.Person.EmailAddresses.ToList();
dgv_Email.ClearSelection();
}
private void dlg_PersonelDetay_Load(object sender, EventArgs e)
{
selectedEmployee = EmployeeBLL.GetEmployee(BusinessEntityID);
lbl_Id.Text = BusinessEntityID.ToString();
lbl_HireDate.Text = selectedEmployee.HireDate.ToString();
lbl_Name.Text = selectedEmployee.Person.FirstName;
lbl_Surname.Text = selectedEmployee.Person.LastName;
txt_JobTitle.Text = selectedEmployee.JobTitle;
dgv_Tel.DataSource = null;
dgv_Tel.DataSource = selectedEmployee.Person.PersonPhones.ToList();
dgv_Email.DataSource = null;
dgv_Email.DataSource = selectedEmployee.Person.EmailAddresses.ToList();
}
