private void frmPackageProducts_Load(object sender, EventArgs e) { using (TravelExpertsDataContext dbContext = new TravelExpertsDataContext()) { dbContext.DeferredLoadingEnabled = false; PackageProductsGridView.DataSource = (from pack in dbContext.Packages join psi in dbContext.Packages_Products_Suppliers on pack.PackageId equals psi.PackageId join ps in dbContext.Products_Suppliers on psi.ProductSupplierId equals ps.ProductSupplierId join p in dbContext.Products on ps.ProductId equals p.ProductId join s in dbContext.Suppliers on ps.SupplierId equals s.SupplierId select new { pack.PkgName, p.ProdName, s.SupName }); //where psi.ProductSupplierId //join ps in dbContext.Products_Suppliers on psi.ProductSupplierId equals ps.ProductSupplierId //orderby psi.PackageId // statment where products = value passed from package ID? } }
private void btnModify_Click(object sender, EventArgs e) { //find column and row location of ID int rowNum = packageDataGridView.CurrentCell.RowIndex; int packID = (int)packageDataGridView["dataGridViewTextBoxColumn1", rowNum].Value; //Select ID Package currentPackage; using (TravelExpertsDataContext dbContext = new TravelExpertsDataContext()) { currentPackage = (from pack in dbContext.Packages where pack.PackageId == packID select pack).Single(); } //Open new form to view products by package ID frmPackageAddModify secondForm = new frmPackageAddModify(); secondForm.currentPackage = currentPackage; DialogResult result = secondForm.ShowDialog(); if (result == DialogResult.OK || result == DialogResult.Retry) { RefreshGridView(); } }
private void frmPackageView_Load(object sender, EventArgs e) { // load package list to grid using (TravelExpertsDataContext dbContext = new TravelExpertsDataContext()) { // select all packages ordered by start date packageDataGridView.DataSource = from pack in dbContext.Packages orderby pack.PkgStartDate select pack; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (TravelExpertsDataContext dbContext = new TravelExpertsDataContext()) { if (isAdd) { Package newPackage = new Package() { PkgAgencyCommission = Convert.ToDecimal(txbPkgAgencyCommission.Text), PkgBasePrice = Convert.ToDecimal(txbPkgBasePrice.Text), PkgDesc = txbPkgDesc.Text, PkgName = txbPkgName.Text, PkgStartDate = startTmpDate, PkgEndDate = endTmpDate }; using (TravelExpertsDataContext dataContext = new TravelExpertsDataContext()) { dbContext.Packages.InsertOnSubmit(newPackage); dbContext.SubmitChanges(); } DialogResult = DialogResult.OK; } else { Package pkg = dbContext.Packages.SingleOrDefault(p => p.PackageId == Convert.ToInt32(txbPackageId.Text)); pkg.PkgAgencyCommission = Convert.ToDecimal(txbPkgAgencyCommission.Text); pkg.PkgBasePrice = Convert.ToDecimal(txbPkgBasePrice.Text); pkg.PkgDesc = txbPkgDesc.Text; pkg.PkgName = txbPkgName.Text; pkg.PkgStartDate = startTmpDate; pkg.PkgEndDate = endTmpDate; dbContext.SubmitChanges(); DialogResult = DialogResult.OK; } } } catch (ChangeConflictException) { MessageBox.Show("Another user changed or deleted the current record", "Concurrency Exception"); DialogResult = DialogResult.Retry; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
private void RefreshGridView() { TravelExpertsDataContext dbContext = new TravelExpertsDataContext(); packageDataGridView.DataSource = dbContext.Packages; }