private void button2_Click(object sender, EventArgs e) { string a = dateTimePicker1.Text; string d = dateTimePicker2.Text; int s = int.Parse(a[0].ToString() + a[1].ToString()); int t = int.Parse(d[0].ToString() + d[1].ToString()); listView2.Items.Clear(); List <Contracts> contr = Contracts.GetContracts(); for (int i = 0; i < contr.Count; i++) { int q = int.Parse(contr[i].DataOpen[0].ToString() + contr[i].DataOpen[1].ToString()); if (q > s && q < t) { string[] array = new string[3]; array[0] = contr[i].Id.ToString(); Users g = Users.GetUsers(contr[i].IdUser); array[1] = contr[i].DataOpen; Cars k = Cars.GetCar(contr[i].IdCar); array[2] = k.Vin; listView2.Items.Add(new ListViewItem(array)); } } }
private void allContractsButton_Click(object sender, EventArgs e) { noDataLabel.Text = ""; if (contractsBox.Text != null && contractsBox.Text != "") { Users f = Users.GetUsers(contractsBox.Text); List <Contracts> q = Contracts.GetContracts(f.Id); openContractsView.Items.Clear(); if (q.Count == 0) { noDataLabel.Text = "Ничего не найдено"; } for (int i = 0; i < q.Count; i++) { string[] array = new string[3]; array[0] = q[i].Id.ToString(); Cars k = Cars.GetCar(q[i].IdCar); array[1] = k.Vin; List <String> m = Cars.GetModel(k.IdModel); array[2] = m[0]; openContractsView.Items.Add(new ListViewItem(array)); } } }
private void openContractsButton_Click(object sender, EventArgs e) { noDataLabel.Text = ""; if (contractsBox.Text != null && contractsBox.Text != "") { Users f = Users.GetUsers(contractsBox.Text); List <Contracts> q = Contracts.GetContracts(f.Id); openContractsView.Items.Clear(); for (int i = 0; i < q.Count; i++) { string[] array = new string[3]; if (q[i].DataClose == null) { array[0] = q[i].Id.ToString(); Cars k = Cars.GetCar(q[i].IdCar); array[1] = k.Vin; array[2] = Cars.GetModel(k.Id).ToString(); openContractsView.Items.Add(new ListViewItem(array)); } else { continue; } } } }
private void carsView_MouseClick(object sender, MouseEventArgs e) { if (!admin) { string selected = carsView.SelectedItems[0].Text; Form AddCars = new AddCars(this, Cars.GetCar(int.Parse(selected)), s); AddCars.Owner = this; AddCars.ShowDialog(); updateListView(); } }
public AddContract(Main m, Contracts c, string pt) { InitializeComponent(); label6.Visible = false; button3.Visible = false; List <Users> list = Users.GetAllUsers(); for (int i = 0; i < list.Count; i++) { if (list[i].IdUserRole == 2) { comboBox1.Items.Add(list[i].Surname); } } List <Contracts> contr = Contracts.GetContracts(); List <Cars> list2 = Cars.GetCars(); for (int i = 0; i < list2.Count; i++) { bool a = false; for (int t = 0; t < contr.Count; t++) { if (contr[t].IdCar == list2[i].Id) { a = true; } } if (!a) { comboBox2.Items.Add(list2[i].Vin); } } this.m = m; this.c = c; this.pt = pt;; if (c != null) { button1.Text = "Завершить контракт"; Users v = Users.GetUsers(c.IdUser); if (v.IdUserRole == 2) { comboBox1.Text = v.Surname; } Cars a = Cars.GetCar(c.IdCar); comboBox2.Text = a.Vin; textBox2.Text = c.Cost; textBox3.Text = c.Commission; button3.Visible = true; label6.Visible = true; } }
public AllContracts() { InitializeComponent(); listView1.Items.Clear(); List <Contracts> v = Contracts.GetContracts(); for (int i = 0; i < v.Count; i++) { string[] array = new string[7]; array[0] = v[i].Id.ToString(); Users g = Users.GetUsers(v[i].IdUser); array[2] = v[i].DataOpen; array[1] = g.Surname; Cars k = Cars.GetCar(v[i].IdCar); array[3] = k.Vin; array[4] = v[i].Cost; array[5] = v[i].Commission; array[6] = v[i].DataClose; listView1.Items.Add(new ListViewItem(array)); } }
public void updateListView() { historyView.Items.Clear(); List <Log> l = Log.GetAllLog(); for (int i = 0; i < l.Count; i++) { string[] array = new string[5]; array[0] = l[i].IdWrite.ToString(); array[1] = l[i].LastNameUser; array[2] = l[i].Act; array[3] = l[i].TableAct; array[4] = l[i].DateAct; historyView.Items.Add(new ListViewItem(array)); } usersView.Items.Clear(); List <Users> u = Users.GetAllUsers(); for (int i = 0; i < u.Count; i++) { string[] array = new string[7]; array[0] = u[i].Id.ToString(); if (u[i].IdUserRole == 1) { array[1] = "админ"; } else { array[1] = "диллер"; } array[2] = u[i].Surname; array[3] = u[i].Name; array[4] = u[i].Patronymic; array[5] = u[i].Address; array[6] = u[i].Phone; usersView.Items.Add(new ListViewItem(array)); } clientsView.Items.Clear(); List <Clients> a = Clients.GetAllClients(); for (int i = 0; i < a.Count; i++) { string[] array = new string[6]; array[0] = a[i].Id.ToString(); array[1] = a[i].surname; array[2] = a[i].Name; array[3] = a[i].Patronymic; array[4] = a[i].Address; array[5] = a[i].Phone; clientsView.Items.Add(new ListViewItem(array)); } contractsView.Items.Clear(); List <Contracts> v = Contracts.GetContracts(); for (int i = 0; i < v.Count; i++) { string[] array = new string[6]; if (v[i].DataClose == null) { array[0] = v[i].Id.ToString(); Users g = Users.GetUsers(v[i].IdUser); array[2] = v[i].DataOpen; array[1] = g.Surname; Cars k = Cars.GetCar(v[i].IdCar); array[3] = k.Vin; array[4] = v[i].Cost; array[5] = v[i].Commission; } else { continue; } contractsView.Items.Add(new ListViewItem(array)); } carsView.Items.Clear(); List <Cars> d = Cars.GetCars(); for (int i = 0; i < d.Count; i++) { string[] array = new string[8]; array[0] = d[i].Id.ToString(); Clients c = Clients.GetClient(d[i].IdClient); array[1] = c.surname; List <String> m = Cars.GetModel(d[i].IdModel); array[2] = m[0]; array[4] = d[i].Color; array[3] = d[i].Vin; array[5] = d[i].IssueDate; array[6] = d[i].Milleage; array[7] = d[i].Transmission; carsView.Items.Add(new ListViewItem(array)); } }
private void button1_Click(object sender, EventArgs e) { if (c != null) { if ( !string.IsNullOrEmpty(textBox2.Text) && !string.IsNullOrWhiteSpace(textBox2.Text) && !string.IsNullOrEmpty(textBox3.Text) && !string.IsNullOrWhiteSpace(textBox3.Text) && !string.IsNullOrEmpty(comboBox1.Text) && !string.IsNullOrWhiteSpace(comboBox1.Text) && !string.IsNullOrEmpty(comboBox2.Text) && !string.IsNullOrWhiteSpace(comboBox2.Text)) { Users cl = Users.GetUsers(comboBox1.Text); Cars c2 = Cars.GetCar(comboBox2.Text); Contracts m = new Contracts(c.Id, cl.Id, dateTimePicker1.Text.ToString(), c2.Id, textBox2.Text.ToString(), textBox3.Text.ToString(), DateTime.Today.ToString()); Contracts.Update(pt, m); Close(); } else { MessageBox.Show("Вы ввели некорректные данные, попробуйте еще раз)", "Ошибка", MessageBoxButtons.OK); } } else { if (int.Parse(textBox3.Text) >= int.Parse(textBox2.Text)) { MessageBox.Show("Вы ввели некорректные данные, попробуйте еще раз)", "Ошибка", MessageBoxButtons.OK); } else { if ( !string.IsNullOrEmpty(textBox2.Text) && !string.IsNullOrWhiteSpace(textBox2.Text) && !string.IsNullOrEmpty(textBox3.Text) && !string.IsNullOrWhiteSpace(textBox3.Text) && !string.IsNullOrEmpty(comboBox1.Text) && !string.IsNullOrWhiteSpace(comboBox1.Text) && !string.IsNullOrEmpty(comboBox2.Text) && !string.IsNullOrWhiteSpace(comboBox2.Text)) { try { Users cl = Users.GetUsers(comboBox1.Text); Cars c2 = Cars.GetCar(comboBox2.Text); Contracts.AddContracts(pt, cl.Id, dateTimePicker1.Text.ToString(), c2.Id, textBox2.Text.ToString(), textBox3.Text.ToString()); Close(); } catch { MessageBox.Show("Вы ввели некорректные данные, попробуйте еще раз)", "Ошибка", MessageBoxButtons.OK); } } else { MessageBox.Show("Вы ввели некорректные данные, попробуйте еще раз)", "Ошибка", MessageBoxButtons.OK); } } } }