public HomeController(ILogger <HomeController> logger)
{
_logger = logger;
_serviceContainer = new Container().GetServiceContainer;
_payinfo = new AllPayments();
_creditInfo = _serviceContainer.GetInstance <ICreditInfo>();
}
public IActionResult Index(BankCreditData bankCreditData)
{
var result = _creditInfo.Calculate(bankCreditData);
_payinfo = new Converter().PaytablesConverter(result);
HttpContext.Session.SetJson("Payinfo", _payinfo);
return(View());
}
private void NewPayment(object obj)
{
IPayment newPayment = new Payment();
_bon.Payments.Add(newPayment);
PaymentViewModel zahlungWrapper = new PaymentViewModel(newPayment, _DBConnection);
zahlungWrapper.PropertyChanged -= dingsda;
zahlungWrapper.PropertyChanged += dingsda;
AllPayments.Add(zahlungWrapper);
CurrentPayment = zahlungWrapper;
RaisePropertyChanged("CurrentPayment");
RaisePropertyChanged("SumToPay");
RaisePropertyChanged("PaymentsExist");
}
private void Loaded()
{
EditCommand = null;
AllPayments.Clear();
foreach (var payment in paymentRepository.LoadRecurringList())
{
AllPayments.Add(payment);
}
Source = new ObservableCollection <AlphaGroupListGroup <Payment> >(
AlphaGroupListGroup <Payment> .CreateGroups(AllPayments,
CultureInfo.CurrentUICulture,
s => s.ChargedAccount.Name));
//We have to set the command here to ensure that the selection changed event is triggered earlier
EditCommand = new MvxCommand <Payment>(Edit);
}
public Converter()
{
_payinfo = new AllPayments();
}
public ActionResult SumMoneyByMonth(string months)
{
if (Session["empName"] != null)
{
if (months == null)
{
HttpNotFound();
}
string name = Session["empName"].ToString();
var emp = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault();
var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == emp.id).FirstOrDefault();
if (_allowAll.Staticis == true)
{
ViewBag.Month = new SelectList(_db.Month.ToList(), "id", "months");
var model = new AllPayments();
model.caseX = _db.Cases.Where(s => s.dateofElkaeed.Month.ToString() == months).ToList();
var EmpCase = _db.Cases.Where(s => s.dateofElkaeed.Month.ToString() == months).FirstOrDefault();
var Emptsalary = _db.Salaries.Where(s => s.month == months).FirstOrDefault();
if (EmpCase == null && Emptsalary == null)
{
ViewBag.sumofcases = 0;
model.EmpX = _db.Employee.ToList();
ViewBag.SumofEmp = _db.Employee.Sum(s => s.Salary);
model.feesX = _db.feeses.Where(s => s.DateofRevice.Month.ToString() == months).ToList();
ViewBag.sumoffees = 0;
model.salaryX = _db.Salaries.Where(s => s.month == months).ToList();
ViewBag.SumofSalary = 0;
ViewBag.subtractCase = ViewBag.sumofcases - ViewBag.sumoffees;
ViewBag.subtractSalary = ViewBag.SumofEmp - ViewBag.SumofSalary;
ViewBag.month = months;
return(View("SumMoneyByMonth"));
}
else if (EmpCase == null)
{
ViewBag.sumofcases = 0;
model.EmpX = _db.Employee.ToList();
ViewBag.SumofEmp = _db.Employee.Sum(s => s.Salary);
model.feesX = _db.feeses.Where(s => s.DateofRevice.Month.ToString() == months).ToList();
ViewBag.sumoffees = 0;
model.salaryX = _db.Salaries.Where(s => s.month == months).ToList();
ViewBag.SumofSalary = _db.Salaries.Where(s => s.month == months).Sum(s => s.salary);
ViewBag.subtractCase = ViewBag.sumofcases - ViewBag.sumoffees;
ViewBag.subtractSalary = ViewBag.SumofEmp - ViewBag.SumofSalary;
ViewBag.month = months;
return(View("SumMoneyByMonth"));
}
else if (Emptsalary == null)
{
ViewBag.sumofcases = _db.Cases.Where(s => s.dateofElkaeed.Month.ToString() == months).Sum(s => s.money);
model.EmpX = _db.Employee.ToList();
ViewBag.SumofEmp = _db.Employee.Sum(s => s.Salary);
model.feesX = _db.feeses.Where(s => s.DateofRevice.Month.ToString() == months).ToList();
ViewBag.sumoffees = model.feesX.Where(s => s.DateofRevice.Month.ToString() == months).Sum(s => s.recived);
model.salaryX = _db.Salaries.Where(s => s.month == months).ToList();
ViewBag.SumofSalary = 0;
ViewBag.subtractCase = ViewBag.sumofcases - ViewBag.sumoffees;
ViewBag.subtractSalary = ViewBag.SumofEmp - ViewBag.SumofSalary;
ViewBag.month = months;
return(View("SumMoneyByMonth"));
}
ViewBag.sumofcases = _db.Cases.Where(s => s.dateofElkaeed.Month.ToString() == months).Sum(s => s.money);
model.EmpX = _db.Employee.ToList();
ViewBag.SumofEmp = _db.Employee.Sum(s => s.Salary);
model.feesX = _db.feeses.Where(s => s.DateofRevice.Month.ToString() == months).ToList();
ViewBag.sumoffees = _db.feeses.Where(s => s.DateofRevice.Month.ToString() == months).Sum(s => s.recived);
model.salaryX = _db.Salaries.Where(s => s.month == months).ToList();
ViewBag.SumofSalary = _db.Salaries.Where(s => s.month == months).Sum(s => s.salary);
ViewBag.subtractCase = ViewBag.sumofcases - ViewBag.sumoffees;
ViewBag.subtractSalary = ViewBag.SumofEmp - ViewBag.SumofSalary;
ViewBag.month = months;
return(View("SumMoneyByMonth"));
}
}
return(RedirectToAction("HavntAccess", "Employees"));
}
public ActionResult TotalPayments(string months)
{
if (Session["empName"] != null)
{
string name = Session["empName"].ToString();
var emp = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault();
var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == emp.id).FirstOrDefault();
if (_allowAll.Staticis == true)
{
ViewBag.Month = new SelectList(_db.Month.ToList(), "id", "months");
var model = new AllPayments();
model.caseX = _db.Cases.ToList();
// var cases = _db.Cases.ToList();
if (model.caseX != null)
{
int sumcases = model.caseX.Sum(s => s.money);
ViewBag.sumofcases = sumcases;
}
else
{
ViewBag.sumofcases = 0;
}
model.EmpX = _db.Employee.ToList();
if (model.EmpX != null)
{
int sumEmp = _db.Employee.Sum(s => s.Salary);
ViewBag.SumofEmp = sumEmp;
}
else
{
ViewBag.SumofEmp = 0;
}
model.feesX = _db.feeses.ToList();
if (model.feesX != null)
{
int sumFess = model.feesX.Sum(s => s.recived);;
ViewBag.sumoffees = sumFess;
}
else
{
ViewBag.sumoffees = 0;
}
model.salaryX = _db.Salaries.ToList();
if (model.salaryX != null)
{
int sumSalary = model.salaryX.Sum(s => s.salary);
ViewBag.SumofSalary = sumSalary;
}
else
{
ViewBag.SumofSalary = 0;
}
ViewBag.subtractCase = ViewBag.sumofcases - ViewBag.sumoffees;
ViewBag.subtractSalary = ViewBag.SumofEmp - ViewBag.SumofSalary;
return(View());
}
}
return(RedirectToAction("HavntAccess", "Employees"));
}
