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