public bool Remove(Link entity)
{
bool removed = false;
if (data.ContainsKey(entity.ID)) {
data.Remove(entity.ID);
removed = true;
}
return removed;
}
public void AddNewLink()
{
Link aLink = new Link(0) {
Enabled = false,
FromSiteID = 1,
ToSiteID = 2,
RXOverride = 0,
TXOverride = 0,
HardwareID = 1
};
linkRepository.Add(aLink);
Links = CollectionViewSource.GetDefaultView(linkRepository.GetAll());
NotifyPropertyChanged("Links");
}
public bool Add(Link entity)
{
bool added = false;
if (entity.ID == 0) {
entity.SetID(InsertLink(entity));
}
if (!data.ContainsKey(entity.ID)) {
data.Add(entity.ID, entity);
if (LinksChanged != null) {
LinksChanged(entity);
}
entity.Changed += new LinkChangedEvent(entity_Changed);
added = true;
}
return added;
}
private Link BuildLink(Panic.Repository.Linq.Link aLink)
{
Link link = new Link(aLink.LinkID) {
Enabled = (bool)aLink.Enabled,
FromSiteID = aLink.FromSiteID,
ToSiteID = aLink.ToSiteID,
HardwareID = aLink.HardwareID,
Notes = aLink.Notes,
RXOverride = (double)aLink.RXOverride,
TXOverride = (double)aLink.TXOverride
};
return link;
}
private bool UpdateLink(Link aLink)
{
string query = string.Format(@"UPDATE LINK
SET
FromSiteID = '{0}',
ToSiteID = {1},
HardwareID = {2},
TXOverride = {3},
RXOverride = {4},
Enabled = '{5}',
Notes = '{6}'
WHERE
LinkID = {7}",
aLink.FromSiteID,
aLink.ToSiteID,
aLink.HardwareID,
aLink.TXOverride,
aLink.TXOverride,
aLink.Enabled,
aLink.Notes,
aLink.ID);
SqlCeCommand command = new SqlCeCommand(query, connection);
connection.Open();
int result = command.ExecuteNonQuery();
connection.Close();
return result > 0;
}
private int InsertLink(Link aLink)
{
int lastID = 0;
string query = string.Format(@"INSERT INTO LINK
(FromSiteID, ToSiteID, HardwareID, TXOverride, RXOverride, Enabled, Notes)
VALUES
('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
aLink.FromSiteID,
aLink.ToSiteID,
aLink.HardwareID,
aLink.TXOverride,
aLink.RXOverride,
aLink.Enabled,
aLink.Notes);
SqlCeCommand command = new SqlCeCommand(query, connection);
connection.Open();
int result = command.ExecuteNonQuery();
if (result > 0) {
SqlCeCommand command1 = new SqlCeCommand("select @@identity ", connection);
lastID = Convert.ToInt32(command1.ExecuteScalar());
}
connection.Close();
return lastID;
}
private void entity_Changed(Link aLink)
{
// Update the site in the Database
if (UpdateLink(aLink)) {
if (LinksChanged != null) {
LinksChanged(aLink);
}
}
}
