protected void Button1_Click(object sender, EventArgs e) { if (Session["TenDN"] == null) { lbThongBao.Text = "Vui lòng đăng nhập trước khi bình luận!!!"; } else { string nd = HttpUtility.HtmlEncode(Request.Form["tbND"]); if (nd == "") { lbThongBao.Text = "Chưa nhập nội dung!!!"; } else { string tendn = Session["TenDN"].ToString(); string sql = "SELECT [MaTK], [TenDN] FROM [TaiKhoan] where TenDN=N'" + tendn + "'"; DataTable dt = XLDL.GetData(sql); string matk = dt.Rows[0]["MaTK"].ToString(); string mablog = Request.QueryString["MaSP"].ToString(); DateTime dateTime = DateTime.Now; string ngay = dateTime.ToString("dd/MM/yyyy HH:mm:ss"); string sql1 = "Insert into BinhLuanSP values (" + mablog + "," + matk + ",'" + ngay + "',N'" + nd + "')"; XLDL.Excute(sql1); Response.Redirect("~/ChiTietSanPham.aspx?MaSP=" + mablog); } } }
protected void btnLuu_Click(object sender, EventArgs e) { try { string MaBlog = Session["MaTK"].ToString(); string mkc = tbMK.Text; string mkm = tbMKM.Text; string str = @"Select Matkhau from taikhoan where matk=" + MaBlog; if (XLDL.GetData(str).Rows[0]["MatKhau"].ToString() == mkc) { string sql = "update TaiKhoan set matkhau='" + mkm + "' where MaTK=" + MaBlog; XLDL.Excute(sql); Response.Redirect("DoiMatKhau.Aspx"); } else { lbThongBao.Text = "Mật khẩu cũ không chính xác."; } } catch { Response.Redirect("Default.aspx"); } }
protected void btnLuu_Click(object sender, EventArgs e) { string mblog = Request.QueryString["MaBlog"].ToString(); DateTime datetime = DateTime.Now; string ngaycapnhat = datetime.ToString("MM/dd/yyyy"); string tieude = tbTieuDe.Text; string nd = tbND.Text; string ngdang = tbNguoiDang.Text; int slx = int.Parse(tbSoLanXem.Text); string savePath = MapPath("~/Anh/Blog/"); if (FileUpload1.HasFile) { savePath += FileUpload1.FileName; FileUpload1.SaveAs(savePath); lbThongBao.Text = "Upload ảnh thành công."; } else { lbThongBao.Text = "Ảnh chưa được upload."; } string ha = FileUpload1.FileName; string tbnd = tbTTND.Text; string sql = "update Blog set hinhanh=N'" + ha + "',Tieude=N'" + tieude + "',TTND=N'" + tbnd + "',NoiDung=N'" + nd + "',SoLanXem=" + slx + ",NgayDang='" + ngaycapnhat + "',NguoiDang=N'" + ngdang + "' where MaBlog=" + mblog; XLDL.Excute(sql); Response.Redirect("DanhSachBlog.Aspx"); }
protected void btnLuu_Click(object sender, EventArgs e) { try { string MaBlog = Request.QueryString["Ma"].ToString(); string tendn = tbDN.Text; string tentk = tbTenKH.Text; string dc = tbDiaChi.Text; string sdt = tbSDT.Text; string email = tbEmail.Text; string mk = tbMK.Text; string sql = "update TaiKhoan set tendn='" + tendn + "',tentk=N'" + tentk + "',DiaChi=N'" + dc + "',sdt='" + sdt + "',email='" + email + "',matkhau='" + mk + "' where MaTK=" + MaBlog; XLDL.Excute(sql); Response.Redirect("QuanTriTaiKhoan.Aspx"); } catch { Response.Redirect("QuanTriTaiKhoan.Aspx"); } }
protected void btnDN_Click(object sender, EventArgs e) { try { string ktr = @"select 1 from taikhoan where tendn=N'" + tbTK.Text + "'"; if (XLDL.GetData(ktr).Rows.Count > 0) { lbThongBao.Text = "Tên tài khoản đã tồn tại!!!"; tbTK.Focus(); } else { string tentk = tbTenTK.Text; string email = tbEmail.Text; string dc = tbDiaChi.Text; string sdt = tbSDT.Text; string tendn = tbTK.Text; string mk = tbMK.Text; string sql = "insert into Taikhoan values (N'" + tentk + "','" + email + "',N'" + dc + "','" + sdt + "','" + tendn + "','" + mk + "',2)"; XLDL.Excute(sql); Response.Redirect("DangNhap.aspx"); } } catch { lbThongBao.Text = "Thất bại"; } }
protected void Button1_Click(object sender, EventArgs e) { if (tbTenNgBL.Text == "" || tbNoiDung.Text == "") { lbThongBao.Text = "Bạn chưa nhập tên hoặc nội dung!!!"; } else { string mablog = Request.QueryString["MaBlog"].ToString(); string ten = tbTenNgBL.Text; string nd = tbNoiDung.Text; DateTime dateTime = DateTime.Now; string ngay = dateTime.ToString("dd/MM/yyyy HH:mm:ss"); string sql1 = "Insert into BinhLuanBLog values (" + mablog + ",N'" + ten + "','" + ngay + "',N'" + nd + "')"; XLDL.Excute(sql1); Response.Redirect("ChiTietTinTuc.aspx?MaBlog=" + mablog); } }
protected void btnLuu_Click(object sender, EventArgs e) { string MaBlog = Request.QueryString["MaDH"].ToString(); string ngay = DateTime.Now.ToString("MM/dd/yyyy"); string ten = tbTenKH.Text; string dc = tbDiaChi.Text; string sdt = tbSDT.Text; string pttt = tbPTTT.Text; int tt = int.Parse(tbThanhTien.Text); string sql = "update DonHang set NgayLapDH='" + ngay + "',TenKH=N'" + ten + "',DiaChi=N'" + dc + "',SDT='" + sdt + "',PTTT=N'" + pttt + "',ThanhTien=" + tt + " where MaDH=" + MaBlog; XLDL.Excute(sql); Response.Redirect("DonHang.Aspx"); }
protected void btnLuu_Click(object sender, EventArgs e) { try { string mblog = Request.QueryString["MaBlog"].ToString(); DateTime datetime = DateTime.Now; string ngaycapnhat = datetime.ToString("MM/dd/yyyy hh:mm:ss"); string tieude = tbTieuDe.Text; string nd = HttpUtility.HtmlEncode(Request.Form["tbND"]); string ngdang = tbNguoiDang.Text; int slx = int.Parse(tbSoLanXem.Text); string savePath = MapPath("~/Anh/Blog/"); if (FileUpload1.HasFile) { savePath += FileUpload1.FileName; FileUpload1.SaveAs(savePath); lbThongBao.Text = "Upload ảnh thành công."; } else { lbThongBao.Text = "Ảnh chưa được upload."; } string ha = FileUpload1.FileName; string tbnd = tbTTND.Text; string matk = Session["MaTK"].ToString(); string sql = "update Blog set hinhanh=N'" + ha + "',Tieude=N'" + tieude + "',TTND=N'" + tbnd + "',NoiDung=N'" + nd + "',SoLanXem=" + slx + ",NgayDang='" + ngaycapnhat + "',MaTK=" + matk + " where MaBlog=" + mblog; XLDL.Excute(sql); Response.Redirect("Quanlibaiviet.Aspx"); } catch { Response.Write("<script>alert('Sửa Thất Bại !!!');</script>"); } }
protected void btnCapNhat_Click(object sender, EventArgs e) { string malsp = rdlMaLoaiSP.SelectedValue.ToString(); string msp = Request.QueryString["Ma"].ToString(); DateTime datetime = DateTime.Now; string ngaycapnhat = datetime.ToShortDateString(); int slb = int.Parse(tbSoLuongBan.Text); int slx = int.Parse(tbSoLanXem.Text); string tensp = tbTenSP.Text; string ncc = tbNCC.Text; int sl = int.Parse(tbSoLuong.Text); string mt = tbMoTa.Text; int dg = int.Parse(tbDonGia.Text); string sql = "update SanPham set MaLoaiSP=" + malsp + ",TenSP=N'" + tensp + "',SoLuongSP=" + sl + ",NhaCC=N'" + ncc + "',TienSP=" + dg + ",NgayCapNhat='" + ngaycapnhat + "',SoLuongBan=" + slb + ",SoLanXem=" + slx + ",Mota=N'" + mt + "' where MaSP=" + msp; XLDL.Excute(sql); Response.Redirect("QuanTri.Aspx"); }
protected void gvBlog_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Xoa") { try { int chiso = int.Parse(e.CommandArgument.ToString()); string ma = gvBlog.Rows[chiso].Cells[0].Text; string str = "Delete from BLog where MaBlog=" + ma; XLDL.Excute(str); Response.Write("<script>alert('Xóa Thành Công!!!');</script>"); Response.Redirect("DanhSachBlog.aspx"); } catch { Response.Write("<script>alert('Xóa Thất Bại!!!');</script>"); } } }
protected void btnLuu_Click(object sender, EventArgs e) { string TenSP = tbTenSP.Text; string LoaiSP = rdLSP.SelectedValue.ToString(); int TienSP = int.Parse(tbDonGia.Text); string NCC = HttpUtility.HtmlEncode(tbNCC.Text); string mota = HttpUtility.HtmlEncode(Request.Form["tbND"]); DataTable dt1 = XLDL.GetData("Select TenLoaiSP from LOAISANPHAM where MaLoaiSP=" + LoaiSP); string tenthumuc = dt1.Rows[0]["TenLoaiSP"].ToString(); string savePath = MapPath("~/Anh/CayCanh/" + tenthumuc + "/"); if (FileUpload1.HasFile) { savePath += FileUpload1.FileName; FileUpload1.SaveAs(savePath); lbThongBao.Text = "Upload ảnh thành công."; } else { lbThongBao.Text = "Ảnh chưa được upload."; } string ha = FileUpload1.FileName; string HinhAnh = FileUpload1.FileName; DateTime datetime = DateTime.Now; string Ngay = datetime.ToString("MM/dd/yyyy"); int SL = int.Parse(tbSoLuong.Text); int SLX = 0; string str = "insert into SanPham values (" + LoaiSP + ",N'" + TenSP + "'," + SL + ",'" + HinhAnh + "',N'" + NCC + "'," + TienSP + ",'" + Ngay + "',1," + SLX + ",N'" + mota + "'" + ")"; XLDL.Excute(str); Response.Write("<script>alert('Them thanh cong !!!');</script>"); Response.Redirect("QuanTri.aspx"); }
protected void btnLuu_Click(object sender, EventArgs e) { try { string TieuDe = tbTieuDe.Text; string NoiDung = HttpUtility.HtmlEncode(Request.Form["tbND"]); string TTND = tbTTND.Text; string savePath = MapPath("~/Anh/Blog/"); if (FileUpload1.HasFile) { savePath += FileUpload1.FileName; FileUpload1.SaveAs(savePath); lbThongBao.Text = "Upload ảnh thành công."; } else { lbThongBao.Text = "Ảnh chưa được upload."; } string HinhAnh = FileUpload1.FileName; DateTime datetime = DateTime.Now; string Ngay = datetime.ToString("MM/dd/yyyy hh:mm:ss"); string str = "insert into Blog values (N'" + HinhAnh + "',N'" + TieuDe + "',N'" + TTND + "',N'" + NoiDung + "',0,'" + Ngay + "',1)"; XLDL.Excute(str); Response.Write("<script>alert('Them thanh cong !!!');</script>"); Response.Redirect("DanhSachBlog.aspx"); } catch { Response.Write("<script>alert('Them That Bai !!!');</script>"); } }
protected void btnCapNhat_Click(object sender, EventArgs e) { string malsp = rdlMaLoaiSP.SelectedValue.ToString(); string msp = Request.QueryString["Ma"].ToString(); DateTime datetime = DateTime.Now; string ngaycapnhat = datetime.ToShortDateString(); int slb = int.Parse(tbSoLuongBan.Text); int slx = int.Parse(tbSoLanXem.Text); string tensp = tbTenSP.Text; string ncc = tbNCC.Text; int sl = int.Parse(tbSoLuong.Text); string savePath = MapPath("~/Anh/CayCanh/"); if (FileUpload1.HasFile) { savePath += FileUpload1.FileName; FileUpload1.SaveAs(savePath); lbThongBao.Text = "Upload ảnh thành công."; } else { lbThongBao.Text = "Ảnh chưa được upload."; } string ha = FileUpload1.FileName; string mt = HttpUtility.HtmlEncode(Request.Form["tbND"]); int dg = int.Parse(tbDonGia.Text); string sql = "update SanPham set HinhAnh='" + ha + "',MaLoaiSP=" + malsp + ",TenSP=N'" + tensp + "',SoLuongSP=" + sl + ",NhaCC=N'" + ncc + "',TienSP=" + dg + ",NgayCapNhat='" + ngaycapnhat + "',SoLuongBan=" + slb + ",SoLanXem=" + slx + ",Mota=N'" + mt + "' where MaSP=" + msp; XLDL.Excute(sql); Response.Redirect("QuanTri.Aspx"); }
protected void btnLuu_Click(object sender, EventArgs e) { try { string MaBlog = Session["MaTK"].ToString(); string tentk = tbTenKH.Text; string dc = tbDiaChi.Text; string sdt = tbSDT.Text; string email = tbEmail.Text; string sql = "update TaiKhoan set 'tentk=N'" + tentk + "',DiaChi=N'" + dc + "',sdt='" + sdt + "',email='" + email + "' where MaTK=" + MaBlog; XLDL.Excute(sql); Response.Redirect("QuanLiThongTin.Aspx"); } catch { Response.Redirect("Default.aspx"); } }
protected void btnLuu_Click(object sender, EventArgs e) { try { string TieuDe = tbTieuDe.Text; string NoiDung = tbND.Text; string TTND = tbTTND.Text; string HinhAnh = FileUpload1.FileName; string NguoiDang = tbNguoiDang.Text; DateTime datetime = DateTime.Now; string Ngay = datetime.ToString("MM/dd/yyyy"); string str = "insert into Blog values (N'" + HinhAnh + "',N'" + TieuDe + "',N'" + TTND + "',N'" + NoiDung + "',0,'" + Ngay + "',N'" + NguoiDang + "')"; XLDL.Excute(str); Response.Write("<script>alert('Them thanh cong !!!');</script>"); Response.Redirect("DanhSachBlog.aspx"); } catch { Response.Write("<script>alert('Them That Bai !!!');</script>"); } }
protected void btDongY_Click(object sender, EventArgs e) { //int httt; ////int htgh; //string TenNguoiNhan, DiaChiNhan, DienThoaiNhan; //TenNguoiNhan = txtTenNguoiNhan.Text; //DiaChiNhan = txtDiaChiNhan.Text; //DienThoaiNhan = txtDienThoaiNhan.Text; //float tongThanhTien = float.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 (MaKH,TriGia,TenNguoiNhan,DiaChiNhan,DienThoaiNhan,HTThanhToan) Values(" + MaKH + ", @ngaydathang," + tongThanhTien + ",@ngaygiaohang,'" + TenNguoiNhan + "','" + DiaChiNhan + "','" + DienThoaiNhan + "','" + httt + ")"; ////cmd.Parameters.Add("@ngaydathang", SqlDbType.SmallDateTime); ////cmd.Parameters["@ngaydathang"].Value = DateTime.Today; ////cmd.Parameters.Add("@ngaygiaohang", SqlDbType.SmallDateTime); ////cmd.Parameters["@ngaygiaohang"].Value = DateTime.Today; //cmd.ExecuteNonQuery(); //con.Close(); //string s = "SELECT max(SoDH) from DONDATHANG Where MaKH=" + MaKH; //int SoDonHang = int.Parse(XLDL.GetData(s).Rows[0][0].ToString()); //DataTable dt = new DataTable(); //dt = (DataTable)Session["GioHang"]; //int MaSach, SoLuong; //float DonGia; //for(int i=0;i< dt.Rows.Count; i++) //{ // MaSach = int.Parse(dt.Rows[i]["MaSach"].ToString()); // SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); // DonGia = int.Parse(dt.Rows[i]["DonGia"].ToString()); // s = "INSERT INTO CTDATHANG(SoDH, MaSach, SoLuong, DonGia) VALUES (" + SoDonHang + "," + MaSach + "," + SoLuong + "," + DonGia + ")"; // XLDL.Excute(s); //} string ten = txtTenNguoiNhan.Text; string dc = txtDiaChiNhan.Text; string sdt = txtDienThoaiNhan.Text; string pttt = rblHinhThucThanhToan.SelectedValue.ToString(); string ngay = DateTime.Now.ToString("MM/dd/yyyy"); string matk = Session["MaTK"].ToString(); string sql = "insert into DonHang values(" + matk + ",'" + ngay + "',N'" + ten + "',N'" + dc + "','" + sdt + "',N'" + pttt + "'," + tt + ")"; XLDL.Excute(sql); string s = " SELECT Max(MaDH) from DonHang "; int SoDonHang = int.Parse(XLDL.GetData(s).Rows[0][0].ToString()); Response.Write(SoDonHang); DataTable dt = new DataTable(); dt = (DataTable)Session["GioHang"]; int MaSP, SoLuong; for (int i = 0; i < dt.Rows.Count; i++) { MaSP = int.Parse(dt.Rows[i]["MaSP"].ToString()); SoLuong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); s = "INSERT INTO ChiTietDonHang VALUES (" + SoDonHang + "," + MaSP + "," + SoLuong + ")"; XLDL.Excute(s); } Session["GioHang"] = null; Response.Redirect("~/XacNhanDonHang.aspx"); } catch { lbThongBaoLoi.Text = "Loi trong qua trinh cap nhat du lieu"; } }