public void DeleteComand()
{
var leaseTime = (from item in CarsCollection select item.LeaseTime);
foreach (var time in leaseTime)
{
LeaseTime = time;
}
var phoneNumber = (from item in CarsCollection select item.PhoneNumber);
foreach (var number in phoneNumber)
{
PhoneNumber = number;
}
var spaceType = (from item in CarsCollection select item.SpaceType);
foreach (var space in spaceType)
{
SpaceType = space;
}
PayAmountSum = payAmountSum_func();
SqlConnectionCarsHistory history = new SqlConnectionCarsHistory();
history.InsertUserCarRecords(CarNumber, CarRegion, CarSeries, LeaseTime, PhoneNumber, SpaceType, TimeOut, PayAmountSum);
SqlConnectionCar spam = new SqlConnectionCar();
spam.DeleteCar(CarNumber, CarRegion, CarSeries);
CarsCollection = AllItems();
CarNumber = String.Empty;
CarRegion = 0;
CarSeries = String.Empty;
PayAmountSum = String.Empty;
TimeOn = TimeSpan.Zero;
}
private ObservableCollection <Car> AllItems()
{
SqlConnectionCarsHistory spam = new SqlConnectionCarsHistory();
ObservableCollection <Car> carsDB = spam.ReadUsersRecords();
CarsCollection = new ObservableCollection <Car>();
if (carsDB != null)
{
foreach (var item in carsDB)
{
CarsCollection.Add(item);
}
}
return(CarsCollection);
}
private ObservableCollection <Car> GetProducts()
{
SqlConnectionCarsHistory spam = new SqlConnectionCarsHistory();
ObservableCollection <Car> carsDB = spam.GiveUsersRecords(PhoneNumber);
CarsCollection = new ObservableCollection <Car>();
if (carsDB != null)
{
foreach (var item in carsDB)
{
CarsCollection.Add(item);
}
}
return(CarsCollection);
}
