public List <AccountObject> GetJoin() { List <AccountObject> lst = new List <AccountObject>(); var db = new eTrainingScheduleEntities(); var list = db.WEB_QLGD01_sp_Account_GetJoin(); foreach (var item in list) { if (item.IsdeletedAccount == true || item.IsdeletedRole == true) { continue; } AccountObject ob = new AccountObject(); ob.UserId = item.UserId; ob.FullName = item.FullName; ob.PassWord = item.PassWord; ob.Username = item.Username; ob.Email = item.Email; ob.Phone = item.Phone; ob.Description = item.Description; ob.Isdeleted = item.IsdeletedAccount; ob.RoleId = item.RoleId; ob.RoleJoin = new RoleObject() { Isdeleted = item.IsdeletedRole, RName = item.RName, RoleId = item.RoleId }; lst.Add(ob); } return(lst); }