public static BandeiraModel DetalhesBandeira(int id) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { SqlCommand cmd = new SqlCommand(); cnn.Open(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT " + "b.id_bandeira," + "b.string_bandeira " + "FROM " + "bandeiras b " + "WHERE " + "b.id_bandeira = @id_bandeira"; cmd.Parameters.Add("@id_bandeira", SqlDbType.Int).Value = id; BandeiraModel _Bandeira = new BandeiraModel(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { _Bandeira.BandeiraID = Convert.ToInt32(dr["id_bandeira"]); _Bandeira.BandeiraString = dr["string_bandeira"].ToString(); } } dr.Close(); return(_Bandeira); } }
public static List <BandeiraModel> TodasBandeiras() { List <BandeiraModel> listSaida = new List <BandeiraModel>(); using (SqlConnection cnn = Conexoes.ConexaoSQL()) { SqlCommand cmd = new SqlCommand(); cnn.Open(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "Select b.id_bandeira, b.string_bandeira FROM bandeiras b"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { BandeiraModel _Bandeira = new BandeiraModel(); _Bandeira.BandeiraID = Convert.ToInt32(dr["id_bandeira"]); _Bandeira.BandeiraString = dr["string_bandeira"].ToString(); listSaida.Add(_Bandeira); } } return(listSaida); } }
public static bool CadastrarBandeira(BandeiraModel _Bandeira) { using (SqlConnection cnn = Conexoes.ConexaoSQL()) { cnn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO " + "bandeiras " + "(" + "string_bandeira" + ") " + "VALUES " + "(" + "@string_bandeira" + ") " + "SELECT SCOPE_IDENTITY() AS ID"; cmd.Parameters.Add("@string_bandeira", SqlDbType.VarChar).Value = _Bandeira.BandeiraString; //int BandeiraID = 0; try { cmd.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } } }