433 lines
19 KiB
C#
433 lines
19 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using System.Drawing;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using System.Windows.Forms;
|
|
|
|
namespace InventoryTest
|
|
{
|
|
public partial class CategoryManager : Form
|
|
{
|
|
private string ConnectionString { get; set; }
|
|
private Dictionary<string, int> CategoryIds { get; } = new();
|
|
private Dictionary<string, int> SubCategoryIds { get; } = new();
|
|
private Dictionary<string, Property> CategoryPropertyIds { get; } = new();
|
|
private Dictionary<string, Property> SubCategoryPropertyIds { get; } = new();
|
|
private Dictionary<string, int> PropertyTypeIds { get; } = new();
|
|
|
|
public CategoryManager(string connectionString)
|
|
{
|
|
ConnectionString = connectionString;
|
|
|
|
InitializeComponent();
|
|
|
|
CategoryComboBoxManager.SelectedIndexChanged += CategoryComboBoxManager_SelectedIndexChanged;
|
|
SubCategoryComboBoxManager.SelectedIndexChanged += SubCategoryComboBoxManager_SelectedIndexChanged;
|
|
CategoryPropertyNameTextBox.TextChanged += CategoryPropertyNameTextBox_TextChanged;
|
|
SubCategoryPropertyNameTextBox.TextChanged += SubCategoryNameTextBox_TextChanged;
|
|
NewCategoryNameTextBox.TextChanged += NewCategoryNameTextBox_TextChanged;
|
|
CategoryPropertiesListBox.SelectedIndexChanged += CategoryPropertiesListBox_SelectedIndexChanged;
|
|
SubCategoryPropertiesListBox.SelectedIndexChanged += SubCategoryPropertiesListBox_SelectedIndexChanged;
|
|
CategoryPropertyInfoNameTextBox.TextChanged += CategoryPropertyInfoNameTextBox_TextChanged;
|
|
SubCategoryPropertyInfoNameTextBox.TextChanged += SubCategoryPropertyInfoNameTextBox_TextChanged;
|
|
|
|
LoadPropertyTypes();
|
|
LoadCategories();
|
|
}
|
|
|
|
private void SubCategoryPropertyInfoNameTextBox_TextChanged(object sender, EventArgs e)
|
|
{
|
|
SubCategoryPropertyInfoUpdateButton.Enabled = SubCategoryPropertyInfoNameTextBox.TextLength > 0 && (SubCategoryPropertiesListBox.SelectedIndex != -1 && SubCategoryPropertiesListBox.SelectedItem.ToString() != SubCategoryPropertyInfoNameTextBox.Text.Trim());
|
|
}
|
|
|
|
private void CategoryPropertyInfoNameTextBox_TextChanged(object sender, EventArgs e)
|
|
{
|
|
CategoryPropertyInfoUpdateButton.Enabled = CategoryPropertyInfoNameTextBox.TextLength > 0 && (CategoryPropertiesListBox.SelectedIndex != -1 && CategoryPropertiesListBox.SelectedItem.ToString() != CategoryPropertyInfoNameTextBox.Text.Trim()); ;
|
|
}
|
|
|
|
private void LoadPropertyTypes()
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("SELECT * FROM dbo.GetPropertyTypes()", connection);
|
|
|
|
connection.Open();
|
|
|
|
var reader = command.ExecuteReader();
|
|
|
|
while (reader.Read())
|
|
{
|
|
CategoryPropertyTypeComboBox.Items.Add(reader["Property Type"]);
|
|
CategoryPropertyInfoTypeComboBox.Items.Add(reader["Property type"]);
|
|
SubCategoryPropertyTypeComboBox.Items.Add(reader["Property Type"]);
|
|
SubCategoryTypeInfoComboBox.Items.Add(reader["Property Type"]);
|
|
PropertyTypeIds.Add(reader["Property Type"].ToString(), Convert.ToInt32(reader["Property Type ID"]));
|
|
}
|
|
|
|
CategoryPropertyTypeComboBox.SelectedIndex = CategoryPropertyInfoTypeComboBox.SelectedIndex = SubCategoryPropertyTypeComboBox.SelectedIndex = SubCategoryTypeInfoComboBox.SelectedIndex = 3;
|
|
}
|
|
|
|
private void SubCategoryPropertiesListBox_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
DeleteSubCategoryPropertyButton.Enabled = SubCategoryPropertiesListBox.SelectedIndex >= 0;
|
|
SubCategoryPropertyInfoNameTextBox.Enabled = SubCategoryPropertiesListBox.SelectedIndex >= 0;
|
|
SubCategoryTypeInfoComboBox.Enabled = SubCategoryPropertiesListBox.SelectedIndex >= 0;
|
|
|
|
if (SubCategoryPropertyInfoNameTextBox.Enabled) SubCategoryPropertyInfoNameTextBox.Text = SubCategoryPropertiesListBox.SelectedItem.ToString();
|
|
else SubCategoryPropertyInfoNameTextBox.Text = string.Empty;
|
|
}
|
|
|
|
private void CategoryPropertiesListBox_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
DeleteCategoryPropertyButton.Enabled = CategoryPropertiesListBox.SelectedIndex >= 0;
|
|
CategoryPropertyInfoNameTextBox.Enabled = CategoryPropertiesListBox.SelectedIndex >= 0;
|
|
CategoryPropertyInfoTypeComboBox.Enabled = CategoryPropertiesListBox.SelectedIndex >= 0;
|
|
|
|
if (CategoryPropertyInfoNameTextBox.Enabled) CategoryPropertyInfoNameTextBox.Text = CategoryPropertiesListBox.SelectedItem.ToString();
|
|
else CategoryPropertyInfoNameTextBox.Text = string.Empty;
|
|
}
|
|
|
|
private void NewCategoryNameTextBox_TextChanged(object sender, EventArgs e)
|
|
{
|
|
CreateNewCategoryButton.Enabled = !string.IsNullOrEmpty(NewCategoryNameTextBox.Text);
|
|
CreateNewSubCategoryButton.Enabled = !string.IsNullOrEmpty(NewCategoryNameTextBox.Text);
|
|
}
|
|
|
|
private void SubCategoryNameTextBox_TextChanged(object sender, EventArgs e)
|
|
{
|
|
CreateSubCategoryButton.Enabled = !string.IsNullOrEmpty(SubCategoryPropertyNameTextBox.Text);
|
|
}
|
|
|
|
private void CategoryPropertyNameTextBox_TextChanged(object sender, EventArgs e)
|
|
{
|
|
CreateCategoryPropertyButton.Enabled = CategoryComboBoxManager.Items.Count > 0 && !string.IsNullOrEmpty(CategoryPropertyNameTextBox.Text);
|
|
}
|
|
|
|
private void SubCategoryComboBoxManager_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
LoadSubCategoryProperties();
|
|
}
|
|
|
|
private void CategoryComboBoxManager_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
SubCategoryComboBoxManager.Items.Clear();
|
|
CategoryPropertiesListBox.Items.Clear();
|
|
SubCategoryPropertiesListBox.Items.Clear();
|
|
DeleteCategoryPropertyButton.Enabled = false;
|
|
DeleteSubCategoryPropertyButton.Enabled = false;
|
|
var id = CategoryIds[CategoryComboBoxManager.Text];
|
|
SubCategoryIds.Clear();
|
|
SubCategoryPropertyIds.Clear();
|
|
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("SELECT * FROM dbo.GetCategorySubCategories(@ID)", connection);
|
|
command.Parameters.AddWithValue("ID", id);
|
|
|
|
connection.Open();
|
|
|
|
var reader = command.ExecuteReader();
|
|
|
|
while (reader.Read())
|
|
{
|
|
SubCategoryComboBoxManager.Items.Add(reader["Name"]);
|
|
SubCategoryIds.Add(reader["Name"].ToString(), Convert.ToInt32(reader["ID"]));
|
|
}
|
|
|
|
reader.Close();
|
|
|
|
if (SubCategoryComboBoxManager.Items.Count > 0)
|
|
{
|
|
SubCategoryComboBoxManager.Enabled = true;
|
|
SubCategoryComboBoxManager.SelectedIndex = 0;
|
|
ToggleSubCategoryProperty(true);
|
|
}
|
|
else
|
|
{
|
|
ToggleSubCategoryProperty(false);
|
|
SubCategoryComboBoxManager.Enabled = false;
|
|
}
|
|
|
|
LoadCategoryProperties();
|
|
}
|
|
|
|
private void LoadCategories()
|
|
{
|
|
CategoryComboBoxManager.Items.Clear();
|
|
SubCategoryComboBoxManager.Items.Clear();
|
|
CategoryIds.Clear();
|
|
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("SELECT [Category ID], [Category Name] FROM Category", connection);
|
|
|
|
connection.Open();
|
|
|
|
var reader = command.ExecuteReader();
|
|
|
|
while (reader.Read())
|
|
{
|
|
CategoryIds.Add(reader["Category Name"].ToString(), Convert.ToInt32(reader["Category ID"]));
|
|
CategoryComboBoxManager.Items.Add(reader["Category Name"]);
|
|
}
|
|
|
|
reader.Close();
|
|
|
|
if (CategoryComboBoxManager.Items.Count > 0)
|
|
{
|
|
ToggleCategoryProperty(true);
|
|
CategoryComboBoxManager.SelectedIndex = 0;
|
|
}
|
|
else ToggleCategoryProperty(false);
|
|
}
|
|
|
|
private void LoadCategoryProperties()
|
|
{
|
|
CategoryPropertiesListBox.Items.Clear();
|
|
CategoryPropertyIds.Clear();
|
|
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("SELECT * FROM GetCategoryProperties(@CategoryID)", connection);
|
|
command.Parameters.AddWithValue("CategoryID", CategoryIds[CategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
var reader = command.ExecuteReader();
|
|
|
|
while (reader.Read())
|
|
{
|
|
CategoryPropertyIds.Add(reader["Name"].ToString(), new Property
|
|
{
|
|
PropertyName = reader["Name"].ToString(),
|
|
PropertyId = Convert.ToInt32(reader["Property ID"]),
|
|
CategoryPropertyId = Convert.ToInt32(reader["Category Property ID"]),
|
|
PropertyType = reader["Property Type"].ToString(),
|
|
PropertyTypeId = Convert.ToInt32(reader["Property Type ID"])
|
|
});
|
|
CategoryPropertiesListBox.Items.Add(reader["Name"]);
|
|
}
|
|
}
|
|
|
|
private void LoadSubCategoryProperties()
|
|
{
|
|
SubCategoryPropertiesListBox.Items.Clear();
|
|
SubCategoryPropertyIds.Clear();
|
|
DeleteSubCategoryPropertyButton.Enabled = false;
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("SELECT * FROM GetSubCategoryProperties(@ID)", connection);
|
|
command.Parameters.AddWithValue("ID", SubCategoryIds[SubCategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
var reader = command.ExecuteReader();
|
|
|
|
while (reader.Read())
|
|
{
|
|
SubCategoryPropertyIds.Add(reader["Name"].ToString(), new Property
|
|
{
|
|
PropertyName = reader["Name"].ToString(),
|
|
PropertyId = Convert.ToInt32(reader["Property ID"]),
|
|
CategoryPropertyId = Convert.ToInt32(reader["Sub Category Property ID"]),
|
|
PropertyType = reader["Property Type"].ToString(),
|
|
PropertyTypeId = Convert.ToInt32(reader["Property Type ID"])
|
|
});
|
|
SubCategoryPropertiesListBox.Items.Add(reader["Name"]);
|
|
}
|
|
}
|
|
|
|
private void ToggleSubCategoryProperty(bool enabled)
|
|
{
|
|
SubCategoryPropertyNameTextBox.Enabled = enabled;
|
|
SubCategoryPropertyTypeComboBox.Enabled = enabled;
|
|
DeleteSubCategoryButton.Enabled = enabled;
|
|
}
|
|
|
|
private void ToggleCategoryProperty(bool enabled)
|
|
{
|
|
CategoryPropertyNameTextBox.Enabled = enabled;
|
|
CategoryPropertyTypeComboBox.Enabled = enabled;
|
|
}
|
|
|
|
private void CreateCategoryPropertyButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("CreateCategoryProperty", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("PropertyName", CategoryPropertyNameTextBox.Text);
|
|
command.Parameters.AddWithValue("PropertyTypeID", PropertyTypeIds[CategoryPropertyTypeComboBox.Text]);
|
|
command.Parameters.AddWithValue("CategoryID", CategoryIds[CategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
LoadCategoryProperties();
|
|
|
|
CategoryPropertyNameTextBox.Text = string.Empty;
|
|
CategoryPropertyNameTextBox.Focus();
|
|
}
|
|
|
|
private void CreateSubCategoryPropertyButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("CreateSubCategoryProperty", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("PropertyName", SubCategoryPropertyNameTextBox.Text);
|
|
command.Parameters.AddWithValue("PropertyTypeID", PropertyTypeIds[SubCategoryPropertyTypeComboBox.Text]);
|
|
command.Parameters.AddWithValue("SubCategoryID", SubCategoryIds[SubCategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
LoadSubCategoryProperties();
|
|
|
|
SubCategoryPropertyNameTextBox.Text = string.Empty;
|
|
SubCategoryPropertyNameTextBox.Focus();
|
|
}
|
|
|
|
private void CreateNewCategoryButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("CreateCategory", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("PropertyTypeID", PropertyTypeIds[CategoryPropertyTypeComboBox.Text]);
|
|
command.Parameters.AddWithValue("Category", NewCategoryNameTextBox.Text);
|
|
|
|
connection.Open();
|
|
|
|
CategoryIds.Add(NewCategoryNameTextBox.Text, Convert.ToInt32(command.ExecuteScalar()));
|
|
|
|
CategoryComboBoxManager.Items.Add(NewCategoryNameTextBox.Text);
|
|
|
|
NewCategoryNameTextBox.Text = string.Empty;
|
|
NewCategoryNameTextBox.Focus();
|
|
|
|
if (CategoryComboBoxManager.SelectedIndex == -1) CategoryComboBoxManager.SelectedIndex = 0;
|
|
}
|
|
|
|
private void CreateNewSubCategoryButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("CreateSubCategory", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("SubCategory", NewCategoryNameTextBox.Text);
|
|
command.Parameters.AddWithValue("CategoryID", CategoryIds[CategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
SubCategoryIds.Add(NewCategoryNameTextBox.Text, Convert.ToInt32(command.ExecuteScalar()));
|
|
|
|
SubCategoryComboBoxManager.Items.Add(NewCategoryNameTextBox.Text);
|
|
|
|
NewCategoryNameTextBox.Text = string.Empty;
|
|
NewCategoryNameTextBox.Focus();
|
|
|
|
SubCategoryComboBoxManager.Enabled = true;
|
|
|
|
if (SubCategoryComboBoxManager.SelectedIndex == -1) SubCategoryComboBoxManager.SelectedIndex = 0;
|
|
|
|
SubCategoryPropertyNameTextBox.Enabled = true;
|
|
DeleteSubCategoryButton.Enabled = true;
|
|
}
|
|
|
|
private void DeleteCategoryButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("DeleteCategory", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("CategoryID", CategoryIds[CategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
LoadCategories();
|
|
}
|
|
|
|
private void DeleteSubCategoryButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("DeleteSubCategory", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("SubCategoryID", SubCategoryIds[SubCategoryComboBoxManager.Text]);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
SubCategoryIds.Remove(SubCategoryComboBoxManager.Text);
|
|
SubCategoryComboBoxManager.Items.RemoveAt(SubCategoryComboBoxManager.SelectedIndex);
|
|
}
|
|
|
|
private void DeleteCategoryPropertyButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("DeleteCategoryProperty", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("CategoryPropertyID", CategoryPropertyIds[CategoryPropertiesListBox.SelectedItem.ToString()].CategoryPropertyId);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
CategoryPropertyIds.Remove(CategoryPropertiesListBox.SelectedItem.ToString());
|
|
|
|
CategoryPropertiesListBox.Items.RemoveAt(CategoryPropertiesListBox.SelectedIndex);
|
|
}
|
|
|
|
private void DeleteSubCategoryPropertyButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("DeleteSubCategoryProperty", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("SubCategoryPropertyID", SubCategoryPropertyIds[SubCategoryPropertiesListBox.SelectedItem.ToString()].CategoryPropertyId);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
SubCategoryPropertyIds.Remove(SubCategoryPropertiesListBox.SelectedItem.ToString());
|
|
|
|
SubCategoryPropertiesListBox.Items.RemoveAt(SubCategoryPropertiesListBox.SelectedIndex);
|
|
}
|
|
|
|
private struct Property
|
|
{
|
|
public string PropertyName;
|
|
public int PropertyId;
|
|
public int CategoryPropertyId;
|
|
public int PropertyTypeId;
|
|
public string PropertyType;
|
|
}
|
|
|
|
private void CategoryPropertyInfoUpdateButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("UpdateProperty", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("PropertyID", CategoryPropertyIds[CategoryPropertiesListBox.SelectedItem.ToString()].PropertyId);
|
|
command.Parameters.AddWithValue("PropertyName", CategoryPropertyInfoNameTextBox.Text);
|
|
command.Parameters.AddWithValue("PropertyTypeID", PropertyTypeIds[CategoryPropertyInfoTypeComboBox.Text]);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
LoadCategoryProperties();
|
|
|
|
CategoryPropertyInfoNameTextBox.Text = string.Empty;
|
|
}
|
|
|
|
private void SubCategoryPropertyInfoUpdateButton_Click(object sender, EventArgs e)
|
|
{
|
|
using var connection = new SqlConnection(ConnectionString);
|
|
using var command = new SqlCommand("UpdateProperty", connection) { CommandType = CommandType.StoredProcedure };
|
|
command.Parameters.AddWithValue("PropertyID", SubCategoryPropertyIds[SubCategoryPropertiesListBox.SelectedItem.ToString()].PropertyId);
|
|
command.Parameters.AddWithValue("PropertyName", SubCategoryPropertyInfoNameTextBox.Text);
|
|
command.Parameters.AddWithValue("PropertyTypeID", PropertyTypeIds[SubCategoryTypeInfoComboBox.Text]);
|
|
|
|
connection.Open();
|
|
|
|
command.ExecuteNonQuery();
|
|
|
|
LoadSubCategoryProperties();
|
|
|
|
SubCategoryPropertyInfoNameTextBox.Text = string.Empty;
|
|
}
|
|
}
|
|
}
|