//Handles addition of vehicle in the database
//No null check for argument since it is done before invokation of function
static public void AddVehInDB(Vehicle veh)
{
CarInsuranceContext context = new CarInsuranceContext();
context.Vehicles.Add(veh);
context.SaveChanges();
}
//Get function for insurances count for specific client in the database
//Returns -1 if client is not found in database
static public int GetInsuranceCountByEgn(string egn)
{
int RetVal = 0;
CarInsuranceContext context = new CarInsuranceContext();
Customer result = (from Cust in context.Customers
where Cust.Egn == egn
select Cust).FirstOrDefault();
if (null != result)
{
List <Insurance> insurances = context.Insurances.ToList();
foreach (Insurance ins in insurances)
{
if (ins.CustomerID == result.CustomerId)
{
RetVal++;
}
}
}
else
{
RetVal = -1;
}
return(RetVal);
}
//Handles addition of insurance in the database
//No null check for argument since it is done before invokation of function
static public void AddInsuranceInDB(Insurance insure)
{
CarInsuranceContext context = new CarInsuranceContext();
context.Insurances.Add(insure);
context.SaveChanges();
}
//Get function for valid insurances for specific car in the database
//No null check for argument since it is done before invokation of function
static public bool CheckForValidInsurancesByVIN(string vin, ref List <Insurance> insurances)
{
bool bRetVal = false;
DateTime CurrDate = DateTime.Now;
CarInsuranceContext context = new CarInsuranceContext();
int vehID = (from Veh in context.Vehicles
where Veh.VIN == vin
select Veh.VehicleId).FirstOrDefault();
if (0 != vehID)
{
List <Insurance> Insurances = (from Insur in context.Insurances
where Insur.VehicleID == vehID &&
DateTime.Compare((DateTime)Insur.DueDate, CurrDate) > 0
select Insur).ToList();
if (Insurances.Any())
{
insurances = Insurances;
}
else
{
insurances = null;
}
bRetVal = true;
}
return(bRetVal);
}
//Handles addition of customer in the database
//No null check for argument since it is done before invokation of function
static public void AddCustInDB(Customer cust)
{
CarInsuranceContext context = new CarInsuranceContext();
context.Customers.Add(cust);
context.SaveChanges();
}
//Get function for insurances for specific client in the database
//No null check for argument since it is done before invokation of function
static public void GetClientInsurances(string egn, ref List <Insurance> ListOfInsurances)
{
CarInsuranceContext context = new CarInsuranceContext();
int clientId = (from Cust in context.Customers
where Cust.Egn == egn
select Cust.CustomerId).FirstOrDefault();
ListOfInsurances = (from Insur in context.Insurances
where Insur.CustomerID == clientId
select Insur).ToList();
}
//Returns average price of the vehicles in the database
static public double CalcAvgPriceOfVehicles()
{
double RetVal = 0.0;
int count = 0;
CarInsuranceContext context = new CarInsuranceContext();
List <Insurance> insurances = (from Insur in context.Insurances
where Insur.InsuranceMoney != 0
select Insur).ToList();
count = insurances.Count();
foreach (Insurance ins in insurances)
{
RetVal = RetVal + (double)ins.InsuranceMoney;
}
return(RetVal / count);
}
//Handles fetching a vehicle from database by egn
//Returns false if no vehicle is fetched
static public bool CheckForVehInDB(string vin, ref Vehicle veh)
{
bool bRetVal = false;
CarInsuranceContext context = new CarInsuranceContext();
if (0 != context.Vehicles.Count())
{
Vehicle result = (from Veh in context.Vehicles
where Veh.VIN == vin
select Veh).FirstOrDefault();
if (null != result)
{
bRetVal = true;
veh = result;
}
}
return(bRetVal);
}
//Handles fetching a customer from database by egn
//Returns false if no customer is fetched
static public bool CheckForOwnerInDB(string egn, ref Customer cust)
{
bool bRetVal = false;
CarInsuranceContext context = new CarInsuranceContext();
if (0 != context.Customers.Count())
{
Customer result = (from Cust in context.Customers
where Cust.Egn == egn
select Cust).FirstOrDefault();
if (null != result)
{
bRetVal = true;
cust = result;
}
}
return(bRetVal);
}
//Returns average age of the vehicles in the database
static public double CalcAvgAgeOfVehicles()
{
double RetVal = 0.0;
int count = 0;
int CurrYear = DateTime.Now.Year;
CarInsuranceContext context = new CarInsuranceContext();
List <Vehicle> vehicles = (from Veh in context.Vehicles
select Veh).ToList();
count = vehicles.Count();
foreach (Vehicle veh in vehicles)
{
RetVal = (double)(RetVal + (CurrYear - veh.Year));
}
return(RetVal / count);
}
//Get function for insurances count in the database
static public int GetInsuranceCount()
{
CarInsuranceContext context = new CarInsuranceContext();
return(context.Insurances.Count());
}
