public List <Vendor> GetBySubCategoryUse(ProductSubCategoryId subCategoryId) { return(Search("dbo.GetVendorsBySubCategoryUse", delegate(SqlCommand cmd) { SqlHelper.AddParamInputId(cmd, "@ProductSubCategoryId", subCategoryId.Value); })); }
private void btnSetSubcategories_Click(object sender, EventArgs e) { bool onFirstRow = true; ProductSubCategoryId subCatId = null; int numberSet = 0; int numberSkipped = 0; List <DataGridViewRow> sortedRows = new List <DataGridViewRow>(); foreach (DataGridViewRow row in grdLines.SelectedRows) { sortedRows.Add(row); } sortedRows.Sort((r1, r2) => r1.Index.CompareTo(r2.Index)); foreach (DataGridViewRow row in sortedRows) { JoinPlToVpToProd purLine = (JoinPlToVpToProd)row.DataBoundItem; if (onFirstRow) { subCatId = purLine.PurLine_ProductSubCategoryId; ProductSubCategory subCat = mSubCategoriesById[subCatId.Value]; string prompt = "Use subcategory \"" + subCat.SubCategoryName + "\"?"; if (MessageBox.Show(prompt, "Confirm", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } onFirstRow = false; } else { if (purLine.PurLine_VendorProductId.IsNull) { purLine.PurLine_ProductSubCategoryId = subCatId; using (Ambient.DbSession.Activate()) { OrderingRepositories.PurLine.Update(purLine.InnerPurLine); numberSet++; } } else { numberSkipped++; } } } MessageBox.Show("Set subcategory for " + numberSet.ToString() + " rows."); MessageBox.Show("Skipped " + numberSkipped.ToString() + " rows because they were not manually added or imported to this order."); ShowLines(); ShowTotalCost(); }