public QuanLyNguoiNhanMau GetNguoiNhanById(int id)
{
QuanLyNguoiNhanMau qlm = new QuanLyNguoiNhanMau();
foreach (var bn in db.dtb_quanlymaus)
{
if (bn.id == id)
{
QuanLyNguoiNhanMau x = new QuanLyNguoiNhanMau();
x.Id = bn.id;
x.MaMau = bn.ma_nguoi_hien;
x.PheDuyet = Convert.ToBoolean(bn.is_approve);
x.NgayLuuTru = Convert.ToDateTime(bn.ngay_luu_tru);
x.NgaySuDung = Convert.ToDateTime(bn.ngay_su_dung);
x.MaNguoiNhan = bn.ma_nguoi_nhan;
x.KetQuaSuDung = bn.ket_qua_su_dung;
x.HuyMau = Convert.ToBoolean(bn.huy_mau);
x.NgayHuyMau = Convert.ToDateTime(bn.ngay_huy_mau);
x.GhiChu = bn.ghi_chu;
return(x);
}
}
return(null);
}
public void AddNguoiNhanMau(QuanLyNguoiNhanMau bn)
{
dtb_quanlymau qlm = new dtb_quanlymau();
qlm.ma_nguoi_hien = bn.MaMau;
qlm.is_approve = bn.PheDuyet;
qlm.ngay_luu_tru = bn.NgayLuuTru;
qlm.ngay_su_dung = bn.NgaySuDung;
qlm.ma_nguoi_nhan = bn.MaNguoiNhan;
qlm.ket_qua_su_dung = bn.KetQuaSuDung;
qlm.huy_mau = bn.HuyMau;
qlm.ngay_huy_mau = bn.NgayHuyMau;
qlm.ghi_chu = bn.GhiChu;
db.dtb_quanlymaus.InsertOnSubmit(qlm);
db.SubmitChanges();
}
public void EditNguoiNhanMau(int id, QuanLyNguoiNhanMau bn)
{
List <dtb_quanlymau> listQLMs = (from s in db.dtb_quanlymaus select s).ToList();
foreach (var qlm in listQLMs)
{
if (qlm.id == id)
{
qlm.ma_nguoi_hien = bn.MaMau;
qlm.is_approve = bn.PheDuyet;
qlm.ngay_luu_tru = bn.NgayLuuTru;
qlm.ngay_su_dung = bn.NgaySuDung;
qlm.ma_nguoi_nhan = bn.MaNguoiNhan;
qlm.ket_qua_su_dung = bn.KetQuaSuDung;
qlm.huy_mau = bn.HuyMau;
qlm.ngay_huy_mau = bn.NgayHuyMau;
qlm.ghi_chu = bn.GhiChu;
db.SubmitChanges();
}
}
}
public List <QuanLyNguoiNhanMau> GetAllNguoiNhanMau()
{
List <QuanLyNguoiNhanMau> listQLM = new List <QuanLyNguoiNhanMau>();
foreach (var bn in db.dtb_quanlymaus)
{
QuanLyNguoiNhanMau x = new QuanLyNguoiNhanMau();
x.Id = bn.id;
x.MaMau = bn.ma_nguoi_hien;
x.PheDuyet = Convert.ToBoolean(bn.is_approve);
x.NgayLuuTru = Convert.ToDateTime(bn.ngay_luu_tru);
x.NgaySuDung = Convert.ToDateTime(bn.ngay_su_dung);
x.MaNguoiNhan = bn.ma_nguoi_nhan;
x.KetQuaSuDung = bn.ket_qua_su_dung;
x.HuyMau = Convert.ToBoolean(bn.huy_mau);
x.NgayHuyMau = Convert.ToDateTime(bn.ngay_huy_mau);
x.GhiChu = bn.ghi_chu;
listQLM.Add(x);
}
return(listQLM);
}
private void QL_sgQuanLyNguoiNhan_CellValueChanged(object sender, GridCellValueChangedEventArgs e)
{
if (e.GridCell.GridRow["PheDuyet"].Value != null | e.GridCell.GridRow["NgayLuuTru"].Value != null)
{
if (!e.GridCell.GridColumn.AllowEdit)
{
return;
}
}
var maBN = e.GridCell.GridRow["MaMau"].Value;
if (maBN == null)
{
MessageBox.Show("Bạn cần nhập mã bệnh nhân hiến trước khi làm tiếp", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
foreach (var bn in listNHTs)
{
if ((string)maBN == bn.MaBN)
{
e.GridCell.GridRow["PheDuyet"].Value = bn.FlagApprove;
e.GridCell.GridRow["NgayLuuTru"].Value = bn.NgayTao;
}
}
var id = e.GridCell.GridRow["Id"].Value;
if (id == null | Convert.ToInt32(id) == 0)
{
QuanLyNguoiNhanMau bn = new QuanLyNguoiNhanMau();
bn.MaMau = Convert.ToString(maBN);
var pheduyet = e.GridCell.GridRow["PheDuyet"].Value;
bn.PheDuyet = Convert.ToBoolean(pheduyet);
var ngayluutru = e.GridCell.GridRow["NgayLuuTru"].Value;
bn.NgayLuuTru = Convert.ToDateTime(ngayluutru);
var ngaysudung = e.GridCell.GridRow["NgaySuDung"].Value;
bn.NgaySuDung = Convert.ToDateTime(ngaysudung);
var manguoinhan = e.GridCell.GridRow["MaNguoiNhan"].Value;
bn.MaNguoiNhan = Convert.ToString(manguoinhan);
var ketqua = e.GridCell.GridRow["KetQuaSuDung"].Value;
bn.KetQuaSuDung = Convert.ToString(ketqua);
var huymau = e.GridCell.GridRow["HuyMau"].Value;
bn.HuyMau = Convert.ToBoolean(huymau);
var ngayhuymau = e.GridCell.GridRow["NgayHuyMau"].Value;
bn.NgayHuyMau = Convert.ToDateTime(ngayhuymau);
var ghichu = e.GridCell.GridRow["GhiChu"].Value;
bn.GhiChu = Convert.ToString(ghichu);
dbQL.AddNguoiNhanMau(bn);
FillData();
}
else
{
QuanLyNguoiNhanMau bn = dbQL.GetNguoiNhanById(Convert.ToInt32(id));
bn.MaMau = Convert.ToString(maBN);
var pheduyet = e.GridCell.GridRow["PheDuyet"].Value;
bn.PheDuyet = Convert.ToBoolean(pheduyet);
var ngayluutru = e.GridCell.GridRow["NgayLuuTru"].Value;
bn.NgayLuuTru = Convert.ToDateTime(ngayluutru);
var ngaysudung = e.GridCell.GridRow["NgaySuDung"].Value;
bn.NgaySuDung = Convert.ToDateTime(ngaysudung);
var manguoinhan = e.GridCell.GridRow["MaNguoiNhan"].Value;
bn.MaNguoiNhan = Convert.ToString(manguoinhan);
var ketqua = e.GridCell.GridRow["KetQuaSuDung"].Value;
bn.KetQuaSuDung = Convert.ToString(ketqua);
var huymau = e.GridCell.GridRow["HuyMau"].Value;
bn.HuyMau = Convert.ToBoolean(huymau);
var ngayhuymau = e.GridCell.GridRow["NgayHuyMau"].Value;
bn.NgayHuyMau = Convert.ToDateTime(ngayhuymau);
var ghichu = e.GridCell.GridRow["GhiChu"].Value;
bn.GhiChu = Convert.ToString(ghichu);
dbQL.EditNguoiNhanMau(Convert.ToInt32(id), bn);
FillData();
}
}
}
