protected void gviewProductCategory_RowUpdating(object sender, GridViewUpdateEventArgs e) { Ref_ProductCategory prodCategory = new Ref_ProductCategory(); prodCategory.CategoryID = Convert.ToInt32((gviewProductCategory.Rows[e.RowIndex].FindControl("hdnCategoryID") as HiddenField).Value); prodCategory.CategoryName = (gviewProductCategory.Rows[e.RowIndex].FindControl("txtCategoryName") as TextBox).Text; prodCategory.Description = (gviewProductCategory.Rows[e.RowIndex].FindControl("txtDescription") as TextBox).Text; prodCategory.ModifiedBy = User.Identity.Name.ToString(); Ref_ProductCategoryManager.Save(prodCategory); gviewProductCategory.EditIndex = -1; //enable the save button on the panel above after update lnkSaveProductCategory.Enabled = true; lnkSaveProductCategory.CssClass = "linkStyle"; PopulateGridview(); //show the edit and delete column gviewProductCategory.Columns[3].Visible = true; //edit column gviewProductCategory.Columns[4].Visible = true; //delete column //hide the update and cancel column gviewProductCategory.Columns[5].Visible = false; //update column gviewProductCategory.Columns[6].Visible = false; //cancel column }
protected void gviewProductCategory_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get the category id of the product category to be deleted int categoryID = Convert.ToInt32((gviewProductCategory.Rows[e.RowIndex].FindControl("hdnCategoryID") as HiddenField).Value); //delete Ref_ProductCategoryManager.DeleteProductCategory(categoryID); //re-bind the gridview PopulateGridview(); }
protected void lnkSaveProductCategory_OnCommand(object sender, CommandEventArgs e) { //clear previous messages lblMessage.Text = ""; Ref_ProductCategory newProdCategory = new Ref_ProductCategory(); newProdCategory.CategoryName = (fviewProdCategory.FindControl("txtProductCategoryName") as TextBox).Text.Trim().ToUpper(); newProdCategory.Description = (fviewProdCategory.FindControl("txtProductCategoryDescription") as TextBox).Text.Trim(); newProdCategory.CreatedBy = User.Identity.Name.ToString(); //check if the category name already exist //get existing categories Ref_ProductCategoryList existingCategories = Ref_ProductCategoryManager.GetList(); // find a match IEnumerable <Ref_ProductCategory> query = from cat in existingCategories where cat.CategoryName == newProdCategory.CategoryName select cat; // if there is no match, then proceed with add if (!query.Any()) { //add the new product category Ref_ProductCategoryManager.Save(newProdCategory); //clear the inputs (fviewProdCategory.FindControl("txtProductCategoryName") as TextBox).Text = ""; (fviewProdCategory.FindControl("txtProductCategoryDescription") as TextBox).Text = ""; } else { lblMessage.Text = "Category name" + newProdCategory.CategoryName + " already exist."; lblMessage.ForeColor = System.Drawing.Color.Red; (fviewProdCategory.FindControl("txtProductCategoryName") as TextBox).Focus(); } PopulateGridview(); gviewProductCategory.Focus(); }
private void PopulateGridview() { gviewProductCategory.DataSource = Ref_ProductCategoryManager.GetList(); gviewProductCategory.DataBind(); }