EHSDataCompliance Framework

#region DotNet Namespaces
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
#endregion

#region Custom Namespaces
using BEs.Engin;
using EHS.CommonDataHelpers.Interfaces;
using EHS.DatabaseHelpers.SqlDatabaseHelper.DataHelpers;
using EHS.CommonDataHelpers.Enums;
using EHS.CommonDataHelpers.DataHelper.Data;
using EHS.CommonDataHelpers.DataHelper.DataHelpers;
using BEs.Enums;
#endregion

namespace DLSql.EnginDAL
{
    public class EnginDAL : IDataAccessLayer<Engin, Engins>
    {
        #region Implemented Methods

        public TransactionStatus Delete(Engin dataObject)
        {
            throw new NotImplementedException();
        }

        public TransactionStatusWithData<Engins> GetAll()
        {
            DataRecord objDataRecord = new DataRecord();
            objDataRecord.TableName = "Engin";

            Engins objEngins = new Engins();

            return StoredProcedures.SelectAll<Engins>(objDataRecord, objEngins);
        }

        public TransactionStatusWithData<Engin> GetById(Engin dataObject)
        {
            StoredProcedure<Engin> Sp_InsertEngin = new StoredProcedure<Engin>();

            Sp_InsertEngin.ProcedureName = "Sp_GetEnginByID";
            Sp_InsertEngin.DataObject = dataObject;
            Sp_InsertEngin.SqlConnectionInfo.ConnectionType = (int)BEs.Enums.ConnectionType.NormalLogin;
            return Sp_InsertEngin.ExecuteReader();
        }

        public TransactionStatus Insert(Engin dataObject)
        {
            StoredProcedure<Engin> Sp_InsertEngin = new StoredProcedure<Engin>();

            Sp_InsertEngin.ProcedureName = "Sp_InsertEngin";
            Sp_InsertEngin.DataObject = dataObject;
            Sp_InsertEngin.SqlConnectionInfo.ConnectionType = (int)BEs.Enums.ConnectionType.NormalLogin;
            return Sp_InsertEngin.ExecuteNonQuery();
        }

        public TransactionStatus Update(Engin dataObject)
        {
            throw new NotImplementedException();
        }

        #endregion

        #region GetColumn

        public Engins GetColumn()
        {
            DataRecord objDataRecord = new DataRecord();

            objDataRecord.TableName = "Engin";
            objDataRecord.FieldName = "Description";

            Engins objEngins = new Engins();
            StoredProcedures.SelectAllFromField<Engins>(objDataRecord, objEngins);

            return objEngins;
        }

        #endregion
    }
}