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();
}
}
}
}
}
