public ActionResult CreateStockBuy([Bind(Include = "TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockFee,stockTax,stockTP,stockNetincome,stockNote,CashAccount")] StockHistory stockHistory, UsersData userdata) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { //存入總表獲得交易序號 db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); bool cashflag = false; if (stockHistory.CashAccount) { CashExpense expense = new CashExpense(); expense.OID = id; expense.UserName = summaryTable.UserName; expense.ExCashType = summaryTable.TradeType; expense.ExAmount = (stockHistory.stockNetincome) * (-1); expense.ExDate = summaryTable.TradeDate; expense.ExNote = "買進股票"; cashflag = true; db.CashExpense.Add(expense); db.SaveChanges(); } //存入股票交易紀錄表 stockHistory.STId = id; stockHistory.stockAmount = stockHistory.stockAmount * 1000; AVGCalculator calculator = new AVGCalculator(); string _username = Session["User"].ToString(); string _searchid = stockHistory.stockID.ToString(); int _invchange = (int)stockHistory.stockAmount; int _cashflow = (int)stockHistory.stockNetincome; stockHistory.stockLastAVG = calculator.GetAvg(_username, _searchid, _invchange, _cashflow); db.StockHistory.Add(stockHistory); db.SaveChanges(); //計算股票現值 var name = summaryTable.UserName; decimal pvsum = calculator.getPVsum(name); var ud = calculator.GetUserdata(name); userdata.StockValue = (double)pvsum; userdata.UserName = ud[0].UserName; userdata.CashValue = (cashflag)? (ud[0].CashValue + Math.Abs((double)stockHistory.stockNetincome)): ud[0].CashValue; userdata.Password = ud[0].Password; userdata.Email = ud[0].Email; userdata.FXValue = ud[0].FXValue; userdata.InsuranceValue = ud[0].InsuranceValue; userdata.FundValue = ud[0].FundValue; db.Entry(userdata).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult CreateStockBuy([Bind(Include = "TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockFee,stockTax,stockNetincome,stockNote,CashAccount")] StockHistory stockHistory) { if (ModelState.IsValid) { //存入總表獲得交易序號 db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); if (stockHistory.CashAccount) { CashExpense expense = new CashExpense(); expense.OID = id; expense.UserName = summaryTable.UserName; expense.ExCashType = summaryTable.TradeType; expense.ExAmount = (stockHistory.stockNetincome) * (-1); expense.ExDate = summaryTable.TradeDate; expense.ExNote = "買進股票"; db.CashExpense.Add(expense); db.SaveChanges(); } //存入股票交易紀錄表 stockHistory.STId = id; stockHistory.stockAmount = stockHistory.stockAmount * 1000; db.StockHistory.Add(stockHistory); db.SaveChanges(); ViewBag.Alert = "alert('新增成功')"; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
//Delete public ActionResult DeleteExpense(int?id) { CashExpense obj = db.CashExpense.Find(id); db.CashExpense.Remove(obj); db.SaveChanges(); return(RedirectToAction("Index")); }
//Edit Income public ActionResult EditExpense([Bind(Include = "ExCashID,UserID,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (ModelState.IsValid) { db.Entry(cashExpense).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashExpense)); }
//Delete Expense public ActionResult DeleteExpense(int?id) { CashExpense obj = db.CashExpense.Find(id); var username = db.SummaryTable.Where(c => c.STId == obj.OID).Select(c => c).SingleOrDefault(); db.SummaryTable.Remove(username); db.CashExpense.Remove(obj); db.SaveChanges(); return(RedirectToAction("Index")); }
//Insert Income public ActionResult InsertExpense([Bind(Include = "ExCashID,UserID,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (ModelState.IsValid) { db.CashExpense.Add(cashExpense); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashExpense)); }
//Edit Expense public ActionResult EditExpense([Bind(Include = "ExCashID,UserID,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { db.Entry(cashExpense).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashExpense)); }
public ActionResult CreateStockBuy([Bind(Include = "TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockFee,stockTax,stockNetincome,stockNote,CashAccount")] StockHistory stockHistory) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { //存入總表獲得交易序號 db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); if (stockHistory.CashAccount) { CashExpense expense = new CashExpense(); expense.OID = id; expense.UserName = summaryTable.UserName; expense.ExCashType = summaryTable.TradeType; expense.ExAmount = (stockHistory.stockNetincome) * (-1); expense.ExDate = summaryTable.TradeDate; expense.ExNote = "買進股票"; db.CashExpense.Add(expense); db.SaveChanges(); } //存入股票交易紀錄表 stockHistory.STId = id; stockHistory.stockAmount = stockHistory.stockAmount * 1000; AVGCalculator calculator = new AVGCalculator(); string _username = Session["User"].ToString(); string _searchid = stockHistory.stockID.ToString(); int _invchange = (int)stockHistory.stockAmount; int _cashflow = (int)stockHistory.stockNetincome; stockHistory.stockLastAVG = calculator.GetAvg(_username, _searchid, _invchange, _cashflow); db.StockHistory.Add(stockHistory); db.SaveChanges(); ViewBag.Alert = "alert('新增成功')"; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "SerialNumber,UserID,InsuranceName,PurchaseDate,WithdrawDate,PaymentPerYear,PayYear,PurchaseOrWithdraw,CashFlow,Withdrawal,RelateCash")] Insurances insurances) { if (insurances.RelateCash == true) { insurances.CashFlow = -insurances.PaymentPerYear * insurances.PayYear; } else { insurances.CashFlow = 0; } insurances.PurchaseOrWithdraw = true; insurances.Withdrawed = false; //insurances.UserID = Session["User"].ToString(); if (ModelState.IsValid) { insurances.UserID = Session["User"].ToString(); SummaryTable ST = new SummaryTable { TradeType = "保險", TradeDate = insurances.PurchaseDate, UserName = insurances.UserID }; db.SummaryTable.Add(ST); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); insurances.STID = id; db.Insurances.Add(insurances); db.SaveChanges(); CashExpense CE = new CashExpense(); CE.ExAmount = -insurances.CashFlow; CE.UserName = insurances.UserID; CE.ExDate = ST.TradeDate; CE.ExCashType = ST.TradeType; CE.OID = id; db.CashExpense.Add(CE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(insurances)); }
//Delete Expense public ActionResult DeleteExpense(int?id) { CashExpense obj = db.CashExpense.Find(id); var stData = db.SummaryTable.Where(c => c.STId == obj.OID).Select(c => c).SingleOrDefault(); //刪除總表資料 db.SummaryTable.Remove(stData); //刪除收入表資料 db.CashExpense.Remove(obj); //更新userdata的cashvalue var username = Convert.ToString(Session["User"]); var Esum = db.CashExpense.Sum(c => c.ExAmount).HasValue? db.CashExpense.Sum(c => c.ExAmount):0; var Isum = db.CashIncome.Sum(c => c.InAmount).HasValue ? db.CashIncome.Sum(c => c.InAmount):0; var net = Isum - Esum; var userdata = db.UsersData.Where(c => c.UserName == username).Select(c => c).SingleOrDefault(); userdata.CashValue = (double)net; db.Entry(userdata).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
//Edit Expense public ActionResult EditExpense([Bind(Include = "ExCashID,UserName,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } var username = Convert.ToString(Session["User"]); if (ModelState.IsValid) { //更新支出表資料 db.Entry(cashExpense).State = EntityState.Modified; //更新userdata的cashvalue var Esum = (db.CashExpense.Sum(c => c.ExAmount) + Convert.ToInt32(cashExpense.ExAmount)).HasValue ? db.CashExpense.Sum(c => c.ExAmount) + Convert.ToInt32(cashExpense.ExAmount) : 0; var Isum = db.CashIncome.Sum(c => c.InAmount).HasValue ? db.CashIncome.Sum(c => c.InAmount) : 0; var net = Isum - Esum; var userdata = db.UsersData.Where(c => c.UserName == username).Select(c => c).SingleOrDefault(); userdata.CashValue = (double)net; db.Entry(userdata).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashExpense)); }
public ActionResult Create([Bind(Include = "SerialNumber,UserID,InsuranceName,PurchaseDate,WithdrawDate,PaymentPerYear,PayYear,PurchaseOrWithdraw,CashFlow,Withdrawal,RelateCash")] Insurances insurances) { if (ModelState.IsValid) { insurances.UserID = Session["User"].ToString(); insurances.PurchaseOrWithdraw = true; insurances.Withdrawed = false; SummaryTable ST = new SummaryTable { TradeType = "保險", TradeDate = insurances.PurchaseDate, UserName = insurances.UserID }; string UID = Session["User"].ToString(); var ExSUM = db.CashExpense.Where(C => C.UserName == UID).Sum(C => C.ExAmount); var InSUM = db.CashIncome.Where(C => C.UserName == UID).Sum(C => C.InAmount); if (insurances.RelateCash == true && InSUM - ExSUM > insurances.PaymentPerYear * insurances.PayYear) { db.SummaryTable.Add(ST); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); insurances.STID = id; insurances.CashFlow = -insurances.PaymentPerYear * insurances.PayYear; db.Insurances.Add(insurances); db.SaveChanges(); CashExpense CE = new CashExpense { ExAmount = -insurances.CashFlow, UserName = insurances.UserID, ExDate = ST.TradeDate, ExCashType = ST.TradeType, OID = id, ExNote = insurances.InsuranceName + "支出" }; db.CashExpense.Add(CE); var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault(); User.InsuranceValue += insurances.Withdrawal; User.CashValue -= insurances.PaymentPerYear * insurances.PayYear; db.SaveChanges(); } else { db.SummaryTable.Add(ST); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); insurances.STID = id; insurances.CashFlow = 0; db.Insurances.Add(insurances); db.SaveChanges(); var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault(); User.InsuranceValue += insurances.Withdrawal; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(insurances)); }
public ActionResult Create([Bind(Include = "FundName,Fee,Units,Date,NAV")] Fund fund) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { fund.BuyOrSell = true; fund.UserID = Session["User"].ToString(); SummaryTable ST = new SummaryTable { UserName = Session["User"].ToString(), TradeDate = fund.Date, TradeType = "基金" }; string UID = Session["User"].ToString(); var ExSUM = db.CashExpense.Where(C => C.UserName == UID).Sum(C => C.ExAmount); var InSUM = db.CashIncome.Where(C => C.UserName == UID).Sum(C => C.InAmount); if (fund.RelateCash == true && InSUM - ExSUM > (fund.NAV * fund.Units) * (1 + fund.Fee / 100)) { db.SummaryTable.Add(ST); db.SaveChanges(); fund.STID = db.SummaryTable.Select(s => s.STId).ToList().LastOrDefault(); fund.CashFlow = -(fund.NAV * fund.Units) * (1 + fund.Fee / 100); db.Fund.Add(fund); db.SaveChanges(); CashExpense CE = new CashExpense { UserName = fund.UserID, OID = fund.STID, ExCashType = "基金", ExDate = fund.Date, ExAmount = Convert.ToInt32(fund.CashFlow), ExNote = "基金申購" }; db.CashExpense.Add(CE); db.SaveChanges(); string value = db.fund_data.Where(D => D.FundName == fund.FundName).Select(D => D.FundNAV).SingleOrDefault(); var User = db.UsersData.Where(U => U.UserName == fund.UserID).Select(U => U).SingleOrDefault(); User.FundValue += fund.Units * double.Parse(value); User.CashValue -= fund.Units * fund.NAV; db.SaveChanges(); } else { db.SummaryTable.Add(ST); db.SaveChanges(); fund.STID = db.SummaryTable.Select(s => s.STId).ToList().LastOrDefault(); fund.CashFlow = 0; db.Fund.Add(fund); db.SaveChanges(); string value = db.fund_data.Where(D => D.FundName == fund.FundName).Select(D => D.FundNAV).SingleOrDefault(); var User = db.UsersData.Where(U => U.UserName == fund.UserID).Select(U => U).SingleOrDefault(); User.FundValue += fund.Units * double.Parse(value); db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(fund)); }
//Delete資料 public ActionResult DeleteStock(int?id) { StockHistory obj = db.StockHistory.Find(id); CashExpense objCashExp = db.CashExpense.Find(id); CashIncome objCashIn = db.CashIncome.Find(id); var stData = db.SummaryTable.Where(c => c.STId == obj.STId).Select(c => c).SingleOrDefault(); var netincome = obj.stockNetincome; //負值=買進紀錄、正值=賣出紀錄 double cashchange = 0; if (netincome > 0) { //cashchange = (double)netincome; ////刪除總表資料 db.SummaryTable.Remove(stData); //刪除股票表資料 db.StockHistory.Remove(obj); //刪除現金表資料 db.CashIncome.Remove(objCashIn); } else if (netincome < 0) //買進紀錄 { bool flagcash = obj.CashAccount; if (flagcash) //現金支出要回沖 { cashchange = (double)netincome; //////刪除總表資料 //db.SummaryTable.Remove(stData); //刪除股票表資料 db.StockHistory.Remove(obj); //刪除現金支出資料 db.CashExpense.Remove(objCashExp); } else { cashchange = 0; ////刪除總表資料 //db.SummaryTable.Remove(stData); //刪除股票表資料 db.StockHistory.Remove(obj); } } else //netincom=0 { cashchange = 0; ////刪除總表資料 //db.SummaryTable.Remove(stData); //刪除股票表資料 db.StockHistory.Remove(obj); } db.SaveChanges(); //計算與登錄股票現值 AVGCalculator calculator = new AVGCalculator(); var name = Convert.ToString(Session["User"]); decimal pvsum = calculator.getPVsum(name); var ud = calculator.GetUserdata(name); UsersData userdata = new UsersData(); userdata.StockValue = (double)pvsum; userdata.UserName = ud[0].UserName; userdata.CashValue = ud[0].CashValue + (cashchange * (-1)); userdata.Password = ud[0].Password; userdata.Email = ud[0].Email; userdata.FXValue = ud[0].FXValue; userdata.InsuranceValue = ud[0].InsuranceValue; userdata.FundValue = ud[0].FundValue; db.Entry(userdata).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
//Insert Expense public ActionResult InsertExpense([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "ExCashID,UserName,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { var username = Convert.ToString(Session["User"]); var Esum = (db.CashExpense.Sum(c => c.ExAmount) + Convert.ToInt32(cashExpense.ExAmount)).HasValue? db.CashExpense.Sum(c => c.ExAmount) + Convert.ToInt32(cashExpense.ExAmount):0; var Isum = db.CashIncome.Sum(c => c.InAmount).HasValue? db.CashIncome.Sum(c => c.InAmount):0; var net = Isum - Esum; //如果淨資產小於零,不給新增支出項目 if (net - cashExpense.ExAmount < 0) { return(Json(net - cashExpense.ExAmount, JsonRequestBehavior.AllowGet)); } else { //更新userdata的cashvalue var userdata = db.UsersData.Where(c => c.UserName == username).Select(c => c).SingleOrDefault(); userdata.CashValue = (double)net; db.Entry(userdata).State = EntityState.Modified; //新增總表資料 summaryTable.TradeType = cashExpense.ExCashType; summaryTable.TradeDate = cashExpense.ExDate; summaryTable.UserName = cashExpense.UserName; db.SummaryTable.Add(summaryTable); //新增支出表資料 cashExpense.OID = summaryTable.STId; db.CashExpense.Add(cashExpense); try { db.SaveChanges(); } catch (Exception er) { throw er; } return(RedirectToAction("Index")); } } return(View(cashExpense)); }
public void Delete(int id) { FXtradeTable tt = dc.FXtradeTable.Find(id); if (tt == null) { return; } var name = Session["User"].ToString(); CashIncome cashincome = new CashIncome(); if (tt.TradeClass == "賣出") { CashExpense cashexpense = new CashExpense(); cashexpense.UserName = Session["User"].ToString(); var summary = dc.SummaryTable.Where(c => c.UserName == name).ToList(); cashexpense.OID = summary[0].STId; cashexpense.ExCashType = summary[0].TradeType; cashexpense.ExDate = summary[0].TradeDate; cashexpense.ExNote = "資料表刪除"; cashexpense.ExAmount = Convert.ToInt32(Math.Abs(tt.NTD.Value)); dc.CashExpense.Add(cashexpense); dc.FXtradeTable.Remove(tt); dc.SaveChanges(); UsersData usersData = new UsersData(); TestHomeController th = new TestHomeController(); var ud = th.GetUsersData(name); usersData.FXValue = th.SaveUserdata(name); usersData.UserName = ud[0].UserName; var cv = Math.Abs(tt.NTD.Value); usersData.CashValue = ud[0].CashValue - cv; usersData.InsuranceValue = ud[0].InsuranceValue; usersData.StockValue = ud[0].StockValue; usersData.FundValue = ud[0].FundValue; usersData.Email = ud[0].Email; usersData.Password = ud[0].Password; dc.Entry(usersData).State = EntityState.Modified; dc.SaveChanges(); } else { var summary = dc.SummaryTable.Where(c => c.UserName == name).ToList(); cashincome.UserName = name; cashincome.OID = summary[0].STId; cashincome.InCashType = summary[0].TradeType; cashincome.InDate = summary[0].TradeDate; cashincome.InNote = "資料表刪除"; var cv = Math.Abs(tt.NTD.Value); if (tt.TradeClass == "買入(不要連動新臺幣帳戶)") { cashincome.InAmount = 0; } else { cashincome.InAmount = Convert.ToInt32(cv); } dc.CashIncome.Add(cashincome); dc.FXtradeTable.Remove(tt); dc.SaveChanges(); UsersData usersData = new UsersData(); TestHomeController th = new TestHomeController(); var ud = th.GetUsersData(name); usersData.FXValue = th.SaveUserdata(name); usersData.UserName = ud[0].UserName; if (tt.TradeClass == "買入(不要連動新臺幣帳戶)") { usersData.CashValue = ud[0].CashValue; } else { usersData.CashValue = ud[0].CashValue + cv; } usersData.InsuranceValue = ud[0].InsuranceValue; usersData.StockValue = ud[0].StockValue; usersData.FundValue = ud[0].FundValue; usersData.Email = ud[0].Email; usersData.Password = ud[0].Password; dc.Entry(usersData).State = EntityState.Modified; dc.SaveChanges(); } }
//[ValidateAntiForgeryToken] public ActionResult Create(FXtradeTable tradeTable, SummaryTable summaryTable, UsersData usersData) { if (ModelState.IsValid) { //存總表 db.SummaryTable.Add(summaryTable); db.SaveChanges(); //存外匯交易表 var uid = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); tradeTable.SummaryId = uid; db.FXtradeTable.Add(tradeTable); db.SaveChanges(); if (tradeTable.TradeClass == "賣出") { CashIncome cashincome = new CashIncome(); cashincome.UserName = Session["User"].ToString(); cashincome.OID = uid; cashincome.InCashType = summaryTable.TradeType; cashincome.InDate = summaryTable.TradeDate; cashincome.InNote = tradeTable.TradeClass; var change = tradeTable.NTD * -1; cashincome.InAmount = Convert.ToInt32(change); db.CashIncome.Add(cashincome); db.SaveChanges(); //更新個人資產表 TestHomeController th = new TestHomeController(); var name = summaryTable.UserName; var ud = th.GetUsersData(name); usersData.FXValue = th.SaveUserdata(name); usersData.UserName = ud[0].UserName; var cv = Math.Abs(tradeTable.NTD.Value); usersData.CashValue = ud[0].CashValue + tradeTable.NTD; usersData.InsuranceValue = ud[0].InsuranceValue; usersData.StockValue = ud[0].StockValue; usersData.FundValue = ud[0].FundValue; usersData.Email = ud[0].Email; usersData.Password = ud[0].Password; db.Entry(usersData).State = EntityState.Modified; db.SaveChanges(); } else { CashExpense cashexpense = new CashExpense(); cashexpense.UserName = Session["User"].ToString(); cashexpense.OID = uid; cashexpense.ExCashType = summaryTable.TradeType; cashexpense.ExDate = summaryTable.TradeDate; cashexpense.ExNote = tradeTable.TradeClass; if (tradeTable.TradeClass == "買入(不要連動新臺幣帳戶)") { cashexpense.ExAmount = 0; } else { cashexpense.ExAmount = Convert.ToInt32(tradeTable.NTD); } db.CashExpense.Add(cashexpense); db.SaveChanges(); //更新個人資產表 TestHomeController th = new TestHomeController(); var name = summaryTable.UserName; var ud = th.GetUsersData(name); usersData.FXValue = th.SaveUserdata(name); usersData.UserName = ud[0].UserName; var cv = Math.Abs(tradeTable.NTD.Value); if (tradeTable.TradeClass == "買入(不要連動新臺幣帳戶)") { usersData.CashValue = ud[0].CashValue; } else { usersData.CashValue = ud[0].CashValue - tradeTable.NTD; } usersData.InsuranceValue = ud[0].InsuranceValue; usersData.StockValue = ud[0].StockValue; usersData.FundValue = ud[0].FundValue; usersData.Email = ud[0].Email; usersData.Password = ud[0].Password; db.Entry(usersData).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(tradeTable)); }
//Insert Expense public ActionResult InsertExpense([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "ExCashID,UserName,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } summaryTable.TradeType = cashExpense.ExCashType; summaryTable.TradeDate = cashExpense.ExDate; summaryTable.UserName = cashExpense.UserName; db.SummaryTable.Add(summaryTable); if (ModelState.IsValid) { db.CashExpense.Add(cashExpense); try { db.SaveChanges(); } catch (Exception er) { throw er; } return(RedirectToAction("Index")); } return(View(cashExpense)); }