public List <Modelo.Recarga> SelectAll() { List <Modelo.Recarga> aListRecarga = new List <Modelo.Recarga>(); SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Select * from Recarga"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Modelo.Recarga aRecarga = new Modelo.Recarga( Convert.ToDouble(dr["valor"].ToString()) ); aRecarga.id = Convert.ToInt32(dr["id"].ToString()); aRecarga.data = Convert.ToDateTime(dr["data"].ToString()); aListRecarga.Add(aRecarga); } } dr.Close(); conn.Close(); return(aListRecarga); }
public Modelo.Recarga Select(string Id) { Modelo.Recarga aRecarga = new Modelo.Recarga(); SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Select * from Recarga Where Id = @Id"; cmd.Parameters.AddWithValue("@Id", Id); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { aRecarga = new Modelo.Recarga( Convert.ToDouble(dr["valor"].ToString()) ); aRecarga.id = Convert.ToInt32(dr["id"].ToString()); aRecarga.data = Convert.ToDateTime(dr["data"].ToString()); } } dr.Close(); conn.Close(); return(aRecarga); }
public void Delete(Modelo.Recarga obj) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand com = conn.CreateCommand(); SqlCommand cmd = new SqlCommand("DELETE FROM Recarga WHERE Id = @Id", conn); cmd.Parameters.AddWithValue("@Id", obj.id); cmd.ExecuteNonQuery(); }
public void Update(Modelo.Recarga obj) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand com = conn.CreateCommand(); SqlCommand cmd = new SqlCommand("UPDATE Recarga SET data = @data, valor = @valor WHERE Id = @Id", conn); cmd.Parameters.AddWithValue("@Id", obj.id); cmd.Parameters.AddWithValue("@data", obj.data); cmd.Parameters.AddWithValue("@valor", obj.valor); cmd.ExecuteNonQuery(); }
public void Insert(Modelo.Recarga obj, int estudante_id) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand com = conn.CreateCommand(); SqlCommand cmd = new SqlCommand("INSERT INTO Recarga (data_recarga, valor, estudante_id) VALUES (@data, @valor, @estudante_id)", conn); cmd.Parameters.AddWithValue("@data", obj.data); cmd.Parameters.AddWithValue("@valor", obj.valor); cmd.Parameters.AddWithValue("@estudante_id", estudante_id); DALExtrato c = new DALExtrato(); Modelo.Extrato d = new Modelo.Extrato(); d.valor = obj.valor; d.data = DateTime.Now.ToString("dd/MM/yyyy HH:mm"); c.Insert(d, estudante_id); cmd.ExecuteNonQuery(); }