private static bool AddH2HRecord(ref House2HouseRecordData rec)
{
using (var db = new House2HouseRecordDataContext()) {
var r = House2HouseRecordData.Copy(rec);
var qry = from x in db.House2HouseRecordItems
//unique items
where x.HouseAptNumber.Equals(r.HouseAptNumber) &&
x.StreetItemId.Equals(r.StreetItemId) &&
x.TerritoryItemId.Equals(r.TerritoryItemId)
select x;
if (qry.Any())
throw new H2HRecordAlreadyExistsException();
db.House2HouseRecordItems.InsertOnSubmit(r);
db.SubmitChanges();
rec.ItemId = r.ItemId;
return rec.ItemId >= 0;
}
}
private static bool UpdateH2HRecord(ref House2HouseRecordData rec)
{
if (rec.ItemId < 0) return AddH2HRecord(ref rec);
try {
using (var db = new House2HouseRecordDataContext()) {
int itemId = rec.ItemId;
var rec2 = db.House2HouseRecordItems.Single(s => s.ItemId == itemId);
rec2.Date = rec.Date;
rec2.HouseAptNumber = rec.HouseAptNumber;
rec2.NamePlacementRemarks = rec.NamePlacementRemarks;
rec2.StreetItemId = rec.StreetItemId;
rec2.Symbol = rec.Symbol;
rec2.TerritoryItemId = rec.TerritoryItemId;
db.SubmitChanges();
return true;
}
} catch (InvalidOperationException) {
return AddH2HRecord(ref rec); //rv not found, lets create it`
}
}
