private void EmployeeDetailForm_Load(object sender, EventArgs e)
{
foreach (Control control in this.Controls)
{
if (control.GetType() != typeof(Button))
{
control.Enabled = false;
}
}
HospitalDBControlEntities dBContext = new HospitalDBControlEntities();
var q = from n in dBContext.Employees.AsEnumerable()
where n.EmployeeId == (ProfileForm.EmpID)
select n;
foreach (var n in q)
{
employeeIdTextBox.Text = n.EmployeeId.ToString();
firstNameTextBox.Text = n.FirstName;
lastNameTextBox.Text = n.LastName;
accountTextBox.Text = n.Account;
birthdayDateTimePicker.Value = n.Birthday;
sexualTextBox.Text = n.Sexual;
emailTextBox.Text = n.Email;
occupationTextBox.SelectedItem = n.Occupation;
departmentTextBox.SelectedItem = n.Department;
physicianIDTextBox.Text = n.PhysicianID;
pictureBox.Image = new Bitmap(new MemoryStream(n.Picture));
pictureBox.SizeMode = PictureBoxSizeMode.StretchImage;
if (n.EmployeeId == LoginForm.UserId)
{
button1.Enabled = button2.Enabled = button3.Enabled = true;
button1.Visible = true;
}
else
{
button1.Enabled = button2.Enabled = button3.Enabled = false;
button1.Visible = false;
}
}
}
private void button3_Click(object sender, EventArgs e)
{
HospitalDBControlEntities dbContext = new HospitalDBControlEntities();
var q = dbContext.Employees.Where(n => n.EmployeeId == LoginForm.UserId).Select(n => n);
try
{
foreach (var n in q)
{
n.FirstName = firstNameTextBox.Text;
n.LastName = lastNameTextBox.Text;
n.Account = accountTextBox.Text;
n.Birthday = birthdayDateTimePicker.Value;
if (Check.HasChinese(emailTextBox.Text) || !Check.IsValidEMailAddress(emailTextBox.Text))
{
MessageBox.Show("Email欄位錯誤");
}
else
{
n.Email = emailTextBox.Text;
}
n.Occupation = occupationTextBox.SelectedItem.ToString();
n.Department = departmentTextBox.SelectedItem.ToString();
}
dbContext.SaveChanges();
MessageBox.Show("修改成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
