public object Index([FromBody] UserModel userModel)
{
try
{
FinanceViewModel financeViewModel = new FinanceViewModel();
var userId = userModel.Id;
financeViewModel.Subscriptions = new List <Subscription>();
financeViewModel.Subscriptions = _financeRepository.GetSubscriptions(userId);
financeViewModel.PaymentMethods = new List <PaymentMethod>();
financeViewModel.PaymentMethods = _financeRepository.GetPaymentMethods(userId);
return(new SingleResponse <FinanceViewModel>
{
Message = string.Empty,
DidError = false,
ErrorMessage = string.Empty,
Token = string.Empty,
Model = financeViewModel
});
}
catch (Exception ex)
{
return(new SingleResponse <FinanceViewModel>
{
Message = ex.Message,
DidError = true,
ErrorMessage = ex.InnerException.ToString(),
Token = string.Empty,
Model = new FinanceViewModel()
});
}
}
public void EarlyCareerPaymentsFlag_On_Course_With_Maths_And_Physics_Should_Be_False(string subjects, int?earlyPaymentsFlag)
{
_subjectFunding.EarlyCareerPayments = earlyPaymentsFlag;//here is the "not null" setting refered to in the name of the test
_emptyCourse.CourseSubjects = SetupSubjects(subjects, _subjectFunding);
var financeViewModel = new FinanceViewModel(_emptyCourse, _feeCaps);
financeViewModel.HasEarlyCareerPayments.Should().Be(false);
}
public void EarlyCareerPaymentsFlag_On_Course_With_Not_Null_Setting_Should_Be_True(string subjects, int?earlyPaymentsFlag)
{
_subjectFunding.EarlyCareerPayments = earlyPaymentsFlag;
_emptyCourse.CourseSubjects = SetupSubjects(subjects, _subjectFunding);
var financeViewModel = new FinanceViewModel(_emptyCourse, _feeCaps);
financeViewModel.HasEarlyCareerPayments.Should().Be(true);
}
public StatisticViewModel(StatisticManagementBussiness bussiness)
{
Finance = new FinanceViewModel(bussiness.Finance);
Teacher = new TeacherViewModel(bussiness.Teacher);
Trainee = new TraineeViewModel(bussiness.Trainee);
General = new GeneralViewModel(bussiness.General);
StatisticFunc = 3;
}
public ActionResult AddDepense(FinanceViewModel fnVm)
{
if (ModelState.IsValid)
{
depenseCtx.AddDepenses(fnVm.CurrentDepense);
}
return(View("Finance", fnVm));
}
public Finance()
{
InitializeComponent();
MostrarMicroChart("Donut", new DonutChart()
{
HoleRadius = 0.6F
});
BindingContext = new FinanceViewModel();
}
// *************** Finance ****************************
public ActionResult NewFinance(int id)
{
var financeVm = new FinanceViewModel()
{
Vendor = _vendorManager.GetAll(),
AssetEntryId = id
};
return(PartialView("PartialViews/AssetEntrys/_FinancePartialPage", financeVm));
}
public void TestFormattedYear(int startYear, int endYear, string expectedResult)
{
var viewModel = new FinanceViewModel(_emptyCourse, new FeeCaps
{
StartYear = startYear,
EndYear = endYear
});
var result = viewModel.FormattedYear;
result.Should().NotBeNullOrEmpty(result);
result.Should().Be(expectedResult);
}
public ActionResult QueryFinanceList(FinanceQueryViewModel queryModel)
{
var results = new List <FinanceViewModel>();
StringBuilder sbr = new StringBuilder();
if (queryModel.customname != null)
{
sbr.Append(" customname=" + queryModel.customname + " and");
}
if (queryModel.batchnumber != null)
{
sbr.Append(" batchnumber=" + queryModel.batchnumber + " and");
}
if (queryModel.returnpaystatus > 0)
{
sbr.Append(" returnpaystatus=" + "'" + queryModel.returnpaystatus + "'" + " and");
}
if (queryModel.billstatus > 0)
{
sbr.Append(" billstatus=" + "'" + queryModel.billstatus + "'" + " and");
}
var condition = sbr.ToString();
var sql = "select * from dbo.financeinfo";
if (!string.IsNullOrEmpty(condition))
{
sql += " where ";
sql += condition;
if (sql.Contains("and"))
{
var charArray = new char[] { 'a', 'n', 'd' };
sql = sql.TrimEnd(charArray);
}
}
var dbFinances = DapperWrapper.GetAll <Tfinance>(sql);
foreach (var item in dbFinances)
{
var financeVM = new FinanceViewModel();
#region convert db to viewmodel
var checkrow = "<a href=\"#\" onclick=\"checkFinance(this)\">查看</a>";
var editrow = "<a href=\"#\" onclick=\"editFinance(this)\">编辑</a>";
financeVM.operation = checkrow + " " + editrow;
#endregion
results.Add(financeVM);
}
return(Json(results));
}
public async Task <ActionResult> Finance(string id)
{
var response = await _accountHandler.FindFinance(id);
if (response.StatusCode == SearchResponseCodes.Success)
{
var vm = new FinanceViewModel
{
Account = response.Account,
Balance = response.Balance
};
return(View(vm));
}
return(HttpNotFound());
}
public async Task <IActionResult> CashFlowBase(string stockName)
{
// ToDo : handle with exceptions !
// loading company data
_gpwCompany = await _db.Company.Where(n => n.Name == stockName).ToListAsync();
var _companyData = _gpwCompany.First();
FinanceViewModel financeVM = new FinanceViewModel()
{
Company = _companyData,
FinanceCashFlow = await _db.CashFlow.Where(n => n.ComapanyName == stockName).OrderByDescending(m => m.RaportYear).ToListAsync(),
FinanceCashFlowDescription = new Models.FinanceCashFlow(),
};
return(View("CashFlow", financeVM));
}
// GET - Balance
public async Task <IActionResult> Balance(int id)
{
// ToDo : handle with exceptions !
// loading company data
_gpwCompany = await _db.Company.Where(n => n.Id == id).ToListAsync();
var _companyData = _gpwCompany.First();
FinanceViewModel financeVM = new FinanceViewModel()
{
Company = _companyData,
FinanceBalance = await _db.Balance.Where(n => n.CompanyId == _companyData.Id).OrderByDescending(m => m.RaportYear).ToListAsync(),
FinanceBalanceDescription = new Models.FinanceBalance()
};
return(View(financeVM));
}
public JsonResult SaveFinanceApi(FinanceViewModel financeVm)
{
ModelState.Remove("Id");
if (ModelState.IsValid)
{
var finance = new Finance()
{
AssetEntryId = financeVm.AssetEntryId,
VendorId = financeVm.VendorId,
PurchaseDate = financeVm.PurchaseDate,
ParchaseOrderNo = financeVm.ParchaseOrderNo,
ParchasePrice = financeVm.ParchasePrice
};
int count = _financeManager.Add(finance);
return(Json(count, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
public async Task <IHttpActionResult> Get(string fType, string nameContain, string month, string year, string day)
{
if (nameContain == "All")
{
return(Ok(await FinanceViewModel.MapFromAsync(db.SalesStages.Where(x => x.CompanyCode.Contains("") && x.DateInvoiced.Equals(year + month + day)).ToList())));
}
else
{
if (fType == "MonthSnapShot")
{
return(Ok(await FinanceViewModel.MapFromAsync(db.SalesStages.Where(x => (x.CompanyCode.Equals(nameContain) || x.PlantCode.Equals(nameContain)) && x.DateInvoiced.Substring(0, 6).Equals(year + month)).OrderBy(o => o.DateInvoiced).ToList())));
}
else
{
return(Ok(await FinanceViewModel.MapFromAsync(db.SalesStages.Where(x => (x.CompanyCode.Equals(nameContain) || x.PlantCode.Equals(nameContain)) && x.DateInvoiced.Equals(year + month + day)).ToList())));
}
}
}
public async Task <IHttpActionResult> Get(string fType, string nameContain, string month, string year)
{
if (nameContain == null)
{
nameContain = "";
}
if (fType == "Overtime")
{
return(Ok(await FinanceViewModel.MapFromAsync(db.OTMonthlyByCompanies.Where(x => x.CompanyCode.Equals(nameContain) && x.Year.Equals(year) && x.Month.Equals(month)).ToList())));
}
else if (fType == "Sales")
{
return(Ok(await FinanceViewModel.MapFromAsync(db.SalesDailyByCompanies.Where(x => x.CompanyCode.Equals(nameContain) && x.Year.Equals(year) && x.Month.Equals(month)).OrderBy(o => o.Date).ToList())));
}
else if (fType == "CWO")
{
return(Ok(await FinanceViewModel.MapFromAsync(db.CWODailyByPlants.Where(x => x.PlantCode.Equals(nameContain) && x.Year.Equals(year) && x.Month.Equals(month)).OrderBy(o => o.Day).ToList())));
}
return(null);
}
// GET
public async Task <IActionResult> Index()
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
FinanceViewModel financeViewModel = new FinanceViewModel()
{
Events = await _context.Events.AsQueryable().Where(x => x.UserId == userId).ToListAsync(),
Wallets = await _context.Wallets.AsQueryable().Where(x => x.UserId == userId).ToListAsync(),
EventCategories = await _context.EventCategories.ToListAsync()
};
financeViewModel.FinancialEvents = new List <FinancialEvent>();
foreach (var _event in financeViewModel.Events)
{
if (_event.FinancialEventId != 0)
{
var financialEvent = await _context.FinancialEvents.FindAsync(_event.FinancialEventId);
financeViewModel.FinancialEvents.Add(financialEvent);
}
}
@ViewData["Title"] = "Finances";
return(View(financeViewModel));
}
public ActionResult Index()
{
var viewmodel = new FinanceViewModel(baseviewmodel);
viewmodel.schoolList = new[] { new SelectListItem()
{
Value = "", Text = "Select school ..."
} }.Union(
repository.GetSchools().Select(x => new SelectListItem()
{
Text = x.name,
Value = x.id.ToString()
}));
// don't care about reminders, otherwise if reminder is > today then it will not show up
// check if they are any overdue fees. grouped by
var overdueStudents = db.fees.Where(x => x.status == FeePaymentStatus.UNPAID.ToString() &&
x.duedate < DateTime.Now)
.OrderBy(x => x.duedate)
.GroupBy(x => x.user);
var alerts = new List <LateFeeAlert>();
foreach (var entry in overdueStudents)
{
var rel = entry.Key.students_guardians.SingleOrDefault(x => x.type.HasValue && x.type.Value == (byte)GuardianType.FATHER);
if (rel == null)
{
rel =
entry.Key.students_guardians.SingleOrDefault(
x => x.type.HasValue && x.type.Value == (byte)GuardianType.MOTHER);
}
var parent = rel.user1;
var alert = new LateFeeAlert
{
parentid = parent.id,
parentname = parent.ToName(),
studentname = entry.Key.ToName(false),
studentid = entry.Key.id,
overdueFees = entry.Select(x => x).ToModel(auth.perms)
};
alerts.Add(alert);
}
// group by parent
var parentGroups = alerts.GroupBy(x => new { x.parentid, x.parentname });
foreach (var entry in parentGroups)
{
var siblings = new LateFeeAlertSiblings();
siblings.children = entry.Select(x => x);
viewmodel.alerts.Add(siblings);
}
// TODO: list most overdued groups first
// get templates
viewmodel.templates = db.fees_templates.OrderBy(x => x.title).ToRowModel();
return(View(viewmodel));
}
public FinancePage()
{
this.InitializeComponent();
vm = new FinanceViewModel();
this.OnRefreshed += new FinancePageDelegate(AddDelegate);
}
public FinanceWindow()
{
InitializeComponent();
vm = ContainerHelper.Container.Resolve <FinanceViewModel>();
DataContext = vm;
}
public MainWindow()
{
InitializeComponent();
_fvm = new FinanceViewModel();
DataContext = _fvm;
}
