public frmVincularVeiculo(Form frm, Enumeradores.TipoOperacao tpo, BindingSource bnd)
{
InitializeComponent();
try
{
frmGrid = frm;
tpOperacao = tpo;
bndVeiculoGrid = bnd;
MdiParent = frmGrid.MdiParent;
if (tpOperacao.Equals(Enumeradores.TipoOperacao.Insert))
{
VincularVeiculoDTObindingSource.AddNew();
txtVeiculo.DataBindings.Clear();
txtCliente.DataBindings.Clear();
}
else
{
int id_veiculo;
vincularveiculoDTO = (VincularVeiculoDTO)bndVeiculoGrid.Current;
id_veiculo = Convert.ToInt32(vincularveiculoGL.GetIdVeiculo(vincularveiculoDTO.Veiculo));
VincularVeiculoDTObindingSource.DataSource = vincularveiculoGL.GetVincularVeiculo(id_veiculo);
}
vincularveiculoDTO = (VincularVeiculoDTO)VincularVeiculoDTObindingSource.Current;
vincularveiculoDTOVersaoOriginal = new VincularVeiculoDTO(vincularveiculoDTO);
GetFoto();
}
catch
{
throw;
}
}
public List <VincularVeiculoDTO> GetGridVeiculoVinc(string campo, string valorPesquisa)
{
try
{
dbcommand = db.GetStoredProcCommand("GetGridVeiculoVinc");
db.AddInParameter(dbcommand, "campo", DbType.String, campo);
db.AddInParameter(dbcommand, "valorPesquisa", DbType.String, valorPesquisa);
using (IDataReader DR = (Transaction == null ? db.ExecuteReader(dbcommand) : db.ExecuteReader(dbcommand, Transaction)))
{
List <VincularVeiculoDTO> list = new List <VincularVeiculoDTO>();
while (DR.Read())
{
VincularVeiculoDTO vinc = new VincularVeiculoDTO();
vinc.Id = int.Parse(DR["id"].ToString());
vinc.Veiculo = DR["veiculo"].ToString();
vinc.Cliente = DR["cliente"].ToString();
vinc.Placa = DR["placa"].ToString();
list.Add(vinc);
}
return(list);
}
}
catch
{
throw;
}
}
public VincularVeiculoDTO GetVeiculoVinc(int id)
{
try
{
dbcommand = db.GetStoredProcCommand("GetVeiculoVinc");
db.AddInParameter(dbcommand, "@veiculo", DbType.Int32, id);
using (IDataReader DR = (Transaction == null ? db.ExecuteReader(dbcommand) : db.ExecuteReader(dbcommand, Transaction)))
{
DR.Read();
VincularVeiculoDTO vinc = new VincularVeiculoDTO();
vinc.Id = int.Parse(DR["id"].ToString());
vinc.Id_Veiculo = int.Parse(DR["id_veiculo"].ToString());
vinc.Veiculo = GetVeiculo(vinc.Id_Veiculo);
vinc.Id_Cliente = int.Parse(DR["id_cliente"].ToString());
vinc.Cliente = GetCliente(vinc.Id_Cliente);
vinc.Placa = DR["placa"].ToString();
vinc.Obs = DR["obs"].ToString();
vinc.Modelo = DR["modelo"].ToString();
vinc.Num_chassi = DR["num_chassi"].ToString();
vinc.Km = int.Parse(DR["Km"].ToString());
vinc.Ano = DR["ano"].ToString();
vinc.Cor = DR["cor"].ToString();
vinc.Foto = (Convert.IsDBNull(DR["foto"]) ? null : (byte[])DR["foto"]);
return(vinc);
}
}
catch
{
throw;
}
}
public List <VincularVeiculoDTO> GetPlacasCliente(int id)
{
List <VincularVeiculoDTO> vinculos = new List <VincularVeiculoDTO>();
try
{
dbcommand = db.GetSqlStringCommand("Select id,placa,id_veiculo FROM public.veiculo_vinc" +
" WHERE" +
" id_cliente = @id;");
db.AddInParameter(dbcommand, "@id", DbType.Int32, id);
using (IDataReader DR = (Transaction == null ? db.ExecuteReader(dbcommand) : db.ExecuteReader(dbcommand, Transaction)))
{
while (DR.Read())
{
VincularVeiculoDTO vinculo = new VincularVeiculoDTO();
vinculo.Id = int.Parse(DR["id"].ToString());
vinculo.Placa = (DR["placa"].ToString());
vinculo.Id_Veiculo = int.Parse(DR["id_veiculo"].ToString());
vinculo.Veiculo = GetVeiculo(vinculo.Id_Veiculo);
vinculos.Add(vinculo);
}
}
return(vinculos);
}
catch
{
throw;
}
}
private void Navegar()
{
Cursor = Cursors.WaitCursor;
int id_veiculo;
vincularveiculoDTO = (VincularVeiculoDTO)bndVeiculoGrid.Current;
id_veiculo = Convert.ToInt32(vincularveiculoGL.GetIdVeiculo(vincularveiculoDTO.Veiculo));
VincularVeiculoDTObindingSource.DataSource = vincularveiculoGL.GetVincularVeiculo(id_veiculo);
vincularveiculoDTO = (VincularVeiculoDTO)VincularVeiculoDTObindingSource.Current;
vincularveiculoDTOVersaoOriginal = new VincularVeiculoDTO(vincularveiculoDTO);
GetFoto();
Cursor = Cursors.Default;
}
private void Excluir()
{
if (MessageBox.Show("Deseja realmente excluir ?", "Atenção", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
vincularveiculoDTO = (VincularVeiculoDTO)VeiculoVincBindingSource.Current;
try
{
vincularveiculoGL.Delete(vincularveiculoDTO.Id);
VeiculoVincBindingSource.RemoveCurrent();
}
catch
{
throw;
}
}
}
public string GetCliente(int id)
{
try
{
dbcommand = db.GetSqlStringCommand(" Select Nome FROM public.clientes" +
" WHERE" +
" id = @id;");
db.AddInParameter(dbcommand, "@id", DbType.Int32, id);
using (IDataReader DR = (Transaction == null ? db.ExecuteReader(dbcommand) : db.ExecuteReader(dbcommand, Transaction)))
{
DR.Read();
VincularVeiculoDTO cliente = new VincularVeiculoDTO();
cliente.Cliente = DR["nome"].ToString();
return(cliente.Cliente);
}
}
catch
{
throw;
}
}
public int Insert(VincularVeiculoDTO vinc)
{
bool transactionstart = false;
try
{
using (DbConnection connection = db.CreateConnection())
{
try
{
connection.Open();
transactionstart = true;
if (Transaction == null)
{
Transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbcommand = db.GetSqlStringCommand("Insert Into public.veiculo_vinc(" +
" id_cliente," +
" id_veiculo," +
" placa," +
" km," +
" cor," +
" ano," +
" num_chassi," +
" obs," +
" modelo," +
" foto" +
") VALUES (" +
" @id_cliente," +
" @id_veiculo," +
" @placa," +
" @km," +
" @cor," +
" @ano," +
" @num_chassi," +
" @obs," +
" @modelo," +
" @foto);" +
" SELECT currval('veiculo_vinc_id_seq');");
db.AddInParameter(dbcommand, "@id_cliente", DbType.Int16, vinc.Id_Cliente);
db.AddInParameter(dbcommand, "@id_veiculo", DbType.Int16, vinc.Id_Veiculo);
db.AddInParameter(dbcommand, "@placa", DbType.String, vinc.Placa);
db.AddInParameter(dbcommand, "@km", DbType.Int32, vinc.Km);
db.AddInParameter(dbcommand, "@cor", DbType.String, vinc.Cor);
db.AddInParameter(dbcommand, "@ano", DbType.String, vinc.Ano);
db.AddInParameter(dbcommand, "@num_chassi", DbType.String, vinc.Num_chassi);
db.AddInParameter(dbcommand, "@obs", DbType.String, vinc.Obs);
db.AddInParameter(dbcommand, "@modelo", DbType.String, vinc.Modelo);
db.AddInParameter(dbcommand, "@foto", DbType.Binary, vinc.Foto);
int id = Convert.ToInt32(db.ExecuteScalar(dbcommand, Transaction));
if (transactionstart)
{
Transaction.Commit();
Transaction = null;
}
connection.Close();
return(id);
}
catch (DbException dbex)
{
if (Transaction != null)
{
Transaction.Rollback();
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
Dispose();
throw dbex;
}
}
}
catch
{
throw;
}
}
public bool Update(VincularVeiculoDTO vinc)
{
Transaction = null;
DbConnection connection = null;
bool transactionstart = false;
try
{
using (connection = db.CreateConnection())
{
try
{
connection.Open();
if (Transaction == null)
{
Transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
transactionstart = true;
}
dbcommand = db.GetSqlStringCommand(" UPDATE public.veiculo_vinc SET" +
" id_veiculo = @id_veiculo," +
" id_cliente = @id_cliente," +
" placa = @placa," +
" km = @km," +
" cor = @cor," +
" ano = @ano," +
" num_chassi = @num_chassi," +
" obs = @obs," +
" modelo = @modelo," +
" foto = @foto" +
" WHERE" +
" id = @id");
db.AddInParameter(dbcommand, "@id_cliente", DbType.Int16, vinc.Id_Cliente);
db.AddInParameter(dbcommand, "@id_veiculo", DbType.Int16, vinc.Id_Veiculo);
db.AddInParameter(dbcommand, "@placa", DbType.String, vinc.Placa);
db.AddInParameter(dbcommand, "@km", DbType.Int32, vinc.Km);
db.AddInParameter(dbcommand, "@cor", DbType.String, vinc.Cor);
db.AddInParameter(dbcommand, "@ano", DbType.String, vinc.Ano);
db.AddInParameter(dbcommand, "@num_chassi", DbType.String, vinc.Num_chassi);
db.AddInParameter(dbcommand, "@obs", DbType.String, vinc.Obs);
db.AddInParameter(dbcommand, "@foto", DbType.Binary, vinc.Foto);
db.AddInParameter(dbcommand, "@modelo", DbType.String, vinc.Modelo);
db.AddInParameter(dbcommand, "@id", DbType.Int16, vinc.Id);
db.ExecuteNonQuery(dbcommand, Transaction);
if (transactionstart)
{
Transaction.Commit();
Transaction = null;
}
connection.Close();
return(true);
}
catch
{
throw;
}
}
}
catch
{
if (transactionstart)
{
if (Transaction.Connection.State == ConnectionState.Open)
{
Transaction.Rollback();
}
Transaction = null;
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
throw;
}
}
