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