public FormECDetail(ExaminationCertificate ecDetail, String userAction, int staffID)
{
InitializeComponent();
this.ECDetail = ecDetail;
this.UserAction = userAction;
SetECDetail(ecDetail, staffID);
}
public static int UpdateEC(ExaminationCertificate updateEC)
{
string sqlUpdate = @"UPDATE EXAMINATIONCERTIFICATE
SET DATE =@DATE, RESULT =@RESULT, STATE =@STATE
WHERE ECID=@ECID ";
SqlParameter[] sqlParameters = { new SqlParameter("@ECID", updateEC.ECID ),
new SqlParameter("@DATE",updateEC.Date),
new SqlParameter("@RESULT", updateEC.Result),
new SqlParameter("STATE", updateEC.State)};
return SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters);
}
public static int InsertEC(ExaminationCertificate newEC)
{
String sqlInsert = @"INSERT INTO EXAMINATIONCERTIFICATE(PATIENTID, STAFFID, DATE, RESULT, STATE)
VALUES (@PATIENTID,@STAFFID,@DATE,@RESULT,@STATE)";
SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newEC.PatientID),
new SqlParameter("@STAFFID", newEC.StaffID),
new SqlParameter("@DATE", newEC.Date),
new SqlParameter("@RESULT", newEC.Result),
new SqlParameter("@STATE",newEC.State)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
//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;
}
public static int UpdateEC(ExaminationCertificate updateEC)
{
string sqlUpdate = @"UPDATE EXAMINATIONCERTIFICATE
SET DATE =@DATE, RESULT =@RESULT, STATE =@STATE
WHERE ECID=@ECID ";
SqlParameter[] sqlParameters = { new SqlParameter("@ECID", updateEC.ECID),
new SqlParameter("@DATE", updateEC.Date),
new SqlParameter("@RESULT", updateEC.Result),
new SqlParameter("STATE", updateEC.State) };
return(SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters));
}
public static int InsertEC(ExaminationCertificate newEC)
{
String sqlInsert = @"INSERT INTO EXAMINATIONCERTIFICATE(PATIENTID, STAFFID, DATE, RESULT, STATE)
VALUES (@PATIENTID,@STAFFID,@DATE,@RESULT,@STATE)";
SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newEC.PatientID),
new SqlParameter("@STAFFID", newEC.StaffID),
new SqlParameter("@DATE", newEC.Date),
new SqlParameter("@RESULT", newEC.Result),
new SqlParameter("@STATE", newEC.State) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static ExaminationCertificate GetEC(int eCID)
{
ExaminationCertificate newEC = new ExaminationCertificate();
string sqlSelect = @"SELECT ECID, PATIENTID, STAFFID, DATE, RESULT, STATE
FROM EXAMINATIONCERTIFICATE
WHERE ECID=@ECID";
SqlParameter[] sqlParameters = { new SqlParameter("@ECID", eCID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if (dataTable.Rows.Count > 0)
{
newEC.ECID = Convert.ToInt32(dataTable.Rows[0][0]);
newEC.PatientID = Convert.ToInt32(dataTable.Rows[0][0]);
newEC.StaffID = Convert.ToInt32(dataTable.Rows[0][0]);
newEC.Date = (DateTime)dataTable.Rows[0][3];
newEC.Result = (String)dataTable.Rows[0][4];
newEC.State = (int)dataTable.Rows[0][5];
}
return newEC;
}
public static ExaminationCertificate GetEC(int eCID)
{
ExaminationCertificate newEC = new ExaminationCertificate();
string sqlSelect = @"SELECT ECID, PATIENTID, STAFFID, DATE, RESULT, STATE
FROM EXAMINATIONCERTIFICATE
WHERE ECID=@ECID";
SqlParameter[] sqlParameters = { new SqlParameter("@ECID", eCID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if (dataTable.Rows.Count > 0)
{
newEC.ECID = Convert.ToInt32(dataTable.Rows[0][0]);
newEC.PatientID = Convert.ToInt32(dataTable.Rows[0][0]);
newEC.StaffID = Convert.ToInt32(dataTable.Rows[0][0]);
newEC.Date = (DateTime)dataTable.Rows[0][3];
newEC.Result = (String)dataTable.Rows[0][4];
newEC.State = (int)dataTable.Rows[0][5];
}
return(newEC);
}
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();
}
