//Refresh datagridview in Examination tab
private void refreshDataViewExamination()
{
try
{
// Get Examination's datatable
DataTable examinationTable = ExaminationCertificate.GetListEC();
// Add Vietnamese column's name
examinationTable.Columns.Add("Mã phiếu khám bệnh", typeof(string), "[ECID]");
examinationTable.Columns.Add("Mã bệnh nhân", typeof(string), "[PATIENTID]");
examinationTable.Columns.Add("Mã nhân viên", typeof(string), "[STAFFID]");
examinationTable.Columns.Add("Ngày lập", typeof(DateTime), "[DATE]");
examinationTable.Columns.Add("Kết quả", typeof(string), "[RESULT]");
examinationTable.Columns.Add("Trạng thái", typeof(string), "IIF([STATE] = 0, 'Chưa xác nhận', 'Đã xác nhận')");
// Set data source to dataview for searching
dataViewExamination.DataSource = examinationTable.DefaultView;
// Hide English columns'name
for (int i = 0; i < 6; i++)
{
dataViewExamination.Columns[i].Visible = false;
}
}
catch
{
MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public FormECDetail(ExaminationCertificate ecDetail, String userAction, int staffID)
{
InitializeComponent();
this.ECDetail = ecDetail;
this.UserAction = userAction;
SetECDetail(ecDetail, staffID);
}
//This method is for update
private void SetECDetail(ExaminationCertificate ecDetail)
{
textBoxECID.Text = ecDetail.ECID.ToString();;
textBoxPatientID.Text = ecDetail.PatientID.ToString();
textBoxStaffID.Text = ecDetail.StaffID.ToString();
dateCreate.Value = ecDetail.Date;
textBoxResult.Text = ecDetail.Result;
textBoxResult.Enabled = false;
comboBoxState.Enabled = false;
comboBoxState.SelectedIndex = ecDetail.State;
}
private void dataViewExamination_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dataViewExamination.SelectedRows.Count > 0)
{
int ecID = Convert.ToInt32(dataViewExamination.SelectedRows[0].Cells[0].Value);
ExaminationCertificate updateEC = ExaminationCertificate.GetEC(ecID);
FormECDetail formECD = new FormECDetail(updateEC, "edit");
formECD.ShowDialog();
refreshDataViewExamination();
}
}
private void buttonExamination_Click(object sender, EventArgs e)
{
if (dataViewExamination.SelectedRows.Count > 0)
{
ExaminationCertificate ECPrint = ExaminationCertificate.GetEC(Convert.ToInt32(dataViewExamination.SelectedRows[0].Cells[0].Value));
FormReport reportForm = new FormReport();
reportForm.ReportType = "EC";
reportForm.ObjectID = ECPrint.ECID;
reportForm.Show();
}
}
private void buttonUpdateResult_Click(object sender, EventArgs e)
{
if (dataViewExamination.SelectedRows.Count > 0)
{
int ecID = Convert.ToInt32(dataViewExamination.SelectedRows[0].Cells[0].Value);
ExaminationCertificate updateEC = ExaminationCertificate.GetEC(ecID);
//Current user
int staffID = loginStaff.StaffID;
FormECDetail formECD = new FormECDetail(updateEC, "updateResult", staffID);
formECD.ShowDialog();
refreshDataViewExamination();
}
}
private void buttonExaminationDelete_Click(object sender, EventArgs e)
{
if (dataViewExamination.SelectedRows.Count > 0)
{
int ecID = Convert.ToInt32(dataViewExamination.SelectedRows[0].Cells[0].Value);
DialogResult dialogResult = MessageBox.Show("Xác nhận xóa phiếu khám bệnh", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if(ExaminationCertificate.GetEC(ecID).State != 1)
{
if (ExaminationCertificate.DeleteEC(ecID) > 0)
MessageBox.Show("Xóa phiếu khám bệnh thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Không thể xóa phiếu khám bệnh này", "Lỗi dữ liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
refreshDataViewExamination();
}
}
private void buttonOk_Click(object sender, System.EventArgs e)
{
try
{
if (!superValidator1.Validate())
{
return;
}
if (this.UserAction.Equals("edit"))
{
ExaminationCertificate newEC = new ExaminationCertificate();
newEC = this.ECDetail;
newEC.Result = textBoxResult.Text;
newEC.State = comboBoxState.SelectedIndex;
newEC.Date = dateCreate.Value;
DialogResult dialogResult = MessageBox.Show("Xác nhận cập nhập thông tin phiếu khám bệnh", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (ExaminationCertificate.UpdateEC(newEC) > 0)
{
MessageBox.Show("Cập nhập thông tin phiếu khám bệnh thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else if (this.UserAction == "updateResult")
{
ExaminationCertificate newEC = new ExaminationCertificate();
newEC.ECID = Convert.ToInt32(textBoxECID.Text);
newEC.PatientID = Convert.ToInt32(textBoxPatientID.Text);
newEC.StaffID = Convert.ToInt32(textBoxStaffID.Text);
newEC.State = 1;
newEC.Date = dateCreate.Value;
newEC.Result = textBoxResult.Text;
if (ExaminationCertificate.UpdateEC(newEC) > 0)
{
MessageBox.Show("Cập nhập kết quả khám bệnh thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
ExaminationCertificate newEC = new ExaminationCertificate();
newEC.ECID = 0;
newEC.PatientID = Convert.ToInt32(textBoxPatientID.Text);
newEC.StaffID = Convert.ToInt32(textBoxStaffID.Text);
newEC.State = comboBoxState.SelectedIndex;
newEC.Date = dateCreate.Value;
newEC.Result = textBoxResult.Text;
if (ExaminationCertificate.InsertEC(newEC) > 0)
{
FormReport reportForm = new FormReport();
reportForm.ReportType = "EC";
reportForm.ObjectID = ExaminationCertificate.GetCurrentECID();
reportForm.ShowDialog();
int patientID = newEC.PatientID;
//Current user
int staffID = LoginStaff.StaffID;
Bill newBill = new Bill(Bill.SERVICEBILL, patientID, staffID);
FormBillDetail billDetailForm = new FormBillDetail("insertExamination", newBill);
billDetailForm.ShowDialog();
}
}
}
catch
{
MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
