//[Authorize(Roles = "Administrator")] public ActionResult EditPrice(int Id) { if (Session["userId"] != null && Session["userId"].Equals(_username)) { } else { return(RedirectToAction("Login", "Account")); } ActualTransactions theTransaction = dbcontext.ActualTransactions.Find(Id); ViewBag.TheStrategy = theTransaction.Strategy; return(View(theTransaction)); }
//[Authorize(Roles = "Administrator")] public ActionResult EditPrice(ActualTransactions actualTransaction) { if (Session["userId"] != null && Session["userId"].Equals(_username)) { } else { return(RedirectToAction("Login", "Account")); } ActualTransactions transactionToSave = dbcontext.ActualTransactions.Find(actualTransaction.ID); transactionToSave.ActualLABUStartingPrice = actualTransaction.ActualLABUStartingPrice; transactionToSave.ActualLABUEndingPrice = actualTransaction.ActualLABUEndingPrice; transactionToSave.ActualLABDStartingPrice = actualTransaction.ActualLABDStartingPrice; transactionToSave.ActualLABDEndingPrice = actualTransaction.ActualLABDEndingPrice; dbcontext.SaveChanges(); return(RedirectToAction("EditTransactionsPage"));; }
public ActionResult InsertNewTrades() { List <ActualTransactions> transactionsDetails = new List <ActualTransactions>(); var transactions = dbcontext.GetTrades(); foreach (var item in transactions) { ActualTransactions details = new ActualTransactions(); details.ID = item.ID; details.Date = item.Date; details.StartingLABUPrice = item.StartingLABUPrice; details.StartingLABDPrice = item.StartingLABDPrice; details.Strategy = item.Strategy; details.StartingType = item.StartingType; details.Shares = item.Shares; details.EndingLABUPrice = item.EndingLABUPrice; details.EndingLABDPrice = item.EndingLABDPrice; details.Type = item.Type; details.Reason = item.Reason; details.ActualLABUStartingPrice = ""; details.ActualLABDStartingPrice = ""; details.ActualLABUEndingPrice = ""; details.ActualLABDEndingPrice = ""; details.EndDate = item.EndDate; transactionsDetails.Add(details); } transactionsDetails.OrderBy(t => t.ID); ActualTransactions lastRecord = dbcontext.ActualTransactions.OrderByDescending(x => x.ID).FirstOrDefault(); int lastRecordID = lastRecord.ID; string lastRecordTimestamp = lastRecord.Date; bool DateMatch = false; int counter = 0; int lastIDinActualTransactionTable = 0; int numbOfNewTrades = 0; foreach (var item in transactionsDetails) { //if(item.ID > lastRecordID) //{ // dbcontext.ActualTransactions.Add(item); // dbcontext.SaveChanges(); //} if (item.Date.Equals(lastRecordTimestamp)) { DateMatch = true; lastIDinActualTransactionTable = lastRecordID; } if (DateMatch) { counter++; } if (counter > 1) { lastIDinActualTransactionTable++; item.ID = lastIDinActualTransactionTable; dbcontext.ActualTransactions.Add(item); dbcontext.SaveChanges(); numbOfNewTrades++; } } string jsonMessage = ""; if (numbOfNewTrades == 1) { jsonMessage = "Inserted " + numbOfNewTrades + " new trade. "; } else { jsonMessage = "Inserted " + numbOfNewTrades + " new trades. "; } return(Json(new { success = jsonMessage }, JsonRequestBehavior.AllowGet)); }