7.Код - Angelok325/kredit GitHub Wiki

    Point lastPoin;
    private void login_MouseMove(object sender, MouseEventArgs e)
    {
        if (e.Button == MouseButtons.Left)
        {
            this.Left += e.X - lastPoin.X;
            this.Top += e.Y - lastPoin.Y;
        }
    }

    private void login_MouseDown(object sender, MouseEventArgs e)
    {
        lastPoin = new Point(e.X, e.Y);
    }

    private void registrlabel_Click(object sender, EventArgs e)
    {
        this.Hide();
        registr registrForm = new registr();
        registrForm.Show();
    }

    private void enter_button_Click(object sender, EventArgs e)
    {
        try
        {
            string login = loginfeald.Text;
            string Password = passfield.Text;
          
                int UserID = AuthenticateUser(login, Password);
                if (UserID != -1)
                {

                Form2 userCabinet = new Form2();
                  FormSwitcher.SwitchMainForm(this, userCabinet);

                }
                else
                {
                    MessageBox.Show("Неверное имя пользователя или пароль.");
                }
            
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }

    }

    private int AuthenticateUser(string FIO, string Password)
    {

        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            connection.Open();
            using (OleDbCommand command = new OleDbCommand("SELECT UserID FROM Users WHERE [FIO] = @FIO AND [Password] = @Password", connection))
            {
                command.Parameters.Add("@FIO", OleDbType.VarChar).Value = FIO;
                command.Parameters.Add("@Password", OleDbType.VarChar).Value = Password;
                object result = command.ExecuteScalar();
                return result != null ? Convert.ToInt32(result) : -1;
            }
        }
    }
}

    private void registr_Load(object sender, EventArgs e)
    {

    }

    private void enterr_button_Click_1(object sender, EventArgs e)
    {
        try
        {
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                connection.Open();
                string query = "INSERT INTO Users ([FIO],[login],[Password]) VALUES (?,?,?)";
                using (OleDbCommand command = new OleDbCommand(query, connection))
                {
                    command.Parameters.AddWithValue("@FIO", fioliabel.Text);
                    command.Parameters.AddWithValue("@login", loginfield.Text);
                    command.Parameters.AddWithValue("@Password", passfield.Text);
                    command.ExecuteNonQuery();
                }
                MessageBox.Show("Вы зарегистрированы!");
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show("Ошибка: " + ex.Message);
        }
        Form1 newForm = new Form1();
         FormSwitcher.SwitchMainForm(this, newForm);
    }
}

    public Form1()
    {
        InitializeComponent();
        comboPaymentType.SelectedIndex = 0;
    }

    private void checkCalcAtSum_CheckedChanged(object sender, EventArgs e)
    {
        nudCostOfPurchase.Enabled = nudInitialPayment.Enabled = !checkCalcAtSum.Checked;
        nudCreditAmount.Enabled = checkCalcAtSum.Checked;
    }

    // Рассчитать стоимость
    private void btnCalculate_Click(object sender, EventArgs e)
    {
        Calculator calculator = new Calculator((double)nudCreditAmount.Value, (double)nudCreditRate.Value, (int)nudCreditPeriod.Value, (CalcType)comboPaymentType.SelectedIndex);
        dtShedule = calculator.GetShedule();
        dgvSchedule.DataSource = dtShedule;
        tbMonthlyPayment.Text = calculator.GetMonthlyPayment();
        tbSummaryCreditAmount.Text = calculator.GetSummaryCreditAmount();
        tbSummaryOverPayment.Text = calculator.GetSummaryOverPayment();

        dgvSchedule.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;
        for (int i = 1; i < dgvSchedule.Columns.Count; i++)
        {
            dgvSchedule.Columns[i].DefaultCellStyle.Format = String.Format("### ### ### ##0.#0");
            dgvSchedule.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
            dgvSchedule.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
        }
        btnExportToCSV.Enabled = true;
    }

    // Очистить расчеты
    private void btnClear_Click(object sender, EventArgs e)
    {
        dtShedule.Clear();
        checkCalcAtSum.Checked = false;
        nudCostOfPurchase.Value = nudCostOfPurchase.Minimum;
        nudInitialPayment.Value = nudInitialPayment.Minimum;
        nudCreditAmount.Value = nudCreditAmount.Minimum;
        nudCreditPeriod.Value = 60M;
        nudCreditRate.Value = 6.5M;
        comboPaymentType.SelectedIndex = 0;
        tbMonthlyPayment.Clear();
        tbSummaryCreditAmount.Clear();
        tbSummaryOverPayment.Clear();
        btnExportToCSV.Enabled = false;
    }

    private void CalcCreditAmount(object sender, EventArgs e)
    {
        decimal cAm = Calculator.GetCreditAmount(nudCostOfPurchase.Value, nudInitialPayment.Value);
        nudCreditAmount.Value = cAm < 0? 0 : cAm;
    }

    private void comboPaymentType_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (comboPaymentType.SelectedIndex == 0)
            toolTip.SetToolTip(comboPaymentType, "Вариант ежемесячного платежа по кредиту, когда размер ежемесячного платежа остаётся постоянным на всём периоде кредитования.");
        if (comboPaymentType.SelectedIndex == 1)
            toolTip.SetToolTip(comboPaymentType, "Вариант ежемесячного платежа по кредиту, когда размер ежемесячного платежа по погашению кредита постепенно уменьшается к концу периода кредитования.");
    }

    private void nuds_Enter(object sender, EventArgs e)
    {
        if (sender is NumericUpDown)
            (sender as NumericUpDown).Select(0, (sender as NumericUpDown).Value.ToString().Length);
    }

    private void nudCreditPeriod_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.KeyCode == Keys.K)
            nudCreditPeriod.Value *= 12;
    }

    private void btnExportToCSV_Click(object sender, EventArgs e)
    {
        SaveFileDialog save = new SaveFileDialog();
        save.Title = "Экспорт графика платежей";
        save.Filter = "*.CSV-файл с разделителями |*.csv";
        if (save.ShowDialog() == DialogResult.OK)
            Export.ToCSV(save.FileName, dtShedule, tbSummaryCreditAmount.Text, nudCreditAmount.Value.ToString(), tbSummaryOverPayment.Text);
    }

    private void gbSchedule_Enter(object sender, EventArgs e)
    {

    }
}