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;
}
}
internal static TerritoryCardItem Copy(TerritoryCardData card)
{
return(new TerritoryCardItem
{
ItemId = card.ItemId,
DateCreated = card.DateCreated,
ImageSrc = card.ImageSrc,
Notes = card.Notes,
TerritoryNumber = card.TerritoryNumber
});
}
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);
}
}
public static TerritoryCardData GetTerritoryCard(int itemId)
{
try {
using (var db = new TerritoryCardsDataContext()) {
var c = db.TerritoryCardItems.Single(x => x.ItemId == itemId);
if (c == null)
{
return(null);
}
return(TerritoryCardData.Copy(c));
}
}
catch (InvalidOperationException e) {
return(null);
}
}
public static TerritoryCardData[] GetTerritoryCards(SortOrder so)
{
try {
using (var db = new TerritoryCardsDataContext()) {
var qry = from x in db.TerritoryCardItems
orderby x.DateCreated
select x;
if (!qry.Any())
{
return(null);
}
return(qry.Select(c => TerritoryCardData.Copy(c)).ToArray());
}
}
catch {
return(null);
}
}
internal static TerritoryCardItem Copy(TerritoryCardData card)
{
return new TerritoryCardItem
{
ItemId = card.ItemId,
DateCreated = card.DateCreated,
ImageSrc = card.ImageSrc,
Notes = card.Notes,
TerritoryNumber = card.TerritoryNumber
};
}
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;
}
}
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;
}
}
public EditTerritoryCardViewModel()
{
TerritoryCard = new TerritoryCardData();
}