Esempio n. 1
0
        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>());
        }
Esempio n. 2
0
        public bool DeleteRegio(ClubCloud_Regio entity, ClubCloud_Setting settings = null)
        {
            if (settings != null)
            {
                ValidateSettings(ref settings);
            }

            return(DeleteRegioById(entity.Id, settings));
        }
Esempio n. 3
0
        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());
        }
Esempio n. 4
0
        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);
        }
Esempio n. 5
0
        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);
        }
Esempio n. 6
0
        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());
        }
Esempio n. 7
0
        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);
        }
Esempio n. 8
0
        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);
        }