using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;

namespace Agroteh
{
    public partial class EmplForm : Form
    {
        string strConn;
        SqlConnection cn;
        SqlDataAdapter da;
        public DataSet ds;
        BindingSource bsDetail;
        BindingSource bsMasterProfession;
        BindingSource bsMasterUnit;
        BindingSource bsMasterRank;

        public EmplForm(string str)
        {
            InitializeComponent();
            this.strConn = str;
        }

        private void exit_btn_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void EmplForm_Load(object sender, EventArgs e)
        {
            cn = new SqlConnection(strConn);
            da = new SqlDataAdapter("select * from profession; select * from unit; select * from [rank]; select * from employees", cn);
            da.TableMappings.Add("Table", "Profession");
            da.TableMappings.Add("Table1", "Unit");
            da.TableMappings.Add("Table2", "Rank");
            DataTableMapping dtm = da.TableMappings.Add("Table3", "Employees");
            dtm.ColumnMappings.Add("id", "№");
            dtm.ColumnMappings.Add("fio","ФИО");
            dtm.ColumnMappings.Add("datein", "Дата_пр");
            dtm.ColumnMappings.Add("dateout", "Дата_ув");
            dtm.ColumnMappings.Add("bithday", "Рождение");
            dtm.ColumnMappings.Add("prof_id", "Проффесия");
            dtm.ColumnMappings.Add("unit_id", "Отдел");
            dtm.ColumnMappings.Add("rank_id", "Разряд");
            dtm.ColumnMappings.Add("ijd", "Иждевенцы");
            dtm.ColumnMappings.Add("salary", "Оклад");
            dtm.ColumnMappings.Add("ways_pay", "Способ");
            ds = new DataSet();
            da.Fill(ds);
            // DataRelation dr = new DataRelation("ProfessionEmployees", ds.Tables["Employees"].Columns["Проффесия"], ds.Tables["Profession"].Columns["id"], false);
            // ds.Relations.Add(dr);
            // dr = new DataRelation("UnitEmployees", ds.Tables["Employees"].Columns["Отдел"], ds.Tables["Unit"].Columns["id"], false);
            // ds.Relations.Add(dr);
            // dr = new DataRelation("RankEmployees", ds.Tables["Employees"].Columns["Разряд"], ds.Tables["Rank"].Columns["id"], false);
            // ds.Relations.Add(dr);
            bsDetail = new BindingSource(ds, "Employees");
            // bsMasterProfession = new BindingSource(bsDetail, "ProfessionEmployees");
            // bsMasterUnit = new BindingSource(bsDetail, "UnitEmployees");
            // bsMasterRank = new BindingSource(bsDetail, "RankEmployees");
            DataColumn[] keys = new DataColumn[1];
            keys[0] = ds.Tables["Profession"].Columns["id"];
            ds.Tables["Profession"].PrimaryKey = keys;
            dataGridView1.VirtualMode = true;
            dataGridView1.DataSource = bsDetail;
            for (int i = 10; i > 1; i--)
                dataGridView1.Columns.RemoveAt(i);
            dataGridView1.Columns[0].Width = 40;
            dataGridView1.Columns[1].Width = 100;
            DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
            column.Name = "pro";
            column.HeaderText = "Проффесия";
            dataGridView1.Columns.Add(column);
            dataGridView1.CellValueNeeded +=new DataGridViewCellValueEventHandler(dataGridView1_CellValueNeeded);
            dataGridView1.CellValuePushed+=new DataGridViewCellValueEventHandler(dataGridView1_CellValuePushed);
        }

        private void dataGridView1_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
        {
            if (dataGridView1.Columns[e.ColumnIndex].Name == "pro")
            {
                DataRow dr_temp = dataGridView1.Rows[e.RowIndex].DataBoundItem as DataRow;
                [color=red]DataRow dr_detail = ds.Tables["Profession"].Rows.Find(dr_temp["Проффесия"].ToString());[/color]
                e.Value = dr_detail["name"].ToString();
            }
        }

        private void dataGridView1_CellValuePushed(object sender, DataGridViewCellValueEventArgs e)
        {
            dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = e.Value;
        }
    }
}