public FacilityLocationCriteria GetByPK(Guid facilityGuid, Guid cityStateZipGuid) { if (Guid.Empty == facilityGuid || Guid.Empty == cityStateZipGuid) { return new FacilityLocationCriteria(); } try { FacilityLocationCriteria daFacilityLocationCriteria = new FacilityLocationCriteria(); using (PSS2012DataContext context = this.DataContext) { daFacilityLocationCriteria = ( from items in context.FacilityLocationCriterias where items.FacilityGuid == facilityGuid && items.CityStateZipGuid == cityStateZipGuid select items).SingleOrDefault(); } if (null == daFacilityLocationCriteria) { throw new DataAccessException("FacilityLocationCriteria no longer exists."); } return daFacilityLocationCriteria; } catch (System.Data.SqlClient.SqlException ex) { throw this.HandleSqlException(ex); } catch (Exception ex) { throw ex; } }
public static DA.FacilityLocationCriteria ToDataEntity(this BE.FacilityLocationCriteria beFacilityLocationCriteria) { DA.FacilityLocationCriteria facilityLocationCriteriaResult = new DA.FacilityLocationCriteria() { FacilityGuid = beFacilityLocationCriteria.FacilityGuid, CityStateZipGuid = beFacilityLocationCriteria.CityStateZipGuid, }; return facilityLocationCriteriaResult; }
public void Update(FacilityLocationCriteria entity) { if (Guid.Empty == entity.FacilityGuid || Guid.Empty == entity.CityStateZipGuid) throw new PrimaryKeyMissingException("FacilityLocationCriteria", entity, "update"); try { using (PSS2012DataContext context = DataContext) { // Get the entity to update. FacilityLocationCriteria facilityLocationCriteriaToUpdate = GetByPK(entity.FacilityGuid, entity.CityStateZipGuid); // Set the new values. // Perform the update. context.SubmitChanges(); } } catch (System.Data.SqlClient.SqlException ex) { throw this.HandleSqlException(ex); } catch (Exception ex) { throw ex; } }
/// <summary> /// Inserts facilityLocationCriteria business entity into the data store. /// </summary> /// <param name="entity">The facilityLocationCriteria business entity to insert.</param> /// <returns>The facilityLocationCriteria identifier.</returns> public FacilityLocationCriteria Insert(FacilityLocationCriteria entity) { //@@NEW - changed return type to entity type. try { using (PSS2012DataContext context = DataContext) { //@@NEW - removed assignments for entity properties to themselves. context.FacilityLocationCriterias.InsertOnSubmit(entity); context.SubmitChanges(); } //@@NEW - returning full entity. return entity; } catch (System.Data.SqlClient.SqlException ex) { throw this.HandleSqlException(ex); } catch (Exception ex) { throw ex; } }