public static List <DriversLicence> LoadDriversLicences()
{
string sql = @"SELECT Id, FirstName, LastName, MiddleName, LicenceNumber, LicenceClass, StreetAddress, City, Province, PostalCode,
Sex, EyeColour, HairColour, DobDay, DobMonth, DobYear, Height, Weight, ExpiryDay, ExpiryMonth, ExpiryYear from dbo.DriversLicencesTable;";
return(DriversLicenceDataAccess.LoadData <DriversLicence>(sql));
}
public static int DeleteDriversLicence(int id)
{
DriversLicence data = new DriversLicence
{
Id = id
};
string sql = @"DELETE FROM dbo.DriversLicencesTable
Where Id=@Id;";
return(DriversLicenceDataAccess.DeleteData(sql, data));
}
public static int UpdateDriversLicence(int id, string firstName, string lastName, string middleName, string licenceNumber, int licenceClass,
string streetAddress, string city, string province, string postalCode, string sex, string eyeColour, string hairColour,
int dobDay, int dobMonth, int dobYear, int height, int weight, int expiryDay, int expiryMonth, int expiryYear)
{
DriversLicence data = new DriversLicence
{
Id = id,
FirstName = firstName,
LastName = lastName,
MiddleName = middleName,
LicenceNumber = licenceNumber,
LicenceClass = licenceClass,
StreetAddress = streetAddress,
City = city,
Province = province,
PostalCode = postalCode,
Sex = sex,
EyeColour = eyeColour,
HairColour = hairColour,
DobDay = dobDay,
DobMonth = dobMonth,
DobYear = dobYear,
Height = height,
Weight = weight,
ExpiryDay = expiryDay,
ExpiryMonth = expiryMonth,
ExpiryYear = expiryYear
};
string sql = @"UPDATE dbo.DriversLicencesTable
SET ID=@Id, FirstName=@FirstName, LastName=@LastName, MiddleName=@MiddleName, LicenceNumber=@LicenceNumber, LicenceClass=@LicenceClass,
StreetAddress=@StreetAddress, City=@City, Province=@Province, PostalCode=@PostalCode, Sex=@Sex, EyeColour=@EyeColour, HairColour=@HairColour,
DobDay=@DobDay, DobMonth=@DobMonth, DobYear=@DobYear, Height=@Height, Weight=@Weight, ExpiryDay=@ExpiryDay, ExpiryMonth=@ExpiryMonth,
ExpiryYear=@ExpiryYear
WHERE Id = @Id;";
return(DriversLicenceDataAccess.SaveData(sql, data));
}
public static int CreateDriversLicence(int id, string firstName, string lastName, string middleName, string licenceNumber, int licenceClass,
string streetAddress, string city, string province, string postalCode, string sex, string eyeColour, string hairColour,
int dobDay, int dobMonth, int dobYear, int height, int weight, int expiryDay, int expiryMonth, int expiryYear)
{
DriversLicence data = new DriversLicence
{
Id = id,
FirstName = firstName,
LastName = lastName,
MiddleName = middleName,
LicenceNumber = licenceNumber,
LicenceClass = licenceClass,
StreetAddress = streetAddress,
City = city,
Province = province,
PostalCode = postalCode,
Sex = sex,
EyeColour = eyeColour,
HairColour = hairColour,
DobDay = dobDay,
DobMonth = dobMonth,
DobYear = dobYear,
Height = height,
Weight = weight,
ExpiryDay = expiryDay,
ExpiryMonth = expiryMonth,
ExpiryYear = expiryYear
};
string sql = @"INSERT INTO dbo.DriversLicencesTable (Id, FirstName, LastName, MiddleName, LicenceNumber, LicenceClass, StreetAddress, City, Province, PostalCode,
Sex, EyeColour, HairColour, DobDay, DobMonth, DobYear, Height, Weight, ExpiryDay, ExpiryMonth, ExpiryYear)
values (@Id, @FirstName, @LastName, @MiddleName, @LicenceNumber, @LicenceClass, @StreetAddress, @City, @Province, @PostalCode,
@Sex, @EyeColour, @HairColour, @DobDay, @DobMonth, @DobYear, @Height, @Weight, @ExpiryDay, @ExpiryMonth, @ExpiryYear);";
return(DriversLicenceDataAccess.SaveData(sql, data));
}
