private void buttonOk_Click(object sender, System.EventArgs e)
{
if (!superValidator1.Validate())
return;
if (Patient.IsPatientExist(int.Parse(textBoxPatientID.Text)))
{
try
{
if (UserAction == "edit")
{
HeathFile newHF = new HeathFile();
newHF.HeathFileID = int.Parse(textBoxHFID.Text);
newHF.PatientID = int.Parse(textBoxPatientID.Text);
newHF.PatientState = textBoxPatientState.Text;
newHF.PreHistory = textBoxPrehistory.Text;
newHF.Disease = textBoxDisease.Text;
newHF.Treament = textBoxTreatment.Text;
newHF.Date = dateCreate.Value;
DialogResult dialogResult = MessageBox.Show("Xác nhận cập nhập thông tin bệnh án", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
if (HeathFile.UpdateHeathFile(newHF) > 0)
MessageBox.Show("Cập nhập thông tin bệnh án thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (HeathFile.DidPatientHaveHF(int.Parse(textBoxPatientID.Text)))
{
MessageBox.Show("Bệnh nhân đã có bệnh án", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
HeathFile newHF = new HeathFile();
newHF.HeathFileID = 0;
newHF.PatientID = int.Parse(textBoxPatientID.Text);
newHF.PatientState = textBoxPatientState.Text;
newHF.PreHistory = textBoxPrehistory.Text;
newHF.Disease = textBoxDisease.Text;
newHF.Treament = textBoxTreatment.Text;
newHF.Date = dateCreate.Value;
if(HeathFile.InsertHeathFile(newHF)>0)
MessageBox.Show("Thêm bệnh án thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch
{
MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Bệnh nhân không tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
this.Close();
}
//For edit feature
private void SetHFDetail(HeathFile hfDetail)
{
textBoxHFID.Text = hfDetail.HeathFileID.ToString();
textBoxPatientID.Text = hfDetail.PatientID.ToString();
dateCreate.Value = hfDetail.Date;
textBoxPatientState.Text = hfDetail.PatientState;
textBoxPrehistory.Text = hfDetail.PreHistory;
textBoxDisease.Text = hfDetail.PreHistory;
textBoxTreatment.Text = hfDetail.Treament;
}
public static int InsertHeathFile(HeathFile newHF)
{
String sqlInsert = @"INSERT INTO HEATHFILE(PATIENTID, DATE, PATIENTSTATE, PREHISTORY, DISEASE, TREATMENT)
VALUES (@PATIENTID,@DATE,@PATIENTSTATE,@PREHISTORY,@DISEASE,@TREATMENT)";
SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newHF.PatientID),
new SqlParameter("@DATE", newHF.Date),
new SqlParameter("@PATIENTSTATE", newHF.PatientState),
new SqlParameter("@PREHISTORY", newHF.PreHistory),
new SqlParameter("@DISEASE", newHF.Disease),
new SqlParameter("@TREATMENT",newHF.Treament)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
public static int InsertHeathFile(HeathFile newHF)
{
String sqlInsert = @"INSERT INTO HEATHFILE(PATIENTID, DATE, PATIENTSTATE, PREHISTORY, DISEASE, TREATMENT)
VALUES (@PATIENTID,@DATE,@PATIENTSTATE,@PREHISTORY,@DISEASE,@TREATMENT)";
SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newHF.PatientID),
new SqlParameter("@DATE", newHF.Date),
new SqlParameter("@PATIENTSTATE", newHF.PatientState),
new SqlParameter("@PREHISTORY", newHF.PreHistory),
new SqlParameter("@DISEASE", newHF.Disease),
new SqlParameter("@TREATMENT", newHF.Treament) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int UpdateHeathFile(HeathFile updateHF)
{
string sqlUpdate = @"UPDATE HEATHFILE
SET DATE =@DATE, PATIENTSTATE =@PATIENTSTATE, PREHISTORY =@PREHISTORY, DISEASE =@DISEASE, TREATMENT =@TREATMENT
WHERE HEATHFILEID=@HEATHFILEID ";
SqlParameter[] sqlParameters = { new SqlParameter("@HEATHFILEID", updateHF.HeathFileID ),
new SqlParameter("@DATE", updateHF.Date ),
new SqlParameter("@PATIENTSTATE", updateHF.PatientState),
new SqlParameter("@PREHISTORY",updateHF.PreHistory ),
new SqlParameter("@DISEASE", updateHF.Disease),
new SqlParameter("TREATMENT", updateHF.Treament)};
return SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters);
}
public static int UpdateHeathFile(HeathFile updateHF)
{
string sqlUpdate = @"UPDATE HEATHFILE
SET DATE =@DATE, PATIENTSTATE =@PATIENTSTATE, PREHISTORY =@PREHISTORY, DISEASE =@DISEASE, TREATMENT =@TREATMENT
WHERE HEATHFILEID=@HEATHFILEID ";
SqlParameter[] sqlParameters = { new SqlParameter("@HEATHFILEID", updateHF.HeathFileID),
new SqlParameter("@DATE", updateHF.Date),
new SqlParameter("@PATIENTSTATE", updateHF.PatientState),
new SqlParameter("@PREHISTORY", updateHF.PreHistory),
new SqlParameter("@DISEASE", updateHF.Disease),
new SqlParameter("TREATMENT", updateHF.Treament) };
return(SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters));
}
public static HeathFile GetHeathFile(int heathFileID)
{
HeathFile hF = new HeathFile();
string sqlSelect = @"SELECT HEATHFILEID, PATIENTID, DATE, PATIENTSTATE, PREHISTORY, DISEASE, TREATMENT
FROM HEATHFILE
WHERE HEATHFILEID=@HEATHFILEID";
SqlParameter[] sqlParameters = { new SqlParameter("@HEATHFILEID",heathFileID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if(dataTable.Rows.Count >0)
{
hF.HeathFileID = Convert.ToInt32(dataTable.Rows[0][0]);
hF.PatientID = Convert.ToInt32(dataTable.Rows[0][1]);
hF.Date = (DateTime)dataTable.Rows[0][2];
hF.PatientState =(String)dataTable.Rows[0][3];
hF.PreHistory = (String)dataTable.Rows[0][4];
hF.Disease = (String)dataTable.Rows[0][5];
hF.Treament = (String)dataTable.Rows[0][6];
}
return hF;
}
public static HeathFile GetHeathFile(int heathFileID)
{
HeathFile hF = new HeathFile();
string sqlSelect = @"SELECT HEATHFILEID, PATIENTID, DATE, PATIENTSTATE, PREHISTORY, DISEASE, TREATMENT
FROM HEATHFILE
WHERE HEATHFILEID=@HEATHFILEID";
SqlParameter[] sqlParameters = { new SqlParameter("@HEATHFILEID", heathFileID) };
DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters);
if (dataTable.Rows.Count > 0)
{
hF.HeathFileID = Convert.ToInt32(dataTable.Rows[0][0]);
hF.PatientID = Convert.ToInt32(dataTable.Rows[0][1]);
hF.Date = (DateTime)dataTable.Rows[0][2];
hF.PatientState = (String)dataTable.Rows[0][3];
hF.PreHistory = (String)dataTable.Rows[0][4];
hF.Disease = (String)dataTable.Rows[0][5];
hF.Treament = (String)dataTable.Rows[0][6];
}
return(hF);
}
public FormHFDetail(HeathFile hfDetail, String userAction)
{
InitializeComponent();
this.UserAction = userAction;
SetHFDetail(hfDetail);
}
