public List <AccountObject> GetAll() { List <AccountObject> lst = new List <AccountObject>(); var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_Account_GetAll(); foreach (var item in list) { if (item.Isdeleted == 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.Isdeleted; ob.RoleId = item.RoleId; lst.Add(ob); } return(lst); }