public async Task <IEnumerable <CollectionModel> > GetAll()
        {
            List <CollectionModel> collections = new List <CollectionModel>();

            try
            {
                using (SQLiteConnection conn = new SQLiteConnection(Database.LoadConnectionString()))
                {
                    dt.Clear();
                    conn.Open();
                    string query = "SELECT * FROM Collections";
                    cmd = new SQLiteCommand(query, conn);
                    await cmd.ExecuteNonQueryAsync();

                    da = new SQLiteDataAdapter(cmd);
                    da.Fill(dt);

                    Loans     loans     = new Loans();
                    Borrowers borrowers = new Borrowers();

                    foreach (DataRow row in dt.Rows)
                    {
                        LoanModel l = await loans.GetSingle(Convert.ToInt32(row["LoanId"]));

                        BorrowerModel b = await borrowers.GetSingle(Convert.ToInt32(row["BorrowerId"]));

                        collections.Add(new CollectionModel()
                        {
                            Id       = Convert.ToInt32(row["Id"]),
                            Amount   = Convert.ToDecimal(row["Amount"]),
                            Date     = Convert.ToDateTime(row["Date"]),
                            Borrower = b,
                            Loan     = l
                        });
                    }
                }
            }
            catch (Exception e)
            {
                msg = e.Message;
            }

            return(collections);
        }
Ejemplo n.º 2
0
        public async Task <CollectablesModel> GetSingle(int id)
        {
            CollectablesModel collectables = new CollectablesModel();

            try
            {
                using (SQLiteConnection conn = new SQLiteConnection(Database.LoadConnectionString()))
                {
                    dt.Clear();
                    conn.Open();
                    string query = $"SELECT * FROM Collectables WHERE LoanId = '{id}'";
                    cmd = new SQLiteCommand(query, conn);
                    await cmd.ExecuteNonQueryAsync();

                    da = new SQLiteDataAdapter(cmd);
                    da.Fill(dt);
                    DataRow row = dt.Rows[0];

                    Loans     loans     = new Loans();
                    Borrowers borrowers = new Borrowers();
                    LoanModel l         = await loans.GetSingle(Convert.ToInt32(row["LoanId"]));

                    BorrowerModel b = await borrowers.GetSingle(Convert.ToInt32(row["BorrowerId"]));

                    collectables.Id       = Convert.ToInt32(row["Id"]);
                    collectables.DueDate  = Convert.ToDateTime(row["DueDate"]);
                    collectables.Loan     = l;
                    collectables.Borrower = b;
                }
            }
            catch (Exception e)
            {
                msg = e.Message;
            }

            return(collectables);
        }