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` } }
public static bool AddOrRemoveHouse2HouseRecord(ref House2HouseRecordData rec) { try { if (rec.ItemId < 0) return AddH2HRecord(ref rec); return UpdateH2HRecord(ref rec); } catch (H2HRecordAlreadyExistsException) { return UpdateH2HRecord(ref rec); } }
public static House2HouseRecordData GetHouse2HouseRecord(int itemId) { using (var db = new House2HouseRecordDataContext()) { try { var r = db.House2HouseRecordItems.Single(s => s.ItemId == itemId); return(House2HouseRecordData.Copy(r)); } catch { return(new House2HouseRecordData()); } } }
internal static House2HouseRecordDataItem Copy(House2HouseRecordData item) { return new House2HouseRecordDataItem() { Date = item.Date, Symbol = item.Symbol, HouseAptNumber = item.HouseAptNumber, NamePlacementRemarks = item.NamePlacementRemarks, StreetItemId = item.StreetItemId, TerritoryItemId = item.TerritoryItemId }; }
public static bool AddOrRemoveHouse2HouseRecord(ref House2HouseRecordData rec) { try { if (rec.ItemId < 0) { return(AddH2HRecord(ref rec)); } return(UpdateH2HRecord(ref rec)); } catch (H2HRecordAlreadyExistsException) { return(UpdateH2HRecord(ref rec)); } }
internal static House2HouseRecordDataItem Copy(House2HouseRecordData item) { return(new House2HouseRecordDataItem() { Date = item.Date, Symbol = item.Symbol, HouseAptNumber = item.HouseAptNumber, NamePlacementRemarks = item.NamePlacementRemarks, StreetItemId = item.StreetItemId, TerritoryItemId = item.TerritoryItemId }); }
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 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` } }