/// <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; }