public AvailabilityCollection FetchAll() { AvailabilityCollection coll = new AvailabilityCollection(); Query qry = new Query(Availability.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public static List <Availability> GetAvailabilityRecords(int Month, int Year) { AvailabilityCollection availabilityRecords = new AvailabilityCollection(); availabilityRecords.Where(Availability.Columns.Month, Month).Where(Availability.Columns.Year, Year).Load(); return(availabilityRecords.GetList()); }
/// <summary> /// Constructor /// </summary> public WorkerFrm() { InitializeComponent(); try { this._keyServiceUsers = new ServiceUserCollection(); this._keyServiceUsers.ObjectAdded += new Cura.Common.Collection <ServiceUser> .CollectionChangeEvent(this.KeyServiceUsersChanged); this._keyServiceUsers.ObjectRemoved += new Cura.Common.Collection <ServiceUser> .CollectionChangeEvent(this.KeyServiceUsersChanged); this._availabilities = new AvailabilityCollection(); this._availabilities.ObjectAdded += new Cura.Common.Collection <Availability> .CollectionChangeEvent(this.AvailabilitiesChanged); this._availabilities.ObjectRemoved += new Cura.Common.Collection <Availability> .CollectionChangeEvent(this.AvailabilitiesChanged); this._longLat = new LongLat(); this.tabControl1.SelectedIndex = 0; int weeks = Settings.Instance.rotaweekcount; for (int i = 0; i < weeks; i++) { treeView1.Nodes.Add("Week " + (i + 1).ToString()); } treeView1.MouseDown += (sender, args) => treeView1.SelectedNode = treeView1.GetNodeAt(args.X, args.Y); //show core hours first splitContainer5.Panel1Collapsed = false; splitContainer5.Panel2Collapsed = true; ((OLVColumn)callHistoryObjectListView.Columns[0]).GroupKeyGetter = delegate(object rowObject) { Call_Slim model = rowObject as Call_Slim; return(model.Day); }; numberLbl.Text = String.Format("{0} Number", Settings.Instance.WorkerNumberAlias).Trim(); splitContainer8.SplitterDistance = pictureBox12.Width + numberLbl.Width + 5; } catch (Exception ex) { Cura.Common.Common.LogError("Failed To Initialise Worker Form", ex); } }
public static List<Availability> GetAvailabilityRecords(int Month, int Year) { AvailabilityCollection availabilityRecords = new AvailabilityCollection(); availabilityRecords.Where(Availability.Columns.Month, Month).Where(Availability.Columns.Year, Year).Load(); return availabilityRecords.GetList(); }
public AvailabilityCollection FetchByQuery(Query qry) { AvailabilityCollection coll = new AvailabilityCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public AvailabilityCollection FetchByID(object Id) { AvailabilityCollection coll = new AvailabilityCollection().Where("id", Id).Load(); return coll; }