public bool DeleteReservering(ClubCloud_Reservering entity, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
return(DeleteReserveringById(entity.Id, settings));
}
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_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_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 async Task <Reservering> GetReserveringAsync(Guid verenigingId, Guid reserveringId)
{
Reservering reservering = new Reservering();
ClubCloud_Reservering ccreservering = await client.GetReserveringByReserveringIdAsync("0000000", verenigingId, reserveringId, true);
reservering = new Reservering
{
BaanId = ccreservering.BaanId,
Datum = ccreservering.Datum,
Duur = ccreservering.Duur,
Final = ccreservering.Final,
Id = ccreservering.Id,
BeginTijd = ccreservering.Tijd,
EindTijd = ccreservering.Tijd.Add(ccreservering.Duur),
Soort = (ClubCloud.Afhangen.UILogic.Models.ReserveringSoort)ccreservering.ReserveringSoort,
Beschrijving = ccreservering.Beschrijving,
Spelers = new ObservableCollection <Speler>(),
};
if (ccreservering.Gebruiker_Een != null)
{
reservering.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Een.Value
});
}
if (ccreservering.Gebruiker_Twee != null)
{
reservering.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Twee.Value
});
}
if (ccreservering.Gebruiker_Drie != null)
{
reservering.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Drie.Value
});
}
if (ccreservering.Gebruiker_Vier != null)
{
reservering.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Vier.Value
});
}
return(reservering);
}
public void UpdateReservering(ClubCloud_Reservering entity)
{
using (new SPMonitoredScope("Reserveringen UpdateReservering"))
{
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)
{
Client.SetReservering(entity, Settings);
this.OnDataSourceViewChanged(EventArgs.Empty);
}
}
}
}
public bool DeleteReservering(ClubCloud_Reservering entity)
{
using (new SPMonitoredScope("Reserveringen DeleteReservering"))
{
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.DeleteReservering(entity, Settings));
}
}
}
return(false);
}
public ClubCloud_Reservering GetReserveringById(System.Guid Id, bool refresh = false, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Reservering result = null;
using (new SPMonitoredScope("Reserveringen GetReserveringById"))
{
try
{
result = beheerModel.ClubCloud_Reserveringen.Find(Id);
if (result == null || refresh)
{
result = GetReserveringById(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_Reservering());
}
public ClubCloud_Reservering SetReservering(ClubCloud_Reservering entity, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
ClubCloud_Reservering tobeupdated = null;
using (new SPMonitoredScope("Reserveringen SetReservering"))
{
try
{
entity = SetReservering(settings.Id.ToString(), entity, settings);
if (entity != null)
{
beheerModel.ClubCloud_Reserveringen.AddOrUpdate(entity);
}
beheerModel.SaveChanges();
tobeupdated = beheerModel.ClubCloud_Reserveringen.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 DeleteReserveringById(System.Guid Id, ClubCloud_Setting settings = null)
{
if (settings != null)
{
ValidateSettings(ref settings);
}
bool succes = false;
ClubCloud_Reservering tobedeleted = null;
using (new SPMonitoredScope("Reserveringen DeleteReserveringById"))
{
try
{
tobedeleted = beheerModel.ClubCloud_Reserveringen.Find(Id);
if (tobedeleted != null)
{
beheerModel.ClubCloud_Reserveringen.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 ClubCloud_Reservering SelectReservering([QueryString] Guid?Id) //(string Id)
{
ClubCloud_Reservering entity = null;
using (new SPMonitoredScope("Reserveringen SelectReservering"))
{
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.GetReserveringById(Id.Value, false, Settings);
if (entity != null || entity.Id != Guid.Empty)
{
entity.ClubCloud_Baan = Client.GetBaanForReserveringById(Id.Value, false, Settings);
if (entity.Gebruiker_Een != null)
{
entity.ClubCloud_Gebruiker_Een = Client.GetGebruikerById(entity.Gebruiker_Een.Value, false, Settings);
}
if (entity.Gebruiker_Twee != null)
{
entity.ClubCloud_Gebruiker_Twee = Client.GetGebruikerById(entity.Gebruiker_Twee.Value, false, Settings);
}
if (entity.Gebruiker_Drie != null)
{
entity.ClubCloud_Gebruiker_Drie = Client.GetGebruikerById(entity.Gebruiker_Drie.Value, false, Settings);
}
if (entity.Gebruiker_Vier != null)
{
entity.ClubCloud_Gebruiker_Vier = Client.GetGebruikerById(entity.Gebruiker_Vier.Value, false, Settings);
}
}
}
}
}
}
return(entity);
}
public async Task <Reservering> SetReserveringAsync(Guid verenigingId, Reservering reservering)
{
try
{
ObservableCollection <Guid> spelers = new ObservableCollection <Guid>();
foreach (Speler speler in reservering.Spelers)
{
if (speler.Id != Guid.Empty)
{
spelers.Add(speler.Id);
}
}
ClubCloudAfhangen.ClubCloud_Reservering ccreservering = null;
if (reservering.Id != Guid.Empty)
{
ClubCloud_Reservering _newreservering = new ClubCloud_Reservering
{
BaanId = reservering.BaanId,
Beschrijving = string.Empty,
Datum = reservering.Datum,
Duur = reservering.Duur,
ReserveringSoort = (ClubCloud.Afhangen.UILogic.ClubCloudAfhangen.ReserveringSoort)reservering.Soort,
Final = true,
Id = reservering.Id,
Tijd = reservering.BeginTijd
};
if (reservering.Spelers[0] != null)
{
_newreservering.Gebruiker_Een = reservering.Spelers[0].Id;
}
if (reservering.Spelers[1] != null)
{
_newreservering.Gebruiker_Een = reservering.Spelers[1].Id;
}
if (reservering.Spelers[2] != null)
{
_newreservering.Gebruiker_Een = reservering.Spelers[2].Id;
}
if (reservering.Spelers[3] != null)
{
_newreservering.Gebruiker_Een = reservering.Spelers[3].Id;
}
ccreservering = await client.UpdateReserveringAsync(
"0000000",
verenigingId,
_newreservering,
true,
false);
}
if (reservering.Id == Guid.Empty)
{
ccreservering = await client.AddReserveringAsync("00000000", verenigingId, reservering.Baan.Id, spelers, reservering.Datum, reservering.BeginTijd, reservering.Duur, (ClubCloud.Afhangen.UILogic.ClubCloudAfhangen.ReserveringSoort) reservering.Soort, true, false, reservering.Soort.ToString());
//ccreservering = await client.SetReserveringAsync("00000000", verenigingId, reservering.Baan.Id, spelers, reservering.Datum, reservering.BeginTijd, reservering.Duur, (ClubCloud.Afhangen.UILogic.ClubCloudAfhangen.ReserveringSoort)reservering.Soort, true, false, reservering.Soort.ToString());
}
else
{
ccreservering = await client.UpdateReserveringAsync("00000000", verenigingId, ccreservering, true, false);
}
if (ccreservering != null)
{
Reservering _new = new Reservering
{
BaanId = ccreservering.BaanId,
Datum = ccreservering.Datum,
Duur = ccreservering.Duur,
Final = ccreservering.Final,
Id = ccreservering.Id,
BeginTijd = ccreservering.Tijd,
EindTijd = ccreservering.Tijd.Add(ccreservering.Duur),
Soort = (ClubCloud.Afhangen.UILogic.Models.ReserveringSoort)ccreservering.ReserveringSoort,
Beschrijving = ccreservering.Beschrijving,
Spelers = new ObservableCollection <Speler>(),
};
if (ccreservering.Gebruiker_Een != null)
{
_new.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Een.Value
});
}
if (ccreservering.Gebruiker_Twee != null)
{
_new.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Twee.Value
});
}
if (ccreservering.Gebruiker_Drie != null)
{
_new.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Drie.Value
});
}
if (ccreservering.Gebruiker_Vier != null)
{
_new.Spelers.Add(new Speler {
Id = ccreservering.Gebruiker_Vier.Value
});
}
return(_new);
}
}
catch (Exception ex)
{
string message = ex.Message;
}
return(null);
}
