protected void btnADD_Click(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["TenTK"];
if (cookie != null)
{
GioHangDTO gh = new GioHangDTO();
gh.TenTaiKhoan = cookie.Value;
gh.MaSP = lblMaSP.Text;
gh.SizeGiay = DropDownList_size.SelectedItem.Text;
gh.SoLuong = Convert.ToInt32(txtSoluong.Text);
if (gh.SoLuong > Convert.ToInt32(lblSLTK.Text))
{
Response.Write("<script>alert('Thêm thất bại')</script>");
}
else if (GioHangBUS.ThemGH(gh))
{
Response.Redirect("GioHang.aspx");
}
else
{
Response.Write("<script>alert('Thêm thất bại')</script>");
}
}
else
{
Response.Redirect("DangNhap.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HienThiDanhMucSanPham();
cardArea.Visible = isVisible;
slideShow.Visible = isVisible;
imgAdv.Visible = isVisible;
//lblOnline.Text = Application["SoNguoiOnLine"].ToString();
anonymous.Visible = isLogIn;
authen.Visible = !isLogIn;
dem = 0;
GioHangDTO gioHang = new GioHangDTO();
gioHang.CartGuid = CartGUID;
GioHangBUS gioHangBUS = new GioHangBUS();
gioHangBUS._gioHang = gioHang;
gioHangBUS.Select();
GridView gridView = new GridView();
gridView.DataSource = gioHangBUS.KetQua;
gridView.DataBind();
foreach (GridViewRow row in gridView.Rows)
{
dem += int.Parse(row.Cells[3].Text);
}
productQuantity.Text = dem.ToString();
}
}
protected void rptSanPham_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "ThemGH")
{
HttpCookie cookie = Request.Cookies["TenTK"];
if (cookie != null)
{
GioHangDTO gh = new GioHangDTO();
gh.TenTaiKhoan = cookie.Value;
gh.MaSP = e.CommandArgument.ToString();
gh.SoLuong = 1;
if (GioHangBUS.ThemGH(gh))
{
Response.Redirect("GioHang.aspx");
}
else
{
Response.Write("<script>alert('Thêm thất bại')</script>");
}
}
else
{
Response.Redirect("DangNhap.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
((Home)this.Master).isVisible = false;
if (base._NguoiDungHienTai == null)
{
((Home)this.Master).isLogIn = true;
}
else
{
((Home)this.Master).isLogIn = false;
}
GioHangBUS gioHangBUS = new GioHangBUS();
GioHangDTO gioHang = new GioHangDTO();
gioHang.IdSanPham = int.Parse(Request.QueryString["IdSanPham"]);
gioHang.CartGuid = CartGUID;
gioHang.SoLuong = 1;
gioHangBUS._gioHang = gioHang;
try
{
gioHangBUS.Insert();
}
catch
{
Response.Redirect("Trangloi.aspx");
}
Response.Redirect("~/customer/cart");
}
public static Boolean Update(GioHangDTO gioHangDTO)
{
if (GioHangDAO.IsExist(gioHangDTO.TenTaiKhoan, gioHangDTO.MaSP))
{
return(GioHangDAO.Update(gioHangDTO));
}
return(false);
}
public static Boolean Insert(GioHangDTO gioHangDTO)
{
if (!GioHangDAO.IsExist(gioHangDTO.TenTaiKhoan, gioHangDTO.MaSP))
{
return(GioHangDAO.Insert(gioHangDTO));
}
return(false);
}
public static bool KTGHTonTai(GioHangDTO gh)
{
string query = "SELECT COUNT(*) FROM GioHang WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@TenTaiKhoan", gh.TenTaiKhoan);
param[1] = new SqlParameter("@MaSP", gh.MaSP);
return(Convert.ToInt32(DataProvider.ExecuteSelectQuery(query, param).Rows[0][0]) == 1);
}
private static GioHangDTO ConvertToDTO(DataRow dr)
{
GioHangDTO result = new GioHangDTO();
result.TenTaiKhoan = Convert.ToString(dr["TenTaiKhoan"]);
result.MaSP = Convert.ToString(dr["MaSP"]);
result.SoLuong = Convert.ToInt32(dr["SoLuong"]);
return(result);
}
public static GioHangDTO ConvertToDTO(DataRow dr)
{
GioHangDTO gh = new GioHangDTO();
gh.TenTaiKhoan = dr["TenTaiKhoan"].ToString();
gh.MaHoa = dr["MaHoa"].ToString();
gh.SoLuong = Convert.ToInt32(dr["SoLuong"]);
return(gh);
}
public static bool SuaGH(GioHangDTO gh)
{
string query = "UPDATE GioHang SET SoLuong = SoLuong + @SoLuong WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP";
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@TenTaiKhoan", gh.TenTaiKhoan);
param[1] = new SqlParameter("@MaSP", gh.MaSP);
param[2] = new SqlParameter("@SoLuong", gh.SoLuong);
return(DataProvider.ExecuteUpdateQuery(query, param) == 1);
}
public static bool XoaGH(GioHangDTO gh)
{
string query = "DELETE FROM GIOHANG WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP ";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@TenTaiKhoan", gh.TenTaiKhoan);
param[1] = new SqlParameter("@MaSP", gh.MaSP);
return(DataProvider.ExecuteDeleteQuery(query, param) == 1);
}
public static Boolean Update(GioHangDTO gioHangDTO)
{
String query = "UPDATE GioHang SET MaSP = @MaSP, SoLuong = @SoLuong WHERE TenTaiKhoan = @TenTaiKhoan";
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@TenTaiKhoan", gioHangDTO.TenTaiKhoan);
param[1] = new SqlParameter("@MaSP", gioHangDTO.MaSP);
param[2] = new SqlParameter("@SoLuong", gioHangDTO.SoLuong);
return(DataProvider.ExecuteUpdateQuery(query, param) == 1);
}
public static bool ThemGH(GioHangDTO gh)
{
string query = "INSERT INTO GioHang (TenTaiKhoan, MaSP, SoLuong) VALUES (@TenTaiKhoan, @MaSP, @SoLuong)";
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@TenTaiKhoan", gh.TenTaiKhoan);
param[1] = new SqlParameter("@MaSP", gh.MaSP);
param[2] = new SqlParameter("@SoLuong", gh.SoLuong);
return(DataProvider.ExecuteInsertQuery(query, param) == 1);
}
public static bool ThemGH(GioHangDTO gh)
{
if (GioHangDAO.KTGHTonTai(gh))
{
return(GioHangDAO.SuaGH(gh));
}
else
{
return(GioHangDAO.ThemGH(gh));
}
}
protected void gridgiohang_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gridgiohang.PageIndex = e.NewPageIndex;
GioHangDTO gioHang = new GioHangDTO();
gioHang.CartGuid = CartGUID;
GioHangBUS gioHangBUS = new GioHangBUS();
gioHangBUS._gioHang = gioHang;
gioHangBUS.Select(); gioHangBUS.Select();
gridgiohang.DataSource = gioHangBUS.KetQua;
gridgiohang.DataBind();
}
//--------------------Thủ tục Delete()------------------
private void Delete(int id)
{
GioHangBUS gioHangBUS = new GioHangBUS();
GioHangDTO gioHang = new GioHangDTO();
gioHang.IdGioHang = id;
gioHangBUS._gioHang = gioHang;
try
{
gioHangBUS.Delete();
}
catch
{
Response.Redirect("Trangloi.aspx");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List <GioHangDetailDTO> giohang = Session["giohang"] as List <GioHangDetailDTO>;
GioHangDTO gioDTO = new GioHangDTO(txtHoTen.Text, txtDiaChi.Text, txtSDT.Text, txtEmail.Text, txtGhiChu.Text);
gioBUS.InsertGioHang(gioDTO);
foreach (GioHangDetailDTO item in giohang)
{
gioDetailBUS.InsertGioHangDetail(item, DateTime.Now);
}
//giohang.Clear();
//Cart.DataSource = giohang;
//Cart.DataBind();
//txtSoSanPham.Text = giohang.Count.ToString();
Response.Write(" <script> alert('Đặt Hàng Thành Công'); </script>");
CrearText();
}
//------------Thủ tục Update------------------
private void Update(int id, int soluong)
{
GioHangBUS gioHangBUS = new GioHangBUS();
GioHangDTO gioHang = new GioHangDTO();
gioHang.SoLuong = soluong;
gioHang.IdGioHang = id;
gioHangBUS._gioHang = gioHang;
try
{
gioHangBUS.Update();
}
catch
{
Response.Redirect("Trangloi.aspx");
}
}
private void HienThiGioHang()
{
GioHangDTO gioHang = new GioHangDTO();
gioHang.CartGuid = TaoCartGuid.LayCartGUID();
GioHangBUS gioHangBUS = new GioHangBUS();
gioHangBUS._gioHang = gioHang;
try
{
gioHangBUS.Select();
gridgiohang.DataSource = gioHangBUS.KetQua;
gridgiohang.DataBind();
}
catch
{
Response.Redirect("Trangloi.aspx");
}
}
protected void btnThanhToan_Click(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["TenTK"];
if (cookie != null)
{
string tenTK = cookie.Value;
HoaDonDTO hd = new HoaDonDTO();
//GioHangDTO gh = new GioHangDTO();
hd.TenTaiKhoan = tenTK;
hd.NgayMua = DateTime.Now;
hd.DiaChiGiaoHang = "Tp.HCM";
hd.SDTGiaoHang = "0905939947";
hd.TongTien = GioHangBUS.TinhTongTienGH(tenTK);
hd.MaHD = HoaDonBUS.ThemHD(hd);
DataTable dtbKetQua = GioHangBUS.LayDSGioHang(tenTK);
foreach (DataRow dr in dtbKetQua.Rows)
{
CTHoaDonDTO cthd = new CTHoaDonDTO();
cthd.MaHD = hd.MaHD;
cthd.MaSP = dr["MaSP"].ToString();
cthd.SoLuong = Convert.ToInt32(dr["SoLuong"]);
cthd.DonGia = Convert.ToInt32(dr["GiaTien"]);
CTHoaDonBUS.ThemCTHD(cthd);
GioHangDTO gh = new GioHangDTO();
gh.TenTaiKhoan = tenTK;
gh.MaSP = dr["MaSP"].ToString();
gh.SoLuong = Convert.ToInt32(dr["SoLuong"]);
gh.SizeGiay = dr["sizenumber"].ToString();
GioHangBUS.XoaGH(gh);
SanPhamBUS.CapNhatSoLuongTonKho(gh.MaSP, gh.SizeGiay, gh.SoLuong);
}
Response.Redirect("GioHang.aspx");
}
}
private void HienThiGioHang()
{
dem = 0;
GioHangDTO gioHang = new GioHangDTO();
gioHang.CartGuid = CartGUID;
GioHangBUS gioHangBUS = new GioHangBUS();
gioHangBUS._gioHang = gioHang;
gioHangBUS.Select(); gioHangBUS.Select();
gridgiohang.DataSource = gioHangBUS.KetQua;
gridgiohang.DataBind();
foreach (GridViewRow row in gridgiohang.Rows)
{
TextBox quantity = (TextBox)row.FindControl("textQuantity");
dem += int.Parse(quantity.Text);
}
Label count = (Label)((Home)this.Master).FindControl("productQuantity");
count.Text = dem.ToString();
}
public void InsertGioHang(GioHangDTO aDTO)
{
string sql = "Insert into GioHang values(N'" + aDTO.TenKH + "',N'" + aDTO.DiaChi + "','" + aDTO.SDT + "','" + aDTO.Email + "',N'" + aDTO.GhiChu + "')";
aBUS.ExcuteNonQuery(sql);
}
public static bool XoaGH(GioHangDTO gh)
{
return(GioHangDAO.XoaGH(gh));
}
