private int InsertStmttrn(Stmttrn stmttrn, SqlConnection conn)
{
int idStmttrn = 0;
using (var comm = new SqlCommand())
{
comm.Connection = conn;
string sql = "INSERT INTO [dbo].[STMTTRN]([TRNTYPE],[DTPOSTED],[TRNAMT],[MEMO])";
sql += $" VALUES('{stmttrn.Trntype}','{stmttrn.Dtposted}',{stmttrn.Trnamt},'{stmttrn.Memo}')";
sql += " SELECT SCOPE_IDENTITY()";
comm.CommandText = sql;
idStmttrn = Convert.ToInt32(comm.ExecuteScalar());
}
return(idStmttrn);
}
public List <Stmttrn> GetById(int id)
{
List <Stmttrn> stmttrns = new List <Stmttrn>();
using (var conn = new SqlConnection(stringConexao))
{
using (var comm = new SqlCommand())
{
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
comm.CommandText = " select STMTTRN.* ";
comm.CommandText += " from OFX_HEADER";
comm.CommandText += " inner join OFX_BODY on OFX_HEADER.ID = OFX_BODY.ID_OFX_HEADER";
comm.CommandText += " inner join STMTTRNRS on STMTTRNRS.ID_STMTRS = OFX_BODY.ID_STMTTRNRS";
comm.CommandText += " inner join STMTRS on STMTRS.ID = STMTTRNRS.ID_STMTRS";
comm.CommandText += " inner join BANKTRAN on BANKTRAN.ID = STMTRS.ID_BANKTRAN";
comm.CommandText += " inner join BANKTRAN_STMTTRN on BANKTRAN_STMTTRN.ID_BANKTRAN = BANKTRAN.ID";
comm.CommandText += " inner join STMTTRN on STMTTRN.ID = BANKTRAN_STMTTRN.ID_STMTTRN";
comm.CommandText += $" where OFX_HEADER.ID = {id}";
comm.Connection = conn;
SqlDataReader rdr = comm.ExecuteReader();
while (rdr.Read())
{
Stmttrn stmttrn = new Stmttrn();
stmttrn.Trntype = rdr["TRNTYPE"].ToString();
stmttrn.Dtposted = rdr["DTPOSTED"].ToString();
stmttrn.Trnamt = Convert.ToSingle(rdr["TRNAMT"]);
stmttrn.Memo = rdr["MEMO"].ToString();
stmttrns.Add(stmttrn);
}
}
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
return(stmttrns);
}
private bool IsNotValuesIquals(List <Stmttrn> stmttrns, Stmttrn stmttrn, int position)
{
bool isEqual = true;
for (int i = position; i < stmttrns.Count; i++)
{
var item = stmttrns[i];
if (item.Dtposted == stmttrn.Dtposted &&
item.Memo == stmttrn.Memo &&
item.Trnamt == stmttrn.Trnamt &&
item.Trntype == stmttrn.Trntype)
{
isEqual = false;
break;
}
}
return(isEqual);
}
