public static bool AddOrUpdateTerritoryCard(ref TerritoryCardData card)
        {
            if (card.ItemId <= 0)
            {
                return(AddTerritoryCard(ref card));
            }
            try {
                using (var db = new TerritoryCardsDataContext()) {
                    var i = card.ItemId;
                    var c = db.TerritoryCardItems.Single(x => x.ItemId == i);
                    if (c == null)
                    {
                        return(AddTerritoryCard(ref card));
                    }

                    c.ImageSrc        = card.ImageSrc;
                    c.Notes           = card.Notes;
                    c.TerritoryNumber = card.TerritoryNumber;
                    c.DateCreated     = card.DateCreated;

                    db.SubmitChanges();
                    return(true);
                }
            }
            catch (InvalidOperationException) {
                return(AddTerritoryCard(ref card));
            }
            catch (Exception e) {
                throw e;
            }
        }
 private static bool AddTerritoryCard(ref TerritoryCardData card)
 {
     try {
         using (var db = new TerritoryCardsDataContext()) {
             var newCard = TerritoryCardData.Copy(card);
             db.TerritoryCardItems.InsertOnSubmit(newCard);
             db.SubmitChanges();
             card.ItemId = newCard.ItemId;
             return(card.ItemId > 0);
         }
     }
     catch {
         return(false);
     }
 }