public void addSelectedNoteToDataGridView(StockDataModel stocks, int quantity, DataGridView datagridview) { decimal amt = quantity * stocks.lastCostPrice; datagridview.Rows.Add((datagridview.RowCount + 1), stocks.name, FormatPrice.format(stocks.lastCostPrice), quantity, FormatPrice.format(amt), "Edit", "Delete"); }
public ActionResult StockDataSetup(StockDataModel model) { System.Random random = new System.Random(); StockData stockData = db.StockDatas.Where(a => a.StockDataId.Equals(model.StockDataId)).FirstOrDefault(); if (stockData == null) { StockData stockDataadd = new StockData(); stockDataadd.ItemName = model.ItemName; stockDataadd.Date = model.Date; stockDataadd.Quantity = model.Quantity; stockDataadd.Rate = model.Rate; stockDataadd.CreateDate = DateTime.Now; stockDataadd.IsActive = true; db.StockDatas.Add(stockDataadd); db.SaveChanges(); ModelState.Clear(); model = null; this.AddNotification("Thats great! Successfully Saved.", NotificationType.SUCCESS); } else { stockData.ItemName = model.ItemName; stockData.Date = model.Date; stockData.Quantity = model.Quantity; stockData.Rate = model.Rate; db.SaveChanges(); model = null; this.AddNotification("Thats great! Successfully Edited.", NotificationType.SUCCESS); } return(RedirectToAction("StockDataList")); }
public void addSelectedStockToDataGridView(StockDataModel stock, DataGridView datagridView) { int index = datagridView.RowCount + 1; datagridView.Rows.Add(index, stock.name, FormatPrice.format(stock.highestCostPrice), FormatPrice.format(stock.lowestCostPrice), FormatPrice.format(stock.lastCostPrice), FormatPrice.format(stock.unitPrice), "Remove"); }
async Task PullData() { LoadingIcon.IsRunning = true; string newSymbol = StockSearch.Text; stockData = await StockDataModel.GetSymbolData(newSymbol); if (stockData == null) { StockSearch.Text = oldSymbol; StockDataModel.lastSymbol = oldSymbol; await DisplayAlert("Stock Not Found", "No stock matching symbol:\n\"" + newSymbol + "\"", "Close"); } else { StocksListView.IsVisible = true; StocksListView.ItemsSource = stockData; HighestLabel.Text = StockDataModel.GetHighestString(); LowestLabel.Text = StockDataModel.GetLowestString(); oldSymbol = newSymbol; } LoadingIcon.IsRunning = false; }
public static StockData MapToStockData(this StockDataModel model) { return(new StockData() { Quantity = model.Quantity, ItemCode = model.ItemCode, }); }
public void addProductsToDataGridView(StockDataModel stock, int quantityToSupply, DataGridView datagridview) { decimal totalPrice = stock.lastCostPrice * quantityToSupply; datagridview.Rows.Add((datagridview.RowCount + 1).ToString(), stock.name, FormatPrice.format(stock.lastCostPrice), FormatPrice.format(stock.highestCostPrice), FormatPrice.format(stock.lowestCostPrice), quantityToSupply, FormatPrice.format(totalPrice), stock.quantity); }
public AddStock(StockDataModel stock) { InitializeComponent(); setDataToEdit(stock); saveButton.Enabled = false; editButton.Visible = true; deleteButton.Visible = true; this.stockToEdit = stock; }
public IQueryable <StockDataModel> GetStockData() { var stockData = new List <StockDataModel>(); this._ConnectionString = string.Format(this._ConnectionString, this.DataSource); using (var conn = new OleDbConnection(this._ConnectionString)) { this._SelectAllCommand = string.Format(@"SELECT * FROM [{0}]", this.FileName); using (var cmd = new OleDbCommand(this._SelectAllCommand, conn)) { try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } var dataAdapter = new OleDbDataAdapter(cmd); this._DataSet = new DataSet(); dataAdapter.Fill(this._DataSet); this._DataTable = this._DataSet.Tables[0]; StockDataModel stockDataModelDataEntry = null; for (int i = 0; i < this._DataTable.Rows.Count; ++i) { stockDataModelDataEntry = new StockDataModel(); stockDataModelDataEntry.Date = Convert.ToDateTime(_DataTable.Rows[i]["Date"]); stockDataModelDataEntry.Open = Convert.ToDecimal(_DataTable.Rows[i]["Open"]); stockDataModelDataEntry.High = Convert.ToDecimal(_DataTable.Rows[i]["High"]); stockDataModelDataEntry.Low = Convert.ToDecimal(_DataTable.Rows[i]["Low"]); stockDataModelDataEntry.Close = Convert.ToDecimal(_DataTable.Rows[i]["Close"]); stockDataModelDataEntry.Volume = Convert.ToInt32(_DataTable.Rows[i]["Volume"]); stockDataModelDataEntry.SwingPoint = _DataTable.Rows[i]["SwingPoint"].ToString(); stockData.Add(stockDataModelDataEntry); } } catch (Exception e) { Console.WriteLine("[Error] GetAll() failed.", this.DataSource); Console.WriteLine(e.Message); } finally { conn.Close(); } } } return(stockData.AsQueryable()); }
public ActionResult StockDataEditView(int StockDataId) { StockDataModel model = new StockDataModel(); StockData newFitCat = db.StockDatas.Where(a => a.StockDataId.Equals(StockDataId)).FirstOrDefault(); if (newFitCat != null) { model.StockDataId = newFitCat.StockDataId; model.ItemName = newFitCat.ItemName; model.Date = newFitCat.Date; model.Quantity = newFitCat.Quantity; model.Rate = newFitCat.Rate; } return(View("StockDataSetup", model)); }
private void setDataToEdit(StockDataModel stock) { nameTextBox.Text = stock.name; descTextBox.Text = stock.desc; skuTextBox.Text = stock.sku; unitTextBox.Text = stock.unit; highestCostPriceTextBox.Text = stock.highestCostPrice.ToString(); lowestCostPricetextBox.Text = stock.lowestCostPrice.ToString(); lastCostPricetextBox.Text = stock.lastCostPrice.ToString(); quantityTextBox.Text = stock.quantity.ToString(); sellingPriceTextBox.Text = stock.unitPrice.ToString(); if (!string.IsNullOrEmpty(stock.vendorId) && vendorsInfo != null && vendorsInfo.Any()) { foreach (var data in vendorsInfo) { if (data.id == stock.vendorId) { vendorComboBox.Text = data.name; break; } } } if (!string.IsNullOrEmpty(stock.storeId) && storesData != null && storesData.Any()) { foreach (var data in storesData) { if (data.id == stock.storeId) { storeComboBox.Text = data.name; break; } } } if (!string.IsNullOrEmpty(stock.categoryId) && categories != null && categories.Any()) { foreach (var data in categories) { if (data.id == stock.categoryId) { categoryComboBox.Text = data.name; break; } } } }
public IStockDataModel GetStockDataModel(ISecurityEndOfDayData securityEndOfDayData) { var stockDataModel = new StockDataModel(securityEndOfDayData.Symbol, securityEndOfDayData.TimeStamp, securityEndOfDayData.Open, securityEndOfDayData.High, securityEndOfDayData.Low, securityEndOfDayData.Close, securityEndOfDayData.Volume, securityEndOfDayData.AdjustedClose, securityEndOfDayData.DayChange, securityEndOfDayData.DayPercentageChange, securityEndOfDayData.StandardChange ?? 0, securityEndOfDayData.StandardPercentageChange ?? 0); return(stockDataModel); }
async Task PullData() { LoadingIcon.IsRunning = true; string newSymbol = StockSearch.Text; stockData = await StockDataModel.GetSymbolData(newSymbol); if (stockData == null) { StockSearch.Text = oldSymbol; StockDataModel.lastSymbol = oldSymbol; await DisplayAlert("Stock Not Found", "No stock matching symbol:\n\"" + newSymbol + "\"", "Close"); } else { Chart30Days.Chart = new LineChart() { Entries = StockDataModel.GetPastDayRange(30) }; Chart100Days.Chart = new LineChart() { Entries = StockDataModel.GetPastDayRange(100) }; Chart30Days.Chart.LabelTextSize = 30; Chart100Days.Chart.LabelTextSize = 30; Chart30Days.Chart.BackgroundColor = SKColors.Transparent; Chart100Days.Chart.BackgroundColor = SKColors.Transparent; Chart30Days.Chart.MaxValue = (float)StockDataModel.GetHighestNum(); Chart30Days.Chart.MinValue = (float)StockDataModel.GetLowestNum(); Chart100Days.Chart.MaxValue = (float)StockDataModel.GetHighestNum(); Chart100Days.Chart.MinValue = (float)StockDataModel.GetLowestNum(); HighestLabel.Text = StockDataModel.GetHighestString(); LowestLabel.Text = StockDataModel.GetLowestString(); ChartsAndLabels.IsVisible = true; oldSymbol = newSymbol; } LoadingIcon.IsRunning = false; }
public void CreateShareOwnership(string stockId, [FromBody] Guid userId, int sharesAmount) { var dbFactory = new OrmLiteConnectionFactory( ConnectionString, SqlServerDialect.Provider); using (var db = dbFactory.Open()) { db.CreateTableIfNotExists <ShareOwnerDataModel>(); db.CreateTableIfNotExists <StockDataModel>(); db.CreateTableIfNotExists <OwnerDataModel>(); var user = db.Single <OwnerDataModel>(x => x.ShareHolderId == userId); var stock = db.Single <StockDataModel>(x => x.StockId == stockId); if (user == null) { user = new OwnerDataModel() { ShareHolderId = userId }; db.Insert(user); } if (stock == null) { stock = new StockDataModel() { StockId = stockId, SharePrice = 5 }; db.Insert(stock); } db.Insert(new ShareOwnerDataModel() { Stock = stock, SharesAmount = sharesAmount, ShareOwner = user }); } }
public IStockDataModel GetStockData(IMySqlDataReaderWrapper dataReader) { string symbol = dataReader.GetField <string>("symbol"); DateTime dateStamp = dataReader.GetField <DateTime>("DateStamp"); decimal open = (decimal)dataReader.GetField <Single>("Open"); decimal high = (decimal)dataReader.GetField <Single>("High"); decimal low = (decimal)dataReader.GetField <Single>("Low"); decimal close = (decimal)dataReader.GetField <Single>("Close"); decimal adjustedClose = (decimal)dataReader.GetField <Single>("AdjustedClose"); long volume = dataReader.GetField <long>("Volume"); decimal dayChange = (decimal)dataReader.GetField <Single>("DayChange"); decimal dayPercentageChange = (decimal)dataReader.GetField <Single>("DayPercentageChange"); decimal standardChange = (decimal)dataReader.GetField <Single>("StandardChange"); decimal standardPercentageChange = (decimal)dataReader.GetField <Single>("StandardPercentageChange"); var stockData = new StockDataModel(symbol, dateStamp, open, high, low, close, volume, adjustedClose, dayChange, dayPercentageChange, standardChange, standardPercentageChange); return(stockData); }
public StockDataViewModel(StockDataModel model) { Model = model; WatchedSymbols = Model.WatchedSymbols; FilteredSymbols = new CollectionViewSource(); FilteredSymbols.Source = watchedSymbols; FilteredSymbols.Filter += OnFilteredSymbolsOnFilter; FetchSymbols = new RelayCommand(FetchSymbolsFromYahoo); ForceFetchSymbols = new RelayCommand(ForceFetchSymbolsFromYahoo); AddSymbolToWatched = new RelayCommand <string>(AddSymbol); fetchSymbolsWorker.DoWork += FetchSymbolsWorker_DoWork; fetchSymbolsWorker.RunWorkerCompleted += FetchSymbolsWorker_RunWorkerCompleted; IsNotBusy = true; }
public void addIssuedStockToDataGridView(StockDataModel stock, int quantity, DataGridView datagridview) { datagridview.Rows.Add((datagridview.RowCount + 1), stock.name, FormatPrice.format(stock.lastCostPrice), FormatPrice.format(stock.unitPrice), quantity); }
private void processData(bool isEdit) { string _name = nameTextBox.Text; string _desc = descTextBox.Text; string category = categoryComboBox.Text; string sku = skuTextBox.Text; string unit = unitTextBox.Text; string vendorId = "", categoryId = "", storeId = ""; int vIndex = vendorComboBox.SelectedIndex; int cIndex = categoryComboBox.SelectedIndex; int sIndex = storeComboBox.SelectedIndex; if (vIndex != -1) { if (vendorsInfo.Any() && vIndex <= vendorsInfo.Count()) { vendorId = vendorsInfo.ElementAt(vIndex).id; } } if (cIndex != -1) { if (categories.Any() && cIndex <= categories.Count()) { categoryId = categories.ElementAt(cIndex).id; } } if (sIndex != -1) { if (storesData.Any() && sIndex <= storesData.Count()) { storeId = storesData.ElementAt(sIndex).id; } } decimal highestCostPrice = 0, lowestCostPrice = 0, lastCostPrice = 0; decimal selling_price = 0; int quantity = 0; try { highestCostPrice = decimal.Parse(highestCostPriceTextBox.Text); lowestCostPrice = decimal.Parse(lowestCostPricetextBox.Text); lastCostPrice = decimal.Parse(lastCostPricetextBox.Text); selling_price = decimal.Parse(sellingPriceTextBox.Text); quantity = int.Parse(quantityTextBox.Text); }catch (Exception ex) { MessageBox.Show("Invalid Data"); return; } var stock = new StockDataModel { name = _name, desc = _desc, sku = sku, unit = unit, highestCostPrice = highestCostPrice, lowestCostPrice = lowestCostPrice, lastCostPrice = lastCostPrice, unitPrice = selling_price, quantity = quantity, vendorId = vendorId, categoryId = categoryId, storeId = storeId, storeLocation = storeComboBox.Text, date = DateTime.Now }; if (isEdit) { if (!MessagePrompt.displayPrompt("Edit", "edit this stock")) { return; } stock.id = stockToEdit.id; DatabaseOperations.updateStock(stock); MessageBox.Show("Stock Updated successfully"); } else { if (!MessagePrompt.displayPrompt("Create New", "create new stock")) { return; } DatabaseOperations.addStocks(stock); MessageBox.Show("Stocks added successfully"); nameTextBox.Clear(); descTextBox.Clear(); skuTextBox.Clear(); unitTextBox.Clear(); highestCostPriceTextBox.Clear(); lowestCostPricetextBox.Clear(); lastCostPricetextBox.Clear(); sellingPriceTextBox.Clear(); quantityTextBox.Clear(); nameTextBox.Focus(); } }
public void Add(StockDataModel model) { StockData entity = model.MapToStockData(); _stockRepository.Add(entity); }
public void addStocksToRecipeDataGridView(StockDataModel stock, int qty, DataGridView dataGridView) { dataGridView.Rows.Add((dataGridView.RowCount + 1).ToString(), stock.name, qty, stock.unitPrice, stock.lastCostPrice); }