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 static void CheckDatabase()
{
using (var db = new TerritoryCardsDataContext()) {
if (!db.DatabaseExists())
{
//db.DeleteDatabase();
db.CreateDatabase();
}
}
}
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);
}
}
