MARKUS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Navigation;

using System.Windows.Shapes;

namespace WpfDataBaseTest

{

    /// <summary>

    /// MainWindow.xaml에 대한 상호 작용 논리

    /// </summary>

    public partial class MainWindow : Window

    {

        public MainWindow()

        {

            InitializeComponent();

        }

        /// <summary>

        /// markus 모델을 참조하여 개발한 dll을 호출한다.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void DataCall_Click(object sender, RoutedEventArgs e)

        {

            try

            {

                try

                {

                    var connectstr = "data source=cloud.devdoftech.co.kr,7777;initial catalog=Markus;persist security info=True;user id=doftech;Password=dof1073#;MultipleActiveResultSets=True;";

                    var entities = new Markus.EntityModel.MarkusModel(connectstr);

                }

                catch (Exception ex)

                {

                    System.Diagnostics.Debug.WriteLine(ex.ToString());

                    throw ex;

                }

                datagrid.ItemsSource = null;

                using (DatabseModelCRUDSampleDLL.TestDataBase db = new DatabseModelCRUDSampleDLL.TestDataBase(txtConnStr.Text))

                {

                    datagrid.ItemsSource = db.GetConvertDoc(10);

                    txtLog.Text = "Ok";

                }

            }

            catch (Exception ex)

            {

                txtLog.Text = ex.ToString();

            }

        }

        /// <summary>

        /// 직접 Markus 모델을 참조하여 호출 한다.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void ModelCall_Click(object sender, RoutedEventArgs e)

        {

            try

            {

                datagrid.ItemsSource = null;

                using (Markus.EntityModel.MarkusModel model = new Markus.EntityModel.MarkusModel(txtConnStr.Text))

                {

                    datagrid.ItemsSource = model.CONVERTER_DOC.Take(10).ToList();

                }

            }

            catch (Exception ex)

            {

                txtLog.Text = ex.ToString();

                txtLog.Text = "Ok";

            }

        }

        private void Clear_Click(object sender, RoutedEventArgs e)

        {

            datagrid.ItemsSource = null;

        }

    }

}