public int GetidhdbySDTanddate(string sdt, DateTime date)
{
int id = 0;
string query = "EXEC dbo.USB_GetIDHDbyDateAndSDT @sdt , @date";
DataTable dt = DataProvider.Instance.ExecureQuery(query, new object[] { sdt, date });
if (dt.Rows.Count == 0)
{
return(-1);
}
else
{
List <Hoadon> listhd = new List <Hoadon>();
foreach (DataRow item in dt.Rows)
{
Hoadon hd = new Hoadon(item);
listhd.Add(hd);
}
id = listhd[0].Id;
for (int i = 0; i < listhd.Count; i++)
{
if (listhd[i].Id > id)
{
id = listhd[i].Id;
}
}
}
return(id);
}
public void Execute()
{
Hoadon check = null;
using (var repo = new HoadonViewRepository())
{
repo.HoadonId = this.item.HoadonId;
check = repo.Execute();
}
if (check != null) //đã tồn tại
{
using (var repo = new HoadonUpdateRepository())
{
repo.item = this.item;
repo.Execute();
}
}
else
{
using (var repo = new HoadonInsertRepository())
{
repo.item = this.item;
repo.Execute();
}
}
}
private void tsbEdit_Click(object sender, EventArgs e)
{
if (txtMahoadon.Text == "")
{
MessageBox.Show("Chưa nhập đủ thông tin!");
return;
}
Hoadon hd = new Hoadon();
hd.mahd = txtMahoadon.Text;
hd.ngaynhap = dateNgaynhap.Value;
hd.matt = cbxMathuthu.Text;
if (MessageBox.Show(string.Format("Bạn có muốn sửa mã hóa đơn {0} ", hd.mahd),
"", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (Bus.UpdateHoadon(hd) > 0)
{
MessageBox.Show("Sửa thành công!");
HoaDon_Load(sender, e);
}
else
{
MessageBox.Show("Lỗi");
}
}
}
public void AddOrder(string currentusername, Hoadon Order, List <Item> cart, Chitiethoadon OrderDetail)
{
int customerid = _unitOfWork.Nhanviens.GetIdNhanvien(currentusername);
Order.NhanvienId = customerid;
Order.Ngaylap = DateTime.Now;
//add Order
var orderAdded = _unitOfWork.Hoadons.Add(Order);
_unitOfWork.Complete(); //save
//add item
for (var i = 0; i < cart.Count; i++)
{
//them vao bang OrderDetail
OrderDetail = new Chitiethoadon();
OrderDetail.ChitiethoadonId = cart[i].Product.MonanId;
OrderDetail.ChitiethoadonId = orderAdded.HoadonId; //orderid
OrderDetail.Soluong = cart[i].Quantity;
_unitOfWork.ChitietHoadons.Add(OrderDetail);
_unitOfWork.Complete();//luu database
}
cart.Clear(); //xoa gio hang
}
public List <Hoadon> timhd(Hoadon h)
{
List <Hoadon> list = Lhoadon();
List <Hoadon> hd = new List <Hoadon>();
if (!string.IsNullOrEmpty(h.Maph))
{
hd = list;
}
if (!string.IsNullOrEmpty(h.Maph))
{
for (int i = 0; i < list.Count; i++)
{
if (list[i].Maph.IndexOf(h.Maph) >= 0)
{
hd.Add(new Hoadon(list[i]));
}
}
}
else
{
hd = null;
}
return(hd);
}
public async Task <IActionResult> CreateInvoce(InvoceModel model)
{
// Tach tao hoa don ra rieng de nhin va de tranh loi null
Hoadon HDtoADD = HoadonCreator(model);
List <Chitiethd> chitiethds = new List <Chitiethd>();
// Lay danh sach san pham trong cart
var cartLst = await _context.Carts.Include(sp => sp.Sp).ToListAsync();
foreach (Carts item in cartLst)
{
// Tao chi tiet hoa don vs san pham vaf thong tin trong cart
Chitiethd chitiet = new Chitiethd()
{
IdHd = HDtoADD.Idhoadon,
IdSp = item.SpId,
GiaSp = item.Sp.GiaSp,
Soluong = item.Quantity.Value.ToString(),
};
chitiethds.Add(chitiet);
}
_context.Carts.RemoveRange(cartLst);
_context.Hoadon.Add(HDtoADD);
_context.Chitiethd.AddRange(chitiethds);
await _context.SaveChangesAsync();
ViewData["Message"] = "Đã lưu thông tin Hóa Đơn, mã hóa đơn của bạn là " + HDtoADD.Idhoadon.ToString();
return(RedirectToAction("Index", "HoaDon"));
}
public void LuuHD(Hoadon hoadon)
{
using (QLKhachsanEntities entity = new QLKhachsanEntities())
{
entity.LuuHoaDon(hoadon.Tienphong, hoadon.Tiendichvu, hoadon.VAT, hoadon.Khuyenmai, hoadon.Ngaylap, hoadon.IDDAT);
}
}
public Hoadon Execute()
{
Hoadon data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM Hoadon WHERE HoadonId = @HoadonId";
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@HoadonId", Value = this.HoadonId, SqlDbType = System.Data.SqlDbType.NVarChar
});
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data = new Hoadon
{
HoadonId = Convert.ToString(reader["HoadonId"].vSafe()),
NhanvienId = Convert.ToString(reader["NhanvienId"].vSafe()),
NgayHoadon = Convert.ToDateTime(reader["NgayHoadon"].vSafe()),
Tongtien = Convert.ToInt64(reader["Tongtien"].vSafe()),
Ghichu = Convert.ToString(reader["Ghichu"].vSafe())
};
}
}
}
conn.Close();
}
return(data);
}
public IActionResult DoCheckOut(Hoadon hd)
{
Khachhang kh = db.Khachhang.Where(x => x.Email == HttpContext.Session.Get <string>("user")).SingleOrDefault();
hd.Makh = kh.Makh;
hd.Matrangthai = 1;
hd.Ngaydat = DateTime.Now;
hd.Ngaygiao = DateTime.Now.AddDays(7);
hd.Cachthanhtoan = hd.Cachthanhtoan;
db.Hoadon.Add(hd);
db.SaveChanges();
int hoadonid = db.Hoadon.OrderByDescending(x => x.Mahd).ToList()[0].Mahd;
List <CartItem> chitiet = HttpContext.Session.Get <List <CartItem> >("gioHang");
foreach (var x in chitiet)
{
Chitiethoadon ct = new Chitiethoadon
{
Mahd = hoadonid,
Mahh = x.Masp,
Soluong = x.Soluong,
Dongia = x.Dongia,
Giamgia = x.Giamgia
};
db.Chitiethoadon.Add(ct);
}
db.SaveChanges();
HttpContext.Session.Set("gioHang", "");
return(View("CheckOut", db.Hoadon.Where(x => x.Mahd == hoadonid).SingleOrDefault()));
}
public void addTblHD()
{
var context = new Dtb_NhaSachContext();
var maNv = context.Nhanviens.Where(s => s.TenNv.Trim() == this.cbbTenNv.Text.Trim())
.Select(s => new { s.MaNv }).FirstOrDefault().MaNv.Trim();
var getSohd = context.Hoadons.Select(s => s.SoHd).Max();
var getMatv = context.Thanhviens.Where(s => s.TenTv.Trim() == this.txtTenKh.Text.Trim())
.Select(s => s.MaTv).FirstOrDefault();
var addHd = new Hoadon()
{
SoHd = getSohd + 1,
MaNv = maNv,
NgayBan = DateTime.Now,
TenKh = this.txtTenKh.Text.Trim(),
MaTv = getMatv,
TongTien = double.Parse(this.txtTongCong.Text.Trim()),
};
context.Hoadons.Add(addHd);
context.SaveChanges();
}
public async Task <IActionResult> Edit(int id, [Bind("Mahd,Ngayhd,Tongtien,Idkh,Ghichu,CreatedAt,UpdatedAt,Tinhtrang")] Hoadon hoadon)
{
if (id != hoadon.Mahd)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(hoadon);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HoadonExists(hoadon.Mahd))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Idkh"] = new SelectList(_context.Khachhang, "Id", "Id", hoadon.Idkh);
return(View(hoadon));
}
public int getIDHDLastest()
{
int id = 0;
string query = "SELECT * FROM dbo.HoaDon";
DataTable dt = DataProvider.Instance.ExecureQuery(query);
List <Hoadon> listhd = new List <Hoadon>();
if (dt.Rows.Count == 0)
{
return(1);
}
foreach (DataRow item in dt.Rows)
{
Hoadon hd = new Hoadon(item);
listhd.Add(hd);
}
id = listhd[listhd.Count - 1].Id;
return(id);
}
public IActionResult ThongTinDonHangCuaKhachHang(string id)
{
var dbContext = new shopContext();
var hoadon = (from tk in dbContext.Taikhoan
join kh in dbContext.Khachhang
on tk.TaiKhoanId equals kh.TaiKhoanId
join hd in dbContext.Hoadon
on kh.KhachHangId equals hd.KhachHangId
where tk.Username == id
orderby hd.HoaDonId descending
select new{
hdId = hd.HoaDonId,
tienGiamGia = hd.TienGiamGia,
ngayMua = hd.NgayTao,
tongntien = hd.TongTienThanhToan,
trangThai = hd.TrangThai
});
List <Hoadon> DSHoaDon = new List <Hoadon>();
foreach (var item in hoadon)
{
Hoadon hd = new Hoadon();
hd.HoaDonId = item.hdId;
hd.TienGiamGia = item.tienGiamGia;
hd.NgayTao = item.ngayMua;
hd.TongTienThanhToan = item.tongntien;
hd.TrangThai = item.trangThai;
DSHoaDon.Add(hd);
}
ViewBag.hoadon = DSHoaDon;
return(View());
}
public async Task <IActionResult> Edit(int id, [Bind("Idhoadon,IdNguoimua,IdchiTiet,TongTien,SoLuong,NgayTao,TinhTrang")] Hoadon hoadon)
{
if (id != hoadon.Idhoadon)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(hoadon);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HoadonExists(hoadon.Idhoadon))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["IdNguoimua"] = new SelectList(_context.Khachhang, "IdKhachHang", "Email", hoadon.IdNguoimua);
return(View(hoadon));
}
public IActionResult XemDanhSachHoaDonYeuCauHuy()
{
var dbContext = new shopContext();
// lấy thông tin trong bảng hóa đơn
var hoadon = (from hd in dbContext.Hoadon
join ps in dbContext.Phiship
on hd.PhiShipId equals ps.PhiShipId
join kh in dbContext.Khachhang
on hd.KhachHangId equals kh.KhachHangId
join nv in dbContext.Nhanvien
on hd.NhanVienId equals nv.NhanVienId into x
from subnv in x.DefaultIfEmpty()
where hd.TrangThai == "Yêu cầu hủy"
select new{
hoadonid = hd.HoaDonId,
ngaytao = hd.NgayTao,
ngaygiao = hd.NgayGiao,
sonha = hd.SoNha,
quan = hd.Quan,
phiship = ps.ChiPhi,
thanhtoan = hd.TongTienThanhToan,
trangthai = hd.TrangThai,
nhanvien = subnv.HoTen,
khachhang = kh.HoTen,
tennguoinhan = hd.TenNguoiNhan,
sdt = hd.Sdt,
tienchuaship = hd.TongTienChuaShip,
tiengiamgia = hd.TienGiamGia
});
List <Hoadon> ListHD = new List <Hoadon>();
foreach (var item in hoadon)
{
Hoadon hd = new Hoadon();
Nhanvien nv = new Nhanvien();
Khachhang kh = new Khachhang();
Phiship ps = new Phiship();
hd.HoaDonId = item.hoadonid;
hd.NgayTao = item.ngaytao;
hd.NgayGiao = item.ngaygiao;
hd.SoNha = item.sonha;
hd.Quan = item.quan;
ps.ChiPhi = item.phiship;
hd.TongTienThanhToan = item.thanhtoan;
hd.TrangThai = item.trangthai;
nv.HoTen = item.nhanvien;
kh.HoTen = item.khachhang;
hd.TenNguoiNhan = item.tennguoinhan;
hd.Sdt = item.sdt;
hd.TongTienChuaShip = item.tienchuaship;
hd.TienGiamGia = item.tiengiamgia;
hd.NhanVien = nv;
hd.KhachHang = kh;
hd.PhiShip = ps;
ListHD.Add(hd);
}
ViewBag.dsYeuCauHuy = ListHD;
return(View());
}
public void themhd(Hoadon hd)
{
StreamWriter fwrite = File.AppendText(hdfile);
fwrite.WriteLine();
fwrite.Write(hd.Maph + "#" + hd.Tienphong + "#" + hd.Tiendien + "#" + hd.Tiennuoc + "#" + hd.Tienvesinh + "#" + hd.Tgiano + "#" + hd.Tkhac + "#" + hd.Tongt);
fwrite.Close();
}
public ActionResult DeleteConfirmed(string id)
{
Hoadon hoadon = db.Hoadons.Find(id);
db.Hoadons.Remove(hoadon);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void themhdon(Hoadon h)
{
StreamWriter fwrite = File.AppendText(file);
fwrite.WriteLine();
fwrite.Write(h.Maph + "#" + h.Soswdien + "#" + h.Sonuoc + "#" + h.Tgiano + "#" + h.Tienvesinh + "#" + h.Tkhac + "#" + h.Tt);
fwrite.Close();
}
public Hoadon HOADON(string s)
{
s = congcu.catxau(s);
string[] tmp = s.Split('#');
Hoadon h = new Hoadon(tmp[0], double.Parse(tmp[1]), double.Parse(tmp[2]), double.Parse(tmp[3]), double.Parse(tmp[4]), int.Parse(tmp[5]), double.Parse(tmp[6]));
return(h);
}
public static int DeleteHoadon(Hoadon hd)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mahoadon", hd.mahd)
};
return(DataProvider.ExecuteNonQuery("Xoahoadon", para));
}
public void them(Hoadon h)
{
list <Hoadon> ds = HDDAL.readlist("Data/Hoadon.txt");
Node <Hoadon> tg = ds.Head;
ds.addhead(h);
HDDAL.writelist("Data/Hoadon.txt", ds);
}
public static int xoa_hd(Hoadon a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mahd", a.Mahd),
};
return(DataProvider.ExecuteNonQuery("xoa_hd", para));
}
public void writefile(string filename, Hoadon d)
{
FileStream fs = new FileStream(filename, FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
sw.Write(HDON(d));
sw.Close();
fs.Close();
}
//Chèn một bản ghi hóa đơn vào tệp
public void ThemHoaDon(Hoadon hd)
{
string MaHoaDon = "HD" + DateTime.Now.ToString("yyMMddhhmmss");
StreamWriter fwrite = File.AppendText(txtfile);
fwrite.WriteLine();
fwrite.Write(MaHoaDon + "#" + hd.tenlaptop + "#" + hd.NgayBan + "#" + hd.SoLuong + "#" + hd.TongTien);
fwrite.Close();
}
public ActionResult Edit([Bind(Include = "Sohoadon,Ngayban,Makhachhang,Tenkhachhang")] Hoadon hoadon)
{
if (ModelState.IsValid)
{
db.Entry(hoadon).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hoadon));
}
public static int UpdateHoadon(Hoadon hd)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mahoadon", hd.mahd),
new SqlParameter("@ngaynhap", hd.ngaynhap),
new SqlParameter("@matt", hd.matt)
};
return(DataProvider.ExecuteNonQuery("Suahoadon", para));
}
public static int sua_hoadon1(Hoadon a)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mahd", a.Mahd),
new SqlParameter("@tongtien", a.Tongtien),
};
return(DataProvider.ExecuteNonQuery("luu_tien", para));
}
private void btn_luu_Click(object sender, EventArgs e)
{
if (themhd)
{
Hoadon a = new Hoadon();
a.Mahd = txt_mahd.Text.Trim();
a.Manv = cmb_tennv.SelectedValue.ToString();
a.Makh = cmb_kh.SelectedValue.ToString();
a.Ngaylap = dtp_ngaylap.Value;
a.Tongtien = float.Parse(txt_tongtien.Text);
// txt_tongtien.Text = "0";
if (a.Mahd == null || a.Mahd == "")
{
throw new Exception();
}
if (BUS.BUS.them_hd(a) == 1)
{
MessageBox.Show("Thêm Thành Công");
txt_mahd.Enabled = false;
}
xuat();
}
else if (themct)
{
CTHoadon b = new CTHoadon();
b.Macthd = txt_macthd.Text.Trim();
b.Masp = txt_mahd.Text.Trim();
b.Madv = cbo_tengoitap.SelectedValue.ToString();
b.Dongia = float.Parse(cmb_gia.Text);
b.Soluong = int.Parse(txt_sl.Text);
b.Tien = float.Parse(txt_tien.Text);
if (BUS.BUS.them_cthd(b) == 1)
{
MessageBox.Show("Thêm Thành Công");
txt_macthd.Enabled = false;
}
string ma = txt_mahd.Text;
dgv_ct.DataSource = BUS.BUS.xuat_cthd(ma);
txt_macthd.Enabled = false;
tongtien();
}
else
{
if (txt_tongtien.Text != "0" && txt_tongtien.Text != null)
{
if (MessageBox.Show("Bạn có muốn lưu tổng tiền ", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
luutien();
MessageBox.Show("đã lưu tổng tiền");
}
}
}
}
public ActionResult Create([Bind(Include = "Sohoadon,Ngayban,Makhachhang,Tenkhachhang")] Hoadon hoadon)
{
if (ModelState.IsValid)
{
db.Hoadons.Add(hoadon);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hoadon));
}
public void themh(Hoadon h)
{
if (!string.IsNullOrEmpty(h.Maph))
{
hddal.themhdon(h);
}
else
{
throw new Exception("dữ liệu sai");
}
}
