/// <summary>
/// Create a billable or non-billable expense.
/// </summary>
/// <param name="new_expense">The new_expense is the Expense object which contains the new expense information with account_id and amount as mandatory attributes.</param>
/// <param name="receipt_path">The receipt_path is the path of the file which is going to be attaches as a receipt to the expense.</param>
/// <returns>Expense object.</returns>
public Expense Create(Expense new_expense, string receipt_path)
{
string url = baseAddress;
var json = JsonConvert.SerializeObject(new_expense);
var jsonstring = new Dictionary<object, object>();
jsonstring.Add("JSONString", json);
var attachments = new string[] { receipt_path };
var file = new KeyValuePair<string,string[] >("receipt", attachments);
var responce = ZohoHttpClient.post(url, getQueryParameters(),jsonstring,file);
return ExpenseParser.getExpense(responce);
}
internal static ExpenseList getExpenseHistory(HttpResponseMessage responce)
{
var expenseList = new ExpenseList();
var jsonObj = JsonConvert.DeserializeObject<Dictionary<string, object>>(responce.Content.ReadAsStringAsync().Result);
if (jsonObj.ContainsKey("expensehistory"))
{
var expenseArray = JsonConvert.DeserializeObject<List<object>>(jsonObj["expensehistory"].ToString());
foreach(var expObj in expenseArray)
{
var expense = new Expense();
expense = JsonConvert.DeserializeObject<Expense>(expObj.ToString());
expenseList.Add(expense);
}
}
if (jsonObj.ContainsKey("page_context"))
{
var pageContext = new PageContext();
pageContext = JsonConvert.DeserializeObject<PageContext>(jsonObj["page_context"].ToString());
expenseList.page_context = pageContext;
}
return expenseList;
}
static void Main(string[] args)
{
try
{
var service = new ZohoBooks();
service.initialize("{authtoken}", "{organizationId}");
var transactionApi = service.GetBankTransactionsApi();
var accounts = service.GetBankAccountsApi().GetBankAccounts(null);
var parameters = new Dictionary<object, object>();
parameters.Add("filter_by", "Status.All");
parameters.Add("account_id", accounts[0].account_id);
Console.WriteLine("---------------------- All Transactions ----------------------");
var transactionList = transactionApi.GetTransactions(parameters);
var transactions = transactionList;
foreach (var trans in transactions)
Console.WriteLine("{0},{1},{2}", trans.transaction_id, trans.status, trans.amount);
Console.WriteLine("---------------------- Specified Transaction ----------------------");
var transaction = transactionApi.Get(transactions[2].transaction_id);
Console.WriteLine("{0},{1},{2}", transaction.transaction_id, transaction.transaction_type, transaction.amount);
Console.WriteLine("---------------------- New Transaction ----------------------");
var newTransactionInfo = new Transaction()
{
transaction_type = "transfer_fund",
from_account_id = accounts[0].account_id,
to_account_id = accounts[2].account_id,
amount=10
};
var newTransaction = transactionApi.Create(newTransactionInfo);
Console.WriteLine("{0},{1},{2}", newTransaction.transaction_id, newTransaction.transaction_type, newTransaction.amount);
Console.WriteLine("---------------------- Updated Transaction ----------------------");
var updateInfo = new Transaction()
{
amount=50,
currency_id=transactionList[0].currency_id,
date="2014-02-06",
description="",
exchange_rate=1,
from_account_id = accounts[0].account_id,
reference_number= "",
to_account_id = accounts[2].account_id,
transaction_type = "transfer_fund"
};
var updatedTrans = transactionApi.Update(newTransaction.transaction_id, updateInfo);
Console.WriteLine("{0},{1},{2}", updatedTrans.transaction_id, updatedTrans.transaction_type, updatedTrans.amount);
Console.WriteLine("---------------------- Delete Transaction ----------------------");
var deltrans = transactionApi.Delete(updatedTrans.transaction_id);
Console.WriteLine(deltrans);
var parameters1 = new Dictionary<object, object>();
parameters1.Add("amount_start", "1");
parameters1.Add("amount_end", "4000");
parameters1.Add("date_start", "2014-02-01");
parameters1.Add("date_end", "2014-02-07");
var matchingtrans = transactionApi.GetMatchingTransactions(transactions[1].transaction_id, parameters1);
foreach(var matchingTran in matchingtrans)
Console.WriteLine("{0},{1},{2}", matchingTran.transaction_id, matchingTran.transaction_type, matchingTran.amount);
var parameters3=new Dictionary<object,object>();
parameters3.Add("account_id", accounts[1].account_id);
TransactionsToBeMatched transtomatch = new TransactionsToBeMatched()
{
transactions_to_be_matched = new List<Transaction>(){
new Transaction()
{
transaction_id=transactions[2].transaction_id,
transaction_type="vendor_payment"
},
new Transaction()
{
transaction_id=transactions[3].transaction_id,
transaction_type="transfer_fund"
},
new Transaction()
{
transaction_id=transactions[1].transaction_id,
transaction_type="expense"
}
}
};
var matchtransaction = transactionApi.MatchATransaction(transactions[0].transaction_id, transtomatch);
Console.WriteLine(matchtransaction);
var unmatch = transactionApi.UnmatchTransaction(transactions[0].transaction_id);
Console.WriteLine(unmatch);
parameters.Add("sort_column", "statement_date");
var associatedTransObj = transactionApi.GetAssociatedTransactions(transactions[0].transaction_id, null);
var associatedTrans = associatedTransObj.associated_transactions;
Console.WriteLine(associatedTransObj.imported_transaction_id);
foreach (var asociatedTran in associatedTrans)
Console.WriteLine("{0},{1},{2}", asociatedTran.transaction_id, asociatedTran.transaction_type, asociatedTran.amount);
var exclude = transactionApi.ExcludeATransaction(transactions[0].transaction_id);
Console.WriteLine(exclude);
var restore = transactionApi.RestoreATransaction(transactions[0].transaction_id);
Console.WriteLine(restore);
var transacInfo=new Transaction()
{
amount=4000,
date="2013-01-29",
description="Insurance payment",
exchange_rate=1,
from_account_id = accounts[1].account_id,
reference_number="Ref-9872",
to_account_id = accounts[3].account_id,
transaction_type = "expense"
};
var catogarise = transactionApi.CategorizeAnUncategorizedTransaction(transactions[0].transaction_id, transacInfo);
Console.WriteLine(catogarise);
var creditrefundInfo = new CreditNote()
{
creditnote_id = "{credit note id}",
date="2014-02-07",
from_account_id = "{account id from which account the transaction is going to be done}",
amount=4000
};
var catogasCred = transactionApi.CategorizeAsCreditNoteRefunds(transactions[0].transaction_id, creditrefundInfo);
Console.WriteLine(catogasCred);
var vendordetails = new VendorPayment()
{
vendor_id = "{vendor id}",
amount=4000,
paid_through_account_id = "{account id}"
};
var vendorcat = transactionApi.CategorizeAsVendorpayment(transactions[0].transaction_id, vendordetails);
Console.WriteLine(vendorcat);
var customerinfo = new CustomerPayment()
{
customer_id = "{customer id}",
date="2014-02-08",
invoices = new List<Invoice>()
{
new Invoice(){
invoice_id="{invoice id}",
amount_applied=4000
}
},
amount=4000
};
var custpaycat = transactionApi.CategorizeAsCustomerPayments(transactions[0].transaction_id, customerinfo, parameters);
Console.WriteLine(custpaycat);
var expenseInfo=new Expense()
{
account_id=accounts[3].account_id,
date="2013-01-29",
paid_through_account_id = accounts[4].account_id,
project_id= "",
amount=4000,
tax_id="",
is_inclusive_tax=false,
is_billable=false,
reference_number="Ref-123",
description="Insurance payment",
};
var catAsExpens = transactionApi.CategorizeAsExpense(transactions[0].transaction_id, expenseInfo, @"F:\error.png");
Console.WriteLine(catAsExpens);
var uncatogorise = transactionApi.UncategorizeACategorizedTransaction(transactions[0].transaction_id);
Console.WriteLine(uncatogorise);
var vendorCreditsApi = service.GetVendorCreditsApi();
var vendorCredits = vendorCreditsApi.GetVendorCredits(null);
var refundInfo = new VendorCreditRefund()
{
vendor_credit_id=vendorCredits[0].vendor_credit_id,
date="2014-11-25",
};
var catAsVendorRefund = transactionApi.CategorizeAsVendorCreditRefund(transactions[0].transaction_id, refundInfo);
Console.WriteLine(catAsVendorRefund);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
Console.ReadKey();
}
/// <summary>
/// Update an existing expense.
/// </summary>
/// <param name="expense_id">The expense_id is the identifier of the expense.</param>
/// <param name="update_info">The update_info is the Expense object which contains the update information.</param>
/// <param name="receipt_path">The receipt_path is the path of the file which is going to be attaches as a receipt to the expense.</param>
/// <returns>Expense object.</returns>
public Expense Update(string expense_id, Expense update_info, string receipt_path)
{
string url = baseAddress+"/"+expense_id;
var file = new KeyValuePair<string, string>("receipt", receipt_path);
var json = JsonConvert.SerializeObject(update_info);
var jsonstring = new Dictionary<object, object>();
jsonstring.Add("JSONString", json);
var responce = ZohoHttpClient.put(url, getQueryParameters(), jsonstring,file);
return ExpenseParser.getExpense(responce);
}
/// <summary>
/// Categorizes an uncategorised transaction as expense.
/// </summary>
/// <param name="transaction_id">The transaction_id is the identifier of the uncategorized transaction.</param>
/// <param name="expense_details">The expense_details is the Expoense object with account_id,paid_through_account_id and date are mandatory parameters.</param>
/// <param name="receipt_path">The receipt_path is the reciept for the expense .</param>
/// <returns>System.String.<br></br> The success message is "The transaction is now categorized."</returns>
public string CategorizeAsExpense(string transaction_id, Expense expense_details, string receipt_path)
{
string url = baseAddress + "/uncategorized/" + transaction_id + "/categorize/expense";
var json = JsonConvert.SerializeObject(expense_details);
var jsonstring = new Dictionary<object, object>();
jsonstring.Add("JSONString", json);
var attachment = new string[] { receipt_path };
var file = new KeyValuePair<string, string[]>("receipt",attachment);
var responce = ZohoHttpClient.post(url, getQueryParameters(), jsonstring, file);
return BankTransactionParser.getMessage(responce);
}