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;
}
}
