namespace SampleCase
{
    using System;
    using System.Collections;
    using System.Configuration;
    using System.ComponentModel;
    using System.Data;
    using System.Data.ADO;
    using System.Diagnostics;
    using System.Web;
    using System.Web.Services;

    /// 
    ///    Summary description for Orderline.
    /// 
    public class Orderline : System.Web.Services.WebService
    {
		private OrderlineSQL objOrderlineSQL;
		private ADOConnection objConnection;
		
		public Orderline()
		{
            //CODEGEN: This call is required by the ASP+ Web Services Designer
            InitializeComponent();
			objOrderlineSQL = new OrderlineSQL();
			objConnection = new ADOConnection ();
			// Refactor-->
			objConnection.ConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Persist Security Info=False;Initial Catalog=UVNET;Data Source=C003W2K";
        }

        /// 
        ///    Required method for Designer support - do not modify
        ///    the contents of this method with the code editor.
        /// 
        private void InitializeComponent()
        {
        }

        /// 
        ///    Clean up any resources being used.
        /// 
        public override void Dispose()
        {
        }

		[WebMethod]
        public DataSet Open()
        {
			return this.Select();
        }

		[WebMethod]
        public void Save(DataSet dsOrderline)
        {
			// Update all new, deleted and modified rows in objData
			foreach (DataRow objRow in dsOrderline.Tables[0].Rows)
			{
				switch (objRow.RowState)
				{
					case DataRowState.Modified:
						this.Update(objRow);
						break;
					case DataRowState.Deleted:
						this.Delete(objRow);
						break;
					case DataRowState.New:
						this.Insert(objRow);
						break;
					default:
						break;
				}
			}
			return;
        }
		private DataSet Select()
		{
			ADODataSetCommand objDataSetCommand;
			DataSet objDataSet;
			String strSQL;

			strSQL = objOrderlineSQL.GetSelectSQL();
			objDataSetCommand = objOrderlineSQL.GetSelectCommand(strSQL, ref objConnection);
			
			objDataSet = new DataSet();
			objConnection.Open();
			objDataSet.EnforceConstraints = false;
			objDataSetCommand.FillDataSet(objDataSet);
			objDataSet.EnforceConstraints = true;
			objConnection.Close();
			return objDataSet;
		}
		private void Insert (System.Data.DataRow objRow)
		{
			ADOCommand objCommand;
			string strSQL;

			strSQL = objOrderlineSQL.GetInsertSQL();
			objCommand = objOrderlineSQL.GetInsertCommand(strSQL, ref objRow, ref objConnection);
			
			objCommand.ActiveConnection.Open();
			objCommand.ExecuteNonQuery();
			objConnection.Close();

			return;
		}
		private void Update (System.Data.DataRow objRow)
		{
			ADOCommand objCommand;
			string strSQL;

			strSQL = objOrderlineSQL.GetUpdateSQL();
			objCommand = objOrderlineSQL.GetUpdateCommand(strSQL, ref objRow, ref objConnection);
			
			objConnection.Open();
			objCommand.ExecuteNonQuery();
			objConnection.Close();

			return;
		}
		private void Delete (System.Data.DataRow objRow)
		{
			ADOCommand objCommand;
			string strSQL;

			strSQL = objOrderlineSQL.GetDeleteSQL();
			objCommand = objOrderlineSQL.GetDeleteCommand(strSQL, ref objRow, ref objConnection);
			
			objCommand.ActiveConnection.Open();
			objCommand.ExecuteNonQuery();
			objConnection.Close();

			return;
		}
    }
}