Found 5 packages
Package Description
Data types, extension methods, helper classes, and value converters designed to simplify Win32 WPF app development.
An extented message box for a Windows Forms applications.
Validation string, How To Use: Validation TextBox, RichTextBox, ComboBox ... Try Dim Value As String = Validation.NotNull.OfControlText(Textbox1, "Erro") Catch Ex As Exception MsgBox(Ex.Message) End Try OfVariable Try Dim t As String = TextBox1.text t = Validation.NotNull.OfVariable(t, "Erro") Catch Ex As Exception MsgBox(Ex.Message) End Try
try { sql.OpenConnect(); SqlCommand command = new SqlCommand($"SELECT idUser, typeUser " + $"FROM [User] " + $"WHERE login = '{LoginTB.Text}' AND password = '{PasswordTB.Text}' ", sql.str); SqlDataReader reader = command.ExecuteReader(); reader.Read(); int idUser = Convert.ToInt32(reader["idUser"].ToString()); object result = reader["typeUser"].ToString(); reader.Close(); sql.CloseConnect(); if (LoginTB.Text == "" || PasswordTB.Text == "") { MessageBox.Show("Введите логин или пароль"); } else if (result != null) { int typeUser = Convert.ToInt32(result); if (typeUser == 1) { Forms.AdminWin adminWin = new Forms.AdminWin(); adminWin.Show(); this.Close(); } else if (typeUser == 2) { Forms.ExcuetWin excuetWin = new Forms.ExcuetWin(idUser); excuetWin.Show(); this.Close(); } } else { MessageBox.Show("Неверный Логин или Пароль"); } } catch (Exception ex) { MessageBox.Show($"Error: {ex}"); } private List<Equipment> equipmentList; private Equipment equipmentSelect; private void LoadEquipmentList() { equipmentList = new List<Equipment>(); try { sql.OpenConnection(); string query = "SELECT Код_Оборудования, Наименование FROM Оборудование"; SqlCommand command = new SqlCommand(query, sql.str); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Equipment equipment = new Equipment { EquipmentCode = reader.GetInt32(reader.GetOrdinal("Код_Оборудования")), Name = reader.GetString(reader.GetOrdinal("Наименование")) }; equipmentList.Add(equipment); } // Установка списка в качестве источника данных для ComboBox OborudCB.ItemsSource = equipmentList; OborudCB.DisplayMemberPath = "Name"; // Отображение наименования в ComboBox } catch (Exception ex) { MessageBox.Show($"Ошибка: {ex.Message}"); } finally { sql.CloseConnection(); } }