public static bool DeletarFabrica(FabricaModel _Fabrica) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { SqlCommand cmd = new SqlCommand(); SqlParameter status = new SqlParameter(); cnn.Open(); cmd.Connection = cnn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "ExcluirFabrica"; cmd.Parameters.Add("@FabricaID", SqlDbType.Int).Value = _Fabrica.FabricaID; status.ParameterName = "@Status"; status.SqlDbType = System.Data.SqlDbType.Int; status.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(status); try { cmd.ExecuteNonQuery(); return(Convert.ToInt32(status.Value) != 0); } catch (Exception) { return(false); } } }
public static bool AtualizarFabrica(FabricaModel _Fabrica) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { cnn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE " + "fabricas " + "SET " + "cnpj_fabrica = @cnpj_fabrica," + "endereco = @endereco," + "id_distribuidora = @id_distribuidora " + "WHERE " + "id_fabrica = @id"; cmd.Parameters.Add("@id", SqlDbType.Int).Value = _Fabrica.FabricaID; cmd.Parameters.Add("@cnpj_fabrica", SqlDbType.VarChar).Value = _Fabrica.Cnpj; cmd.Parameters.Add("@endereco", SqlDbType.VarChar).Value = _Fabrica.Endereco; cmd.Parameters.Add("@id_distribuidora", SqlDbType.Int).Value = _Fabrica.DistribuidoraID; try { cmd.ExecuteNonQuery(); return(true); } catch (Exception) { //throw; return(false); } } }
public static bool DeletarFabrica(FabricaModel _Fabrica) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { SqlCommand cmd = new SqlCommand(); cnn.Open(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "DELETE FROM fabricas WHERE id_fabrica = @id_fabrica"; cmd.Parameters.Add("@id_fabrica", SqlDbType.Int).Value = _Fabrica.FabricaID; try { cmd.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } } }
public static bool CadastrarFabrica(FabricaModel _Fabrica) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { cnn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO " + "fabricas" + "(" + "id_cliente," + "cnpj_fabrica," + "endereco," + "id_distribuidora" + ") " + "VALUES " + " (" + "@id_cliente," + "@cnpj_fabrica," + "@endereco," + "@id_distribuidora " + ") " + "SELECT SCOPE_IDENTITY() AS ID "; cmd.Parameters.Add("@id_cliente", SqlDbType.Int).Value = _Fabrica.ClienteID; cmd.Parameters.Add("@cnpj_fabrica", SqlDbType.VarChar).Value = _Fabrica.Cnpj; cmd.Parameters.Add("@endereco", SqlDbType.VarChar).Value = _Fabrica.Endereco; cmd.Parameters.Add("@id_distribuidora", SqlDbType.Int).Value = _Fabrica.DistribuidoraID; try { cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); } } }
public static List <FabricaModel> TodasFabricas(int ClienteID) { List <FabricaModel> listaSaida = new List <FabricaModel>(); using (SqlConnection cnn = Conexoes.ConexaoSQL()) { SqlCommand cmd = new SqlCommand(); cnn.Open(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT " + "f.id_fabrica," + "f.id_cliente," + "f.cnpj_fabrica," + "f.endereco," + "f.id_distribuidora " + "FROM " + "fabricas f " + "WHERE " + "f.id_cliente = @id_cliente;"; cmd.Parameters.Add("@id_cliente", SqlDbType.Int).Value = ClienteID; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { FabricaModel _Fabrica = new FabricaModel(); _Fabrica.FabricaID = Convert.ToInt32(dr["id_fabrica"]); _Fabrica.ClienteID = Convert.ToInt32(dr["id_cliente"]); _Fabrica.Cnpj = dr["cnpj_fabrica"].ToString(); _Fabrica.Endereco = dr["endereco"].ToString(); _Fabrica.DistribuidoraID = Convert.ToInt32(dr["id_distribuidora"]); listaSaida.Add(_Fabrica); } } return(listaSaida); } }
public static FabricaModel DestalhesDaFabrica(int id) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { SqlCommand cmd = new SqlCommand(); cnn.Open(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT " + "f.id_fabrica," + "f.id_cliente," + "f.cnpj_fabrica," + "f.endereco," + "f.id_distribuidora " + "FROM " + "fabricas f " + "WHERE " + "f.id_fabrica = @id_fabrica"; cmd.Parameters.Add("@id_fabrica", SqlDbType.Int).Value = id; FabricaModel _Fabrica = new FabricaModel(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { _Fabrica.FabricaID = Convert.ToInt32(dr["id_fabrica"]); _Fabrica.ClienteID = Convert.ToInt32(dr["id_cliente"]); _Fabrica.Cnpj = dr["cnpj_fabrica"].ToString(); _Fabrica.Endereco = dr["endereco"].ToString(); _Fabrica.DistribuidoraID = Convert.ToInt32(dr["id_distribuidora"]); } } dr.Close(); return(_Fabrica); } }