public void Update(Facility entity)
{
if (Guid.Empty == entity.FacilityGuid)
throw new PrimaryKeyMissingException("Facility", entity, "update");
try
{
using (PSS2012DataContext context = this.DataContext)
{
// Get the entity to update.
Facility facilityToUpdate = GetByPK(entity.FacilityGuid);
context.Facilities.Attach(facilityToUpdate);
// Set the new values.
//facilityToUpdate.FacilityID = entity.FacilityID;
facilityToUpdate.FacilityName = entity.FacilityName;
facilityToUpdate.Exerpt = entity.Exerpt;
facilityToUpdate.Description = entity.Description;
facilityToUpdate.Address = entity.Address;
facilityToUpdate.CityStateZipGuid = entity.CityStateZipGuid;
facilityToUpdate.PhoneNumber = entity.PhoneNumber;
facilityToUpdate.Email = entity.Email;
facilityToUpdate.Website = entity.Website;
facilityToUpdate.ClientGuid = entity.ClientGuid;
facilityToUpdate.ListingTypeGuid = entity.ListingTypeGuid;
facilityToUpdate.PublicPhotoFileUri = entity.PublicPhotoFileUri;
facilityToUpdate.Latitude = entity.Latitude;
facilityToUpdate.Longitude = entity.Longitude;
facilityToUpdate.Price = entity.Price;
// Perform the update.
context.SubmitChanges();
}
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
/// <summary>
/// Inserts facility business entity into the data store.
/// </summary>
/// <param name="entity">The facility business entity to insert.</param>
/// <returns>The facility identifier.</returns>
public Facility Insert(Facility entity)
{
//@@NEW - changed return type to entity type.
try
{
using (PSS2012DataContext context = this.DataContext)
{
entity.FacilityGuid = Guid.NewGuid();
context.Facilities.InsertOnSubmit(entity);
context.SubmitChanges();
}
//@@NEW - returning full entity.
return entity;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public List<Facility> GetAllWithUndefined()
{
Facility undefinedFacility = new Facility()
{
FacilityGuid = Guid.Empty,
FacilityID = 0,
FacilityName = "Undefined",
Exerpt = null,
Description = null,
Address = null,
CityStateZipGuid = Guid.Empty,
PhoneNumber = null,
Email = null,
Website = null,
ClientGuid = Guid.Empty,
ListingTypeGuid = Guid.Empty,
PublicPhotoFileUri = null,
};
List<Facility> response = this.GetAll().ToList();
response.Add(undefinedFacility);
return response;
}
public Facility GetByPK(Guid facilityGuid)
{
if (Guid.Empty == facilityGuid)
{ return new Facility(); }
try
{
Facility daFacility = new Facility();
using (PSS2012DataContext context = this.DataContext)
{
daFacility = (
from items in context.Facilities
where items.FacilityGuid == facilityGuid
select items).SingleOrDefault();
}
if (null == daFacility)
{
throw new DataAccessException("Facility no longer exists.");
}
return daFacility;
}
catch (System.Data.SqlClient.SqlException ex)
{
throw this.HandleSqlException(ex);
}
}
public static DA.Facility ToDataEntity(this BE.Facility beFacility)
{
DA.Facility facilityResult = new DA.Facility()
{
FacilityGuid = beFacility.FacilityGuid,
FacilityID = beFacility.FacilityID,
FacilityName = beFacility.FacilityName,
Exerpt = beFacility.Exerpt,
Description = beFacility.Description,
Address = beFacility.Address,
CityStateZipGuid = beFacility.CityStateZipGuid,
PhoneNumber = beFacility.PhoneNumber,
Email = beFacility.Email,
Website = beFacility.Website,
ClientGuid = beFacility.ClientGuid,
ListingTypeGuid = beFacility.ListingTypeGuid,
PublicPhotoFileUri = beFacility.PublicPhotoFileUri,
Latitude = beFacility.Latitude,
Longitude = beFacility.Longitude,
Price=beFacility.Price
};
return facilityResult;
}
