private void saveButton_Click(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
try
{
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
dbContext.Prescriptions.Add(new Prescription
{
EmployeeID = LoginForm.UserId,
PatientID = dbContext.Diagnosis1.AsEnumerable().Where(n => n.PatientName == dataGridView.Rows[i].Cells[1].Value.ToString()).Select(n => n.PatientId).First(),
PillsID = dbContext.Pills.AsEnumerable().Where(n => n.PillName == dataGridView.Rows[i].Cells[2].Value.ToString()).Select(n => n.Id).First(),
Count = Int32.Parse(dataGridView.Rows[i].Cells[3].Value.ToString()),
TotalPrice = (decimal)dataGridView.Rows[0].Cells[3].Value * dbContext.Pills.AsEnumerable().Where(n => n.PillName == dataGridView.Rows[i].Cells[2].Value.ToString()).Select(n => n.PillUnitPrice).First(),
CreateDate = DateTime.Now
});
dbContext.SaveChanges();
}
dataGridView.Rows.Clear();
MessageBox.Show("儲存成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void buyBtn_Click(object sender, EventArgs e)
{
if (comboBox1 != null)
{
try
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Pills.AsEnumerable().Where(n => n.PillName == comboBox1.Text).Select(n => n);
foreach (var n in q)
{
n.PillName = comboBox1.Text;
n.PillInstore += (int)numericUpDown1.Value;
}
dbContext.SaveChanges();
MessageBox.Show("訂購成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
dbContext.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("請選擇購買品項", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
try
{
FileStream fileStream = new FileStream(fileStreamPath, FileMode.Open, FileAccess.Read);
byte[] data = new byte[fileStream.Length];
fileStream.Read(data, 0, (int)fileStream.Length);
dbContext.Diagnosis1.Add(new Diagnosis
{
PatientName = patientNameTextBox.Text,
Sexual = sexualTextBox.Text,
MRN = mrnTextBox.Text,
IdNumber = idTextBox.Text,
Birthday = birthdayDTP.Value,
Address = addressTextBox.Text,
Symptoms = SymptomsRichTextBox.Text,
Advice = adviceRichTextBox.Text,
DocterID = LoginForm.UserId,
CreateDate = creatDTP.Value,
PrintDate = printDTP.Value,
Picture = data
});
dbContext.SaveChanges();
MessageBox.Show("存檔成功!");
this.Close();
this.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void confirmButton_Click(object sender, EventArgs e)
{
if (richTextBox.Text == "" || titleTextBox.Text == "")
{
MessageBox.Show("請輸入文字", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
foreach (Control controls in tabPage2.Controls)
{
controls.Enabled = false;
}
writeButton.Enabled = true;
try
{
dbContext.Messageboards.Add(new Messageboard
{
EmployeeId = LoginForm.UserId,
Name = LoginForm.UserName,
Title = titleTextBox.Text,
Content = richTextBox.Text,
Date = DateTime.Now
});
dbContext.SaveChanges();
MessageBox.Show("上傳成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void confirmButton_Click(object sender, EventArgs e)
{
var q = dbContext.Messageboards.Where(n => n.Id == MainPage.PostID).Select(n => n);
try
{
foreach (var n in q)
{
n.Content = richTextBox.Text;
}
dbContext.SaveChanges();
MessageBox.Show("修改成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
richTextBox.Enabled = false;
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void confirmButton_Click(object sender, EventArgs e)
{
try
{
HospitalDBEntities dbContext = new HospitalDBEntities();
dbContext.Issues.Add(new Issue
{
Title = titleTextBox.Text,
Content = contentRichTextBox.Text,
Date = monthCalendar.SelectionStart,
EmployeeID = LoginForm.UserId
});
dbContext.SaveChanges();
MessageBox.Show("新增成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
titleTextBox.Enabled = contentRichTextBox.Enabled = confirmButton.Enabled = monthCalendar.Enabled = false;
}catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}