public List<BAIVIET> LayBaiVietMoiNhat(int SoLuong)
{
List<BAIVIET> list = new List<BAIVIET>();
using (LinQDataContext db = new LinQDataContext())
{
ISingleResult<BAIVIET_LayBaiVietMoiNhatResult> lp = db.BAIVIET_LayBaiVietMoiNhat();
int i = 0;
foreach(BAIVIET_LayBaiVietMoiNhatResult bv in lp)
{
if (i == SoLuong)
{
break;
}
//BAIVIET_LayBaiVietMoiNhatResult bv = temp[i];
BAIVIET var1 = new BAIVIET();
var1.MaBaiViet = bv.MaBaiViet;
var1.TieuDe = bv.TieuDe;
var1.NoiDung = bv.NoiDung;
var1.MaLoaiBaiViet = bv.MaLoaiBaiViet;
var1.NgayDang = bv.NgayDang;
var1.HinhAnh = bv.HinhAnh;
var1.TomTat = bv.TomTat;
if (bv.CapNhat!=null)
var1.CapNhat = (DateTime)bv.CapNhat;
list.Add(var1);
i++;
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
