1 files changed, 39 insertions, 0 deletions
diff --git a/src/app/Cmpp298.Assignment3.DataAccess/InsertQueryBuilder.cs b/src/app/Cmpp298.Assignment3.DataAccess/InsertQueryBuilder.cs
new file mode 100644
index 0000000..bbb3d9c
--- /dev/null
+++ b/src/app/Cmpp298.Assignment3.DataAccess/InsertQueryBuilder.cs
@@ -0,0 +1,39 @@
+using System.Collections.Generic;
+using System.Text;
+
+namespace Cmpp298.Assignment3.DataAccess {
+	public class InsertQueryBuilder {
+		private readonly string _tableName;
+		private IList< CommandParameter > _parameters;
+
+		public InsertQueryBuilder( string tableName ) {
+			_tableName = tableName;
+			_parameters = new List< CommandParameter >( );
+		}
+
+		public IList< CommandParameter > Parameters {
+			get { return _parameters; }
+		}
+
+		public void Add( DatabaseColumn column, string value ) {
+			_parameters.Add( new CommandParameter( column.ColumnName, value ) );
+		}
+
+		public override string ToString( ) {
+			StringBuilder builder = new StringBuilder( );
+			builder.AppendFormat( "INSERT INTO {0} ({1}) VALUES ({2});SELECT @@IDENTITY;", _tableName,
+			                      GetParameterNames( string.Empty ),
+			                      GetParameterNames( "@" ) );
+			return builder.ToString( );
+		}
+
+		private string GetParameterNames( string prefix ) {
+			StringBuilder builder = new StringBuilder( );
+			foreach ( CommandParameter parameter in _parameters ) {
+				builder.AppendFormat( "{0}{1},", prefix, parameter.ColumnName );
+			}
+			builder.Remove( builder.Length - 1, 1 );
+			return builder.ToString( );
+		}
+	}
+}
+\ No newline at end of file