//Get bought vignette by car from db
public BoughtVignette GetByCar(Car car)
{
BoughtVignette boughtVignettes = null;
using (var context = new VignetteContext())
{
boughtVignettes = context.BoughtVignettes.FirstOrDefault(b => b.Id_Car == car.Id);
}
return(boughtVignettes);
}
//Take date
public void takeData(BoughtVignette boughtVignettes, User user, Car car)
{
using (var context = new VignetteContext())
{
context.Users.Add(user);
car.user = user;
car.Id_User = user.Id;
context.Cars.Add(car);
boughtVignettes.Id_Car = car.Id;
boughtVignettes.cars = car;
context.BoughtVignettes.Add(boughtVignettes);
context.SaveChanges();
}
}
//Deleated information from base
public void DeleteData(BoughtVignette boughtVignettes, User user, Car car)
{
using (var context = new VignetteContext())
{
User removeUser = context.Users.FirstOrDefault(u => u.FirstName == user.FirstName &&
u.LastName == user.LastName && u.PersonalCode == user.PersonalCode);
Car removeCar = context.Cars.FirstOrDefault(c => c.Id_User == removeUser.Id &&
c.CarRegistration == car.CarRegistration);
BoughtVignette removeBoughtVignette = context.BoughtVignettes.FirstOrDefault(b => b.Id_Car == removeCar.Id &&
b.VignettesId == boughtVignettes.VignettesId);
//car.user = user;
//car.Id_User = user.Id;
//boughtVignettes.Id_Car = car.Id;
//boughtVignettes.cars = car;
context.Users.Remove(removeUser);
context.Cars.Remove(removeCar);
context.BoughtVignettes.Remove(removeBoughtVignette);
context.SaveChanges();
}
}
private void button2_Click(object sender, EventArgs e)
{
Car car = new Car();
User user = new User();
BoughtVignette boughtVignette = new BoughtVignette();
Vignettes vignettes = new Vignettes();
car.CarRegistration = textBox3.Text.ToString();
user.FirstName = textBox1.Text.ToString();
user.LastName = textBox2.Text.ToString();
user.PersonalCode = textBox5.Text.ToString();
var date = dateTimePickerActivateDate.Value;
switch (comboBox1.SelectedItem.ToString())
{
case "Уикенд - 10лв.":
{
boughtVignette.VignettesId = 1;
date = date.AddDays(2);
} break;
case "Седмична - 15лв.":
{
boughtVignette.VignettesId = 2;
date = date.AddDays(7);
} break;
case "Месечна - 30лв.":
{
boughtVignette.VignettesId = 3;
date = date.AddMonths(1);
} break;
case "Тримесечна - 54лв.":
{
boughtVignette.VignettesId = 4;
date = date.AddMonths(3);
} break;
case "Годишна - 97лв.":
{
boughtVignette.VignettesId = 5;
date = date.AddYears(1);
} break;
default:
break;
}
boughtVignette.DateTime = date;
var vinneteSurvices = new VinetteSurvices();
vinneteSurvices.takeData(boughtVignette, user, car);
this.Close();
MessageBox.Show("Вие успешно закупихте винетка!", "BG TOL SISTEM", MessageBoxButtons.OK);
Form1 form1 = new Form1();
form1.Show();
}
