private CodeMemberMethod BuildPocoUpdate(TableViewTableTypeBase table)
{
CodeMemberMethod cmUpdate = new CodeMemberMethod();
cmUpdate.Attributes = MemberAttributes.Public;
cmUpdate.Name = "Update";
CodeParameterDeclarationExpression cpPocoPar = new CodeParameterDeclarationExpression();
cpPocoPar.Name = "query";
cpPocoPar.Type = new CodeTypeReference(table.Name);
cmUpdate.Parameters.Add(cpPocoPar);
String cp_name = "cp_" + table.Name;
cmUpdate.Statements.Add(new CodeSnippetExpression("this.Access.CreateProcedureCommand(\"ProcedureName\")".Replace("ProcedureName", cp_name)));
cmUpdate.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"Operation\", 4, ParameterDirection.Input)"));
CodeStatementCollection AttributeValidationStatements = GraphAttributeSet.BuildAttributeSetStatement(table);
foreach (CodeStatement AttributeValidationStatment in AttributeValidationStatements)
{
cmUpdate.Statements.Add(AttributeValidationStatment);
}
cmUpdate.Statements.Add(new CodeSnippetExpression("int value = this.Access.ExecuteNonQuery()"));
cmUpdate.Statements.Add(new CodeSnippetExpression("return value"));
cmUpdate.ReturnType = new CodeTypeReference("System.Int32");
cmUpdate.Comments.Add(new CodeCommentStatement("Updates a Record"));
return(cmUpdate);
}
private CodeMemberMethod BuildPocoInsert(TableViewTableTypeBase table)
{
CodeMemberMethod cmInsert = new CodeMemberMethod();
cmInsert.Name = "Insert";
String cp_name = "cp_" + table.Name;
cmInsert.Attributes = MemberAttributes.Public;
cmInsert.ReturnType = new CodeTypeReference("System.Int32");
cmInsert.Parameters.Add(this.PocoQueryParameter(table.Name));
cmInsert.Statements.Add(new CodeSnippetExpression("this.Access.CreateProcedureCommand(\"ProcedureName\")".Replace("ProcedureName", cp_name)));
cmInsert.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"Operation\", 5, ParameterDirection.Input)"));
CodeStatementCollection AttributeValidationStatmenets = GraphAttributeSet.BuildAttributeSetStatement(table);
foreach (CodeStatement AttributeValidationStatmenet in AttributeValidationStatmenets)
{
cmInsert.Statements.Add(AttributeValidationStatmenet);
}
cmInsert.Statements.Add(new CodeSnippetExpression("return this.Access.ExecuteNonQuery()"));
cmInsert.Comments.Add(new CodeCommentStatement("Inserts a record"));
return(cmInsert);
}
public CodeMemberMethod BuildIsDirtyMethod(TableViewTableTypeBase baseobj)
{
CodeMemberMethod cmd = new CodeMemberMethod();
cmd.Name = "IsDirty";
cmd.Attributes = MemberAttributes.Public;
cmd.ReturnType = new CodeTypeReference("System.Boolean");
CodeStatementCollection cssDirtyCode = GraphAttributeSet.BuildValidationSetStatement(baseobj);
foreach (CodeStatement cs in GraphAttributeSet.BuildValidationSetStatement(baseobj))
{
cmd.Statements.Add(cs);
}
return(cmd);
}
