public void HtmlGeneratesAsExpected()
{
var HttpResults = System.IO.File.ReadAllText(ExpRelPath + "expected.json");
var generator = new GenerateHTML(RelPath + "generated", ExpRelPath + "boilerplate.html");
var success = generator.GenerateReport(HttpResults);
Assert.True(success);
Assert.True(FilesAreEqual(RelPath + "generated.html", ExpRelPath + "expected.html"));
}
private void btnSaveLocation_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog Savelocation = new SaveFileDialog();
Savelocation.DefaultExt = ".pdf";
Savelocation.Filter = "PDF (.pdf)|*.pdf";
bool?result = Savelocation.ShowDialog();
if (result == true)
{
string filename = "\"" + Savelocation.FileName; ///string.Join("_", Savelocation.FileName.Split(' '));
GenerateHTML.SaveaPDF(pubresults, filename, tmduration, txtNotes.Text); // Savelocation.FileName); Convert.ToString(DateTime.Now.Subtract(genTime).TotalMinutes) + " Seconds: " + Convert.ToString(DateTime.Now.Subtract(genTime).Seconds)
}
Window window = Window.GetWindow(this);
window.Close();
}
public async Task <string> GetEmployeeExpenseForPDF(string UserName, string MonthYear)
{
int dataExpCount = _appDbContext.Expenses.Where(e => e.UserName.Equals(UserName) && e.ExpenseMonth.Equals(MonthYear)).ToList().Count();
var dataExpenses = await(from e in _appDbContext.Expenses
join es in _appDbContext.ExpensesStatus
on e.ExpenseMonth equals es.ExpenseMonth
where e.UserName.Equals(es.UserName) && e.ExpenseMonth.Equals(es.ExpenseMonth) &&
e.UserName.Equals(UserName) && e.ExpenseMonth.Equals(MonthYear)
select new EmployeeExpensesViewModel
{
ID = e.Id,
UserName = e.UserName,
PresentType = e.PresentType,
ExpenseMonth = e.ExpenseMonth,
Date = e.Date,
HQ = e.Hq,
HQName = (from m in _appDbContext.MasterKeyValue
where m.Id == e.Hq
select m.Value).FirstOrDefault(),
Region = e.Region,
BikeAllowance = e.BikeAllowance,
DailyAllowance = e.DailyAllowance,
OtherAmount = e.OtherAmount,
ClaimAmount = e.ClaimAmount,
EmployeeRemark = e.EmployeeRemark,
ApprovedAmount = e.ApprovedAmount,
ApprovedBy = e.ApprovedBy,
ApproverRemark = e.ApproverRemark,
Status = es.Status
}).OrderBy(x => x.Date).ToListAsync().ConfigureAwait(false);
//dataExpenses.OrderBy(f => f.Date);
var dataUsers = await(from u in _appDbContext.Users
where u.UserName.Equals(UserName)
select new RegistrationViewModel
{
ID = u.Id,
FirstName = u.FirstName,
MiddleName = u.MiddleName,
LastName = u.LastName,
Department = u.Department,
DepartmentName = (from depm in _appDbContext.MasterKeyValue
where depm.Id == u.Department
select depm.Value).FirstOrDefault(),
Desigination = u.Desigination,
DesiginationName = (from desm in _appDbContext.MasterKeyValue
where desm.Id == u.Desigination
select desm.Value).FirstOrDefault(),
}).ToListAsync().ConfigureAwait(false);
var dataMobile = await(from mst in _appDbContext.MasterKeyValue
where mst.Type.Equals(EmployeeConstant.Mobile)
select Convert.ToInt32(mst.Value)).FirstOrDefaultAsync().ConfigureAwait(false);
var dataFare = await(from mst in _appDbContext.MasterKeyValue
where mst.Type.Equals(EmployeeConstant.Fare)
select Convert.ToInt32(mst.Value)).FirstOrDefaultAsync().ConfigureAwait(false);
var dataStationery = await(from mst in _appDbContext.MasterKeyValue
where mst.Type.Equals(EmployeeConstant.Stationery)
select Convert.ToInt32(mst.Value)).FirstOrDefaultAsync().ConfigureAwait(false);
var dataCyber = await(from mst in _appDbContext.MasterKeyValue
where mst.Type.Equals(EmployeeConstant.Cyber)
select Convert.ToInt32(mst.Value)).FirstOrDefaultAsync().ConfigureAwait(false);
if (dataExpCount < 15)
{
dataMobile /= 2;
dataFare /= 2;
dataStationery /= 2;
dataCyber /= 2;
}
return(GenerateHTML.GetHTMLEmployeeExpense(dataUsers.ToList()[0], dataExpenses.ToList(), dataMobile, dataFare, dataStationery, dataCyber));
}