public Gio LayThongTinSanPham(int ID) { DAL_KetNoi dao_sp = new DAL_KetNoi(); dao_sp.Open(); string qry = "select * from SanPham s, LoaiHang si where s.MaLoai = si.MaLoai and MaSP = " + ID; SqlCommand cmd = new SqlCommand(qry, dao_sp.cnn); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); Gio g = new Gio(); g.MaSP = int.Parse(reader["MaSP"].ToString()); g.TenSP = reader["TenSanPham"].ToString(); g.GiaMua = float.Parse(reader["GiaMua"].ToString()); g.GiaBan = float.Parse(reader["GiaBan"].ToString()); g.Masize = reader["Size"].ToString(); g.SoLuong = int.Parse(reader["SoLuong"].ToString()); g.ThongTin = reader["ThongTin"].ToString(); g.NgayNhap = DateTime.Parse(reader["NgayNhapHang"].ToString()); g.HinhAnh = reader["HinhAnh"].ToString(); return(g); }
public int LayMaKH(string username) { DAL_KetNoi dal = new DAL_KetNoi(); dal.Open(); string qry = "SELECT MaKH FROM KhachHang WHERE TenDangNhap = '" + username + "'"; SqlCommand cmd = new SqlCommand(qry, dal.cnn); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); int makh = int.Parse(reader.GetValue(0).ToString()); cmd.Dispose(); reader.Dispose(); dal.Close(); return(makh); } else { cmd.Dispose(); reader.Dispose(); dal.Close(); return(-1); } }
public void HienThiGioHang() { DataTable dt = new DataTable(); dt.Columns.Add("MaSP"); dt.Columns.Add("Ten"); dt.Columns.Add("SL"); int SoLuong = 0; double TongTien = 0; if (Session["GioHang"] != null) { ArrayList giohang = (ArrayList)Session["GioHang"]; DAL_KetNoi dalsp = new DAL_KetNoi(); foreach (Gio sp in giohang) { DataRow dr = dt.NewRow(); dr["MaSP"] = sp.MaSP; dr["Ten"] = sp.TenSP; dr["SL"] = sp.SoLuong; SoLuong += sp.SoLuong; TongTien += (sp.SoLuong * sp.GiaBan); dt.Rows.Add(dr); } Session["TongSL"] = SoLuong; Session["TongTien"] = TongTien; lblSL.Text = SoLuong.ToString(); lblTongTien.Text = TongTien.ToString(); } }
public KhachHang LayThongTinKhachHang(string uname) { DAL_KetNoi daoKH = new DAL_KetNoi(); daoKH.Open(); string qry = "select * from KhachHang where TenDangNhap = '" + uname + "'"; SqlCommand cmd = new SqlCommand(qry, daoKH.cnn); SqlDataReader reader = cmd.ExecuteReader(); KhachHang kh = new KhachHang(); if (reader.HasRows) { reader.Read(); kh.MAKH = reader.GetInt32(0); kh.TENDANGNHAP = uname; kh.HOTEN = reader.GetValue(3).ToString(); kh.GIOITINH = (bool)reader.GetValue(4); kh.DIACHI = reader.GetValue(5).ToString(); kh.EMAIL = reader.GetValue(6).ToString(); kh.SODIENTHOAI = reader.GetValue(7).ToString(); } reader.Dispose(); cmd.Dispose(); daoKH.Close(); return(kh); }
protected void bttDN_Click(object sender, EventArgs e) { DAL_KetNoi dn = new DAL_KetNoi(); string sql = "Select * From KhachHang Where TenDangNhap=@User and MatKhau=@Pass "; SqlCommand cmd = new SqlCommand(sql, dn.cnn); cmd.Parameters.AddWithValue("User", txtTendangnhap.Text); cmd.Parameters.AddWithValue("Pass", txtMatkhau.Text); dn.Open(); SqlDataReader rd = cmd.ExecuteReader(); if (rd.HasRows) { rd.Read(); Session["MaKH"] = rd["MaKH"].ToString(); Session["HoTen"] = rd["HoTen"].ToString(); //Session["MatKhau"] = rd["MatKhau"].ToString(); Session["TenDangNhap"] = rd["TenDangNhap"].ToString(); // lưu session cột name //Session["TrangThai"] = true; Response.Redirect("Default.aspx"); } else { lblThongbao.Visible = true; lblThongbao.Text = "Email or password incorrect!"; } dn.Close(); }
public static void DoiMatKhau(KhachHang kh) { string qry = "UPDATE KhachHang SET MatKhau='" + kh.Newpass + "'WHERE TenDangNhap='" + kh.TENDANGNHAP + "'"; DAL_KetNoi dal = new DAL_KetNoi(); dal.Open(); SqlCommand cmd = new SqlCommand(qry, dal.cnn); cmd.Dispose(); dal.Close(); }
public void ThemSP_GioHang() { if (Request.QueryString["action"] == "add" && Session["TenDangNhap"] == null) { Response.Write("<Script>alert(\"Vui lòng đăng nhập , để sử dụng chức năng này .\")</Script>"); return; } if (Request.QueryString["action"] == "add") { int id = int.Parse(Request.QueryString["id"]); Session["MaSP"] = id; if (Session["GioHang"] == null) { ArrayList giohang = new ArrayList(); // tạo mới món hàng DAL_KetNoi dao = new DAL_KetNoi(); Gio sp = dao.LayThongTinSanPham(id); // thêm vào slg 1 sp.SoLuong = 1; // thêm vào giỏ hàng giohang.Add(sp); // lưu trong session Session["GioHang"] = giohang; } else { ArrayList giohang = (ArrayList)Session["GioHang"]; bool flag = false; foreach (Gio sp in giohang) { if (sp.MaSP == id) { sp.SoLuong += 1; flag = true; break; } } if (flag == false) { // tạo mới món hàng DAL_KetNoi dao = new DAL_KetNoi(); Gio sp = dao.LayThongTinSanPham(id); // thêm vào slg 1 sp.SoLuong = 1; // thêm vào giỏ hàng giohang.Add(sp); } } Response.Redirect("~/Form/SanPham.aspx"); } }
public void ThemHD(HoaDon hd) { DAL_KetNoi dalHD = new DAL_KetNoi(); dalHD.Open(); string qry = "insert into HoaDon values(" + hd.MAHD + "," + hd.MAKH + ",'" + hd.NGAYLAPHD + "','" + hd.NGAYGIAOHANG + "','" + hd.DIACHIGIAOHANG + "','True')"; SqlCommand cmd = new SqlCommand(qry, dalHD.cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); dalHD.Close(); }
public void ThemCTHD(CTHD cthd) { DAL_KetNoi daoCTHD = new DAL_KetNoi(); daoCTHD.Open(); string qry = "insert into ChiTietHoaDon(MaHD,MaSP,Size,SoLuong,DonGia,TinhTrang) values(" + cthd.MAHD + "," + cthd.MASP + ",'" + cthd.MASIZE + "'," + cthd.SOLUONG + "," + cthd.DONGIA + ",'false')"; SqlCommand cmd = new SqlCommand(qry, daoCTHD.cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); daoCTHD.Close(); }
internal void GhiThongTinKhach(KhachHang kh) { DAL_KetNoi dao = new DAL_KetNoi(); dao.Open(); string qry = "insert into KhachHang values(" + kh.MAKH + ",'" + kh.TENDANGNHAP + "','" + kh.MATKHAU + "','" + kh.HOTEN + "','true','" + kh.DIACHI + "','" + kh.EMAIL + "','" + kh.SODIENTHOAI + "')"; SqlCommand cmd = new SqlCommand(qry, dao.cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); dao.Close(); }
public DataTable LoadSanPham(string TenSP) { DataTable ds = new DataTable(); DAL_KetNoi Size = new DAL_KetNoi(); Size.Open(); string qry = "SELECT * FROM SanPham WHERE TenSanPham =" + TenSP; SqlCommand cmd = new SqlCommand(qry, Size.cnn); SqlDataReader reader = cmd.ExecuteReader(); ds.Load(reader); Size.Close(); return(ds); }
public DataTable LoadSPTheoLoai(int MaLoai) { DataTable dt = new DataTable(); DAL_KetNoi sp = new DAL_KetNoi(); sp.Open(); string qry = "select * from SanPham a, LoaiHang b where a.MaLoai = b.MaLoai and a.MaLoai = " + MaLoai; SqlCommand cmd = new SqlCommand(qry, sp.cnn); SqlDataReader reader = cmd.ExecuteReader(); dt.Load(reader); sp.Close(); return(dt); }
protected void btnXacNhan_Click(object sender, EventArgs e) { if (Page.IsValid) { if (DateTime.Now.CompareTo(DateTime.Parse(txtNgayGiao.Text.Trim())) > 0) { lblNgayGiaoHang.Text = "Ngày giao hàng nhỏ hơn ngày hiện tại !"; return; } if (Session["TenDangNhap"] != null && Session["GioHang"] != null) { string uname = (string)Session["TenDangNhap"]; DAL_KetNoi dal = new DAL_KetNoi(); int MaKH = dal.LayMaKH(uname); string ngaylaphd = DateTime.Now.ToShortDateString(); string ngaygiaohang = txtNgayGiao.Text.Trim(); string dc = txtDCNhan.Text.Trim(); // them hoa don DAL_KetNoi dalhd = new DAL_KetNoi(); HoaDon hd = new HoaDon(); hd.MAHD = int.Parse(DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString()); hd.NGAYLAPHD = ngaylaphd; hd.NGAYGIAOHANG = ngaygiaohang; hd.MAKH = MaKH; hd.DIACHIGIAOHANG = dc; dalhd.ThemHD(hd); //them chi tiet hoa don DAL_KetNoi dalCTHD = new DAL_KetNoi(); ArrayList giohang = (ArrayList)Session["GioHang"]; ArrayList chitietHD = new ArrayList(); foreach (Gio sp in giohang) { CTHD cthd = new CTHD(); cthd.MAHD = hd.MAHD; cthd.MASP = sp.MaSP; cthd.MASIZE = sp.Masize; cthd.SOLUONG = sp.SoLuong; cthd.DONGIA = sp.GiaBan; dalCTHD.ThemCTHD(cthd); chitietHD.Add(cthd); } Session["ChiTietHoaDon"] = chitietHD; Session["GioHang"] = null; Response.Redirect("thanhcong.html"); } } }
protected void btnXacnhan_Click(object sender, EventArgs e) { if (Page.IsValid) { DAL_KetNoi dao = new DAL_KetNoi(); int flagEmail = dao.LaTrungEmail(txtEmail.Text.Trim()); int flagUsername = dao.LaTrungTenDangNhap(txtTendangnhap.Text.Trim()); if (flagUsername == 1 && flagEmail == 1) { lblUsername.Text = "Tên đăng nhập này đã có người sử dụng!"; lblEmail.Text = "Địa chỉ Email này đã có người sử dụng!"; lblThongBao.Text = "Đăng kí không thành công !"; } else if (flagEmail == 1) { lblEmail.Text = "Địa chỉ Email này đã có người sử dụng!"; lblThongBao.Text = "Đăng kí không thành công !"; } else if (flagUsername == 1) { lblUsername.Text = "Tên đăng nhập này đã có người sử dụng!"; lblThongBao.Text = "Đăng kí không thành công !"; } else { KhachHang kh = new KhachHang(); kh.MAKH = int.Parse(DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString()); kh.TENDANGNHAP = txtTendangnhap.Text; kh.MATKHAU = txtMatkhau.Text; kh.HOTEN = txtHoten.Text; if (rblGioitinh.SelectedItem.Text.Equals("Nam")) { kh.GIOITINH = true; } else { kh.GIOITINH = false; } kh.DIACHI = txtDiachi.Text; kh.EMAIL = txtEmail.Text; kh.SODIENTHOAI = txtDienthoai.Text; dao.GhiThongTinKhach(kh); lblThongBao.Text = kh.TENDANGNHAP + " ! Đăng kí thành công ."; Response.Redirect("~/Form/Default.aspx"); } } }
public void LoadGioHang() { DataTable dt = new DataTable(); dt.Columns.Add("MaSP"); dt.Columns.Add("TenSanPham"); dt.Columns.Add("Size"); dt.Columns.Add("SoLuong"); dt.Columns.Add("GiaBan"); if (Session["GioHang"] != null) { ArrayList giohang = (ArrayList)Session["GioHang"]; DAL_KetNoi dal = new DAL_KetNoi(); foreach (Gio sp in giohang) { DataRow dr = dt.NewRow(); dr["MaSP"] = sp.MaSP; dr["TenSanPham"] = sp.TenSP; switch (sp.Masize) { case "38": dr["Size"] = "38"; break; case "39": dr["Size"] = "39"; break; case "40": dr["Size"] = "40"; break; case "41": dr["Size"] = "41"; break; case "42": dr["Size"] = "42"; break; } dr["SoLuong"] = sp.SoLuong; dr["GiaBan"] = sp.GiaBan; dt.Rows.Add(dr); } gvDSSP.DataSource = dt.DefaultView; gvDSSP.DataBind(); } }
public int LaTrungTenDangNhap(string TenDangNhap) { DAL_KetNoi dao = new DAL_KetNoi(); dao.Open(); string qry = "SELECT * FROM KhachHang where TenDangNhap = '" + TenDangNhap + "'"; SqlCommand cmd = new SqlCommand(qry, dao.cnn); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { return(1); } return(0); }
public void LayThongTinSanPham() { if (Request.QueryString["action"] == "chitiet") { int id = int.Parse(Request.QueryString["id"].ToString()); Session["MaSP"] = id; DAL_KetNoi dao = new DAL_KetNoi(); SqlDataAdapter da = new SqlDataAdapter("select * from SanPham s, LoaiHang si where s.MaLoai = si.MaLoai and MaSP = " + id, dao.cnn); DataSet ds = new DataSet(); da.Fill(ds, "*"); Repeater1.DataSource = ds.Tables["*"]; Repeater1.DataBind(); ibtnmua.PostBackUrl = "ChiTietSanPham.aspx?action=add&id=" + id + "&url=chitiet"; } }
public void LoadThongTinKH() { if (Session["TenDangNhap"] != null) { string uname = (string)Session["TenDangNhap"]; DAL_KetNoi dal = new DAL_KetNoi(); KhachHang kh = dal.LayThongTinKhachHang(uname); txtTenKH.Text = kh.HOTEN; txtDiaChi.Text = kh.DIACHI; txtEmail.Text = kh.EMAIL; txtSoDT.Text = kh.SODIENTHOAI; } }
public int LaTrungEmail(string Email) { int flag = 0; DAL_KetNoi dao = new DAL_KetNoi(); dao.Open(); string qry = "SELECT * FROM KhachHang WHERE Email = '" + Email + "'"; SqlCommand cmd = new SqlCommand(qry, dao.cnn); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { flag = 1; } cmd.Dispose(); reader.Dispose(); dao.Close(); return(flag); }
public static int LayMaHoaDon() { DAL_KetNoi dao = new DAL_KetNoi(); dao.Open(); string qry = "select top 1 MaHD from HoaDon order by MaHD desc"; SqlCommand cmd = new SqlCommand(qry, dao.cnn); SqlDataReader reader = cmd.ExecuteReader(); HoaDon hd = new HoaDon(); if (reader.HasRows) { reader.Read(); hd.MAHD = reader.GetInt32(0); } reader.Dispose(); cmd.Dispose(); dao.Close(); return(hd.MAHD); }
protected void btnDMK_Click(object sender, EventArgs e) { try { KhachHang kh = new KhachHang(); kh.TENDANGNHAP = txtTK.Text; kh.MATKHAU = txtMKcu.Text; kh.Newpass = txtMKmoi.Text; Panel pnldadangnhap = (Panel)this.Master.FindControl("pnldadangnhap"); if (pnldadangnhap.Visible == true) { DAL_KetNoi.DoiMatKhau(kh); lblThongBao.Text = "Đổi thành công"; } else { lblThongBao.Text = "Đổi thất bại"; } } catch { } }
public void LoadSanPham() { if (Request.QueryString["url"] != null) { string ulr = Request.QueryString["url"]; Session["url"] = Request.UrlReferrer.ToString(); DAL_KetNoi dao = new DAL_KetNoi(); switch (ulr) { case "Adidas": dtlSanPham.DataSource = dao.LoadSPTheoLoai(1); dtlSanPham.DataBind(); Session["LoaiSP"] = "Adidas"; break; case "Nike": dtlSanPham.DataSource = dao.LoadSPTheoLoai(2); dtlSanPham.DataBind(); Session["LoaiSP"] = "Nike"; break; case "Jordan": dtlSanPham.DataSource = dao.LoadSPTheoLoai(3); dtlSanPham.DataBind(); Session["LoaiSP"] = "Jordan"; break; //case "tk": // string TenSP = Request.QueryString["value"]; // dtlSanPham.DataSource = dao.TimKiemSanPham(TenSP); // dtlSanPham.DataBind(); default: break; } } }
private void LoadGioHang() { DataTable dt = new DataTable(); dt.Columns.Add("MaSP"); dt.Columns.Add("TenSanPham"); dt.Columns.Add("HinhAnh"); dt.Columns.Add("Size"); dt.Columns.Add("SoLuong"); dt.Columns.Add("GiaBan"); if (Session["GioHang"] != null) { ArrayList giohang = (ArrayList)Session["GioHang"]; DAL_KetNoi bus_sp = new DAL_KetNoi(); Label lblTT = (Label)this.Master.FindControl("lblTongTien"); double TongTien = 0; foreach (Gio sp in giohang) { DataRow dr = dt.NewRow(); dr["MaSP"] = sp.MaSP; dr["TenSanPham"] = sp.TenSP; dr["HinhAnh"] = sp.HinhAnh; switch (sp.Masize) { case "38": dr["Size"] = "38"; break; case "39": dr["Size"] = "39"; break; case "40": dr["Size"] = "40"; break; case "41": dr["Size"] = "41"; break; case "42": dr["Size"] = "42"; break; } dr["SoLuong"] = sp.SoLuong; dr["GiaBan"] = sp.GiaBan; TongTien += (sp.SoLuong * sp.GiaBan); dt.Rows.Add(dr); } gvGioHang.DataSource = dt.DefaultView; gvGioHang.DataBind(); Session["TongTien"] = TongTien; lblTT.Text = TongTien.ToString(); if (Session["TongTien"] != null) { lblTongCong.Text = "Tổng Tiền: " + Session["TongTien"].ToString() + "VNĐ"; } } }