public static void Main(string[] args)
{
Console.WriteLine($"Requested on {DateTime.Now.ToString($"dd'/'MM'/'yyyy' at 'HH':'mm':'ss")}");
Console.WriteLine("Do you want to get Crypto's current 'Buy' or 'Sell' price?");
var price = Console.ReadLine().ToLower();
var csvParserService = new CsvParserService();
var records = csvParserService.ReadCsvFile("fills.csv");
var cryptoPortfolio = records
.Select(a => a.SizeUnit)
.Distinct()
.ToList();
var table = new ConsoleTable(
"Name",
"Amount",
"Total Cost",
"Current Value",
"Gain/Loss",
"%",
"Crypto's Live Price",
"Your Average Price (Weighted)"
);
foreach (var crypto in cryptoPortfolio)
{
var returnCalculator = new CalculatorService();
var row = returnCalculator.CalculateReturn(records, crypto, price);
table.AddRow(
$"{row.Name}",
$"{row.Amount}",
$"{row.Cost}",
$"{row.CurrentValue}",
$"{row.GainLoss}",
$"{row.PercentageDiff}",
$"{row.CurrentPrice}",
$"{row.WeightedAvg}"
);
}
table.Write(Format.Alternative);
}
public IEnumerable <MemberClaimDetails> Get(DateTime dt)
{
var csvParserService = new CsvParserService();
var path = @"C:\\Users\\gopin\\Downloads\\WebAPI-SampleProject\\Claim.csv";
var path1 = @"C:\\Users\\gopin\\Downloads\\WebAPI-SampleProject\\Member.csv";
var allClaims = csvParserService.ReadCsvFileToClaimsModel(path);
var allMembers = csvParserService.ReadCsvFileToMemberModel(path1);
// List<Claims> q = allClaims.FindAll(t => t.ClaimDate <= dt.Date);
var mcDetails = allMembers.Select(s =>
new MemberClaimDetails
{
MemberId = s.MemberId,
FirstName = s.FirstName,
LastName = s.LastName,
EnrollmentDate = s.EnrollmentDate,
ClaimDetails = allClaims.Where(g => g.MemberId == s.MemberId && g.ClaimDate <= dt.Date).ToArray()
});
return(mcDetails.ToArray()); //
}
public static void WriteCSV(string company, string jobtitle, string city, string joburl)
{
string appDataPath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
string srcPath = Path.Combine(appDataPath, "latex_curriculum_vitae");
var csvParserService = new CsvParserService();
var path = Path.Combine(srcPath, "JobApplications.csv");
var result = csvParserService.ReadCsvFileToJobApplicationModel(path);
var jobApplicationToAdd = new JobApplicationModel()
{
Company = company,
Jobtitle = jobtitle,
City = city,
Status = Properties.Resources.CsvEmailSent,
EmailSent = DateTime.Today,
JobOfferUrl = joburl
};
result.Add(jobApplicationToAdd);
csvParserService.WriteNewCsvFile(path, result);
}
static void Main(string[] args)
{
Console.WriteLine("**** Read a CSV file *****");
var csvParserService = new CsvParserService();
var path = @"C:\Users\didou\Documents\CSVHelperProject\Employee.csv";
var result = csvParserService.ReadCsvFileToEmployeeModel(path);
var employeeToAdd = new EmployeeModel()
{
Address = "address 20",
City = "city 20",
Direction = "direction 20",
Firstname = "first name 20",
Email = "*****@*****.**",
Lastname = "lastname 20",
Mobile = "1111",
Salary = "100000"
};
result.Add(employeeToAdd);
Console.WriteLine("**** Write a CSV file *****");
csvParserService.WriteNewCsvFile(@"C:\Users\didou\Documents\CSVHelperProject\Employee1.csv", result);
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
Console.WriteLine(" ");
string fileTimeStamp = DateTime.Now.ToString("yyyyMMddHHmmss");
string filepath = @"c:\temp\csvFiles\myCsvFile.csv";
//=========================================================//
Console.WriteLine(" ");
Console.WriteLine("File Timestamp: " + fileTimeStamp);
Console.WriteLine(" ");
Console.WriteLine("**** Read a CSV file *****");
Console.WriteLine(" ");
var csvParserService = new CsvParserService();
var result = csvParserService.ReadCsvFileToLoanModel(filepath);
//var employeeToAdd = new EmployeeModel()
//{
// Address = "address 20",
// City = "city 20",
// Direction = "direction 20",
// Firstname = "first name 20",
// Email = "*****@*****.**",
// Lastname = "lastname 20",
// Mobile = "1111",
// Salary = "100000"
//};
//
//result.Add(loanToAdd);
Console.WriteLine("**** List Input Records *****");
Console.WriteLine(" ");
foreach (LoanModel loan in result)
{
Console.WriteLine($"Loan Info: {loan.BorrowerName} " +
$"{loan.City} {loan.State} {loan.LoanNumber} {loan.LoanAmount}");
}
Console.WriteLine("**** Update Input File Records *****");
Console.WriteLine(" ");
foreach (LoanModel loan in result)
{
Random rnd = new Random();
int index = rnd.Next(1, 301);
NameHelper nameHelper = new NameHelper();
string newBowrrowerName = nameHelper.PerformGetLastName(index);
//string newBowrrowerName = loan.BorrowerName + "-Smith";
loan.BorrowerName = newBowrrowerName;
int tmpLoanNumber = int.Parse(loan.LoanNumber);
tmpLoanNumber += 5;
loan.LoanNumber = tmpLoanNumber.ToString();
}
Console.WriteLine("**** Write Updated CSV file *****");
Console.WriteLine(" ");
string outFile = @"C:\temp\csvfiles\myCsvFile-" + fileTimeStamp + ".csv";
csvParserService.WriteNewCsvFile(outFile, result);
Console.WriteLine("Modified CSV File written to disk - " + outFile);
Console.WriteLine("Press any key to continue...");
Console.ReadLine();
//=========================================================//
Console.WriteLine("Listing the updated records to the console...");
Console.WriteLine(" ");
foreach (LoanModel loan in result)
{
Console.WriteLine($"Loan Info: {loan.BorrowerName} " +
$"{loan.City} {loan.State} {loan.LoanNumber} {loan.LoanAmount}");
}
Console.WriteLine(" ");
Console.WriteLine(" ");
Console.WriteLine("Press any key to continue...");
Console.ReadLine();
}
public void Setup()
{
_parser = new CsvParserService();
}
