public ClubCloud_Functionaris SelectFunctionaris([QueryString] Guid?Id) //(string Id) { ClubCloud_Functionaris entity = null; using (new SPMonitoredScope("Functionarissen SelectFunctionaris")) { if (SPContext.Current.Web.CurrentUser != null) { int bondsnummer; ClubCloud_Setting Settings = null; if (int.TryParse(SPContext.Current.Web.CurrentUser.UserId.NameId, out bondsnummer)) { Settings = Client.GetSettingById(bondsnummer); } if (Settings != null && Settings.VerenigingId != null) { Settings.ClubCloud_Vereniging = Client.GetVerenigingById(Settings.VerenigingId.Value, false, Settings); if (Settings.ClubCloud_Vereniging != null) { if (Id == null) { Guid queryId = Guid.Empty; foreach (Parameter where in WhereParameters) { if (where.Name == "Id") { if (Guid.TryParse(where.DefaultValue, out queryId)) { break; } } } Id = queryId; } if (Id == Guid.Empty) { } entity = Client.GetFunctionarisById(Id.Value, false, Settings); if (entity != null || entity.Id != Guid.Empty) { entity.ClubCloud_Functie = Client.GetFunctieForFunctionarisById(Id.Value, false, Settings); entity.ClubCloud_Vereniging = Client.GetVerenigingForFunctionarisById(Id.Value, false, Settings); entity.ClubCloud_Gebruiker = Client.GetGebruikerForFunctionarisById(Id.Value, false, Settings); entity.ClubCloud_District = Client.GetDistrictForFunctionarisById(Id.Value, false, Settings); entity.ClubCloud_Bestuursorgaan = Client.GetBestuursorgaanForFunctionarisById(Id.Value, false, Settings); } } } } } return(entity); }
public bool DeleteFunctionaris(ClubCloud_Functionaris entity, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } return(DeleteFunctionarisById(entity.Id, settings)); }
public ClubCloud_District GetDistrictForFunctionarisById(System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } ClubCloud_Functionaris entity = null; ClubCloud_District result = null; using (new SPMonitoredScope("Functionarissen GetDistrictForFunctionarisById")) { try { entity = beheerModel.ClubCloud_Functionarissen.Find(Id); if (entity != null && entity.ClubCloud_District == null) { beheerModel.Entry(entity).Reference(e => e.ClubCloud_District).Load(); } if (entity != null) { result = entity.ClubCloud_District; } if (result == null || refresh) { result = GetDistrictForFunctionarisById(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_District()); }
public ClubCloud_Bestuursorgaan GetBestuursorgaanForFunctionaris(ClubCloud_Functionaris entity, bool refresh = false, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } ClubCloud_Bestuursorgaan result = null; using (new SPMonitoredScope("Functionarissen GetBestuursorgaanForFunctionaris")) { try { entity = beheerModel.ClubCloud_Functionarissen.Find(entity.Id); if (entity != null && entity.ClubCloud_Bestuursorgaan == null) { beheerModel.Entry(entity).Reference(e => e.ClubCloud_Bestuursorgaan).Load(); } if (entity != null) { result = entity.ClubCloud_Bestuursorgaan; } if (result == null || refresh && entity != null) { result = GetBestuursorgaanForFunctionaris(settings.Id.ToString(), entity, 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_Bestuursorgaan()); }
/// <summary> /// /// </summary> /// <param name="functie"></param> /// <param name="settings"></param> /// <returns></returns> private async Task <bool> CreateOrUpdateRoleFunctionaris(ClubCloud_Functionaris functionaris, ClubCloud_Setting settings = null) { try { if (settings == null) { return(false); } if (settings != null) { if (functionaris != null && functionaris.ClubCloud_Gebruiker == null) { beheerModel.Entry(functionaris).Reference(e => e.ClubCloud_Gebruiker).Load(); } if (functionaris.ClubCloud_Gebruiker == null) { functionaris.ClubCloud_Gebruiker = GetGebruikerById(functionaris.GebruikerId.Value, false, settings); } if (functionaris != null && functionaris.ClubCloud_Functie == null) { beheerModel.Entry(functionaris).Reference(e => e.ClubCloud_Functie).Load(); } if (functionaris.ClubCloud_Functie == null) { functionaris.ClubCloud_Functie = GetFunctieById(functionaris.FunctieId.Value, false, settings); } if (functionaris.Actief == ActiefSoort.Actief) { await ZimbraRoleProvider.AddUsersToRolesAsync(new string[] { functionaris.ClubCloud_Gebruiker.Bondsnummer }, new string[] { functionaris.ClubCloud_Functie.Naam }); } else { await ZimbraRoleProvider.RemoveUsersFromRolesAsync(new string[] { functionaris.ClubCloud_Gebruiker.Bondsnummer }, new string[] { functionaris.ClubCloud_Functie.Naam }); } } return(true); } catch (Exception) { return(false); } }
public bool SetGebruikerForFunctionarisById(ClubCloud_Gebruiker Gebruiker, System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } ClubCloud_Functionaris entity = null; bool succes = false; using (new SPMonitoredScope("Functionarissen SetGebruikerForFunctionarisById")) { try { entity = beheerModel.ClubCloud_Functionarissen.Find(Id); if (entity != null && entity.ClubCloud_Gebruiker == null) { beheerModel.Entry(entity).Reference(e => e.ClubCloud_Gebruiker).Load(); } if (entity != null) { entity.ClubCloud_Gebruiker = Gebruiker; } 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 DeleteFunctionaris(ClubCloud_Functionaris entity) { using (new SPMonitoredScope("Functionarissen DeleteFunctionaris")) { if (SPContext.Current.Web.CurrentUser != null) { int bondsnummer; ClubCloud_Setting Settings = null; if (int.TryParse(SPContext.Current.Web.CurrentUser.UserId.NameId, out bondsnummer)) { Settings = Client.GetSettingById(bondsnummer); } if (Settings != null && Settings.VerenigingId != null) { return(Client.DeleteFunctionaris(entity, Settings)); } } } return(false); }
public ClubCloud_Functionaris GetFunctionarisById(System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } ClubCloud_Functionaris result = null; using (new SPMonitoredScope("Functionarissen GetFunctionarisById")) { try { result = beheerModel.ClubCloud_Functionarissen.Find(Id); if (result == null || refresh) { result = GetFunctionarisById(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_Functionaris()); }
public ClubCloud_Functionaris SetFunctionaris(ClubCloud_Functionaris entity, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } ClubCloud_Functionaris tobeupdated = null; using (new SPMonitoredScope("Functionarissen SetFunctionaris")) { try { entity = SetFunctionaris(settings.Id.ToString(), entity, settings); if (entity != null) { beheerModel.ClubCloud_Functionarissen.AddOrUpdate(entity); } beheerModel.SaveChanges(); tobeupdated = beheerModel.ClubCloud_Functionarissen.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 void UpdateFunctionaris(ClubCloud_Functionaris entity) { using (new SPMonitoredScope("Functionarissen UpdateFunctionaris")) { if (SPContext.Current.Web.CurrentUser != null) { int bondsnummer; ClubCloud_Setting Settings = null; if (int.TryParse(SPContext.Current.Web.CurrentUser.UserId.NameId, out bondsnummer)) { Settings = Client.GetSettingById(bondsnummer); } if (Settings != null && Settings.VerenigingId != null) { entity.VerenigingId = Settings.VerenigingId.Value; Client.SetFunctionaris(entity, Settings); this.OnDataSourceViewChanged(EventArgs.Empty); } } } }
public bool DeleteFunctionarisById(System.Guid Id, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } bool succes = false; ClubCloud_Functionaris tobedeleted = null; using (new SPMonitoredScope("Functionarissen DeleteFunctionarisById")) { try { tobedeleted = beheerModel.ClubCloud_Functionarissen.Find(Id); if (tobedeleted != null) { beheerModel.ClubCloud_Functionarissen.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); }
public bool SetBestuursorgaanForFunctionaris(ClubCloud_Bestuursorgaan Bestuursorgaan, ClubCloud_Functionaris entity, bool refresh = false, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } bool succes = false; using (new SPMonitoredScope("Functionarissen SetBestuursorgaanForFunctionaris")) { try { entity = beheerModel.ClubCloud_Functionarissen.Find(entity.Id); if (entity != null && entity.ClubCloud_Bestuursorgaan == null) { beheerModel.Entry(entity).Reference(e => e.ClubCloud_Bestuursorgaan).Load(); } if (entity != null) { entity.ClubCloud_Bestuursorgaan = Bestuursorgaan; } 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); }