public bool DeleteListingServiceLocation(long listingServiceLocationId)
{
bool retVal = false;
try
{
using (TransactionScope trans = new TransactionScope())
{
using (TMCContext tmcContext = new TMCContext())
{
ListingServiceLocation listingServiceLocationEntity = tmcContext.ListingServiceLocation.SingleOrDefault(lcid =>
lcid.ListingServiceLocationId == listingServiceLocationId);
if (listingServiceLocationEntity != null)
{
tmcContext.DeleteObject(listingServiceLocationEntity);
tmcContext.SaveChanges();
}
}
trans.Complete();
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException("Error while deleting listing ServiceLocation.", ex);
}
return retVal;
}
public string DeleteListingMedia(long listingMediaid)
{
string retVal = "";
try
{
using (TransactionScope trans = new TransactionScope())
{
using (TMCContext tmcContext = new TMCContext())
{
ListingMedia listingMediaEntity = tmcContext.ListingMedia.SingleOrDefault(lm =>
lm.ListingMediaId == listingMediaid); //todo check
File fileEntity = tmcContext.File.SingleOrDefault(f =>
f.FileId == listingMediaEntity.FileId);
if (listingMediaEntity != null)
{
tmcContext.DeleteObject(listingMediaEntity);
tmcContext.DeleteObject(fileEntity);
tmcContext.SaveChanges();
retVal = fileEntity.ServerFileName;//todo check for null
}
}
trans.Complete();
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException("Error while deleting listing media.", ex);
}
return retVal;
}
