/// <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> /// 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); }
/// <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; }