public void Reset()
{
hoaDon = new eHoaDon();
hoaDon.maHoaDon = (ser.GetAllHoaDon().Max(t => t.maHoaDon) + 1);
hoaDon.maNhanVien = nhanVien.maNhanVien;
lstChiTiet = new List <eChiTietHoaDon>();
tbMaHD.Text = hoaDon.maHoaDon.ToString();
dateNgayLap.Value = DateTime.Now;
LoadDatagrib(ser.SearchDia("", "", "").ToList());
eChiTietHoaDonBindingSource.DataSource = lstChiTiet;
}
public bool AddHoaDon(eHoaDon x, List <eChiTietHoaDon> lst)
{
using (TransactionScope scope = new TransactionScope())
{
try
{
HoaDon hoaDon = new HoaDon();
hoaDon.MaHoaDon = x.maHoaDon;
hoaDon.MaNhanVien = x.maNhanVien;
hoaDon.LoaiHoaDon = x.loaiHoaDon;
hoaDon.MaNhanVien = x.maNhanVien;
hoaDon.NgayLapHoaDon = x.ngayLapHD;
hoaDon.TongTien = x.tongTien;
int idCTHD = 1;
if (db.ChiTietHoaDons.Any())
{
idCTHD = db.ChiTietHoaDons.Max(a => a.MaChiTietHD) + 1;
}
foreach (eChiTietHoaDon item in lst)
{
ChiTietHoaDon cthd = new ChiTietHoaDon();
cthd.MaDia = item.maDia;
cthd.MaChiTietHD = idCTHD;
cthd.MaHoaDon = hoaDon.MaHoaDon;
cthd.SoLuong = item.soLuong;
cthd.HoaDon = hoaDon;
cthd.ThanhTien = item.thanhTien;
db.ChiTietHoaDons.Add(cthd);
if (x.loaiHoaDon == "Bán")
{
var dia = db.Dias.FirstOrDefault(s => s.MaDia == cthd.MaDia);
dia.SoLuong -= cthd.SoLuong;
db.Entry(dia).State = System.Data.Entity.EntityState.Modified;
}
else
{
var dia = db.Dias.FirstOrDefault(s => s.MaDia == cthd.MaDia);
dia.SoLuong += cthd.SoLuong;
db.Entry(dia).State = System.Data.Entity.EntityState.Modified;
}
idCTHD++;
}
db.HoaDons.Add(hoaDon);
db.SaveChanges();
scope.Complete();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public void ThemThongTinHoaDon(eHoaDon newHD)
{
HoaDons temp = new HoaDons();
temp.MaHoaDon = newHD.MaHoaDon;
temp.MaDonThuoc = newHD.MaDonThuoc;
temp.MaBenhNhan = newHD.MaBenhNhan;
temp.MaNhanVien = newHD.MaNhanVien;
temp.NgayLapHD = newHD.NgayLapHD;
temp.TongTien = newHD.TongTien;
qt.HoaDons.InsertOnSubmit(temp);
qt.SubmitChanges();
}
public bool suaTrangThaiHoaDon(eHoaDon hd, int maHD)
{
eHoaDon hd1 = new eHoaDon();
var q = db.HoaDons.Where(a => a.maHoaDon == maHD).SingleOrDefault();
if (hd1 != null)
{
// hd1.maHoaDon = hd.maHoaDon;
hd1.TrangThai = q.trangThai;
db.SubmitChanges();
return(true);
}
return(false);
}
public bool themHoaDon(eHoaDon hd)
{
if (!DanhSachHoadon().Contains(hd))
{
HoaDon hd1 = new HoaDon();
hd1.maHoaDon = hd.MaHoaDon;
hd1.ngayThanhToan = hd.NgayThanhToan;
hd1.tongTienThanhToan = hd.TongTienThanhToan;
hd1.trangThai = hd.TrangThai;
hd1.maNhanVien = hd.MaNhanVien;
hd1.maBan = hd.MaBan;
db.HoaDons.InsertOnSubmit(hd1);
db.SubmitChanges();
return(true);
}
return(false);
}
public int ThemHoaDon(eHoaDon hd) // Thêm hóa đơn mới
{
HoaDon t = new HoaDon();
t.MaHoaDon = hd.MaHoaDon;
t.MaKH = hd.MaKH;
t.MaNV = hd.MaNV;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.KhuyenMai = float.Parse(hd.KhuyenMai.ToString());
t.SdtKH = hd.SoDT;
t.TienThanhToan = decimal.Parse(hd.TienThanhToan.ToString());
t.TongTien = decimal.Parse(hd.TongTien.ToString());
db.HoaDons.InsertOnSubmit(t);
db.SubmitChanges();
return(1);
}
public List <eHoaDon> LayThongTinHoaDon()
{
var dsHoaDon = qt.HoaDons.ToList();
List <eHoaDon> dshd = new List <eHoaDon>();
foreach (HoaDons item in dsHoaDon)
{
eHoaDon hd = new eHoaDon();
hd.MaHoaDon = item.MaHoaDon;
hd.MaDonThuoc = item.MaDonThuoc;
hd.MaBenhNhan = item.MaBenhNhan;
hd.MaNhanVien = item.MaNhanVien;
hd.NgayLapHD = item.NgayLapHD;
hd.TongTien = item.TongTien;
dshd.Add(hd);
}
return(dshd);
}
public List <eHoaDon> LayDuLieu()
{
var hdlist = db.HoaDons.ToList();
List <eHoaDon> ls = new List <eHoaDon>();
foreach (HoaDon hd in hdlist)
{
eHoaDon t = new eHoaDon();
t.MaHoaDon = hd.MaHoaDon;
t.MaKH = hd.MaKH;
t.MaNV = hd.MaNV;
t.NgayLap = DateTime.Parse(hd.NgayLap.ToString());
t.TenKH = hd.TenKH;
t.TenNV = hd.TenNV;
t.KhuyenMai = float.Parse(hd.KhuyenMai.ToString());
t.TienThanhToan = double.Parse(hd.TienThanhToan.ToString());
t.TongTien = double.Parse(hd.TongTien.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);
}
}
