protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                switch (e.CommandName.ToLower())
                {
                case "removeinsightsupplier":
                {
                    int insightSupplierId = Convert.ToInt32(e.CommandArgument);

                    InsightSupplierCustomHeader.DeleteInsightSupplierCustomHeaderByInsightSupplierId(insightSupplierId);
                    InsightSupplierContactDistributionLink.DeleteInsightSupplierContactDistributionLinkByInsightSupplierId(insightSupplierId);
                    InsightSupplierContactDistributionOption.DeleteInsightSupplierContactDistributionOptionByInsightSupplierId(insightSupplierId);
                    InsightSupplierContactDistributionModel.DeleteInsightSupplierContactDistributionModelByInsightSupplierId(insightSupplierId);
                    InsightSupplierContactLicense.DeleteInsightSupplierContactLicenseByInsightSupplierId(insightSupplierId);
                    InsightSupplierContactLink.DeleteInsightSupplierContactLinkByInsightSupplierId(insightSupplierId);
                    InsightSupplierMerchandising.DeleteInsightSupplierMerchandisingByInsightSupplierId(insightSupplierId);
                    InsightSupplierMerchSupplierLink.DeleteInsightSupplierMerchSupplierLinkByInsightSupplierId(insightSupplierId);
                    InsightSupplier.DeleteInsightSupplierByInsightSupplierId(insightSupplierId);

                    BindGridViewResultDefault();

                    break;
                }
                }
            }
            catch (System.Data.SqlClient.SqlException sqlEx)
            {
            }
        }
        private void SaveInsightSupplieMerchSupplier(int insightSupplierId)
        {
            InsightSupplierMerchSupplierLink iSMSL = new InsightSupplierMerchSupplierLink();

            iSMSL.InsightSupplierId = insightSupplierId;
            iSMSL.SupplierParentId  = 0;
            iSMSL.SupplierId        = Convert.ToInt32(DropDownListSupplierList.SelectedValue);
            iSMSL.ModifiedUser      = Context.User.Identity.GetUserName();

            iSMSL.Save();
        }
        protected void GridViewLinkedSupplier_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                switch (e.CommandName.ToLower())
                {
                case "viewauthorization":
                {
                    ViewState["SupplierId"] = Convert.ToInt32(e.CommandArgument);
                    BindViewAuthorization(0);

                    break;
                }

                case "viewcategories":
                {
                    ViewState["SupplierId"] = Convert.ToInt32(e.CommandArgument);
                    BindSupplierMerchandisingGridView();

                    break;
                }

                case "removeinsightsuppliermerchsupplierlink":
                {
                    InsightSupplier.DeleteInsightSupplierMerchandisingByInsightSupplierIdAndSupplierId(Convert.ToInt32(ViewState["InsightSupplierId"]), Convert.ToInt32(ViewState["SupplierId"]));
                    InsightSupplierMerchSupplierLink.DeleteInsightSupplierMerchSupplierLinkByInsightSupplierMerchSupplierLinkId(Convert.ToInt32(e.CommandArgument));

                    BindSupplierList();
                    BindLinkedSupplierGridView();
                    BindSupplierMerchandisingGridView();

                    CloseSupplierAuthorization();
                    CloseSupplierMerchandisingGridView();

                    break;
                }
                }
            }
            catch (System.Data.SqlClient.SqlException sqlEx)
            {
                LabelError.Text = "";
                for (int i = 0; i < sqlEx.Errors.Count; i++)
                {
                    LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
                }
                PanelError.Visible = true;
            }
        }
 private void BindLinkedSupplierGridView()
 {
     GridViewLinkedSupplier.DataSource = InsightSupplierMerchSupplierLink.GetInsightSupplierMerchSupplierListByInsightSupplierId(Convert.ToInt32(ViewState["InsightSupplierId"]));
     GridViewLinkedSupplier.DataBind();
 }