kreta/Kreta.DataAccessManual/KirStatDAL.cs

using System.Data;
using Kreta.DataAccessManual.Interfaces;
using Kreta.DataAccessManual.Util;
using Kreta.Framework;
using Kreta.Framework.Util;
using SDA.DataProvider;

namespace Kreta.DataAccessManual
{
    internal class KirStatDAL : DataAccessBase, IKirStatDAL
    {
        public KirStatDAL(DalHandler handler, GridParameters parameters) : base(handler, parameters)
        {
        }

        public DataSet GetKirStatAdatok(string taroltEljarasNeve, int tanevId, int intezmenyId)
        {
            DataSet ds = new DataSet();

            using (SDACommand command = new SDACommand())
            {
                command.Connection = UserContext.Instance.SDAConnection;
                command.Transaction = UserContext.Instance.SDATransaction;
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("tanevID", tanevId);
                command.Parameters.Add("intezmenyID", intezmenyId);

                command.CommandText = taroltEljarasNeve;
                using (var adapter = new SDADataAdapter())
                {
                    adapter.SelectCommand = command;
                    adapter.Fill(ds);
                }
                DataTable dt = SortingAndPaging(ds.Tables[0], GridParameters);

                return dt.AsDataSet();
            }
        }

        public DataSet GetStoredProcedures(string spNeve)
        {
            using (SDACommand command = new SDACommand())
            {
                command.Connection = UserContext.Instance.SDAConnection;
                command.Transaction = UserContext.Instance.SDATransaction;
                command.CommandType = CommandType.Text;

                command.CommandText = @"SELECT ROUTINE_NAME
                      FROM INFORMATION_SCHEMA.ROUTINES
                      where ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_NAME like";

                var param = "'%KIRSTAT_" + spNeve + "%'";
                command.CommandText += param;

                var ds = this.GetData(command.CommandText);
                return ds;
            }
        }
    }
}