Example #1
0
        protected void WriteValidationCodeDetailsGrid()
        {
            bool validationsEnabled = ValidationsEnabled;

            if (!validationsEnabled)
            {
                return;
            }
            List <ColumnValidation> validationColumns = GetValidationColumns();

            Writer.PushIdentationLevel();
            Writer.IncreaseIdentation();
            Writer.IncreaseIdentation();

            Writer.WriteLine("private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)");
            Writer.WriteLine("{");

            Writer.WriteLine("string s;");
            Writer.WriteLine("DataGridViewRow row = dataGridView1.Rows[e.RowIndex];");
            Writer.WriteLine("object value = e.FormattedValue;");
            Writer.WriteLine("e.Cancel = false;");
            Writer.WriteLine("row.ErrorText = \"\";");
            Writer.WriteLine("if (row.IsNewRow) return;");
            for (int i = 0; i < validationColumns.Count; i++)
            {
                ColumnValidation cv = validationColumns[i];
                if (cv.IsBooleanType() || cv.HasLookup)
                {
                    continue;
                }
                string idColumnCanonical = GetCanonicalIdentifier(cv.Column.ColumnName);

                Writer.WriteLine("if (e.ColumnIndex == {0})", i);
                Writer.WriteLine("{");

                string numericType = "";
                if (cv.IsNumericType())
                {
                    if (cv.IsIntegerType())
                    {
                        numericType = "int";
                    }
                    if (cv.IsFloatingPointType())
                    {
                        numericType = "double";
                    }
                    Writer.WriteLine("{0} v;", numericType);
                }

                if (cv.Required)
                {
                    Writer.WriteLine("if( (value is DBNull) || string.IsNullOrEmpty( value.ToString() ) )");
                    Writer.WriteLine("{");
                    Writer.WriteLine("e.Cancel = true;");
                    Writer.WriteLine("row.ErrorText = \"The field {0} is required\";", cv.Name);
                    Writer.WriteLine("return;");
                    Writer.WriteLine("}");
                }
                if (cv.IsNumericType())
                {
                    Writer.WriteLine("s = value.ToString();");
                    if (!string.IsNullOrEmpty(numericType))
                    {
                        Writer.WriteLine("if( !{0}.TryParse( s, out v ) )", numericType);
                        Writer.WriteLine("{");
                    }
                    else
                    {
                        // just assume is good
                        Writer.WriteLine("if( true )");
                        Writer.WriteLine("{");
                    }
                    Writer.WriteLine("e.Cancel = true;");
                    Writer.WriteLine("row.ErrorText = \"The field {0} must be {1}.\";", cv.Name, numericType);
                    Writer.WriteLine("return;");
                    Writer.WriteLine("}");
                    if (cv.MinValue != null)
                    {
                        Writer.WriteLine("else if( {0} > v )", cv.MinValue);
                        Writer.WriteLine("{");
                        Writer.WriteLine("e.Cancel = true;");
                        Writer.WriteLine("row.ErrorText = \"The field {0} must be greater or equal than {1}.\";", cv.Name, cv.MinValue);
                        Writer.WriteLine("return;");
                        Writer.WriteLine("} ");
                    }
                    if (cv.MaxValue != null)
                    {
                        Writer.WriteLine("else if( {0} < v )", cv.MaxValue);
                        Writer.WriteLine("{");
                        Writer.WriteLine("e.Cancel = true;");
                        Writer.WriteLine("row.ErrorText = \"The field {0} must be lesser or equal than {1}\";", cv.Name, cv.MaxValue);
                        Writer.WriteLine("return;");
                        Writer.WriteLine("} ");
                    }
                }

                Writer.WriteLine("}");
            }
            Writer.WriteLine("}");

            // DataError event
            Writer.WriteLine("");
            Writer.WriteLine("private void dataGridView1_DataError(object sender, DataGridViewDataErrorEventArgs e)");
            Writer.WriteLine("{");
            Writer.WriteLine("dataGridView1.Rows[e.RowIndex].ErrorText = e.Exception.Message;");
            Writer.WriteLine("e.Cancel = true;");
            Writer.WriteLine("}");

            Writer.PopIdentationLevel();
        }
        protected void WriteValidationCodeDetailsGrid()
        {
            bool validationsEnabled = ValidationsEnabled;

            if (!validationsEnabled)
            {
                return;
            }
            List <ColumnValidation> validationColumns = GetValidationColumns();

            Writer.PushIdentationLevel();
            Writer.IncreaseIdentation();
            Writer.IncreaseIdentation();

            Writer.WriteLine("Private Sub dataGridView1_CellValidating(sender As Object, e As DataGridViewCellValidatingEventArgs)");
            Writer.WriteLine("");

            Writer.WriteLine("Dim s As String");
            Writer.WriteLine("Dim row As DataGridViewRow= dataGridView1.Rows(e.RowIndex)");
            Writer.WriteLine("Dim value As Object = e.FormattedValue");
            Writer.WriteLine("e.Cancel = False");
            Writer.WriteLine("row.ErrorText = \"\"");
            Writer.WriteLine("If row.IsNewRow Then");
            Writer.WriteLine("Return");
            Writer.WriteLine("End If");
            for (int i = 0; i < validationColumns.Count; i++)
            {
                ColumnValidation cv = validationColumns[i];
                if (cv.IsBooleanType() || cv.HasLookup)
                {
                    continue;
                }
                string idColumnCanonical = GetCanonicalIdentifier(cv.Column.ColumnName);

                Writer.WriteLine("If e.ColumnIndex = {0} Then", i);
                Writer.WriteLine("");

                string numericType = "";
                if (cv.IsNumericType())
                {
                    if (cv.IsIntegerType())
                    {
                        numericType = "Integer";
                    }
                    if (cv.IsFloatingPointType())
                    {
                        numericType = "Double";
                    }
                    Writer.WriteLine("Dim v as {0}", numericType);
                }

                if (cv.Required)
                {
                    Writer.WriteLine("If (TypeOf value is DBNull) OrElse String.IsNullOrEmpty( value.ToString() ) Then ");
                    Writer.WriteLine("e.Cancel = True");
                    Writer.WriteLine("row.ErrorText = \"The field {0} is required\"", cv.Name);
                    Writer.WriteLine("Return");
                    Writer.WriteLine("End If");
                }
                if (cv.IsNumericType())
                {
                    Writer.WriteLine("s = value.ToString()");
                    if (!string.IsNullOrEmpty(numericType))
                    {
                        Writer.WriteLine("If Not {0}.TryParse( s, v ) Then", numericType);
                    }
                    else
                    {
                        // just assume is good
                        Writer.WriteLine("If True Then");
                    }
                    Writer.WriteLine("e.Cancel = True");
                    Writer.WriteLine("row.ErrorText = \"The field {0} must be {1}.\"", cv.Name, numericType);
                    Writer.WriteLine("Return");
                    if (cv.MinValue != null)
                    {
                        Writer.WriteLine("ElseIf {0} > v Then", cv.MinValue);
                        Writer.WriteLine("e.Cancel = True");
                        Writer.WriteLine("row.ErrorText = \"The field {0} must be greater or equal than {1}.\"", cv.Name, cv.MinValue);
                        Writer.WriteLine("Return");
                    }
                    if (cv.MaxValue != null)
                    {
                        Writer.WriteLine("ElseIf {0} < v Then", cv.MaxValue);
                        Writer.WriteLine("e.Cancel = True");
                        Writer.WriteLine("row.ErrorText = \"The field {0} must be lesser or equal than {1}\"", cv.Name, cv.MaxValue);
                        Writer.WriteLine("Return");
                    }
                    Writer.WriteLine("End If");
                }

                Writer.WriteLine("End If");
            }
            Writer.WriteLine("End Sub");
            // DataError
            Writer.WriteLine("Private Sub dataGridView1_DataError(ByVal sender As Object, ByVal e As DataGridViewDataErrorEventArgs)");
            Writer.WriteLine("dataGridView1.Rows(e.RowIndex).ErrorText = e.Exception.Message");
            Writer.WriteLine("e.Cancel = true");
            Writer.WriteLine("End Sub");

            Writer.PopIdentationLevel();
        }
Example #3
0
        protected override void WriteValidationCode()
        {
            bool validationsEnabled = ValidationsEnabled;
            List <ColumnValidation> validationColumns = ValidationColumns;

            Writer.PushIdentationLevel();
            Writer.IncreaseIdentation();
            Writer.IncreaseIdentation();

            if (validationsEnabled)
            {
                for (int i = 0; i < validationColumns.Count; i++)
                {
                    ColumnValidation cv = validationColumns[i];
                    if (cv.IsDateType() || cv.IsReadOnly() || cv.IsBooleanType())
                    {
                        continue;
                    }

                    string idColumnCanonical = GetCanonicalIdentifier(cv.Column.ColumnName);

                    if (cv.HasLookup && cv.Required)
                    {
                        Writer.WriteLine("private void {0}_comboBox_Validating(object sender, CancelEventArgs e)", idColumnCanonical);
                        Writer.WriteLine("{");
                        Writer.WriteLine("int i = {0}_comboBox.SelectedIndex;", idColumnCanonical);
                        Writer.WriteLine("e.Cancel = false;");
                        Writer.WriteLine("if( i == -1 )");
                        Writer.WriteLine("{");
                        Writer.WriteLine("e.Cancel = true; ");
                        Writer.WriteLine("errorProvider1.SetError({0}_comboBox, \"Must select a {0}\");", idColumnCanonical);
                        Writer.WriteLine("}");
                        Writer.WriteLine("if( !e.Cancel )");
                        Writer.WriteLine("{");
                        Writer.WriteLine("errorProvider1.SetError({0}_comboBox, \"\");", idColumnCanonical);
                        Writer.WriteLine("}");
                        Writer.WriteLine("}");
                        continue;
                    }

                    Writer.WriteLine("private void {0}TextBox_Validating(object sender, CancelEventArgs e)", idColumnCanonical);
                    Writer.WriteLine("{");
                    Writer.WriteLine("e.Cancel = false;");
                    if (cv.Required)
                    {
                        Writer.WriteLine("if( string.IsNullOrEmpty( {0}TextBox.Text ) )", idColumnCanonical);
                        Writer.WriteLine("{");
                        Writer.WriteLine("e.Cancel = true;");
                        Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} is required\" ); ", idColumnCanonical, cv.Name);
                        Writer.WriteLine("}");
                    }
                    if (cv.IsNumericType())
                    {
                        string numericType = "";
                        if (cv.IsIntegerType())
                        {
                            numericType = "int";
                        }
                        else if (cv.IsFloatingPointType())
                        {
                            numericType = "double";
                        }
                        Writer.WriteLine("{0} v;", numericType);
                        Writer.WriteLine("string s = {0}TextBox.Text;", idColumnCanonical);
                        if (!string.IsNullOrEmpty(numericType))
                        {
                            Writer.WriteLine("if( !{0}.TryParse( s, out v ) )", numericType);
                            Writer.WriteLine("{");
                        }
                        else
                        {
                            // just assume is good
                            Writer.WriteLine("if( true )");
                            Writer.WriteLine("{");
                        }
                        Writer.WriteLine("e.Cancel = true;");
                        Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} must be {2}.\" );", idColumnCanonical, cv.Name, numericType);
                        Writer.WriteLine("}");
                        if (cv.MinValue != null)
                        {
                            Writer.WriteLine("else if( {0} > v )", cv.MinValue);
                            Writer.WriteLine("{");
                            Writer.WriteLine("e.Cancel = true;");
                            Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} must be greater or equal than {2}.\" );", idColumnCanonical, cv.Name, cv.MinValue);
                            Writer.WriteLine("}");
                        }
                        if (cv.MaxValue != null)
                        {
                            Writer.WriteLine("else if( {0} < v )", cv.MaxValue);
                            Writer.WriteLine("{");
                            Writer.WriteLine("e.Cancel = true;");
                            Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} must be lesser or equal than {2}\" );", idColumnCanonical, cv.Name, cv.MaxValue);
                            Writer.WriteLine("} ");
                        }
                    }
                    Writer.WriteLine("if( !e.Cancel ) {{ errorProvider1.SetError( {0}TextBox, \"\" ); }} ", idColumnCanonical);
                    Writer.WriteLine("}");
                    Writer.WriteLine();
                }
            }
            Writer.PopIdentationLevel();
        }
        protected override void WriteValidationCode()
        {
            bool validationsEnabled = ValidationsEnabled;
            List <ColumnValidation> validationColumns = ValidationColumns;

            Writer.PushIdentationLevel();
            Writer.IncreaseIdentation();
            Writer.IncreaseIdentation();

            if (validationsEnabled)
            {
                for (int i = 0; i < validationColumns.Count; i++)
                {
                    ColumnValidation cv = validationColumns[i];
                    if (cv.IsDateType() || cv.IsReadOnly() || cv.IsBooleanType())
                    {
                        continue;
                    }

                    string idColumnCanonical = GetCanonicalIdentifier(cv.Column.ColumnName);

                    if (cv.HasLookup && cv.Required)
                    {
                        Writer.WriteLine("Private Sub {0}_comboBox_Validating(sender As System.Object, e As System.ComponentModel.CancelEventArgs)", idColumnCanonical);
                        Writer.WriteLine("Dim i As Integer = {0}_comboBox.SelectedIndex", idColumnCanonical);
                        Writer.WriteLine("e.Cancel = False");
                        Writer.WriteLine("If i = -1 Then");
                        Writer.WriteLine("e.Cancel = True");
                        Writer.WriteLine("errorProvider1.SetError({0}_comboBox, \"Must select a {0}\")", idColumnCanonical);
                        Writer.WriteLine("End If");
                        Writer.WriteLine("If Not e.Cancel Then");
                        Writer.WriteLine("errorProvider1.SetError({0}_comboBox, \"\")", idColumnCanonical);
                        Writer.WriteLine("End If");
                        Writer.WriteLine("End Sub");
                        continue;
                    }

                    Writer.WriteLine("Private Sub {0}TextBox_Validating(sender As Object, e As CancelEventArgs)", idColumnCanonical);
                    Writer.WriteLine("");
                    Writer.WriteLine("e.Cancel = False");
                    if (cv.Required)
                    {
                        Writer.WriteLine("If String.IsNullOrEmpty( {0}TextBox.Text ) Then ", idColumnCanonical);
                        Writer.WriteLine("e.Cancel = True");
                        Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} is required\" ) ", idColumnCanonical, cv.Name);
                        Writer.WriteLine("End If");
                    }
                    if (cv.IsNumericType())
                    {
                        string numericType = "";
                        if (cv.IsIntegerType())
                        {
                            numericType = "Integer";
                        }
                        else if (cv.IsFloatingPointType())
                        {
                            numericType = "Double";
                        }
                        Writer.WriteLine("Dim v As {0}", numericType);
                        Writer.WriteLine("Dim s As string = {0}TextBox.Text", idColumnCanonical);
                        if (!string.IsNullOrEmpty(numericType))
                        {
                            Writer.WriteLine("If Not {0}.TryParse( s, v ) Then", numericType);
                        }
                        else
                        {
                            // just assume is good
                            Writer.WriteLine("If True Then");
                        }
                        Writer.WriteLine("e.Cancel = True");
                        Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} must be {2}.\" )", idColumnCanonical, cv.Name, numericType);
                        if (cv.MinValue != null)
                        {
                            Writer.WriteLine("ElseIf {0} > v Then ", cv.MinValue);
                            Writer.WriteLine("e.Cancel = True");
                            Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} must be greater or equal than {2}.\" )", idColumnCanonical, cv.Name, cv.MinValue);
                        }
                        if (cv.MaxValue != null)
                        {
                            Writer.WriteLine("ElseIf {0} < v Then ", cv.MaxValue);
                            Writer.WriteLine("e.Cancel = True");
                            Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"The field {1} must be lesser or equal than {2}\" )", idColumnCanonical, cv.Name, cv.MaxValue);
                        }
                        Writer.WriteLine("End If");
                    }
                    Writer.WriteLine("If Not e.Cancel Then");
                    Writer.WriteLine("errorProvider1.SetError( {0}TextBox, \"\" )", idColumnCanonical);
                    Writer.WriteLine("End If");
                    Writer.WriteLine("End Sub");
                    Writer.WriteLine();
                }
            }
            Writer.PopIdentationLevel();
        }