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