protected override void OnLoad(EventArgs e) { base.OnLoad(e); SOE = new SalesOfferEntities(); // Call the Load method to get the data for the given DbSet // from the database. // The data is materialized as entities. The entities are managed by // the DbContext instance. //SOE.OfferVersionGroup.Load(); // Bind the categoryBindingSource.DataSource to // all the Unchanged, Modified and Added Category objects that // are currently tracked by the DbContext. // Note that we need to call ToBindingList() on the // ObservableCollection<TEntity> returned by // the DbSet.Local property to get the BindingList<T> // in order to facilitate two-way binding in WinForms. SOE.OfferFile.Load(); SOE.Offer.Load(); //int[] All =new int[1]; //All[0] = 100; //var otypes = (from o in SOE.Offer select o.TypeId).Distinct().Union(All); //offerTypeBindignSource.DataSource = otypes.ToList(); //offerTypeBindignSource = SOE.Offer.GetTypeIdDistinct(); IBindingList list = SOE.OfferFile.Local.ToBindingList(); this.offerFileBindingSource.DataSource = list; this.offerBindingSource.DataSource = list; list.ListChanged += List_ListChanged; //SOE.OfferVersionGroup.Load(); //this.offerVersionGroupBindingSource.DataSource = SOE.OfferVersionGroup.Local.ToBindingList(); //SOE.OfferItem.Load(); //this.offerItemBindingSource.DataSource = SOE.OfferItem.Local.ToBindingList(); }
public Form2(OfferVersionGroup obj, SalesOfferEntities SOE) { InitializeComponent(); //SOEOI = new SalesOfferEntities(); this.SOEOI = SOE; IList <OfferItem> oi = new System.ComponentModel.BindingList <OfferItem>(); oi = SOE.OfferItem.Local.ToBindingList(); // offerItemBindingSource = new BindingSource(); offerItemBindingSource.DataSource = oi.Where(offi => offi.OfferVersionGroupId == obj.Id).ToList(); offerBindingSource.DataSource = obj.OfferVersion.Offer; offerVersionBindingSource = new BindingSource(); var qovid = ((from ov in SOEOI.OfferVersion where ov.OfferId == obj.OfferVersion.OfferId select ov.IssueDate)).SingleOrDefault(); DateTime ovid; if (DateTime.TryParse(qovid.ToString(), out ovid)) { labIssueDate.Text = ovid.ToString("yyyy/MM/dd"); } else { labIssueDate.Text = null; } //offerVersionBindingSource.DataSource = SOEOI.OfferVersion.Local.ToBindingList().Where(ov => ov.OfferId == obj.OfferVersion.OfferId); }