protected void dl2_ItemCommand(object source, DataListCommandEventArgs e)
    {
        LinkButton lable         = (LinkButton)e.Item.FindControl("TenSPLabel");
        SanPhams   sanpham       = db.SanPhams.SingleOrDefault(p => p.TenSP == lable.Text);
        string     clickdangnhap = Request.QueryString["ClickDangNhap"];

        if (clickdangnhap == null)
        {
            Response.Redirect("~/TrangDangNhap.aspx?MaSanPham=" + sanpham.MaSanPham);
        }
        else
        {
            string   makh    = Request.QueryString["MaKhachHang"];
            GioHangs giohang = db.GioHangs.SingleOrDefault(p => p.MaKhachHang.ToString() == makh && p.MaSanPham == sanpham.MaSanPham);
            if (giohang != null)
            {
                giohang.SoLuong = giohang.SoLuong + 1;
                db.SubmitChanges();
            }
            else
            {
                giohang             = new GioHangs();
                giohang.SoLuong     = 1;
                giohang.MaSanPham   = Convert.ToInt32(sanpham.MaSanPham);
                giohang.MaKhachHang = Convert.ToInt32(makh);
                db.GioHangs.InsertOnSubmit(giohang);
                db.SubmitChanges();
            }
            Response.Redirect("~/GioHang.aspx?MaKhachHang=" + makh);
        }
    }
    protected void btnSua_Click(object sender, EventArgs e)
    {
        SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.TenSP == txtTenSP.Text);

        ChiTietNhap chitietnhap = db.ChiTietNhaps.SingleOrDefault(p => p.SoHoaDon.ToString() == txtSoHD.Text && p.MaSanPham == sanpham.MaSanPham);

        if (chitietnhap == null)
        {
            CustomValidator1.ErrorMessage = "Bạn hãy chọn một chi tiết nhập để sửa ";
            CustomValidator1.IsValid      = false;
        }
        else
        {
            updatesoluongsp("update", chitietnhap);
            chitietnhap.SoLuongNhap = Convert.ToInt32(txtSoLuong.Text);
            chitietnhap.GiaNhap     = Convert.ToDouble(txtGiaNhap.Text);
            db.SubmitChanges();

            LoadTatCaSP();
        }

        txtSoHD.Enabled           = true;
        txtThongSoKyThuat.Enabled = true;
        txtTenSP.Enabled          = true;
        txtNhaSanXuat.Enabled     = true;
        txtLoaiSP.Enabled         = true;
        FileUpload1.Enabled       = true;
        btnupload.Enabled         = true;
        txtNhaSanXuat.Enabled     = true;
        txtThongSoKyThuat.Enabled = true;
    }
    protected void dl1_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        DataListItem item = e.Item;


        Label lbGiaMoi = (Label)item.FindControl("GiaBanMoiLabel");

        Label lbGiaBan = (Label)item.FindControl("GiaBanLabel");

        lbGiaBan.Text = "Giá:  " + HienThiGia(Convert.ToDouble(lbGiaBan.Text));

        LinkButton linkbutton = (LinkButton)item.FindControl("lbtTenSP");
        SanPhams   sanpham    = db.SanPhams.SingleOrDefault(p => p.TenSP == linkbutton.Text);

        Label             tenkhuyenmai     = (Label)item.FindControl("TenKhuyenMai");
        SanPham_KhuyenMai sanphamkhuyenmai = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaSanPham == sanpham.MaSanPham);

        if (sanphamkhuyenmai != null)
        {
            KhuyenMai khuyenmai = db.KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == sanphamkhuyenmai.MaKhuyenMai);
            tenkhuyenmai.Text = khuyenmai.NoiDungKhuyenMai;
            if (khuyenmai.NoiDungKhuyenMai.ToString().Length > 30)
            {
                tenkhuyenmai.Text = khuyenmai.NoiDungKhuyenMai.Substring(0, 30) + "...";
            }
            lbGiaBan.Font.Strikeout = true;
            lbGiaMoi.ForeColor      = System.Drawing.Color.Red;
            lbGiaMoi.Text           = "Giá bán:  " + HienThiGia(Convert.ToDouble(TinhGiamGia(khuyenmai.GiaCanGiam, sanpham.GiaBan).ToString()));
        }
        else
        {
            lbGiaBan.Font.Size = 11;
            lbGiaBan.Font.Bold = true;
        }
    }
Exemple #4
0
        public ActionResult PartialDanhSachSanPham()
        {
            var lstKetQua = new List <SanPhams>();

            using (DauGiaEntities ctx = new DauGiaEntities())
            {
                var lstSanPham = ctx.SanPhams.where (x => x.DaDuyet == false).ToList();
                foreach (var item in lstSanPham)
                {
                    var danhmuc   = ctx.DanhMucs.SingleOrDefault(x => x.MaTheLoai == item.MaTheLoai.Value);
                    var nguoiDung = ctx.NguoiDungs.SingleOrDefault(x => x.MaNguoiDung = item.MaNguoiDung.Value);
                    var sanpham   = new SanPhams()
                    {
                        MaSanPham   = item.MaSanPham,
                        Gia         = item.Gia,
                        Hinhanh1    = item.HinhAnh1,
                        HinhAnh2    = item.HinhAnh2,
                        HinhAnh3    = item.HinhAnh3,
                        NgayBatDau  = item.NgayBatDau,
                        NgayKetThuc = item.NgayKetThuc,
                        TenSanPham  = item.TenSanPham,
                        LoaiSanPham = item.DanhMuc,
                        NguoiDung   = nguoiDung
                    };
                    lstKetQua.Add(sanpham);
                }
                lstKetQua.OrderBy(x => x.NgayBatDau).ToList();
                return(partialView("DanhSachSanPham", lstKetQua));
            }
        }
    protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
    {
        SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.MaSanPham.ToString() == GridView3.Rows[GridView3.SelectedIndex].Cells[0].Text.ToString());

        ChiTietNhap chitietnhap = db.ChiTietNhaps.SingleOrDefault(p => p.MaSanPham == sanpham.MaSanPham && p.SoHoaDon.ToString() == GridView3.Rows[GridView3.SelectedIndex].Cells[6].Text);

        txtSoHD.Enabled           = false;
        txtThongSoKyThuat.Enabled = false;
        txtTenSP.Enabled          = false;
        txtNhaSanXuat.Enabled     = false;
        txtLoaiSP.Enabled         = false;
        FileUpload1.Enabled       = false;
        btnupload.Enabled         = false;
        txtNhaSanXuat.Enabled     = false;
        txtThongSoKyThuat.Enabled = false;
        txtBaoHanh.Enabled        = false;

        if (sanpham.HinhAnh != null)
        {
            hinhanh.ImageUrl = sanpham.HinhAnh;
            hinhanh.DataBind();
        }

        txtNhaSanXuat.SelectedItem.Text = sanpham.NhaSanXuat;


        txtSoHD.SelectedItem.Text       = chitietnhap.SoHoaDon.ToString();
        txtNhaCungCap.SelectedItem.Text = chitietnhap.NhaCungCap.TenNhaCungCap;
        txtSoLuong.Text            = chitietnhap.SoLuongNhap.ToString();
        txtTenSP.SelectedItem.Text = sanpham.TenSP;
        txtGiaNhap.Text            = chitietnhap.GiaNhap.ToString();
        txtGhichu.Text             = chitietnhap.GhiChu;
    }
        public void ThemSanPham(SanPham sp, int sl, bool laCapNhat)
        {
            var SanPhamGioHang = new SanPhamGioHang()
            {
                MaSP          = sp.MaSP,
                TenSP         = sp.TenSP,
                MieuTa        = sp.MieuTa,
                GiaSP         = sp.GiaSP,
                AnhSP         = sp.AnhSP,
                XuatSu        = sp.XuatSu,
                ChatLieu      = sp.ChatLieu,
                GioiTinh      = sp.GioiTinh,
                MaLoaiSanPham = sp.MaLoaiSanPham,
                LoaiSanPham   = sp.LoaiSanPham.TenLoaiSanPham,
                SoLuong       = sl,
            };
            // kiểm tra tồn tại Product có trong giỏ hàng theo id chưa
            var existKey = SanPhams.ContainsKey(sp.MaSP);

            if (!laCapNhat && existKey)
            {
                var existingItem = SanPhams[sp.MaSP];
                SanPhamGioHang.SoLuong += existingItem.SoLuong;
            }

            if (existKey)
            {
                SanPhams[sp.MaSP] = SanPhamGioHang;
            }
            else
            {
                SanPhams.Add(sp.MaSP, SanPhamGioHang);
            }
        }
 public void Remove(int MaSP)
 {
     if (SanPhams.ContainsKey(MaSP))
     {
         SanPhams.Remove(MaSP);
     }
 }
Exemple #8
0
    protected void btnMua_Click(object sender, ImageClickEventArgs e)
    {
        string   masp    = Request.QueryString["MaSanPham"];
        SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.MaSanPham.ToString() == masp);

        Response.Redirect("~/TrangDangNhap.aspx?MaSanPham=" + sanpham.MaSanPham);
    }
Exemple #9
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string   masp    = Request.QueryString["MaSanPham"];
        SanPhams sanpham = db.SanPhams.SingleOrDefault(p => p.MaSanPham.ToString() == masp);

        lblTenSanPham.Text     = sanpham.TenSP;
        lblThongSoTongThe.Text = sanpham.ThongSoKyThuat;

        if (sanpham.SanPham_KhuyenMai.KhuyenMai.GiaCanGiam != null)
        {
            lblGiaBan.Font.Strikeout = true;
            lblGiaMoi.Text           = "Giá bán:  " + HienThiGia(Convert.ToDouble(TinhGiamGia(sanpham.SanPham_KhuyenMai.KhuyenMai.GiaCanGiam, sanpham.GiaBan).ToString()));
        }
        lblGiaBan.Text    = HienThiGia(sanpham.GiaBan);
        lblBaoHanh.Text   = sanpham.BaoHanh;
        lblKhuyenMai.Text = sanpham.SanPham_KhuyenMai.KhuyenMai.TenKhuyenMai;
        if (sanpham.SoLuong > 0)
        {
            lblKhoHang.Text = "Còn hàng";
        }
        Image6.ImageUrl = sanpham.HinhAnh;
        Image6.DataBind();

        var chitiet = from p in db.ChiTietThongSos where p.ThongSoKyThuat == sanpham.ThongSoKyThuat select p;

        if (chitiet != null)
        {
            DataList1.DataSource = chitiet;
            DataList1.DataBind();
        }
    }
    protected void dl1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        DataListItem item       = e.Item;
        LinkButton   linkbutton = (LinkButton)item.FindControl("TenSPLabel");
        SanPhams     sanpham    = db.SanPhams.SingleOrDefault(p => p.TenSP == linkbutton.Text);

        Response.Redirect("~/TrangDangNhap.aspx?MaSanPham=" + sanpham.MaSanPham);
    }
    void updatesoluongsp(string type, ChiTietNhap chitietnhap)
    {
        SanPhams sp = db.SanPhams.SingleOrDefault(p => p.MaSanPham == chitietnhap.MaSanPham);

        if (type == "insert")
        {
            sp.SoLuong = sp.SoLuong + Convert.ToInt16(txtSoLuong.Text);
            db.SubmitChanges();
        }
        if (type == "update")
        {
            sp.SoLuong = sp.SoLuong - chitietnhap.SoLuongNhap + Convert.ToInt32(txtSoLuong.Text);
            db.SubmitChanges();
        }
        if (type == "delete")
        {
            sp.SoLuong = sp.SoLuong - chitietnhap.SoLuongNhap;
            db.SubmitChanges();
        }
    }
    protected void btnNhap_Click(object sender, EventArgs e)
    {
        if (kiemtra() == true)
        {
            NhaCungCap nhacungcap = db.NhaCungCaps.SingleOrDefault(p => p.TenNhaCungCap == txtNhaCungCap.Text);
            SanPhams   Sanpham    = db.SanPhams.SingleOrDefault(p => p.TenSP == txtTenSP.Text);
            if (Sanpham != null)
            {
                ChiTietNhap chitietnhap = db.ChiTietNhaps.SingleOrDefault(p => p.MaSanPham == Sanpham.MaSanPham && p.SoHoaDon.ToString() == txtSoHD.Text);

                if (chitietnhap != null)
                {
                    chitietnhap.SoLuongNhap = chitietnhap.SoLuongNhap + Convert.ToInt16(txtSoLuong.Text);
                    chitietnhap.GiaNhap     = chitietnhap.GiaNhap + Convert.ToDouble(txtGiaNhap.Text);
                    db.SubmitChanges();
                    updatesoluongsp("insert", chitietnhap);
                }
                else
                {
                    ChiTietNhap Chitietnhap = new ChiTietNhap();
                    Chitietnhap.SoLuongNhap = Convert.ToInt16(txtSoLuong.Text);
                    Chitietnhap.SoHoaDon    = Convert.ToInt16(txtSoHD.Text);
                    Chitietnhap.GhiChu      = txtGhichu.Text;
                    Chitietnhap.GiaNhap     = Convert.ToDouble(txtGiaNhap.Text);


                    if (nhacungcap != null)
                    {
                        Chitietnhap.MaNhaCungCap = nhacungcap.MaNhaCungCap;
                    }
                    Chitietnhap.MaSanPham = Sanpham.MaSanPham;
                    Chitietnhap.NgayNhap  = DateTime.Now.ToShortDateString();
                    db.ChiTietNhaps.InsertOnSubmit(Chitietnhap);
                    db.SubmitChanges();
                    updatesoluongsp("insert", Chitietnhap);
                }
            }
            else
            {
                SanPhams sanpham = new SanPhams();
                sanpham.TenSP          = txtTenSP.Text;
                sanpham.ThongSoKyThuat = txtThongSoKyThuat.Text;
                sanpham.NhaSanXuat     = txtNhaSanXuat.Text;
                sanpham.LoaiSP         = txtLoaiSP.Text;
                sanpham.HinhAnh        = hinhanh.ImageUrl;
                sanpham.BaoHanh        = txtBaoHanh.Text;
                sanpham.SoLuong        = Convert.ToInt16(txtSoLuong.Text);

                db.SanPhams.InsertOnSubmit(sanpham);
                db.SubmitChanges();

                ChiTietNhap chitietnhap = new ChiTietNhap();
                chitietnhap.SoLuongNhap = Convert.ToInt16(txtSoLuong.Text);
                chitietnhap.SoHoaDon    = Convert.ToInt16(txtSoHD.Text);
                chitietnhap.GhiChu      = txtGhichu.Text;
                chitietnhap.GiaNhap     = Convert.ToDouble(txtGiaNhap.Text);


                if (nhacungcap != null)
                {
                    chitietnhap.MaNhaCungCap = nhacungcap.MaNhaCungCap;
                }
                chitietnhap.MaSanPham = sanpham.MaSanPham;
                chitietnhap.NgayNhap  = DateTime.Now.ToShortDateString();
                db.ChiTietNhaps.InsertOnSubmit(chitietnhap);
                db.SubmitChanges();
            }
        }
        LoadTatCaSP();
    }