namespace SampleCase
{
    using System;
    using System.Data;
    using System.Data.ADO;


    /// 
    ///    Summary description for OrderlineSQL.
    /// 
    public class OrderlineSQL
    {
        public OrderlineSQL()
        {
            //
            // TODO: Add Constructor Logic here
            //
        }

		public string GetInsertSQL()
		{
			string strSQL;

			strSQL = "INSERT INTO Orderline ( ";
        
			strSQL = strSQL + ") VALUES( ";
        
			strSQL = strSQL + ")";

			return strSQL;
		}
		public ADOCommand GetInsertCommand(string strSQL, ref DataRow objRow, ref ADOConnection objConnection)
		{
			ADOCommand objCommand;

			objCommand = new ADOCommand(strSQL, objConnection);
        
			
			return objCommand;
		}
		public string GetUpdateSQL()
		{
			string strSQL;

			strSQL = "UPDATE Orderline SET ";

			strSQL = strSQL + "WHERE (OrderlineID = ?) ";        

			return strSQL;
		}
		public ADOCommand GetUpdateCommand(string strSQL, ref DataRow objRow, ref ADOConnection objConnection)
		{
			ADOCommand objCommand;

			objCommand = new ADOCommand(strSQL, objConnection);

			objCommand.Parameters.Add(new ADOParameter("OrderlineID", ,"OrderlineID"));
			objCommand.Parameters["OrderlineID"].Value = objRow["OrderlineID"];
			
			return objCommand;
		}
		public string GetDeleteSQL()
		{
			string strSQL;

			strSQL = "DELETE FROM Orderline WHERE ";

			strSQL = strSQL + "(OrderlineID = ?) ";        
			
			return strSQL;
		}
		public ADOCommand GetDeleteCommand(string strSQL, ref DataRow objRow, ref ADOConnection objConnection)
		{
			ADOCommand objCommand;

			objCommand = new ADOCommand(strSQL, objConnection);

			objCommand.Parameters.Add(new ADOParameter("OrderlineID", ,"OrderlineID"));        
			objRow.RejectChanges();

			objCommand.Parameters["OrderlineID"].Value = objRow["OrderlineID"];        

			return objCommand;
		}
		public string GetSelectSQL(string strWhere, string strOrder)
		{
			string strSQL;

			strSQL = "SELECT ";

			strSQL = strSQL + "OrderlineID, ";
			strSQL = strSQL + "OrderID, ";
			strSQL = strSQL + "ProductID, ";
			strSQL = strSQL + "Amount, ";
			strSQL = strSQL + "Price ";        
			strSQL = strSQL + "FROM Orderline ";
			strSQL = strSQL + strWhere + " ";
			strSQL = strSQL + strOrder + " ";
			
			return strSQL;
		}
		public string GetSelectSQL(string strWhere)
		{
			return GetSelectSQL(strWhere, "");
		}
		public string GetSelectSQL()
		{
			return GetSelectSQL("", "");
		}
		public ADODataSetCommand GetSelectCommand(string strSQL, ref ADOConnection objConnection)
		{
			ADODataSetCommand objDataSetCommand;

			objDataSetCommand = new ADODataSetCommand(strSQL, objConnection);
			objDataSetCommand.TableMappings.Add("Table","Orderline");
   		
			return objDataSetCommand;
		}

    }
}