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