public void ClearLocateBuddies()
{
var locateBuddies = from LocateBuddyTableEntity lb in _dataContext.LocateBuddiesTable
select lb;
_dataContext.LocateBuddiesTable.DeleteAllOnSubmit(locateBuddies);
_dataContext.SubmitChanges();
}
public void AddProfile(ProfileTableEntity newProfile)
{
_dataContext.MyProfilesTable.InsertOnSubmit(newProfile);
_dataContext.SubmitChanges();
this.CurrentProfile = newProfile;
}
public void CreateDefaultUser()
{
UserTableEntity user = new UserTableEntity();
//user.IsDataSynced = true;
user.CurrentProfileId = "0";
_dataContext.UserTable.InsertOnSubmit(user);
_dataContext.SubmitChanges();
this.User = user;
}
public void AddBuddy(BuddyTableEntity newBuddy)
{
IsSuccess = true;
Message = string.Empty;
try
{
var buddyInLocalStore = (from BuddyTableEntity buddy in _dataContext.MyBuddiesTable
where (buddy.PhoneNumber != "" && buddy.PhoneNumber == newBuddy.PhoneNumber) ||
(buddy.Email != "" && buddy.Email == newBuddy.Email)
select buddy).FirstOrDefault();
if (buddyInLocalStore != null)
{
buddyInLocalStore.IsDeleted = false;
}
else
{
_dataContext.MyBuddiesTable.InsertOnSubmit(newBuddy);
}
_dataContext.SubmitChanges();
this.Buddies.Add(newBuddy);
}
catch (Exception ex)
{
IsSuccess = false;
Message = ex.Message;
}
}
private async void GetLocationAddressAsync(ObservableCollection <GeoTag> locationTag, string profileId)
{
try
{
string address = await Utility.GetCombOfBingAndGMapsAddress(locationTag[0].Lat, locationTag[0].Long);
if (this.LocateBuddies.Any(b => b.BuddyProfileId == profileId))
{
this.LocateBuddies.First(b => b.BuddyProfileId == profileId).LastLocation = "@ " + address + " - " + new DateTime(locationTag[0].TimeStamp).ToString("dd/MM/yyyy HH:mm:ss");
using (var dataContext = new SOSDataContext(SOSDataContext.DBConnectionString))
{
if (dataContext.LocateBuddiesTable.Count() > 0)
{
//TODO: Bug - if uses Single, then it is throwing error. This means there are multiple entries in LocateBuddies with Same buddyId
dataContext.LocateBuddiesTable.First(b => b.BuddyProfileId == profileId).LastLocation = "( was at " + address + " - " + new DateTime(locationTag[0].TimeStamp).ToString("dd/MM/yyyy HH:mm:ss") + ")";
dataContext.SubmitChanges();
}
}
}
}
catch
{
//absorb exception occurred while getting address
}
}
public void AddGroup(GroupTableEntity newGroup)
{
IsSuccess = true;
Message = string.Empty;
try
{
var groupInLocalStore = (from GroupTableEntity g in _dataContext.MyGroupsTable
where g.GroupId == newGroup.GroupId
select g).FirstOrDefault();
if (groupInLocalStore != null)
{
groupInLocalStore.IsDeleted = false;
}
else
{
_dataContext.MyGroupsTable.InsertOnSubmit(newGroup);
}
_dataContext.SubmitChanges();
this.Groups.Add(newGroup);
}
catch (Exception ex)
{
IsSuccess = false;
Message = ex.Message;
}
}