/// <summary>
/// Delete Query Method
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private CodeMemberMethod BuildDelete(TableViewTableTypeBase table)
{
CodeMemberMethod cmDelete = new CodeMemberMethod();
cmDelete.Attributes = MemberAttributes.Public;
cmDelete.Name = "Delete";
String cp_name = "cp_" + table.Name;
cmDelete.ReturnType = new CodeTypeReference("System.Int32");
cmDelete.Statements.Add(new CodeSnippetExpression("this.Access.CreateProcedureCommand(\"ProcedureName\")".Replace("ProcedureName", cp_name)));
cmDelete.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"Operation\", 6, ParameterDirection.Input)"));
foreach (Column c in table.Columns)
{
if (c.InPrimaryKey)
{
MemberGraph mGraph = new MemberGraph(c);
cmDelete.Parameters.Add(mGraph.GetParameter());
cmDelete.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"" + mGraph.PropertyName() + "\", " + mGraph.ParameterName() + ", ParameterDirection.Input)"));
}
}
cmDelete.Statements.Add(new CodeSnippetExpression("var value = this.Access.ExecuteNonQuery()"));
cmDelete.Statements.Add(new CodeSnippetExpression("return value"));
cmDelete.Comments.Add(new CodeCommentStatement("Delete's a record"));
return(cmDelete);
}
/// <summary>
/// Select One Query Method
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private CodeMemberMethod BuildSelect(TableViewTableTypeBase table)
{
CodeMemberMethod cmSelect = new CodeMemberMethod();
String cp_name = "cp_" + table.Name;
cmSelect.Attributes = MemberAttributes.Public;
cmSelect.Name = "Select";
cmSelect.Statements.Add(new CodeSnippetExpression("this.Access.CreateProcedureCommand(\"ProcedureName\")".Replace("ProcedureName", cp_name)));
cmSelect.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"Operation\", 1, ParameterDirection.Input)"));
cmSelect.Comments.Add(new CodeCommentStatement("Selects One By Primary Key, returns a Data Set"));
foreach (Column c in table.Columns)
{
if (c.InPrimaryKey)
{
MemberGraph mGraph = new MemberGraph(c);
cmSelect.Parameters.Add(mGraph.GetParameter());
cmSelect.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"" + mGraph.Name + "\", " + mGraph.ParameterName() + ", ParameterDirection.Input)"));
}
}
cmSelect.Statements.Add(new CodeSnippetExpression("var value = this.Access.ExecuteDataSet()"));
cmSelect.Statements.Add(new CodeSnippetExpression("return value"));
cmSelect.ReturnType = new CodeTypeReference("System.Data.DataSet");
return(cmSelect);
}
/// <summary>
/// Insert Query Method
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private CodeMemberMethod BuildInsert(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");
foreach (Column c in table.Columns)
{
MemberGraph mGraph = new MemberGraph(c);
if (mGraph.IsReadOnly)
{
// nothing yet
}
else
{
cmInsert.Parameters.Add(mGraph.GetParameter());
}
}
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)"));
foreach (Column c in table.Columns)
{
MemberGraph mGraph = new MemberGraph(c);
if (mGraph.IsReadOnly)
{
// nothing yet
}
else
{
cmInsert.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"" + mGraph.PropertyName() + "\", " + mGraph.ParameterName() + " , ParameterDirection.Input)"));
}
}
cmInsert.Statements.Add(new CodeSnippetExpression("return this.Access.ExecuteNonQuery()"));
cmInsert.Comments.Add(new CodeCommentStatement("Inserts a record"));
return(cmInsert);
}
/// <summary>
/// Update Query Method
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private CodeMemberMethod BuildUpdate(TableViewTableTypeBase table)
{
CodeMemberMethod cmUpdate = new CodeMemberMethod();
cmUpdate.Attributes = MemberAttributes.Public;
cmUpdate.Name = "Update";
String cp_name = "cp_" + table.Name;
foreach (Column c in table.Columns)
{
MemberGraph mGraph = new MemberGraph(c);
if (mGraph.IsReadOnly)
{
// nothing yet
}
else
{
cmUpdate.Parameters.Add(mGraph.GetParameter());
}
}
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)"));
foreach (Column c in table.Columns)
{
MemberGraph mGraph = new MemberGraph(c);
if (mGraph.IsReadOnly)
{
// nothing yet
}
else
{
cmUpdate.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"" + mGraph.PropertyName() + "\", " + mGraph.ParameterName() + ", ParameterDirection.Input)"));
}
}
cmUpdate.Statements.Add(new CodeSnippetExpression("var 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;
}
/// <summary>
/// Select One Query Method
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private CodeMemberMethod BuildSelect(TableViewTableTypeBase table)
{
CodeMemberMethod cmSelect = new CodeMemberMethod();
String cp_name = "cp_" + table.Name;
cmSelect.Attributes = MemberAttributes.Public;
cmSelect.Name = "Select";
cmSelect.Statements.Add(new CodeSnippetExpression("this.Access.CreateProcedureCommand(\"ProcedureName\")".Replace("ProcedureName",cp_name)));
cmSelect.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"Operation\", 1, ParameterDirection.Input)"));
cmSelect.Comments.Add(new CodeCommentStatement("Selects One By Primary Key, returns a Data Set"));
foreach (Column c in table.Columns)
{
if (c.InPrimaryKey)
{
MemberGraph mGraph = new MemberGraph(c);
cmSelect.Parameters.Add(mGraph.GetParameter());
cmSelect.Statements.Add(new CodeSnippetExpression("this.Access.AddParameter(\"" + mGraph.Name + "\", " + mGraph.ParameterName() + ", ParameterDirection.Input)"));
}
}
cmSelect.Statements.Add(new CodeSnippetExpression("var value = this.Access.ExecuteDataSet()"));
cmSelect.Statements.Add(new CodeSnippetExpression("return value"));
cmSelect.ReturnType = new CodeTypeReference("System.Data.DataSet");
return cmSelect;
}
