/// <summary>
///
/// </summary>
/// <returns></returns>
public ResourceTypeCollection GetAllResourceTypes()
{
try
{
// create sql parameters
SqlParameter prmResourceTypeCode = new SqlParameter("@ResourceTypeCode", SqlDbType.VarChar, 50);
prmResourceTypeCode.Direction = ParameterDirection.Input;
prmResourceTypeCode.Value = DBNull.Value;
ResourceTypeCollection collection = new ResourceTypeCollection();
// Execute procedure
using (IDataReader dr = Database.ExecuteReader("UspGetResourceType", CommandType.StoredProcedure, prmResourceTypeCode))
{
while (dr.Read())
{
ResourceType resourceType = Populate(dr);
collection.Add(resourceType);
}
}
return(collection);
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadData()
{
//GlobalData.Init();
//GlobalData.model.Refresh(RefreshMode.StoreWins, GlobalData.model.Reservations);
IsLoading = true;
this.Categories.Clear();
this.Categories.AddRange(GlobalData.model.ReservationTypes.ToList());
DateTime datedebut = CurrentDate.AddDays(-14);
DateTime datefin = CurrentDate.AddDays(14);
//string datedebut = "05/08/2013";
var result = GlobalData.model.Reservations.Where(a => (a.DateArrive >= datedebut && a.DateArrive < datefin && a.EtatOperation != "TERMINER" && a.EtatOperation != "ANNULER")).ToList <Reservations>();
this.appointments = LoadAppointments(result);
ResourceTypes.Remove(resourceType);
resourceType.Resources.Clear();
resourceType.Resources.AddRange(this.GetResources());
resourceTypes.Add(resourceType);
//this.OnPropertyChanged("Appointments");
IsLoading = false;
}
