public void InsertMedicalRecord(DTO_PhieuKhamBenh medicalRecord)
{
//Encrypt
String cypherSymptoms = Crypto.Encryption(medicalRecord.TrieuChung, Crypto.CryptoKey);
String cypherDiagnose = Crypto.Encryption(medicalRecord.KetLuanCuaBacSi, Crypto.CryptoKey);
medicalRecord.TrieuChung = cypherSymptoms;
medicalRecord.KetLuanCuaBacSi = cypherDiagnose;
DAO_PhieuKhamBenh.Instance.InsertMedicalRecord(medicalRecord);
}
public void InsertMedicalRecord(DTO_PhieuKhamBenh medicalRecord)
{
////OracleCommand command = new OracleCommand();
//command.CommandText = $"begin INSERT_PKB ('{medicalRecord.MaKhamBenh}', '{medicalRecord.NgayKham}', '{medicalRecord.TrieuChung}', " +
// $"'{medicalRecord.KetLuanCuaBacSi}', '{medicalRecord.MaBenhNhan}', '{medicalRecord.MaBacSi}'); end;";
//command.Connection = _conn;
OracleCommand command = new OracleCommand($"{_dbSchema}.INSERT_PKB", _conn);
command.CommandType = CommandType.StoredProcedure;
OracleParameter param1 = new OracleParameter("I_MAKHAMBENH", OracleDbType.Varchar2);
param1.Value = medicalRecord.MaKhamBenh;
OracleParameter param2 = new OracleParameter("I_NGAYKHAM", OracleDbType.Varchar2);
param2.Value = medicalRecord.NgayKham;
OracleParameter param3 = new OracleParameter("I_TRIEUCHUNG", OracleDbType.Varchar2);
param3.Value = medicalRecord.TrieuChung;
OracleParameter param4 = new OracleParameter("I_KETLUANCUABS", OracleDbType.Varchar2);
param4.Value = medicalRecord.KetLuanCuaBacSi;
OracleParameter param5 = new OracleParameter("I_MABENHNHAN", OracleDbType.Varchar2);
param5.Value = medicalRecord.MaBenhNhan;
OracleParameter param6 = new OracleParameter("I_MANHANVIEN", OracleDbType.Varchar2);
param6.Value = medicalRecord.MaBacSi;
command.Parameters.Add(param1);
command.Parameters.Add(param2);
command.Parameters.Add(param3);
command.Parameters.Add(param4);
command.Parameters.Add(param5);
command.Parameters.Add(param6);
try
{
_conn.Open();
command.ExecuteNonQuery();
_conn.Close();
}
catch (OracleException e)
{
_conn.Close();
throw new Exception(e.Message);
}
}
private void InsertButton_Click(object sender, RoutedEventArgs e)
{
DTO_PhieuKhamBenh medicalRecord = new DTO_PhieuKhamBenh();
medicalRecord.MaKhamBenh = txtbox_medicalRecordID.Text;
medicalRecord.MaBenhNhan = txtbox_patientID.Text;
medicalRecord.MaBacSi = txtbox_doctorID.Text;
medicalRecord.TrieuChung = txtbox_symptompsID.Text;
medicalRecord.KetLuanCuaBacSi = txtbox_diagnoseID.Text;
medicalRecord.NgayKham = DateTime.Now.ToString("dd/MM/yyyy");
//Call BUS to do encrypt
try
{
BUS_PhieuKhamBenh.Instance.InsertMedicalRecord(medicalRecord);
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return;
}
InsertSuccessfully();
}
public List <DTO_PhieuKhamBenh> GetMedicalRecords()
{
List <DTO_PhieuKhamBenh> result = new List <DTO_PhieuKhamBenh>();
DataTable data = DAO_PhieuKhamBenh.Instance.GetMedicalRecords();
foreach (DataRow row in data.Rows)
{
DTO_PhieuKhamBenh tmpObject = new DTO_PhieuKhamBenh();
tmpObject.MaKhamBenh = row["MAKHAMBENH"].ToString();
DateTime date = DateTime.Parse(row["NGAYKHAM"].ToString());
tmpObject.NgayKham = date.ToString("dd/MM/yyyy");
tmpObject.TrieuChung = Crypto.Decryption(row["TRIEUCHUNG"].ToString(), Crypto.CryptoKey);
tmpObject.KetLuanCuaBacSi = Crypto.Decryption(row["KETLUANCUABACSI"].ToString(), Crypto.CryptoKey);
tmpObject.MaBenhNhan = row["MABENHNHAN"].ToString();
tmpObject.MaBacSi = row["MANHANVIEN"].ToString();
result.Add(tmpObject);
}
return(result);
}
