using System; using System.Collections.Generic; using System.Diagnostics; using System.Globalization; using System.IO; using System.Linq; using System.Linq.Expressions; using System.Net; using System.Runtime.CompilerServices; using System.Security.Principal; using System.Text.RegularExpressions; using System.Threading; using System.Web; using System.Web.Services; using Newtonsoft.Json.Linq; using Swarmops.Interface.Support; using Swarmops.Localization; using Swarmops.Logic.Cache; using Swarmops.Logic.Financial; using Swarmops.Logic.Security; using Swarmops.Logic.Structure; using Swarmops.Logic.Support; using Swarmops.Logic.Support.BackendServices; using Swarmops.Logic.Swarm; using Swarmops.Site.Pages.Ledgers; using CsvHelper; using Swarmops.Common.Enums; using Swarmops.Frontend.Automation; using Formatting = Swarmops.Logic.Support.Formatting; namespace Swarmops.Frontend.Pages.v5.Financial { public partial class FileExpenseClaim : PageV5Base { private int[] _tagSetIds; protected void Page_Init (object sender, EventArgs e) { string tagSetIdsString = Request["ctl00$PlaceHolderMain$HiddenTagSetIdentifiers"]; // Find our tag ids, either from previously hidden var or load from org if (String.IsNullOrEmpty (tagSetIdsString)) { this._tagSetIds = FinancialTransactionTagSets.ForOrganization (CurrentOrganization).Identities; } else { string[] tagSetIdStrings = tagSetIdsString.Split (','); this._tagSetIds = new int[tagSetIdStrings.Length]; for (int index = 0; index < tagSetIdStrings.Length; index++) { this._tagSetIds[index] = Int32.Parse (tagSetIdStrings[index]); } } // Construct data source List dataSourceVisibleTags = new List(); List dataSourceForcedTags = new List(); foreach (int tagSetId in this._tagSetIds) { TagSetDataSourceItem item = new TagSetDataSourceItem { TagSetId = tagSetId, TagSetLocalizedName = FinancialTransactionTagSetType.GetLocalizedName ( FinancialTransactionTagSet.FromIdentity (tagSetId). FinancialTransactionTagSetTypeId) }; FinancialTransactionTagSet tagSet = FinancialTransactionTagSet.FromIdentity (tagSetId); if (tagSet.VisibilityLevel <= 1) { dataSourceVisibleTags.Add (item); if (!tagSet.AllowUntagged) { dataSourceForcedTags.Add (item); } } } // Bind data // Unused for now /* this.RepeaterTagLabels.DataSource = dataSourceVisibleTags; this.RepeaterTagDrop.DataSource = dataSourceVisibleTags; this.RepeaterTagDropScript.DataSource = dataSourceVisibleTags; this.RepeaterErrorCheckTags.DataSource = dataSourceForcedTags; this.RepeaterTagLabels.DataBind(); this.RepeaterTagDrop.DataBind(); this.RepeaterTagDropScript.DataBind(); this.RepeaterErrorCheckTags.DataBind();*/ // Write set list back to hidden variable List tagSetIdStringList = new List(); foreach (int tagSetId in this._tagSetIds) { tagSetIdStringList.Add (tagSetId.ToString (CultureInfo.InvariantCulture)); } this.HiddenTagSetIdentifiers.Value = String.Join (",", tagSetIdStringList.ToArray()); } protected void Page_Load (object sender, EventArgs e) { if (!CurrentOrganization.IsEconomyEnabled) { Response.Redirect ("/Pages/v5/Financial/EconomyNotEnabled.aspx", true); return; } this.BoxTitle.Text = PageTitle = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_PageTitle"); PageIcon = "iconshock-moneyback"; InfoBoxLiteral = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Info"); PageAccessRequired = new Access (CurrentOrganization, AccessAspect.Participant, AccessType.Write); if (!Page.IsPostBack) { // Prime bank details this.TextBank.Text = CurrentUser.BankName; this.TextClearing.Text = CurrentUser.BankClearing; this.TextAccount.Text = CurrentUser.BankAccount; this.CurrencyAmount.Cents = 0; this.CurrencyVat.Cents = 0; this.DateExpenseIncurred.Value = DateTime.Today; this.CurrencyAmount.Focus(); Localize(); this.CurrencyAmount.Focus(); } } private void Localize() { /* Main tab */ this.LabelExpenseDate.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_DateIncurred"); this.LabelAmount.Text = string.Format (LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Amount"), CurrentOrganization.Currency.DisplayCode); this.LabelPurpose.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Description"); this.LabelBudget.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Budget"); this.LabelHeaderBankDetails.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_HeaderBankDetails"); this.LabelBankName.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_BankName"); this.LabelBankClearing.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_BankClearing"); this.LabelBankAccount.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_BankAccount"); this.LabelHeaderImageFiles.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_HeaderReceiptImages"); this.LabelImageFiles.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_UploadRecieptImages"); this.LabelVat.Text = string.Format(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Vat"), CurrentOrganization.Currency.DisplayCode); this.ButtonRequest.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_ButtonRequest"); /* Expensify tab */ this.LabelExpensifyUploadHeader.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Title_Expensify"); this.LabelExpensifyCsv.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_CsvUploadDescription"); this.LabelExpensifyInstructions1.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_InstructionsBasic"); this.LabelExpensifyProcessingComplete.Text = LocalizedStrings.Get(LocDomain.Global, "Global_FileUploadResults"); this.LabelExpensifyUploadAnotherHeader.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_UploadAnother"); if (CurrentOrganization.VatEnabled) { this.LabelExpensifyInstructions2.Text = String.Format(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_InstructionsNeedVat"), CurrentOrganization.Name); } else { this.LabelExpensifyInstructions2.Text = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_InstructionsNothingAdvanced"); } this.LabelExpensifyHeaderAmount.Text = LocalizedStrings.Get(LocDomain.Global, "Financial_Amount"); this.LabelExpensifyHeaderVat.Text = LocalizedStrings.Get(LocDomain.Global, "Financial_AmountVat"); this.LabelExpensifyHeaderDocs.Text = LocalizedStrings.Get(LocDomain.Global, "Global_Action"); this.LabelExpensifyHeaderDescription.Text = LocalizedStrings.Get(LocDomain.Global, "Global_Description"); this.LabelExpensifyHeaderBudget.Text = LocalizedStrings.Get(LocDomain.Global, "Financial_Budget"); this.LabelExpensifyHeaderDate.Text = LocalizedStrings.Get(LocDomain.Global, "Global_Date"); } [WebMethod(true)] public static AjaxCallResult InitializeExpensifyProcessing(string guidFiles, string guidProgress) { // Start an async thread that does all the work, then return AuthenticationData authData = GetAuthenticationDataAndCulture(); ProgressBarBackend progress = new ProgressBarBackend(guidProgress); progress.Set(0); // Set to 0 first, esp. in case of previous files progress.Set(1); // Then to 1, just to indicate life Thread initThread = new Thread(ProcessExpensifyUploadThread); ProcessThreadArguments args = new ProcessThreadArguments { GuidFiles = guidFiles, GuidProgress = guidProgress, Organization = authData.CurrentOrganization, CurrentUser = authData.CurrentUser }; initThread.Start(args); return new AjaxCallResult {Success = true}; } private class ProcessThreadArguments { public string GuidFiles { get; set; } public string GuidProgress { get; set; } public Organization Organization { get; set; } public Person CurrentUser { get; set; } } public class ReportedImportResults { public string Category { get; set; } public string Html { get; set; } } private static void ProcessExpensifyUploadThread(object args) { string guidProgress = ((ProcessThreadArguments) args).GuidProgress; string guidFiles = ((ProcessThreadArguments)args).GuidFiles; Person currentUser = ((ProcessThreadArguments) args).CurrentUser; Organization organization = ((ProcessThreadArguments) args).Organization; // Disable certificate checking due to Mono not installing with a certificate repository - this is UTTERLY broken SupportFunctions.DisableSslCertificateChecks(); // MONO BUG/MISFEATURE: Mono has no root certificates, so can't verify cert ProgressBarBackend progress = new ProgressBarBackend(guidProgress); try { Documents documents = Documents.RecentFromDescription(guidFiles); progress.Set(2); // indicate more life if (documents.Count != 1) { return; // abort } Document uploadedDoc = documents[0]; // TODO: ATTEMPT TO DETERMINE CURRENCY FROM FILE, USING ORIGINAL CURRENCY + ORIGINAL AMOUNT string csvEntire; using (StreamReader reader = uploadedDoc.GetReader(1252)) { csvEntire = reader.ReadToEnd(); } GuidCache.Set("ExpensifyRaw-" + guidFiles, csvEntire); string[] csvLines = csvEntire.Split(new char[] {'\r', '\n'}); string[] fieldNames = csvLines[0].Split(','); // Map fields to column indexes Dictionary fieldMap = new Dictionary(); for (int loop = 0; loop < fieldNames.Length; loop++) { switch (fieldNames[loop].ToLowerInvariant().Trim('\"')) { case "timestamp": fieldMap[ExpensifyColumns.Timestamp] = loop; break; case "amount": fieldMap[ExpensifyColumns.AmountFloat] = loop; break; case "merchant": fieldMap[ExpensifyColumns.Merchant] = loop; break; case "comment": fieldMap[ExpensifyColumns.Comment] = loop; break; case "category": fieldMap[ExpensifyColumns.CategoryCustom] = loop; break; case "mcc": fieldMap[ExpensifyColumns.CategoryStandard] = loop; break; case "vat": fieldMap[ExpensifyColumns.VatFloat] = loop; break; case "original currency": fieldMap[ExpensifyColumns.OriginalCurrency] = loop; break; case "original amount": fieldMap[ExpensifyColumns.OriginalCurrencyAmountFloat] = loop; break; case "receipt": fieldMap[ExpensifyColumns.ReceiptUrl] = loop; break; default: // ignore any unknown fields break; } } ExpensifyColumns[] requiredData = { ExpensifyColumns.AmountFloat, ExpensifyColumns.CategoryCustom, ExpensifyColumns.CategoryStandard, ExpensifyColumns.Comment, ExpensifyColumns.Merchant, ExpensifyColumns.OriginalCurrency, ExpensifyColumns.OriginalCurrencyAmountFloat, ExpensifyColumns.ReceiptUrl, ExpensifyColumns.Timestamp }; foreach (ExpensifyColumns requiredColumn in requiredData) { if (!fieldMap.ContainsKey(requiredColumn)) { // Abort as invalid file GuidCache.Set("Results-" + guidFiles, new AjaxCallExpensifyUploadResult { Success = false, ErrorType = "ERR_INVALIDCSV", DisplayMessage = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_Error_InvalidCsv") }); progress.Set(100); // terminate progress bar, causes retrieval of result documents[0].Delete(); // prevents further processing return; // terminates thread } } // TODO: Much more general-case error conditions if not all fields are filled bool vatEnabled = organization.VatEnabled; if (vatEnabled && !fieldMap.ContainsKey(ExpensifyColumns.VatFloat)) { // Error: Organization needs a VAT field GuidCache.Set("Results-" + guidFiles, new AjaxCallExpensifyUploadResult { Success = false, ErrorType = "ERR_NEEDSVAT", DisplayMessage = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_Error_NeedsVat") }); progress.Set(100); // terminate progress bar, causes retrieval of result documents[0].Delete(); // prevents further processing return; // terminates thread } List recordList = new List(); CsvHelper.Configuration.CsvConfiguration config = new CsvHelper.Configuration.CsvConfiguration(CultureInfo.InvariantCulture); config.HasHeaderRecord = true; using (TextReader textReader = new StringReader(csvEntire)) { CsvReader csvReader = new CsvReader(textReader, config); csvReader.Read(); // bypass header record -- why isn't this done automatically? while (csvReader.Read()) { ExpensifyRecord newRecord = new ExpensifyRecord(); Int64 amountExpensifyCents = newRecord.AmountCents = Formatting.ParseDoubleStringAsCents( csvReader.GetField(fieldMap[ExpensifyColumns.AmountFloat]), CultureInfo.InvariantCulture); newRecord.OriginalCurrency = Currency.FromCode(csvReader.GetField(fieldMap[ExpensifyColumns.OriginalCurrency])); newRecord.OriginalAmountCents = Formatting.ParseDoubleStringAsCents( csvReader.GetField(fieldMap[ExpensifyColumns.OriginalCurrencyAmountFloat]), CultureInfo.InvariantCulture); newRecord.Timestamp = DateTime.Parse(csvReader.GetField(fieldMap[ExpensifyColumns.Timestamp])); bool amountNeedsTranslation = false; if (newRecord.OriginalCurrency.Identity != organization.Currency.Identity) { amountNeedsTranslation = true; // May or may not be the same as Expensify calculated newRecord.AmountCents = new Money(newRecord.OriginalAmountCents, newRecord.OriginalCurrency, newRecord.Timestamp) .ToCurrency(organization.Currency).Cents; } newRecord.Description = csvReader.GetField(fieldMap[ExpensifyColumns.Merchant]); string comment = csvReader.GetField(fieldMap[ExpensifyColumns.Comment]).Trim(); if (!string.IsNullOrEmpty(comment)) { newRecord.Description += " / " + comment; } newRecord.CategoryCustom = csvReader.GetField(fieldMap[ExpensifyColumns.CategoryCustom]); newRecord.CategoryStandard = csvReader.GetField(fieldMap[ExpensifyColumns.CategoryStandard]); newRecord.ReceiptUrl = csvReader.GetField(fieldMap[ExpensifyColumns.ReceiptUrl]); newRecord.Guid = Guid.NewGuid().ToString(); if (vatEnabled) { Int64 vatOriginalCents = Formatting.ParseDoubleStringAsCents( csvReader.GetField(fieldMap[ExpensifyColumns.VatFloat]), CultureInfo.InvariantCulture); if (amountNeedsTranslation) { double vatRatio = vatOriginalCents/(double) amountExpensifyCents; newRecord.VatCents = (Int64) (newRecord.AmountCents*vatRatio); } else { newRecord.VatCents = vatOriginalCents; } } recordList.Add(newRecord); } } progress.Set(10); // We now need to get all the receipt images. This is a little tricky as we don't have the URL // of the receipt directly, we only have the URL of a webpage that contains JavaScript code // to fetch the receipt image. // Get relative date part string relativePath = Document.DailyStorageFolder.Substring(Document.StorageRoot.Length); // Get all receipts for (int loop = 0; loop < recordList.Count; loop++) { progress.Set(loop*90/recordList.Count + 10); using (WebClient client = new WebClient()) { SupportFunctions.DisableSslCertificateChecks(); string receiptResource = string.Empty; try { receiptResource = client.DownloadString(recordList[loop].ReceiptUrl); } catch (Exception innerException) { throw new Exception("Exception trying to download first Receipt URI: " + recordList[loop].ReceiptUrl, innerException); } // We now have the web page which holds information about where the actual receipt is located. Regex regex = new Regex(@"\s*var transaction\s*=\s*(?{.*});", RegexOptions.Multiline); Match match = regex.Match(receiptResource); if (match.Success) { string txInfoString = match.Groups["jsonTxInfo"].ToString(); JObject txInfo = JObject.Parse(txInfoString); recordList[loop].ExtendedInfo = txInfoString; string expensifyFileName = (string) txInfo["receiptFilename"]; string actualReceiptUrl = "https://s3.amazonaws.com/receipts.expensify.com/" + expensifyFileName; string newGuidString = recordList[loop].Guid; string fullyQualifiedFileName = Document.DailyStorageFolder + newGuidString; string relativeFileName = relativePath + newGuidString; try { client.DownloadFile(actualReceiptUrl, fullyQualifiedFileName); } catch (Exception innerException) { throw new Exception("Exception trying to download receipt image: " + actualReceiptUrl, innerException); } recordList[loop].ReceiptFileNameHere = newGuidString; // If original file name ends in PDF, initiate conversion. if (expensifyFileName.ToLowerInvariant().EndsWith(".pdf")) { // Convert low resolution Documents docs = new PdfProcessor().RasterizeOne(fullyQualifiedFileName, recordList[loop].Description, newGuidString, currentUser, organization); recordList[loop].Documents = docs; // Ask backend for high-res conversion RasterizeDocumentHiresOrder backendOrder = new RasterizeDocumentHiresOrder(docs[0]); backendOrder.Create(); } else { Document doc = Document.Create(relativePath + newGuidString, expensifyFileName, 0, newGuidString, null, currentUser); recordList[loop].Documents = Documents.FromSingle(doc); } } } } // We now have the individual expenses and all accompanying receipts. // Create the expense claim group, then the individual expense records, // and assign the Documents to the records and the records to the Group, // so the user can review all of it. // TODO: Suggest initial budgets List outputRecords = new List(); string docString = ""; string documentsAll = String.Empty; foreach (ExpensifyRecord record in recordList) { foreach (Document document in record.Documents) { documentsAll += String.Format(docString, document.Identity, document.ClientFileName.Replace("\"", "'"), "D" + record.Documents[0].Identity.ToString(CultureInfo.InvariantCulture)); } } AjaxCallExpensifyUploadResult result = new AjaxCallExpensifyUploadResult { Success = true, Data = FormatExpensifyOutputRecords(recordList), Footer = FormatExpensifyFooter(recordList), Documents = documentsAll }; GuidCache.Set("Results-" + guidFiles, result); GuidCache.Set("ExpensifyData-" + guidFiles, recordList); } catch (Exception exception) { // Abort as exception GuidCache.Set("Results-" + guidFiles, new AjaxCallExpensifyUploadResult { Success = false, ErrorType = "ERR_EXCEPTION", DisplayMessage = exception.ToString() }); } finally { progress.Set(100); // terminate progress bar, causes retrieval of result } } private static ExpensifyOutputRecord[] FormatExpensifyOutputRecords(List recordList) { List outputRecords = new List(); const string doxString = ""; const string editString = ""; foreach (ExpensifyRecord record in recordList) { ExpensifyOutputRecord newRecord = new ExpensifyOutputRecord { Description = record.CategoryCustom + " / " + record.Description, CreatedDateTime = record.Timestamp.ToString("MMM dd"), Amount = (record.AmountCents/100.0).ToString("N2"), AmountVat = (record.VatCents/100.0).ToString("N2"), Actions = String.Format(doxString, "D" + record.Documents[0].Identity.ToString(CultureInfo.InvariantCulture)) + String.Format(editString, record.Guid), Guid = record.Guid }; if (record.BudgetId != 0) { FinancialAccount account = FinancialAccount.FromIdentity(record.BudgetId); newRecord.BudgetText = account.Name; if (account.ParentIdentity != 0) { newRecord.BudgetText = account.Parent.Name + " » " + account.Name; } } else { newRecord.BudgetText = "" + LocalizedStrings.Get(LocDomain.Global, "Global_DropInits_SelectFinancialAccount") + ""; } outputRecords.Add(newRecord); } return outputRecords.ToArray(); } private static ExpensifyOutputRecord[] FormatExpensifyFooter(List recordList) { Int64 amountCentsTotal =0; Int64 vatCentsTotal =0; foreach (ExpensifyRecord record in recordList) { amountCentsTotal += record.AmountCents; vatCentsTotal += record.VatCents; } ExpensifyOutputRecord newRecord = new ExpensifyOutputRecord { Amount = "" + (amountCentsTotal / 100.0).ToString("N2") + "", AmountVat = "" + (vatCentsTotal / 100.0).ToString("N2") + "", BudgetText = "" + LocalizedStrings.Get(LocDomain.Global, "Global_Total").ToUpperInvariant() + "" }; List listResult = new List(); listResult.Add(newRecord); return listResult.ToArray(); } private static string FormatExpensifySubmitPrompt(List recordList) { foreach (ExpensifyRecord record in recordList) { if (record.BudgetId == 0) { return string.Empty; } } if (recordList.Count == 1) { return LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_SubmitRecordSingle"); } return String.Format(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_SubmitRecordsSeveral"), recordList.Count); } [WebMethod] public static AjaxCallExpensifyRecordResult ExpensifyRecordProceed(string masterGuid, string recordGuid, string amountString, string amountVatString, int budgetId, string description) { GetAuthenticationDataAndCulture(); List recordList = (List)GuidCache.Get("ExpensifyData-" + masterGuid); int index = LocateRecordsetIndex(recordList, recordGuid); amountString = amountString.Trim(); amountVatString = amountVatString.Trim(); if (amountString.Contains(" ")) { amountString = FinancialFunctions.InterpretCurrency(amountString).DisplayAmount; } if (amountVatString.Contains(" ")) { amountVatString = FinancialFunctions.InterpretCurrency(amountVatString).DisplayAmount; } recordList[index].AmountCents = Formatting.ParseDoubleStringAsCents(amountString); recordList[index].VatCents = Formatting.ParseDoubleStringAsCents(amountVatString); recordList[index].BudgetId = budgetId; recordList[index].Description = description; GuidCache.Set("ExpensifyData-" + masterGuid, recordList); index++; if (index >= recordList.Count) { // We processed the last record, so return a null record return new AjaxCallExpensifyRecordResult { Guid = "", // indicates null record Success = true, DataUpdate = FormatExpensifyOutputRecords(recordList), FooterUpdate = FormatExpensifyFooter(recordList), SubmitPrompt = FormatExpensifySubmitPrompt(recordList) }; } // Display the record next in line return new AjaxCallExpensifyRecordResult { Amount = (recordList[index].AmountCents / 100.0).ToString("N2"), AmountVat = (recordList[index].VatCents / 100.0).ToString("N2"), Description = recordList[index].Description, DocumentId = recordList[index].Documents.First().Identity, BudgetId = recordList[index].BudgetId, Guid = recordList[index].Guid, ExistNext = (index < recordList.Count - 1 ? true : false), Success = true, DataUpdate = FormatExpensifyOutputRecords(recordList), FooterUpdate = FormatExpensifyFooter (recordList), SubmitPrompt = FormatExpensifySubmitPrompt(recordList) }; } [WebMethod] public static AjaxCallExpensifyRecordResult ExpensifyRecordDelete(string masterGuid, string recordGuid) { GetAuthenticationDataAndCulture(); List recordList = (List)GuidCache.Get("ExpensifyData-" + masterGuid); int index = LocateRecordsetIndex(recordList, recordGuid); recordList.RemoveAt(index); GuidCache.Set("ExpensifyData-" + masterGuid, recordList); if (index >= recordList.Count) { // We deleted the last record, so return a null record return new AjaxCallExpensifyRecordResult { Guid = "", // indicates null record Success = true, DataUpdate = FormatExpensifyOutputRecords(recordList), FooterUpdate = FormatExpensifyFooter(recordList), SubmitPrompt = FormatExpensifySubmitPrompt(recordList) }; } // Display the record next in line return new AjaxCallExpensifyRecordResult { Amount = (recordList[index].AmountCents / 100.0).ToString("N2"), AmountVat = (recordList[index].VatCents / 100.0).ToString("N2"), Description = recordList[index].Description, DocumentId = recordList[index].Documents.First().Identity, BudgetId = recordList[index].BudgetId, Guid = recordList[index].Guid, ExistNext = (index < recordList.Count - 1 ? true : false), Success = true, DataUpdate = FormatExpensifyOutputRecords(recordList), FooterUpdate = FormatExpensifyFooter(recordList), SubmitPrompt = FormatExpensifySubmitPrompt (recordList) }; } [WebMethod] public static AjaxCallResult ExpensifyRecordsetCommit(string masterGuid) { AuthenticationData authData = GetAuthenticationDataAndCulture(); // Commit all expenses in the recordset try { List recordList = (List) GuidCache.Get("ExpensifyData-" + masterGuid); string expensifyRaw = (string) GuidCache.Get("ExpensifyRaw-" + masterGuid); ExpenseClaimGroup expenseClaimGroup = ExpenseClaimGroup.Create(authData.CurrentOrganization, authData.CurrentUser, ExpenseClaimGroupType.Expensify, expensifyRaw); foreach (ExpensifyRecord record in recordList) { FinancialAccount budget = FinancialAccount.FromIdentity(record.BudgetId); ExpenseClaim claim = ExpenseClaim.Create(authData.CurrentUser, authData.CurrentOrganization, budget, record.Timestamp, record.CategoryCustom + " / " + record.Description, record.AmountCents, record.VatCents, expenseClaimGroup); record.Documents.SetForeignObjectForAll(claim); // TODO: Log } if (recordList.Count > 1) { return new AjaxCallResult { Success = true, DisplayMessage = String.Format(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_SuccessSeveral"), recordList.Count) }; } return new AjaxCallResult { Success = true, DisplayMessage = LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_SuccessOne") }; } catch (Exception exc) { return new AjaxCallResult { Success = false, DisplayMessage = exc.ToString() }; } } [WebMethod] public static AjaxCallExpensifyUploadResult GetExpensifyUploadResult(string guid) { // This may throw and it's okay return (AjaxCallExpensifyUploadResult) GuidCache.Get("Results-" + guid); } [WebMethod] public static AjaxCallExpensifyRecordResult GetExpensifyRecord(string masterGuid, string recordGuid) { GetAuthenticationDataAndCulture(); List recordList = (List) GuidCache.Get("ExpensifyData-" + masterGuid); int index = LocateRecordsetIndex(recordList, recordGuid); return new AjaxCallExpensifyRecordResult { Amount = (recordList[index].AmountCents / 100.0).ToString("N2"), AmountVat = (recordList[index].VatCents / 100.0).ToString("N2"), Description = recordList[index].Description, DocumentId = recordList[index].Documents.First().Identity, BudgetId = recordList[index].BudgetId, Guid = recordGuid, ExistNext = (index < recordList.Count - 1? true: false), Success = true }; } private static int LocateRecordsetIndex(List recordList, string recordGuid) { // Linear search for the GUID -- a report should have more than a couple dozen records at most // so this is not a real need for optimization int index = 0; while (index < recordList.Count && recordList[index].Guid != recordGuid) { index++; } if (index >= recordList.Count) { // not found throw new ArgumentException("Could not locate record GUID"); } return index; } public class BarfException: Exception {} private enum ExpensifyColumns { Unknown = 0, Timestamp, AmountFloat, Merchant, Comment, CategoryCustom, CategoryStandard, VatFloat, OriginalCurrency, OriginalCurrencyAmountFloat, ReceiptUrl } private class ExpensifyRecord { public Int64 AmountCents { get; set; } public Int64 VatCents { get; set; } public string Description { get; set; } public string CategoryCustom { get; set; } public string CategoryStandard { get; set; } public Currency OriginalCurrency { get; set; } public Int64 OriginalAmountCents { get; set; } public string ReceiptUrl { get; set; } public DateTime Timestamp { get; set; } public string ExtendedInfo { get; set; } public string ReceiptFileNameHere { get; set; } public Documents Documents { get; set; } public int BudgetId { get; set; } // Initializes to 0 public string Guid { get; set; } } // Timestamp,Merchant,Amount,MCC,Category,Tag,Comment,Reimbursable,"Original Currency","Original Amount",Receipt protected void ButtonRequest_Click (object sender, EventArgs e) { // The data has been validated client-side already. We'll throw unfriendly exceptions if invalid data is passed here. // People who choose to disable JavaScript and then submit bad input almost deserve to be hurt. DateTime expenseDate = this.DateExpenseIncurred.Value; Int64 amountCents = this.CurrencyAmount.Cents; Int64 vatCents = this.CurrencyVat.Cents; string description = this.TextPurpose.Text; FinancialAccount budget = this.ComboBudgets.SelectedAccount; // If the expense happened now, get the timestamp of today as well if (expenseDate.Date == DateTime.Today) { expenseDate = DateTime.UtcNow; } // sanity check if (budget.Organization.Identity != CurrentOrganization.Identity) { throw new InvalidOperationException ("Budget-organization mismatch; won't file expense claim"); } // Store bank details for current user CurrentUser.BankName = this.TextBank.Text; CurrentUser.BankClearing = this.TextClearing.Text; CurrentUser.BankAccount = this.TextAccount.Text; // Get documents; check that documents have been uploaded Documents documents = Documents.RecentFromDescription (this.FileUpload.GuidString); if (documents.Count == 0) { throw new InvalidOperationException ("No documents uploaded"); } ExpenseClaim claim = ExpenseClaim.Create (CurrentUser, CurrentOrganization, budget, expenseDate, description, amountCents, vatCents); foreach (int tagSetId in this._tagSetIds) { string selectedTagString = Request.Form["DropTags" + tagSetId.ToString (CultureInfo.InvariantCulture)]; if (!String.IsNullOrEmpty (selectedTagString)) { int selectedTagType = Int32.Parse (selectedTagString); if (selectedTagType != 0) { claim.FinancialTransaction.CreateTag ( FinancialTransactionTagType.FromIdentity (selectedTagType), CurrentUser); } } } documents.SetForeignObjectForAll (claim); string successMessage = string.Format (LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_SuccessMessagePartOne"), CurrentOrganization.Currency.Code, amountCents/100.0, budget.Name); if (budget.OwnerPersonId != CurrentUser.Identity) { successMessage += "

" + LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_SuccessMessagePartTwo") + "
"; } else { successMessage += "

" + LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_SuccessMessagePartTwoOwnBudget") + "
"; claim.Approve (CurrentUser); } DashboardMessage.Set (successMessage); // Redirect to dashboard Response.Redirect ("/", true); } protected class TagSetDataSourceItem { public int TagSetId { get; set; } public string TagSetLocalizedName { get; set; } } // ASPX localizations // ReSharper disable InconsistentNaming public string Localized_ValidationError_MissingTag { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_ValidationError_MissingTag")); } } public string Localized_ValidationError_BankAccount { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "RequestCashAdvance_ValidationError_BankAccount")); } } public string Localized_ValidationError_BankClearing { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "RequestCashAdvance_ValidationError_BankClearing")); } } public string Localized_ValidationError_BankName { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "RequestCashAdvance_ValidationError_BankName")); } } public string Localized_ValidationError_Purpose { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_ValidationError_Purpose")); } } public string Localized_ValidationError_Budget { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "RequestCashAdvance_ValidationError_Budget")); } } public string Localized_ValidationError_Amount { get { return JavascriptEscape(String.Format(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_ValidationError_Amount"), CurrentOrganization.Currency.DisplayCode)); } } public string Localized_ValidationError_Documents { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_ValidationError_Documents")); } } public string Localized_Expensify_NeedBudgetsForAll { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_NeedBudgetsForAll")); } } public string Localized_Expensify_NoRecords { get { return JavascriptEscape(LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_Expensify_NoRecordsLeft")); } } } public class ExpensifyOutputRecord { public string Description { get; set; } public string BudgetText { get; set; } public string Amount { get; set; } public string AmountVat { get; set; } public string CreatedDateTime { get; set; } public string Actions { get; set; } public string Guid { get; set; } } public class AjaxCallExpensifyUploadResult: AjaxCallResult { public string ErrorType { get; set; } public ExpensifyOutputRecord[] Data { get; set; } public ExpensifyOutputRecord[] Footer { get; set; } public string Documents { get; set; } public string SubmitPrompt { get; set; } } public class AjaxCallExpensifyRecordResult : AjaxCallResult { public string Amount { get; set; } public string AmountVat { get; set; } public string Description { get; set; } public int DocumentId { get; set; } public int BudgetId { get; set; } public string Guid { get; set; } public bool ExistNext { get; set; } public ExpensifyOutputRecord[] DataUpdate { get; set; } public ExpensifyOutputRecord[] FooterUpdate { get; set; } public string SubmitPrompt { get; set; } } }