private void btn_GoiKham_Click(object sender, EventArgs e)
{
try
{
int i = lst_ChoKham.SelectedIndex;
ePhieuKham bn = new ePhieuKham();
bn = (ePhieuKham)lst_ChoKham.Items[i];
MessageBox.Show("Đã gọi thành công");
lst_ChoKham.Items.RemoveAt(lst_ChoKham.SelectedIndex);
IConnectionFactory factory = new ConnectionFactory("tcp://localhost:61616");
IConnection con = factory.CreateConnection("admin", "admin");
con.Start();
ISession session = con.CreateSession(AcknowledgementMode.AutoAcknowledge);
ActiveMQTopic destination = new ActiveMQTopic("topicKiemTra");
IMessageProducer producer = session.CreateProducer(destination);
IMessage msg = new ActiveMQTextMessage(txtMaPhieu.Text.Trim());
producer.Send(msg);
session.Close();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi" + ex.Message);
}
}
private void TruyenData()
{
IConnectionFactory factory = new ConnectionFactory("tcp://localhost:61616");
IConnection con = factory.CreateConnection("admin", "admin");
con.Start();
ISession session = con.CreateSession(AcknowledgementMode.AutoAcknowledge);
ActiveMQTopic destination = new ActiveMQTopic("PhongKhamNhaKhoa");
IMessageProducer producer = session.CreateProducer(destination);
ePhieuKham p = new ePhieuKham();
p.idPhieuKham = idPhieuKham;
p.idNV = 1;
p.ngayDKKham = DateTime.Today;
p.tinhTrang = 1;
p.moTa = txtmota.Text.Trim();
p.idKH = Convert.ToInt32(idKhachHang);
string xml = new ObjectToXml <ePhieuKham>().object2XML(p);
IMessage msg = new ActiveMQTextMessage(xml);
producer.Send(msg);
session.Close();
con.Close();
}
private void btnGoiPhieuHen_Click(object sender, EventArgs e)
{
try
{
//ePhieuKham epk = new ePhieuKham();
int idphieu = idPhieuKham;
ePhieuKham epk = wcf_phieu.getPhieuKham_byID(idphieu);
epk.ngayDKKham = DateTime.Now;
int kq = wcf_phieu.UpdateTinhTrang_PhieuKham(epk, 1);
//int kq=wcf_phieu.AddPhieuKham(epk);
if (kq == 1)
{
MessageBox.Show("Goi phiếu khám phiếu hẹn thành công");
TruyenData();
this.Close();
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi" + ex.Message);
}
}
public List <ePhieuKham> getPhieuhen_TrongNgay()
{
List <PhieuKham> list = db.phieukhams.Select(x => x).ToList();
List <ePhieuKham> l = new List <ePhieuKham>();
foreach (var item in list)
{
int day = item.ngayDKKham.Day;
int month = item.ngayDKKham.Month;
int year = item.ngayDKKham.Year;
if (day == DateTime.Now.Day && month == DateTime.Now.Month && year == DateTime.Now.Year && item.tinhTrang == 2)
{
ePhieuKham p = new ePhieuKham();
p.idKH = item.idKH;
p.idNV = item.idNV;
p.idPhieuKham = item.idPhieuKham;
p.ngayDKKham = item.ngayDKKham;
p.tinhTrang = item.tinhTrang;
p.moTa = item.moTa;
l.Add(p);
}
}
return(l);
}
public int UpdateTinhTrang_PhieuKham(ePhieuKham epk, int tinhtrangnew)
{
PhieuKham temp = db.phieukhams.Where(x => x.idPhieuKham.Equals(epk.idPhieuKham)).FirstOrDefault();
temp.tinhTrang = tinhtrangnew;
return(db.SaveChanges());
}
private void CT_PhieuHen_Load(object sender, EventArgs e)
{
if (idKhachHang != 0)
{
eKhachHang k = wcf_kh.GetKhachHangs_byID(idKhachHang);
txtidkh.Text = k.idKH.ToString();
dtpns.Text = k.ngaySinh.ToString();
txttenkh.Text = k.tenKH;
txtdiachi.Text = k.diaChi;
txtsodt.Text = k.soDienThoai;
if (k.gioiTinh == true)
{
radnam.Checked = true;
}
else
{
radnam.Checked = true;
}
ePhieuKham p = wcf_phieu.getPhieuKham_byID(idPhieuKham);
txtmota.Text = p.moTa;
dtpngayhen.Text = p.ngayDKKham.ToString();
}
txtsodt.AutoCompleteMode = AutoCompleteMode.Suggest;
txtsodt.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
public void UpdatePhieuKham(ePhieuKham epk)
{
PhieuKham temp = db.phieukhams.Where(x => x.idPhieuKham.Equals(epk.idPhieuKham)).FirstOrDefault();
temp.moTa = epk.moTa;
temp.ngayDKKham = epk.ngayDKKham;
db.SaveChanges();
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
//cập nhật thông tin phiếu khám trong lịch hẹn
ePhieuKham pk = new ePhieuKham();
pk.idPhieuKham = idPhieuKham;
pk.moTa = txtmota.Text.Trim();
pk.ngayDKKham = dtpngayhen.Value;
if (pk.ngayDKKham > DateTime.Now)
{
wcf_phieu.UpdatePhieuKham(pk);
}
else
{
MessageBox.Show("Ngày hẹn khám phải >= ngày hiện tại");
return;
}
//cập nhật thông tin khách hàng trong lịch hẹn
eKhachHang k = new eKhachHang();
k.idKH = idKhachHang;
k.ngaySinh = dtpns.Value;
k.tenKH = txttenkh.Text.ToString();
k.soDienThoai = txtsodt.Text.ToString();
k.diaChi = txtdiachi.Text.ToString();
if (radnam.Checked == true)
{
k.gioiTinh = true;
}
else
{
k.gioiTinh = false;
}
int tuoi = DateTime.Now.Year - k.ngaySinh.Year;
if (k.ngaySinh < DateTime.Now)
{
if ((tuoi > 1))
{
wcf_kh.UpdateKhachHang(k);
}
else
{
MessageBox.Show("Khách hàng phải > 1 tuổi");
return;
}
}
else
{
MessageBox.Show("Ngày sinh của khách hàng phải < ngày hiện tại");
return;
}
}
public int AddPhieuKham(ePhieuKham epk)
{
PhieuKham item = new PhieuKham();
item.idKH = epk.idKH;
item.idNV = epk.idNV;
item.moTa = epk.moTa;
item.ngayDKKham = epk.ngayDKKham;
item.tinhTrang = epk.tinhTrang;
db.phieukhams.Add(item);
return(db.SaveChanges());
}
public ePhieuKham getPhieuKham_byID(int id)
{
PhieuKham kh = db.phieukhams.Where(x => x.idPhieuKham == id).FirstOrDefault();
ePhieuKham k = new ePhieuKham();
k.idKH = kh.idKH;
k.moTa = kh.moTa;
k.idNV = kh.idNV;
k.idPhieuKham = kh.idPhieuKham;
k.ngayDKKham = kh.ngayDKKham;
k.tinhTrang = kh.tinhTrang;
return(k);
}
private void Consumerkt_Listener(IMessage message)
{
if (message is ActiveMQTextMessage)
{
ActiveMQTextMessage msg = message as ActiveMQTextMessage;
foreach (var item in lst_ChoKham.Items)
{
ePhieuKham bn = (ePhieuKham)item;
if (bn.idPhieuKham.Equals(msg.Text))
{
lst_ChoKham.Items.Remove(item);
}
}
}
}
private void lst_ChoKham_SelectedIndexChanged(object sender, EventArgs e)
{
int i = lst_ChoKham.SelectedIndex;
if (i == -1)
{
return;
}
ePhieuKham bn = new ePhieuKham();
bn = (ePhieuKham)lst_ChoKham.Items[i];
eKhachHang kh = khachHangWCFClient.GetKhachHangs_byID(bn.idKH);
txtKB_maBN.Text = bn.idKH.ToString();
txtKB_hoten.Text = kh.tenKH;
txtKB_mota.Text = bn.moTa;
txtMaPhieu.Text = bn.idPhieuKham.ToString();
}
private void btnTaoPhieuHen_Click(object sender, EventArgs e)
{
try
{
ePhieuKham epk = new ePhieuKham();
epk.idKH = Convert.ToInt32(txtidkh.Text.Trim());
epk.idNV = 1;
epk.moTa = txtmota.Text.Trim();
epk.ngayDKKham = dtpngayhen.Value;
epk.tinhTrang = 2; // tinh trang cua phieu hen
wcf_phieu.AddPhieuKham(epk);
MessageBox.Show("Thêm phiếu hen thành công");
// loaddatagridview_dsphieukham_trongngay(dvwDSBNKham, wcf_phieu.getPhieuKham_theoNgay().ToList());
}
catch (Exception ex)
{
MessageBox.Show("Lỗi" + ex.Message);
}
}
public void AddItem(ListBox box, ePhieuKham item)
{
item.truyenMa = khachHangWCFClient.GetKhachHangs_byID(item.idKH).tenKH + "_" + item.idKH;
MethodInvoker miAddItem = delegate
{
box.Items.Add(item);
box.DisplayMember = "truyenMa";
box.ValueMember = "idPhieuKham";
};
if (box.InvokeRequired)
{
box.Invoke(miAddItem);
}
else
{
miAddItem();
}
}
private void btnThemKham_Click(object sender, EventArgs e)
{
try
{
ePhieuKham epk = new ePhieuKham();
epk.idKH = Convert.ToInt32(txtMaKH.Text.Trim());
epk.idNV = 1;
epk.moTa = txtLyDoKham.Text.Trim();
epk.ngayDKKham = DateTime.Today;
epk.tinhTrang = 1;
wcf_phieu.AddPhieuKham(epk);
MessageBox.Show("Thêm phiếu khám thành công");
TruyenData();
loaddatagridview_dsphieukham_trongngay(dvwDSBNKham, wcf_phieu.getPhieuKham_theoNgay().ToList());
}
catch (Exception ex)
{
MessageBox.Show("Lỗi" + ex.Message);
}
}
public List <ePhieuKham> getPhieuhen_TimKiem(DateTime datefrom, DateTime dateto)
{
List <PhieuKham> list = db.phieukhams.Select(x => x).ToList();
List <ePhieuKham> l = new List <ePhieuKham>();
foreach (var item in list)
{
if (item.tinhTrang == 2 && (item.ngayDKKham >= datefrom) && (item.ngayDKKham <= dateto))
{
ePhieuKham p = new ePhieuKham();
p.idKH = item.idKH;
p.idNV = item.idNV;
p.idPhieuKham = item.idPhieuKham;
p.ngayDKKham = item.ngayDKKham;
p.tinhTrang = item.tinhTrang;
p.moTa = item.moTa;
l.Add(p);
}
}
return(l);
}
public List <ePhieuKham> getPhieuhen()
{
List <PhieuKham> list = db.phieukhams.Select(x => x).ToList();
List <ePhieuKham> l = new List <ePhieuKham>();
foreach (var item in list)
{
if (item.ngayDKKham > DateTime.Today && item.tinhTrang == 2)
{
ePhieuKham p = new ePhieuKham();
p.idKH = item.idKH;
p.idNV = item.idNV;
p.idPhieuKham = item.idPhieuKham;
p.ngayDKKham = item.ngayDKKham;
p.tinhTrang = item.tinhTrang;
p.moTa = item.moTa;
l.Add(p);
}
}
return(l);
}
