/// <summary> /// Method to get database parameters /// </summary> /// <param name="cmdType">command type</param> /// <returns>parameters list</returns> public ArrayList DbParamList(int cmdType) { ArrayList paramList = new ArrayList(); DBUtilities dbUtilities = new DBUtilities(); paramList.Add(dbUtilities.CreateSqlParamater("@id", SqlDbType.VarChar, ParameterDirection.Input, this.Id)); paramList.Add(dbUtilities.CreateSqlParamater("@process_id", SqlDbType.Int, ParameterDirection.Input, this.ProcessId)); paramList.Add(dbUtilities.CreateSqlParamater("@status_message", SqlDbType.VarChar, ParameterDirection.Input, this.StatusMessage)); return(paramList); }
/// <summary> /// Gets the equity order detail from database /// </summary> /// <param name="orderExchangeRef">order reference to get details for</param> /// <returns>true if record found, false otherwise</returns> private bool GetOrderRecordFromDatabase(string orderExchangeRef) { bool doesOrderRecordExist = false; DBLibrary dbLib = new DBLibrary(); DBUtilities dbUtilities = new DBUtilities(); try { ArrayList paramList = new ArrayList { dbUtilities.CreateSqlParamater("@orderRef", SqlDbType.VarChar, 50, ParameterDirection.Input, orderExchangeRef) }; // Query the database for an orderRecord with given orderRecordId DataSet ds = dbLib.ExecuteProcedureDS("sp_select_st_derivatives_orderbook", paramList); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; // Get StockOrderBookRecord data OrderDate = DateTime.Parse(dr["order_date"].ToString()); ContractName = dr["contract_name"].ToString(); Direction = (OrderDirection)Enum.Parse(typeof(OrderDirection), dr["direction"].ToString()); Quantity = int.Parse(dr["qty"].ToString()); Price = double.Parse(dr["price"].ToString()); OrderRefenceNumber = dr["order_ref"].ToString(); Exchange = (Exchange)Enum.Parse(typeof(Exchange), dr["exchange"].ToString()); OrderStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), dr["order_status"].ToString()); OpenQty = int.Parse(dr["qty_open"].ToString()); ExecutedQty = int.Parse(dr["qty_executed"].ToString()); ExpiredQty = int.Parse(dr["qty_expired"].ToString()); CancelledQty = int.Parse(dr["qty_cancelled"].ToString()); StopLossPrice = double.Parse(dr["stoploss_price"].ToString()); UpdatedAt = DateTime.Parse(dr["status_update_time"].ToString()); AlgoId = int.Parse(dr["algo_id"].ToString()); doesOrderRecordExist = true; } } } catch (Exception ex) { // If we failed, trace the error for log analysis Logger.LogException(ex); throw; } return(doesOrderRecordExist); }
public static bool DoesExistEOPStatsForMinMaxAlgos(string contractName, short algoId, double marketDirection, string r1, string r2) { //EOPTradeStats eopTradeStats = null; DBUtilities dbUtilities = new DBUtilities(); DBLibrary dbLib = new DBLibrary(""); ArrayList paramList = new ArrayList { dbUtilities.CreateSqlParamater("@contract_name", SqlDbType.VarChar, 100, ParameterDirection.Input, contractName), dbUtilities.CreateSqlParamater("@market_direction_percentage", SqlDbType.Decimal, ParameterDirection.Input, marketDirection), dbUtilities.CreateSqlParamater("@algo_id", SqlDbType.SmallInt, ParameterDirection.Input, algoId) }; var param = dbUtilities.CreateSqlParamater("@r1", SqlDbType.VarChar, 100, ParameterDirection.Input, r1); param.IsNullable = true; param.Value = param.Value ?? DBNull.Value; paramList.Add(param); param = dbUtilities.CreateSqlParamater("@r2", SqlDbType.VarChar, 100, ParameterDirection.Input, r2); param.IsNullable = true; param.Value = param.Value ?? DBNull.Value; paramList.Add(param); // Query the database DataSet ds = dbLib.ExecuteProcedureDS("sp_select_st_trading_eop_statsbook", paramList); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(true); } return(false); }
/// <summary> /// Method to read recent log /// </summary> /// <param name="reportId">Id of the report</param> /// <returns>log string</returns> public static string ReadRecentLog(string reportId) { string latestLog = string.Empty; ArrayList paramList = new ArrayList(); paramList.Add(dbUtilities.CreateSqlParamater("@id", SqlDbType.VarChar, ParameterDirection.Input, reportId)); DataSet ds = dbLib.ExecuteProcedureDS("sp_select_pdr_logs", paramList); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { latestLog = (ds.Tables[0].Rows[0])["status_message"].ToString(); } return(latestLog); }
public ArrayList DbParamListForInsert() { ArrayList paramList = new ArrayList(); DBUtilities dbUtilities = new DBUtilities(); paramList.Add(dbUtilities.CreateSqlParamater("@property_id", SqlDbType.NVarChar, 50, ParameterDirection.Input, this.property_id)); paramList.Add(dbUtilities.CreateSqlParamater("@project_name", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.project_name))); paramList.Add(dbUtilities.CreateSqlParamater("@project_id", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.project_id))); paramList.Add(dbUtilities.CreateSqlParamater("@project_url", SqlDbType.NVarChar, 100, ParameterDirection.Input, GetDBValue(this.project_url))); paramList.Add(dbUtilities.CreateSqlParamater("@area_id", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.area_id))); paramList.Add(dbUtilities.CreateSqlParamater("@area_name", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.area_name))); paramList.Add(dbUtilities.CreateSqlParamater("@city", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.city))); paramList.Add(dbUtilities.CreateSqlParamater("@property_description", SqlDbType.NVarChar, 256, ParameterDirection.Input, GetDBValue(this.property_description))); paramList.Add(dbUtilities.CreateSqlParamater("@title", SqlDbType.NVarChar, 100, ParameterDirection.Input, GetDBValue(this.title))); paramList.Add(dbUtilities.CreateSqlParamater("@about_project", SqlDbType.NVarChar, 100, ParameterDirection.Input, GetDBValue(this.about_project))); paramList.Add(dbUtilities.CreateSqlParamater("@property_type", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.property_type))); paramList.Add(dbUtilities.CreateSqlParamater("@unit_type", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.unit_type))); paramList.Add(dbUtilities.CreateSqlParamater("@floor_number", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.floor_number))); paramList.Add(dbUtilities.CreateSqlParamater("@bed_rooms", SqlDbType.Decimal, ParameterDirection.Input, GetDBValue(this.bed_rooms))); paramList.Add(dbUtilities.CreateSqlParamater("@bath_rooms", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.bath_rooms))); paramList.Add(dbUtilities.CreateSqlParamater("@balconies", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.balconies))); paramList.Add(dbUtilities.CreateSqlParamater("@area_carpet", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.area_carpet))); paramList.Add(dbUtilities.CreateSqlParamater("@area_builtup", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.area_builtup))); paramList.Add(dbUtilities.CreateSqlParamater("@rent_monthly", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.rent_monthly))); paramList.Add(dbUtilities.CreateSqlParamater("@deposit_amount", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.deposit_amount))); paramList.Add(dbUtilities.CreateSqlParamater("@property_age_years", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.property_age_years))); paramList.Add(dbUtilities.CreateSqlParamater("@total_floors", SqlDbType.Int, ParameterDirection.Input, GetDBValue(this.total_floors))); paramList.Add(dbUtilities.CreateSqlParamater("@facing", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.facing))); paramList.Add(dbUtilities.CreateSqlParamater("@area_unit_type", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.area_unit_type))); paramList.Add(dbUtilities.CreateSqlParamater("@flooring_type", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.flooring_type))); paramList.Add(dbUtilities.CreateSqlParamater("@intent", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.intent))); paramList.Add(dbUtilities.CreateSqlParamater("@ownership", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.ownership))); paramList.Add(dbUtilities.CreateSqlParamater("@is_negotiable", SqlDbType.NVarChar, 10, ParameterDirection.Input, GetDBValue(this.is_negotiable))); paramList.Add(dbUtilities.CreateSqlParamater("@bachelors_allowed", SqlDbType.NVarChar, 10, ParameterDirection.Input, GetDBValue(this.bachelors_allowed))); paramList.Add(dbUtilities.CreateSqlParamater("@furnish_state", SqlDbType.NVarChar, 50, ParameterDirection.Input, GetDBValue(this.furnish_state))); paramList.Add(dbUtilities.CreateSqlParamater("@two_wheeler_parking", SqlDbType.NVarChar, 10, ParameterDirection.Input, GetDBValue(this.two_wheeler_parking))); paramList.Add(dbUtilities.CreateSqlParamater("@four_wheeler_parking", SqlDbType.NVarChar, 10, ParameterDirection.Input, GetDBValue(this.four_wheeler_parking))); paramList.Add(dbUtilities.CreateSqlParamater("@address", SqlDbType.NVarChar, 100, ParameterDirection.Input, GetDBValue(this.address))); paramList.Add(dbUtilities.CreateSqlParamater("@source_system", SqlDbType.NVarChar, 30, ParameterDirection.Input, GetDBValue(this.source_system))); paramList.Add(dbUtilities.CreateSqlParamater("@record_type", SqlDbType.NVarChar, 20, ParameterDirection.Input, GetDBValue(this.record_type))); paramList.Add(dbUtilities.CreateSqlParamater("@added_by_type", SqlDbType.NVarChar, 20, ParameterDirection.Input, GetDBValue(this.added_by_type))); paramList.Add(dbUtilities.CreateSqlParamater("@added_by_name", SqlDbType.NVarChar, 20, ParameterDirection.Input, GetDBValue(this.added_by_name))); paramList.Add(dbUtilities.CreateSqlParamater("@contact_person_type", SqlDbType.NVarChar, 20, ParameterDirection.Input, GetDBValue(this.contact_person_type))); paramList.Add(dbUtilities.CreateSqlParamater("@latitude", SqlDbType.NVarChar, 20, ParameterDirection.Input, GetDBValue(this.latitude))); paramList.Add(dbUtilities.CreateSqlParamater("@longitude", SqlDbType.NVarChar, 20, ParameterDirection.Input, GetDBValue(this.longitude))); //contact_person_type paramList.Add(dbUtilities.CreateSqlParamater("@possession_from", SqlDbType.DateTime, ParameterDirection.Input, GetDBValue(this.possession_from))); paramList.Add(dbUtilities.CreateSqlParamater("@added_on", SqlDbType.DateTime, ParameterDirection.Input, GetDBValue(this.added_on))); return(paramList); }
public ArrayList DbParamList(int cmdType) { ArrayList paramList = new ArrayList(); DBUtilities dbUtilities = new DBUtilities(); paramList.Add(dbUtilities.CreateSqlParamater("@contract_name", SqlDbType.NVarChar, 100, ParameterDirection.Input, this.contract_name)); paramList.Add(dbUtilities.CreateSqlParamater("@trade_date", SqlDbType.DateTime, ParameterDirection.Input, this.trade_date)); paramList.Add(dbUtilities.CreateSqlParamater("@num_trades", SqlDbType.Int, ParameterDirection.Input, this.num_trades)); paramList.Add(dbUtilities.CreateSqlParamater("@num_profit_trades", SqlDbType.Int, ParameterDirection.Input, this.num_profit_trades)); paramList.Add(dbUtilities.CreateSqlParamater("@num_loss_trades", SqlDbType.Int, ParameterDirection.Input, this.num_loss_trades)); paramList.Add(dbUtilities.CreateSqlParamater("@min_price", SqlDbType.Decimal, ParameterDirection.Input, this.min_price)); paramList.Add(dbUtilities.CreateSqlParamater("@max_price", SqlDbType.Decimal, ParameterDirection.Input, this.max_price)); paramList.Add(dbUtilities.CreateSqlParamater("@quantity", SqlDbType.Int, ParameterDirection.Input, this.quantity)); paramList.Add(dbUtilities.CreateSqlParamater("@actual_profit", SqlDbType.Decimal, ParameterDirection.Input, this.actual_profit)); paramList.Add(dbUtilities.CreateSqlParamater("@expected_profit", SqlDbType.Decimal, ParameterDirection.Input, this.expected_profit)); paramList.Add(dbUtilities.CreateSqlParamater("@average_profit_pertrade", SqlDbType.Decimal, ParameterDirection.Input, this.average_profit_pertrade)); paramList.Add(dbUtilities.CreateSqlParamater("@average_loss_pertrade", SqlDbType.Decimal, ParameterDirection.Input, this.average_loss_pertrade)); paramList.Add(dbUtilities.CreateSqlParamater("@roi_percentage", SqlDbType.Decimal, ParameterDirection.Input, this.roi_percentage)); paramList.Add(dbUtilities.CreateSqlParamater("@market_direction_percentage", SqlDbType.Decimal, ParameterDirection.Input, this.market_direction_percentage)); paramList.Add(dbUtilities.CreateSqlParamater("@actual_roi_percentage", SqlDbType.Decimal, ParameterDirection.Input, this.actual_roi_percentage)); paramList.Add(dbUtilities.CreateSqlParamater("@brokerage", SqlDbType.Decimal, ParameterDirection.Input, this.brokerage)); var param = dbUtilities.CreateSqlParamater("@r1", SqlDbType.NVarChar, 100, ParameterDirection.Input, this.r1); param.IsNullable = true; param.Value = param.Value ?? DBNull.Value; paramList.Add(param); param = dbUtilities.CreateSqlParamater("@r2", SqlDbType.NVarChar, 100, ParameterDirection.Input, this.r2); param.IsNullable = true; param.Value = param.Value ?? DBNull.Value; paramList.Add(param); paramList.Add(dbUtilities.CreateSqlParamater("@algo_id", SqlDbType.Int, ParameterDirection.Input, this.algo_id)); paramList.Add(dbUtilities.CreateSqlParamater("@inmarket_time_in_minutes", SqlDbType.Int, ParameterDirection.Input, this.inmarket_time_in_minutes)); paramList.Add(dbUtilities.CreateSqlParamater("@number_of_ticks", SqlDbType.Int, ParameterDirection.Input, this.number_of_ticks)); paramList.Add(dbUtilities.CreateSqlParamater("@status_update_time", SqlDbType.DateTime, ParameterDirection.Input, this.status_update_time)); paramList.Add(dbUtilities.CreateSqlParamater("@upsertStatus", SqlDbType.Bit, ParameterDirection.Output)); return(paramList); }
/// <summary> /// Method to prepare the Database parameter list /// </summary> /// <param name="cmdType">Command Type</param> /// <returns>Arraylist of SQL parameters</returns> public ArrayList DbParamList(int cmdType) { ArrayList paramList = new ArrayList(); DBUtilities dbUtilities = new DBUtilities(); paramList.Add(dbUtilities.CreateSqlParamater("@contractName", SqlDbType.NVarChar, 50, ParameterDirection.Input, this.ContractName)); paramList.Add(dbUtilities.CreateSqlParamater("@tradeDate", SqlDbType.DateTime, ParameterDirection.Input, this.TradeDate)); paramList.Add(dbUtilities.CreateSqlParamater("@orderRef", SqlDbType.VarChar, 30, ParameterDirection.Input, this.OrderRefenceNumber)); paramList.Add(dbUtilities.CreateSqlParamater("@direction", SqlDbType.SmallInt, ParameterDirection.Input, this.Direction)); paramList.Add(dbUtilities.CreateSqlParamater("@qty", SqlDbType.Int, ParameterDirection.Input, this.Quantity)); paramList.Add(dbUtilities.CreateSqlParamater("@price", SqlDbType.Decimal, ParameterDirection.Input, this.Price)); paramList.Add(dbUtilities.CreateSqlParamater("@exchange", SqlDbType.SmallInt, ParameterDirection.Input, this.Exchange)); paramList.Add(dbUtilities.CreateSqlParamater("@tradeValue", SqlDbType.Decimal, ParameterDirection.Input, this.TradeValue)); paramList.Add(dbUtilities.CreateSqlParamater("@brokerage", SqlDbType.Decimal, ParameterDirection.Input, this.Brokerage)); paramList.Add(dbUtilities.CreateSqlParamater("@algoId", SqlDbType.Int, ParameterDirection.Input, this.AlgoId)); paramList.Add(dbUtilities.CreateSqlParamater("@statusUpdateAt", SqlDbType.VarChar, 127, ParameterDirection.Input, DateTime.Now)); paramList.Add(dbUtilities.CreateSqlParamater("@upsertStatus", SqlDbType.Bit, ParameterDirection.Output)); return(paramList); }
/// <summary> /// Method to prepare the Database parameter list /// </summary> /// <param name="cmdType">Command Type</param> /// <returns>Arraylist of SQL parameters</returns> public ArrayList DbParamList(int cmdType) { ArrayList paramList = new ArrayList(); DBUtilities dbUtilities = new DBUtilities(); paramList.Add(dbUtilities.CreateSqlParamater("@contractName", SqlDbType.NVarChar, 100, ParameterDirection.Input, this.ContractName)); paramList.Add(dbUtilities.CreateSqlParamater("@orderDate", SqlDbType.DateTime, ParameterDirection.Input, this.OrderDate)); paramList.Add(dbUtilities.CreateSqlParamater("@orderRef", SqlDbType.VarChar, 30, ParameterDirection.Input, this.OrderRefenceNumber)); paramList.Add(dbUtilities.CreateSqlParamater("@direction", SqlDbType.SmallInt, ParameterDirection.Input, this.Direction)); paramList.Add(dbUtilities.CreateSqlParamater("@qty", SqlDbType.Int, ParameterDirection.Input, this.Quantity)); paramList.Add(dbUtilities.CreateSqlParamater("@price", SqlDbType.Decimal, ParameterDirection.Input, this.Price)); paramList.Add(dbUtilities.CreateSqlParamater("@orderStatus", SqlDbType.SmallInt, ParameterDirection.Input, this.OrderStatus)); paramList.Add(dbUtilities.CreateSqlParamater("@exchange", SqlDbType.SmallInt, ParameterDirection.Input, this.Exchange)); paramList.Add(dbUtilities.CreateSqlParamater("@qtyOpen", SqlDbType.Int, ParameterDirection.Input, this.OpenQty)); paramList.Add(dbUtilities.CreateSqlParamater("@qtyExecuted", SqlDbType.Int, ParameterDirection.Input, this.ExecutedQty)); paramList.Add(dbUtilities.CreateSqlParamater("@qtyCancelled", SqlDbType.Int, ParameterDirection.Input, this.CancelledQty)); paramList.Add(dbUtilities.CreateSqlParamater("@qtyExpired", SqlDbType.Int, ParameterDirection.Input, this.ExpiredQty)); paramList.Add(dbUtilities.CreateSqlParamater("@stoplossPrice", SqlDbType.Decimal, ParameterDirection.Input, this.StopLossPrice)); paramList.Add(dbUtilities.CreateSqlParamater("@algoId", SqlDbType.Int, ParameterDirection.Input, this.AlgoId)); paramList.Add(dbUtilities.CreateSqlParamater("@statusUpdateAt", SqlDbType.VarChar, 127, ParameterDirection.Input, DateTime.Now)); paramList.Add(dbUtilities.CreateSqlParamater("@upsertStatus", SqlDbType.Bit, ParameterDirection.Output)); //switch (cmdType) //{ // case 0: // paramList.Add(dbUtilities.CreateSqlParamater("@insertStatus", SqlDbType.Bit, ParameterDirection.Output)); // break; // case 1: // paramList.Add(dbUtilities.CreateSqlParamater("@updateStatus", SqlDbType.Bit, ParameterDirection.Output)); // break; // default: // break; //} return(paramList); }
/// <summary> /// Method to prepare the Database parameter list /// </summary> /// <param name="cmdType">Command Type</param> /// <returns>Arraylist of SQL parameters</returns> public ArrayList DbParamList(int cmdType) { ArrayList paramList = new ArrayList(); DBUtilities dbUtilities = new DBUtilities(); paramList.Add(dbUtilities.CreateSqlParamater("@contractName", SqlDbType.NVarChar, 100, ParameterDirection.Input, this.ContractName)); paramList.Add(dbUtilities.CreateSqlParamater("@quoteTime", SqlDbType.DateTime, ParameterDirection.Input, this.QuoteTime)); paramList.Add(dbUtilities.CreateSqlParamater("@instrumentType", SqlDbType.SmallInt, ParameterDirection.Input, this.InstrumentType)); paramList.Add(dbUtilities.CreateSqlParamater("@assetUnderlying", SqlDbType.VarChar, 50, ParameterDirection.Input, this.AssetUnderlying)); paramList.Add(dbUtilities.CreateSqlParamater("@strikePrice", SqlDbType.Decimal, ParameterDirection.Input, this.StrikePrice)); paramList.Add(dbUtilities.CreateSqlParamater("@expiryDate", SqlDbType.DateTime, ParameterDirection.Input, this.ExpiryDate)); paramList.Add(dbUtilities.CreateSqlParamater("@lastTradePrice", SqlDbType.Decimal, ParameterDirection.Input, this.LastTradePrice)); paramList.Add(dbUtilities.CreateSqlParamater("@assetPrice", SqlDbType.Decimal, ParameterDirection.Input, this.AssetPrice)); paramList.Add(dbUtilities.CreateSqlParamater("@bidPrice", SqlDbType.Decimal, ParameterDirection.Input, this.BidPrice)); paramList.Add(dbUtilities.CreateSqlParamater("@offerPrice", SqlDbType.Decimal, ParameterDirection.Input, this.OfferPrice)); paramList.Add(dbUtilities.CreateSqlParamater("@bidQty", SqlDbType.Int, ParameterDirection.Input, this.BidQty)); paramList.Add(dbUtilities.CreateSqlParamater("@offerQty", SqlDbType.Int, ParameterDirection.Input, this.OfferQty)); paramList.Add(dbUtilities.CreateSqlParamater("@tradedQty", SqlDbType.Int, ParameterDirection.Input, this.TradedQty)); paramList.Add(dbUtilities.CreateSqlParamater("@exchange", SqlDbType.SmallInt, ParameterDirection.Input, this.Exchange)); switch (cmdType) { case 0: paramList.Add(dbUtilities.CreateSqlParamater("@insertStatus", SqlDbType.Bit, ParameterDirection.Output)); break; case 1: paramList.Add(dbUtilities.CreateSqlParamater("@updateStatus", SqlDbType.Bit, ParameterDirection.Output)); break; } return(paramList); }