<commit_before>﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using PenjualanHewanTernak.Model;
using System.Data;

namespace PenjualanHewanTernak.DataAccess
{
    class PosMutasiStokListDAO
    {
        #region Constructor
        public PosMutasiStokListDAO()
        {

        }
        #endregion

        #region Method
        internal void ShowList(PosMutasiStokList list)
        {
            string sql = "SELECT [noRef], " +
                        "[isPemasukan], " +
                        "[Keterangan], " +
                        "[Stat] " +                       
                        "FROM [Systernakdb].[dbo].[POS_MUTASI_STOK]";

            DataSet dataSet = DataProvider.GetDataSet(sql);

            //Create variable for dataset table
            DataTable itemTabel = dataSet.Tables[0];

            PosMutasiStokItem nextItem = null;

            foreach (DataRow parentRow in itemTabel.Rows)
            {
                nextItem = new PosMutasiStokItem();
                nextItem.NoRef = parentRow["NoRef"].ToString();
                nextItem.IsPemasukan = Convert.ToBoolean(parentRow["IsPemasukan"]);
                nextItem.Keterangan = parentRow["Keterangan"].ToString();
                nextItem.Stat = Convert.ToBoolean(parentRow["Stat"]);

                list.Add(nextItem);
            }
            dataSet.Dispose();
        }
    }
        #endregion
    }
}<commit_msg>Some dirty code<commit_after>﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using PenjualanHewanTernak.Model;
using System.Data;

namespace PenjualanHewanTernak.DataAccess
{
    class PosMutasiStokListDAO
    {
        #region Constructor
        public PosMutasiStokListDAO()
        {

        }
        #endregion

        #region Method
        internal void ShowList(PosMutasiStokList list)
        {
            string sql = "SELECT [noRef], " +
                        "[isPemasukan], " +
                        "[Keterangan], " +
                        "[Stat] " +                       
                        "FROM [Systernakdb].[dbo].[POS_MUTASI_STOK]";

            DataSet dataSet = DataProvider.GetDataSet(sql);

            //Create variable for dataset table
            DataTable itemTabel = dataSet.Tables[0];

            PosMutasiStokItem nextItem = null;

            foreach (DataRow parentRow in itemTabel.Rows)
            {
                nextItem = new PosMutasiStokItem();
                nextItem.NoRef = parentRow["NoRef"].ToString();
                nextItem.IsPemasukan = Convert.ToBoolean(parentRow["IsPemasukan"]);
                nextItem.Keterangan = parentRow["Keterangan"].ToString();
                nextItem.Stat = Convert.ToBoolean(parentRow["Stat"]);

                list.Add(nextItem);
            }
            dataSet.Dispose();
        }
    }
        #endregion
}

{'fraction_non_alphanumeric': 0.0958627648839556, 'fraction_numerical': 0.0006727211570803902, 'mean_word_length': 1.701180744777475, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1219681', 'n_tokens_mistral': 863, 'n_tokens_neox': 825, 'n_words': 144}