/// <summary> /// This finally deletes the selected category /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirm_Click(object sender, EventArgs e) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", ddlCategories.SelectedValue, 4, SqlDbType.Char, ParameterDirection.Input)); SqlJacknife.SendCommand("Categ_Delete", parms, CommandType.StoredProcedure); Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label; lblMasterMessage.Text = "Category Deleted"; getCategories(); IdeaHeaderAndSide master = (IdeaHeaderAndSide)this.Master; master.getCategories(); btnCancel.Visible = false; btnConfirm.Visible = false; btnNew.Visible = true; btnSave.Visible = true; btnDelete.Visible = true; master.messageSuccess("Category deleted"); //Response.Redirect("default.aspx?messageSuccess=Category+Deleted!"); } catch { master.messageError("Cannot delete Categories containing products"); } }
/// <summary> /// Saves or updates the category /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { // Check if the name is null or empty if (string.IsNullOrEmpty(cat_name.Text.Trim())) { IdeaHeaderAndSide leMaster = (IdeaHeaderAndSide)this.Master; leMaster.messageError("Please enter a title!"); } Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label; String idOutput = ""; if (ddlCategories.Visible == false) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", idOutput, 4, SqlDbType.Char, ParameterDirection.Output)); parms.Add(new SqlJacknife.ParmStruct("@cat_name", cat_name.Text, 30, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@description", description.Text, 200, SqlDbType.VarChar, ParameterDirection.Input)); SqlJacknife.SendCommand("Categ_Add", parms, CommandType.StoredProcedure); this.master.messageSuccess("Category Added"); } else if (ddlCategories.Visible == true) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", ddlCategories.SelectedValue, 30, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@cat_name", cat_name.Text, 30, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@description", description.Text, 200, SqlDbType.VarChar, ParameterDirection.Input)); SqlJacknife.SendCommand("Categ_Update", parms, CommandType.StoredProcedure); this.master.messageSuccess("Category Updated"); } getCategories(); //IdeaHeaderAndSide master = (IdeaHeaderAndSide)this.Master; master.getCategories(); }