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