static void Main(string[] args)
{
BaseparkingContext db = new BaseparkingContext();
GetLinqMessage("task01", LinqTasks.SelectOne(db));
GetLinqMessage("task02", LinqTasks.SelectOneByWhere(db));
GetLinqMessage("task03", LinqTasks.SelectManyByGroup(db));
GetLinqMessage("task04", LinqTasks.SelectOneMany(db));
GetLinqMessage("task05", LinqTasks.SelectOneManyByWhere(db));
string[] data = GetData("Введите ФИО:", "Введите nameFone:");
GetLinqMessage("task06", LinqTasks.InsertOne(data[0], data[1], db));
data = GetData("Введите Carbands:", "Введите numberoffthecar:", "Введите Fio:");
GetLinqMessage("task07", LinqTasks.InsertMany(data[0], data[1], data[2], db));
data = GetData("Введите Fio:");
GetLinqMessage("task08", LinqTasks.DeleteOne(data[0], db));
data = GetData("Введите Carbrands:");
GetLinqMessage("task09", LinqTasks.DeleteMany(data[0], db));
data = GetData("Введите oldName:", "Введите fio", "Введите nameFone");
GetLinqMessage("task10", LinqTasks.UpdateOne(data[0], data[1], data[2], db));
}
/// <summary>
/// Task09.
/// </summary>
public static string DeleteMany(string carbrands, BaseparkingContext db)
{
Car car = db.Cars.Find(db.Cars.Where(c => c.Carbrands == carbrands).FirstOrDefault().Id);
db.Cars.Remove(car);
db.SaveChanges();
return($"Carbrands: {car.Carbrands}, Numberofthecar = {car.Numberofthecar}\n");
}
/// <summary>
/// Task08.
/// </summary>
public static string DeleteOne(string fio, BaseparkingContext db)
{
Owner owner = db.Owners.Find(db.Owners.Where(o => o.Fio == fio).FirstOrDefault().Id);
db.Owners.Remove(owner);
db.SaveChanges();
return($"Fio: {owner.Fio}, NameFone = {owner.NameFone}\n");
}
/// <summary>
/// Task10.
/// </summary>
public static string UpdateOne(string oldFio, string fio, string nameFone, BaseparkingContext db)
{
Owner owner = db.Owners.Find(db.Owners.Where(o => o.Fio == oldFio).FirstOrDefault().Id);
owner.Fio = fio;
owner.NameFone = nameFone;
db.SaveChanges();
return($"Fio: {fio}, NameFone = {nameFone}\n");
}
/// <summary>
/// Task06.
/// </summary>
public static string InsertOne(string fio, string nameFone, BaseparkingContext db)
{
Owner owner = new Owner();
owner.Fio = fio;
owner.NameFone = nameFone;
db.Owners.Add(owner);
db.SaveChanges();
return($"Fio: {fio}, NameFone = {nameFone}\n");
}
/// <summary>
/// Task01.
/// </summary>
public static string SelectOne(BaseparkingContext db)
{
StringBuilder builder = new StringBuilder();
var query = from o in db.Owners
select new
{
o.Fio,
o.NameFone
};
foreach (var entity in query.Take(5))
{
builder.Append(entity + "\n");
}
return(builder.ToString());
}
/// <summary>
/// Task03.
/// </summary>
public static string SelectManyByGroup(BaseparkingContext db)
{
StringBuilder builder = new StringBuilder();
var query = from c in db.Cars
group c by c.Carbrands into n
select new
{
Carbrand = n.Key,
CarbrandCount = n.Count()
};
foreach (var entity in query.Take(5))
{
builder.Append(entity + "\n");
}
return(builder.ToString());
}
/// <summary>
/// Task04.
/// </summary>
public static string SelectOneMany(BaseparkingContext db)
{
StringBuilder builder = new StringBuilder();
var query = from c in db.Cars
join o in db.Owners
on c.OwnersId equals o.Id
select new
{
c.Carbrands,
c.Numberofthecar,
Owner = o.Fio
};
foreach (var entity in query.Take(5))
{
builder.Append(entity + "\n");
}
return(builder.ToString());
}
/// <summary>
/// Task07.
/// </summary>
public static string InsertMany(string carbrands, string numberofthecar, string fio, BaseparkingContext db)
{
Car car = new Car();
car.Carbrands = carbrands;
car.Numberofthecar = numberofthecar;
car.OwnersId = db.Owners.Where(o => o.Fio == fio).FirstOrDefault().Id;
db.Cars.Add(car);
db.SaveChanges();
return($"Carbrands: {carbrands}, Numberofthecar = {numberofthecar}\n");
}
