public ActionResult GiaHanPhong(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } tblPhieuDatPhong pdp = db.tblPhieuDatPhongs.Find(tblHoaDon.ma_pdp); String dt = null; try { DateTime d = (DateTime)db.tblPhieuDatPhongs.Where(t => t.ma_tinh_trang == 1 && t.ma_phong == pdp.tblPhong.ma_phong).Select(t => t.ngay_vao).OrderBy(t => t.Value).First(); dt = d.ToString(); } catch { } ViewBag.dateMax = dt; return(View(pdp)); }
private void Form_ThuTien_Load(object sender, EventArgs e) { try { if (ca.getCart().Count > 0) { double sum = ca.tinhTong(); lbl_TongTien.Text = sum + ""; //lbl_TongTien.Text = mc.convertCurrency(sum); } else if (ca.getCart2().Count == 0) { tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); List <tblChiTietHD> lstCT = (List <tblChiTietHD>)ct.getCTByMaHD(h.MaHD); lbl_TongTien.Text = lstCT.Sum(t => t.TongTien) + ""; //lbl_TongTien.Text = mc.convertCurrency((double)lstCT.Sum(t => t.TongTien)); } else if (ca.getCart2().Count > 0) { tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); List <tblChiTietHD> lstCT = (List <tblChiTietHD>)ct.getCTByMaHD(h.MaHD); double sum = ca.tinhTong2(); lbl_TongTien.Text = ((double)lstCT.Sum(t => t.TongTien) + sum) + ""; //lbl_TongTien.Text = mc.convertCurrency((double)lstCT.Sum(t => t.TongTien) + sum); } } catch (Exception ee) { } }
public Form_ChiTietHoaDon(int maHDInput) { InitializeComponent(); Current = this; this.maHD = maHDInput; this.hoaDon = hd.getHDByMaHD(maHDInput); }
public void load3() { try { flowLayoutPanel1.Controls.Clear(); bool colorFlag = false; tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); List <tblChiTietHD> lstCT = (List <tblChiTietHD>)ct.getCTByMaHD(h.MaHD); for (int i = 0; i < lstCT.Count; i++) { DoUongGioHang_Item_Temp item; item = new DoUongGioHang_Item_Temp(lstCT[i].tblThucDon.TenMon, lstCT[i].SoLuong, double.Parse(lstCT[i].tblThucDon.DonGia), colorFlag, lstCT[i].MaMon); item.Dock = DockStyle.Top; flowLayoutPanel1.Controls.Add(item); } List <Item> lstCart = ca.getCart2(); for (int i = 0; i < lstCart.Count; i++) { DoUongGioHang_Item_Temp item; item = new DoUongGioHang_Item_Temp(lstCart[i].tenMon, lstCart[i].sl, lstCart[i].donGia, colorFlag, lstCart[i].maMon); item.Dock = DockStyle.Top; flowLayoutPanel1.Controls.Add(item); } } catch (Exception ee) { } }
public ActionResult DeleteConfirmed(int id) { tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); db.tblHoaDons.Remove(tblHoaDon); db.SaveChanges(); return(RedirectToAction("Index")); }
private void lbl_TenBan_Click(object sender, EventArgs e) { try { if (chuyen == 0) { ca.setMaBan(int.Parse(lbl_TenBan.Tag + "")); if ((Program.frmGM == null || Program.frmGM.IsDisposed) && lbl_TrangThai.Tag.ToString().Equals("False")) { Program.frmGM = new Form_GoiMon(); } else if ((Program.frmGM == null || Program.frmGM.IsDisposed) && lbl_TrangThai.Tag.ToString().Equals("True")) { Program.frmGM = new Form_GoiMon("a"); } Program.frmCNC.Visible = false; Program.frmGM.Show(); } else if (chuyen == 1) { if (lbl_TrangThai.Tag.ToString().Equals("False")) { int maBanMoi = int.Parse(lbl_TenBan.Tag + ""); int maBanCu = maBan; //xu li tblHoaDon h = hd.getMaHDTheoBan(maBanCu); hd.suaHoaDonMaBan(h.MaHD, maBanMoi); b.updateTTBan(maBanCu); Program.frmCNC.load2(); chuyen = 0; } else { MessageBox.Show("Mời chọn 1 bàn khác"); } } else if (chuyen == 2) { if (lbl_TrangThai.Tag.ToString().Equals("True") && maBan != int.Parse(lbl_TenBan.Tag + "")) { int maBanMoi = int.Parse(lbl_TenBan.Tag + ""); int maBanCu = maBan; //xu li b.gopBan(maBanCu, maBanMoi); Program.frmCNC.load2(); chuyen = 0; } else { MessageBox.Show("Mời chọn 1 bàn khác"); } } } catch (Exception ee) { } }
public Form_GoiMon(String a) { InitializeComponent(); loadUserControl(); ca.setFlag(1); tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); lstCT = ct.getCTByMaHD(h.MaHD).ToList <tblChiTietHD>(); loadListOrder2(); }
public ActionResult Edit([Bind(Include = "ma_hd,ma_nv,ma_pdp,ngay_tra_phong,ma_tinh_trang,tien_phong,tien_dich_vu,phu_thu,tong_tien")] tblHoaDon tblHoaDon) { if (ModelState.IsValid) { db.Entry(tblHoaDon).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ma_nv = new SelectList(db.tblNhanViens, "ma_nv", "ho_ten", tblHoaDon.ma_nv); ViewBag.ma_pdp = new SelectList(db.tblPhieuDatPhongs, "ma_pdp", "ma_kh", tblHoaDon.ma_pdp); ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangHoaDons, "ma_tinh_trang", "mo_ta", tblHoaDon.ma_tinh_trang); return(View(tblHoaDon)); }
public void gopBan(int maBanCu, int maBanMoi) { try { tblBan bCu = db.tblBans.Where(t => t.MaBan == maBanCu).FirstOrDefault(); tblBan bMoi = db.tblBans.Where(t => t.MaBan == maBanMoi).FirstOrDefault(); tblHoaDon hCu = hd.getMaHDTheoBan(maBanCu); tblHoaDon hMoi = hd.getMaHDTheoBan(maBanMoi); List <tblChiTietHD> lstCu = ct.getCTByMaHD(hCu.MaHD).ToList(); List <tblChiTietHD> lstMoi = ct.getCTByMaHD(hMoi.MaHD).ToList(); double sum1 = (double)hCu.TongTienTT; double sum2 = (double)hCu.TongTienTT; //cap nhat cac hoa don trung nhau foreach (tblChiTietHD ctCu in lstCu) { foreach (tblChiTietHD ctMoi in lstMoi) { if (ctCu.MaMon == ctMoi.MaMon) { //cap nhat sl + tong tien ctCu.SoLuong = ctCu.SoLuong + ctMoi.SoLuong; ctCu.TongTien = ctCu.TongTien + ctMoi.TongTien; //xoa chi tiet moi ct.xoaCTHDByMa(hMoi.MaHD, ctMoi.MaMon); } } } //them cac hoa don moi foreach (tblChiTietHD ctMoi in lstMoi) { //them tblChiTietHD c = new tblChiTietHD(); c.MaHD = hCu.MaHD; c.MaMon = ctMoi.MaMon; c.SoLuong = ctMoi.SoLuong; c.TongTien = ctMoi.TongTien; c.GiamGia = ctMoi.GiamGia; db.tblChiTietHDs.InsertOnSubmit(c); //xoa ct.xoaCTHDByMa(hMoi.MaHD, ctMoi.MaMon); } //update tong tien hd hd.suaHoaDon(hCu.MaHD, (sum1 + sum2)); db.SubmitChanges(); } catch (Exception ee) { } }
public ActionResult TraPhong(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblPhieuDatPhong phieudatphong = new tblPhieuDatPhong(); phieudatphong = db.tblPhieuDatPhongs.Where(x => x.ma_phong == id && x.ma_tinh_trang == 2).SingleOrDefault(); tblHoaDon MaHoaDon = db.tblHoaDons.Where(x => x.ma_pdp == phieudatphong.ma_pdp && x.ma_tinh_trang == 1).SingleOrDefault(); return(RedirectToAction("ThanhToan", "HoaDon", new { id = MaHoaDon.ma_hd })); }
// GET: HoaDon/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } return(View(tblHoaDon)); }
public ActionResult Create([Bind(Include = "ma_hd,ma_pdp,ngay_tra_phong,ma_tinh_trang")] tblHoaDon tblHoaDon) { if (ModelState.IsValid) { db.tblHoaDons.Add(tblHoaDon); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ma_nv = new SelectList(db.tblNhanViens, "ma_nv", "ho_ten", tblHoaDon.ma_nv); ViewBag.ma_pdp = new SelectList(db.tblPhieuDatPhongs, "ma_pdp", "ma_kh", tblHoaDon.ma_pdp); ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangHoaDons, "ma_tinh_trang", "mo_ta", tblHoaDon.ma_tinh_trang); return(View(tblHoaDon)); }
public void loadItemFormOrder(tblHoaDon tblHD) { tblBan tblBan = new tblBan(); List <tblHoaDon> listHD = hd.getDSHoaDonChuaThanhToan(); //List<Grid_Item> lst = new List<Grid_Item>(); foreach (tblHoaDon item in listHD) { tblBan = ban.getBanByID(item.MaBan); Grid_Item user; user = new Grid_Item(tblBan.KhuVuc, tblBan.TenBan, Convert.ToDouble(item.TongTienTT.ToString()), item.TGVao.ToString(), item.MaHD, item.MaBan); //lst.Add(user); flowLayoutPanel_TrangOrder.Controls.Add(user); } }
public int suaHoaDonMaBan(int maHD, int maBan) { tblHoaDon h = new tblHoaDon(); try { h = db.tblHoaDons.Where(t => t.MaHD == maHD).FirstOrDefault(); h.MaBan = maBan; db.SubmitChanges(); } catch (Exception ee) { } return(h.MaHD); }
public int suaHoaDon(int maHD, double tong) { tblHoaDon h = new tblHoaDon(); try { h = db.tblHoaDons.Where(t => t.MaHD == maHD).FirstOrDefault(); h.TongTienTT = (Decimal)tong; db.SubmitChanges(); } catch (Exception ee) { } return(h.MaHD); }
// Chuyển giá trị trong Textbox thành tblHoaDon public tblHoaDon Textbox_To_tblHoaDon() { try { tblHoaDon result = new tblHoaDon(); result.id = (int)this.numbid.Value; result.ngayTao = this.datengayTao.Value; result.tenNhanVien = (this.txttenNhanVien.Text == null ? null : (string)(this.txttenNhanVien.Text)); result.tongTien = (int)this.numbtongTien.Value; return(result); } catch (Exception ex) { ShowMessage(ex.Message, false); } // Không load được hoặc xảy ra lỗi return(null); }
// GET: HoaDon/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } ViewBag.ma_nv = new SelectList(db.tblNhanViens, "ma_nv", "ho_ten", tblHoaDon.ma_nv); ViewBag.ma_pdp = new SelectList(db.tblPhieuDatPhongs, "ma_pdp", "ma_kh", tblHoaDon.ma_pdp); ViewBag.ma_tinh_trang = new SelectList(db.tblTinhTrangHoaDons, "ma_tinh_trang", "mo_ta", tblHoaDon.ma_tinh_trang); return(View(tblHoaDon)); }
public int suaHoaDon(int maHD, DateTime tgRa, String tt) { tblHoaDon h = new tblHoaDon(); try { h = db.tblHoaDons.Where(t => t.MaHD == maHD).FirstOrDefault(); h.TGRa = tgRa; h.TrangThai = tt; db.SubmitChanges(); } catch (Exception ee) { } return(h.MaHD); }
public ActionResult DoiPhong(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } tblPhieuDatPhong pdp = db.tblPhieuDatPhongs.Find(tblHoaDon.ma_pdp); var li = db.tblPhongs.Where(t => t.ma_tinh_trang == 1 && !(db.tblPhieuDatPhongs.Where(m => (m.ma_tinh_trang == 1 || m.ma_tinh_trang == 2) && m.ngay_ra > DateTime.Now && m.ngay_vao < pdp.ngay_ra)).Select(m => m.ma_phong).ToList().Contains(t.ma_phong)); ViewBag.ma_phong_moi = new SelectList(li, "ma_phong", "so_phong"); return(View(pdp)); }
public ActionResult ThanhToan(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } var so_ngay = (tblHoaDon.tblPhieuDatPhong.ngay_ra - tblHoaDon.tblPhieuDatPhong.ngay_vao).Value.Days; //if (so_ngay < 1) // so_ngay = 1; var tien_phong = so_ngay * tblHoaDon.tblPhieuDatPhong.tblPhong.tblLoaiPhong.gia; ViewBag.tien_phong = tien_phong; ViewBag.so_ngay = so_ngay; ViewBag.time_now = DateTime.Now.ToString(); tblNhanVien nv = (tblNhanVien)Session["NV"]; if (nv != null) { ViewBag.ho_ten = nv.ho_ten; } List <tblDichVuDaDat> dsdv = db.tblDichVuDaDats.Where(u => u.ma_hd == id).ToList(); ViewBag.list_dv = dsdv; double tongtiendv = 0; List <double> tt = new List <double>(); foreach (var item in dsdv) { double t = (double)(item.so_luong * item.tblDichVu.gia); tongtiendv += t; tt.Add(t); } ViewBag.list_tt = tt; ViewBag.tien_dich_vu = tongtiendv; ViewBag.tong_tien = tien_phong + tongtiendv; return(View(tblHoaDon)); }
private void Form_ThanhToan_Load(object sender, EventArgs e) { try { if (ca.getCart().Count > 0) { load1(); //lbl_ThanhTien.Text = ca.tinhTong() + ""; //lbl_TongThanhToan.Text = ca.tinhTong() + ""; lbl_ThanhTien.Text = mc.convertCurrency(ca.tinhTong()) + ""; lbl_TongThanhToan.Text = mc.convertCurrency(ca.tinhTong()) + ""; lbl_TenBan.Text = "Bàn số: " + ca.getMaBan(); lbl_ThoiGianVao.Text = DateTime.Now + ""; } else if (ca.getCart2().Count == 0) { load2(); tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); List <tblChiTietHD> lstCT = (List <tblChiTietHD>)ct.getCTByMaHD(h.MaHD); //lbl_TongThanhToan.Text = lstCT.Sum(t => t.TongTien) + ""; lbl_ThanhTien.Text = mc.convertCurrency((double)lstCT.Sum(t => t.TongTien)) + ""; lbl_TongThanhToan.Text = mc.convertCurrency((double)lstCT.Sum(t => t.TongTien)) + ""; lbl_TenBan.Text = "Bàn số: " + ca.getMaBan(); lbl_ThoiGianVao.Text = h.TGVao + ""; } else if (ca.getCart2().Count > 0) { load3(); tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); List <tblChiTietHD> lstCT = (List <tblChiTietHD>)ct.getCTByMaHD(h.MaHD); double sum = ca.tinhTong2(); //lbl_ThanhTien.Text = ((double)lstCT.Sum(t => t.TongTien)+sum) + ""; //lbl_TongThanhToan.Text = ((double)lstCT.Sum(t => t.TongTien)+sum) + ""; lbl_ThanhTien.Text = mc.convertCurrency((double)lstCT.Sum(t => t.TongTien) + sum) + ""; lbl_TongThanhToan.Text = mc.convertCurrency((double)lstCT.Sum(t => t.TongTien) + sum) + ""; lbl_TenBan.Text = "Bàn số: " + ca.getMaBan(); lbl_ThoiGianVao.Text = h.TGVao + ""; } } catch (Exception ee) { } }
public ActionResult XacNhanThanhToan(string ma_hd, string tien_phong, string tien_dich_vu, string phu_thu, string tong_tien) { if (ma_hd == null || tien_phong == null || tien_dich_vu == null || phu_thu == null || tong_tien == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } try { tblHoaDon hd = db.tblHoaDons.Find(Int32.Parse(ma_hd)); tblNhanVien nv = (tblNhanVien)Session["NhanVien"]; if (nv != null) { hd.ma_nv = nv.ma_nv; } hd.tien_phong = Double.Parse(tien_phong); hd.tien_dich_vu = Double.Parse(tien_dich_vu); hd.phu_thu = Double.Parse(phu_thu); hd.tong_tien = Double.Parse(tong_tien); hd.ma_tinh_trang = 2; hd.ngay_tra_phong = DateTime.Now; db.Entry(hd).State = EntityState.Modified; tblPhong p = db.tblPhongs.Find(hd.tblPhieuDatPhong.ma_phong); p.ma_tinh_trang = 3; tblPhieuDatPhong pd = db.tblPhieuDatPhongs.Find(hd.tblPhieuDatPhong.ma_pdp); pd.ma_tinh_trang = 4; db.Entry(p).State = EntityState.Modified; db.Entry(pd).State = EntityState.Modified; db.SaveChanges(); ViewBag.result = "success"; } catch { ViewBag.result = "error"; } ViewBag.ma_hd = ma_hd; return(View()); }
public ActionResult GoiDichVu(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblPhong phong = new tblPhong(); phong = db.tblPhongs.Find(id); tblPhieuDatPhong phieudatphong = new tblPhieuDatPhong(); phieudatphong = db.tblPhieuDatPhongs.Where(x => x.ma_phong == phong.ma_phong && x.ma_tinh_trang == 2 && phong.ma_tinh_trang == 2).FirstOrDefault(); tblHoaDon hoadon = new tblHoaDon(); hoadon = db.tblHoaDons.Where(x => x.ma_pdp == phieudatphong.ma_pdp && phieudatphong.ma_tinh_trang == 2 && x.ma_tinh_trang == 1).SingleOrDefault(); //int ma_hd = db.tblHoaDons.Where(x => x.ma_phong == id && u.ma_tinh_trang == 2).First().ma_hd; return(RedirectToAction("GoiDichVu", "HoaDon", new { id = hoadon.ma_hd })); }
public int LuuHoaDon2(DateTime dt, int maB, int MaNV, String pt, double tong, String tt) { tblHoaDon h = new tblHoaDon(); try { h.TGVao = dt; h.TGRa = dt; h.MaBan = maB; h.MaNV = 2; h.PhuongThucTT = "Cash"; h.TongTienTT = (Decimal)tong; h.TrangThai = "Roi"; db.tblHoaDons.InsertOnSubmit(h); db.SubmitChanges(); } catch (Exception ee) { } return(h.MaHD); }
public ActionResult Result(String ma_tgd) { if (ma_tgd == null) { return(RedirectToAction("Index", "Admin")); } else { tblHoaDon hd = new tblHoaDon(); hd.ma_tgd = Int32.Parse(ma_tgd); hd.ma_tinh_trang = 1; try { db.tblHoaDons.Add(hd); tblPhieuDatPhong tgd = db.tblPhieuDatPhongs.Find(Int32.Parse(ma_tgd)); if (tgd == null) { return(HttpNotFound()); } tblPhong p = db.tblPhongs.Find(tgd.ma_phong); if (p == null) { return(HttpNotFound()); } tgd.ma_tinh_trang = 2; db.Entry(tgd).State = EntityState.Modified; p.ma_tinh_trang = 2; db.Entry(p).State = EntityState.Modified; ViewBag.ngay_ra = tgd.ngay_ra; db.SaveChanges(); ViewBag.Result = "success"; } catch { ViewBag.Result = "error"; } } return(View()); }
// Chuyển giá trị trong DataGridView thành tblHoaDon public tblHoaDon DataGridView_To_tblHoaDon(int index) { try { tblHoaDon result = new tblHoaDon(); var id = this.dgvData.Rows[index].Cells["id"].Value; if (id != null) { result.id = int.Parse(id.ToString()); } var ngayTao = this.dgvData.Rows[index].Cells["ngayTao"].Value; if (ngayTao != null) { result.ngayTao = (ngayTao == null ? null : (DateTime?)DateTime.Parse(ngayTao.ToString())); } var tenNhanVien = this.dgvData.Rows[index].Cells["tenNhanVien"].Value; if (tenNhanVien != null) { result.tenNhanVien = (tenNhanVien == null ? null : (string)(tenNhanVien)); } var tongTien = this.dgvData.Rows[index].Cells["tongTien"].Value; if (tongTien != null) { result.tongTien = (tongTien == null ? null : (int?)int.Parse(tongTien.ToString())); } return(result); } catch (Exception ex) { ShowMessage(ex.Message, false); } // Không load được hoặc xảy ra lỗi return(null); }
public ActionResult ChiTietHoaDon(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } var tien_phong = (tblHoaDon.tblPhieuDatPhong.ngay_ra - tblHoaDon.tblPhieuDatPhong.ngay_vao).Value.TotalDays * tblHoaDon.tblPhieuDatPhong.tblPhong.tblLoaiPhong.gia; ViewBag.tien_phong = tien_phong; ViewBag.time_now = DateTime.Now.ToString(); List <tblDichVuDaDat> dsdv = db.tblDichVuDaDats.Where(u => u.ma_hd == id).ToList(); ViewBag.list_dv = dsdv; double tongtiendv = 0; List <double> tt = new List <double>(); foreach (var item in dsdv) { double t = (double)(item.so_luong * item.tblDichVu.gia); tongtiendv += t; tt.Add(t); } ViewBag.list_tt = tt; ViewBag.tien_dich_vu = tongtiendv; ViewBag.tong_tien = tien_phong + tongtiendv; return(View(tblHoaDon)); }
public ActionResult ThanhToan(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblHoaDon tblHoaDon = db.tblHoaDons.Find(id); if (tblHoaDon == null) { return(HttpNotFound()); } DateTime ngay_ra = DateTime.Now; DateTime ngay_vao = (DateTime)tblHoaDon.tblPhieuDatPhong.ngay_vao; DateTime ngay_du_kien = (DateTime)tblHoaDon.tblPhieuDatPhong.ngay_ra; DateTime dateS = new DateTime(ngay_vao.Year, ngay_vao.Month, ngay_vao.Day, 12, 0, 0); DateTime dateE = new DateTime(ngay_ra.Year, ngay_ra.Month, ngay_ra.Day, 12, 0, 0); Double gia = (Double)tblHoaDon.tblPhieuDatPhong.tblPhong.tblLoaiPhong.gia; var songay = (dateE - dateS).TotalDays; if (dateS > ngay_vao) { songay++; } if (ngay_ra > dateE) { songay++; } var ti_le_phu_thu = tblHoaDon.tblPhieuDatPhong.tblPhong.tblLoaiPhong.ti_le_phu_thu; var so_ngay_phu_thu = Math.Abs(Math.Ceiling((ngay_ra - ngay_du_kien).TotalDays)); System.Diagnostics.Debug.WriteLine("So ngay: " + so_ngay_phu_thu); System.Diagnostics.Debug.WriteLine("Gia: " + gia); System.Diagnostics.Debug.WriteLine("Ti le: :" + ti_le_phu_thu); var phuthu = so_ngay_phu_thu * gia * ti_le_phu_thu / 100; ViewBag.phu_thu = phuthu; System.Diagnostics.Debug.WriteLine("Phu thu:" + phuthu); ViewBag.so_ngay_phu_thu = so_ngay_phu_thu; var tien_phong = songay * gia; ViewBag.tien_phong = tien_phong; ViewBag.so_ngay = songay; tblNhanVien nv = (tblNhanVien)Session["NV"]; if (nv != null) { ViewBag.ho_ten = nv.ho_ten; } List <tblDichVuDaDat> dsdv = db.tblDichVuDaDats.Where(u => u.ma_hd == id).ToList(); ViewBag.list_dv = dsdv; double tongtiendv = 0; List <double> tt = new List <double>(); foreach (var item in dsdv) { double t = (double)(item.so_luong * item.tblDichVu.gia); tongtiendv += t; tt.Add(t); } ViewBag.list_tt = tt; ViewBag.tien_dich_vu = tongtiendv; ViewBag.tong_tien = tien_phong + tongtiendv + phuthu; return(View(tblHoaDon)); }
public ActionResult XacNhanThanhToan(FormCollection c) { if (Session["dangnhap"] == null) { ViewBag.TB = "Ban chua dang nhap"; return(RedirectToAction("DangNhap", "KhachHang")); } try { tblKhachHang kh = Session["dangnhap"] as tblKhachHang; // tblKhachHang kh = db.tblKhachHangs.FirstOrDefault(); String pt = c["PTThanhToan"].ToString(); String tg = c["DonViVC"].ToString(); String dc = c["DiaChiNhan"].ToString(); List <item> lst = layGioHang(); tblHoaDon hd = new tblHoaDon(); DateTime now = DateTime.Now; hd.NgayHD = DateTime.Parse(now.ToShortDateString()); hd.MaNV = 1; hd.TongTien = (decimal)tongTien(); db.tblHoaDon.Add(hd); db.SaveChanges(); tblThanhToan thanhtoan = new tblThanhToan(); thanhtoan.MaHD = hd.MaHD; thanhtoan.MaKH = kh.MaKH; thanhtoan.SoTienThanhToan = (decimal)tongTien(); thanhtoan.NgayThanhToan = hd.NgayHD; if (pt == "0") { thanhtoan.PhuongThucThanhToan = "Thanh toán khi nhận hàng"; } else { thanhtoan.PhuongThucThanhToan = "Thanh toán ngay"; } tblGiaoHang giaohang = new tblGiaoHang(); giaohang.MaHD = hd.MaHD; giaohang.TenNguoiNhan = kh.TenKH; giaohang.DiaChi1 = dc; giaohang.DiaChi2 = dc; giaohang.DiaChi3 = dc; giaohang.MaDonViVanChuyen = tg; giaohang.SoDT1 = kh.DienThoai; giaohang.Email = kh.Email; // add data into database db.tblThanhToan.Add(thanhtoan); db.tblGiaoHang.Add(giaohang); db.SaveChanges(); foreach (var sp in lst) { if (ktSL(sp.maTB, sp.sl, sp.cauHinh)) { tblChiTietHD ct = new tblChiTietHD(); ct.MaHD = hd.MaHD; ct.MaTB = sp.maTB; ct.MaCauHinh = sp.cauHinh; ct.SoLuong = sp.sl; ct.ThanhTien = (decimal)sp.thanhTien; db.tblChiTietHD.Add(ct); db.SaveChanges(); } else { ViewBag.TB = "Failed"; return(RedirectToAction("ThanhToan", "ThanhToan")); } } lst.Clear(); return(RedirectToAction("HoanTat", "ThanhToan")); } catch { TempData["Message"] = "Error !!"; return(RedirectToAction("ThanhToan", "ThanhToan")); } }
private void simpleButton5_Click(object sender, EventArgs e) { try { if (ca.getFlag() == 0) { if (ca.getCart().Count != 0) { DateTime dt = DateTime.Now; int maB = ca.getMaBan(); int maNV = ca.getMaNV(); String PT = "Cash"; double tong = ca.tinhTong(); String TT = "Chua"; int x = hd.LuuHoaDon(dt, maB, maNV, PT, tong, TT); List <Item> lstCart = ca.getCart(); foreach (Item i in lstCart) { int maHD = x; int maMon = i.maMon; int sl = i.sl; double tong2 = i.tongTien; ct.LuuChiTietHD(maHD, maMon, sl, tong2); } ca.clearCard2(); ca.clearCard(); this.Dispose(); if (Program.frmCNC.Visible == false) { Program.frmCNC = new Form_ChucNangChinh(); } Program.frmCNC.Show(); } else { MessageBox.Show("Moi Chon San Pham"); } } else { ////xoa het ct cu //tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); //List<tblChiTietHD> lstCT = ct.getCTByMaHD(h.MaHD).ToList<tblChiTietHD>(); //foreach (tblChiTietHD t in lstCT) //{ // ct.xoaCTHDByMa(t.MaHD,t.MaMon); //} ////them chi tiet moi //DateTime dt = DateTime.Today; //int maB = ca.getMaBan(); //int maNV = 2; //String PT = "Cash"; //double tong = ca.tinhTong(); //String TT = "Chua"; //int x = hd.LuuHoaDon(dt, maB, maNV, PT, tong, TT); //List<Item> lstCart = ca.getCart2(); //foreach (Item i in lstCart) //{ // int maHD = x; // int maMon = i.maMon; // int sl = i.sl; // double tong2 = i.tongTien; // ct.LuuChiTietHD(maHD, maMon, sl, tong2); //} //update lai cac mon an da co; if (ca.getCart2().Count != 0) { tblHoaDon h = hd.getMaHDTheoBan(ca.getMaBan()); List <tblChiTietHD> lstCT = ct.getCTByMaHD(h.MaHD).ToList <tblChiTietHD>(); List <Item> lstCart = ca.getCart2(); double tong1 = ca.tinhTong2(); //update lai chi tiet for (int i = 0; i < lstCT.Count; i++) { for (int j = 0; j < lstCart.Count; j++) { if (lstCT[i].MaMon == lstCart[j].maMon) { ct.suaChiTietHD(lstCT[i].MaHD, lstCT[i].MaMon, (lstCart[j].sl + lstCT[i].SoLuong), (lstCart[j].tongTien + (double)lstCT[i].TongTien)); lstCart.Remove(lstCart[j]); j--; } } } //them cac chi tiet moi foreach (Item i in lstCart) { int maHD = h.MaHD; int maMon = i.maMon; int sl = i.sl; double tong = i.tongTien; ct.LuuChiTietHD(maHD, maMon, sl, tong); } //update lai tong tien cho hoa don hd.suaHoaDon(h.MaHD, (tong1 + (double)h.TongTienTT)); ca.clearCard2(); ca.clearCard(); this.Dispose(); if (Program.frmCNC.Visible == false) { Program.frmCNC = new Form_ChucNangChinh(); } Program.frmCNC.Show(); } else { MessageBox.Show("Moi Chon San Pham"); } } } catch (Exception eee) { } }