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; } }
void luucheck(KhuyenMai khuyenmai) { if (txtMaKhuyenMai.Text != "") { var masanphamkhuyenmai = from p in db.SanPham_KhuyenMais where p.MaKhuyenMai == khuyenmai.MaKhuyenMai select p.MaSanPham; if (masanphamkhuyenmai != null) { foreach (GridViewRow dr in GridView3.Rows) { CheckBox chk = (CheckBox)dr.FindControl("chkApDung"); if (chk.Checked == true) { //kiemtra xem sampham_khuyenmai do da ton tai chua SanPham_KhuyenMai spkm = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == khuyenmai.MaKhuyenMai && p.MaSanPham.ToString() == dr.Cells[1].Text); if (spkm == null) { //neu chua ton tai //kiem tra xem san pham nay da duoc ap dung khuyen mai nao chua SanPham_KhuyenMai spkmtruoc = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaSanPham.ToString() == dr.Cells[1].Text); //neu da dc khuyen mai thi xoa di if (spkmtruoc != null) { db.SanPham_KhuyenMais.DeleteOnSubmit(spkmtruoc); db.SubmitChanges(); } SanPham_KhuyenMai spkmmoi = new SanPham_KhuyenMai(); spkmmoi.MaKhuyenMai = khuyenmai.MaKhuyenMai; spkmmoi.MaSanPham = Convert.ToInt32(dr.Cells[1].Text); db.SanPham_KhuyenMais.InsertOnSubmit(spkmmoi); db.SubmitChanges(); } } else { //kiemtra xem sampham_khuyenmai do da ton tai chua SanPham_KhuyenMai spkm = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == khuyenmai.MaKhuyenMai && p.MaSanPham.ToString() == dr.Cells[1].Text); if (spkm != null) { //neu da ton tai thi xoa di db.SanPham_KhuyenMais.DeleteOnSubmit(spkm); db.SubmitChanges(); } } } } } else { foreach (GridViewRow dr in GridView3.Rows) { CheckBox chk = (CheckBox)dr.FindControl("chkApDung"); if (chk.Checked == true) { //kiemtra xem sampham_khuyenmai do da ton tai chua SanPham_KhuyenMai spkm = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == khuyenmai.MaKhuyenMai && p.MaSanPham.ToString() == dr.Cells[1].Text); if (spkm == null) { //neu chua ton tai //kiem tra xem san pham nay da duoc ap dung khuyen mai nao chua SanPham_KhuyenMai spkmtruoc = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaSanPham.ToString() == dr.Cells[1].Text); //neu da dc khuyen mai thi xoa di if (spkmtruoc != null) { db.SanPham_KhuyenMais.DeleteOnSubmit(spkmtruoc); db.SubmitChanges(); } SanPham_KhuyenMai spkmmoi = new SanPham_KhuyenMai(); spkmmoi.MaKhuyenMai = khuyenmai.MaKhuyenMai; spkmmoi.MaSanPham = Convert.ToInt32(dr.Cells[1].Text); db.SanPham_KhuyenMais.InsertOnSubmit(spkmmoi); db.SubmitChanges(); } } else { //kiemtra xem sampham_khuyenmai do da ton tai chua SanPham_KhuyenMai spkm = db.SanPham_KhuyenMais.SingleOrDefault(p => p.MaKhuyenMai == khuyenmai.MaKhuyenMai && p.MaSanPham.ToString() == dr.Cells[1].Text); if (spkm != null) { //neu da ton tai thi xoa di db.SanPham_KhuyenMais.DeleteOnSubmit(spkm); db.SubmitChanges(); } } } } }