public void AddRemittance(Remittance model) { Remittances.Add(model); string sql = "INSERT INTO Remittance (Id,Date,Deposit,WithDrawal,Type,Summary,AccountId) " + "VALUES(@Id,@Date,@Deposit,@WithDrawal,@Type,@Summary,@AccountId)"; SQLiteCommand cmd = new SQLiteCommand(sql); cmd.Parameters.AddWithValue("@AccountId", model.AccountId.ToString()); cmd.Parameters.AddWithValue("@Date", model.Date); cmd.Parameters.AddWithValue("@Deposit", model.Deposit); cmd.Parameters.AddWithValue("@Id", model.Id.ToString()); cmd.Parameters.AddWithValue("@Summary", model.Summary); cmd.Parameters.AddWithValue("@Type", model.Type); cmd.Parameters.AddWithValue("@WithDrawal", model.WithDrawal); cmds.Add(cmd); }
public List <Remittance> GetRemittances() { List <Remittance> result = new List <Remittance>(); SQLiteConnection conn = null; try { conn = new SQLiteConnection(connectionStr); conn.Open(); string sql = string.Format("SELECT * FROM Remittance"); SQLiteCommand cmd = new SQLiteCommand(sql, conn); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Remittance model = new Remittance(); model.Id = Guid.Parse(reader.GetString(0)); model.Date = reader.GetDateTime(1); model.Deposit = reader.GetDecimal(2); model.WithDrawal = reader.GetDecimal(3); model.Type = reader.GetString(4); model.Summary = reader.GetString(5); model.AccountId = Guid.Parse(reader.GetString(6)); result.Add(model); } conn.Close(); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(result); }