internal int Delete(stockremain formdata)
{
stockremain result = db.stockremain.Where(m => m.證券代號 == formdata.證券代號 && m.account == formdata.account).FirstOrDefault();
db.stockremain.Remove(result);
return(db.SaveChanges());
}
internal int Updatestockremain(stockremain formdata, int Number)
{
var stockremain = db.stockremain.Where(s => s.證券代號 == formdata.證券代號 && s.account == formdata.account).FirstOrDefault();
stockremain.張數 = (int.Parse(stockremain.張數) - Number).ToString();
stockremain.持有成本 = ((int.Parse(stockremain.張數) * double.Parse(stockremain.成交均價)) * number).ToString();
stockremain.現值 = (double.Parse(formdata.現價) * double.Parse(stockremain.張數.ToString()) * number).ToString();
stockremain.預估收入 = ((int.Parse(stockremain.張數) * double.Parse(stockremain.現價)) * number).ToString();
stockremain.預估損益 = (double.Parse(stockremain.預估收入) - double.Parse(stockremain.持有成本)).ToString();
stockremain.預估獲利率 = ((double.Parse(stockremain.預估損益) / double.Parse(stockremain.持有成本)) * 100).ToString("f2") + "%";
db.SaveChanges();
return(db.SaveChanges());
}