/// <summary> /// Получить базу замеров. /// </summary> /// <returns></returns> public List <Froze> GetFrozeBase(string idGager, string date) { // Подключение к БД try { _connect.Connection.Open(); } catch (MySqlException) { MessageBox.Show("Проблемы с подключениек к базе данных.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return(null); } var query = "SELECT * FROM froze_base WHERE id_gager = '" + idGager + "' AND date = '" + date + "'"; var command = new MySqlCommand(query, _connect.Connection); var reader = command.ExecuteReader(); var frozeBase = new List <Froze>(); while (reader.Read()) { var froze = new Froze { IdFroze = (int)reader[0], Time = (int)reader[1] }; DateTime.TryParseExact(reader[3].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out var newDate); froze.Date = newDate; froze.City = reader[3].ToString(); froze.Street = reader[4].ToString(); froze.HouseNumber = (int)reader[5]; froze.PhoneNumber = reader[7].ToString(); froze.Apartment = (int)reader[6]; froze.Comment = reader[8].ToString(); froze.CheckWasFroze = (bool)reader[12]; froze.IdGager = reader[14].ToString(); froze.CreateFroze = reader[16].ToString(); frozeBase.Add(froze); } _connect.Connection.Close(); return(frozeBase); }
/// <summary> /// Добавить новый замер в БД. /// </summary> public bool AddFroze(Froze froze) { var time = froze.Time; var date = froze.Date.ToString("dd/MM/yyyy"); var city = froze.City; var street = froze.Street; var houseNumber = froze.HouseNumber; var apartment = froze.Apartment; var phoneNumber = froze.PhoneNumber; var comment = froze.Comment; var idGager = froze.IdGager; var create = froze.CreateFroze; try { _connect.Connection.Open(); } catch (MySqlException) { MessageBox.Show("Проблемы с подключениек к базе данных.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } string query = "INSERT INTO `froze_base` ( " + "`time` , `date` , `city` ,`street` , `house_number` ,`apartment` , `phone_number` , `coment` ,`id_gager`" + ",`create`)" + "VALUES(" + time + ", '" + date + "', '" + city + "', '" + street + "', " + houseNumber + ", " + apartment + ", '" + phoneNumber + "', '" + comment + "', '" + idGager + "', '" + create + "');"; var command = new MySqlCommand(query, _connect.Connection); command.ExecuteNonQuery(); _connect.Connection.Close(); return(true); }
/// <summary> /// Просмотр замера по двойному клику мыши. /// </summary> private void ShowFrozeDataGridView_MouseDoubleClick(object sender, MouseEventArgs e) { DataGridView dataGrid = SelectedDataGridViewFroze(sender); if ((TestMagnatBL.Froze)dataGrid.SelectedCells[8].Value != null) { var showFrozeForm = new ShowFrozeForm(); showFrozeForm.CurrentFroze = (TestMagnatBL.Froze)dataGrid.SelectedCells[8].Value; showFrozeForm.Show(); } else { if (!UserProfile.Data.CurrentPosition.CheckAddFroze) { MessageBox.Show("Вы не можете добавить новый замер.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } int index = _showGagerDataGridViewList.FindIndex(t => t == dataGrid); var newFroze = new TestMagnatBL.Froze(); newFroze.Date = _dateTimePickerList[index].Value; newFroze.IdGager = _gager[index].ToString(); newFroze.Time = int.Parse(dataGrid.SelectedCells[0].Value.ToString()); var addFrozeForm = new AddFrozeForm(); addFrozeForm.CurrentFroze = newFroze; if (addFrozeForm.ShowDialog() == DialogResult.OK) { UpdateDataSelectTableFroze(dataGrid, _gager[index], _dateTimePickerList[index].Value); } } }