private void Update_Rule() { Business_Rules.Update_RulesName(Rule_information.Id, Txt_RuleName.Text); var textBox = Business_Rules.Search_Rule_Information_Text_Boxs(Rule_information.Id); Business_Rules.Update_Rule_Information_Text_Boxs(textBox.Id, Txt_Statement.Text, Txt_Constraint.Text, Txt_Field_Names.Text, Txt_Table_Names.Text, Txt_Action_Taken.Text); var logical_elements = Business_Rules.Search_Logical_Elements(Rule_information.Id); Business_Rules.Update_Logical_Elements(checkBox_Key_Type.Checked, checkBox_Key_Structure.Checked, checkBox_Uniqueness.Checked, checkBox_NullSupport.Checked, checkBox_Values_Entered_By.Checked, checkBox_Required_Value.Checked, checkBox_Default_Value.Checked, checkBox_Ranges_Values.Checked, checkBox_Comparisons_Allowed.Checked, checkBox_Operations_Allowed.Checked, checkBox_Edit_Rule.Checked, logical_elements.Id); var physical_elements = Business_Rules.Search_Physical_Elements(Rule_information.Id); Business_Rules.Update_Physical_Elements(checkBox_Data_Type.Checked, checkBox_Length.Checked, checkBox_Decimal_Places.Checked, checkBox_Character_Support.Checked, checkBox_Input_Mask.Checked, checkBox_Display_Format.Checked, physical_elements.Id); var relationship_characteristics_affected = Business_Rules.Search_Relationship_Characteristics_Affected(Rule_information.Id); Business_Rules.Update_Relationship_Characteristics_Affected(checkBox_Deletion_Rule.Checked, checkBox_Type_Participation.Checked, checkBox_Degree_Participation.Checked, relationship_characteristics_affected.Id); var type = Business_Rules.Search_Type(Rule_information.Id); Business_Rules.Update_Type(checkBox_Database_Oriented.Checked, checkBox_Application_Oriented.Checked, type.Id); var categories = Business_Rules.Search_Categories(type.Id); Business_Rules.Update_Categories(checkBox_Field_Specific.Checked, checkBox_Relationship_Specific.Checked, categories.Id); var test_on = Business_Rules.Search_Test_On(type.Id); Business_Rules.Update_Test_On(checkBox_Insert.Checked, checkBox_Update.Checked, checkBox_Delete.Checked, test_on.Id); }
private void Btn_Save_Rule_Click(object sender, EventArgs e) { var business_rule = Business_Rules.Create_Rule(Txt_RuleName.Text, Model_information.Id); if (business_rule.Equals(true)) { if (Txt_RuleName.Text != null) { var idRuleName = Business_Rules.Search_Rule(Txt_RuleName.Text); Business_Rules.Create_Rule_Information(Txt_Statement.Text, Txt_Constraint.Text, Txt_Field_Names.Text, Txt_Table_Names.Text, Txt_Action_Taken.Text, idRuleName.Id); Business_Rules.Create_logical_elements(checkBox_Key_Type.Checked, checkBox_Key_Structure.Checked, checkBox_Uniqueness.Checked, checkBox_NullSupport.Checked, checkBox_Values_Entered_By.Checked, checkBox_Required_Value.Checked, checkBox_Default_Value.Checked, checkBox_Ranges_Values.Checked, checkBox_Comparisons_Allowed.Checked, checkBox_Operations_Allowed.Checked, checkBox_Edit_Rule.Checked, idRuleName.Id); Business_Rules.Create_relationship_characteristics_affected(checkBox_Deletion_Rule.Checked, checkBox_Type_Participation.Checked, checkBox_Degree_Participation.Checked, idRuleName.Id); Business_Rules.Create_physical_elements(checkBox_Data_Type.Checked, checkBox_Length.Checked, checkBox_Decimal_Places.Checked, checkBox_Character_Support.Checked, checkBox_Input_Mask.Checked, checkBox_Display_Format.Checked, idRuleName.Id); Business_Rules.Create_type(checkBox_Database_Oriented.Checked, checkBox_Application_Oriented.Checked, idRuleName.Id); var idType = Business_Rules.Search_Type(idRuleName.Id); Business_Rules.Create_categories(checkBox_Field_Specific.Checked, checkBox_Relationship_Specific.Checked, idType.Id); Business_Rules.Create_test_on(checkBox_Insert.Checked, checkBox_Update.Checked, checkBox_Delete.Checked, idType.Id); MessageBox.Show("The business rule was created."); Form_profil form_Profil = new Form_profil(); this.Hide(); form_Profil.Show(); } else { MessageBox.Show("The business rule was not created without the name of the rule."); } } else { MessageBox.Show("The business rule was not created."); } }
private void Type() { var type = Business_Rules.Search_Type(Rule_information.Id); checkBox_Database_Oriented.Checked = Convert.ToBoolean(type.data_base_oriented); checkBox_Application_Oriented.Checked = Convert.ToBoolean(type.application_oriented); var categories = Business_Rules.Search_Categories(type.Id); checkBox_Field_Specific.Checked = Convert.ToBoolean(categories.Field_specfic); checkBox_Relationship_Specific.Checked = Convert.ToBoolean(categories.Relationship_specific); var test_on = Business_Rules.Search_Test_On(type.Id); checkBox_Insert.Checked = Convert.ToBoolean(test_on.Inserts); checkBox_Update.Checked = Convert.ToBoolean(test_on.Updates); checkBox_Delete.Checked = Convert.ToBoolean(test_on.Deletes); }