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Đ";
}
}
}
