Esempio n. 1
0
        public void ExpenseTable_to_Expense_should_copy_all_values()
        {
            var expenseTable = new ExpenseTable {Id = 1, Amount = 100, Title = "Title", Description = "Description"};
            Expense expense = this.Mapping.GetEntity(expenseTable);

            Assert.AreEqual(expenseTable.Id, expense.Id);
            Assert.AreEqual(expenseTable.Amount, expense.Amount);
            Assert.AreEqual(expenseTable.Title, expense.Title);
            Assert.AreEqual(expenseTable.Description, expense.Description);
        }
Esempio n. 2
0
        public int InsertUpdate(ExpenseTable et)
        {
            ArrayList altParams = new ArrayList();

            altParams.Add(new SqlParameter("@Id", et.Id));
            altParams.Add(new SqlParameter("@AccountingTypeId", et.AccountingTypeId));
            altParams.Add(new SqlParameter("@Amount", et.Amount));
            altParams.Add(new SqlParameter("@BankId", et.BankId));
            altParams.Add(new SqlParameter("@BankPay", et.BankPay));
            altParams.Add(new SqlParameter("@BuildingId", et.BuildingId));
            altParams.Add(new SqlParameter("@CashPay", et.CashPay));
            altParams.Add(new SqlParameter("@CequeNumber", et.CequeNumber));
            altParams.Add(new SqlParameter("@Date", et.Date.Date));
            altParams.Add(new SqlParameter("@userid", et.userid));
            altParams.Add(new SqlParameter("@payto", et.payto));
            altParams.Add(new SqlParameter("@vouchernumber", et.VoucherNumber));
            return(DatabaseManager.GetInstance().ExecuteNonQueryStoredProcedure("Acc_sp_ExpenceInsertUpdate", altParams));
        }
Esempio n. 3
0
 public int InsertUpdate(ExpenseTable et)
 {
     return(de.InsertUpdate(et));
 }