public List <ClubCloud_Address> GetAddressenForRegioById(System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Regio entity = null;
List <ClubCloud_Address> result = null;
using (new SPMonitoredScope("Regios GetAddressenForRegioById"))
{
try
{
entity = beheerModel.ClubCloud_Regios.Find(Id);
if (entity != null && entity.ClubCloud_Address != null && entity.ClubCloud_Address.Count == 0)
{
beheerModel.Entry(entity).Collection(e => e.ClubCloud_Address).Load();
}
if (entity != null)
{
result = entity.ClubCloud_Address.ToList();
}
if (result == null || result.Count == 0 || refresh)
{
result = GetAddressenForRegioById(settings.Id.ToString(), Id, refresh, settings);
}
if (result != null)
{
return(result);
}
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (entity != null)
{
try { beheerModel.ObjectContext.Detach(entity); } catch {}
}
if (result != null)
{
foreach (object item in result)
{
if (item != null)
{
try { beheerModel.ObjectContext.Detach(item); } catch {}
}
}
}
}
}
return(new List <ClubCloud_Address>());
}
public bool DeleteRegio(ClubCloud_Regio entity, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
return(DeleteRegioById(entity.Id, settings));
}
public ClubCloud_Regio GetRegioForAddressById(System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Address entity = null;
ClubCloud_Regio result = null;
using (new SPMonitoredScope("Addressen GetRegioForAddressById"))
{
try
{
entity = beheerModel.ClubCloud_Addressen.Find(Id);
if (entity != null && entity.ClubCloud_Regio == null)
{
beheerModel.Entry(entity).Reference(e => e.ClubCloud_Regio).Load();
}
if (entity != null)
{
result = entity.ClubCloud_Regio;
}
if (result == null || refresh)
{
result = GetRegioForAddressById(settings.Id.ToString(), Id, refresh, settings);
}
if (result != null)
{
return(result);
}
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (entity != null)
{
try { beheerModel.ObjectContext.Detach(entity); } catch {}
}
if (result != null)
{
try { beheerModel.ObjectContext.Detach(result); } catch {}
}
}
}
return(new ClubCloud_Regio());
}
public bool SetRegioForAddressById(ClubCloud_Regio Regio, System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Address entity = null;
bool succes = false;
using (new SPMonitoredScope("Addressen SetRegioForAddressById"))
{
try
{
entity = beheerModel.ClubCloud_Addressen.Find(Id);
if (entity != null && entity.ClubCloud_Regio == null)
{
beheerModel.Entry(entity).Reference(e => e.ClubCloud_Regio).Load();
}
if (entity != null)
{
entity.ClubCloud_Regio = Regio;
}
beheerModel.SaveChanges();
succes = true;
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (entity != null)
{
try { beheerModel.ObjectContext.Detach(entity); } catch {}
}
}
}
return(succes);
}
public bool SetAddressenForRegio(List <ClubCloud_Address> Addressen, ClubCloud_Regio entity, bool refresh = false, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
bool succes = false;
ClubCloud_Regio result = null;
using (new SPMonitoredScope("Regios SetAddressenForRegio"))
{
try
{
entity = beheerModel.ClubCloud_Regios.Find(entity.Id);
if (entity != null)
{
beheerModel.Entry(entity).Collection(e => e.ClubCloud_Address).Load();
}
//result = GetRegioById(settings.Id.ToString(), Id, refresh, settings);
if (result != null)
{
//return result.ClubCloud_Regios.Count == ;
succes = false;
}
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (entity != null)
{
try { beheerModel.ObjectContext.Detach(entity); } catch {}
}
}
}
return(succes);
}
public ClubCloud_Regio GetRegioById(System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Regio result = null;
using (new SPMonitoredScope("Regios GetRegioById"))
{
try
{
result = beheerModel.ClubCloud_Regios.Find(Id);
if (result == null || refresh)
{
result = GetRegioById(settings.Id.ToString(), Id, refresh, settings);
}
if (result != null)
{
return(result);
}
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (result != null)
{
try { beheerModel.ObjectContext.Detach(result); } catch {}
}
}
}
return(new ClubCloud_Regio());
}
public ClubCloud_Regio SetRegio(ClubCloud_Regio entity, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Regio tobeupdated = null;
using (new SPMonitoredScope("Regios SetRegio"))
{
try
{
entity = SetRegio(settings.Id.ToString(), entity, settings);
if (entity != null)
{
beheerModel.ClubCloud_Regios.AddOrUpdate(entity);
}
beheerModel.SaveChanges();
tobeupdated = beheerModel.ClubCloud_Regios.Find(entity.Id);
return(tobeupdated);
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (tobeupdated != null)
{
try { beheerModel.ObjectContext.Detach(tobeupdated); } catch {}
}
}
}
return(null);
}
public bool DeleteRegioById(System.Guid Id, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
bool succes = false;
ClubCloud_Regio tobedeleted = null;
using (new SPMonitoredScope("Regios DeleteRegioById"))
{
try
{
tobedeleted = beheerModel.ClubCloud_Regios.Find(Id);
if (tobedeleted != null)
{
beheerModel.ClubCloud_Regios.Remove(tobedeleted);
beheerModel.SaveChanges();
}
succes = true;
}
catch (Exception ex)
{
Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message);
}
finally
{
if (tobedeleted != null)
{
try { beheerModel.ObjectContext.Detach(tobedeleted); } catch {}
}
}
}
return(succes);
}
