public IActionResult HoaDon(int pageIndex = 1, int?searchMa = null)
{
var HoaDonVM = new HoaDonViewModel()
{
ListHoaDon = _db.HoaDon.Where(hd => hd.MaKH == HttpContext.Session.GetObject <DangNhap>("DangNhap").MaKH).ToList()
};
StringBuilder param = new StringBuilder();
param.Append("/Customer/MuaHang/HoaDon?pageIndex=:");
param.Append("&searchMa=");
if (searchMa != null)
{
param.Append(searchMa);
}
if (searchMa != null)
{
HoaDonVM.ListHoaDon = HoaDonVM.ListHoaDon.Where(dh => dh.MaDH.ToString().Contains(searchMa.ToString())).ToList();
}
var count = HoaDonVM.ListHoaDon.Count;
HoaDonVM.ListHoaDon = HoaDonVM.ListHoaDon.OrderByDescending(dh => dh.NgayLapHD).Skip((pageIndex - 1) * PageSize).Take(PageSize).ToList();
HoaDonVM.PagingInfo = new PagingInfo
{
CurrentPage = pageIndex,
ItemsPerPage = PageSize,
TotalItems = count,
urlParam = param.ToString()
};
return(View(HoaDonVM));
}
public ActionResult CheckoutStatus()
{
HoaDonViewModel hoaDon = new HoaDonViewModel();
hoaDon.KhachHangID = (int)Session["KhachHangID"];
hoaDon.DiaChiNhanHang = Request.Form["DiaChi"];
hoaDon.HoaDon = new List <ChiTietHDViewModel>();
foreach (var item in GetCart().Lines)
{
hoaDon.HoaDon.Add(new ChiTietHDViewModel()
{
Sua = item.Product,
SoLuong = item.Quantity,
DonGia = item.Product.DonGia
});
}
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:24554/api/");
//HTTP POST
var postTask = client.PostAsJsonAsync("bill", hoaDon);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
Session["CheckoutStatus"] = "Đặt hàng thành công ";
return(View());
}
}
Session["CheckoutStatus"] = "Hệ thống đang xảy ra lỗi quý khách vui lòng thử lại sau!";
return(View());
}
public List <HoaDonViewModel> inHoaDons()
{
var query = from i in db.HOADONs
join c in db.PHONGs on i.MaPhong equals c.MaPhong
join d in db.DIENs on c.MaPhong equals d.MaPhong
join e in db.NUOCs on d.MaPhong equals e.MaPhong
select new
{
hd = i.MaHD,
nv = i.MaNV,
mp = i.MaPhong,
nghi = i.NgayGhi,
chiSoMoiD = d.CSC,
chiSoCuD = d.CSD,
dogiaD = d.DonGia,
chiSoMoiN = e.CSC,
chiSoCuN = e.CSD,
donGiaN = e.DonGia,
};
List <HoaDonViewModel> hd = new List <HoaDonViewModel>();
foreach (var item in query)
{
HoaDonViewModel hd1 = new HoaDonViewModel();
hd1.MaHD = item.hd;
hd1.MaNV = item.nv;
hd1.MaPhong = item.mp;
hd1.NgayGhi = item.nghi;
var tongTien = (item.chiSoMoiD - item.chiSoCuD) * item.dogiaD + (item.chiSoMoiN - item.chiSoCuN) * item.donGiaN;
hd1.TongTien = tongTien;
hd.Add(hd1);
}
return(hd);
}
public DetailHoaDonPage(HoaDonViewModel hd)
{
var pageService = new PageService();
var dataAccess = new SQLiteHoaDonStore(DependencyService.Get <ISQLite>());
ViewModel = new DetailHoaDonPageViewModel(dataAccess, hd, pageService);
InitializeComponent();
}
private void DonHang(object sender, RoutedEventArgs e)
{
DataContext = new HoaDonViewModel();
TaiKhoan.Background = Brushes.ForestGreen;
donhang.Background = Brushes.LightGreen;
MonAn.Background = Brushes.ForestGreen;
loaimonan.Background = Brushes.ForestGreen;
DoanhThu.Background = Brushes.ForestGreen;
nhanvien.Background = Brushes.ForestGreen;
}
public IActionResult EditConfirm(HoaDonViewModel save)
{
if (ModelState.IsValid)
{
HoaDonViewModel hd = ihoadons.GetHoaDon(save.Id);
save.Gia = hd.Gia;
ihoadons.Create(save);
return(RedirectToAction("Index"));
}
return(View(save));
}
public IActionResult Create(HoaDonViewModel save)
{
if (ModelState.IsValid)
{
save.Id = 0;
save.Gia = 0;
ihoadons.Create(save);
return(RedirectToAction("Index"));
}
return(View(save));
}
public IActionResult CreateCTHD(CTHoaDonViewModel save)
{
if (ModelState.IsValid)
{
save.Id = 0;
save.IdhoaDon = idhoadon;
icthoadons.Create(save);
XeViewModel xe = ixes.GetXe(save.Idxe);
xe.Soluong -= save.Soluong;
ixes.Create(xe);
HoaDonViewModel hoadon = ihoadons.GetHoaDon(save.IdhoaDon);
hoadon.Gia += xe.Gia * save.Soluong;
ihoadons.Create(hoadon);
return(RedirectToAction("Index"));
}
return(View(save));
}
public IActionResult DeleteCT(int?Id)
{
if (Id == null)
{
return(NotFound());
}
else
{
var hd = icthoadons.GetCTHoaDon(Id);
XeViewModel xe = ixes.GetXe(hd.Idxe);
xe.Soluong += hd.Soluong;
ixes.Create(xe);
HoaDonViewModel hoadon = ihoadons.GetHoaDon(hd.IdhoaDon);
hoadon.Gia -= xe.Gia * hd.Soluong;
ihoadons.Create(hoadon);
return(View(hd));
}
}
public IActionResult chitietdonhang(int?id)
{
HoaDonViewModel model = new HoaDonViewModel();
List <ChiTietHd> ct = new List <ChiTietHd>();
if (id.HasValue)
{
HoaDon hd = _context.hoaDons.Include(x => x.NguoiDung).Include(x => x.ThanhToan).Include(x => x.VanChuyen).Include(x => x.TrangThai).Where(p => p.HoaDonID == id).First();
ct = _context.chiTietHds.Include(x => x.HangHoa).Where(p => p.HoaDonID == hd.HoaDonID).ToList();
model.hoadon = hd;
model.chitiet = ct;
}
double tongtien = 0;
foreach (var item in ct)
{
tongtien += item.ThanhTien;
}
ViewBag.TongTien = tongtien;
return(View(model));
}
public IHttpActionResult PostBill(HoaDonViewModel hoaDon)
{
db.HoaDons.Add(new HoaDon()
{
HoaDonID = (db.HoaDons.Max(h => h.HoaDonID) + 1),
NgayLap = DateTime.Now,
DiaChiNhanHang = hoaDon.DiaChiNhanHang,
KhachHangID = hoaDon.KhachHangID
});
foreach (var item in hoaDon.HoaDon)
{
db.ChiTietHoaDons.Add(new ChiTietHoaDon()
{
HoaDonID = (db.HoaDons.Max(h => h.HoaDonID) + 1),
SuaID = item.Sua.SuaID,
SoLuong = item.SoLuong,
DonGia = item.DonGia
});
}
db.SaveChanges();
return(Ok());
}
public HoaDon()
{
InitializeComponent();
home = new HoaDonViewModel();
this.DataContext = home;
}
public void Create(HoaDonViewModel hoadon)
{
var hd = iMapper.Map <HoaDonViewModel, HoaDon>(hoadon);
ihoadonr.Add(hd);
}
