Files
using.cash/Site/Pages/v5/Financial/FileExpenseClaim.aspx.cs
2021-07-09 22:24:01 +02:00

1144 lines
47 KiB
C#

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<TagSetDataSourceItem> dataSourceVisibleTags = new List<TagSetDataSourceItem>();
List<TagSetDataSourceItem> dataSourceForcedTags = new List<TagSetDataSourceItem>();
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<string> tagSetIdStringList = new List<string>();
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<ExpensifyColumns, int> fieldMap = new Dictionary<ExpensifyColumns, int>();
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<ExpensifyRecord> recordList = new List<ExpensifyRecord>();
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*(?<jsonTxInfo>{.*});", 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<ExpensifyOutputRecord> outputRecords = new List<ExpensifyOutputRecord>();
string docString =
"<a href='/Pages/v5/Support/StreamUpload.aspx?DocId={0}&hq=1' data-caption=\"{1}\" class='FancyBox_Gallery' data-fancybox='{2}'>";
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<ExpensifyRecord> recordList)
{
List<ExpensifyOutputRecord> outputRecords = new List<ExpensifyOutputRecord>();
const string doxString =
"<img src='/Images/Icons/iconshock-search-256px.png' onmouseover=\"this.src='/Images/Icons/iconshock-search-hot-256px.png';\" onmouseout=\"this.src='/Images/Icons/iconshock-search-256px.png';\" data-docid='{0}' class='LocalViewDox' style='cursor:pointer' height='20' width='20' />";
const string editString =
"<img src='/Images/Icons/iconshock-wrench-128x96px-centered.png' height='18' width='24' class='LocalEditExpenseClaim' data-guid='{0}' />";
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 + " &raquo; " + account.Name;
}
}
else
{
newRecord.BudgetText =
"<span class='LocalEditExpenseClaim' data-guid='" + record.Guid + "'>" +
LocalizedStrings.Get(LocDomain.Global, "Global_DropInits_SelectFinancialAccount") + "</span>";
}
outputRecords.Add(newRecord);
}
return outputRecords.ToArray();
}
private static ExpensifyOutputRecord[] FormatExpensifyFooter(List<ExpensifyRecord> recordList)
{
Int64 amountCentsTotal =0;
Int64 vatCentsTotal =0;
foreach (ExpensifyRecord record in recordList)
{
amountCentsTotal += record.AmountCents;
vatCentsTotal += record.VatCents;
}
ExpensifyOutputRecord newRecord = new ExpensifyOutputRecord
{
Amount = "<span class='weight-more-emphasis'>" + (amountCentsTotal / 100.0).ToString("N2") + "</span>",
AmountVat = "<span class='weight-more-emphasis'>" + (vatCentsTotal / 100.0).ToString("N2") + "</span>",
BudgetText = "<span class='weight-more-emphasis'>" + LocalizedStrings.Get(LocDomain.Global, "Global_Total").ToUpperInvariant() + "</span>"
};
List<ExpensifyOutputRecord> listResult = new List<ExpensifyOutputRecord>();
listResult.Add(newRecord);
return listResult.ToArray();
}
private static string FormatExpensifySubmitPrompt(List<ExpensifyRecord> 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<ExpensifyRecord> recordList = (List<ExpensifyRecord>)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<ExpensifyRecord> recordList = (List<ExpensifyRecord>)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<ExpensifyRecord> recordList = (List<ExpensifyRecord>) 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<ExpensifyRecord> recordList = (List<ExpensifyRecord>) 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<ExpensifyRecord> 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 += "<br/><br/>" + LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_SuccessMessagePartTwo") +
"<br/>";
}
else
{
successMessage += "<br/><br/>" +
LocalizedStrings.Get(LocDomain.PagesFinancial, "FileExpenseClaim_SuccessMessagePartTwoOwnBudget") +
"<br/>";
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; }
}
}