// lưu đơn thuốc
public string SaveDonthuoc(DonThuocDTO donThuoc, List <ChiTietDonThuocDTO> chiTietDonThuocs)
{
DonThuocBUS donThuocBUS = new DonThuocBUS();
ChiTietDonThuocBUS chiTietDonThuocBUS = new ChiTietDonThuocBUS();
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
using (var trans = db.Database.BeginTransaction())
{
string maDonThuoc = donThuocBUS.getMaDonThuoc(db);
donThuoc.MaDonThuoc = maDonThuoc;
if (donThuocBUS.SaveDonThuoc(db, donThuoc).Equals(Constant.RES_FAI))
{
trans.Rollback();
return(Constant.RES_FAI);
}
foreach (var ct in chiTietDonThuocs)
{
ct.MaDonThuoc = maDonThuoc;
if (chiTietDonThuocBUS.SaveChiTietDonThuoc(db, ct).Equals(Constant.RES_FAI))
{
trans.Rollback();
return(Constant.RES_FAI);
}
}
trans.Commit();
}
db.SaveChanges();
}
return(Constant.RES_SUC);
}
public void Search_TestCase1()
{
// create data search
db.HOSOBENHANs.Add(new HOSOBENHAN {
MaHoSo = "1234567890", NgayKham = "12122010"
});
db.HOSOBENHANs.Add(new HOSOBENHAN {
MaHoSo = "1234567891", NgayKham = "12122011"
});
db.HOSOBENHANs.Add(new HOSOBENHAN {
MaHoSo = "1234567892", NgayKham = "12122012"
});
// create object search
HoSoSearchEntity hoSoSearchEntity = new HoSoSearchEntity
{
MaHoSo = "12345678",
TenBenhNhan = "",
NgayKham = ""
};
List <HoSoBenhAnDTO> listResult = null;
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
// execute
string actual = hoSoBenhAnBUS.SearchHoSo(db, hoSoSearchEntity, out listResult);
string expected = "0000";
// compare
Assert.Equals(actual, expected);
}
public void Add_TestCase2()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10 + "1",
MaHoSoTruoc = TestCommon.LEN_10 + "1",
MaHoSoGoc = TestCommon.LEN_10 + "1",
MaLoaiHoSo = TestCommon.LEN_10 + "1",
MaBenhNhan = TestCommon.LEN_10 + "1",
MaNguoiTN = TestCommon.LEN_10 + "1",
NgayTiepNhan = TestCommon.LEN_8 + "1",
YeuCauKham = TestCommon.LEN_250 + "1",
TrieuChung = TestCommon.LEN_250 + "1",
NgayKham = TestCommon.LEN_8 + "1",
SoThuTu = 1,
MaPhongKham = TestCommon.LEN_10 + "1",
MaBacSi = TestCommon.LEN_10 + "1",
ChuanDoan = "abc",
CoKeDon = true,
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
string actual = hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
string expected = "1111";
Assert.Equals(expected, actual);
}
private string CheckExist(TiepNhanEntity entity, ref List <string> Messages)
{
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
PhongKhamBUS phongKhamBUS = new PhongKhamBUS();
NhanVienBUS nhanVienBUS = new NhanVienBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
if (entity.MaLoaiHoSo != Com.BusConstant.HS_KHAMMOI && entity.MaLoaiHoSo != BUS.Com.BusConstant.HS_TAIKHAM)
{
Messages.Add("Loại hồ sơ không tồn tại!");
return(Constant.RES_FAI);
}
HoSoBenhAnDTO hoSoBenhAn = new HoSoBenhAnDTO();
if (hoSoBenhAnBUS.GetInfomationHoSo(db, entity.MaHoSoTruoc, out hoSoBenhAn) == Constant.RES_FAI && entity.MaLoaiHoSo == Com.BusConstant.HS_TAIKHAM)
{
Messages.Add("Hồ sơ bệnh án trước không tồn tại!");
return(Constant.RES_FAI);
}
PhongKhamDTO phong = new PhongKhamDTO();
if (phongKhamBUS.GetInformationPhongKham(db, entity.MaPhongKham, out phong) == Constant.RES_FAI)
{
Messages.Add("Phòng khám không tồn tại!");
return(Constant.RES_FAI);
}
NhanVienDTO nhanVien = new NhanVienDTO();
if (nhanVienBUS.GetInfomationNhanVien(db, entity.MaNguoiTN, out nhanVien) == Constant.RES_FAI)
{
Messages.Add("Nhân viên tiếp nhận không tồn tại!");
return(Constant.RES_FAI);
}
}
return(Constant.RES_SUC);
}
// lấy danh sách hồ sơ theo bệnh nhân
public string GetListHoSoByBenhNhan(string MaBenhNhan, out List <HoSoBenhAnDTO> hoSoBenhAnDTOs)
{
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
hoSoBenhAnBUS.GetListHoSoWithIdBenhNhan(db, MaBenhNhan, out hoSoBenhAnDTOs);
}
return(Constant.RES_SUC);
}
// lấy danh sách hồ sơ sau xét nghiệm theo phòng
public string GetListHoSoXetNgiemByPhong(string MaPhong, out List <HoSoBenhAnDTO> listHoSoBenhAn)
{
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
hoSoBenhAnBUS.GetListHoSo(db, MaPhong, BusConstant.NODE_KHAM_SAU_XN, out listHoSoBenhAn);
}
return(Constant.RES_SUC);
}
// lấy thông tin toàn bồ hồ sơ
public string GetInformationHoSo(string MaHoSo, out HoSoBenhAnDTO hoSoBenhAn)
{
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
hoSoBenhAnBUS.GetInfomationHoSo(db, MaHoSo, out hoSoBenhAn);
}
return(Constant.RES_SUC);
}
// Lấy danh sách hồ sơ bệnh án hiện tại
public string GetListHoSo(out List <HoSoBenhAnDTO> hoSoBenhAnDTOs)
{
hoSoBenhAnDTOs = new List <HoSoBenhAnDTO>();
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
hoSoBenhAnBUS.GetListHoSo(db, out hoSoBenhAnDTOs);
}
return(Constant.RES_SUC);
}
public string GetListRelativeHoSo(string MaBenhNhan, out List <HoSoBenhAnDTO> ListRelativeHoSo)
{
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (var db = new QLPHONGKHAMEntities())
{
if (hoSoBenhAnBUS.GetListHoSoWithIdBenhNhan(db, MaBenhNhan, out ListRelativeHoSo) == Constant.RES_FAI)
{
return(Constant.RES_FAI);
}
}
return(Constant.RES_SUC);
}
public void Add_TestCase3()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10,
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
string actual = hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
string expected = "1111";
Assert.Equals(expected, actual);
}
public void Update_TestCase1()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10,
MaHoSoTruoc = TestCommon.LEN_10,
MaHoSoGoc = TestCommon.LEN_10,
MaLoaiHoSo = TestCommon.LEN_10,
MaBenhNhan = TestCommon.LEN_10,
MaNguoiTN = TestCommon.LEN_10,
NgayTiepNhan = TestCommon.LEN_8,
YeuCauKham = TestCommon.LEN_250,
TrieuChung = TestCommon.LEN_250,
NgayKham = TestCommon.LEN_8,
SoThuTu = 1,
MaPhongKham = TestCommon.LEN_10,
MaBacSi = TestCommon.LEN_10,
ChuanDoan = "abc",
CoKeDon = true,
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
HOSOBENHAN hoSoBenhAnUpdate = new HOSOBENHAN
{
MaHoSo = TestCommon.LEN_10,
MaHoSoTruoc = TestCommon.LEN_10,
MaHoSoGoc = TestCommon.LEN_10,
MaLoaiHoSo = TestCommon.LEN_10,
MaBenhNhan = TestCommon.LEN_10,
MaNguoiTN = TestCommon.LEN_10,
NgayTiepNhan = TestCommon.LEN_8,
YeuCauKham = TestCommon.LEN_250,
TrieuChung = TestCommon.LEN_250,
NgayKham = TestCommon.LEN_8,
SoThuTu = 1,
MaPhongKham = TestCommon.LEN_10,
MaBacSi = TestCommon.LEN_10,
ChuanDoan = "TEST UPDATE",
CoKeDon = true,
};
string actual = hoSoBenhAnBUS.UpdateHoSoBenhAn(db, hoSoBenhAnDTO);
string expected = "0000";
Assert.Equals(expected, actual);
}
//Update hồ sơ bệnh án
public string UpdateHoSo(DTO.HoSoBenhAnDTO hoso)
{
HoSoBenhAnBUS bus = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
if (bus.UpdateHoSoBenhAn(db, hoso) == COM.Constant.RES_FAI)
{
return(COM.Constant.RES_FAI);
}
db.SaveChanges();
}
return(COM.Constant.RES_SUC);
}
public void Delete_TestCase1()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10,
MaHoSoTruoc = TestCommon.LEN_10,
MaHoSoGoc = TestCommon.LEN_10,
MaLoaiHoSo = TestCommon.LEN_10,
MaBenhNhan = TestCommon.LEN_10,
MaNguoiTN = TestCommon.LEN_10,
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
string actual = hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
Assert.Equals(null, actual);
}
public void Add_TestCase4()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10,
MaLoaiHoSo = "1234",
MaBenhNhan = "1234",
MaNguoiTN = "1234",
MaPhongKham = "1234",
MaBacSi = "1234",
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
string actual = hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
string expected = "1111";
Assert.Equals(expected, actual);
}
public void Search_TestCase2()
{
// create object search
HoSoSearchEntity hoSoSearchEntity = new HoSoSearchEntity
{
MaHoSo = "12345678",
TenBenhNhan = "",
NgayKham = ""
};
List <HoSoBenhAnDTO> listResult = null;
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
// execute
string actual = hoSoBenhAnBUS.SearchHoSo(db, hoSoSearchEntity, out listResult);
string expected = "1111";
// compare
Assert.Equals(actual, expected);
}
// XÓA ĐƠN THUỐC
public string DeleteDonThuoc(DonThuocDTO donThuoc)
{
DonThuocBUS donThuocBUS = new DonThuocBUS();
ChiTietDonThuocBUS chiTietDonThuocBUS = new ChiTietDonThuocBUS();
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
using (var trans = db.Database.BeginTransaction())
{
// xoá tất cả ctdt
if (chiTietDonThuocBUS.DeleteAllWithId(db, donThuoc.MaDonThuoc) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
// Xóa đơn thuốc
if (donThuocBUS.Delete(db, donThuoc.MaDonThuoc) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
HoSoBenhAnDTO hoSo = new HoSoBenhAnDTO();
if (hoSoBenhAnBUS.GetInfomationHoSo(db, donThuoc.MaHoSo, out hoSo) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
hoSo.CoKeDon = false;
if (hoSoBenhAnBUS.UpdateHoSoBenhAn(db, hoSo) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
trans.Commit();
}
db.SaveChanges();
}
return(Constant.RES_SUC);
}
public void Update_TestCase5()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10,
MaLoaiHoSo = TestCommon.LEN_10,
MaBenhNhan = TestCommon.LEN_10,
MaNguoiTN = TestCommon.LEN_10,
NgayTiepNhan = TestCommon.LEN_8,
YeuCauKham = TestCommon.LEN_250,
TrieuChung = TestCommon.LEN_250,
NgayKham = TestCommon.LEN_8,
SoThuTu = 1,
MaPhongKham = TestCommon.LEN_10,
MaBacSi = TestCommon.LEN_10,
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
HOSOBENHAN hoSoBenhAnUpdate = new HOSOBENHAN
{
MaHoSo = TestCommon.LEN_10,
MaLoaiHoSo = TestCommon.LEN_10,
MaBenhNhan = TestCommon.LEN_10,
MaNguoiTN = TestCommon.LEN_10,
NgayTiepNhan = TestCommon.LEN_8,
YeuCauKham = TestCommon.LEN_250,
TrieuChung = TestCommon.LEN_250,
NgayKham = TestCommon.LEN_8,
SoThuTu = -1,
MaPhongKham = TestCommon.LEN_10,
MaBacSi = TestCommon.LEN_10
};
string actual = hoSoBenhAnBUS.UpdateHoSoBenhAn(db, hoSoBenhAnDTO);
string expected = "1111";
Assert.Equals(expected, actual);
}
// lấy danh sách chờ xét nghiệm
public string GetListHoSoKhamByPhong(string MaPhong, out List <HoSoBenhAnDTO> listHoSoBenhAn)
{
// lấy xét nghiệm dựa vào phòng
XetNghiemBUS xetNghiemBUS = new XetNghiemBUS();
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
XetNghiemDTO xetNghiemDTO = new XetNghiemDTO();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
if (xetNghiemBUS.GetXetNghiemByPhong(db, MaPhong, ref xetNghiemDTO) == Constant.RES_FAI)
{
listHoSoBenhAn = new List <HoSoBenhAnDTO>();
return(Constant.RES_FAI);
}
if (hoSoBenhAnBUS.GetListHoSoXN(db, xetNghiemDTO.MaXetNghiem, out listHoSoBenhAn) == Constant.RES_FAI)
{
listHoSoBenhAn = new List <HoSoBenhAnDTO>();
return(Constant.RES_FAI);
}
}
return(Constant.RES_SUC);
}
public void Update_TestCase3()
{
HoSoBenhAnDTO hoSoBenhAnDTO = new HoSoBenhAnDTO
{
MaHoSo = TestCommon.LEN_10,
MaLoaiHoSo = TestCommon.LEN_10,
MaBenhNhan = TestCommon.LEN_10,
};
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAnDTO);
HOSOBENHAN hoSoBenhAnUpdate = new HOSOBENHAN
{
MaHoSo = TestCommon.LEN_10,
};
string actual = hoSoBenhAnBUS.UpdateHoSoBenhAn(db, hoSoBenhAnDTO);
string expected = "1111";
Assert.Equals(expected, actual);
}
// Lưu thông tin Khám
public string KhamProcessing(HoSoBenhAnDTO hoSoBenhAn)
{
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
LuonCongViecBUS luonCongViecBUS = new LuonCongViecBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
LuonCongViecDTO luonCongViec = new LuonCongViecDTO();
try
{
luonCongViecBUS.GetInformationLuonCongViec(db, hoSoBenhAn.MaHoSo, out luonCongViec);
luonCongViec.NodeHienTai = BusConstant.NODE_HOAN_TAT;
luonCongViec.KhamBenh = true;
}
catch
{
return(Constant.RES_FAI);
}
using (var trans = db.Database.BeginTransaction())
{
if (hoSoBenhAnBUS.UpdateHoSoBenhAn(db, hoSoBenhAn).Equals(Constant.RES_FAI))
{
trans.Rollback();
return(Constant.RES_FAI);
}
if (luonCongViecBUS.UpdateLuonCongViec(db, luonCongViec).Equals(Constant.RES_FAI))
{
trans.Rollback();
return(Constant.RES_FAI);
}
trans.Commit();
}
db.SaveChanges();
}
return(Constant.RES_SUC);
}
public string SaveHoSo(HoSoBenhAnDTO hoSoBenhAn,
ThanhToanDTO thanhToan)
{
TrangThaiPhongDTO trangThaiPhong = null;
// get System date
string SystemDate = DateTime.Now.ToString("yyyyMMdd");
ThanhToanBUS thanhToanBUS = new ThanhToanBUS();
HoSoBenhAnBUS hoSoBenhAnBUS = new HoSoBenhAnBUS();
LuonCongViecBUS luonCongViecBUS = new LuonCongViecBUS();
TrangThaiPhongBUS trangThaiPhongBUS = new TrangThaiPhongBUS();
using (QLPHONGKHAMEntities db = new QLPHONGKHAMEntities())
{
// lấy trạng thái phòng
trangThaiPhongBUS.GetTrangThaiPhong(db, hoSoBenhAn.MaPhongKham, SystemDate, out trangThaiPhong);
trangThaiPhong.SttCaoNhat += 1;
// setting ho so
string maHoSo;
hoSoBenhAnBUS.CreateIdHoSoBenhAn(db, out maHoSo);
hoSoBenhAn.MaHoSo = maHoSo;
// nếu là hồ sơ tái khám
if (hoSoBenhAn.MaLoaiHoSo == BusConstant.HS_TAIKHAM)
{
HoSoBenhAnDTO root = new HoSoBenhAnDTO();
// get MaHoSoGoc
hoSoBenhAnBUS.GetRootHoSoBenhAn(db, hoSoBenhAn.MaHoSoTruoc, out root);
hoSoBenhAn.MaHoSoGoc = root.MaHoSoGoc;
}
hoSoBenhAn.SoThuTu = trangThaiPhong.SttCaoNhat;
// điền thông tin vào thanh toán
string MaThanhToan = "";
thanhToanBUS.CreateIdThanhToan(db, out MaThanhToan);
thanhToan.MaThanhToan = MaThanhToan;
thanhToan.TongChiPhi = thanhToan.ChiPhiKham;
thanhToan.MaHoSo = hoSoBenhAn.MaHoSo;
// điền thông tin Workflow
LuonCongViecDTO luonCongViec = new LuonCongViecDTO();
luonCongViec.MaHoSo = hoSoBenhAn.MaHoSo;
luonCongViec.NodeHienTai = BusConstant.NODE_KHAM;
luonCongViec.TiepNhan = true;
luonCongViec.XetNghiem = false;
luonCongViec.KhamBenh = false;
// Tạo transaction
using (var trans = db.Database.BeginTransaction())
{
// save hồ sơ
if (hoSoBenhAnBUS.AddHoSoBenhAn(db, hoSoBenhAn) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
// save luồn công việc
if (luonCongViecBUS.AddLuonCongViec(db, luonCongViec) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
// save thanh toán
if (thanhToanBUS.InsertThanhToan(db, thanhToan) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
// update Trang thanh phong
if (trangThaiPhongBUS.UpdateTrangThaiPhong(db, trangThaiPhong) == Constant.RES_FAI)
{
trans.Rollback();
return(Constant.RES_FAI);
}
trans.Commit();
}
db.SaveChanges();
}
return(Constant.RES_SUC);
}
