public Modelo.Extrato Select(string Id)
{
Modelo.Extrato aExtrato = new Modelo.Extrato();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from Extrato Where Id = @Id";
cmd.Parameters.AddWithValue("@Id", Id);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aExtrato = new Modelo.Extrato(
dr["data"].ToString(),
Convert.ToDouble(dr["valor"].ToString())
);
aExtrato.id = Convert.ToInt32(dr["id"].ToString());
}
}
dr.Close();
conn.Close();
return(aExtrato);
}
public List <Modelo.Extrato> SelectAll(int estudante_id)
{
List <Modelo.Extrato> aListExtrato = new List <Modelo.Extrato>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from Extrato where estudante_id = " + estudante_id + " ORDER BY id DESC";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Modelo.Extrato aExtrato = new Modelo.Extrato(
dr["data"].ToString(),
Convert.ToDouble(dr["valor"].ToString())
);
aListExtrato.Add(aExtrato);
}
}
dr.Close();
conn.Close();
return(aListExtrato);
}
public void Insert(Modelo.Extrato obj, int estudante_id)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("INSERT INTO Extrato (data, valor, estudante_id, recarga_id) VALUES (@data, @valor, @estudante_id," + 1 + ")", conn);
cmd.Parameters.AddWithValue("@data", obj.data);
cmd.Parameters.AddWithValue("@valor", obj.valor);
cmd.Parameters.AddWithValue("@estudante_id", estudante_id);
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();
}
