public AccountObject GetByUserId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_Account_GetByUserId(ID); foreach (var item in list) { AccountObject obj = new AccountObject(); obj.UserId = item.UserId; obj.FullName = item.FullName; obj.PassWord = item.PassWord; obj.Username = item.Username; obj.Email = item.Email; obj.Phone = item.Phone; obj.Description = item.Description; obj.Isdeleted = item.Isdeleted; obj.RoleId = item.RoleId; return(obj); } return(null); }