static void Main(string[] args) { Parser.Default.ParseArguments <LoginOptions, WithdrawOptions, InstantTransferOptions, DelayedTransferOptions, PermanentTransferOptions, CreateSavingsAccountOptions, DeleteSavingsAccountOptions, InfoSavingAccountsOptions, InfoCurrentAccountsOptions, CreateClientOptions, DeleteClientOptions, ModifyPasssOptions, InfoUserOptions, InfoTransactionOptions, ExportOptions, AddDonatorsOptions>(args) .WithParsed <LoginOptions>(RunLoginUser) .WithParsed <WithdrawOptions>(RunWithdrawOptions) .WithParsed <InstantTransferOptions>(RunInstantTransferOptions) .WithParsed <DelayedTransferOptions>(RunDelayedTransferOptions) .WithParsed <PermanentTransferOptions>(RunPermanentTransferOptions) .WithParsed <CreateClientOptions>(RunCreateClientOptions) .WithParsed <DeleteClientOptions>(RunDeleteClientOptions) .WithParsed <ModifyPasssOptions>(RunModifyPassOptions) .WithParsed <CreateSavingsAccountOptions>(RunCreateSavingsAccountOptions) .WithParsed <DeleteSavingsAccountOptions>(RunDeleteSavingsAccountOptions) .WithParsed <InfoSavingAccountsOptions>(RunSavingAccountsInfoOptions) .WithParsed <InfoCurrentAccountsOptions>(RunCurrentAccountsInfoOptions) .WithParsed <InfoUserOptions>(RunInfoUserOptions) .WithParsed <InfoTransactionOptions>(RunInfoTransactionOptions) .WithParsed <ExportOptions>(RunExportOptions) .WithParsed <AddDonatorsOptions>(RunAddDonatorOptions); ConnectionDB.GetConnectionString(); }
public static void ExportCSVFile(string exportPath) { string queryString = GetTransactions(); SqlConnection connection = new SqlConnection(ConnectionDB.GetConnectionString()); connection.Open(); Random randomNumber = new Random(); int a = randomNumber.Next(1, int.MaxValue); string exportCsv = $"exportFileDB{a}.csv"; if (Directory.Exists(exportPath)) { try { SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); StreamWriter csvFile = new StreamWriter(@exportPath + "\\" + exportCsv); object[] output = new object[reader.FieldCount]; for (int i = 0; i < reader.FieldCount; i++) { output[i] = reader.GetName(i); } csvFile.WriteLine(string.Join(", ", output)); while (reader.Read()) { reader.GetValues(output); csvFile.WriteLine(string.Join(", ", output)); } Console.WriteLine("Data export successful."); csvFile.Close(); reader.Close(); } catch (Exception e) { Console.WriteLine("Data export unsuccessful." + e); Environment.Exit(0); } } else { Console.WriteLine("File path does not exist."); } connection.Close(); }