07# C# Entity framework

도구 - 확장 및 업데이트에서 Entity framework를 검색 한 후, 다운로드 받고 새로 edmx를 추가한다.

데이터베이스에 있는 테이블과 구조를 똑같이 설정 만든 클래스를 호출해주면 된다.

private void SetGameStart()
{
    try
    {
        if (GetGameStartValidation() == true)
        {
            //경기 기본 데이터베이스 입력
            EntityObject obj = new EntityObject();
            ControlUtil.Game.Set_GameEntry gameEntry = new ControlUtil.Game.Set_GameEntry();
 
            obj.paramTable["GAMEDATE"] = dateTimeGame.Value;
            obj.paramTable["HOME_ENTRY"] = arrAllPosition[Convert.ToInt32(((TextValue)cboAllTeam.Items[0]).Value)];
            obj.paramTable["AWAY_ENTRY"] = arrAllPosition[Convert.ToInt32(((TextValue)cboAllTeam.Items[1]).Value)];
            obj.paramTable["HOME_INDEX"] = ((TextValue)cboAllTeam.Items[0]).Value;
            obj.paramTable["AWAY_INDEX"] = ((TextValue)cboAllTeam.Items[1]).Value;
       
            gameEntry.SetEntityObject(obj);                    
            obj = gameEntry.Entity;
 
            if (obj.success != true)
            {
                Lib.ShowBox.ShowOK.ShowDialog(Lib.ShowBox.ShowType.MessageType.Emergency, "경기 라인업 입력 도중 오류가 발생했습니다.");
            }
        }
    }
    catch (Exception ex)
    {
        ExceptionLog.Log(ex);
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using BaselBall.Interface;
using Lib;
using System.Collections;
 
namespace BaselBall.View.Game
{
    public partial class GameEntry : UserControl, IView
    {
        private Button[] btnPosition;
        private Label[] lblPosition;
        private Color controlColor;
 
        private Dictionary<int, ListViewItem> arrHomePosition = new Dictionary<int, ListViewItem>();
        private Dictionary<int, ListViewItem> arrAwayPosition = new Dictionary<int, ListViewItem>();
        private Dictionary<int, Dictionary<int, ListViewItem>> arrAllPosition = new Dictionary<int, Dictionary<int, ListViewItem>>();
 
        public GameEntry()
        {
            InitializeComponent();
 
            SetInit();
        }
 
        #region 초기화
 
        private void SetInit()
        {
            try
            {
                controlColor = btn9.BackColor;
                SetPositionInfomation();
                SetTeamGroup();
                SetTeamList();
                SetSelectTeamPlayer();
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetPositionInfomation()
        {
            try
            {
                const int positionCount = 10;
                btnPosition = new Button[positionCount];
                lblPosition = new Label[positionCount];
 
                for (int i = 0; i < positionCount; i++)
                {
                    string btnKey = string.Format("btn{0}", i + 1);
                    string lblKey = string.Format("lbl{0}", i + 1);
 
                    btnPosition[i] = (Button)this.Controls.Find(btnKey, true)[0];
                    lblPosition[i] = (Label)this.Controls.Find(lblKey, true)[0];
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetTeamGroup()
        {
            try
            {
                List<TextValue> arrGroup = new List<TextValue>();
 
                arrGroup.Add(new TextValue("전체", "전체"));
                arrGroup.Add(new TextValue("초/중등부", "초/중등부"));
                arrGroup.Add(new TextValue("고등부", "고등부"));
                arrGroup.Add(new TextValue("대학팀", "대학팀"));
 
                ControlSource.GetComboData(cboTeam_Group, arrGroup);
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        #endregion
 
        #region 이벤트
 
        private void cboTeam_Group_SelectionChangeCommitted(object sender, EventArgs e)
        {
            SetTeamGroupChange();
        }
 
        private void cboTeam_SelectionChangeCommitted(object sender, EventArgs e)
        {
            SetHomeAwayTeamList(GetSelectTeamIndex(sender));
        }
 
        private void cboAllTeam_SelectionChangeCommitted(object sender, EventArgs e)
        {
            SetSelectTeamPlayer();
            SetAllPositionPlayer();
        }
 
        private void btnPosition_Click(object sender, EventArgs e)
        {
            SetPositionRemove(sender, e);
        }
 
        private void listAllPlayer_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            SetAllPositionInsert(e);
        }
 
        private void listHitter_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            SetHitOrder(e);
        }
 
        private void btnGameStart_Click(object sender, EventArgs e)
        {
            SetGameStart();
        }
 
        #endregion
 
        #region Get Method
 
        private int GetSelectTeamIndex(object sender)
        {
            int index = 0;
 
            try
            {
                ComboBox cbo = (ComboBox)sender;
 
                if (cbo.Name.IndexOf("Away") > -1)
                {
                    index = 1;
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
 
            return index;
        }
 
        private int GetLastBatOrder()
        {
            int number = 1;
 
            try
            {
                SortedList<int, int> list = new SortedList<int, int>();
 
                foreach (ListViewItem lvItem in listHitter.Items)
                {
                    if (lvItem.SubItems["ORDER"].Text.Length > 0)
                    {
                        int lastOrder = Convert.ToInt32(lvItem.SubItems["ORDER"].Text);
                        list.Add(lastOrder, lastOrder);
                    }
                }
 
                if (list.Count > 0)
                {
                    foreach (int lastNumber in list.Keys)
                    {
                        if (number == lastNumber)
                        {
                            number = number + 1;
                        }
                        else
                        {
                            number = lastNumber - 1;
                            break;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
 
            return number;
        }
 
        private int GetFieldPosition()
        {
            int position = 1;
 
            try
            {
                for (int i = 0; i < btnPosition.Length; i++)
                {
                    if (btnPosition[i].BackColor == controlColor)
                    {
                        position = i + 1;
                        break;
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
 
            return position;
        }
 
        private bool GetGameStartValidation()
        {
            bool validation = true;
 
            try
            {
                string message = "";
                TextValue tvHome = (TextValue)cboAllTeam.Items[0];
                TextValue tvAway = (TextValue)cboAllTeam.Items[1];
 
                if (arrAllPosition.ContainsKey(Convert.ToInt32(tvAway.Value)) == true && arrAllPosition.ContainsKey(Convert.ToInt32(tvAway.Value)) == true)
                {
                    Dictionary<int, ListViewItem> arrHomePosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(tvHome.Value)]);
                    Dictionary<int, ListViewItem> arrAwayPosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(tvAway.Value)]);
 
                    if (10 > arrHomePosition.Count)
                    {
                        message = string.Format("홈 팀의 선수가 {0} 명 입니다. {1}", arrHomePosition.Count, Environment.NewLine);
                    }
 
                    foreach (int key in arrHomePosition.Keys)
                    {
                        ListViewItem item = arrHomePosition[key];
 
                        if (key > 1 && item.SubItems["ORDER"].Text.Length == 0)
                        {
                            message = string.Format("{0}홈 팀의 타격순서가 정해지지 않았습니다. {1}", message, Environment.NewLine);
                            break;
                        }
                    }
 
                    if (10 > arrAwayPosition.Count)
                    {
                        message = string.Format("{0}원정 팀의 선수가 {1} 명 입니다. {2}", message, arrAwayPosition.Count, Environment.NewLine);
                    }
 
                    foreach (int key in arrAwayPosition.Keys)
                    {
                        ListViewItem item = arrAwayPosition[key];
 
                        if (key > 1 && item.SubItems["ORDER"].Text.Length == 0)
                        {
                            message = string.Format("{0}원정 팀의 타격순서가 정해지지 않았습니다. {1}", message, Environment.NewLine);
                            break;
                        }
                    }
 
                    if (message.Length > 0)
                    {
                        Lib.ShowBox.ShowOK.ShowDialog(Lib.ShowBox.ShowType.MessageType.Warning, message);
                        validation = false;
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
 
            return validation;
        }
 
        #endregion
 
        #region Set Method
 
        private void SetTeamGroupChange()
        {
            try
            {
                SetTeamList();
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetTeamList()
        {
            try
            {
                string teamType = ((TextValue)cboTeam_Group.SelectedItem).Value.ToString();
 
                teamType = string.Format("TEAM_GROUP = '{0}'", teamType);
 
                if (teamType.IndexOf("전체") > -1)
                {
                    teamType = "";
                }
 
                Reference.userManager.GetTeamList(cboHome, teamType);
                Reference.userManager.GetTeamList(cboAway, teamType);
 
                const int teamIndex = 0;
 
                SetHomeAwayTeamList(teamIndex);
 
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetHomeAwayTeamList(int index)
        {
            try
            {
                cboAllTeam.DataSource = null;
 
                string home = string.Format("홈 : {0}", ((DataRowView)cboHome.SelectedItem).Row["NAME"]);
                string away = string.Format("어웨이 : {0}", ((DataRowView)cboAway.SelectedItem).Row["NAME"]);
 
                TextValue tvHome = new TextValue(home, cboHome.SelectedValue.ToString());
                TextValue tvAway = new TextValue(away, cboAway.SelectedValue.ToString());
 
                ControlSource.GetComboData(cboAllTeam, new List<TextValue>() { tvHome, tvAway });
                cboAllTeam.SelectedIndex = index;
                cboAllTeam_SelectionChangeCommitted(cboAllTeam, EventArgs.Empty);
            }
            catch (Exception ex)
            {
                 ExceptionLog.Log(ex);
            }
        }
 
        private void SetSelectTeamPlayer()
        {
            try
            {
                TextValue selectTeam = (TextValue)cboAllTeam.SelectedItem;
 
                listAllPlayer.Items.Clear();
 
                List<object> arrParams = new List<object>();
                arrParams.Add(Reference.userInfomation.GetInstance().company);
                arrParams.Add(cboAllTeam.SelectedValue);
                DataTable table = SQLConnection.GetExcuteDataTable(ProcedureName.S_PLAYER_INFOMATION, arrParams, Convert.ToInt32(SQLConnection.TableIndex.Zero), "SetPlayerInfomation");
 
                arrHomePosition.Clear();
                arrAwayPosition.Clear();
                Dictionary<int, ListViewItem> arrPosition = new Dictionary<int, ListViewItem>();
 
                if(arrAllPosition.ContainsKey(Convert.ToInt32(selectTeam.Value)) == true)
                {
                    if (cboAllTeam.Text.IndexOf("홈") > -1)
                    {
                        arrHomePosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(selectTeam.Value)]);
                        arrPosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(selectTeam.Value)]);
                    }
                    else
                    {
                        arrAwayPosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(selectTeam.Value)]);
                        arrPosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(selectTeam.Value)]);
                    }
                }
 
                string[] column = { "NAME", "POSITION", "NUMBER"};
 
                foreach (DataRow row in table.Rows)
                {
                    ListViewItem item = new ListViewItem(row["CODE"].ToString());
 
                    //이미 있는 선수는 제외한다.
                    if (arrPosition.Values.FirstOrDefault(o => o.Text.Contains(item.Text)) == null)
                    {
                        foreach (string key in column)
                        {
                            ListViewItem.ListViewSubItem subItem = new ListViewItem.ListViewSubItem(item, row[key].ToString());
                            subItem.Name = key;
 
                            item.SubItems.Add(subItem);
                        }
 
                        listAllPlayer.Items.Add(item);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetAllPositionPlayer()
        {
            try
            {
                Dictionary<int, ListViewItem> arrPosition = new Dictionary<int, ListViewItem>();
 
                if (arrAllPosition.ContainsKey(Convert.ToInt32(cboAllTeam.SelectedValue)) == true)
                {
                    arrPosition = ConvertManager.GetDictionaryCopy(arrAllPosition[Convert.ToInt32(cboAllTeam.SelectedValue)]);
                }
 
                SetAllPositionUpdate(arrPosition);
                SetHitOrderUpdate(arrPosition);
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        //기존에 작업된 것이 존재할 시 복원 시켜주고, 리스트에서 삭제해야 한다.
        private void SetAllPositionUpdate(Dictionary<int, ListViewItem> arrPosition)
        {
            try
            {
                //그라운드
                string[] arrText = { "투수", "포수", "1루수", "2루수", "3루수", "유격수", "좌익수", "중견수", "우익수", "지명타자"};
 
                for (int i = 0; i < arrText.Length; i++)
                {
                    lblPosition[i].Text = arrText[i];
                    btnPosition[i].BackColor = controlColor;
                }
 
                foreach (int key in arrPosition.Keys)
                {
                    ListViewItem item = arrPosition[key];
 
                    btnPosition[key - 1].BackColor = Color.LightYellow;
                    lblPosition[key - 1].Text = item.SubItems["NAME"].Text;
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        //더블 클릭 시 리스트 이동
        private void SetAllPositionInsert(MouseEventArgs e)
        {
            try
            {
                ListViewItem item = listAllPlayer.GetItemAt(e.X, e.Y);//listAllPlayer.GetItemAt(listAllPlayer.SelectedIndices[0], 1);
 
                if (item != null)
                {
                    int playerCode = Convert.ToInt32(item.Text);
                    int position = GetFieldPosition();
 
                    //그라운드에 해당 포지션으로 추가
                    lblPosition[position - 1].Text = item.SubItems["NAME"].Text;
                    btnPosition[position - 1].BackColor = Color.LightYellow;
 
                    //라인업에 투수가 아닐 경우 추가
                    SetHitterList(item, position, btnPosition[position - 1].Text);
 
                    //전부 추가 후, 리스트에서 삭제 한다.
                    listAllPlayer.Items.Remove(item);
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetHitterList(ListViewItem item, int position, string positionName)
        {
            try
            {
                //listHitter
                string playerCode = item.Text;
                string name = item.SubItems["NAME"].Text;
                string number = item.SubItems["NUMBER"].Text;
 
                string[] key = { "ORDER", "NAME", "POSITION", "NUMBER" };
                string[] value = { "", name, positionName, number };
 
                ListViewItem playeritem = new ListViewItem(playerCode);
 
                for (int i = 0; i < key.Length; i++)
                {
                    ListViewItem.ListViewSubItem subItem = new ListViewItem.ListViewSubItem(playeritem, value[i]);
                    subItem.Name = key[i];
 
                    playeritem.SubItems.Add(subItem);
                }
                
                const int pitcherPosition = 1;
 
                if (position > pitcherPosition)
                {
                    listHitter.Items.Insert(position - 2, playeritem);
                }
                else
                {
                    lblPitcher.Text = item.SubItems["NAME"].Text;
                }
 
                SetDictinaryItem(playeritem, position);
            }
            catch (Exception ex)
            {
                 ExceptionLog.Log(ex);
            }
        }
 
        private void SetDictinaryItem(ListViewItem item, int position)
        {
            try
            {
                if (cboAllTeam.Text.IndexOf("홈") > -1)
                {
                    arrHomePosition[position] = item;
                    arrAllPosition[Convert.ToInt32(cboAllTeam.SelectedValue)] = ConvertManager.GetDictionaryCopy(arrHomePosition);
                }
                else
                {
                    arrAwayPosition[position] = item;
                    arrAllPosition[Convert.ToInt32(cboAllTeam.SelectedValue)] = ConvertManager.GetDictionaryCopy(arrAwayPosition);
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetHitOrder(MouseEventArgs e)
        {
            try
            {
                ListViewItem item = listHitter.GetItemAt(e.X, e.Y);
 
                if (item != null)
                {
                    if (e.Button == System.Windows.Forms.MouseButtons.Left)
                    {
                        SetHitOrderAdd(item);
                    }
                    else if (e.Button == System.Windows.Forms.MouseButtons.Right)
                    {
                        SetHitOrderRemove(item);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetHitOrderAdd(ListViewItem item)
        {
            try
            {
                if (item.SubItems["ORDER"].Text.Length == 0)
                {
                    Dictionary<string, string> arrHitOrder = new Dictionary<string, string>();
 
                    //Input 번호
                    int number = GetLastBatOrder();
 
                    item.SubItems["ORDER"].Text = number.ToString();
                    arrHitOrder[item.SubItems["NAME"].Text] = number.ToString();
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetHitOrderRemove(ListViewItem item)
        {
            try
            {
                item.SubItems["ORDER"].Text = "";
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetHitOrderUpdate(Dictionary<int, ListViewItem> arrPosition)
        {
            try
            {
                listHitter.Items.Clear();
 
                foreach (ListViewItem item in arrPosition.Values)
                {
                    if (item.SubItems["POSITION"].Text != "투수")
                    {
                        listHitter.Items.Add(item);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetPositionRemove(object sender, EventArgs e)
        {
            try
            {
                Button btn = (Button)sender;
 
                int position = Convert.ToInt32(btn.Name.Replace("btn", ""));
      
                //리스트에서 삭제
                if (cboAllTeam.Text.IndexOf("홈") > -1)
                {
                    arrHomePosition.Remove(position);
                    arrAllPosition[Convert.ToInt32(cboAllTeam.SelectedValue)] = ConvertManager.GetDictionaryCopy(arrHomePosition);
                }
                else
                {
                    arrAwayPosition.Remove(position);
                    arrAllPosition[Convert.ToInt32(cboAllTeam.SelectedValue)] = ConvertManager.GetDictionaryCopy(arrAwayPosition);
                }
 
                SetAllPositionPlayer();
                SetSelectTeamPlayer();
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        private void SetGameStart()
        {
            try
            {
                if (GetGameStartValidation() == true)
                {
                    //경기 기본 데이터베이스 입력
                    EntityObject obj = new EntityObject();
                    ControlUtil.Game.Set_GameEntry gameEntry = new ControlUtil.Game.Set_GameEntry();
 
                    obj.paramTable["GAMEDATE"] = dateTimeGame.Value;
                    obj.paramTable["HOME_ENTRY"] = arrAllPosition[Convert.ToInt32(((TextValue)cboAllTeam.Items[0]).Value)];
                    obj.paramTable["AWAY_ENTRY"] = arrAllPosition[Convert.ToInt32(((TextValue)cboAllTeam.Items[1]).Value)];
                    obj.paramTable["HOME_INDEX"] = ((TextValue)cboAllTeam.Items[0]).Value;
                    obj.paramTable["AWAY_INDEX"] = ((TextValue)cboAllTeam.Items[1]).Value;
       
                    gameEntry.SetEntityObject(obj);
                    obj = gameEntry.Entity;
 
                    if (obj.success != true)
                    {
                        Lib.ShowBox.ShowOK.ShowDialog(Lib.ShowBox.ShowType.MessageType.Emergency, "경기 라인업 입력 도중 오류가 발생했습니다.");
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.Log(ex);
            }
        }
 
        #endregion
 
       
 
    }
}
 
 
 

2년 전쯤 만들어봤던 것 같은데, 조금 아쉬운감이 있다. 

새로이 클래스를 정의해서 했지만.. 안에서 무언가 실행할 때 부모 클래스나 인터페이스로 했으면 더 좋았을 것 같은 느낌이 있다.