public List <ThucDonModels> sp_danhmucloadthucdon() { List <ThucDonModels> list = new List <ThucDonModels>(); foreach (var i in db.DANHMUCTHUCDONs.ToList()) { ThucDonModels t = new ThucDonModels(i.MADM, i.TENDM); list.Add(t); } return(list); }
public List <ThucDonModels> sp_loadthucdon(int madm) { var query = from td in db.THUCDONs where td.MADM == madm select new { td.MATHUCDON, td.TENTHUCDON, td.DONGIA, td.GIAMGIA }; List <ThucDonModels> list = new List <ThucDonModels>(); foreach (var i in query) { ThucDonModels t = new ThucDonModels(i.MATHUCDON, i.TENTHUCDON, i.DONGIA, i.GIAMGIA); list.Add(t); } return(list); }