/// <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();
}
