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); }