public int daysRentRecueByPlate(String plate)
{
command = new SqlCommand();
connection = new DAOConnection();
command.CommandText = "select * from locadora.dbo.Rent where placa = @placa";
command.Parameters.AddWithValue("@placa", plate);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
while (datareader.Read())
{
int daodias = (int)datareader["dias"];
connection.disconnect();
return(daodias);
}
}
connection.disconnect();
this.mensagem = "encontrado com sucesso";
return(0);
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
return(0);
}
}
public Client rescueCPF(string cpf)
{
connection = new DAOConnection();
command = new SqlCommand();
command.CommandText = "select * from locadora.dbo.Client where CPF = @CPF";
command.Parameters.AddWithValue("@CPF", cpf);
try
{
command.Connection = connection.connect();
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
while (datareader.Read())
{
String daonome = (string)datareader["Name"];
String daocpf = (string)datareader["Name"];
connection.disconnect();
Client c = new Client(daocpf, daonome);
return(c);
}
}
connection.disconnect();
return(null);
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
return(null);
}
}
public void updateDailyVehiclesByPlate(String plate, double value)
{
command = new SqlCommand();
connection = new DAOConnection();
command.CommandText = "update locadora.dbo.Vehicle set valordiaria = @valordiaria where placa = @placa";
command.Parameters.AddWithValue("@placa", plate);
command.Parameters.AddWithValue("@valordiaria", value);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
}
}
public Rent updateDiasByPlate(String plate, int day)
{
command = new SqlCommand();
connection = new DAOConnection();
command.CommandText = "update locadora.dbo.Rent set dias = @dias where placa = @placa";
command.Parameters.AddWithValue("@placa", plate);
command.Parameters.AddWithValue("@dias", day);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
while (datareader.Read())
{
String daoplaca = (string)datareader["placa"];
String daocpf = (string)datareader["CPF"];
int daodias = (int)datareader["dias"];
connection.disconnect();
Rent r = new Rent(daocpf, daoplaca, daodias);
return(r);
}
}
connection.disconnect();
this.mensagem = "encontrado com sucesso";
return(null);
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
return(null);
}
}
public void save(Rent rent)
{
command = new SqlCommand();
connection = new DAOConnection();
command.CommandText = "insert into locadora.dbo.Rent(CPF,placa,dias) values (@CPF,@placa,@dias)";
command.Parameters.AddWithValue("CPF", rent.CPF);
command.Parameters.AddWithValue("placa", rent.Placa);
command.Parameters.AddWithValue("dias", rent.Dias);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
this.mensagem = "cadastraado com sucesso";
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
}
}
public void deleteAll()
{
connection = new DAOConnection();
command = new SqlCommand();
command.CommandText = "delete from locadora.dbo.Client";
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
this.mensagem = "data delete";
}
catch (SqlException)
{
this.mensagem = "erro ao se conectar banco de dados";
}
}
public void deletebyCPF(String cpf)
{
connection = new DAOConnection();
command = new SqlCommand();
command.CommandText = "delete from locadora.dbo.Client where CPF = @CPF";
command.Parameters.AddWithValue("@CPF", cpf);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
this.mensagem = "Client delete";
}
catch (SqlException)
{
this.mensagem = "erro ao se conectar banco de dados";
}
}
public void save(Client client)
{
connection = new DAOConnection();
command = new SqlCommand();
command.CommandText = "insert into locadora.dbo.Client(CPF,Name) values (@CPF,@Name)";
command.Parameters.AddWithValue("CPF", client.CPF);
command.Parameters.AddWithValue("Name", client.Name);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
}
catch (SqlException)
{
this.mensagem = "erro ao se conectar banco de dados";
}
}
public void deleteByPlate(String plate)
{
connection = new DAOConnection();
command = new SqlCommand();
command.CommandText = "delete from locadora.dbo.Vehicle where placa = @placa";
command.Parameters.AddWithValue("@valordiaria", plate);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
this.mensagem = "apagado";
}
catch (SqlException)
{
this.mensagem = "erro ao se conectar banco de dados";
}
}
public void updateNameClient(String cpf, String name)
{
connection = new DAOConnection();
command = new SqlCommand();
command.CommandText = "update locadora.dbo.Client set Name = @Name where CPF = @CPF";
command.Parameters.AddWithValue("CPF", cpf);
command.Parameters.AddWithValue("Name", name);
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
connection.disconnect();
this.mensagem = "atualizado com sucesso";
}
catch (SqlException)
{
this.mensagem = "erro ao se conectar banco de dados";
}
}
public Vehicles recueByPlate(String plate)
{
command = new SqlCommand();
connection = new DAOConnection();
//comando sql ---
command.CommandText = "select * from locadora.dbo.Vehicle where placa = @placa";
//parametros
command.Parameters.AddWithValue("@placa", plate);
try
{ //conectar com baNCO de dados
command.Connection = connection.connect();
//executar comandos
command.ExecuteNonQuery();
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
while (datareader.Read())
{
String daoplaca = (string)datareader["placa"];
String daomodelo = (string)datareader["modelo"];
String daomarca = (string)datareader["marca"];
int daoano = (int)datareader["ano"];
double daovaloravaliado = (double)datareader["valoravaliado"];
double daovalordiaria = (double)datareader["valordiaria"];
int daocategoriacarro = (int)datareader["categoriacarro"];
int daocarga = (int)datareader["carga"];
int daocilindrada = (int)datareader["cilindrada"];
int daopassageiro = (int)datareader["passageiro"];
int daodiscriminador = (int)datareader["discriminador"];
if (daodiscriminador == 1)
{
connection.disconnect();
Vehicles motorcycle = new Motorcycle(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daocilindrada);
return(motorcycle);
}
else if (daodiscriminador == 2)
{
connection.disconnect();
Vehicles car = new Car(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daocategoriacarro);
return(car);
}
else if (daodiscriminador == 3)
{
connection.disconnect();
Vehicles bus = new Bus(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daopassageiro);
return(bus);
}
else if (daodiscriminador == 4)
{
connection.disconnect();
Vehicles truck = new Truck(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daocarga);
return(truck);
}
else
{
connection.disconnect();
return(null);
}
}
}
connection.disconnect();
return(null);
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
return(null);
}
}
public List <Vehicles> RescueAllVehicle()
{
command = new SqlCommand();
connection = new DAOConnection();
command.CommandText = "select * from locadora.dbo.Vehicle";
List <Vehicles> vehiclelist = new List <Vehicles>();
try
{
command.Connection = connection.connect();
command.ExecuteNonQuery();
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
while (datareader.Read())
{
String daoplaca = (string)datareader["placa"];
String daomodelo = (string)datareader["modelo"];
String daomarca = (string)datareader["marca"];
int daoano = (int)datareader["ano"];
double daovaloravaliado = (double)datareader["valoravaliado"];
double daovalordiaria = (double)datareader["valordiaria"];
int daocategoriacarro = (int)datareader["categoriacarro"];
int daocarga = (int)datareader["carga"];
int daocilindrada = (int)datareader["cilindrada"];
int daopassageiro = (int)datareader["passageiro"];
int daodiscriminador = (int)datareader["discriminador"];
if (daodiscriminador == 1)
{
Vehicles motorcycle = new Motorcycle(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daocilindrada);
vehiclelist.Add(motorcycle);
}
else if (daodiscriminador == 2)
{
Vehicles car = new Car(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daocategoriacarro);
vehiclelist.Add(car);
}
else if (daodiscriminador == 3)
{
Vehicles bus = new Bus(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daopassageiro);
vehiclelist.Add(bus);
}
else if (daodiscriminador == 4)
{
Vehicles truck = new Truck(daomarca, daomodelo, daoano, daovaloravaliado, daovalordiaria, daoplaca, daocarga);
vehiclelist.Add(truck);
}
else
{
connection.disconnect();
return(null);
}
}
}
connection.disconnect();
return(vehiclelist);
}
catch (SqlException)
{
connection.disconnect();
this.mensagem = "erro ao se conectar banco de dados";
return(null);
}
}
public void save(Vehicles vehicle)
{
int categoriaCarro = 0;
int cargaCaminhao = 0;
int cilindradas = 0;
int passageiros = 0;
connection = new DAOConnection();
command = new SqlCommand();
if (vehicle is Car)
{
categoriaCarro = ((Car)vehicle).CategoriaCarro;
}
if (vehicle is Motorcycle)
{
cilindradas = ((Motorcycle)vehicle).Cilindradas;
}
if (vehicle is Truck)
{
cargaCaminhao = ((Truck)vehicle).CapacidadeCarga;
}
if (vehicle is Bus)
{
passageiros = ((Bus)vehicle).CapacidadePassageiro;
}
//comando sql ---
command.CommandText = "insert into locadora.dbo.Vehicle (placa,marca, modelo, ano,valoravaliado,valordiaria,categoriacarro,carga,cilindrada,passageiro,discriminador) " +
"values (@placa,@marca,@modelo,@ano,@valoravaliado,@valordiaria,@categoriacarro,@carga,@cilindrada,@passageiro,@discriminador)";
//parametros
command.Parameters.AddWithValue("placa", vehicle.Placa);
command.Parameters.AddWithValue("marca", vehicle.Marca);
command.Parameters.AddWithValue("modelo", vehicle.Modelo);
command.Parameters.AddWithValue("ano", vehicle.AnoFabricacao);
command.Parameters.AddWithValue("valoravaliado", vehicle.ValorAvaliadoDoBem);
command.Parameters.AddWithValue("valordiaria", vehicle.ValorDiaria);
command.Parameters.AddWithValue("categoriacarro", categoriaCarro);
command.Parameters.AddWithValue("carga", cargaCaminhao);
command.Parameters.AddWithValue("cilindrada", cilindradas);
command.Parameters.AddWithValue("passageiro", passageiros);
command.Parameters.AddWithValue("discriminador", vehicle.Tipo);
try
{ //conectar com baNCO de dados
command.Connection = connection.connect();
//executar comandos
command.ExecuteNonQuery();
//desconectar
connection.disconnect();
//mostrar mensagem de erro ou sucesso
this.mensagem = "cadastraado com sucesso";
}
catch (SqlException)
{
this.mensagem = "erro ao se conectar banco de dados";
}
finally
{
connection.disconnect();
}
}