private void btnAddCategory_Click(object sender, EventArgs e)
{
try {
workingCompCategory = FillCategoryFromUiForAdd();
} catch (Exception ex) {
FrontendUtils.ShowError(ex.Message, ex);
}
}
private void btnSaveCategory_Click(object sender, EventArgs e)
{
try {
workingCompCategory = FillCategoryFromUiForSave();
} catch (Exception ex) {
CommonUtils.ShowError(ex.Message, ex);
}
}
public static void UpdatedCategoryById(ComparisonCategory comparisonCategory)
{
SqlCeConnection conn = BackEndUtils.GetSqlConnection();
try {
conn.Open();
SqlCeCommand command = new SqlCeCommand(Env_Comparison_Categories_SQL.commandUpdateEnvComparisonCategoryById, conn);
command.Parameters.Add("@name", comparisonCategory.categoryName);
command.Parameters.Add("@description", comparisonCategory.categoryDescription);
command.Parameters.Add("@path", comparisonCategory.categoryPath);
command.Parameters.Add("@parentId", comparisonCategory.categoryParentId);
command.Parameters.Add("@id", comparisonCategory.categoryId);
command.ExecuteNonQuery();
} finally {
conn.Close();
}
}
public static int InserNewCategory(ComparisonCategory comparisonCategory, SqlCeTransaction transaction, SqlCeConnection conn)
{
SqlCeCommand command = new SqlCeCommand(Env_Comparison_Categories_SQL.commandInsertNewEnvComparisonCategory, conn);
command.Transaction = transaction;
command.Parameters.Add("@id", comparisonCategory.categoryId);
command.Parameters.Add("@name", comparisonCategory.categoryName);
command.Parameters.Add("@description", comparisonCategory.categoryDescription);
command.Parameters.Add("@path", comparisonCategory.categoryPath);
if (comparisonCategory.categoryParentId == -1) {
//DBNull.Value
command.Parameters.Add("@parentId", DBNull.Value);
} else {
command.Parameters.Add("@parentId", comparisonCategory.categoryParentId);
}
int numberAffectedRows = Convert.ToInt32(command.ExecuteNonQuery());
return numberAffectedRows;
}
private ComparisonCategory FillCategoryFromUiForSave()
{
ComparisonCategory comparisonCategory = new ComparisonCategory(workingCompCategory.categoryId,
txtCategoryName.Text,
txtCategoryDesc.Text,
txtCategoryPath.Text,
workingCompCategory.categoryParentId);
return comparisonCategory;
}
private ComparisonCategory FillCategoryFromUiForAdd()
{
ComparisonCategory comparisonCategory = new ComparisonCategory(txtCategoryName.Text, txtCategoryDesc.Text, txtCategoryPath.Text);
return comparisonCategory;
}
public EnvComparisonCategoryForm(ComparisonCategory comparisonCategory)
{
InitializeComponent();
workingCompCategory = comparisonCategory;
btnAddCategory.Enabled = false;
}
