public string[] GetGebruikers(string prefixText, int count, string contextKey)
{
List <string> customers = new List <string>();
if (SPContext.Current != null && SPContext.Current.Web != null && SPContext.Current.Web.CurrentUser != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
List <ClubCloud_Gebruiker> gebruikers = client.GetGebruikersBySearch(prefixText, count, contextKey, new ClubCloud_Setting {
Id = int.Parse(SPContext.Current.Web.CurrentUser.UserId.NameId)
});
if (gebruikers != null && gebruikers.Count > 0)
{
foreach (ClubCloud_Gebruiker gebruiker in gebruikers)
{
customers.Add((new JavaScriptSerializer()).Serialize(new Pair(string.Format("{0} - {1}", gebruiker.Bondsnummer, gebruiker.Volledigenaam), gebruiker.Bondsnummer)));
}
return(customers.ToArray());
}
else
{
return(default(string[]));
}
//return customers.ToArray(); ;
}
else
{
return(default(string[]));
}
}
public string[] GetVerenigingen(string prefixText, int count, string contextKey)
{
List <string> results = new List <string>();
try
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
List <ClubCloud_Vereniging> verenigingen = client.GetVerenigingenBySearch(prefixText, count, contextKey);
if (verenigingen != null && verenigingen.Count > 0)
{
foreach (ClubCloud_Vereniging vereniging in verenigingen)
{
results.Add((new JavaScriptSerializer()).Serialize(new Pair(string.Format("{0} - {1}", vereniging.Nummer, vereniging.Naam), vereniging.Nummer)));
}
return(results.ToArray());
}
return(results.ToArray());;
}
catch { };
return(default(string[]));
}
/// <summary>
///
/// </summary>
/// <param name="bondsnummer"></param>
/// <param name="verenigingId"></param>
/// <param name="date"></param>
/// <param name="refresh"></param>
/// <returns></returns>
public List <ClubCloud_Baanschema> GetBaanSchemaByDate(string bondsnummer, Guid verenigingId, DateTime date, bool refresh = false)
{
List <ClubCloud_Baanschema> baanschema = new List <ClubCloud_Baanschema>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
baanschema = client.GetBaanSchemaByDate(bondsnummer, verenigingId, date, refresh);
}
return(baanschema);
}
public ClubCloud_Reservering AddReservering(string bondsnummer, Guid verenigingId, Guid baanId, Guid[] gebruikers, DateTime Datum, TimeSpan Tijd, TimeSpan Duur, ReserveringSoort Soort = ReserveringSoort.Afhangen, bool final = false, bool push = false, string Beschrijving = "")
{
ClubCloud_Reservering reservering = new ClubCloud_Reservering();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
reservering = client.AddReservering(bondsnummer, verenigingId, baanId, gebruikers, Datum, Tijd, Duur, Soort, final, push, Beschrijving);
}
return(reservering);
}
public ClubCloud_Vereniging GetVerenigingByNummer(string bondsnummer, string verenigingNummer, bool refresh = false)
{
ClubCloud_Vereniging vereniging = new ClubCloud_Vereniging();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
vereniging = client.GetVerenigingByNummer(bondsnummer, verenigingNummer, refresh);
}
return(vereniging);
}
public ClubCloud_Reservering UpdateReservering(string bondsnummer, Guid verenigingId, ClubCloud_Reservering reservering, bool final = false, bool push = false)
{
ClubCloud_Reservering Ureservering = new ClubCloud_Reservering();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
Ureservering = client.UpdateReservering(bondsnummer, verenigingId, reservering, final, push);
}
return(Ureservering);
}
public ClubCloud_Vereniging GetVerenigingByLocation(string bondsnummer, double Latitude, double Longitude, bool refresh = false)
{
ClubCloud_Vereniging vereniging = new ClubCloud_Vereniging();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
vereniging = client.GetVerenigingByLocation(bondsnummer, Latitude, Longitude, refresh);
}
return(vereniging);
}
public List <ApplicationProcessorArchitecture> GetApplicationProcessorArchitectures(int applicationVersionId, string version)
{
List <ApplicationProcessorArchitecture> architecture = new List <ApplicationProcessorArchitecture>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
architecture = client.GetApplicationProcessorArchitecture(applicationVersionId, version);
}
return(architecture);
}
//public System.Collections.Generic.List<ClubCloud_Baan> GetBanenByVerenigingId(string bondsnummer, Guid verenigingId, bool refresh = false)
//{
// List<ClubCloud_Baan> banen = new List<ClubCloud_Baan>();
// if (SPContext.Current != null && SPContext.Current.Web != null)
// {
// ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
// banen = client.GetBanenByVerenigingId(bondsnummer, verenigingId, refresh);
// }
// return banen;
//}
public List <ClubCloud_Baanblok> GetBaanblokkenByAccommodatieId(string bondsnummer, Guid verenigingId, Guid accommodatieId, bool refresh = false)
{
List <ClubCloud_Baanblok> baanblokken = new List <ClubCloud_Baanblok>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
baanblokken = client.GetBaanblokkenByAccommodatieId(bondsnummer, verenigingId, accommodatieId, refresh);
}
return(baanblokken);
}
public ApplicationVersion GetApplicationVersion(int applicationInfoId, string version)
{
ApplicationVersion _version = new ApplicationVersion();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
_version = client.GetApplicationVersion(applicationInfoId, version);
}
return(_version);
}
public System.Collections.Generic.List <ClubCloud_Gebruiker> GetGebruikersByReserveringId(string bondsnummer, Guid verenigingId, Guid reserveringId, bool refresh = false)
{
List <ClubCloud_Gebruiker> gebruikers = new List <ClubCloud_Gebruiker>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
gebruikers = client.GetGebruikersForReserveringById(bondsnummer, verenigingId, reserveringId, refresh);
}
return(gebruikers);
}
public System.Collections.Generic.List <ClubCloud_Reservering> GetReserveringenByVerenigingId(string bondsnummer, Guid verenigingId, bool refresh = false)
{
List <ClubCloud_Reservering> reserveringen = new List <ClubCloud_Reservering>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
reserveringen = client.GetReserveringenByVerenigingId(bondsnummer, verenigingId, refresh);
}
return(reserveringen);
}
public List <ApplicationInfo> GetApplicationInfos()
{
List <ApplicationInfo> infos = new List <ApplicationInfo>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
infos = client.GetApplicationInfos();
}
return(infos);
}
public ClubCloud_Gebruiker GetGebruikerByNummer(string bondsnummer, Guid verenigingId, string nummer, bool refresh = false)
{
ClubCloud_Gebruiker gebruiker = new ClubCloud_Gebruiker();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
gebruiker = client.GetGebruikerByNummer(bondsnummer, verenigingId, nummer, refresh);
}
return(gebruiker);
}
/// <summary>
/// No SPContext available...
/// </summary>
/// <param name="dependencyResolver"></param>
private static void SignalRScaleOutDatabase(ref IDependencyResolver dependencyResolver)
{
Guid siteId = SPContext.GetContext(HttpContext.Current).Site.ID;//.Current.Site.ID;
string key = "ClubCloudService_SignalR";
string value = string.Empty;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite currentSiteCollection = new SPSite(siteId))
{
using (SPWeb currentWeb = currentSiteCollection.OpenWeb())
{
currentWeb.AllowUnsafeUpdates = true;
if (!currentWeb.AllProperties.ContainsKey(key))
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
value = client.ScaleOutConnection(key);
currentWeb.Properties.Add(key, value);
currentWeb.Properties.Update();
}
else
{
value = currentWeb.AllProperties[key].ToString();
SqlConnectionStringBuilder builder = null;
using (SqlConnection connection = new SqlConnection(value))
{
builder = new SqlConnectionStringBuilder(connection.ConnectionString);
if (!builder.InitialCatalog.Equals(key, StringComparison.InvariantCultureIgnoreCase))
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
value = client.ScaleOutConnection(key);
currentWeb.AllProperties[key] = value;
currentWeb.Properties.Update();
}
}
}
currentWeb.AllowUnsafeUpdates = false;
}
}
});
if (string.IsNullOrWhiteSpace(value))
{
dependencyResolver.UseSqlServer(value);
}
}
public ClubCloud_Sponsor_Afbeelding GetSponsorImageById(string bondsnummer, Guid verenigingId, Guid afbeeldingId, bool refresh = false)
{
ClubCloud_Sponsor_Afbeelding afbeelding = new ClubCloud_Sponsor_Afbeelding();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
afbeelding = client.GetAfbeeldingById(afbeeldingId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(afbeelding);
}
public ClubCloud_Sponsor GetSponsorById(string bondsnummer, Guid verenigingId, Guid sponsorId, bool refresh = false)
{
ClubCloud_Sponsor sponsor = new ClubCloud_Sponsor();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
sponsor = client.GetSponsorById(sponsorId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(sponsor);
}
public List <ClubCloud_Sponsor> GetSponsorenByVerenigingId(string bondsnummer, Guid verenigingId, bool refresh = false)
{
List <ClubCloud_Sponsor> sponsoren = new List <ClubCloud_Sponsor>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
sponsoren = client.GetSponsorenForVerenigingById(verenigingId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(sponsoren);
}
public ClubCloud_Baantype GetBaantypeById(string bondsnummer, Guid verenigingId, Guid accommodatieId, Guid baantypeId, bool refresh = false)
{
ClubCloud_Baantype baantype = new ClubCloud_Baantype();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
baantype = client.GetBaantypeById(baantypeId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
}); //, accommodatieId, BaantypeId, refresh);
}
return(baantype);
}
//public ClubCloud_Foto GetFotoByNummer(string bondsnummer, Guid verenigingId, string nummer, bool refresh = false)
//{
// ClubCloud_Foto foto = null;
// if (SPContext.Current != null && SPContext.Current.Web != null)
// {
// ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
// foto = client.GetFotoByNummer(bondsnummer, verenigingId, nummer, refresh);
// }
// return foto;
//}
public ClubCloud_Foto GetFotoById(string bondsnummer, Guid verenigingId, Guid gebruikerId, bool refresh = false)
{
ClubCloud_Foto foto = null;
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
foto = client.GetFotoForGebruikerById(bondsnummer, gebruikerId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId, GebruikerId = gebruikerId
});
}
return(foto);
}
//public System.Collections.Generic.List<ClubCloud_Baanschema> GetBaanSchemaByAccommodatieId(string bondsnummer, Guid verenigingId, Guid accommodatieId, bool refresh = false)
//{
// List<ClubCloud_Baanschema> baanschema = new List<ClubCloud_Baanschema>();
// if (SPContext.Current != null && SPContext.Current.Web != null)
// {
// ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
// baanschema = client.GetBaanSchemaByAccommodatieId(bondsnummer, verenigingId, accommodatieId, refresh);
// }
// return baanschema;
//}
/// <summary>
///
/// </summary>
/// <param name="bondsnummer"></param>
/// <param name="verenigingId"></param>
/// <param name="refresh"></param>
/// <returns></returns>
public System.Collections.Generic.List <ClubCloud_Baanschema> GetBaanSchemaByVerenigingId(string bondsnummer, Guid verenigingId, bool refresh = false)
{
List <ClubCloud_Baanschema> baanschema = new List <ClubCloud_Baanschema>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
baanschema = client.GetBaanschemasForVerenigingById(verenigingId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(baanschema);
}
public ClubCloud_Baan GetBaanById(string bondsnummer, Guid verenigingId, Guid baanId, bool refresh = false)
{
ClubCloud_Baan baan = new ClubCloud_Baan();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
baan = client.GetBaanById(baanId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(baan);
}
public List <ClubCloud_Afhang> GetVerenigingAfhangSettings(string bondsnummer, Guid verenigingId, bool refresh = false)
{
List <ClubCloud_Afhang> afhang = new List <ClubCloud_Afhang>();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
afhang = client.GetAfhangenForVerenigingById(verenigingId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(afhang);
}
public ClubCloud_Gebruiker GetGebruikerById(string bondsnummer, Guid verenigingId, Guid gebruikerId, bool refresh = false)
{
ClubCloud_Gebruiker gebruiker = new ClubCloud_Gebruiker();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
gebruiker = client.GetGebruikerById(gebruikerId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(gebruiker);
}
public ClubCloud_Reservering GetReserveringByReserveringId(string bondsnummer, Guid verenigingId, Guid reserveringId, bool refresh = false)
{
ClubCloud_Reservering reservering = new ClubCloud_Reservering();
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
reservering = client.GetReserveringById(reserveringId, refresh, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(reservering);
}
public bool DeleteReservering(string bondsnummer, Guid verenigingId, Guid reserveringId, bool push = false)
{
bool deleted = false;
if (SPContext.Current != null && SPContext.Current.Web != null)
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
deleted = client.DeleteReserveringById(reserveringId, new ClubCloud_Setting {
Id = int.Parse(bondsnummer), VerenigingId = verenigingId
});
}
return(deleted);
}
public static void ConfigureSignalR(IDependencyResolver dependencyResolver, IHubPipeline hubPipeline)
{
// Uncomment the following line to enable scale-out using SQL Server
//SignalRScaleOutDatabase(ref dependencyResolver);
string connection = string.Empty;
try
{
ClubCloudServiceClient client = new ClubCloudServiceClient(SPServiceContext.Current);
connection = client.ScaleOutConnection("ClubCloudService_SignalR");
}
catch { }
finally
{
if (!string.IsNullOrWhiteSpace(connection))
{
dependencyResolver.UseSqlServer(connection);
}
}
// Any connection or hub wire up and configuration should go here
hubPipeline.AddModule(new ClubCloudPipelineModule());
}
