using HRM.BO;
using Ease.Core.DataAccess;
using System;
using System.Data;
using System.Data.SqlClient;


namespace HRM.DA
{
    #region SystemParameterSetupDA

    internal class SystemParameterSetupDA
    {
        #region Constructor

        private SystemParameterSetupDA()
        {
        }

        #endregion

        #region Insert function

        internal static void Insert(TransactionContext tc, SystemParameterSetup item)
        {
            tc.ExecuteNonQuery(
                "Insert into SystemParameterSetup (BADLOGINATTEMPT,SYSTEMIDEALTIME,BADLOGINATTEMPTID) Values (%n,%n,%n) ",
                item.BadloginAttempt, item.SystemIdealTime, item.ID);
        }

        internal static void Update(TransactionContext tc, SystemParameterSetup item)
        {
            tc.ExecuteNonQuery("UPDATE SystemParameterSetup SET BADLOGINATTEMPT=%n, SYSTEMIDEALTIME=%n " +
                               " WHERE BADLOGINATTEMPTID=%n", item.BadloginAttempt, item.SystemIdealTime, item.ID);
        }

        #endregion

        #region Get Function

        internal static IDataReader Get(TransactionContext tc)
        {
            return tc.ExecuteReader("SELECT * FROM SystemParameterSetup");
        }

        #endregion
    }

    #endregion
}