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

namespace Клиент_оперативный_отчет
{
    public partial class Form1 : Form
    {
        string log1;
        string pas1;
        public Form1()
        {
            InitializeComponent();
            FillComboCOK();
         }

        public void FillComboCOK()
        {
            string connstring1 = @"Data Source";
            SqlConnection sqlconn1 = new SqlConnection(connstring1);
            SqlCommand sqlcomm1 = new SqlCommand("ACCESS", sqlconn1);
            sqlcomm1.CommandType = System.Data.CommandType.StoredProcedure;
            try
            {
                sqlconn1.Open();
                SqlDataAdapter sqladap1 = new SqlDataAdapter(sqlcomm1);
                System.Data.DataTable dt1 = new System.Data.DataTable();
                sqladap1.Fill(dt1);
                comboBox1.ValueMember = "id_office";
                comboBox1.DisplayMember = "login";
                comboBox1.DataSource = dt1;


                sqladap1.Update(dt1);
                sqlconn1.Close();
            }
            catch (Exception ex) { };
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            log1 = comboBox1.SelectedValue.ToString();
            try
            {

                if (log1 ==    )
                {
                    Form1.ActiveForm.Visible = false;
                    Form2.ActiveForm.Visible = true;
                }   Close();
            }
            catch (Exception ex) { };

        }
    }
}

  protected void CheckSnils()
        {
            string connstring1 = @"Data Source";
            bool pass, name;

            SqlConnection conn = new SqlConnection(connstring1);
            string queryPass = "Select password FROM where password='" + textBox1.Text + "'";
            string queryName = "Select id_office FROMwhere id_office='" + log1 + "'";

            using (SqlDataAdapter dataAdapter = new SqlDataAdapter(queryPass, conn))
            {
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                dataAdapter.Fill(table);
                if (table.Rows.Count > 0)
                {
                    pass = true;
                }
                else
                {                    
                    return;
                }
            }
            using (SqlDataAdapter dataAdapter2 = new SqlDataAdapter(queryName, conn))
            {
                DataTable table2 = new DataTable();
                table2.Locale = System.Globalization.CultureInfo.InvariantCulture;

                dataAdapter2.Fill(table2);
                if (table2.Rows.Count > 0)
                {
                    name = true;
                }
                else
                {
                    return;
                }
            }

            if (pass == true && name == true)
            {
                Form2 f = new Form2();
                f.Show();
                this.Hide();
            }