private Panel renderCatalogItem(Catalog catalog)
{
Panel catalogListItemContainer = new Panel();
catalogListItemContainer.CssClass = "catalogListItemContainer";
Panel catalogItemFirstClass = new Panel();
catalogItemFirstClass.CssClass = "catalogItemFirstClass";
Label firstClassLabel = new Label();
firstClassLabel.Text = catalog.Name;
catalogItemFirstClass.Controls.Add(firstClassLabel);
catalogListItemContainer.Controls.Add(catalogItemFirstClass);
List<Catalog> childCatalogs = CatalogService.GetAllChildCatalogs(catalog.CatalogID);
foreach (Catalog childCatalog in childCatalogs)
{
Panel catalogItemSecondClass = new Panel();
catalogItemSecondClass.CssClass = "catalogItemSecondClass";
HyperLink secondClassLink = new HyperLink();
secondClassLink.Text = childCatalog.Name;
secondClassLink.NavigateUrl = "~/Page/V2/Business/catalogDetail.aspx?catalog=" + childCatalog.CatalogID.ToString();
catalogItemSecondClass.Controls.Add(secondClassLink);
catalogListItemContainer.Controls.Add(catalogItemSecondClass);
}
return catalogListItemContainer;
}
public static List<Catalog> FindAllChildCatalogs(int catalogID)
{
List<Catalog> result = new List<Catalog>();
string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
string cmdString = "SELECT * FROM [Catalog] WHERE ParentCatalogID = @parentCatalogID";
SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn);
sqlCmd.Parameters.Add(new SqlParameter("parentCatalogID", catalogID));
SqlDataReader sqlDataReader = sqlCmd.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
Catalog newCatalog = new Catalog();
FillCatalog(sqlDataReader, newCatalog);
result.Add(newCatalog);
}
sqlDataReader.Close();
}
return result;
}
protected void ButtonDeleteCatalog_Click(object sender, EventArgs e)
{
Catalog oldCatalog = new Catalog();
oldCatalog.CatalogID = Int32.Parse(DropDownListDeleteCatalog.SelectedValue);
CatalogService.DeleteCatalog(oldCatalog);
Response.Redirect(Request.Url.ToString());
}
protected void ButtonModifyCatalog_Click(object sender, EventArgs e)
{
Catalog newCatalog = new Catalog();
newCatalog.CatalogID = Int32.Parse(DropDownListModifyCatalog.SelectedValue);
newCatalog.Name = TextBoxModifyCatalog.Text;
CatalogService.ModifyCatalog(newCatalog);
Response.Redirect(Request.Url.ToString());
}
protected void ButtonAddCatalog_Click(object sender, EventArgs e)
{
Catalog newCatalog = new Catalog();
newCatalog.Name = TextBoxNewCatalogName.Text;
newCatalog.ParentCatalogID = Int32.Parse(DropDownListFirstLevelCatalogs.SelectedValue);
CatalogService.AddCatalog(newCatalog);
Response.Redirect(Request.Url.ToString());
}
public static void DeleteCatalog(Catalog oldCatalog)
{
string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
string cmdString = "DELETE FROM Catalog WHERE CatalogID=@catalogID";
SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn);
sqlCmd.Parameters.Add(new SqlParameter("catalogID", oldCatalog.CatalogID));
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}
private void renderCatalogSubTitle()
{
List<Catalog> secondLevelCatalogs = CatalogService.GetAllSecondLevelCatalogs();
foreach (Catalog catalog in secondLevelCatalogs)
{
if (catalog.CatalogID == this.catalogNum)
{
this.currentCatalog = catalog;
break;
}
}
this.catalogDetailSubTitleLabel.Text = this.currentCatalog.Name;
}
public static void AddNewCatalog(Catalog newCatalog)
{
string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
string cmdString = "INSERT INTO Catalog (ParentCatalogID, Name) VALUES (@parentCatalogID, @name)";
SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn);
sqlCmd.Parameters.Add(new SqlParameter("parentCatalogID", newCatalog.ParentCatalogID));
sqlCmd.Parameters.Add(new SqlParameter("name", newCatalog.Name));
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}
static void FillCatalog(SqlDataReader sqlDataReader, Catalog newCatalog)
{
newCatalog.CatalogID = (int)sqlDataReader["CatalogID"];
newCatalog.ParentCatalogID = (int)sqlDataReader["ParentCatalogID"];
newCatalog.Name = (string)sqlDataReader["Name"];
}
public static void ModifyCatalog(Catalog newCatalog)
{
string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
string cmdString = "UPDATE Catalog SET Name=@name WHERE CatalogID=@catalogID";
SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn);
sqlCmd.Parameters.Add(new SqlParameter("catalogID", newCatalog.CatalogID));
sqlCmd.Parameters.Add(new SqlParameter("name", newCatalog.Name));
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}
public static void ModifyCatalog(Catalog newCatalog)
{
CatalogRepository.ModifyCatalog(newCatalog);
}
public static void DeleteCatalog(Catalog oldCatalog)
{
CatalogRepository.DeleteCatalog(oldCatalog);
}
public static void AddCatalog(Catalog newCatalog)
{
CatalogRepository.AddNewCatalog(newCatalog);
}
