protected void btDangNhap_Click1(object sender, EventArgs e) { try { DataTable dt1, dt2; dt1 = XLDL.GetData("select MaTV,TenTV from ThanhVien where Email = '" + txtEmail.Text + "' and MatKhau = '" + txtMatKhau.Text + "'"); dt2 = XLDL.GetData("select MaAdmin,TenAdmin from Admin where Email = '" + txtEmail.Text + "' and MatKhau = '" + txtMatKhau.Text + "'"); if (dt1.Rows.Count > 0) { Session["MaTV"] = dt1.Rows[0][0].ToString(); Session["TenTV"] = dt1.Rows[0][1].ToString(); Response.Redirect("~/Index.aspx"); } if (dt2.Rows.Count > 0) { Session["MaAdmin"] = dt2.Rows[0][0].ToString(); Session["TenAdmin"] = dt2.Rows[0][1].ToString(); Response.Redirect("~/Admin/Admin.aspx"); } else { Response.Write("<script>alert('sai tài khoản hoặc mật khẩu')</script>"); } } catch { Response.Write("<script>alert('Có lỗi trong quá trình đăng nhập')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { DataList1.DataSource = XLDL.GetData("select top 3 TT.*,TV.TenTV from TinTuc TT,ThanhVien TV where TV.MaTV = TT.MaTV and Duyet='1' order by NgayDang DESC"); DataList1.DataBind(); DataList2.DataSource = XLDL.GetData("select top 6 BD.*,TV.TenTV from BaiDang BD, ThanhVien TV where TV.MaTV = BD.MaTV and Duyet='1' order by NgayDang DESC"); DataList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack != true) { if (Request.QueryString["MaBai"] != null)/*xảy ra trường hợp 1*/ { int MaBai = int.Parse(Request.QueryString["MaBai"]); DataTable dt = XLDL.GetData("SELECT TieuDe,DonGia from BaiDang WHERE MaBai = " + MaBai); String TieuDe = dt.Rows[0][0].ToString(); double DonGia = double.Parse(dt.Rows[0][1].ToString()); int SoLuong = 1; ThemVaoGioHang(MaBai, TieuDe, DonGia, SoLuong); } if (Session["GioHang"] != null) { DataTable dt = new DataTable(); dt = (DataTable)Session["GioHang"]; System.Decimal TongThanhTien = 0; foreach (DataRow r in dt.Rows) { r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDouble(r["DonGia"]); TongThanhTien += Convert.ToDecimal(r["ThanhTien"]); lbTongThanhTien.Text = TongThanhTien.ToString(); } gvGioHang.DataSource = dt; gvGioHang.DataBind(); } } }
protected void btBoThich_Click(object sender, EventArgs e) { int MaBai = int.Parse(Request.QueryString["MaBai"]); XLDL.Execute("delete from Thich where MaTV = " + Session["MaTV"] + " and MaBai = " + MaBai); kiemtralike(); load(); }
protected void btThich_Click1(object sender, EventArgs e) { int MaBai = int.Parse(Request.QueryString["MaBai"]); XLDL.Execute("INSERT INTO Thich(MaTV,MaBai) values(" + Session["MaTV"] + "," + MaBai + ")"); kiemtralike(); load(); }
protected void btDongY_Click(object sender, EventArgs e) { int httt = 0, htgh = 0; string TenNguoiNhan, DiaChiNhan, DienThoaiNhan; TenNguoiNhan = txtNguoiNhan.Text; DiaChiNhan = txtNguoiNhan.Text; DienThoaiNhan = txtDienThoai.Text; decimal tongthanhtien = decimal.Parse(lbTongTien.Text); // httt = Convert.ToInt32(rblHinhThucThanhToan.SelectedItem.Value); htgh = Convert.ToInt32(rblhinhThucGiaoHang.SelectedItem.Value); try { SqlConnection con = new SqlConnection(XLDL.strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.Connection = con; cmd.CommandText = @"insert into DonDatHang(MaTV,NgayDH,TriGia,NgayGH,TenNguoiNhan,DiaChiNhan,DTNhan,HTTT,HTGH) Values(" + Session["MaTV"] + ",@ngaydathang," + tongthanhtien + ",@ngaygiaohang,N'" + TenNguoiNhan + "',N'" + DiaChiNhan + "','" + DienThoaiNhan + "'," + httt + "," + htgh + ")"; cmd.Parameters.Add("@ngaydathang", SqlDbType.SmallDateTime); cmd.Parameters["@ngaydathang"].Value = DateTime.Now; cmd.Parameters.Add("@ngaygiaohang", SqlDbType.SmallDateTime); cmd.Parameters["@ngaygiaohang"].Value = calNgayGiao.SelectedDate; cmd.ExecuteNonQuery(); con.Close(); //laymadonhang string s = @"Select max(MaDH) from DonDatHang Where MaTV = " + Session["MaTV"]; int MaDH = int.Parse(XLDL.GetData(s).Rows[0][0].ToString()); DataTable dt = new DataTable(); dt = (DataTable)Session["GioHang"]; int MaSP, SoLuong; double DonGia, ThanhTien; /* Luu san pham vao table CTDATHANG */ for (int i = 0; i < dt.Rows.Count; i++) { MaSP = int.Parse(dt.Rows[i]["MaBai"].ToString()); SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); DonGia = double.Parse(dt.Rows[i]["DonGia"].ToString()); ThanhTien = double.Parse(dt.Rows[i]["ThanhTien"].ToString()); s = "INSERT INTO CTDatHang(MaDH,MaBai,SoLuong,DonGia,ThanhTien) VALUES(" + MaDH + "," + MaSP + "," + SoLuong + "," + DonGia + "," + ThanhTien + ")"; XLDL.Execute(s); XLDL.Execute("Update BaiDang set TrangThai = '1' where MaBai = " + MaSP); } /* xoa gio hang sau khi da thuc hien xong dat hang*/ Session["GioHang"] = null; /*Sau khi dat hang se chuyen toi trang XAc nhan don hang */ Response.Redirect("~/Xacnhandonhang.aspx"); } catch { lbThongBaoLoi.Text = "Lỗi trong quá trình cập nhật dữ liệu!"; } }
private void load() { int MaTin = int.Parse(Request.QueryString["MaTin"]); DataTable dt = new DataTable(); dt = XLDL.GetData("Select TieuDe,TomTat,NoiDung from TinTuc where MaTin = " + MaTin); txtTieuDe.Text = dt.Rows[0][0].ToString(); txtTomTat.Text = dt.Rows[0][1].ToString(); CKEditorControl1.Text = dt.Rows[0][2].ToString(); }
private void load() { int MaTin = int.Parse(Request.QueryString["MaTin"]); DataTable dt1, dt2; dt1 = XLDL.GetData("select TieuDe,NoiDung from TinTuc where MaTin = " + MaTin); lbTieuDe.Text = dt1.Rows[0][0].ToString(); lbNoiDung.Text = dt1.Rows[0][1].ToString(); dt2 = XLDL.GetData("select TV.TenTV, BLTT.NoiDung,BLTT.NgayBL from ThanhVien TV,BLTinTuc BLTT where TV.MaTV = BLTT.MaTV and BLTT.MaTin = " + MaTin + " order by NgayBL DESC"); dlBinhLuan.DataSource = dt2; dlBinhLuan.DataBind(); }
private void capnhat() { string chuoitk = Request.QueryString["chuoitk"]; DataTable dt1, dt2; dt1 = XLDL.GetData("SELECT * FROM BaiDang WHERE TieuDe LIKE N'%" + chuoitk + "%' and Duyet = '1'"); dt2 = XLDL.GetData("SELECT * FROM TinTuc WHERE TieuDe LIKE N'%" + chuoitk + "%' and Duyet = '1'"); DataList1.DataSource = dt2; DataList1.DataBind(); DataList2.DataSource = dt1; DataList2.DataBind(); }
protected void btSua_Click(object sender, EventArgs e) { try { int MaTin = int.Parse(Request.QueryString["MaTin"]); XLDL.Execute("update TinTuc set TieuDe = N'" + txtTieuDe.Text.Trim() + "', TomTat = N'" + txtTomTat.Text.Trim() + "', NoiDung = N'" + CKEditorControl1.Text.ToString() + "' where MaTin = " + MaTin); Response.Redirect("~/QLBaiviet.aspx"); } catch { Response.Write("<script>alert('lỗi')</script>"); } }
private void load() { int MaBai = int.Parse(Request.QueryString["MaBai"]); DataTable dt = new DataTable(); dt = XLDL.GetData("Select TieuDe,NoiDung,DonGia,TomTat,HinhMinhHoa from BaiDang where MaBai = " + MaBai); txtTieuDe.Text = dt.Rows[0][0].ToString(); CKEditorControl1.Text = dt.Rows[0][1].ToString(); txtDonGia.Text = dt.Rows[0][2].ToString(); txtTomTat.Text = dt.Rows[0][3].ToString(); Image1.ImageUrl = "~/Images/BaiDang/" + dt.Rows[0][4].ToString(); Session["TenHinh"] = dt.Rows[0][4].ToString(); }
private void load() { int MaBai = int.Parse(Request.QueryString["MaBai"]); DataTable dt1, dt2, dt3; dt1 = XLDL.GetData("select TieuDe,HinhMinhHoa,NoiDung from BaiDang where MaBai = " + MaBai); Image1.ImageUrl = "~/Images/BaiDang/" + dt1.Rows[0][1].ToString(); lbTieuDe.Text = dt1.Rows[0][0].ToString(); lbNoiDung.Text = dt1.Rows[0][2].ToString(); dt2 = XLDL.GetData("select TV.TenTV, BLBD.NoiDung,BLBD.NgayBL from ThanhVien TV,BLBaiDang BLBD where TV.MaTV = BLBD.MaTV and BLBD.MaBai = " + MaBai + " order by NgayBL DESC"); dlBinhLuan.DataSource = dt2; dlBinhLuan.DataBind(); dt3 = XLDL.GetData("SELECT COUNT(*) as SLLike FROM Thich where MaBai = " + MaBai); lbSLLike.Text = dt3.Rows[0][0].ToString(); }
private void kiemtralike() { int MaBai = int.Parse(Request.QueryString["MaBai"]); DataTable dt = XLDL.GetData("select * from Thich where MaTV = " + Session["MaTV"] + " and MaBai = " + MaBai); if (dt.Rows.Count > 0) { btBoThich.Visible = true; btThich.Visible = false; } else { btBoThich.Visible = false; btThich.Visible = true; } }
//decimal a; protected void Page_Load(object sender, EventArgs e) { if (IsPostBack != true) { if (Session["MaTV"] == null) { Response.Redirect("~/Dangnhap.aspx"); } if (Session["GioHang"] == null) { Response.Redirect("~/Giohang.aspx"); } if (Session["MaTV"] != null) { string s = @"select MaTV,TenTV,DiaChi,SDT,Email from ThanhVien where MaTV ='" + Session["MaTV"].ToString() + "'"; DataTable dt = XLDL.GetData(s); if (dt.Rows.Count > 0) { lbHoTen.Text = dt.Rows[0][1].ToString(); lbDiaChi.Text = dt.Rows[0][2].ToString(); lbDienThoai.Text = dt.Rows[0][3].ToString(); lbEmail.Text = dt.Rows[0][4].ToString(); txtNguoiNhan.Text = dt.Rows[0][1].ToString(); txtDiaChi.Text = dt.Rows[0][2].ToString(); txtDienThoai.Text = dt.Rows[0][3].ToString(); } } if (Session["GioHang"] != null) { DataTable dt = new DataTable(); dt = (DataTable)Session["GioHang"]; System.Decimal tongthanhtien = 0; foreach (DataRow r in dt.Rows) { r["ThanhTien"] = Convert.ToInt32(r["SoLuong"]) * Convert.ToDecimal(r["DonGia"]); tongthanhtien += Convert.ToDecimal(r["Thanhtien"]); lbTongTien.Text = tongthanhtien.ToString(); //Session["lbtongthanhtien"] = tongthanhtien; // a = tongthanhtien; } gvGioHang.DataSource = dt; gvGioHang.DataBind(); } calNgayGiao.SelectedDate = DateTime.Today; } }
protected void gvTinTuc_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Xoa") { try { int chiso = int.Parse(e.CommandArgument.ToString()); int ma = int.Parse(gvTinTuc.Rows[chiso].Cells[0].Text); DataTable dt = XLDL.GetData("delete from TinTuc where MaTin =" + ma); Response.Write("<script>alert('Xóa thành công')</script>"); laytintuc(); } catch { Response.Write("<script>alert('Lỗi')</script>"); } } }
protected void btDangKy_Click(object sender, EventArgs e) { try { string str1 = @"select * from ThanhVien where Email = '" + txtEmail.Text + "'"; if (XLDL.GetData(str1).Rows.Count > 0) { lbThongBaoLoi.Text = "Tên đăng nhập đã tồn tại"; txtEmail.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 ThanhVien (TenTV,GioiTinh,NgaySinh,Email,MatKhau,DiaChi,SDT) VALUES (@tentv,@gioitinh,@ngaysinh,@email,@matkhau,@diachi,@sdt)"; cmd.Parameters.Add("@tentv", SqlDbType.NVarChar, 50); cmd.Parameters["@tentv"].Value = txtHoTen.Text; cmd.Parameters.Add("@gioitinh", SqlDbType.Int); cmd.Parameters["@gioitinh"].Value = Convert.ToInt16(rblGioiTinh.SelectedItem.Value.Equals("Nam") ? 1 : 0); cmd.Parameters.Add("@ngaysinh", SqlDbType.SmallDateTime); cmd.Parameters["@ngaysinh"].Value = DateTime.Parse(txtNamSinh.Text + "-" + ddlThangSinh.Text + "-" + ddlNgaySinh.Text); cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50); cmd.Parameters["@Email"].Value = txtEmail.Text; cmd.Parameters.Add("@matkhau", SqlDbType.VarChar, 50); cmd.Parameters["@matkhau"].Value = txtMatKhau.Text; cmd.Parameters.Add("@diachi", SqlDbType.NVarChar, 50); cmd.Parameters["@diachi"].Value = txtDiaChi.Text; cmd.Parameters.Add("@sdt", SqlDbType.VarChar, 10); cmd.Parameters["@sdt"].Value = txtDienThoai.Text; cmd.ExecuteNonQuery(); con.Close(); Response.Redirect("~/Dangnhap.aspx"); } } catch { lbThongBaoLoi.Text = "Thất bại!"; } }
protected void btLuu_Click(object sender, EventArgs e) { try { DataTable dt = XLDL.GetData("select MatKhau from ThanhVien where MaTV = " + Session["MaTV"]); if (dt.Rows[0][0].ToString() == txtMKCu.Text) { XLDL.Execute("UPDATE KHACHHANG Set MatKhau = '" + txtMKMoi.Text + "' where MaTV = " + Session["MaTV"]); Response.Redirect("~/QLTaikhoan.aspx"); } else { lbThongBao.Text = "Mật khẩu cũ không đúng!"; } } catch { lbThongBao.Text = "Thất bại!"; } }
protected void btSua_Click(object sender, EventArgs e) { if (file_upload.HasFile == false) { sTenfile = Session["TenHinh"].ToString(); } else { sTenfile = file_upload.FileName; } try { int MaBai = int.Parse(Request.QueryString["MaBai"]); XLDL.Execute("update BaiDang set TieuDe = N'" + txtTieuDe.Text.Trim() + "', TomTat = N'" + txtTomTat.Text.Trim() + "', NoiDung = N'" + CKEditorControl1.Text.ToString() + "', DonGia = " + txtDonGia.Text.Trim() + ", HinhMinhHoa = '" + sTenfile + "' where MaBai = " + MaBai); file_upload.SaveAs(MapPath("~/Images/BaiDang/" + sTenfile)); Response.Redirect("~/QLBaiviet.aspx"); Session["TenHinh"] = null; } catch { Response.Write("<script>alert('lỗi')</script>"); } }
private void laytintuc() { DataList1.DataSource = XLDL.GetData("select TT.*,TV.TenTV from TinTuc TT,ThanhVien TV where TV.MaTV = TT.MaTV and Duyet='1' order by NgayDang DESC"); DataList1.DataBind(); }
private void laybaidang() { gvDangBan.DataSource = XLDL.GetData("Select * from BaiDang where MaTV = " + Session["MaTV"] + " order by NgayDang DESC "); gvDangBan.DataBind(); }
private void laytintuc() { gvTinTuc.DataSource = XLDL.GetData("select * from TinTuc where MaTV = " + Session["MaTV"] + " order by NgayDang DESC "); gvTinTuc.DataBind(); }
protected void btDang_Click(object sender, EventArgs e) { if (DropDownList1.SelectedItem.Value == "0") { try { string str1 = @"Select * from BaiDang Where TieuDe = '" + txtTieuDe.Text + "'"; if (XLDL.GetData(str1).Rows.Count > 0) { lbThongBao.Text = "Bài viết đã tồn tại"; txtTieuDe.Focus(); } else { string sTenfile; sTenfile = file_upload.FileName; SqlConnection con = new SqlConnection(XLDL.strCon); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.Connection = con; cmd.CommandText = @"INSERT INTO BaiDang(TieuDe,NoiDung,DonGia,NgayDang,MaTV,TomTat,HinhMinhHoa) VALUES(@tieude,@noidung,@dongia,@ngaydang,@matv,@tomtat,@hinhminhhoa)"; cmd.Parameters.Add("@tieude", SqlDbType.NVarChar, 50); cmd.Parameters["@tieude"].Value = txtTieuDe.Text; cmd.Parameters.Add("@noidung", SqlDbType.NText); cmd.Parameters["@noidung"].Value = CKEditorControl1.Text.ToString(); cmd.Parameters.Add("@dongia", SqlDbType.Money); cmd.Parameters["@dongia"].Value = txtDonGia.Text; cmd.Parameters.Add("@ngaydang", SqlDbType.SmallDateTime); cmd.Parameters["@ngaydang"].Value = DateTime.Today; cmd.Parameters.Add("@matv", SqlDbType.Int); cmd.Parameters["@matv"].Value = Session["MaTV"].ToString(); cmd.Parameters.Add("@tomtat", SqlDbType.NVarChar, 100); cmd.Parameters["@tomtat"].Value = txtTomTat.Text; cmd.Parameters.Add("@hinhminhhoa", SqlDbType.VarChar, 50); cmd.Parameters["@hinhminhhoa"].Value = file_upload.FileName.ToString(); cmd.ExecuteNonQuery(); con.Close(); file_upload.SaveAs(MapPath("~/Images/BaiDang/" + sTenfile)); lbThongBao.Text = "Đăng bài thành công"; cleartable(); } } catch { lbThongBao.Text = "Thất Bại!"; } } if (DropDownList1.SelectedItem.Value == "1") { try { string str1 = @"Select * from TinTuc Where TieuDe = '" + txtTieuDe.Text + "'"; if (XLDL.GetData(str1).Rows.Count > 0) { lbThongBao.Text = "Bài viết đã tồn tại"; txtTieuDe.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 TinTuc(TieuDe,TomTat,NoiDung,NgayDang,MaTV) VALUES(@tieude,@tomtat,@noidung,@ngaydang,@matv)"; cmd.Parameters.Add("@tieude", SqlDbType.NVarChar, 50); cmd.Parameters["@tieude"].Value = txtTieuDe.Text; cmd.Parameters.Add("@noidung", SqlDbType.NText); cmd.Parameters["@noidung"].Value = CKEditorControl1.Text.ToString(); cmd.Parameters.Add("@ngaydang", SqlDbType.SmallDateTime); cmd.Parameters["@ngaydang"].Value = DateTime.Today; cmd.Parameters.Add("@matv", SqlDbType.Int); cmd.Parameters["@matv"].Value = Session["MaTV"].ToString(); cmd.Parameters.Add("@tomtat", SqlDbType.NVarChar, 200); cmd.Parameters["@tomtat"].Value = txtTomTat.Text; cmd.ExecuteNonQuery(); con.Close(); lbThongBao.Text = "Đăng thành công. Xin chờ quản trị viên duyệt bài!"; cleartable(); } } catch { lbThongBao.Text = "Thất Bại!"; } } }