public Click GetByPK(Guid clickGuid) { if (Guid.Empty == clickGuid) { return new Click(); } try { Click daClick = new Click(); using (PSS2012DataContext context = this.DataContext) { daClick = ( from items in context.Clicks where items.ClickGuid == clickGuid select items).SingleOrDefault(); } if (null == daClick) { throw new DataAccessException("Click no longer exists."); } return daClick; } catch (System.Data.SqlClient.SqlException ex) { throw this.HandleSqlException(ex); } }
public List<Click> GetAllWithUndefined() { Click undefinedClick = new Click() { ClickGuid = Guid.Empty, FacilityGuid = Guid.Empty, ListingTypeGuid = Guid.Empty, TimeStamp = default(DateTime), }; List<Click> response = this.GetAll().ToList(); response.Add(undefinedClick); return response; }
public static DA.Click ToDataEntity(this BE.Click beClick) { DA.Click clickResult = new DA.Click() { ClickGuid = beClick.ClickGuid, FacilityGuid = beClick.FacilityGuid, ListingTypeGuid = beClick.ListingTypeGuid, TimeStamp = beClick.TimeStamp, }; return clickResult; }
public void Update(Click entity) { if (Guid.Empty == entity.ClickGuid) throw new PrimaryKeyMissingException("Click", entity, "update"); try { using (PSS2012DataContext context = DataContext) { // Get the entity to update. Click clickToUpdate = GetByPK(entity.ClickGuid); // Set the new values. clickToUpdate.FacilityGuid = entity.FacilityGuid; clickToUpdate.ListingTypeGuid = entity.ListingTypeGuid; clickToUpdate.TimeStamp = entity.TimeStamp; // Perform the update. context.SubmitChanges(); } } catch (System.Data.SqlClient.SqlException ex) { throw this.HandleSqlException(ex); } }
/// <summary> /// Inserts click business entity into the data store. /// </summary> /// <param name="entity">The click business entity to insert.</param> /// <returns>The click identifier.</returns> public Click Insert(Click entity) { //@@NEW - changed return type to entity type. try { using (PSS2012DataContext context = DataContext) { entity.ClickGuid = Guid.NewGuid(); context.Clicks.InsertOnSubmit(entity); context.SubmitChanges(); } //@@NEW - returning full entity. return entity; } catch (System.Data.SqlClient.SqlException ex) { throw this.HandleSqlException(ex); } }