protected void ButtonDelete_Click(object sender, EventArgs e) { ItemAttribute newItemAttribute = new ItemAttribute(); newItemAttribute.ItemAttributeID = Int32.Parse(TextBoxDeleteID.Text); ItemAttributeService.DeleteItemAttribute(newItemAttribute); Response.Redirect(Request.Url.ToString()); }
public static List<ItemAttribute> FindItemAttributesByCatalogAndLevel(int CatalogID, int Level) { List<ItemAttribute> result = new List<ItemAttribute>(); string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString(); SqlConnection sqlConn = new SqlConnection(connectionString); sqlConn.Open(); string cmdString = "SELECT * FROM [ItemAttribute] WHERE CatalogID=@catalogID AND ItemAttributeLevel = @itemAttributeLevel"; SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn); sqlCmd.Parameters.Add(new SqlParameter("catalogID", CatalogID)); sqlCmd.Parameters.Add(new SqlParameter("itemAttributeLevel", Level)); SqlDataReader sqlDataReader = sqlCmd.ExecuteReader(); if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { ItemAttribute newItemAttribute = new ItemAttribute(); FillItemAttribute(sqlDataReader, newItemAttribute); result.Add(newItemAttribute); } sqlDataReader.Close(); } return result; }
protected void ButtonEdit_Click(object sender, EventArgs e) { ItemAttribute newItemAttribute = new ItemAttribute(); newItemAttribute.ItemAttributeID = Int32.Parse(TextBoxEditID.Text); newItemAttribute.Name = TextBoxEditNewName.Text; ItemAttributeService.UpdateItemAttribute(newItemAttribute); Response.Redirect(Request.Url.ToString()); }
protected void ButtonAddAttr_Click(object sender, EventArgs e) { ItemAttribute newItemAttribute = new ItemAttribute(); newItemAttribute.CatalogID = Int32.Parse(DropDownListNewAttrCatalog.SelectedValue); newItemAttribute.ItemAttributeLevel = Int32.Parse(DropDownListNewAttrLevel.SelectedValue); newItemAttribute.Name = TextBoxNewAttrName.Text; ItemAttributeService.AddItemAttribute(newItemAttribute); Response.Redirect(Request.Url.ToString()); }
public static void DeleteItemAttribute(ItemAttribute itemAttribute) { string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString(); SqlConnection sqlConn = new SqlConnection(connectionString); sqlConn.Open(); string cmdString = "DELETE FROM [ItemAttribute] WHERE ItemAttributeID=@itemAttributeID"; SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn); sqlCmd.Parameters.Add(new SqlParameter("itemAttributeID", itemAttribute.ItemAttributeID)); sqlCmd.ExecuteNonQuery(); sqlConn.Close(); }
public static void AddItemAttribute(ItemAttribute newItemAttribute) { string connectionString = WebConfigurationManager.ConnectionStrings["defaultConnectionString"].ToString(); SqlConnection sqlConn = new SqlConnection(connectionString); sqlConn.Open(); string cmdString = "INSERT INTO [ItemAttribute] (CatalogID, ItemAttributeLevel, Name) VALUES (@catalogID, @itemAttributeLevel, @name)"; SqlCommand sqlCmd = new SqlCommand(cmdString, sqlConn); sqlCmd.Parameters.Add(new SqlParameter("catalogID", newItemAttribute.CatalogID)); sqlCmd.Parameters.Add(new SqlParameter("itemAttributeLevel", newItemAttribute.ItemAttributeLevel)); sqlCmd.Parameters.Add(new SqlParameter("name", newItemAttribute.Name)); sqlCmd.ExecuteNonQuery(); sqlConn.Close(); }
static void FillItemAttribute(SqlDataReader sqlDataReader, ItemAttribute newItemAttribute) { newItemAttribute.CatalogID = (int)sqlDataReader["CatalogID"]; newItemAttribute.ItemAttributeLevel = (int)sqlDataReader["ItemAttributeLevel"]; newItemAttribute.ItemAttributeID = (int)sqlDataReader["ItemAttributeID"]; newItemAttribute.Name = (string)sqlDataReader["Name"]; }
public static void UpdateItemAttribute(ItemAttribute itemAttribute) { ItemAttributeRepository.UpdateItemAttribute(itemAttribute); }
public static void DeleteItemAttribute(ItemAttribute itemAttribute) { ItemAttributeRepository.DeleteItemAttribute(itemAttribute); }
public static void AddItemAttribute(ItemAttribute newItemAttribute) { ItemAttributeRepository.AddItemAttribute(newItemAttribute); }