public static ArrayList FiguresInfo()
{
ArrayList all = new ArrayList();
all.AddRange(ReadFiguresFromDB.ReadAllTriangles(connect));
all.AddRange(ReadFiguresFromDB.ReadAllSquares(connect));
all.AddRange(ReadFiguresFromDB.ReadAllRectangles(connect));
all.AddRange(ReadFiguresFromDB.ReadAllRhombs(connect));
all.AddRange(ReadFiguresFromDB.ReadAllParallelograms(connect));
all.AddRange(ReadFiguresFromDB.ReadAllCubes(connect));
all.AddRange(ReadFiguresFromDB.ReadAllPrisms(connect));
all.AddRange(ReadFiguresFromDB.ReadAllParallelepipeds(connect));
all.AddRange(ReadFiguresFromDB.ReadAllPyramids(connect));
return(all);
}
public static void TopicParallelepiped(DataBase db)
{
Console.Clear();
Console.WriteLine("1 - Add new parallelepiped into the table:");
Console.WriteLine("2 - Show all parallelepipeds from the table");
Console.WriteLine("3 - Edit parallelepiped by Id");
Console.WriteLine("4 - Delete parallelepiped by Id");
Console.WriteLine("5 - Return back");
Console.Write("\nPlease make your choice..");
int choice1 = int.Parse(Console.ReadLine());
switch (choice1)
{
case 1:
Console.Clear();
Parallelepiped prll = SetParallelepiped(out name, out type, out a, out b, out h, out area, out volume, out tops, out edges, out sides);
try
{
Console.ForegroundColor = ConsoleColor.Green;
result = db.Add($"\n\nInsert into Parallelepipeds([Name],[Type],[A],[B],[H],[Volume],[Area],[Tops],[Edges],[Sides])" +
$"values('{name}','{type}','{a}','{b}','{h}','{volume}','{area}','{tops}','{edges}','{sides}')");
Console.WriteLine(result);
Console.ResetColor();
Pause();
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(ex.Message);
Console.ResetColor();
Pause();
}
break;
case 2:
Console.Clear();
string conn = ConfigurationManager.ConnectionStrings["connection"].ConnectionString;
List <Parallelepiped> list = ReadFiguresFromDB.ReadAllParallelepipeds(conn);
for (int i = 0; i < list.Count; i++)
{
Console.WriteLine(new string('-', 120));
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine($"\n{i + 1} Parallelepiped:\n");
Console.ForegroundColor = RandColors()[rand.Next(0, 5)];
Console.WriteLine(list[i]);
Console.ResetColor();
Console.WriteLine("\n" + new string('-', 120));
}
Pause();
break;
case 3:
Console.Write("Enter any id of parallelepiped to Update: ");
int editId = int.Parse(Console.ReadLine());
Parallelepiped editPrll = SetParallelepiped(out name, out type, out a, out b, out h, out area, out volume, out tops, out edges, out sides);
string editQuery = $"Update Parallelepipeds SET Name='{name}',Type='{type}',A='{a}', B='{b}', H='{h}', Volume='{volume}', Area='{area}' where Id={editId}";
try
{
resultInt = db.Update(editQuery);
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(ex.Message);
Console.ResetColor();
Pause();
}
if (resultInt == 1)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("\nParallelepiped has updated successfull!!!");
Console.ResetColor();
Pause();
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"\nThe method of Update() return {resultInt}\nSomething went wrong...Try to fix this!");
Console.ResetColor();
Pause();
}
break;
case 4:
Console.Write("Enter any id of parallelepiped to Delete from the table: ");
int deleteId = int.Parse(Console.ReadLine());
string delQuery = $"Delete from Parallelepipeds where Id={deleteId}";
try
{
resultInt = db.Delete(delQuery);
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(ex.Message);
Console.ResetColor();
Pause();
}
if (resultInt == 1)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("\nParallelepiped has deleted successfully!!!");
Console.ResetColor();
Pause();
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"\nThe method of Delete() return {result}\nSomething went wrong...Try to fix this!");
Console.ResetColor();
Pause();
}
break;
case 5: break;
}
}
