// Busca o total de dívidas que os amigos tem para um determinado amigo public String GetTotalDebtsByFriendName(String friendNameIn) { try { Connection connection = Connection.Instance; connection.dateBase = new DebSystemDatabaseEntities(); FriendRepository friendRepository = new FriendRepository(); int friendIdIn = friendRepository.GetFriendIdByName(friendNameIn); var debObj = from debt in connection.dateBase.Debts where debt.FriendIdIn == friendIdIn select debt.Value; return(Convert.ToString(debObj.Sum())); } catch (DbEntityValidationException e) { throw e; } }
// Atualiza o amigo na tabela. public Boolean Update(Friend friend, int friendId) { try { Connection connection = Connection.Instance; connection.dateBase = new DebSystemDatabaseEntities(); FriendRepository friendRepository = new FriendRepository(); Friend updateFriend = friendRepository.GetFriendById(friendId); if (friend.Name != "") { updateFriend.Name = friend.Name.Trim(); } if (friend.Sex != "") { updateFriend.Sex = friend.Sex; } if (friend.Age > 0) { updateFriend.Age = Convert.ToInt32(friend.Age); } connection.dateBase.Friends.Attach(updateFriend); connection.dateBase.Entry(updateFriend).State = EntityState.Modified; connection.dateBase.SaveChanges(); return(true); } catch (DbEntityValidationException e) { return(false); throw e; } }