Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using System.Data.SQLite;
- using Sale_on_credit.Models;
- using System.Security.Cryptography;
- using Sale_on_credit.Classes;
- namespace Sale_on_credit
- {
- public partial class Form2 : MetroFramework.Forms.MetroForm
- {
- static Form1 form1 = new Form1();
- SalesContext _db;
- Core obj = new Core();
- public Form2()
- {
- InitializeComponent();
- this.StyleManager = metroStyleManager1;
- _db = new SalesContext();
- }
- private void metroButton1_Click(object sender, EventArgs e)
- {
- Visible = false;
- form1.Visible = true;
- }
- private void metroButton3_Click(object sender, EventArgs e)
- {
- metroPanel2.Visible = true;
- }
- private void metroButton4_Click(object sender, EventArgs e)
- {
- Encryption md5 = new Encryption();
- if (string.IsNullOrEmpty(metroTextBox3.Text) && string.IsNullOrWhiteSpace(metroTextBox3.Text)) { MessageBox.Show("Не заполнено поле Старый пароль"); }
- else if (string.IsNullOrEmpty(metroTextBox4.Text) && string.IsNullOrWhiteSpace(metroTextBox4.Text)) { MessageBox.Show("Не заполнено поле Новый пароль"); }
- else
- {
- Admin admin = obj.GetAdmin();
- if (admin.Password != md5.MD5(metroTextBox3.Text)) { MessageBox.Show("Введенный пароль не соответсвует сохраненному паролю..."); }
- else
- {
- obj.UpdateInf(metroTextBox4.Text);
- MessageBox.Show("Изменения внесены успешно.");
- metroTextBox3.Text = "";
- metroTextBox4.Text = "";
- metroPanel2.Visible = false;
- }
- }
- }
- private void metroButton2_Click(object sender, EventArgs e)
- {
- metroLabel6.Visible = true;
- metroLabel21.Visible = false;
- metroButton7.Visible = true;
- metroButton20.Visible = false;
- // metroButton20.Enabled = false;
- metroPanel1.Visible = true;
- }
- private void metroButton5_Click(object sender, EventArgs e)
- {
- deleteRowProduct();
- MessageBox.Show("Удаление прошло успешно");
- UpdateDataGridView1();
- }
- private void metroButton6_Click(object sender, EventArgs e)
- {
- int znach = (int)dataGridView1.CurrentRow.Cells[0].Value;
- Product2 product = obj.getInfoAboutProduct(znach);
- metroLabel6.Visible = false;
- metroLabel21.Visible = true;
- metroButton7.Visible = false;
- //metroButton7.Enabled = false;
- metroButton20.Visible = true;
- metroPanel1.Visible = true;
- metroTextBox1.Text = product.Name; metroTextBox2.Text = Convert.ToString(product.Cost); metroTextBox5.Text = product.Manufacturer; metroTextBox6.Text = product.Serial_number;
- }
- private void Form2_Load(object sender, EventArgs e)
- {
- UpdateDataGridView1();
- UpdateDataGridView2();
- UpdateDataGridView3();
- }
- public void UpdateDataGridView1()
- {
- //------------------------Заполнение dataGridView1------------------------------//
- var temp = _db.Product2.ToList();
- var columns = from t in temp
- orderby t.Id_product
- select new
- {
- ID = t.Id_product,
- Name = t.Name,
- Cost = t.Cost,
- Manufacturer = t.Manufacturer,
- Serial_number = t.Serial_number
- };
- dataGridView1.DataSource = columns.ToList();
- }
- public void UpdateDataGridView2()
- {
- //------------------------Заполнение dataGridView2------------------------------//
- var temp = _db.Users.ToList();
- var columns = from t in temp
- orderby t.Id
- select new
- {
- ID = t.Id,
- Login = t.Login,
- Fio = t.FIO
- };
- dataGridView2.DataSource = columns.ToList();
- }
- public void UpdateDataGridView3()
- {
- //------------------------Заполнение dataGridView3------------------------------//
- var temp = _db.Banks2.ToList();
- var columns = from t in temp
- orderby t.Id_bank
- select new
- {
- ID = t.Id_bank,
- nameBank = t.Name,
- percent = t.Percent_of_credit
- };
- dataGridView3.DataSource = columns.ToList();
- }
- private void metroButton7_Click(object sender, EventArgs e)
- {
- /*Метод добавления нового пользоваьеля в БД
- Encryption md5 = new Encryption();
- User user = new User { Login = metroTextBox1.Text, Password = md5.MD5(metroTextBox2.Text), FIO = metroTextBox5.Text };
- MessageBox.Show(user.Login + " " + user.Password);
- _db.Users.Add(user);
- _db.SaveChanges();*/
- }
- private void Form2_FormClosed(object sender, FormClosedEventArgs e)
- {
- form1.Visible = true;
- form1.FocusMe();
- this.Visible = false;
- }
- private void metroButton8_Click(object sender, EventArgs e)
- {
- metroTextBox3.Text = "";
- metroTextBox4.Text = "";
- metroPanel2.Visible = false;
- }
- private void groupBox3_Enter(object sender, EventArgs e)
- {
- }
- private void metroLabel6_Click(object sender, EventArgs e)
- {
- }
- private void metroPanel3_Paint(object sender, PaintEventArgs e)
- {
- }
- private void metroButton9_Click(object sender, EventArgs e)
- {
- metroTextBox1.Text = "";
- metroTextBox2.Text = "";
- metroTextBox5.Text = "";
- metroTextBox6.Text = "";
- metroPanel1.Visible = false;
- }
- private void metroButton10_Click(object sender, EventArgs e)
- {
- metroLabel2.Visible = true;
- metroLabel22.Visible = false;
- metroButton13.Visible = true;
- metroButton21.Visible = false;
- metroPanel3.Visible = true;
- }
- private void metroButton14_Click(object sender, EventArgs e)
- {
- metroTextBox7.Text = "";
- metroTextBox8.Text = "";
- metroTextBox9.Text = "";
- metroPanel3.Visible = false;
- }
- private void metroButton17_Click(object sender, EventArgs e)
- {
- metroLabel23.Visible = false;
- metroButton22.Visible = false;
- metroPanel4.Visible = true;
- }
- private void metroButton16_Click(object sender, EventArgs e)
- {
- metroTextBox10.Text = "";
- metroTextBox11.Text = "";
- metroPanel4.Visible = false;
- }
- private void metroTextBox2_KeyPress(object sender, KeyPressEventArgs e)
- {
- if (Char.IsNumber(e.KeyChar) ||
- (!string.IsNullOrEmpty(metroTextBox2.Text) && e.KeyChar == ',' || e.KeyChar == (char)Keys.Back))
- {
- return;
- }
- e.Handled = true;
- }
- private void metroTextBox11_KeyPress(object sender, KeyPressEventArgs e)
- {
- if (Char.IsNumber(e.KeyChar) ||
- (!string.IsNullOrEmpty(metroTextBox11.Text) && e.KeyChar == ',' || e.KeyChar == (char)Keys.Back))
- {
- return;
- }
- e.Handled = true;
- }
- public void deleteRowProduct()
- {
- //dataGridView1.Rows.Remove(this.dataGridView1.CurrentRow);
- int znach = (int)dataGridView1.CurrentRow.Cells[0].Value;
- obj.removeProduct(znach);
- }
- private void metroButton7_Click_1(object sender, EventArgs e)
- {
- if (string.IsNullOrEmpty(metroTextBox1.Text) && string.IsNullOrWhiteSpace(metroTextBox1.Text)) { MessageBox.Show("Невведено наименование товара!"); }
- else if (string.IsNullOrEmpty(metroTextBox2.Text) && string.IsNullOrWhiteSpace(metroTextBox2.Text)) { MessageBox.Show("Невведена стоимость товара!"); }
- else if (string.IsNullOrEmpty(metroTextBox5.Text) && string.IsNullOrWhiteSpace(metroTextBox5.Text)) { MessageBox.Show("Невведен производитель товара!"); }
- else if(string.IsNullOrEmpty(metroTextBox6.Text) && string.IsNullOrWhiteSpace(metroTextBox6.Text)) { MessageBox.Show("Невведен серийный номер товара!"); }
- else
- {
- string name_product = metroTextBox1.Text, manufacturer = metroTextBox5.Text, serialNumber = metroTextBox6.Text;
- double cost_product =Convert.ToDouble(metroTextBox2.Text);
- obj.addProductIntoDB(name_product, cost_product, manufacturer, serialNumber);
- MessageBox.Show("Товар успешно внесен...");
- metroTextBox1.Text = "";
- metroTextBox2.Text = "";
- metroTextBox5.Text = "";
- metroTextBox6.Text = "";
- metroPanel1.Visible = false;
- }
- UpdateDataGridView1();
- }
- private void metroButton13_Click(object sender, EventArgs e)
- {
- if (string.IsNullOrEmpty(metroTextBox7.Text) && string.IsNullOrWhiteSpace(metroTextBox7.Text)) { MessageBox.Show("Не заполнено поле Логин"); }
- else if (string.IsNullOrEmpty(metroTextBox8.Text) && string.IsNullOrWhiteSpace(metroTextBox8.Text)) { MessageBox.Show("Не заполнено поле Пароль"); }
- else if (string.IsNullOrEmpty(metroTextBox9.Text) && string.IsNullOrWhiteSpace(metroTextBox9.Text)) { MessageBox.Show("Не заполнено поле Фамилия/Имя/Отчество"); }
- else
- {
- obj.addNewUser(metroTextBox7.Text, metroTextBox8.Text, metroTextBox9.Text);
- MessageBox.Show("Пользователь успешно зарегистрирован.");
- metroTextBox7.Text = "";
- metroTextBox8.Text = "";
- metroTextBox9.Text = "";
- metroPanel3.Visible = false;
- }
- UpdateDataGridView2();
- }
- private void metroButton12_Click(object sender, EventArgs e)
- {
- deleteRowUser();
- MessageBox.Show("Удаление прошло успешно.");
- UpdateDataGridView2();
- }
- public void deleteRowUser()
- {
- int znach = (int)dataGridView2.CurrentRow.Cells[0].Value;
- obj.removeUser(znach);
- }
- private void metroButton15_Click(object sender, EventArgs e)
- {
- if (string.IsNullOrEmpty(metroTextBox10.Text) && string.IsNullOrWhiteSpace(metroTextBox10.Text)) { MessageBox.Show("Не заполнено поле Наименование"); }
- else if (string.IsNullOrEmpty(metroTextBox11.Text) && string.IsNullOrWhiteSpace(metroTextBox11.Text)) { MessageBox.Show("Не заполнено поле Процент кредита"); }
- else
- {
- obj.addNewBank(metroTextBox10.Text, Convert.ToDouble(metroTextBox11.Text));
- MessageBox.Show("Информация о банке успешно добавлена");
- metroTextBox10.Text = "";
- metroTextBox11.Text = "";
- metroPanel4.Visible = false;
- }
- UpdateDataGridView3();
- }
- private void metroButton19_Click(object sender, EventArgs e)
- {
- deleteRowBank();
- MessageBox.Show("Информация о банке успешно удалена.");
- UpdateDataGridView3();
- }
- public void deleteRowBank()
- {
- int znach = (int)dataGridView3.CurrentRow.Cells[0].Value;
- obj.removeBank(znach);
- }
- private void metroButton20_Click(object sender, EventArgs e)
- {
- if (string.IsNullOrEmpty(metroTextBox1.Text) && string.IsNullOrWhiteSpace(metroTextBox1.Text)) { MessageBox.Show("Не заполнено поле Наименование поступившего товара"); }
- else if (string.IsNullOrEmpty(metroTextBox2.Text) && string.IsNullOrWhiteSpace(metroTextBox2.Text)) { MessageBox.Show("Не заполнено поле Стоимость"); }
- else if (string.IsNullOrEmpty(metroTextBox5.Text) && string.IsNullOrWhiteSpace(metroTextBox5.Text)) { MessageBox.Show("Не заполнено поле Производитель"); }
- else if (string.IsNullOrEmpty(metroTextBox6.Text) && string.IsNullOrWhiteSpace(metroTextBox6.Text)) { MessageBox.Show("Не заполнено поле Серийный номер товара"); }
- else
- {
- obj.updateInfoAboutProduct(metroTextBox1.Text,Convert.ToDouble(metroTextBox2.Text), metroTextBox5.Text, metroTextBox6.Text);
- MessageBox.Show("Изменения прошли успешно");
- metroTextBox1.Text = "";
- metroTextBox2.Text = "";
- metroTextBox5.Text = "";
- metroTextBox6.Text = "";
- metroPanel1.Visible = false;
- }
- UpdateDataGridView1(); //НЕ РАБОТАЕТ!!!
- }
- private void metroButton11_Click(object sender, EventArgs e)
- {
- int znach = (int)dataGridView2.CurrentRow.Cells[0].Value;
- User user = obj.getInfoAboutUser(znach);
- metroLabel12.Visible = false;
- metroLabel22.Visible = true;
- metroButton13.Visible = false;
- metroButton21.Visible = true;
- metroPanel3.Visible = true;
- metroTextBox7.Text = user.Login; metroTextBox9.Text = user.FIO;
- }
- private void metroButton21_Click(object sender, EventArgs e)
- {
- int znach = (int)dataGridView2.CurrentRow.Cells[0].Value;
- // User user = obj.getInfoAboutUser(znach);
- if (string.IsNullOrEmpty(metroTextBox7.Text) && string.IsNullOrWhiteSpace(metroTextBox7.Text)) { MessageBox.Show("Не заполнено поле Логин"); }
- else if (string.IsNullOrEmpty(metroTextBox8.Text) && string.IsNullOrWhiteSpace(metroTextBox8.Text)) { MessageBox.Show("Не заполнено поле Пароль"); }
- else if (string.IsNullOrEmpty(metroTextBox9.Text) && string.IsNullOrWhiteSpace(metroTextBox9.Text)) { MessageBox.Show("Не заполнено поле Фамилия/Имя/Отчество"); }
- else
- {
- obj.updateInfoAboutUsers(znach,metroTextBox7.Text, metroTextBox8.Text, metroTextBox9.Text);
- MessageBox.Show("Изменения внесены.");
- metroPanel3.Visible = false;
- metroTextBox7.Text = "";
- metroTextBox8.Text = "";
- metroTextBox9.Text = "";
- }
- UpdateDataGridView2(); //НЕ РАБОТАЕТ!!!
- }
- private void metroLabel22_Click(object sender, EventArgs e)
- {
- }
- private void metroButton18_Click(object sender, EventArgs e)
- {
- int idBank = (int)dataGridView3.CurrentRow.Cells[0].Value;
- metroLabel23.Visible = true;
- metroButton22.Visible = true;
- metroLabel17.Visible = false;
- metroButton15.Visible = false;
- metroPanel4.Visible = true;
- Bank2 bank = obj.getInfoAboutBank(idBank);
- metroTextBox10.Text = bank.Name;
- metroTextBox11.Text = Convert.ToString(bank.Percent_of_credit);
- }
- private void metroButton22_Click(object sender, EventArgs e)
- {
- int idBank = (int)dataGridView3.CurrentRow.Cells[0].Value;
- if (string.IsNullOrEmpty(metroTextBox10.Text) && string.IsNullOrWhiteSpace(metroTextBox10.Text)) { MessageBox.Show("Не заполнено поле Наименование"); }
- else if (string.IsNullOrEmpty(metroTextBox11.Text) && string.IsNullOrWhiteSpace(metroTextBox11.Text)) { MessageBox.Show("Не заполнено поле Процент кредита"); }
- else
- {
- obj.updateInfoAboutBanks(idBank, metroTextBox10.Text, Convert.ToDouble(metroTextBox11.Text));
- MessageBox.Show("Изменения внесены.");
- metroPanel4.Visible = false;
- metroTextBox10.Text = "";
- metroTextBox11.Text = "";
- }
- UpdateDataGridView3(); //НЕ РАБОТАЕТ!!!
- }
- }
- }
Add Comment
Please, Sign In to add comment