//Add
public void Add(Contact contact)
{
if (FirstTime)
{
Value = contact;
FirstTime = false;
Count++;
string CommandInsert = $@"INSERT INTO ContactList ([Name], [SurName], [Email], [PNumber]) VALUES
('{Value.Name}', '{Value.SurName}', '{Value.Email}', '{Value.PNumber}')";
using (SqlConnection connection = new SqlConnection(strConnection))
{
connection.Open();
SqlCommand command = new SqlCommand(CommandInsert, connection);
numOfInserted += command.ExecuteNonQuery();
}
}
else if (Next == null)
{
Next = new PhoneBook(contact);
Current = Next;
Count++;
string CommandInsert = $@"INSERT INTO ContactList ([Name], [SurName], [Email], [PNumber]) VALUES
('{Current.Value.Name}', '{Current.Value.SurName}', '{Current.Value.Email}', '{Current.Value.PNumber}')";
using (SqlConnection connection = new SqlConnection(strConnection))
{
connection.Open();
SqlCommand command = new SqlCommand(CommandInsert, connection);
numOfInserted += command.ExecuteNonQuery();
}
}
else
{
Current.Next = new PhoneBook(contact);
Current = Current.Next;
Count++;
string CommandInsert = $@"INSERT INTO ContactList ([Name], [SurName], [Email], [PNumber]) VALUES
('{Current.Value.Name}', '{Current.Value.SurName}', '{Current.Value.Email}', '{Current.Value.PNumber}')";
using (SqlConnection connection = new SqlConnection(strConnection))
{
connection.Open();
SqlCommand command = new SqlCommand(CommandInsert, connection);
numOfInserted += command.ExecuteNonQuery();
}
}
}
static void Main(string[] args)
{
var pb = new PhoneBook();
Random r = new Random();
for (int i = 0; i < 10; i++)
{
pb.Add(new Contact($"A{i}", $"A{i}yan", $"A{i}@mail.ru", $"{r.Next(100000000, 999999999)}"));
}
//pb.Clear();
for (int i = 0; i < pb.Count; i++)
{
Console.WriteLine(pb[i]);
}
pb[4] = new Contact("000000", "00000", "00000", "00000");
Console.WriteLine(pb[4]);
var a = pb.ToArray();
}
public Enumerator(PhoneBook pb)
{
Current = null;
Pb = pb;
}