/// <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);
}
