private void guna2Button2_Click(object sender, EventArgs e)
{
using (var context = new YTeDbContext())
{
var phongKham = context.PhongKhams.Where(s => s.TenPhongKham == phongkham).FirstOrDefault();
var People = context.DatLichKhams.Where(s => s.ID_PhongKham == phongKham.ID_PhongKham).FirstOrDefault();
var people = new ConNguoi();
{
people.HoTen = txtHoTen.Text;
people.SoCMND = txtCMND.Text;
people.SoDienThoai = txtSDT.Text;
people.Email = txtEmail.Text;
people.DiaChi = txtDiaChi.Text;
// people.GioiTinh = cbGioiTinh.Text;
}
context.ConNguois.Add(people);
context.SaveChanges();
var connguoi = new DatLichKham();
{
connguoi.GhiChu = txtGhiChu.Text;
connguoi.LyDoKham = txtLyDoKham.Text;
connguoi.ID_PhongKham = People.ID_PhongKham;
}
context.DatLichKhams.Add(connguoi);
context.SaveChanges();
}
}
public int timchotrong(DateTime dt, string PK)
{
using (var context = new YTeDbContext())
{
var pk = context.PhongKhams.Where(s => s.TenPhongKham == PK).FirstOrDefault();
var listdatlich = context.DatLichKhams.Where(s => s.ThoiGianHenKham == dt && s.ID_PhongKham == pk.ID_PhongKham).ToList();
return(listdatlich.Count);
}
}
public List <String> listphongkham()
{
using (var context = new YTeDbContext())
{
var phongkhams = context.PhongKhams.ToList();
List <String> tenphongkham = new List <string>();
foreach (var i in phongkhams)
{
tenphongkham.Add(i.TenPhongKham);
}
var p = new HashSet <String>(tenphongkham);
return(p.ToList());
}
}
private void guna2Button1_Click_1(object sender, EventArgs e)
{
using (var context = new YTeDbContext())
{
var people = context.ConNguois.Where(s => s.SoDienThoai == c).FirstOrDefault();
if (people == null)
{
MessageBox.Show("Không tìm thấy bệnh nhân!");
}
else
{
MessageBox.Show("ID bệnh nhân đã xóa: " + people.ID_Nguoi.ToString(), "Thông báo!");
}
var people1 = context.DatLichKhams.Where(s => s.ID_Nguoi == people.ID_Nguoi).FirstOrDefault();
context.DatLichKhams.Remove(people1);
context.SaveChanges();
LoadingTable ld = new LoadingTable();
dataGridView1.DataSource = ld.datlichkham();
}
}
private void guna2Button2_Click_1(object sender, EventArgs e)
{
if (txtBHYT.Text != "" && txtCMND.Text == "")
{
using (var context = new YTeDbContext())
{
var people = context.TreEms.Where(s => s.MaTheBHYTe == txtBHYT.Text).FirstOrDefault();
if (people == null)
{
MessageBox.Show("Sai thông tin!", "Thông báo!");
}
else
{
this.Hide();
FormDanhSachDatLich f = new FormDanhSachDatLich();
f.BHYT = people.MaTheBHYTe;
f.Show();
this.Close();
}
}
}
if (txtCMND.Text != "" && txtBHYT.Text == "")
{
using (var context = new YTeDbContext())
{
var people = context.ConNguois.Where(s => s.SoCMND == txtCMND.Text).FirstOrDefault();
if (people == null)
{
MessageBox.Show("Sai thông tin!", "Thông báo!");
}
else
{
this.Hide();
FormDanhSachDatLich f = new FormDanhSachDatLich();
f.SoCMND = people.SoCMND;
f.Show();
}
}
}
}
private void guna2Button2_Click(object sender, EventArgs e)
{
using (var context = new YTeDbContext())
{
var oldconnguoi = context.ConNguois.Where(s => s.SoDienThoai == c).FirstOrDefault();
var oldpeople = context.DatLichKhams.Where(s => s.ID_Nguoi == oldconnguoi.ID_Nguoi).FirstOrDefault();
{
oldpeople.LyDoKham = textboxLyDoKham.Text;
// oldpeople.ThoiGianHenKham = guna2DateTimePicker1.Value.ToString();
oldconnguoi.HoTen = textboxHoTen.Text;
oldconnguoi.SoCMND = textboxCMND.Text;
oldconnguoi.SoDienThoai = textboxSDT.Text;
oldconnguoi.DiaChi = textboxDiaChi.Text;
oldconnguoi.Email = textboxEmail.Text;
}
context.SaveChanges();
LoadingTable ld = new LoadingTable();
dataGridView1.DataSource = ld.datlichkham();
MessageBox.Show(oldconnguoi.DiaChi);
MessageBox.Show(oldpeople.LyDoKham);
MessageBox.Show(oldpeople.ID_Nguoi + " " + oldconnguoi.ID_Nguoi);
}
}
