private void btnLapHoaDon_Click(object sender, EventArgs e) { dsHoaDon = hoadonBLL.LayThongTinHoaDon(); dsLoThuoc = loThuocBLL.LayThongTinLoThuoc(); dsBenhNhan = benhnhanBLL.LayThongTinBenhNhan(); var timkiemBN = dsBenhNhan.Where(w => w.TenBenhNhan.Equals(txtBenhNhan.Text)).ToList(); eHoaDon newHD = new eHoaDon(); eBenhNhan newBN = new eBenhNhan(); if (dsHoaDon.Count == 0) { newHD.MaHoaDon = "1"; } else { newHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newHD.MaNhanVien = "1"; if (timkiemBN.Count == 0) { newHD.MaBenhNhan = newBN.MaBenhNhan = (dsBenhNhan.Count + 1).ToString(); newBN.TenBenhNhan = txtBenhNhan.Text; newBN.NamSinh = Convert.ToInt32(txtNamSinh.Text); newBN.SDT = txtSDT.Text; newBN.DiaChi = cbbTP.Text; if (rdNam.Checked == true) { newBN.GioiTinh = "nam"; } else { newBN.GioiTinh = "nu"; } benhnhanBLL.ThemThongTinBenhNhan(newBN); } else { newHD.MaBenhNhan = timkiemBN.First().MaBenhNhan; } newHD.NgayLapHD = DateTime.Now; newHD.TongTien = Convert.ToDecimal(lblTongTien.Text); newHD.MaDonThuoc = null; hoadonBLL.ThemThongTinHoaDon(newHD); for (int i = 0; i < dgvThuocDaChon.Rows.Count; i++) { var loThuocTimKiem = dsLoThuoc.Where(w => w.MaLoThuoc.Equals(dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString())); eCTHoaDon newCTHD = new eCTHoaDon(); if (dsHoaDon.Count == 0) { newCTHD.MaHoaDon = "1"; } else { newCTHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newCTHD.MaLoThuoc = dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString(); newCTHD.DVT = dgvThuocDaChon.Rows[i].Cells["DVT"].Value.ToString(); newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChon.Rows[i].Cells["soluongcol"].Value)); newCTHD.GiaBan = Convert.ToDecimal((dgvThuocDaChon.Rows[i].Cells["dongiacol"].Value)); loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString(), loThuocTimKiem.First().SoLuong - Convert.ToInt32((dgvThuocDaChon.Rows[i].Cells["soluongcol"].Value))); cthdBLL.ThemThongTinCTHoaDon(newCTHD); } MessageBox.Show("Tao Hoa Don Thanh Cong"); LoadSauKhiLapHD(); HienThiLoThuoc(); }
private void btnLapHoaDonKD_Click(object sender, EventArgs e) { try { dsHoaDon = hoadonBLL.LayThongTinHoaDon().OrderBy(o => o.MaHoaDon).ToList(); dsBenhNhan = benhnhanBLL.LayThongTinBenhNhan(); dsLoThuoc = loThuocBLL.LayThongTinLoThuoc(); var timKiemBN = dsBenhNhan.Where(w => w.TenBenhNhan.Equals(txtTenKhachHangKD.Text)).ToList(); eHoaDon newHD = new eHoaDon(); if (dsHoaDon.Count == 0) { newHD.MaHoaDon = "1"; } else { newHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newHD.MaNhanVien = "1"; newHD.MaBenhNhan = timKiemBN.First().MaBenhNhan; newHD.NgayLapHD = DateTime.Now; newHD.TongTien = Convert.ToDecimal(lblTongTienKD.Text); newHD.MaDonThuoc = dgvDanhSachDonThuocKD.SelectedCells[0].OwningRow.Cells["MaDonThuoc"].Value.ToString(); hoadonBLL.ThemThongTinHoaDon(newHD); for (int i = 0; i < dgvThuocDaChonKD.Rows.Count; i++) { Check(dgvThuocDaChonKD.Rows[i].Cells["dongiacol"].Value.ToString()); var timKiemLT = dsLoThuoc.Where(w => w.MaLoThuoc.Equals(dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString())).ToList(); eCTHoaDon newCTHD = new eCTHoaDon(); if (dsHoaDon.Count == 0) { newCTHD.MaHoaDon = "1"; } else { newCTHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newCTHD.MaLoThuoc = dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString(); newCTHD.DVT = dgvThuocDaChonKD.Rows[i].Cells["DVT"].Value.ToString(); if ((int)dgvThuocDaChonKD.Rows[i].Cells["SoLuong"].Value <= (int)dgvThuocDaChonKD.Rows[i].Cells["slton"].Value) { newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["SoLuong"].Value)); loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString(), timKiemLT.First().SoLuong - Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["SoLuong"].Value))); } else { newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["slton"].Value)); loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString(), timKiemLT.First().SoLuong - Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["slton"].Value))); } newCTHD.GiaBan = Convert.ToDecimal((dgvThuocDaChonKD.Rows[i].Cells["dongiacol"].Value)); cthdBLL.ThemThongTinCTHoaDon(newCTHD); MessageBox.Show("Tao Hoa Don Thanh Cong"); btnTaoLaiKD_Click(sender, e); UCBanThuocKeDon_Load(sender, e); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }