/// <summary> /// AccountSummary /// </summary> /// <returns></returns> public ActionResult AccountSummary() { if (Convert.ToInt32(Session["user"].ToString()) > 0) { StockModels objStockModels = new StockModels(); ViewBag.TradeBalance = Math.Round(Convert.ToDouble(objStockModels.GetUserAccountBalance(Convert.ToInt32(Session["user"].ToString()))), 2); return View(); } else { return RedirectToAction("CreateAccount"); } }
public CTrade BuyTrade(CTrade objCTrade, int GMTInfo) { using (SqlConnection cnn = new SqlConnection(CommonCollection.ConnectionString)) { try { cnn.Open(); using (SqlCommand cmd = new SqlCommand("BuyTrade", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 60; cmd.Parameters.Add("@userId", SqlDbType.Int).Value = objCTrade.UserId; cmd.Parameters.Add("@TradeAmount", SqlDbType.Float).Value = objCTrade.TradeAmount; cmd.Parameters.Add("@SymbolID", SqlDbType.NVarChar).Value = objCTrade.SymbolId; cmd.Parameters.Add("@TradeType", SqlDbType.NVarChar).Value = objCTrade.TradeType; cmd.Parameters.Add("@PayOutPercentage", SqlDbType.Int).Value = objCTrade.PayoutPerCentage; cmd.Parameters.Add("@ExpiryTimeInterval", SqlDbType.Int).Value = objCTrade.ExpiryTimeInterval; cmd.Parameters.Add("@xpoints", SqlDbType.NVarChar).Value = objCTrade.xpoints; cmd.Parameters.Add("@ypoints", SqlDbType.NVarChar).Value = objCTrade.ypoints; cmd.Parameters.Add("@TradeWay", SqlDbType.NVarChar).Value = objCTrade.TradeWay; cmd.Parameters.Add("@idOut", SqlDbType.Int).Value = null; cmd.Parameters["@idOut"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); objCTrade.TradeId = Convert.ToInt32(cmd.Parameters["@idOut"].Value.ToString()); if (objCTrade.TradeId > 0) { StockModels objStockModels = new StockModels(); objStockModels.GetTradebyTradeId(objCTrade, GMTInfo, 0); } } } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { cnn.Close(); cnn.Dispose(); GC.Collect(); SqlConnection.ClearPool(cnn); } return objCTrade; } }
public ActionResult BuyTrade(double TradeAmount, Int32 PayoutPercentage, string SymbolId, string TradeType, Int32 ExpiryTimeInterval, string xpoints, string ypoints, string TradeWay) { CTrade objCTrade = new CTrade(); Int32 UserId = Convert.ToInt32(Session["user"]); Int32 GmtInfo = Convert.ToInt32(Session["GMTInfo"]); try { if (UserId > -1) { objCTrade.TradeId = -1; objCTrade.TradeAmount = TradeAmount; objCTrade.PayoutPerCentage = PayoutPercentage; objCTrade.SymbolId = SymbolId; objCTrade.TradeType = TradeType; objCTrade.UserId = UserId; objCTrade.ExpiryTimeInterval = ExpiryTimeInterval; objCTrade.xpoints = xpoints; objCTrade.ypoints = ypoints; objCTrade.TradeWay = TradeWay; StockModels objStockModels = new StockModels(); objCTrade = objStockModels.BuyTrade(objCTrade, GmtInfo); if (objCTrade.TradeId > 0) { if (Convert.ToInt32(Session["user"]) > 0) { Session["TradeBalance"] = Math.Round(Convert.ToDouble(objStockModels.GetUserAccountBalance(Convert.ToInt32(Session["user"].ToString()))), 2); } else { Session["TradeBalance"] = -1; } } else { return Json(objCTrade); } } else { objCTrade.TradeId = -1; return Json(objCTrade); } } catch (Exception ex) { throw ex; } return PartialView("_SingleOpenTrade", objCTrade); }
public string returngraphdata(string SymbolId, Int32 timeinterval) { StockModels objStockModels = new StockModels(); return objStockModels.returngraphdata(SymbolId, timeinterval); }
public Int32 OpenAccount(string FirstName, String LastName, String Title, String EmailId, String Country, String PhoneNo, String DateOfBirth, String UserName, String Password, String AccountBaseCurrency, bool IsPromotionalSubcribed) { try { RegisterModel objRegisterModel = new RegisterModel(); UserAccountModels objUserAccountModels = new UserAccountModels(); objRegisterModel.FirstName = FirstName; objRegisterModel.LastName = LastName; objRegisterModel.Title = Title; objRegisterModel.Email = EmailId; objRegisterModel.Country = Country; objRegisterModel.PhoneNo = PhoneNo; objRegisterModel.DateOfBirth = DateOfBirth; objRegisterModel.UserName = UserName; objRegisterModel.Password = Password; objRegisterModel.AccountBaseCurrency = AccountBaseCurrency; objRegisterModel.IsPromotionalSubcribed = IsPromotionalSubcribed; objRegisterModel = objUserAccountModels.OpenAccount(objRegisterModel); if (objRegisterModel.UserId > 0) { objUserAccountModels.ValidateUser(UserName, Password); Session["username"] = FirstName + " " + LastName; Session["user"] = objRegisterModel.UserId; StockModels objStockModels = new StockModels(); Session["TradeBalance"] = Math.Round(Convert.ToDouble(objStockModels.GetUserAccountBalance(Convert.ToInt32(Session["user"].ToString()))), 2); return 1; } else { return -2; } } catch (Exception ex) { throw ex; } }
public ActionResult LogIn(String UserName, String Password, Int32 UserId = 0) { try { if (UserId != 0) { Session["GMTInfo"] = UserName; } UserAccountModels objUserAccountModels = new UserAccountModels(); Int32 nResult = objUserAccountModels.ValidateUser(UserName, Password, UserId); if (nResult > 0) { Session["user"] = nResult; Session["username"] = CommonCollection.GetUserName(nResult); StockModels objStockModels = new StockModels(); Session["TradeBalance"] = Math.Round(Convert.ToDouble(objStockModels.GetUserAccountBalance(Convert.ToInt32(Session["user"].ToString()))), 2); Session["isadmin"] = false; } else { Session["user"] = -1; ViewBag.WrongLogin = 1; ViewBag.WrongLoginCreditional = "Wrong UserName Password!"; Session["isadmin"] = false; } } catch (Exception ex) { throw ex; } return PartialView("~/Views/Shared/_LayoutLeft.cshtml"); }
// // GET: /Stock/ /// <summary> /// Index /// </summary> /// <returns></returns> public ActionResult Index() { VMIndex objVMIndex = new VMIndex(); StockModels objStockModels = new StockModels(); Int32 GmtInfo = Convert.ToInt32(Session["GMTInfo"]); objVMIndex.VMOptionFilterType = objStockModels.GetOptionFilters(Convert.ToInt32(Session["user"])); if (Convert.ToInt32(Session["user"]) > 0) { objVMIndex.LstOpenTrade = objStockModels.GetOpenTrades(Convert.ToInt32(Session["user"]), GmtInfo); objVMIndex.LstTradeHistory = objStockModels.GetTradeHistory(Convert.ToInt32(Session["user"]), GmtInfo); } return View(objVMIndex); }
public Double GetUserAccountBalance() { if (Convert.ToInt32(Session["user"]) > 0) { StockModels objStockModels = new StockModels(); Session["TradeBalance"] = Math.Round(Convert.ToDouble(objStockModels.GetUserAccountBalance(Convert.ToInt32(Session["user"].ToString()))), 2); return Convert.ToDouble(Session["TradeBalance"]); } else { return -1; } }
public ActionResult GetTradeTabsWithAllTradeHistory() { VMIndex objVMIndex = new VMIndex(); StockModels objStockModels = new StockModels(); Int32 UserId = Convert.ToInt32(Session["user"]); Int32 GmtInfo = Convert.ToInt32(Session["GMTInfo"]); try { if (UserId > -1) { objVMIndex.LstOpenTrade = objStockModels.GetOpenTrades(UserId, GmtInfo); objVMIndex.LstTradeHistory = objStockModels.GetAllTradeHistory(UserId, GmtInfo); Session["TradeBalance"] = objStockModels.GetUserAccountBalance(UserId); return PartialView("_TradeTabs", objVMIndex); } else { CTrade objCTrade = new CTrade(); objCTrade.TradeId = -1; return Json(objCTrade); } } catch (Exception ex) { throw ex; } }
public ActionResult GetTradebyTradeId(Int32 TradeId, string ExpPrice) { CTrade objCTrade = new CTrade(); StockModels objStockModels = new StockModels(); Int32 UserId = Convert.ToInt32(Session["user"]); Int32 GmtInfo = Convert.ToInt32(Session["GMTInfo"]); try { if (UserId > -1) { objCTrade.TradeId = TradeId; objCTrade.UserId = UserId; objStockModels.TradeExpire(TradeId, ExpPrice); objCTrade = objStockModels.GetTradebyTradeId(objCTrade, GmtInfo, 1); ViewBag.IsClosed = 1; Session["TradeBalance"] = objStockModels.GetUserAccountBalance(UserId); ViewBag.IsClosed = 1; if (objCTrade.TradeId == 0) { return Json(objCTrade); } return PartialView("_SingleOpenTrade", objCTrade); } else { objCTrade.TradeId = -1; return Json(objCTrade); } } catch (Exception ex) { throw ex; } }
public string GetOpenTradeGraph(Int32 TradeId) { if (Convert.ToInt32(Session["user"].ToString()) > 0) { StockModels objStockModels = new StockModels(); return objStockModels.GetOpenTradeGraph(TradeId); } else { return "-1"; } }