コード例 #1
0
ファイル: DatabaseService.cs プロジェクト: Riders9388/Debtors
        public DebtBack GetDebtBack(int id)
        {
            DebtBack toReturn = new DebtBack();

            try
            {
                toReturn = Connection.Get <DebtBack>(id);
            }
            catch (Exception ex)
            {
            }
            return(toReturn);
        }
コード例 #2
0
ファイル: DatabaseService.cs プロジェクト: Riders9388/Debtors
        public bool InsertOrUpdateDebtBack(DebtBack debtBack, bool newTransaction = true)
        {
            bool toReturn = false;

            try
            {
                if (newTransaction && !Connection.IsInTransaction)
                {
                    Connection.BeginTransaction();
                }

                int succeed = 0;
                if (debtBack.Id > 0)
                {
                    debtBack.ModifiedAt = DateTime.Now;
                    succeed             = Connection.Update(debtBack);
                }
                else
                {
                    debtBack.CreatedAt  = DateTime.Now;
                    debtBack.ModifiedAt = DateTime.Now;
                    succeed             = Connection.Insert(debtBack);
                }

                if (succeed > 0)
                {
                    toReturn = true;
                }

                if (newTransaction && Connection.IsInTransaction)
                {
                    if (toReturn)
                    {
                        Connection.Commit();
                    }
                    else
                    {
                        Connection.Rollback();
                    }
                }
            }
            catch (Exception ex)
            {
                toReturn = false;
                if (newTransaction && Connection.IsInTransaction)
                {
                    Connection.Rollback();
                }
            }
            return(toReturn);
        }