public void DeleteCoach()
{
try
{
Console.WriteLine("Enter Coach id:");
string id = Console.ReadLine();
int tryint;
while (!int.TryParse(id, out tryint))
{
Console.WriteLine("Incorrect id! Try again ");
id = Console.ReadLine();
}
using (swimmingContext swimdb = new swimmingContext())
{
ICoachManager <Coach> coachManager = new CoachRepository(swimdb);
coachManager.Delete(Convert.ToInt32(id));
Console.WriteLine("Coach is deleted");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void SelectSwimmersByAge()
{
Console.WriteLine("Enter age\n");
string age = Console.ReadLine();
int tryint;
while (!int.TryParse(age, out tryint))
{
Console.WriteLine("Incorrect age! Try again ");
age = Console.ReadLine();
}
try
{
Console.Write("Swimmers:\n");
Console.WriteLine("\t\tId \tFirstName \tSecondName\t\tAge");
using (swimmingContext swimdb = new swimmingContext())
{
ISwimmerManager <Swimmer> swimmerManager = new SwimmerRepository(swimdb);
var swimmers = swimmerManager.GetListByAge(Convert.ToInt32(age));
foreach (Swimmer c in swimmers)
{
Console.WriteLine($"{c.Id,15}{c.FirstName,15} {c.LastName,17} {c.Age,15}");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void UpdateCoach()
{
Console.WriteLine("Enter Coach id:");
string coachId = Console.ReadLine();
int tryint;
while (!int.TryParse(coachId, out tryint))
{
Console.WriteLine("Incorrect id! Try again ");
coachId = Console.ReadLine();
}
Console.Write("Enter Coach name:");
string newName = Console.ReadLine();
while (!IsAllAlphabetic(newName))
{
Console.WriteLine("Incorrect Name! Try again");
newName = Console.ReadLine();
}
Console.Write("Enter Coach surname:");
string newSurname = Console.ReadLine();
while (!IsAllAlphabetic(newSurname))
{
Console.WriteLine("Incorrect Surname! Try again");
newSurname = Console.ReadLine();
}
Console.Write("Enter Coach work experience:");
string newWorkExperience = Console.ReadLine();
while ((!int.TryParse(newWorkExperience, out tryint)) || (!WorkExperienceValidationAttribute.IsValidCoachExperience(Convert.ToInt32(newWorkExperience))))
{
Console.WriteLine("Incorrect Work Experience! Try again ");
newWorkExperience = Console.ReadLine();
}
try
{
Coach coach = new Coach {
FirstName = newName, LastName = newSurname, WorkExperience = Convert.ToInt32(newWorkExperience)
};
using (swimmingContext swimdb = new swimmingContext())
{
ICoachManager <Coach> coachManager = new CoachRepository(swimdb);
coachManager.Update(Convert.ToInt32(coachId), coach);
Console.WriteLine("Coach is updated");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void AddSwimmwer()
{
Console.Write("Enter Swimmer name:");
string swimmerName = Console.ReadLine();
while (!IsAllAlphabetic(swimmerName))
{
Console.WriteLine("Incorrect Name! Try again");
swimmerName = Console.ReadLine();
}
Console.Write("Enter Swimmer surname:");
string swimmerSurname = Console.ReadLine();
while (!IsAllAlphabetic(swimmerSurname))
{
Console.WriteLine("Incorrect Surname! Try again");
swimmerSurname = Console.ReadLine();
}
Console.Write("Enter Swimmer age:");
string age = Console.ReadLine();
int tryint;
while ((!int.TryParse(age, out tryint)) || (!AgeValidationAttribute.IsValidSwimmerAge(Convert.ToInt32(age))))
{
Console.WriteLine("Incorrect Age! Try again ");
age = Console.ReadLine();
}
Console.Write("Enter Coach Id:");
string swimmerCoachId = Console.ReadLine();
while (!int.TryParse(swimmerCoachId, out tryint))
{
Console.WriteLine("Incorrect Id! Try again ");
swimmerCoachId = Console.ReadLine();
}
try
{
Swimmer swimmer = new Swimmer {
FirstName = swimmerName, LastName = swimmerSurname, Age = Convert.ToInt32(age), CoachId = Convert.ToInt32(swimmerCoachId)
};
using (swimmingContext swimdb = new swimmingContext())
{
ISwimmerManager <Swimmer> swimmerManager = new SwimmerRepository(swimdb);
swimmerManager.Add(swimmer);
Console.WriteLine("Swimmer is added");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void SelectTraining()
{
try
{
using (swimmingContext db = new swimmingContext())
{
ITrainingsSwimmersSwimStyleManager <TrainingsSwimmersSwimStyle> swimStyleManager = new TrainingSwimmerSwimStyleRepository(db);
var traininings = swimStyleManager.GetView();
Console.WriteLine("TrainingId\tName\t\tSurname\t\tDate\t\t\tDistance\t\tStyle");
foreach (var t in traininings)
{
Console.WriteLine("{0,10} {1,15} {2,15} {3,20} {4,15} {5,15}", t.TrainingId, t.FirstName, t.LastName, t.TrainingDate, t.Style, t.Distance);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void UpdateDistance()
{
Console.WriteLine("Enter Training id:");
string trainingId = Console.ReadLine();
int tryint;
while (!int.TryParse(trainingId, out tryint))
{
Console.WriteLine("Incorrect id! Try again ");
trainingId = Console.ReadLine();
}
Console.Write("Enter new distance:");
string newDistance = Console.ReadLine();
while ((!int.TryParse(newDistance, out tryint)) || (!DistanceValidationAttribute.IsValidDistance(Convert.ToInt32(newDistance))))
{
Console.WriteLine("Incorrect distance! Try again ");
newDistance = Console.ReadLine();
}
try
{
Training training = new Training {
Distance = Convert.ToInt32(newDistance)
};
using (swimmingContext swimdb = new swimmingContext())
{
ITrainingManager <Training> trainingManager = new TrainingRepository(swimdb);
trainingManager.Update(Convert.ToInt32(trainingId), training);
Console.WriteLine("Distance is updated");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void SelectCoaches()
{
try
{
Console.Write("Coaches:\n");
Console.WriteLine("\tCoach Id \tFirstName \tSecondName\tWorkExperience");
using (swimmingContext swimdb = new swimmingContext())
{
ICoachManager <Coach> coachManager = new CoachRepository(swimdb);
var coaches = coachManager.GetList();
foreach (Coach c in coaches)
{
Console.WriteLine($"{c.Id,15}{c.FirstName,15} {c.LastName,17} {c.WorkExperience,15}");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void SelectSwimStyles()
{
try
{
Console.Write("Swimming Styles:\n");
Console.WriteLine("\tId \tStyle Name ");
using (swimmingContext swimdb = new swimmingContext())
{
ISwimStyleManager <SwimStyle> swimStyleManager = new SwimStyleRepository(swimdb);
var swimStyles = swimStyleManager.GetList();
foreach (SwimStyle c in swimStyles)
{
Console.WriteLine($"{c.Id,10} {c.StyleName,15}");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void SelectSwimmers()
{
try
{
Console.Write("Swimmers:\n");
Console.WriteLine("\t\tId \tFirstName \tSecondName\t\tAge");
using (swimmingContext swimdb = new swimmingContext())
{
ISwimmerManager <Swimmer> swimmerManager = new SwimmerRepository(swimdb);
var swimmers = swimmerManager.GetList();
foreach (Swimmer c in swimmers)
{
Console.WriteLine($"{c.Id,15}{c.FirstName,15} {c.LastName,17} {c.Age,15}");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public SwimmerRepository(swimmingContext context)
{
_context = context;
}
public TrainingSwimmerSwimStyleRepository(swimmingContext context)
{
_context = context;
}
public void AddTraining()
{
int tryint;
Console.Write("Enter Swimmer Id:");
string swimmertrainingId = Console.ReadLine();
while (!int.TryParse(swimmertrainingId, out tryint))
{
Console.WriteLine("Incorrect Id! Try again ");
swimmertrainingId = Console.ReadLine();
}
Console.Write("Enter Swim Style Id:");
string swimStyleId = Console.ReadLine();
while (!int.TryParse(swimStyleId, out tryint))
{
Console.WriteLine("Incorrect Id! Try again ");
swimStyleId = Console.ReadLine();
}
string trainingDate = Console.ReadLine();
DateTime temp;
while (!DateTime.TryParse(trainingDate, out temp))
{
Console.WriteLine("Incorrect Date! Try again ");
trainingDate = Console.ReadLine();
}
string distance = Console.ReadLine();
while (!int.TryParse(distance, out tryint))
{
Console.WriteLine("Incorrect Distance! Try again ");
distance = Console.ReadLine();
}
try
{
Training training = new Training
{
SwimmerId = Convert.ToInt32(swimmertrainingId),
SwimStyleId = Convert.ToInt32(swimStyleId),
TrainingDate = Convert.ToDateTime(trainingDate),
Distance = Convert.ToInt32(distance)
};
using (swimmingContext swimdb = new swimmingContext())
{
ITrainingManager <Training> trainingManager = new TrainingRepository(swimdb);
trainingManager.Add(training);
Console.WriteLine("Training is added");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public TrainingRepository(swimmingContext context)
{
_context = context;
}
public CoachRepository(swimmingContext context)
{
_context = context;
}
