public JsonResult CreateFoodAjax(HttpPostedFileBase file, string tenmonan, int loaimonanID)
{
try
{
MonAnDAO objDAO = new MonAnDAO();
MonAn objMonAn = new MonAn();
objMonAn.MaMonAn = XuLy.NextID(objDAO.getLastID(), "MA");
objMonAn.TenMonAn = tenmonan;
int dataLength = (int)file.InputStream.Length;
byte[] _byteArr = new byte[dataLength];
file.InputStream.Read(_byteArr, 0, dataLength);
objMonAn.HinhAnh = _byteArr;
objMonAn.MaLoaiMonAn = loaimonanID.ToString();
int result = objDAO.insertMonAn(objMonAn);
if (result == 2)
{
return(Json(new { iserror = false, isExist = true }));
}
else
{
if (result == 1)
{
return(Json(new { iserror = false, isExist = false }));
}
}
return(Json(new { iserror = true, messageError = "Đã xảy ra lỗi khi thêm mới. Vui lòng kiểm tra lại!" }));
}
catch (Exception ex)
{
return(Json(new { iserror = true, messageError = ex.Message }));
}
}
private void dgvKhachHang_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int viTri = e.RowIndex;
XuLy.CellClickBangKhachHang(txtCMT, txtTenKH, txtSDT, txtDiaChi,
rdbNam, rdbNu, dtpNgaySinh, dgvKhachHang, viTri);
}
private void DatDV_Load(object sender, EventArgs e)
{
// lúc mới khởi tạo combobox phòng không có dữ liệu thì sao m
XuLy.hienthiPhongDatDV(cmbPhong);
XuLy.HienThiDV(dgvTTDV);
}
public DataTable load_On_KhuVuc()
{
DataTable re;
String lenh_KhuVuc = "select * from DIACHI where parent_id != 0";
re = XuLy.TaoBang(lenh_KhuVuc);
return(re);
}
public DataTable load_On()
{
DataTable re;
String lenh_all = "select * from Shipper";
re = XuLy.TaoBang(lenh_all);
return(re);
}
public DataTable load_DoanhThu(object MaShipper)
{
DataTable re;
String lenh_1 = "Select TenShipper,MaDonHang,MaNhanVien,TenKhachHang,DONHANG.SDT,Tinh,Huyen,DCChiTiet,MoTa,TienHang,PhiShip,TongTienDonHang from DonHang join Shipper on DonHang.Shipper = Shipper.MaShipper where DonHang.Shipper = N'" + MaShipper + "' ";
re = XuLy.TaoBang(lenh_1);
return(re);
}
private void dgvPhongthanhtoan_CellClick(object sender, DataGridViewCellEventArgs e)
{
int index = e.RowIndex;
XuLy.hienthiHoaDon(dgvPhongthanhtoan, index, dgvDVdadat, txtmaHD, txtSoPhong, txtTenKH, dtpNgaySinh,
txtGioiTinh, txtDiaChi, txtSoCMT, txtNgayVao
, txtNgayRa, txtGiaPhong, txtTongtien);
}
public DataTable load_DoanhThu(object MaShipper)
{
DataTable re;
String lenh_1 = "select TenShipper,sum(PhiShip) as DoanhThu from DONHANG join SHIPPER on DONHANG.Shipper = SHIPPER.MaShipper where Shipper =" + MaShipper + " group by TenShipper ";
re = XuLy.TaoBang(lenh_1);
return(re);
}
public DataTable load_DonHang(object MaShipper)
{
DataTable re;
String lenh_2 = "select TenShipper,Count(MaDonHang) as TongDonHang from DONHANG join SHIPPER on DONHANG.Shipper = SHIPPER.MaShipper where Shipper = " + MaShipper + " group by TenShipper ";
re = XuLy.TaoBang(lenh_2);
return(re);
}
//private string maDH { get; set; }
//private string maNV { get; set; }
//private string tenKH { get; set; }
//private string sdt { get; set; }
//private string tinh { get; set; }
//private string huyen { get; set; }
//private string xa { get; set; }
//private string chiTiet { get; set; }
//private string ngayLap { get; set; }
//private string moTa { get; set; }
//private string tienHang { get; set; }
//private string phiShip { get; set; }
//private string shipper { get; set; }
//private string tongTien { get; set; }
public DataTable load_On()
{
DataTable re;
String lenh = "select * from DONHANG";
re = XuLy.TaoBang(lenh);
return(re);
}
public DataTable load_City()
{
DataTable re;
String lenh_2 = "select * from DIACHI where parent_id = 0";
re = XuLy.TaoBang(lenh_2);
return(re);
}
public DataTable Load_On()
{
DataTable re;
String lenh = "select * from SHIPPER";
re = XuLy.TaoBang(lenh);
return(re);
}
public DataTable load_KhuVuc(object parent_id)
{
DataTable re;
String lenh_3 = "select * from DIACHI where parent_id = " + parent_id;
re = XuLy.TaoBang(lenh_3);
return(re);
}
public DataTable load_Shipper(object parent_id)
{
DataTable re;
String lenh_4 = "select * from SHIPPER where KhuVucPhuTrach = " + parent_id;
re = XuLy.TaoBang(lenh_4);
return(re);
}
public DataTable load_KhuVuc(object KhuVuc)
{
DataTable re;
String lenh_3 = "Select TenShipper,MaDonHang,MaNhanVien,TenKhachHang,DONHANG.SDT,Tinh,Huyen,DCChiTiet,MoTa,TienHang,PhiShip,TongTienDonHang from DonHang join Shipper on DonHang.Shipper = Shipper.MaShipper where Huyen = N'" + KhuVuc + "' ";
re = XuLy.TaoBang(lenh_3);
return(re);
}
public bool ToFix(String maShipper, String tenShipper, bool gioiTinh, String email, String ngaySinh, String sdt, String khuVuc, String trangThai)
{
String lenh3 = "update SHIPPER set TenShipper = N'" + tenShipper + "', GioiTinh = " + gioiTinh + ", Email = N'" + email + "', Ngaysinh = N'" + ngaySinh + "', SDT = N'" + sdt + "', KhuVucPhuTrach = N'" + khuVuc + "', TrangThai = " + trangThai;
bool re = false;
if (XuLy.ExecuteNonQuery(lenh3) > 0)
{
re = true;
}
return(re);
}
public bool Add_Shipper(String maShipper, String tenShipper, String gioiTinh, String email, String ngaySinh, String sdt, String khuVuc, String trangThai)
{
String lenh1 = "insert into SHIPPER(MaShipper,TenShipper,GioiTinh,Email,NgaySinh,SDT,KhuVucPhuTrach,TrangThai) values('" + maShipper + "','" + tenShipper + "'," + gioiTinh + ",'" + email + "','" + ngaySinh + "','" + sdt + "'," + khuVuc + "," + trangThai + ")";
bool re = false;
if (XuLy.ExecuteNonQuery(lenh1) > 0)
{
re = true;
}
return(re);
}
public bool add_Order(String maDH, String maNV, String tenKH, String sdt, String tinh, String huyen, String chiTiet, String moTa, String tienHang, String phiShip, String shipper)
{
String lenh_1 = "insert into DONHANG values(" + maDH + "," + maNV + ",N'" + tenKH + "',N'" + sdt + "',N'" + tinh + "',N'" + huyen + "',N'" + chiTiet + "',N'" + moTa + "'," + tienHang.ToString() + "," + phiShip.ToString() + ",N'" + shipper + "')";
bool re = false;
if (XuLy.ExecuteNonQuery(lenh_1) > 0)
{
re = true;
}
return(re);
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (txtSoPhong.Text.Trim().Equals(""))
{
MessageBox.Show("Không để trống số phòng", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
XuLy.xoaPhong(txtSoPhong, txtGia, cmbLoaiPhong);
Phong_Load(sender, e);
}
}
public bool Delete_Shipper(String maShipper)
{
//luu y kiem tra neu tinh trang shipper = false thi khong duoc xoa
String lenh2 = "delete from SHIPPER where MaShipper = '" + maShipper + "'";
bool re = false;
if (XuLy.ExecuteNonQuery(lenh2) > 0)
{
re = true;
}
return(re);
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (txtMaDV.Text.Trim().Equals(""))
{
MessageBox.Show("Mã dịch vụ không để trống");
}
else
{
XuLy.xoaTTDV(txtMaDV);
DichVuScreen_Load(sender, e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// khong phai load lai trang
if (!IsPostBack)
{
//string stringSql = string.Format(@"Select * From tblChuDe");
//DataTable dt = XuLy.Xuly_Select(stringSql);
DataTable dt = XuLy.getDL("spChuDe_get");
rpChuDe.DataSource = dt;
rpChuDe.DataBind();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtSoPhong.Text.Trim().Equals(""))
{
MessageBox.Show("Số phòng bị trống");
}
else if (txtmaHD.Text.Trim().Equals(""))
{
MessageBox.Show("Số hóa đơn bị trống");
}
else
{
XuLy.xuatHoaDon(txtmaHD, txtSoPhong);
txtSoPhong.Text = "";
txtmaHD.Text = "";
HoaDon_Load(sender, e);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
DataTable dt = XuLy.getTaiKhoan(txtTenDangNhap.Text, txtMatKhau.Text);
int kq = dt.Rows.Count;
if (kq > 0)
{
Session["admin"] = true;
int idTV = int.Parse(dt.Rows[0]["idTV"].ToString());
Session["idTV"] = idTV;
//string url = "index.aspx?idTV=" + idTV;
Response.Redirect("index.aspx");
}
else
{
lblThongBao.Text = "Đăng nhập thất bại";
}
}
private void btnsua_Click(object sender, EventArgs e)
{
if (txtMaDV.Text.Trim().Equals(""))
{
MessageBox.Show("Mã dịch vụ không để trống");
}
else if (txtTenDV.Text.Trim().Equals(""))
{
MessageBox.Show("Tên dịch vụ không để trống");
}
else if (rtbMoTa.Text.Trim().Equals(""))
{
MessageBox.Show("Mô tả dịch vụ không để trống");
}
else if (txtDonGia.Text.Trim().Equals(""))
{
MessageBox.Show("Giá dịch vụ không để trống");
}
else
{
XuLy.suaTTDV(txtMaDV, txtTenDV, txtDonGia, rtbMoTa);
DichVuScreen_Load(sender, e);
}
}
private void btnHuyTK_Click(object sender, EventArgs e)
{
XuLy.hienthiKhachHang(dgvKhachHang);
XuLy.huyThongTinTimKiem(txtTimKienTenKH, txtTimKiemSoCMT);
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
XuLy.timKiemKhachHang(txtTimKienTenKH, txtTimKiemSoCMT, dgvKhachHang);
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
XuLy.capnhatKhachHang(txtCMT, txtTenKH, txtSDT, txtDiaChi, rdbNam, dtpNgaySinh);
KhachHangScreen_Load(sender, e);
}
private void btnXoa_Click(object sender, EventArgs e)
{
XuLy.xoaKhachHang(txtCMT);
KhachHangScreen_Load(sender, e);
}
private void btnHuy_Click(object sender, EventArgs e)
{
XuLy.huyThongTinHienThi(txtCMT, txtTenKH, txtSDT, txtDiaChi, rdbNam);
//this.Close();
}
public void CapNhatGTXN(XuLy.XiNgau xn)
{
this.SoXN=xn.SoXN;
if(this.SoXN==1)
this.gtXN1=xn.gt1;
else
{
this.gtXN1=xn.gt1;this.gtXN2=xn.gt2;
}
}
