public string SaveTimesheetExpense(int timesheetId, string title, DateTime date, string filePath)
{
SqlCommand command = GetCommandForTimesheetExpenseUpload(timesheetId, title, date, filePath);
var fsh = new FileStreamHelper();
var conn = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
fsh.SaveDocumentWithoutFileStream(command, conn, filePath);
return command.Parameters["@DocumentId"].Value.ToString();
}
public string SaveInvoiceFile(int invoiceId, string filePath)
{
SqlCommand command = GetCommandForInvoiceUpload(invoiceId, filePath);
var fsh = new FileStreamHelper();
var conn = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
fsh.SaveDocumentWithoutFileStream(command, conn, filePath);
return command.Parameters["@DocumentId"].Value.ToString();
}