Program.cs

//1.Group yarat
/*2.Grouplari goster
3.Group sil
4.Student yarat
5.Studentleri goster
6.Student sil*/

using Microsoft.EntityFrameworkCore;
using ormStudent;

using AppDBContext context = new AppDBContext();

START:
Console.WriteLine(" ");
Console.WriteLine("1.Group yarat");
Console.WriteLine("2.Grouplari goster");
Console.WriteLine("3.Group sil");
Console.WriteLine("4.Student yarat");
Console.WriteLine("5.Studentleri goster");
Console.WriteLine("6.Student sil");
Console.WriteLine(" ");
string choice = Console.ReadLine();

Console.Clear();

switch (choice)
{
    case "1":
        Console.Write("Yeni yaradacaginiz Groupun adi:");
        string gName = Console.ReadLine();
        Group groups = new()
        {
            Name = gName
        };

        context.Groups.Add(groups);
        var result=context.SaveChanges();
        if (result > 0)
        {
            Console.WriteLine("Group ugurla yaradildi");
        }
        goto START;
        break;


    case "2":
        ShowAllGroup(context);
        goto START;
        break;

    case "3":
    IdGroupDelete:
        ShowAllGroup(context);
        Console.Write("Silmek istediyiniz ID-ni secin:");
        string deleteIdGroup = Console.ReadLine();
        bool isDeletedGroup = int.TryParse(deleteIdGroup, out int idGroup);
        if (!isDeletedGroup)
        {
            Console.WriteLine("Duzgun deyer daxil et!");
            goto IdGroupDelete;
        }
        Group deletedGroup = context.Groups.FirstOrDefault(s => s.Id == idGroup);

        if (deletedGroup == null)
        {
            Console.WriteLine("Silmek istediyiniz Group movcud deyil");
            break;
        }

        context.Groups.Remove(deletedGroup);
        var deleteGroup = context.SaveChanges();
        if (deleteGroup > 0)
        {
            Console.WriteLine("Group ugurla silindi");
        }
        goto START;
        break;



    case "4":
sNameInput:
    Console.Write("Yeni yaradacaginiz Studentin adi:");
    string sName = Console.ReadLine();
    if (sName == null || sName.Length < 3)
    {
        Console.WriteLine("Duzgun deyer daxil et!");
        goto sNameInput;
    }


    Console.Write("Yeni yaradacaginiz Studentin yasi:");
    int age = Convert.ToInt32(Console.ReadLine());


gradeInput:
    Console.Write("Yeni yaradacaginiz Studentin qiymeti:");
    string grade = Console.ReadLine();
    var isParsed = decimal.TryParse(grade, out decimal DCgrade);
    if (!isParsed)
    {
        Console.WriteLine("Duzgun deyer daxil et!");
        goto gradeInput;
    }



groupIdInput:
    var gr = context.Groups.ToList();
    foreach (var item in gr)
    {
        Console.WriteLine(item);
    }
    Console.Write("Istediyiniz GroupsID-ni daxil edin:");
    string groupIdInput = Console.ReadLine();
    var isParsedGroupId = int.TryParse(groupIdInput, out int DCgroupId);
    if (!isParsedGroupId)
    {
        Console.WriteLine("Duzgun deyer daxil et!");
        goto groupIdInput;
    }

    bool isExistGroup = context.Groups.Any(g => g.Id == DCgroupId);
    if (!isExistGroup)
    {
        Console.WriteLine("Duzgun deyer daxil et!");
        goto groupIdInput;
    }


    Student students = new()
    {
        Name = sName,
        Age = age,
        Grade = DCgrade,
        GroupsId = DCgroupId
    };

    context.Students.Add(students);
    var yekun = context.SaveChanges();
    if (yekun > 0)
    {
        Console.WriteLine("Student ugurla elave edildi");
    }
        goto START;
    break;

case "5":
    ShowAll(context);
        goto START;
    break;

case "6":
IDinput:
    ShowAll(context);
    Console.Write("Silmek istediyiniz ID-ni secin:");
    string deleteIdInput = Console.ReadLine();
    bool isDeleted = int.TryParse(deleteIdInput, out int id);
    if (!isDeleted)
    {
        Console.WriteLine("Duzgun deyer daxil et!");
        goto IDinput;
    }
    Student deletedStudent = context.Students.FirstOrDefault(s => s.Id == id);

    if (deletedStudent == null)
    {
        Console.WriteLine("Silmek istediyiniz Student movcud deyil");
        break;
    }

    context.Students.Remove(deletedStudent);
    var deleteYekun = context.SaveChanges();
    if (deleteYekun > 0)
    {
        Console.WriteLine("Student ugurla silindi");
    }
        goto START;
    break;
}

static void ShowAll(AppDBContext context)
{
    var forStudents = context.Students.Include(x => x.Groups).ToList();
    foreach (var item in forStudents)
    {
        Console.WriteLine(item);
    }
}

static void ShowAllGroup(AppDBContext context)
{
    var forGroup = context.Groups.ToList();
    foreach (var item in forGroup)
    {
        Console.WriteLine(item);
    }
}