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 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 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 List<CTrade> GetTradeHistory(int UserId, int GMTInfo) { List<CTrade> lstCTrade = new List<CTrade>(); using (SqlConnection cnn = new SqlConnection(CommonCollection.ConnectionString)) { try { cnn.Open(); using (SqlCommand cmm = new SqlCommand("select top(15) [TradeId] ,[UserId],tradehistory.[SymbolId],[SymbolName],[TradeAmount],[BuyTimestamp],[ExpireTimestamp],dbo.F_DATETIME_TO_UNIX_TIME(BuyTimestamp) as [BuyTimestampUTC],dbo.F_DATETIME_TO_UNIX_TIME(ExpireTimestamp) as [ExpireTimestampUTC],[PriceAtBuy],[PriceAtExpire] ,[TradeType],TradeHistory.[PayoutPerCentage],[Description] from TradeHistory,Symbol_info where TradeHistory.SymbolId = Symbol_info.SymbolId and ExpireTimestamp < GETUTCDATE() and Status = 1 and UserId = " + UserId.ToString() + " order by BuyTimestamp desc", cnn)) { using (SqlDataAdapter a = new SqlDataAdapter(cmm)) { DataTable t = new DataTable(); a.Fill(t); if (t.Rows.Count > 0) { foreach (DataRow dtRow in t.Rows) { CTrade oCTrade = new CTrade(); oCTrade.BuyTimestamp = CommonCollection.GetLocalTime(Convert.ToInt64(dtRow["BuyTimestampUTC"]), GMTInfo); oCTrade.ExpireTimestamp = CommonCollection.GetLocalTime(Convert.ToInt64(dtRow["ExpireTimestampUTC"]), GMTInfo); oCTrade.Description = dtRow["Description"].ToString(); oCTrade.PayoutPerCentage = Convert.ToInt32(dtRow["PayoutPerCentage"].ToString()); oCTrade.PriceAtBuy = Convert.ToDouble(dtRow["PriceAtBuy"].ToString()); oCTrade.PriceAtExpire = Convert.ToDouble(dtRow["PriceAtExpire"].ToString()); oCTrade.SymbolId = dtRow["SymbolName"].ToString(); oCTrade.TradeType = dtRow["TradeType"].ToString(); oCTrade.TradeAmount = Convert.ToDouble(dtRow["TradeAmount"]); oCTrade.TradeId = Convert.ToInt32(dtRow["TradeId"]); oCTrade.UTCBuyTimestamp = Convert.ToInt64(dtRow["BuyTimestampUTC"]); oCTrade.UTCExpireTimestamp = Convert.ToInt64(dtRow["ExpireTimestampUTC"]); lstCTrade.Add(oCTrade); } } } } } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { cnn.Close(); cnn.Dispose(); GC.Collect(); SqlConnection.ClearPool(cnn); } return lstCTrade; } }
public CTrade GetTradebyTradeId(CTrade objCTrade, int GMTInfo, int status) { String Query = ""; using (SqlConnection cnn = new SqlConnection(CommonCollection.ConnectionString)) { try { cnn.Open(); if (objCTrade.TradeId > 0) { if (status == 0) { Query = "select [TradeId] ,[UserId],[xpoints],[ypoints],[TradeWay],tradehistory.[SymbolId],[SymbolName],[TradeAmount],[BuyTimestamp],[ExpireTimestamp],dbo.F_DATETIME_TO_UNIX_TIME(BuyTimestamp) as [BuyTimestampUTC],dbo.F_DATETIME_TO_UNIX_TIME(ExpireTimestamp) as [ExpireTimestampUTC],[PriceAtBuy],[PriceAtExpire] ,[TradeType],TradeHistory.[PayoutPerCentage],[Description] from TradeHistory,Symbol_info where TradeHistory.SymbolId = Symbol_info.SymbolId and UserId =" + objCTrade.UserId + " and TradeId = " + objCTrade.TradeId + " "; } else { Query = "select [TradeId] ,[UserId],[xpoints],[ypoints],[TradeWay],tradehistory.[SymbolId],[SymbolName],[TradeAmount],[BuyTimestamp],[ExpireTimestamp],dbo.F_DATETIME_TO_UNIX_TIME(BuyTimestamp) as [BuyTimestampUTC],dbo.F_DATETIME_TO_UNIX_TIME(ExpireTimestamp) as [ExpireTimestampUTC],[PriceAtBuy],[PriceAtExpire] ,[TradeType],TradeHistory.[PayoutPerCentage],[Description] from TradeHistory,Symbol_info where TradeHistory.SymbolId = Symbol_info.SymbolId and status= 1 and UserId =" + objCTrade.UserId + " and TradeId = " + objCTrade.TradeId + " "; } using (SqlCommand cmm = new SqlCommand(Query, cnn)) { using (SqlDataAdapter a = new SqlDataAdapter(cmm)) { DataTable t = new DataTable(); a.Fill(t); if (t.Rows.Count > 0) { objCTrade.Description = t.Rows[0]["Description"].ToString(); objCTrade.PayoutPerCentage = Convert.ToInt32(t.Rows[0]["PayoutPerCentage"].ToString()); objCTrade.PriceAtBuy = Convert.ToDouble((t.Rows[0]["ypoints"]).ToString()); objCTrade.SymbolId = t.Rows[0]["SymbolName"].ToString(); objCTrade.TradeType = t.Rows[0]["TradeType"].ToString(); objCTrade.TradeAmount = Convert.ToDouble(t.Rows[0]["TradeAmount"]); objCTrade.TradeId = Convert.ToInt32(t.Rows[0]["TradeId"]); objCTrade.BuyTimestamp = CommonCollection.GetLocalTime(Convert.ToInt64(t.Rows[0]["BuyTimestampUTC"]), GMTInfo); objCTrade.ExpireTimestamp = CommonCollection.GetLocalTime(Convert.ToInt64(t.Rows[0]["ExpireTimestampUTC"]), GMTInfo); objCTrade.UTCBuyTimestamp = Convert.ToInt64(t.Rows[0]["BuyTimestampUTC"]); objCTrade.UTCExpireTimestamp = Convert.ToInt64(t.Rows[0]["ExpireTimestampUTC"]); objCTrade.xpoints = (t.Rows[0]["xpoints"]).ToString(); objCTrade.ypoints = (t.Rows[0]["ypoints"]).ToString(); objCTrade.TradeWay = (t.Rows[0]["TradeWay"]).ToString(); objCTrade.PriceAtExpire = Convert.ToDouble((t.Rows[0]["PriceAtExpire"]).ToString()); } else { objCTrade.TradeId = 0; } } } } } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { cnn.Close(); cnn.Dispose(); GC.Collect(); SqlConnection.ClearPool(cnn); } return objCTrade; } }