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);
}
