public void Show()
{
try
{
var query = connection.CreateCommand();
query.Connection = connection;
query.CommandText = "SELECT * FROM Contact";
using (var reader = query.ExecuteReader())
{
System.Console.WriteLine("| First Name | Last Name | Phone |");
while (reader.Read())
{
System.Console.WriteLine($"| {reader[0]} | {reader[1]} | {reader[2]} |");
}
}
CoreMethods.ChoiseMethod();
}
catch (Exception e)
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine(e.ToString());
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
}
public void Search(string[] com)
{
try
{
var query = connection.CreateCommand();
query.Connection = connection;
switch (com[1])
{
case "firstname":
query.CommandText = "SELECT * FROM Contact WHERE FirstName = $val";
break;
case "lastnamr":
query.CommandText = "SELECT * FROM Contact WHERE LastName = $val";
break;
case "phone":
query.CommandText = "SELECT * FROM Contact WHERE Phone = $val";
break;
default:
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine("Wat ?! ...");
Console.ResetColor();
CoreMethods.ChoiseMethod();
break;
}
query.Parameters.AddWithValue("$val", com[2]);
using (var reader = query.ExecuteReader())
{
System.Console.WriteLine("| First Name | Last Name | Phone |");
while (reader.Read())
{
System.Console.WriteLine($"| {reader[0]} | {reader[1]} | {reader[2]} |");
}
}
CoreMethods.ChoiseMethod();
}
catch (Exception e)
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine(e.ToString());
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
}
public void Remove(string[] com)
{
try
{
var query = connection.CreateCommand();
query.Connection = connection;
query.CommandText = "DELETE FROM Contact WHERE Phone = $p;";
query.Parameters.AddWithValue("$p", int.Parse(com[1]));
query.ExecuteNonQuery();
Console.ForegroundColor = ConsoleColor.Green;
System.Console.WriteLine("Success !!");
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
catch (Exception e)
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine(e.ToString());
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
}
public void Edit(string[] com)
{
try
{
var query = connection.CreateCommand();
query.Connection = connection;
query.CommandText = "UPDATE Contact SET FirstName = $fn , LastName = $ln WHERE Phone = $p;";
query.Parameters.AddWithValue("$fn", com[2]);
query.Parameters.AddWithValue("$ln", com[3]);
query.Parameters.AddWithValue("$p", int.Parse(com[1]));
query.ExecuteNonQuery();
Console.ForegroundColor = ConsoleColor.Green;
System.Console.WriteLine("Success !!");
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
catch (Exception e)
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine(e.ToString());
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
}
public void Create(string[] com)
{
try
{
var query = connection.CreateCommand();
query.Connection = connection;
query.CommandText = "INSERT INTO Contact (FirstName,LastName,Phone) VALUES($fn,$ln,$p);";
query.Parameters.AddWithValue("$fn", com[1]);
query.Parameters.AddWithValue("$ln", com[2]);
query.Parameters.AddWithValue("$p", int.Parse(com[3]));
query.ExecuteNonQuery();
Console.ForegroundColor = ConsoleColor.Green;
System.Console.WriteLine("Success !!");
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
catch (Exception e)
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine(e.ToString());
Console.ResetColor();
CoreMethods.ChoiseMethod();
}
}