public void BindGrid()
{
DataSet dsSubCategoryMasterList = CSubCategoryMasterServices.SubCategoryMasterList();
GvSubCategoryList.DataSource = dsSubCategoryMasterList;
GvSubCategoryList.DataBind();
}
protected void GvSubCategoryList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//TblAddEdit.Visible = false;
//ButAdd.Visible = true;
int intSubCategoryId = Convert.ToInt32(GvSubCategoryList.DataKeys[e.RowIndex].Value);
CSubCategoryMaster ObjSubCategory = new CSubCategoryMaster(intSubCategoryId);
if (ObjSubCategory.IsExit == true)
{
Txtsubcategoryid.Text = ObjSubCategory.SubCategoryId.ToString();
Dropcategoryname.SelectedValue = ObjSubCategory.CategoryId.ToString();
Txtsubcategoryname.Text = ObjSubCategory.SubCategoryName;
DropStatus.SelectedValue = ObjSubCategory.Status;
}
int intResultValue = CSubCategoryMasterServices.SubCategoryDelete(intSubCategoryId);
if (intResultValue > 0)
{
BindGrid();
lblmsgbox.Text = "SubCategory Delete.";
Txtsubcategoryid.Text = "";
Txtsubcategoryname.Text = "";
}
else
{
lblmsgbox.Text = "Error occured while Deleting Data.";
}
}
private void BindSubCategory()
{
DataSet dsSubCategoryMasterList = CSubCategoryMasterServices.SubCategoryMasterList();
ListBox1.DataSource = dsSubCategoryMasterList;
ListBox1.DataTextField = "SubCategoryName";
ListBox1.DataValueField = "SubCategoryId";
ListBox1.DataBind();
}
public void BindCategoryName()
{
DataSet dsCategoryMasterList = CSubCategoryMasterServices.BindCategoryNameList();
Dropcategoryname.DataSource = dsCategoryMasterList;
Dropcategoryname.DataTextField = "CategoryName";
Dropcategoryname.DataValueField = "CategoryId";
Dropcategoryname.DataBind();
}
public void BindSubcategoryname(int CategoryId)
{
DataSet dsSubcategoryMasterListbyCategoryId = CSubCategoryMasterServices.SubCategoryMasterListbyCategoryId(Convert.ToInt32(DropCategoryname.SelectedValue));
DropSubCategory.DataSource = dsSubcategoryMasterListbyCategoryId;
DropSubCategory.Items.Clear();
DropSubCategory.DataTextField = "SubCategoryName";
DropSubCategory.DataValueField = "SubCategoryId";
DropSubCategory.DataBind();
}
protected void ButInsert_Click(object sender, EventArgs e)
{
//ButAdd.Visible = true;
//ButUpdate.Visible =false ;
//ButCancle.Visible = true;
int intReturnValue = CSubCategoryMasterServices.SubCategoryInsert(Convert.ToInt32(Dropcategoryname.SelectedValue), Txtsubcategoryname.Text, DropStatus.SelectedValue);
if (intReturnValue > 0)
{
lblmsgbox.Text = "SubCategory Insert";
BindGrid();
//Dropcategoryname.SelectedValue="";
Txtsubcategoryname.Text = "";
// TxtSubCategoryDescription.Text = "";
TblAddEdit.Visible = false;
}
else
{
lblmsgbox.Text = "Error occured while insering SubCategory.";
}
}
protected void ButUpdate_Click(object sender, EventArgs e)
{
ButInsert.Visible = false;
ButCancle.Visible = true;
int intReturnValue = CSubCategoryMasterServices.SubCategoryUpDate(Convert.ToInt32(Txtsubcategoryid.Text),
Convert.ToInt32(Dropcategoryname.SelectedValue), Txtsubcategoryname.Text,
DropStatus.SelectedValue);
if (intReturnValue > 0)
{
lblmsgbox.Text = "SubCategory UpDate.";
BindGrid();
Txtsubcategoryid.Text = "";
Txtsubcategoryname.Text = "";
DropStatus.SelectedValue = "";
TblAddEdit.Visible = false;
}
else
{
lblmsgbox.Text = "Error occured while UpDate Category.";
}
}
