//Tim kiem nang cao
public List<sanpham> SearchSanPhamNangCao(string mansx, float giatu, float giaden)
{
var list = new List<sanpham>();
using (db)
{
try
{
var sanpham = (from s in db.sanphams where s.Active == true select s).ToList();
if (mansx == "0" && giatu == 0 && giaden == 0)
{
sanpham = sanpham.ToList();
}
else if (mansx == "0" && giatu == 0 && giaden > 0)
{
sanpham = sanpham.Where(s => s.gia < giaden).ToList();
}
else if (mansx == "0" && giatu > 0 && giaden > 0)
{
sanpham = sanpham.Where(s => s.gia < giaden && s.gia > giatu).ToList();
}
else if (mansx == "0" && giatu > 0 && giaden == 0)
{
sanpham = sanpham.Where(s => s.gia > giatu).ToList();
}
else if (mansx != "0" && giatu == 0 && giaden == 0)
{
sanpham = sanpham.Where(s => s.mansx == mansx).ToList();
}
else if (mansx != "0" && giatu > 0 && giaden == 0)
{
sanpham = sanpham.Where(s => s.mansx == mansx && s.gia > giatu).ToList();
}
else if (mansx != "0" && giatu == 0 && giaden > 0)
{
sanpham = sanpham.Where(s => s.mansx == mansx && s.gia < giaden).ToList();
}
else if (mansx != "0" && giatu > 0 && giaden > 0)
{
sanpham = sanpham.Where(s => s.mansx == mansx && s.gia < giaden && s.gia > giatu).ToList();
}
else
{
sanpham = sanpham.ToList();
}
foreach (sanpham item in sanpham)
{
sanpham sp = new sanpham()
{
id = item.id,
masp = item.masp,
mansx = item.mansx,
tensp = item.tensp,
soluong = item.soluong,
gia = item.gia,
ngaynhap = item.ngaynhap,
hinh = item.hinh
};
list.Add(sp);
}
}
catch
{
return null;
}
}
return list;
}
public bool insertSanPham(string msp, string ml, string mnsx, string ten, int sl, float gia, DateTime ngay, string hinh)
{
try
{
sanpham sp = new sanpham();
sp.masp = msp;
sp.maloai = ml;
sp.mansx = mnsx;
sp.tensp = ten;
sp.soluong = sl;
sp.gia = gia;
sp.ngaynhap = ngay;
sp.hinh = hinh;
sp.Active = true;
db.sanphams.InsertOnSubmit(sp);
db.SubmitChanges();
return true;
}
catch
{
return false;
}
}
partial void Deletesanpham(sanpham instance);
partial void Updatesanpham(sanpham instance);
partial void Insertsanpham(sanpham instance);
private void detach_sanphams(sanpham entity)
{
this.SendPropertyChanging();
entity.nhasx = null;
}
private void attach_sanphams(sanpham entity)
{
this.SendPropertyChanging();
entity.nhasx = this;
}