public void DeleteChiTietHDDAO(int maHD, int maSP)
{
ChiTietHD cthd = db.ChiTietHD.Find(maHD, maSP);
db.ChiTietHD.Remove(cthd);
db.SaveChanges();
}
public void xoaDoUong(string mamon)
{
try
{
Menu td = qlThucDon.Menus.Where(t => t.MaMon == mamon).FirstOrDefault();
DanhSachMonGoi ds = qlThucDon.DanhSachMonGois.Where(t => t.MaMon == mamon).FirstOrDefault();
ChiTietHD ct = qlThucDon.ChiTietHDs.Where(t => t.MaMon == mamon).FirstOrDefault();
if (td != null)
{
if (ds == null && ct == null)
{
qlThucDon.Menus.DeleteOnSubmit(td);
MessageBox.Show("Xóa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Đồ uống đã tồn tại không được xóa!", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
qlThucDon.SubmitChanges();
}
catch
{
}
}
public ActionResult XacNhanDonHang(FormCollection col)
{
KhachHang khach = Session["kh"] as KhachHang;
GioHang gio = Session["gh"] as GioHang;
string ghiChu = col["txtGhiChu"];
//lưu thông tin 1 dòng vào hóa đơn
HoaDon dh = new HoaDon();
dh.MaKH = khach.MaKH;
dh.NgayLap = DateTime.Now;
//dh.TinhTrang = Int32.Parse(tinhTrang);
//dh.GhiChu = ghiChu;
dh.GhiChu = ghiChu;
db.HoaDons.Add(dh);
db.SaveChanges();
foreach (CartItem item in gio.dssp)
{
ChiTietHD ct = new ChiTietHD();
ct.MaHD = dh.MaHD;
ct.MaSP = item.iMaSP;
ct.SoLuong = item.isoluong;
db.ChiTietHDs.Add(ct);
db.SaveChanges();
}
gio.dssp = null;
return(View(dh));
}
public ActionResult ThanhToan()
{
HoaDon hd = new HoaDon();
List <GioHang> lsGioHang = LayGioHang();
hd.NgayLap = DateTime.Now;
hd.ThanhTien = TongTien();
//Lấy Mã KH theo Tên đăng nhập
var id = (from userid in db.KhachHangs where User.Identity.Name == userid.Ten select userid.MaKH).First();
hd.MaKH = id;
db.HoaDons.Add(hd);
foreach (var item in lsGioHang)
{
ChiTietHD cthd = new ChiTietHD();
cthd.MaHD = hd.MaHD;
cthd.MaSP = item.MaSP;
cthd.SoLuong = item.SoLuong;
cthd.Gia = item.Gia;
db.ChiTietHDs.Add(cthd);
int?sl = LaySoLuong(item.MaSP) - item.SoLuong;
var SL = db.SanPhams.First(n => n.MaSP == item.MaSP);
if (SL != null)
{
SL.SoLuong = sl;
db.Entry(SL).State = EntityState.Modified;
}
}
db.SaveChanges();
Session.Abandon();
return(RedirectToAction("Index", "Home"));
}
public IHttpActionResult PutChiTietHD(string id, ChiTietHD chiTietHD)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != chiTietHD.ID_Chi_Tiet)
{
return(BadRequest());
}
db.Entry(chiTietHD).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ChiTietHDExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void themHoaDon(int maban, DateTime ngayxuat, double tongtien, string magiamgia)
{
HoaDon hd = new HoaDon();
hd.NgayXuat = ngayxuat;
hd.TongTien = (decimal)tongtien;
hd.MaGiamGia = magiamgia;
qlThucDon.HoaDons.InsertOnSubmit(hd);
qlThucDon.SubmitChanges();
List <SanPhamTrongGioHang> lst = new List <SanPhamTrongGioHang>();
var mons = (from m in qlThucDon.DanhSachMonGois where m.MaBan == maban select m).ToList();
foreach (DanhSachMonGoi ds in mons)
{
ChiTietHD ct = new ChiTietHD();
ct.MaHoaDon = hd.MaHoaDon;
ct.MaBan = ds.MaBan;
ct.MaMon = ds.MaMon;
ct.SoLuong = ds.SoLuong;
ct.DonGia = ds.Gia;
Menu mn = qlThucDon.Menus.Where(t => t.MaMon == ds.MaMon).FirstOrDefault();
SanPhamTrongGioHang sp = new SanPhamTrongGioHang(mn.TenMon.ToString(), ds.SoLuong.ToString(), ds.Gia.ToString());
lst.Add(sp);
qlThucDon.ChiTietHDs.InsertOnSubmit(ct);
}
ThongTinHoaDon.sanhams = lst;
qlThucDon.SubmitChanges();
}
public IHttpActionResult PostChiTietHD(ChiTietHD chiTietHD)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ChiTietHDs.Add(chiTietHD);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (ChiTietHDExists(chiTietHD.ID_Chi_Tiet))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = chiTietHD.ID_Chi_Tiet }, chiTietHD));
}
public ActionResult DeleteConfirmed(int id)
{
ChiTietHD chitiethd = db.ChiTietHDs.Find(id);
db.ChiTietHDs.Remove(chitiethd);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void MappingChiTietHD(this ChiTietHDDto cthddto, ChiTietHD cthd)
{
// q.permission_id = cthddto.permission_id;
cthd.name = cthddto.name;
cthd.amount = cthddto.amount;
cthd.price = cthddto.price;
cthd.img = cthddto.img.Replace(Constants.apiUrlImg, "");
}
public IActionResult Post([FromBody] ChiTietHD ctHd)
{
var roweffect = _chiTietHDService.addChiTietHD(ctHd);
//if (roweffect == 400)
// return Created("Thông báo", "Mã hóa đơn đã tồn tại");
return(Ok(roweffect));
}
// GET: /ChiTietHD/Create
public PartialViewResult Create()
{
ViewBag.SP_id = new SelectList(db.BangSanPhams, "id", "TenSP");
var model = new ChiTietHD();
model.HD_id = 0;
model.SoLuong = 1;
return(PartialView(model));
}
public void deleteChiTietHD(ChiTietHD del)
{
try
{
qlks.ChiTietHDs.DeleteOnSubmit(del);
qlks.SubmitChanges();
}
catch (Exception ex) { }
}
public ActionResult Create([Bind(Include = "MaThue,SoHD,MaPhong,NgayDen,NgayDi,SoLuong")] PhongThue phongThue)
{
if (ModelState.IsValid)
{
ChiTietHD cthd = new ChiTietHD();
int soNgay = cthd.SoNgay(Convert.ToDateTime(phongThue.NgayDen), Convert.ToDateTime(phongThue.NgayDi));
Phong p = db.Phongs.Find(phongThue.MaPhong);
int tien = Convert.ToInt32(db.LoaiPhongs.Find(p.MaLoaiPhong).Gia);
int makhach = Convert.ToInt32(db.HoaDons.Find(phongThue.SoHD).MaKH);
p.TinhTrang = true;
db.PhongThues.Add(phongThue);
cthd.SoNgayO = soNgay;
cthd.MaThue = phongThue.MaThue;
cthd.SoHD = Convert.ToInt32(phongThue.SoHD);
int slKhach = Convert.ToInt32(db.PhongThues.Find(cthd.MaThue).SoLuong);
if (db.KhachHangs.Find(makhach).MaLoaiKhach == "NN")
{
if (slKhach > 2)
{
cthd.Tien = ((tien * 3 / 2) + ((tien * 3 / 2) / 4)) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
else
{
cthd.Tien = (tien * 3 / 2) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
}
else
{
if (slKhach > 2)
{
cthd.Tien = (tien + tien / 4) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
else
{
cthd.Tien = (tien) * soNgay;
db.ChiTietHDs.Add(cthd);
db.SaveChanges();
}
}
return(RedirectToAction("Index", "ChiTietHDs"));
}
ViewBag.SoHD = new SelectList(db.HoaDons, "SoHd", "SoHD", phongThue.SoHD);
ViewBag.MaPhong = new SelectList(db.Phongs, "MaPhong", "MaPhong", phongThue.MaPhong);
return(View(phongThue));
}
public static ChiTietHDDto MappingChiTietHDDto(this ChiTietHD cthd)
{
return(new ChiTietHDDto {
bill_id = cthd.bill_id,
product_id = cthd.product_id,
name = cthd.name,
amount = cthd.amount,
price = cthd.price,
img = Constants.apiUrlImg + cthd.img
});
}
public IHttpActionResult GetChiTietHD(string id)
{
ChiTietHD chiTietHD = db.ChiTietHDs.Find(id);
if (chiTietHD == null)
{
return(NotFound());
}
return(Ok(chiTietHD));
}
public void UpdateChiTietHDDAO(ChiTietHD cthdhdToUpDate)
{
ChiTietHD cthd = db.ChiTietHD.Find(cthdhdToUpDate.MaHD);
cthd.MaHD = cthdhdToUpDate.MaHD;
cthd.MaSP = cthdhdToUpDate.MaSP;
cthd.GiaBan = cthdhdToUpDate.GiaBan;
cthd.GiamGia = cthdhdToUpDate.GiamGia;
cthd.ThanhTien = cthdhdToUpDate.ThanhTien;
db.SaveChanges();
}
public void AddHDDAO(HoaDon hd, ChiTietHD cthd)
{
db.HoaDon.Add(hd);
db.SaveChanges();
int idhd = hd.MaHD;
cthd.MaHD = idhd;
db.ChiTietHD.Add(cthd);
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "IDCTHD,SoHD,MaThue,SoNgayO,Tien")] ChiTietHD chiTietHD)
{
if (ModelState.IsValid)
{
db.Entry(chiTietHD).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SoHD = new SelectList(db.HoaDons, "SoHD", "SoHD", chiTietHD.SoHD);
ViewBag.MaThue = new SelectList(db.PhongThues, "MaThue", "MaThue", chiTietHD.MaThue);
return(View(chiTietHD));
}
public ActionResult Edit([Bind(Include = "id,HD_id,SP_id,DonGiaBan,SoLuong")] ChiTietHD chitiethd)
{
if (ModelState.IsValid)
{
db.Entry(chitiethd).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.HD_id = new SelectList(db.BangHoaDons, "id", "TenKhachHang", chitiethd.HD_id);
ViewBag.SP_id = new SelectList(db.BangSanPhams, "id", "MaSP", chitiethd.SP_id);
return(View(chitiethd));
}
public void DeleteHDDAO(int id)
{
ChiTietHD cthd = db.ChiTietHD.Where(p => p.MaHD == id).SingleOrDefault();
db.ChiTietHD.Remove(cthd);
db.SaveChanges();
HoaDon hd = db.HoaDon.Find(id);
db.HoaDon.Remove(hd);
db.SaveChanges();
}
public ActionResult TinhTien(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietHD chiTietHD = db.ChiTietHDs.Find(id);
if (chiTietHD == null)
{
return(HttpNotFound());
}
return(View(chiTietHD));
}
public IHttpActionResult DeleteChiTietHD(string id)
{
ChiTietHD chiTietHD = db.ChiTietHDs.Find(id);
if (chiTietHD == null)
{
return(NotFound());
}
db.ChiTietHDs.Remove(chiTietHD);
db.SaveChanges();
return(Ok(chiTietHD));
}
public void ThemChiTietHD(ChiTietHD CThd)
{
SqlCommand com = new SqlCommand("ThemChiTietHD", conn);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@MaHD", CThd.MaHD);
com.Parameters.AddWithValue("@MaSP", CThd.MaSP);
com.Parameters.AddWithValue("@TenSP", CThd.TenSP);
com.Parameters.AddWithValue("@DonGia", CThd.DonGia);
com.Parameters.AddWithValue("@SoLuong", CThd.SoLuong);
com.Parameters.AddWithValue("@TongCong", CThd.TongCong);
conn.Open();
com.ExecuteNonQuery();
conn.Close();
}
// GET: ChiTietHDs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietHD chiTietHD = db.ChiTietHDs.Find(id);
if (chiTietHD == null)
{
return(HttpNotFound());
}
ViewBag.SoHD = new SelectList(db.HoaDons, "SoHD", "SoHD", chiTietHD.SoHD);
ViewBag.MaThue = new SelectList(db.PhongThues, "MaThue", "MaThue", chiTietHD.MaThue);
return(View(chiTietHD));
}
// GET: /ChiTietHD/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietHD chitiethd = db.ChiTietHDs.Find(id);
if (chitiethd == null)
{
return(HttpNotFound());
}
ViewBag.HD_id = new SelectList(db.BangHoaDons, "id", "TenKhachHang", chitiethd.HD_id);
ViewBag.SP_id = new SelectList(db.BangSanPhams, "id", "MaSP", chitiethd.SP_id);
return(View(chitiethd));
}
public ActionResult DatHang()
{
if (Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "")
{
return(RedirectToAction("Login", "Regester"));
}
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "TrangChu"));
}
int count = db.HOADONs.Count();
HOADON hd = new HOADON();
KHACHHANG kh = Session["TaiKhoan"] as KHACHHANG;
List <Gio> gio = layGioHang();
if (count == 0)
{
hd.MAHD = 1;
}
else
{
hd.MAHD = db.HOADONs.Max(n => n.MAHD) + 1;
}
hd.MAKH = kh.MAKH;
hd.NGAYDAT = DateTime.Now;
hd.TONGTIEN = TongTien();
hd.Status = false;
db.HOADONs.Add(hd);
foreach (var item in gio)
{
ChiTietHD cthd = new ChiTietHD();
cthd.MAHD = hd.MAHD;
cthd.MASP = item.maSP;
cthd.SOLUONG = item.soLuong;
cthd.DONGIA = item.donGia;
SANPHAM sp = db.SANPHAMs.SingleOrDefault(n => n.MASP == item.maSP);
sp.SoLuongTon -= item.soLuong;
db.ChiTietHDs.Add(cthd);
}
db.SaveChanges();
Session.Remove("GioHang");
return(RedirectToAction("Index", "TrangChu"));
}
private void AddHD()
{
HoaDon hd = new HoaDon();
hd.MaKH = int.Parse(cbMaKHang.Text);
hd.MaNV = int.Parse(cbMaNVien.Text);
hd.NgayDatHang = dtpNgayDatHang.Value;
hd.NgayGiaoHang = dtpNgayGiaoHang.Value;
ChiTietHD cthd = new ChiTietHD();
cthd.MaSP = int.Parse(cbMaSPham.Text);
cthd.GiaBan = decimal.Parse(txtGiaBan.Text);
cthd.SoLuong = int.Parse(txtSoLuong.Text);
cthd.GiamGia = double.Parse(txtGiamGia.Text);
cthd.ThanhTien = decimal.Parse(txtThanhTien.Text);
hdBUS.AddHDBUS(hd, cthd);
}
public void Them(string mahd, string masp, int soluong)
{
var hd = new ChiTietHD
{
MaHD = mahd,
MaSP = masp,
SoLuong = soluong,
};
try
{
qly.ChiTietHDs.InsertOnSubmit(hd);
qly.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("Không thêm được !!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void UpdateHDDAO(HoaDon hdToUpDate, ChiTietHD cthdToUpDate)
{
int id = hdToUpDate.MaHD;
ChiTietHD cthd = db.ChiTietHD.Where(p => p.MaHD == id).SingleOrDefault();
cthd.GiaBan = cthdToUpDate.GiaBan;
cthd.SoLuong = cthdToUpDate.SoLuong;
cthd.GiamGia = cthdToUpDate.GiamGia;
cthd.ThanhTien = cthdToUpDate.ThanhTien;
db.SaveChanges();
HoaDon hd = db.HoaDon.Find(hdToUpDate.MaHD);
hd.MaKH = hdToUpDate.MaKH;
hd.MaNV = hdToUpDate.MaNV;
hd.NgayDatHang = hdToUpDate.NgayDatHang;
hd.NgayGiaoHang = hdToUpDate.NgayGiaoHang;
db.SaveChanges();
}
public ActionResult Dathang(FormCollection collection)
{
HoaDon HD = new HoaDon();
TaiKhoan kh = (TaiKhoan)Session["Taikhoan"];
List <HoaDon> lsthd = db.HoaDons.ToList();
List <ChiTietHD> lstchitiet = db.ChiTietHDs.ToList();
List <Giohang> lstGiohang = Laygiohang().ToList();
HD.idHoaDon = kh.idTaiKhoan + (lsthd.Count + 1);
HD.idTaiKhoan = kh.idTaiKhoan;
HD.NgayLap = DateTime.Now.Date;
HD.DiaChiGiao = kh.Diachi;
var ngaygiao = String.Format("{0:dd/MM/yyyy}", collection["Ngaygiao"]);
HD.NgayGiao = DateTime.Parse(ngaygiao).Date;
if (HD.NgayGiao < HD.NgayLap)
{
return(RedirectToAction("HienThiGioHang"));
}
HD.ThanhTien = decimal.Parse(TongTien().ToString());
HD.TinhTrang = "Đang Giao";
HD.DaThanhToan = "Chưa Thanh Toán";
db.HoaDons.InsertOnSubmit(HD);
db.SubmitChanges();
int dem = 0;
foreach (var item in lstGiohang)
{
ChiTietHD ctdh = new ChiTietHD();
ctdh.idChiTiet = HD.idHoaDon + (dem + 1);
ctdh.idHoaDon = HD.idHoaDon;
ctdh.idSanPham = item.iMasanpham;
ctdh.Soluong = item.iSoluong;
ctdh.ThanhTien = decimal.Parse(item.dDongia.ToString());
dem++;
db.ChiTietHDs.InsertOnSubmit(ctdh);
}
db.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("Xacnhandonhang", "Giohang"));
}
