public IActionResult Index(IndexViewModel vm)
{
var model = new IndexViewModel();
var analysis = new AnalysisBusinessObject();
var stockFitnessAnalysis = analysis.GetStockData(vm.WeightNumberRoic, vm.WeightNumberEquity, vm.WeightNumberEPS, vm.WeightNumberRevenue, vm.WeightNumberPERatio, vm.WeightNumberDebtToEquity, vm.WeightNumberAssetsToLiabilities);
foreach (var poco in stockFitnessAnalysis)
{
var homeData = new HomeDataPoco();
homeData.CompanyName = poco.CompanyDataPoco.Company.Name;
homeData.Ticker = poco.CompanyDataPoco.Company.Ticker;
homeData.MarketAnalyzerRank = poco.MarketAnalyzerRank;
if (poco.CompanyDataPoco.Company.StockPrice != 0)
{
homeData.StockPrice = poco.CompanyDataPoco.Company.StockPrice;
}
homeData.Fitness = poco.Fitness;
homeData.Ticker = poco.CompanyDataPoco.Company.Ticker;
model.HomeDataPocos.Add(homeData);
}
model.WeightNumberRoic = Convert.ToDouble(vm.WeightNumberRoic, CultureInfo.InvariantCulture);
model.WeightNumberEquity = Convert.ToDouble(vm.WeightNumberEquity, CultureInfo.InvariantCulture);
model.WeightNumberEPS = Convert.ToDouble(vm.WeightNumberEPS, CultureInfo.InvariantCulture);
model.WeightNumberRevenue = Convert.ToDouble(vm.WeightNumberRevenue, CultureInfo.InvariantCulture);
model.WeightNumberPERatio = Convert.ToDouble(vm.WeightNumberPERatio, CultureInfo.InvariantCulture);
model.WeightNumberDebtToEquity = Convert.ToDouble(vm.WeightNumberDebtToEquity, CultureInfo.InvariantCulture);
model.WeightNumberAssetsToLiabilities = Convert.ToDouble(vm.WeightNumberAssetsToLiabilities, CultureInfo.InvariantCulture);
return(View(model));
}
public IActionResult Index()
{
var model = new IndexViewModel();
var analysis = new AnalysisBusinessObject();
var stockFitnessAnalysis = analysis.GetStockData();
foreach (var poco in stockFitnessAnalysis)
{
var homeData = new HomeDataPoco();
homeData.CompanyName = poco.CompanyDataPoco.Company.Name;
homeData.Ticker = poco.CompanyDataPoco.Company.Ticker;
homeData.MarketAnalyzerRank = poco.MarketAnalyzerRank;
if (poco.CompanyDataPoco.Company.StockPrice != 0)
{
homeData.StockPrice = poco.CompanyDataPoco.Company.StockPrice;
}
homeData.Fitness = poco.Fitness;
homeData.Ticker = poco.CompanyDataPoco.Company.Ticker;
model.HomeDataPocos.Add(homeData);
}
model.HomeDataPocos.OrderByDescending(l => l.MarketAnalyzerRank);
return(View(model));
}
public UserRecordsController()
{
this.userTransaction = new UserTransaction();
this._noteBO = new NoteBusinessObject();
this._weightMultiplierBO = new WeightMultiplierBusinessObject();
this.model = new UserTransactionViewModel();
this.analysis = new AnalysisBusinessObject();
}
private DataTable GetCollectionDetails()
{
DataTable dtColl = new DataTable();
try
{
IAnalysis objCashdesk = AnalysisBusinessObject.CreateInstance();
dtColl = objCashdesk.GetWeeklyCollectionDetails(_iWeekID);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtColl);
}
public IActionResult Index()
{
var model = new IndexViewModel();
var analysis = new AnalysisBusinessObject();
var stockFitnessAnalysis = new List <StockItemPoco>();
var user = User.Identity.GetUserId();
var weight = analysis.GetWeightMultipliers(user);
if (weight != null)
{
model.WeightNumberRoic = weight.WeightNumberRoic;
model.WeightNumberEquity = weight.WeightNumberEquity;
model.WeightNumberEPS = weight.WeightNumberEPS;
model.WeightNumberRevenue = weight.WeightNumberRevenue;
model.WeightNumberPERatio = weight.WeightNumberPERatio;
model.WeightNumberAssetsToLiabilities = weight.WeightNumberAssetsToLiabilities;
model.WeightNumberDebtToEquity = weight.WeightNumberDebtToEquity;
stockFitnessAnalysis = analysis.GetStockData(model.WeightNumberRoic, model.WeightNumberEquity, model.WeightNumberEPS, model.WeightNumberRevenue, model.WeightNumberPERatio, model.WeightNumberDebtToEquity, model.WeightNumberAssetsToLiabilities);
}
else
{
stockFitnessAnalysis = analysis.GetStockData();
}
foreach (var poco in stockFitnessAnalysis)
{
var homeData = new HomeDataPoco();
homeData.CompanyName = poco.CompanyDataPoco.Company.Name;
homeData.Ticker = poco.CompanyDataPoco.Company.Ticker;
homeData.MarketAnalyzerRank = poco.MarketAnalyzerRank;
if (poco.CompanyDataPoco.Company.StockPrice != 0)
{
homeData.StockPrice = poco.CompanyDataPoco.Company.StockPrice;
}
homeData.Fitness = poco.Fitness;
homeData.Ticker = poco.CompanyDataPoco.Company.Ticker;
model.HomeDataPocos.Add(homeData);
}
model.HomeDataPocos.OrderByDescending(l => l.MarketAnalyzerRank);
return(View(model));
}
public IActionResult UserTransactions()
{
var model = new UserTransactionViewModel();
model.AspNetUserId = User.Identity.GetUserId();
var portfolioBusiness = new PortfolioBusinessObject();
var result = portfolioBusiness.GetUserPortfolio(User.Identity.GetUserId());
model.CompaniesTransactions = result.CompaniesTransactions;
model.TotalTransactions = result.TotalTransactions;
var weightModel = _weightMultiplierBO.List().Result.Where(w => w.AspNetUserId == model.AspNetUserId).FirstOrDefault();
if (weightModel != null)
{
model.WeightNumberAssetsToLiabilities = weightModel.WeightNumberAssetsToLiabilities;
model.WeightNumberDebtToEquity = weightModel.WeightNumberDebtToEquity;
model.WeightNumberEPS = weightModel.WeightNumberEPS;
model.WeightNumberEquity = weightModel.WeightNumberEquity;
model.WeightNumberPERatio = weightModel.WeightNumberPERatio;
model.WeightNumberRevenue = weightModel.WeightNumberRevenue;
model.WeightNumberRoic = weightModel.WeightNumberRoic;
}
var analysis = new AnalysisBusinessObject();
var stockItemPocos = analysis.GetStockData();
var companyList = new List <Company>();
foreach (var item in stockItemPocos)
{
var company = item.CompanyDataPoco.Company;
companyList.Add(company);
}
model.Companies = companyList;
ViewBag.CompanyNames = model.Companies.Select(company => new SelectListItem()
{
Text = company.Name, Value = company.Id.ToString()
});
return(View(model));
}
public void Refresh(int iType, DateTime dteStartDate, DateTime DteEndDate)
{
_iType = iType;
lblStatus.Visibility = Visibility.Hidden;
progressBar1.Visibility = Visibility.Hidden;
lstAnalysisDetails.Visibility = Visibility.Visible;
lstCollectionDetails.Visibility = Visibility.Hidden;
IAnalysis objCashdesk = AnalysisBusinessObject.CreateInstance();
DataTable dtAnalysisDetails = objCashdesk.GetAnalysisDetails(iType, dteStartDate, DteEndDate, BMC.Business.CashDeskOperator.AnalysisView.Position, 0);
dtPrintDetails = null;
dtPrintDetails = dtAnalysisDetails.Copy();
if (dtPrintDetails.Rows.Count > 0)
{
TotalAvgBet = Convert.ToDecimal(dtPrintDetails.Rows[0]["AvgBet"]);
dtPrintDetails.Rows[0].Delete();
dtPrintDetails.AcceptChanges();
}
lstAnalysisDetails.DataContext = dtAnalysisDetails.DefaultView;
txtHeader.Visibility = Visibility.Visible;
txtHeader1.Visibility = Visibility.Hidden;
btnPrint.Visibility = Visibility.Visible;
btnExport.Visibility = Visibility.Visible;
if (!Settings.IsAFTEnabledForSite)
{
this.gvAnalysisDetails.Columns.Remove(gvColCashableEFTIn);
this.gvAnalysisDetails.Columns.Remove(gvColCashableEFTOut);
this.gvAnalysisDetails.Columns.Remove(gvColNonCashableEFTIn);
this.gvAnalysisDetails.Columns.Remove(gvColNonCashableEFTOut);
this.gvAnalysisDetails.Columns.Remove(gvColWATIn);
this.gvAnalysisDetails.Columns.Remove(gvColWATOut);
dtPrintDetails.Columns.Add("CashableEFTIn", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("CashableEFTOut", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("NonCashableEFTIn", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("NonCashableEFTOut", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("WATIn", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("WATOut", typeof(decimal), "0.00");
}
}
public void Refresh(int iType, AnalysisView viewType, int zoneId, DateTime dteStartDate, DateTime DteEndDate)
{
try
{
_iType = iType;
//lblStatus.Visibility = Visibility.Hidden;
//progressBar1.Visibility = Visibility.Hidden;
lstAnalysisDetails.Visibility = Visibility.Visible;
lstCollectionDetails.Visibility = Visibility.Hidden;
//GridViewColumn_NoOfMC.Width = (viewType == AnalysisView.Zone) ? 78 : 0;
string reportType = string.Empty;
switch (iType.ToString())
{
case "1":
reportType = "DAY";
break;
case "2":
reportType = "DROP";
break;
case "3":
reportType = "WEEK";
break;
case "4":
reportType = "MONTH";
break;
}
LogManager.WriteLog("UCAnalysisDetails:Refresh ZoneID:" + zoneId + " ReportType:" + reportType, LogManager.enumLogLevel.Info);
Action doAnalysis = () =>
{
IAnalysis objCashdesk = AnalysisBusinessObject.CreateInstance();
dtAnalysisDetails = objCashdesk.GetAnalysisDetails(iType, dteStartDate, DteEndDate, viewType, zoneId);
};
if (iType == 2)
{
//Getting Installation No for grabbing current meters
IList <int> inst = (new CommonDataAccess()).GetInstallationDetailsForReports(reportType)
.AsEnumerable()
.Where(r => (zoneId == -1 ? true : (r["Zone_No"] != DBNull.Value ? (r.Field <int>("Zone_No") == zoneId) : false)))
.Select(row => row.Field <int>("Installation_No"))
.ToList <int>();
//Grabbing current meters from VLT
LoadingWindow ld_analysis = new LoadingWindow(this, Audit.Transport.ModuleName.AnalysisDetails, inst, doAnalysis);
ld_analysis.ShowDialog();
}
else
{
LoadingWindow ld_analysis = new LoadingWindow(this, Audit.Transport.ModuleName.AnalysisDetails, doAnalysis, true);
ld_analysis.ShowDialog();
}
dtPrintDetails = null;
dtPrintDetails = dtAnalysisDetails.Copy();
if (dtPrintDetails.Rows.Count > 0)
{
TotalAvgBet = Convert.ToDecimal(dtPrintDetails.Rows[0]["AvgBet"]);
dtPrintDetails.Rows[0].Delete();
dtPrintDetails.AcceptChanges();
}
lstAnalysisDetails.DataContext = dtAnalysisDetails.DefaultView;
foreach (Microsoft.Windows.Controls.DataGridColumn gvCol in lstAnalysisDetails.Columns)
{
ResizeGridViewColumn(gvCol);
lstAnalysisDetails.Columns[0].Width = 0;
}
//txtHeader.Visibility = Visibility.Visible;
//txtHeader1.Visibility = Visibility.Hidden;
btnPrint.Visibility = Visibility.Visible;
btnExport.Visibility = Visibility.Visible;
if (!Settings.IsAFTEnabledForSite)
{
this.lstAnalysisDetails.Columns.Remove(gvColCashableEFTIn);
this.lstAnalysisDetails.Columns.Remove(gvColCashableEFTOut);
this.lstAnalysisDetails.Columns.Remove(gvColNonCashableEFTIn);
this.lstAnalysisDetails.Columns.Remove(gvColNonCashableEFTOut);
this.lstAnalysisDetails.Columns.Remove(gvColWATIn);
this.lstAnalysisDetails.Columns.Remove(gvColWATOut);
dtPrintDetails.Columns.Add("CashableEFTIn", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("CashableEFTOut", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("NonCashableEFTIn", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("NonCashableEFTOut", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("WATIn", typeof(decimal), "0.00");
dtPrintDetails.Columns.Add("WATOut", typeof(decimal), "0.00");
}
GetRefreshedData();
}
catch (Exception ex)
{
MessageBox.ShowBox(ex.Message, true);
ExceptionManager.Publish(ex);
}
}
public CompanyDetailsController()
{
this.dataPoco = new CompanyDataPoco();
this.analysis = new AnalysisBusinessObject();
}
public IActionResult UserTransactions(UserTransactionViewModel vm)
{
var model = new UserTransactionViewModel();
var userTransaction = new UserTransaction();
userTransaction.AspNetUserId = User.Identity.GetUserId();
model.AspNetUserId = User.Identity.GetUserId();
if (vm.ValueOfShares != null)
{
model.CompanyId = vm.CompanyId;
model.DateOfMovement = vm.DateOfMovement;
userTransaction.CompanyId = vm.CompanyId;
userTransaction.DateOfMovement = vm.DateOfMovement;
if (vm.IsAPurchaseOrSale == 0)
{
model.NumberOfShares = vm.NumberOfShares;
model.ValueOfShares = vm.ValueOfShares;
userTransaction.NumberOfShares = vm.NumberOfShares;
userTransaction.ValueOfShares = vm.ValueOfShares;
userTransaction.NumberOfSharesWithdrawn = 0;
userTransaction.ValueOfSharesWithdrawn = 0;
}
else
{
model.NumberOfSharesWithdrawn = vm.NumberOfShares;
model.ValueOfSharesWithdrawn = vm.ValueOfShares;
userTransaction.NumberOfShares = 0;
userTransaction.ValueOfShares = 0;
userTransaction.NumberOfSharesWithdrawn = vm.NumberOfShares;
userTransaction.ValueOfSharesWithdrawn = vm.ValueOfShares;
}
var portfolioBusiness = new PortfolioBusinessObject();
var result = portfolioBusiness.GetUserPortfolio(User.Identity.GetUserId());
model.CompaniesTransactions = result.CompaniesTransactions;
model.TotalTransactions = result.TotalTransactions;
var analysis = new AnalysisBusinessObject();
var stockItemPocos = analysis.GetStockData();
var companyList = new List <Company>();
foreach (var item in stockItemPocos)
{
var company = item.CompanyDataPoco.Company;
companyList.Add(company);
}
model.Companies = companyList;
ViewBag.CompanyNames = model.Companies.Select(company => new SelectListItem()
{
Text = company.Name, Value = company.Id.ToString()
});
var createOperation = _userTransactionBO.Create(userTransaction);
Response.Redirect("UserTransactions");
}
//Caso seja introduzida uma transação e o utilizador não se lembrar do value da compra
if (vm.ValueOfShares == null && vm.NumberOfShares != null)
{
var stockValues = _stockValuesBO.GetStockValuesPerYear(vm.CompanyId);
var valueInYear = stockValues.Components.Where(x => x.Year == vm.DateOfMovement.Year);
var marketCap = valueInYear.Select(x => x.MarketCap).SingleOrDefault();
var sharesBasic = valueInYear.Select(x => x.SharesBasic).SingleOrDefault();
var stockValue = marketCap / sharesBasic;
model.CompanyId = vm.CompanyId;
model.DateOfMovement = vm.DateOfMovement;
userTransaction.CompanyId = vm.CompanyId;
userTransaction.DateOfMovement = vm.DateOfMovement;
if (vm.IsAPurchaseOrSale == 0)
{
model.NumberOfShares = vm.NumberOfShares;
model.ValueOfShares = stockValue;
userTransaction.NumberOfShares = vm.NumberOfShares;
userTransaction.ValueOfShares = stockValue;
userTransaction.NumberOfSharesWithdrawn = 0;
userTransaction.ValueOfSharesWithdrawn = 0;
}
else
{
model.NumberOfSharesWithdrawn = vm.NumberOfShares;
model.ValueOfSharesWithdrawn = stockValue;
userTransaction.NumberOfShares = 0;
userTransaction.ValueOfShares = 0;
userTransaction.NumberOfSharesWithdrawn = vm.NumberOfShares;
userTransaction.ValueOfSharesWithdrawn = stockValue;
}
var portfolioBusiness = new PortfolioBusinessObject();
var result = portfolioBusiness.GetUserPortfolio(User.Identity.GetUserId());
model.CompaniesTransactions = result.CompaniesTransactions;
model.TotalTransactions = result.TotalTransactions;
var analysis = new AnalysisBusinessObject();
var stockItemPocos = analysis.GetStockData();
var companyList = new List <Company>();
foreach (var item in stockItemPocos)
{
var company = item.CompanyDataPoco.Company;
companyList.Add(company);
}
model.Companies = companyList;
ViewBag.CompanyNames = model.Companies.Select(company => new SelectListItem()
{
Text = company.Name, Value = company.Id.ToString()
});
var createOperation = _userTransactionBO.Create(userTransaction);
Response.Redirect("UserTransactions");
}
return(View(model));
}
private DataTable GetCollectionDetails()
{
IAnalysis objCashdesk = AnalysisBusinessObject.CreateInstance();
return(objCashdesk.GetWeeklyCollectionDetails(_iWeekID));
}
