// 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;
}
}
