private void AddButton_Click(object sender, EventArgs e)
{
//Массив параметров
string[] List =
{
VusNumbtextBox.Text,
FIOtextBox.Text,
RankComboBox.SelectedItem.ToString(),
$"{DateOfBirth.Value.Day:0#}.{DateOfBirth.Value.Month:0#}.{DateOfBirth.Value.Year}",
HomeAdresstextBox.Text,
WorkPlacetextBox.Text,
TurnoutAddresstextBox.Text,
CompanytextBox.Text
};
bool IsEmptyField = false;
foreach (var item in List)
{
if (item.Length == 0)
{
IsEmptyField = true;
}
}
if (IsEmptyField)
{
MessageBox.Show("Заполните все поля", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var member = new Member()
{
VusNumber = List[0],
FIO = List[1],
Rank = List[2],
YearOfBirth = List[3],
HomeAddress = List[4],
PlaceOfWork = List[5],
TurnoutAddress = List[6],
Company = List[7]
};
GroupsArray.AddMemberToTheGroup(GroupsArray.LastGroupName, member);
Group group = GroupsArray.FindGroup(GroupsArray.LastGroupName);
if (!EditableControls.IsContained(GroupsArray.LastGroupName))
{
EditableControls.CreateNewTab(group);
}
else
//if (EditableControls.IsContained(GroupsArray.LastGroupName))
{
EditableControls.AddMemberToTab(GroupsArray.LastGroupName, member);
}
SQLite.AddMemberToDB(GroupsArray.LastGroupName, member);
this.Close();
}
}
public static void FirstInitialize()
{
if (!File.Exists(database))
{
SQLiteConnection.CreateFile(database);
}
string StartCommand = DataBaseCommands.CreateTableListMembers();
string request = DataBaseCommands.SelectAll();
command = new SQLiteCommand(StartCommand, connection);
command1 = new SQLiteCommand(request, connection);
try
{
connection.Open();
command.ExecuteNonQuery();
using (DbDataReader reader = command1.ExecuteReader())
{
string GroupName, _VusNumber, _FIO,
_rank, _YearOfBirth, _HomeAddress,
_PlaceOfWork, _TurnoutAddress, _Company;
if (reader.HasRows)
{
while (reader.Read())
{
GroupName = reader.GetString(0);
_VusNumber = reader.GetString(1);
_FIO = reader.GetString(2);
_rank = reader.GetString(3);
_YearOfBirth = reader.GetString(4).Split(' ')[0];
_HomeAddress = reader.GetString(5);
_PlaceOfWork = reader.GetString(6);
_TurnoutAddress = reader.GetString(7);
_Company = reader.GetString(8);
GroupsArray.LastGroupName = GroupName;
if (!GroupsArray.IsCreated(GroupName))
{
GroupsArray.CreateNewGroup(GroupName);
EditableControls.GroupList.Items.Add(GroupName);
}
var member = new Member()
{
VusNumber = _VusNumber,
FIO = _FIO,
Rank = _rank,
YearOfBirth = _YearOfBirth,
HomeAddress = _HomeAddress,
PlaceOfWork = _PlaceOfWork,
TurnoutAddress = _TurnoutAddress,
Company = _Company
};
GroupsArray.AddMemberToTheGroup(GroupsArray.LastGroupName, member);
Group group = GroupsArray.FindGroup(GroupsArray.LastGroupName);
if (!EditableControls.IsContained(GroupsArray.LastGroupName))
{
EditableControls.CreateNewTab(group);
}
else
{
EditableControls.AddMemberToTab(GroupsArray.LastGroupName, member);
}
}
}
}
connection.Close();
}
catch (Exception e)
{
MessageBox.Show("Error: " + e.Message);
}
}
