private void SaveInsightSupplierOption(int insightSupplierId) { InsightSupplierOption.DeleteInsightSupplierOptionByInsightSupplierId(insightSupplierId); foreach (ListItem listItem in CheckBoxListOption.Items) { if (listItem.Selected) { InsightSupplierOption iso = new InsightSupplierOption(); iso.InsightSupplierId = insightSupplierId; iso.OptionId = Convert.ToInt32(listItem.Value); iso.ModifiedUser = Context.User.Identity.GetUserName(); iso.Save(); } } }
private void BindInsightSupplier() { try { InsightSupplier insightSupplier = InsightSupplier.GetInsightSupplierByInsightSupplierId(this.insightSupplierId); TextBoxSupplierName.Text = insightSupplier.SupplierName; TextBoxSupplierNameModel.Text = insightSupplier.SupplierNameModel; TextBoxPastelRef.Text = insightSupplier.PastelRef; TextBoxMonths.Text = insightSupplier.Months.ToString(); TextBoxNotes.Text = insightSupplier.Notes; DropDownListSupplierType.Items.FindByValue(insightSupplier.SupplierTypeId.ToString()).Selected = true; //DropDownListOption.Items.FindByValue(insightSupplier.OptionId.ToString()).Selected = true; DropDownListSecurity.Items.FindByValue(insightSupplier.SecurityId.ToString()).Selected = true; //DropDownListLink.Items.FindByValue(insightSupplier.LinkId.ToString()).Selected = true; DropDownListCategoryReduction.Items.FindByValue(insightSupplier.CategoryReductionId.ToString()).Selected = true; DropDownListBuild.Items.FindByValue(insightSupplier.BuildId.ToString()).Selected = true; DropDownListStatus.Items.FindByValue(insightSupplier.StatusId.ToString()).Selected = true; DropDownListCatman.Items.FindByValue(insightSupplier.CatmanId.ToString()).Selected = true; DropDownListCustom.Items.FindByValue(insightSupplier.CustomId.ToString()).Selected = true; DropDownListDaily.Items.FindByValue(insightSupplier.DailyId.ToString()).Selected = true; DropDownListWeekly.Items.FindByValue(insightSupplier.WeeklyId.ToString()).Selected = true; DropDownListPromo.Items.FindByValue(insightSupplier.PromoId.ToString()).Selected = true; List <InsightSupplierModel> ismList = InsightSupplierModel.GetInsightSupplierModelByInsightSupplierId(this.insightSupplierId); foreach (ListItem listItem in CheckBoxListModel.Items) { foreach (InsightSupplierModel ism in ismList) { if (listItem.Value == ism.ModelId.ToString()) { listItem.Selected = true; } } } List <InsightSupplierOption> isoList = InsightSupplierOption.GetInsightSupplierOptionByInsightSupplierId(this.insightSupplierId); foreach (ListItem listItem in CheckBoxListOption.Items) { foreach (InsightSupplierOption iso in isoList) { if (listItem.Value == iso.OptionId.ToString()) { listItem.Selected = true; } } } List <InsightSupplierLink> islList = InsightSupplierLink.GetInsightSupplierLinkByInsightSupplierId(this.insightSupplierId); foreach (ListItem listItem in CheckBoxListLink.Items) { foreach (InsightSupplierLink isl in islList) { if (listItem.Value == isl.LinkId.ToString()) { listItem.Selected = true; } } } } catch (System.Data.SqlClient.SqlException sqlEx) { for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } catch (Exception exception) { LabelError.Text += (exception.Message + "<br />"); PanelError.Visible = true; } }