public FacilityOffering GetByPK(Guid facilityGuid, Guid offeringGuid)
{
if (Guid.Empty == facilityGuid || Guid.Empty == offeringGuid)
{ return new FacilityOffering(); }
try
{
FacilityOffering daFacilityOffering = new FacilityOffering();
using (PSS2012DataContext context = this.DataContext)
{
daFacilityOffering = (
from items in context.FacilityOfferings
where items.FacilityGuid == facilityGuid && items.OfferingGuid == offeringGuid
select items).SingleOrDefault();
}
if (null == daFacilityOffering)
{
throw new DataAccessException("FacilityOffering no longer exists.");
}
return daFacilityOffering;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
/// <summary>
/// Inserts facilityOffering business entity into the data store.
/// </summary>
/// <param name="entity">The facilityOffering business entity to insert.</param>
/// <returns>The facilityOffering identifier.</returns>
public FacilityOffering Insert(FacilityOffering entity)
{
//@@NEW - changed return type to entity type.
try
{
using (PSS2012DataContext context = DataContext)
{
context.FacilityOfferings.InsertOnSubmit(entity);
context.SubmitChanges();
}
//@@NEW - returning full entity.
return entity;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public void Update(FacilityOffering entity)
{
if (Guid.Empty == entity.FacilityGuid || Guid.Empty == entity.OfferingGuid)
throw new PrimaryKeyMissingException("FacilityOffering", entity, "update");
try
{
using (PSS2012DataContext context = DataContext)
{
// Get the entity to update.
FacilityOffering facilityOfferingToUpdate = GetByPK(entity.FacilityGuid, entity.OfferingGuid);
// Set the new values.
facilityOfferingToUpdate.IsChecked = entity.IsChecked;
context.FacilityOfferings.Attach(facilityOfferingToUpdate);
// Perform the update.
context.SubmitChanges();
}
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public static DA.FacilityOffering ToDataEntity(this BE.FacilityOffering beFacilityOffering)
{
DA.FacilityOffering facilityOfferingResult = new DA.FacilityOffering()
{
FacilityGuid = beFacilityOffering.FacilityGuid,
OfferingGuid = beFacilityOffering.OfferingGuid,
IsChecked = beFacilityOffering.IsChecked,
};
return facilityOfferingResult;
}
