public void ThemThongTinCTHoaDon(eCTHoaDon newCTHD)
{
CTHoaDons temp = new CTHoaDons();
temp.MaHoaDon = newCTHD.MaHoaDon;
temp.MaLoThuoc = newCTHD.MaLoThuoc;
temp.DVT = newCTHD.DVT;
temp.SoLuong = newCTHD.SoLuong;
temp.GiaBan = newCTHD.GiaBan;
qt.CTHoaDons.InsertOnSubmit(temp);
qt.SubmitChanges();
}
public int ThemCTHD(eCTHoaDon cthd) // Thêm ct hóa đơn mới
{
CT_HoaDon temp = new CT_HoaDon();
temp.MaHoaDon = cthd.MaHoaDon;
temp.MaHopDong = cthd.MaHopDong;
temp.MaXe = cthd.MaXe;
temp.TenXe = cthd.TenXe;
temp.TienTT = decimal.Parse(cthd.TienTT.ToString());
temp.Gia = decimal.Parse(cthd.Gia.ToString());
db.CT_HoaDons.InsertOnSubmit(temp);
db.SubmitChanges();
return(1);
}
public List <eCTHoaDon> LayThongTinCTHoaDon()
{
var dsCTHoaDon = qt.CTHoaDons.ToList();
List <eCTHoaDon> dscthd = new List <eCTHoaDon>();
foreach (CTHoaDons item in dsCTHoaDon)
{
eCTHoaDon ct = new eCTHoaDon();
ct.MaHoaDon = item.MaHoaDon;
ct.MaLoThuoc = item.MaLoThuoc;
ct.DVT = item.DVT;
ct.SoLuong = item.SoLuong;
ct.GiaBan = item.GiaBan;
dscthd.Add(ct);
}
return(dscthd);
}
public List <eCTHoaDon> LayDulieu() // Lấy dữ liệu từ csdl sang lớp entity
{
var cthdlist = db.CT_HoaDons.ToList();
List <eCTHoaDon> ls = new List <eCTHoaDon>();
foreach (CT_HoaDon cthd in cthdlist)
{
eCTHoaDon t = new eCTHoaDon();
t.MaHoaDon = cthd.MaHoaDon;
t.MaHopDong = cthd.MaHopDong;
t.MaXe = cthd.MaXe;
t.TenXe = cthd.TenXe;
t.TienTT = double.Parse(cthd.TienTT.ToString());
t.Gia = double.Parse(cthd.Gia.ToString());
ls.Add(t);
}
return(ls);
}
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);
}
}
