public int insPlantas(ePlantas planta)
{
int idRetorno = 0;
objSqlConect = new SqlConnection();
objSqlCom = new SqlCommand();
con = new duConexao();
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlCom.CommandText = "USP_INS_PLANTAS";
if (planta.Id == 0)
{
objSqlCom.Parameters.AddWithValue("@Id", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@Id", planta.Id);
}
objSqlCom.Parameters.AddWithValue("@Nome", planta.Nome);
objSqlCom.Parameters.AddWithValue("@Preco", float.Parse(planta.Preco));
objSqlCom.Parameters.AddWithValue("@Qtd", planta.Qtd);
objSqlCom.Parameters.AddWithValue("@Especial", planta.Especial);
objSqlCom.Parameters.AddWithValue("@Status", planta.Status);
objSqlCom.Parameters.Add("@Id_Retorno", SqlDbType.Int).Direction = ParameterDirection.Output;
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
try
{
objSqlCom.ExecuteNonQuery();
idRetorno = int.Parse(objSqlCom.Parameters["@Id_Retorno"].Value.ToString());
}
catch (Exception ex)
{
if (!idRetorno.Equals(0))
{
MessageBox.Show("Erro de Conexão \n" + ex.Message);
}
}
finally
{
objSqlConect.Dispose();
objSqlConect.Close();
objSqlConect = null;
}
return(idRetorno);
}
public bool insVendaProduto(eVendas venda)
{
bool gravou = false;
objSqlCom = new SqlCommand();
objSqlConect = new SqlConnection();
con = new duConexao();
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlCom.CommandText = "USP_INS_VENDAS_PRODUTOS";
if (venda.Id == 0)
{
objSqlCom.Parameters.AddWithValue("@Id", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@Id", venda.Id);
}
objSqlCom.Parameters.AddWithValue("@Produto", venda.Produto);
objSqlCom.Parameters.AddWithValue("@Preco", venda.Preco);
objSqlCom.Parameters.AddWithValue("@QtdVendidas", venda.QtdVendidas);
objSqlCom.Parameters.AddWithValue("@QtdEstocadas", venda.QtdEstocadas);
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
try
{
if (objSqlCom.ExecuteNonQuery() > 0)
{
gravou = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Erro de Conexão \n" + ex.Message);
}
finally
{
objSqlConect.Dispose();
objSqlConect.Close();
objSqlConect = null;
}
return(gravou);
}
public List <eVendas> selRelatorioVendas(DateTime?dataAte, DateTime?dataDe, string nomeProd, int?qtdMaior, decimal?preco)
{
objSqlCom = new SqlCommand();
objSqlConect = new SqlConnection();
con = new duConexao();
List <eVendas> lista = new List <eVendas>();
objSqlCom.CommandText = "USP_SEL_RELATORIO_VENDAS";
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlCom.Parameters.AddWithValue("@Id", null);
objSqlCom.Parameters.AddWithValue("@Produtos", nomeProd);
objSqlCom.Parameters.AddWithValue("@PrecoTotal", preco);
objSqlCom.Parameters.AddWithValue("@QtdProdutos", qtdMaior);
objSqlCom.Parameters.AddWithValue("@DataDe", dataDe);
objSqlCom.Parameters.AddWithValue("@DataAte", dataAte);
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
dr = objSqlCom.ExecuteReader();
try
{
if (dr.HasRows)
{
while (dr.Read())
{
lista.Add(SetarObjetoRelatorio(dr));
}
}
return(lista);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSqlCom.Dispose();
objSqlConect.Close();
objSqlConect = null;
objSqlCom = null;
}
}
public bool insFotos(eFotos foto)
{
bool gravou = false;
objSqlConect = new SqlConnection();
objSqlCom = new SqlCommand();
con = new duConexao();
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlCom.CommandText = "USP_INS_FOTO_PLANTA";
if (foto.Id == 0)
{
objSqlCom.Parameters.AddWithValue("@Id", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@Id", foto.Id);
}
objSqlCom.Parameters.AddWithValue("@Caminho", foto.Caminho);
objSqlCom.Parameters.AddWithValue("@Status", foto.Status);
objSqlCom.Parameters.AddWithValue("@IdPlanta", foto.IdPlanta);
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
try
{
if (objSqlCom.ExecuteNonQuery() > 0)
{
gravou = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Erro de Conexão \n" + ex.Message);
}
finally
{
objSqlConect.Dispose();
objSqlConect.Close();
objSqlConect = null;
}
return(gravou);
}
public List <eVendas> selProdutosVendidos(int?id, string produto)
{
objSqlCom = new SqlCommand();
objSqlConect = new SqlConnection();
con = new duConexao();
List <eVendas> lista = new List <eVendas>();
objSqlCom.Parameters.AddWithValue("@Id", id);
objSqlCom.Parameters.AddWithValue("@Produto", produto);
objSqlCom.CommandText = "USP_SEL_PRODUTOS_VENDIDOS";
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
dr = objSqlCom.ExecuteReader();
try
{
if (dr.HasRows)
{
while (dr.Read())
{
lista.Add(SetarObjetoProdutosVendidos(dr));
}
}
return(lista);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSqlCom.Dispose();
objSqlConect.Close();
objSqlConect = null;
objSqlCom = null;
}
}
public List <ePlantas> selPlantas(string nome)
{
List <ePlantas> lista = new List <ePlantas>();
objSqlConect = new SqlConnection();
objSqlCom = new SqlCommand();
con = new duConexao();
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlCom.CommandText = "USP_SEL_PLANTAS";
objSqlCom.Parameters.AddWithValue("@Nome", nome);
objSqlCom.Parameters.AddWithValue("@Id", null);
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
dr = objSqlCom.ExecuteReader();
try
{
while (dr.Read())
{
lista.Add(SetarObjeto(dr));
}
}
catch (Exception ex)
{
MessageBox.Show("Erro de Conexão \n" + ex.Message);
}
finally
{
dr.Close();
objSqlConect.Dispose();
objSqlConect.Close();
objSqlConect = null;
}
return(lista);
}
public bool delPlanta(int?idPlanta, int?idFoto)
{
bool deletou = false;
objSqlConect = new SqlConnection();
objSqlCom = new SqlCommand();
con = new duConexao();
objSqlCom.CommandType = CommandType.StoredProcedure;
objSqlCom.CommandText = "USP_DEL_PLANTA_FOTO";
objSqlCom.Parameters.AddWithValue("@idPlanta", idPlanta);
objSqlCom.Parameters.AddWithValue("@idFoto", idFoto);
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
try
{
if (objSqlCom.ExecuteNonQuery() > 0)
{
deletou = true;
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
objSqlConect.Dispose();
objSqlConect.Close();
objSqlConect = null;
}
return(deletou);
}
public List <eVendas> selVendas(eVendas venda)
{
objSqlCom = new SqlCommand();
objSqlConect = new SqlConnection();
con = new duConexao();
List <eVendas> lista = new List <eVendas>();
objSqlCom.CommandText = "USP_SEL_VENDAS";
objSqlCom.CommandType = CommandType.StoredProcedure;
if (venda.Id == 0)
{
objSqlCom.Parameters.AddWithValue("@Id", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@Id", venda.Id);
}
objSqlCom.Parameters.AddWithValue("@Produto", venda.Produto);
if (venda.Preco == 0)
{
objSqlCom.Parameters.AddWithValue("@Preco", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@Preco", venda.Preco);
}
if (venda.QtdVendidas == 0)
{
objSqlCom.Parameters.AddWithValue("@QtdVendidas", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@QtdVendidas", venda.QtdVendidas);
}
if (venda.QtdEstocadas == 0)
{
objSqlCom.Parameters.AddWithValue("@QtdEstocada", null);
}
else
{
objSqlCom.Parameters.AddWithValue("@QtdEstocada", venda.QtdEstocadas);
}
objSqlConect = con.abrirConexao();
objSqlCom.Connection = objSqlConect;
dr = objSqlCom.ExecuteReader();
try
{
if (dr.HasRows)
{
while (dr.Read())
{
lista.Add(SetarObjetoVendas(venda, dr));
}
}
return(lista);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSqlCom.Dispose();
objSqlConect.Close();
objSqlConect = null;
objSqlCom = null;
}
}