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); } }