public List <TipoTransacaoModel> ListarTipoTransacao(int codigoTipoTransacao)
{
List <TipoTransacaoModel> listaTipoTransacao = new List <TipoTransacaoModel>();
SqlDataReader reader = null;
var query = @"SELECT * FROM TipoTransacao";
if (codigoTipoTransacao > 0)
{
query += " WHERE ttCodi = " + codigoTipoTransacao;
}
using (SqlConnection con = new SqlConnection(strConn.ToString()))
{
SqlCommand com = new SqlCommand(query, con);
con.Open();
try
{
reader = com.ExecuteReader();
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
var ret = new TipoTransacaoModel()
{
ttCodi = int.Parse(reader[0].ToString()),
ttDesc = reader[1].ToString()
};
listaTipoTransacao.Add(ret);
}
}
}
catch (Exception)
{
}
finally
{
con.Close();
}
}
return(listaTipoTransacao);
}
public ActionResult EditarTipoTransacao(TipoTransacaoModel tipotransacao)
{
db.Entry(tipotransacao).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ConsultaTipoTransacao"));
}
public ActionResult CadastrarTipoTransacao(TipoTransacaoModel tipotransacao)
{
db.tipotransacaodb.Add(tipotransacao);
db.SaveChanges();
return(RedirectToAction("ConsultaTipoTransacao"));
}
