protected void gvThongTinKH_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Xoa")
{
try
{
int chiso = int.Parse(e.CommandArgument.ToString());
string ma = gvThongTinKH.Rows[chiso].Cells[0].Text;
DataTable dt = XLDL.GetData("select MaKH from KhachHang where MaKH='" + ma + "'");
if (dt.Rows.Count > 1)
{
lbBaoLoi.Text = "Khách hàng đang có bài viết nên không thể xóa.<br/> Bạn cần xóa hết các bài viết của khách hàng này trước";
}
else
{
string str = "delete from KhachHang where MaKH='" + ma + "'";
XLDL.Excute(str);
Response.Redirect("~/AD/KhachHang.aspx");
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
//Response.Write("<script>alert('Xóa Thất Bại!!!');</script>");
}
}
}
private int countMess()
{
DataTable dt = new DataTable();
dt = XLDL.GetData("select * from ThongTinLienHe where DaDuyet = 0");
return(int.Parse(dt.Rows.Count.ToString()));
}
protected void gvNhaTro_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Xoa")
{
try
{
int chiso = int.Parse(e.CommandArgument.ToString());
string ma = gvNhaTro.Rows[chiso].Cells[0].Text;
DataTable dt = XLDL.GetData("select MaNhaTro from NhaTroChoThue where MaNhaTro='" + ma + "'");
if (dt.Rows.Count > 1)
{
lbBaoLoi.Text = "Xóa thất bại";
}
else
{
XLDL.Excute("Delete HinhAnhChiTietNhaTro from HinhAnhChiTietNhaTro where HinhAnhChiTietNhaTro.MaNhaTro =" + ma);
XLDL.Excute("Delete DanhGia from DanhGia where DanhGia.MaNhaTro=" + ma);
XLDL.Excute("Delete NhaTroChoThue from NhaTroChoThue where NhaTroChoThue.MaNhaTro =" + ma);
Response.Redirect("~/AD/NhaTro.aspx");
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
//Response.Write("<script>alert('Xóa Thất Bại!!!');</script>");
}
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
String strSearch = txtTimKiem.Text;
String sql, datenew;
int luotTruyCap = 1;
datenew = DateTime.Now.ToString();
DataTable dt = XLDL.GetData("select * from TimKiem where TuKhoa = '" + strSearch + "'");
if (dt.Rows.Count > 0)
{
luotTruyCap = int.Parse(dt.Rows[0]["LuotTruyCap"].ToString());
luotTruyCap++;
sql = "UPDATE TimKiem SET LuotTruyCap = " + luotTruyCap + "" +
", NgayNhapGanNhat = '" + datenew +
"' WHERE TuKhoa = '" + strSearch + "'";
XLDL.GetData(sql);
}
else
{
sql = "INSERT INTO TimKiem VALUES('" + strSearch + "'" +
"," + luotTruyCap + "" +
",'" + datenew + "')";
XLDL.GetData(sql);
}
Response.Redirect("~/SP_Search.aspx?Search=" + strSearch + "");
}
private void LayThongTin(string ms)
{
string str = "Select S.*, TenChuDe FROM HOA S INNER JOIN CHUDE C ON S.MaCD=C.MaCD WHERE S.MaHoa=" + int.Parse(ms);
DataTable dt = XLDL.GetData(str);
if (dt.Rows.Count > 0)
{
dlChiTietHoa.DataSource = dt;
dlChiTietHoa.DataBind();
}
}
public void GH()
{
DataTable dt = new DataTable();
//maSP = Request.QueryString["MaSP"].ToString();
dt = XLDL.GetData("select Ma_SP,TenSP,DonGia,Image from San_Pham inner join San_Pham_Image on Ma_SP = MaSP where Ma_SP= '" + maSP + "' and Position = 0 ");
string TenSP = dt.Rows[0][1].ToString();
float DonGia = float.Parse(dt.Rows[0][2].ToString());
String Image = "/Image/San_Pham/" + dt.Rows[0][3].ToString() + ".jpg";
int SoLuong = 1;
new Product_Des().ThemVaoGioHang(maSP, TenSP, DonGia, SoLuong, Image);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Ma"] != null)
{
string MaQH = Request.QueryString["Ma"].ToString();
string sql = "select [MaTinh],[TenQH] from QuanHuyen where MaQH='" + MaQH + "'";
DataTable dt = XLDL.GetData(sql);
txtMaTinh.Text = dt.Rows[0]["MaTinh"].ToString();
txtTenQuanHuyen.Text = dt.Rows[0]["TenQH"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Ma"] != null)
{
string MaPX = Request.QueryString["Ma"].ToString();
string sql = "select [MaQH],[TenPhuongXa] from PhuongXa where MaPX='" + MaPX + "'";
DataTable dt = XLDL.GetData(sql);
txtMaQH.Text = dt.Rows[0]["MaQH"].ToString();
txtPhuongXa.Text = dt.Rows[0]["TenPhuongXa"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Ma"] != null)
{
string MaAD = Request.QueryString["Ma"].ToString();
string sql = "select [TenTK],[MatKhau],[SDT_Admin] from NguoiQuanLi where ID_Admin='" + MaAD + "'";
DataTable dt = XLDL.GetData(sql);
txtTaiKhoanAD.Text = dt.Rows[0]["TenTK"].ToString();
txtMatKhauAD.Text = dt.Rows[0]["MatKhau"].ToString();
txtSDT_AD.Text = dt.Rows[0]["SDT_Admin"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Ma"] != null)
{
string MaKH = Request.QueryString["Ma"].ToString();
string sql = "select [TenKH],[SDT],[Email],[MatKhau],[TenTK] from KhachHang where MaKH='" + MaKH + "'";
DataTable dt = XLDL.GetData(sql);
txtTenKH.Text = dt.Rows[0]["TenKH"].ToString();
txtSDT.Text = dt.Rows[0]["SDT"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
txtMatKhau.Text = dt.Rows[0]["MatKhau"].ToString();
txtTaiKhoan.Text = dt.Rows[0]["TenTK"].ToString();
}
}
}
protected void btDangKy_Click(object sender, EventArgs e)
{
try
{
string str1 = @"Select 1 from Khachhang Where tenDN=N'" + txtTenDN.Text + "'";
if (XLDL.GetData(str1).Rows.Count > 0)
{
lbThongBaoLoi.Text = "Tên đăng nhập đã tồn tại.";
txtTenDN.Focus();
}
else
{
SqlConnection con = new SqlConnection(XLDL.strCon);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.CommandText = @"INSERT INTO KHACHHANG (HoTenKH,DiaChiKH,DienThoaiKH,Email,TenDN,MatKhau,NgaySinh,GioiTinh) VALUES(@Hoten,@Diachi,@Dienthoai,@Email,@TenDN,@Matkhau,@Ngaysinh,@Gioitinh)";
cmd.Parameters.Add("@Hoten", SqlDbType.NVarChar, 50);
cmd.Parameters["@Hoten"].Value = txtHoTen.Text;
cmd.Parameters.Add("@Diachi", SqlDbType.NVarChar, 50);
cmd.Parameters["@Diachi"].Value = txtDiaChi.Text;
cmd.Parameters.Add("@Dienthoai", SqlDbType.VarChar, 10);
cmd.Parameters["@Dienthoai"].Value = txtDienThoai.Text;
cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50);
cmd.Parameters["@Email"].Value = txtEmail.Text;
cmd.Parameters.Add("@TenDN", SqlDbType.VarChar, 15);
cmd.Parameters["@TenDN"].Value = txtTenDN.Text;
cmd.Parameters.Add("@Matkhau", SqlDbType.VarChar, 15);
cmd.Parameters["@Matkhau"].Value = txtMatKhau.Text;
cmd.Parameters.Add("@Ngaysinh", SqlDbType.SmallDateTime);
cmd.Parameters["@Ngaysinh"].Value = DateTime.Parse(ddlThangSinh.Text + "/" + ddlNgaySinh.Text + "/" + txtNamSinh.Text);
cmd.Parameters.Add("@Gioitinh", SqlDbType.Int);
cmd.Parameters["@Gioitinh"].Value = Convert.ToInt16(rblGioiTinh.SelectedItem.Value);
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("~/Dangnhap.aspx");
}
}
catch
{
lbThongBaoLoi.Text = "Thất bại!";
}
}
private void getSP()
{
DataTable dt = new DataTable();
dt = XLDL.GetData("select * from San_Pham S join San_Pham_Image I on S.Ma_SP = I.MaSP where Position = 0 order by DaBan desc");
//maSP = dt.Rows[0]["Ma_SP"].ToString();
p.DataSource = dt.DefaultView;
p.PageSize = 8;
p.CurrentPageIndex = trang_thu;
p.AllowPaging = true;
btnFirst.Enabled = true;
btnLast.Enabled = true;
btnnext.Enabled = true;
btnpre.Enabled = true;
if (p.IsFirstPage == true)//neu la dau.
{
btnFirst.Enabled = false;//neu la trang dau thi hai nut mo di.
btnpre.Enabled = false;
btnnext.Enabled = true;//Hai nut sau sang len.
btnLast.Enabled = true;
}
if (p.IsLastPage == true)//neu la cuoi
{
btnFirst.Enabled = true;//nguoc lai
btnpre.Enabled = true;
btnnext.Enabled = false;
btnLast.Enabled = false;
}
txtPage.Text = (trang_thu + 1).ToString();
txtMaxPage.Text = p.PageCount.ToString();
dtSPNB.DataSource = p;
dtSPNB.DataBind();
}
protected void gvTinTuc_RowCommand(object sender, GridViewCommandEventArgs e)
{
int chiso = int.Parse(e.CommandArgument.ToString());
int ma = int.Parse(gvTinTuc.Rows[chiso].Cells[0].Text);
if (e.CommandName == "Xoa")
{
try
{
DataTable dt = XLDL.GetData("select * from BLTinTuc where MaTin = " + ma);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('Không thể xóa tin này. Bạn cần xóa hêt bình luận có trong tin này trước')</script>");
}
else
{
dt = XLDL.GetData("delete from TinTuc where MaTin =" + ma);
lbThongBao.Text = "Xóa thành công";
capnhat();
}
}
catch
{
Response.Write("<script>alert('Có lỗi trong quá trình xóa')</script>");
}
}
if (e.CommandName == "Duyet")
{
int duyet = 1;
try
{
string str1 = @"Update TinTuc set Duyet = " + duyet + " where MaTin = " + ma;
XLDL.Execute(str1);
lbThongBao.Text = "Đã duyệt";
capnhat();
}
catch
{
lbThongBao.Text = "Cập nhật thất bại";
}
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
string MaNT = Request.QueryString["Ma"].ToString();
DataTable dt = XLDL.GetData("select [MaKH],[TinhThanh],[QuanHuyen],[PhuongXa],[SoNha],[DiaChi],[SDTNguoiChoThue],[MoTa],[GiaChoThue],[DienTich],[TieuDe] from NhaTroChoThue where MaNhaTro='" + MaNT + "'");
if (dt.Rows.Count > 0)
{
XLDL.Excute(@"update NhaTroChoThue set MaKH=" + txtMaKH.Text + ",TinhThanh=N'" + txtTinhThanh.Text + "',QuanHuyen=N'" + txtQuanHuyen.Text + "',PhuongXa=N'" + txtPhuongXa.Text + "',SoNha=N'" + txtSoNha.Text + "',DiaChi=N'" + txtDiaChi.Text + "',SDTnguoiChoThue='" + txtSDT.Text + "',MoTa=N'" + txtMoTa.Text + "',GiaChoThue='" + txtGiaChoThue.Text + "',DienTich='" + txtDienTich.Text + "',TieuDe=N'" + txtTieuDe.Text + "' where MaNhaTro='" + MaNT + "'");
lbBaoLoi.Text = "Lưu thành công";
}
else
{
lbBaoLoi.Text = "Lưu không thành công!";
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
string MaQH = Request.QueryString["Ma"].ToString();
DataTable dt = XLDL.GetData("select [MaTinh],[TenQH] from QuanHuyen where MaQH='" + MaQH + "'");
if (dt.Rows.Count > 0)
{
XLDL.Excute(@"update QuanHuyen set MaTinh='" + txtMaTinh.Text + "',TenQH=N'" + txtTenQuanHuyen.Text + "' where MaQH='" + MaQH + "'");
lbBaoLoi.Text = "Lưu thành công";
}
else
{
lbBaoLoi.Text = "Lưu không thành công!";
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
string MaAD = Request.QueryString["Ma"].ToString();
DataTable dt = XLDL.GetData("select [TenTK],[MatKhau],[SDT_Admin] from NguoiQuanLi where ID_Admin='" + MaAD + "'");
if (dt.Rows.Count > 0)
{
XLDL.Excute(@"update NguoiQuanLi set TenTK=N'" + txtTaiKhoanAD.Text + "',MatKhau='" + txtMatKhauAD.Text + "',SDT_Admin='" + txtSDT_AD.Text + "' where ID_Admin='" + MaAD + "'");
lbBaoLoi.Text = "Lưu thành công";
}
else
{
lbBaoLoi.Text = "Lưu không thành công!";
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
string MaKH = Request.QueryString["Ma"].ToString();
DataTable dt = XLDL.GetData("select [TenKH],[SDT],[Email],[MatKhau],[TenTK] from KhachHang where MaKH='" + MaKH + "'");
if (dt.Rows.Count > 0)
{
XLDL.Excute(@"update KhachHang set TenKH=N'" + txtTenKH.Text + "',SDT='" + txtSDT.Text + "',Email='" + txtEmail.Text + "',MatKhau='" + txtMatKhau.Text + "',TenTK='" + txtTaiKhoan.Text + "' where MaKH='" + MaKH + "'");
lbBaoLoi.Text = "Lưu thành công";
}
else
{
lbBaoLoi.Text = "Lưu không thành công!";
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
string MaPX = Request.QueryString["Ma"].ToString();
DataTable dt = XLDL.GetData("select [MaQH],[TenPhuongXa] from PhuongXa where MaPX='" + MaPX + "'");
if (dt.Rows.Count > 0)
{
XLDL.Excute(@"update PhuongXa set MaQH='" + txtMaQH.Text + "',TenPhuongXa=N'" + txtPhuongXa.Text + "' where MaPX='" + MaPX + "'");
lbBaoLoi.Text = "Lưu thành công";
}
else
{
lbBaoLoi.Text = "Lưu không thành công!";
}
}
catch
{
lbBaoLoi.Text = "Thất bại";
}
}
protected void gvQuanTriVIen_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Xoa")
{
try
{
int chiso = int.Parse(e.CommandArgument.ToString());
string ma = gvQuanTriVIen.Rows[chiso].Cells[0].Text;
DataTable dt = XLDL.GetData("select ID_Admin from NguoiQuanLi where ID_Admin='" + ma + "'");
string str = "delete from NguoiQuanLi where ID_Admin='" + ma + "'";
XLDL.Excute(str);
Response.Redirect("~/AD/QuanTriVien.aspx");
}
catch
{
lbBaoLoi.Text = "Thất bại";
//Response.Write("<script>alert('Xóa Thất Bại!!!');</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Ma"] != null)
{
string MaNT = Request.QueryString["Ma"].ToString();
string sql = "select [MaKH],[TinhThanh],[QuanHuyen],[PhuongXa],[SoNha],[DiaChi],[SDTNguoiChoThue],[MoTa],[GiaChoThue],[DienTich],[TieuDe] from NhaTroChoThue where MaNhaTro='" + MaNT + "'";
DataTable dt = XLDL.GetData(sql);
txtMaKH.Text = dt.Rows[0]["MaKH"].ToString();
txtTinhThanh.Text = dt.Rows[0]["TinhThanh"].ToString();
txtQuanHuyen.Text = dt.Rows[0]["QuanHuyen"].ToString();
txtPhuongXa.Text = dt.Rows[0]["PhuongXa"].ToString();
txtSoNha.Text = dt.Rows[0]["SoNha"].ToString();
txtDiaChi.Text = dt.Rows[0]["DiaChi"].ToString();
txtSDT.Text = dt.Rows[0]["SDTNguoiChoThue"].ToString();
txtMoTa.Text = dt.Rows[0]["MoTa"].ToString();
txtGiaChoThue.Text = dt.Rows[0]["GiaChoThue"].ToString();
txtDienTich.Text = dt.Rows[0]["DienTich"].ToString();
txtTieuDe.Text = dt.Rows[0]["TieuDe"].ToString();
}
}
}
private void chuaduyet()
{
gvTinTuc.DataSource = XLDL.GetData("select * from TinTuc where Duyet='0' order by NgayDang DESC ");
gvTinTuc.DataBind();
}
private void laylogo()
{
DataTable dt1 = XLDL.GetData("select * from LoGo");
Image1.ImageUrl = "~/Images/Logo/" + dt1.Rows[0][0].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
dlTinMoi.DataSource = XLDL.GetData("SELECT top 5 [TieuDe], [MaNhaTro] FROM [NhaTroChoThue] ORDER BY [MaNhaTro] DESC");
dlTinMoi.DataBind();
}
private void chuaduyet()
{
gvDangBan.DataSource = XLDL.GetData("select * from BaiDang where Duyet='0' order by NgayDang DESC ");
gvDangBan.DataBind();
}
private void getMenuSP()
{
dtMenuSP.DataSource = XLDL.GetData("select * from Hang_San_Xuat");
dtMenuSP.DataBind();
}