public CHI_TIET_HOA_DON GetDVByMa(int pMaHD, int pMaSP)
{
CHI_TIET_HOA_DON result = new CHI_TIET_HOA_DON();
result = context.CHI_TIET_HOA_DON.FirstOrDefault(m => m.MA_HD == pMaHD && m.MA_SP == pMaSP);
return(result);
}
public ActionResult DatHang(FormCollection collection)
{
HOA_DON hd = new HOA_DON();
KHACH_HANG kh = (KHACH_HANG)Session["TaiKhoan"];
List <GioHang> gh = LayGioHang();
//hd.MaHD = "HD" + data.HOA_DONs.Count();
//hd.TaiKhoan = kh.TaiKhoan;
hd.ThoiGian = DateTime.Now;
//var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]);
//dh.NGAYGIAO = DateTime.Parse(NgayGiao);
//hd.NGAYGIAO = DateTime.Now.AddDays(2);
//hd.TINHTRANGGIAOHANG = "Đang tiếp nhận";
// hd.TINHTRANGTHANHTOAN = "Chưa thanh toán";
data.HOA_DONs.InsertOnSubmit(hd);
data.SubmitChanges();
foreach (var item in gh)
{
CHI_TIET_HOA_DON CTDH = new CHI_TIET_HOA_DON();
CTDH.MaHD = hd.MaHD;
CTDH.MaSP = Convert.ToInt32(item.ma);
CTDH.SoLuong = item.sl;
//Chú ý chỗ này chưa sửa donGia
CTDH.GiaBan = (decimal)item.donGia;
data.CHI_TIET_HOA_DONs.InsertOnSubmit(CTDH);
}
data.SubmitChanges();
Session["Giohang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
public int Add(CHI_TIET_HOA_DON p)
{
int result = 0;
context.CHI_TIET_HOA_DON.Add(p);
result = context.SaveChanges();
return(result);
}
public int Delete(int pMaHD, int pMaSP)
{
int result = 0;
CHI_TIET_HOA_DON k = context.CHI_TIET_HOA_DON.FirstOrDefault(m => m.MA_HD == pMaHD && m.MA_SP == pMaSP);
context.CHI_TIET_HOA_DON.Remove(k);
result = context.SaveChanges();
return(result);
}
public static bool XuatHang(int maHoaDon, SAN_PHAM sp)
{
CHI_TIET_HOA_DON tmp = new CHI_TIET_HOA_DON();
tmp.GIA = sp.GIA_BAN;
tmp.MA_HOA_DON = maHoaDon;
tmp.IMEI = sp.IMEI;
CHI_TIET_HOA_DON.insert(tmp);
return(true);
}
public static bool NhapHang(int maHoaDon, string imei, int gia)
{
CHI_TIET_HOA_DON tmp = new CHI_TIET_HOA_DON();
tmp.GIA = gia;
tmp.MA_HOA_DON = maHoaDon;
tmp.IMEI = imei;
CHI_TIET_HOA_DON.insert(tmp);
return(true);
}
public static List <CHI_TIET_HOA_DON> LayChiTietHoaDon(int maHoaDon)
{
try
{
return(CHI_TIET_HOA_DON.select(" where MA_HOA_DON = " + maHoaDon + " "));
}
catch (Exception)
{
return(null);
}
}
public void insert(int idBill, String tenHH, int soLuong)
{
int idHH = Merchandise_DAL.Instance.GetIDByName(tenHH);
CHI_TIET_HOA_DON chitietHD = new CHI_TIET_HOA_DON
{
ID_HD = idBill,
ID_HH = idHH,
soluong = soLuong
};
CHI_TIET_HOA_DON_DAL.Instance.Add(chitietHD);
CHI_TIET_HOA_DON_DAL.Instance.Sync();
}
public int Update(CHI_TIET_HOA_DON p)
{
int result = 0;
CHI_TIET_HOA_DON k = context.CHI_TIET_HOA_DON.FirstOrDefault(m => m.MA_HD == p.MA_HD && m.MA_SP == p.MA_SP);
if (k != null)
{
k.SO_LUONG = p.SO_LUONG;
k.THANH_TIEN = p.THANH_TIEN;
}
result = context.SaveChanges();
return(result);
}
public void delete(int idBill, String tenHH, int soLuong)
{
int idHH = Merchandise_DAL.Instance.GetIDByName(tenHH);
int idCTHD = CHI_TIET_HOA_DON_DAL.Instance.GetID(idBill, idHH);
CHI_TIET_HOA_DON chitiet = new CHI_TIET_HOA_DON
{
ID_CTHD = idCTHD,
ID_HD = idBill,
ID_HH = idHH,
soluong = soLuong,
};
CHI_TIET_HOA_DON_DAL.Instance.Delete(chitiet);
CHI_TIET_HOA_DON_DAL.Instance.Sync();
}
protected void btn_datHang_Click(object sender, EventArgs e)
{
if (Session["MA_KH"] == null)
{
Response.Redirect("../Login/login.aspx");
}
else
{
HOA_DON hd = new HOA_DON();
hd.MA_KH = Convert.ToInt32(Session["MA_KH"]);
if (hdDAL.Add(hd) == 1)
{
double tongtien = 0;
if (CartItemGridView.Rows.Count > 0)
{
foreach (GridViewRow row in CartItemGridView.Rows)
{
CHI_TIET_HOA_DON ct = new CHI_TIET_HOA_DON();
ct.MA_HD = hd.MA_HD;
ct.MA_SP = Int32.Parse(row.Cells[1].Text);
TextBox sl = (TextBox)row.FindControl("txt_SoLuong");
//ct.SO_LUONG = Int32.Parse(row.Cells[4].Text);
ct.SO_LUONG = Int32.Parse(sl.Text);
Label giastr = (Label)row.FindControl("txt_gia");
double gia = double.Parse(giastr.Text);
ct.THANH_TIEN = ct.SO_LUONG * gia;
chiTietHoaDonService.Add(ct);
tongtien += ct.THANH_TIEN.GetValueOrDefault();
}
}
hd.TONG_TIEN = tongtien;
hdDAL.Update(hd);
Session.Remove("cart");
lb_notify.Visible = true;
lb_notify.Text = "Bạn đã đặt hàng thành công!";
}
else
{
lb_notify.Visible = true;
lb_notify.Text = "Bạn đã đặt hàng không thành công!";
}
}
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
//Button thêm món mới cho bàn sử dụng
private void bnt_ThemMon_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(txt_SoHoaDon.Text))
{
CHI_TIET_HOA_DON ct = new CHI_TIET_HOA_DON();
ct.ID_Mon = int.Parse(gridView_ThucDon.GetRowCellValue(gridView_ThucDon.FocusedRowHandle,
"ID_Mon").ToString());
ct.So_Luong = 1;
int idHoaDon = int.Parse(txt_SoHoaDon.Text);
ct.ID_Hoa_Don = idHoaDon;
_hoaDonBLL.ThemChiTietHoaDon(ct);
LoadDaTaChiTietHoaDon(idHoaDon);
}
else
{
Utils.Notification.Error("Bạn chưa chọn hóa đơn.");
}
}
private void icoBtnTraphong_Click(object sender, EventArgs e)
{
//Check tra chua
if (maThuePhong == "")
{
MessageBox.Show("Vui lòng chọn phiếu thuê trước!", "Thông tin");
}
else
{
// thanh toan chua
HOA_DON hd = context.HOA_DON.FirstOrDefault(p => p.MaThuePhong == maThuePhong);
if (hd == null)
{
HOA_DON hdCuoi = context.HOA_DON.ToList().LastOrDefault();
if (hdCuoi == null)
{
// HD001
String maMoi = "HD001";
PHIEU_THUE_PHONG phieuThue = context.PHIEU_THUE_PHONG.FirstOrDefault(p => p.MaThuePhong == maThuePhong);
//Tinh tien
double tongTien = 0;
CHI_TIET_PHIEU_THUE_PHONG ctThuePhong = context.CHI_TIET_PHIEU_THUE_PHONG.FirstOrDefault(p => p.MaThuePhong == maThuePhong);
ctThuePhong.NgayTra = DateTime.Now;
context.SaveChanges();
//tinh so ngay
Double milTime = DateTime.Parse(ctThuePhong.NgayTraDuKien.ToString()).Day - DateTime.Parse(ctThuePhong.NgayNhan.ToString()).Day + 1;
Double month = DateTime.Parse(ctThuePhong.NgayTraDuKien.ToString()).Month - DateTime.Parse(ctThuePhong.NgayNhan.ToString()).Month;
Double year = DateTime.Parse(ctThuePhong.NgayTraDuKien.ToString()).Year - DateTime.Parse(ctThuePhong.NgayNhan.ToString()).Year;
double dayTime = (milTime + 31 * month + 365 * year);
//Tien phong
PHONG phong = context.PHONG.FirstOrDefault(p => p.MaPhong == ctThuePhong.MaPhong);
LOAI_PHONG loaiPhong = context.LOAI_PHONG.FirstOrDefault(p => p.MaLoaiPhong == phong.MaLoaiPhong);
double tienPhong = dayTime * Double.Parse(loaiPhong.DonGia.ToString());
//Tien dich vu
List <DANH_SACH_SU_DUNG_DICH_VU> ds = context.DANH_SACH_SU_DUNG_DICH_VU.ToList();
double tienDV = 0;
foreach (var item in ds)
{
if (item.MaThuePhong == maThuePhong)
{
tienDV += Double.Parse(loaiPhong.DonGia.ToString()) * Double.Parse(item.SoLuong.ToString());
}
}
tongTien = tienPhong + tienDV;
tongtienthue = tongTien;
HOA_DON newHD = new HOA_DON()
{
MaHoaDon = maMoi, MaNhanVien = phieuThue.MaNhanVien, MaThuePhong = maThuePhong, NgayLap = DateTime.Now, TongTien = long.Parse(tongTien.ToString())
};
context.HOA_DON.Add(newHD);
context.SaveChanges();
CHI_TIET_HOA_DON ctHD = new CHI_TIET_HOA_DON()
{
MaHoaDon = maMoi, MaThuePhong = maThuePhong, SoNgay = int.Parse(dayTime.ToString()), ThanhTien = long.Parse(tongTien.ToString()), TienDichVu = long.Parse(tienDV.ToString()), TienPhong = long.Parse(tienPhong.ToString())
};
context.CHI_TIET_HOA_DON.Add(ctHD);
//Cap nhat lai tinh trang phong
phong.MaLoaiTinhTrangPhong = "TP001";
context.SaveChanges();
loadData();
//Tra phong xuat hoa don
}
else
{
PHIEU_THUE_PHONG phieuThue = context.PHIEU_THUE_PHONG.FirstOrDefault(p => p.MaThuePhong == maThuePhong);
String maMoi = convertNumbtoID(hdCuoi.MaHoaDon.Replace("HD", ""));
//Tinh tien
Double tongTien = 0;
CHI_TIET_PHIEU_THUE_PHONG ctThuePhong = context.CHI_TIET_PHIEU_THUE_PHONG.FirstOrDefault(p => p.MaThuePhong == maThuePhong);
ctThuePhong.NgayTra = DateTime.Now;
context.SaveChanges();
//tinh so ngay
Double milTime = DateTime.Parse(ctThuePhong.NgayTraDuKien.ToString()).Day - DateTime.Parse(ctThuePhong.NgayNhan.ToString()).Day + 1;
Double month = DateTime.Parse(ctThuePhong.NgayTraDuKien.ToString()).Month - DateTime.Parse(ctThuePhong.NgayNhan.ToString()).Month;
Double year = DateTime.Parse(ctThuePhong.NgayTraDuKien.ToString()).Year - DateTime.Parse(ctThuePhong.NgayNhan.ToString()).Year;
double dayTime = (milTime + 31 * month + 365 * year);
//Tien phong
PHONG phong = context.PHONG.FirstOrDefault(p => p.MaPhong == ctThuePhong.MaPhong);
LOAI_PHONG loaiPhong = context.LOAI_PHONG.FirstOrDefault(p => p.MaLoaiPhong == phong.MaLoaiPhong);
Double tienPhong = dayTime * Double.Parse(loaiPhong.DonGia.ToString());
//Tien dich vu
List <DANH_SACH_SU_DUNG_DICH_VU> ds = context.DANH_SACH_SU_DUNG_DICH_VU.ToList();
Double tienDV = 0;
foreach (var item in ds)
{
if (item.MaThuePhong == maThuePhong)
{
tienDV += Double.Parse(loaiPhong.DonGia.ToString()) * Double.Parse(item.SoLuong.ToString());
}
}
tongTien = tienPhong + tienDV;
HOA_DON newHD = new HOA_DON()
{
MaHoaDon = maMoi, MaNhanVien = phieuThue.MaNhanVien, MaThuePhong = maThuePhong, NgayLap = DateTime.Now, TongTien = long.Parse(tongTien.ToString())
};
context.HOA_DON.Add(newHD);
context.SaveChanges();
CHI_TIET_HOA_DON ctHD = new CHI_TIET_HOA_DON()
{
MaHoaDon = maMoi, MaThuePhong = maThuePhong, SoNgay = int.Parse(dayTime.ToString()), ThanhTien = long.Parse(tongTien.ToString()), TienDichVu = long.Parse(tienDV.ToString()), TienPhong = long.Parse(tienPhong.ToString())
};
context.CHI_TIET_HOA_DON.Add(ctHD);
//Cap nhat lai tinh trang phong
phong.MaLoaiTinhTrangPhong = "TP001";
context.SaveChanges();
loadData();
//Tra phong xuat hoa don
}
}
else
{
MessageBox.Show("Phiếu thuê phòng này đã thanh toán", "Thông tin");
}
}
}
