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