static void ExportAsExcel(string[] args)
{
var reviews = GetReviews();
CSVCreator csvCreator = new CSVCreator("D:\\MetalImpact.csv");
csvCreator.CreateCSVFrom(reviews);
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", "Post", Route = null)] HttpRequest req,
ILogger log)
{
GDCGetTablesInput gdcInput;
string sqlConnectionString;
try
{
var body = await new StreamReader(req.Body).ReadToEndAsync();
gdcInput = JsonConvert.DeserializeObject <GDCGetTablesInput>(body);
}
catch (System.Exception ex)
{
return(new BadRequestObjectResult($"An error occurred while deserializing input: {ex.ToString()}"));
}
try
{
sqlConnectionString = await new RetrieveSecretCommand(gdcInput.keyVaultURI, gdcInput.sqlConnectionStringSecret).ExecuteAsync();
}
catch (System.Exception ex)
{
return(new BadRequestObjectResult($"An error occurred while pulling secrets from Key Vault: {ex.ToString()}"));
}
string contactsReturn = null;
try
{
List <GDCContact> contacts = new List <GDCContact>();
using (IDbConnection db = new SqlConnection(sqlConnectionString))
{
contacts = db.Query <GDCContact>(@"SELECT * FROM dbo.v_ConversationSentiment_CRM", 300).ToList();
}
if (gdcInput.returnFormat == "csv")
{
contactsReturn = CSVCreator.CreateCSVTextFile(contacts);
return(new OkObjectResult(contactsReturn));
}
else
{
contactsReturn = JsonConvert.SerializeObject(contacts, Formatting.Indented);
return(new OkObjectResult(contactsReturn));
}
//Stupid worthless comment
}
catch (System.Exception ex)
{
return(new BadRequestObjectResult($"An error occured getting contacts from the SQL Database. {ex.ToString()}"));
}
}
static void ExportAsExcel(string[] args)
{
var reviews = GetReviews();
CSVCreator csvCreator = new CSVCreator("D:\\MetalImpact.csv");
csvCreator.CreateCSVFrom(reviews);
}
public void CMW030_DownloadBLR060CsvReport(DateTime?GenerateDateFrom, DateTime?GenerateDateTo)
{
ObjectResultData res = new ObjectResultData();
IBillingHandler billingHandler = ServiceContainer.GetService <IBillingHandler>() as IBillingHandler;
var datas = billingHandler.GetRptInvoiceIssueList(GenerateDateFrom, GenerateDateTo);
MemoryStream csv = CSVCreator.CreateCSVSteam <doGetRptInvoiceIssueList>(datas, "Common\\CMS030_BLR060Csv");
string fName = string.Format("{0}BLR060_{1}-{2}.csv"
, DateTime.Now.ToString("yyyyMM"), GenerateDateFrom.Value.ToString("yyyyMMdd"), GenerateDateTo.Value.ToString("yyyyMMdd"));
this.DownloadCSVFile(fName, csv.ToArray());
}
void btnGenerate_Click(object sender, EventArgs e)
{
int rowCount;
if (!int.TryParse(txtRows.Text, out rowCount))
{
txtRows.Clear();
return;
}
CSVCreator creator = new CSVCreator(new FileNameCreator(), new FileDateCreator(),
new FilePhoneCreator(), new FileCityCreator(), new FileEmailCreator());
users = creator.CreateUsers(rowCount);
usersGridView.DataSource = null;
usersGridView.DataSource = users;
usersListBox.Items.Clear();
usersListBox.Items.AddRange(users.Select(u => u.ToString()).ToArray());
}
public HttpResponseMessage GetAllAsCSV()
{
var publications = _publicationBaseRepository.Get();
AppendJournalInformations(publications);
using (var stream = new MemoryStream())
{
var creator = new CSVCreator(stream);
creator.CreateToStream(publications);
var result = new HttpResponseMessage(HttpStatusCode.OK);
result.Content = new ByteArrayContent(stream.ToArray());
result.Content.Headers.ContentType =
new MediaTypeHeaderValue("text/csv");
result.Content.Headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment")
{
FileName = string.Format("DumpAll_{0}.csv", DateTime.Now.ToString("yyyyMMddHHmmss")),
};
return(result);
}
}
