private void BindClaimSkuSubCategory() { DropDownListSubCategory.ClearSelection(); DropDownListSubCategory.DataSource = ClaimSku.GetClaimSkuSubCategoryListByClaimSkuCategory(Convert.ToInt32(DropDownListCategory.SelectedValue)); DropDownListSubCategory.DataTextField = "Description"; DropDownListSubCategory.DataValueField = "ClaimSkuSubCategoryId"; DropDownListSubCategory.DataBind(); }
private void BindClaimSkuSubCategory() { DropDownListSubCategory.DataSource = ClaimSku.GetClaimSkuSubCategoryListByClaimSkuCategory(Convert.ToInt32(DropDownListCategory.SelectedValue)); DropDownListSubCategory.DataTextField = "Description"; DropDownListSubCategory.DataValueField = "ClaimSkuSubCategoryId"; DropDownListSubCategory.DataBind(); //DropDownListSubCategory.Items.Insert(0, new ListItem("Please select", "0")); }
protected void DropDownListCategory_SelectedIndexChanged(object sender, EventArgs e) { AltKategori a = new AltKategori(); a.KategoriId.Id = Convert.ToInt16(DropDownListCategory.SelectedItem.Value); AltKategoriDb db = new AltKategoriDb(); DropDownListSubCategory.DataSource = db.GetSubCategory(a); DropDownListSubCategory.DataTextField = "AltKategori_Ad"; DropDownListSubCategory.DataValueField = "AltKategori_ID"; DropDownListSubCategory.DataBind(); }
private void Reset() { ViewState["ClaimId"] = null; this.claimId = 0; DropDownListCategory.ClearSelection(); BindClaimSkuCategory(); DropDownListSubCategory.ClearSelection(); BindClaimSkuSubCategory(); TextBoxValue.Text = "0"; TextBoxQuantity.Text = "0"; TextBoxComment.Text = ""; }
protected void DropDownListCategory_SelectedIndexChanged(object sender, EventArgs e) { string constr = ConfigurationManager.ConnectionStrings["Registration"].ConnectionString; SqlConnection connec = new SqlConnection(constr); string S = "spGetSubCat"; SqlCommand com = new SqlCommand(S, connec); com.Parameters.AddWithValue("@id", int.Parse(DropDownListCategory.SelectedItem.Value)); connec.Open(); com.CommandType = CommandType.StoredProcedure; DropDownListSubCategory.DataSource = com.ExecuteReader(); DropDownListSubCategory.DataValueField = "subcat id"; DropDownListSubCategory.DataTextField = "sub cat name"; DropDownListSubCategory.DataBind(); connec.Close(); }
private void BindClaim() { try { StoreRep.Web.Code.Claim claim = StoreRep.Web.Code.Claim.GetClaimByClaimId(this.claimId); /* * PayStore - 0 = No * PayStore - 1 = Yes * PayStore - 99 = Not indicated yet */ RadioButtonPayStoreNo.Checked = claim.PayStore == 0; RadioButtonPayStoreYes.Checked = claim.PayStore == 1; /* * SupplierClaimBack - 0 = No * SupplierClaimBack - 1 = Yes * SupplierClaimBack - 99 = Not indicated yet */ RadioButtonClaimSupplierNo.Checked = claim.SupplierClaimBack == 0; RadioButtonClaimSupplierYes.Checked = claim.SupplierClaimBack == 1; DropDownListSupplier.ClearSelection(); DropDownListSupplier.Items.FindByValue(claim.ClaimSupplierId.ToString()).Selected = true; //BindStore(); DropDownListStore.ClearSelection(); DropDownListStore.Items.FindByValue(claim.StoreId.ToString()).Selected = true; TextBoxClaimDate.Text = claim.FormattedClaimDateEdit.ToString(); TextBoxClaimNumber.Text = claim.ClaimNumber; DropDownListClaimType.ClearSelection(); DropDownListClaimType.Items.FindByValue(claim.ClaimTypeId.ToString()).Selected = true; DropDownListClaimResponsible.ClearSelection(); DropDownListClaimResponsible.Items.FindByValue(claim.ClaimResponsibleId.ToString()).Selected = true; DropDownListCategory.ClearSelection(); DropDownListCategory.Items.FindByValue(claim.ClaimSkuCategoryId.ToString()).Selected = true; BindClaimSkuSubCategory(); DropDownListSubCategory.ClearSelection(); DropDownListSubCategory.Items.FindByValue(claim.ClaimSkuSubCategoryId.ToString()).Selected = true; TextBoxValue.Text = claim.Value.ToString(); //PanelQuantity.Visible = Convert.ToInt32(DropDownListClaimType.SelectedValue) == 4; //Recall if (Convert.ToInt32(DropDownListClaimType.SelectedValue) == 4)//Recall { PanelBatchNumber.Visible = true; TextBoxBatchNumber.Text = claim.BatchNumber; } else { PanelBatchNumber.Visible = true; TextBoxBatchNumber.Text = ""; } TextBoxQuantity.Text = claim.Quantity.ToString(); TextBoxComment.Text = claim.Comment; TextBoxClaimReference.Text = claim.ClaimReference; TextBoxCaptureDate.Text = String.Format("{0:d/M/yyyy HH:mm:ss}", claim.CreatedDate); TextBoxCapturedBy.Text = claim.ModifiedUser; if (Convert.ToInt32(DropDownListSupplier.SelectedValue) == 2) //Monteagle Africa { PanelKeyAccount.Visible = true; DropDownListKeyAccount.ClearSelection(); DropDownListKeyAccount.Items.FindByValue(claim.KeyAccountId.ToString()).Selected = true; } else { PanelKeyAccount.Visible = false; } BindClaimTypeSelection(); } 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; } }