static GetScripFactory()
{
IScript lobjScrip = default(IScript);
System.Reflection.PropertyInfo[] lobjProperties = null;
Dictionary <string, PropertyInfo> lobjPropertiesMap = default(Dictionary <string, PropertyInfo>);
ExchangeColumnName_Map lobjExchangeColumnMap = default(ExchangeColumnName_Map);
IEnumerator <string> lIenum = ColumnNameFactory.GetExchangeColumnMapKeysEnum();
while (lIenum.MoveNext())
{
lobjPropertiesMap = new Dictionary <string, PropertyInfo>();
lobjExchangeColumnMap = ColumnNameFactory.GetExchangeColumnMap(lIenum.Current);
lobjScrip = IScripFactory.CreateInstance(lobjExchangeColumnMap.ClassType);
lobjProperties = lobjScrip.GetType().GetProperties(BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Instance);
for (Int16 lintTemp = 0; lintTemp <= lobjProperties.Count() - 1; lintTemp++)
{
lobjPropertiesMap.Add(lobjProperties[lintTemp].Name.ToUpper(), lobjProperties[lintTemp]);
}
Prototype_IScrips.Add(lIenum.Current, lobjScrip);
Prototype_ExchangeColumnMap.Add(lIenum.Current, lobjPropertiesMap);
}
CurrentDBProvider.ConnectTo(AppDomain.CurrentDomain.BaseDirectory, BowConstants.DATABASE_MASTERS);
}
/// <summary>
/// Returns Exchange Column Map for the given Key
/// </summary>
/// <param name="pstrKey">ExchangeID^MarketID</param>
/// <returns>ExchangeColumnName_Map</returns>
/// <remarks>Will return an Unknown Object as per NullObject Pattern if no matching entry is found </remarks>
static internal ExchangeColumnName_Map GetExchangeColumnMap(string pstrKey)
{
if (RegisteredExchangeColumnMap.ExchangeColumnMapColl.ContainsKey(pstrKey))
{
return(RegisteredExchangeColumnMap.ExchangeColumnMapColl.Values.Where(x => x.Key == pstrKey).FirstOrDefault());
}
else
{
ExchangeColumnName_Map lobjUnknown = new ExchangeColumnName_Map(-1, -1, "", "");
//: NullObjectPattern
lobjUnknown.ColumnName_Map.Add("ID".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("Token".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("InstrumentName".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("Symbol".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("Series".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("ExpiryDate".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("StrikePrice".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("OptionType".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("TickSize".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("Name".ToUpper(), "");
lobjUnknown.ColumnName_Map.Add("SequenceId".ToUpper(), "");
return(lobjUnknown);
}
}
public static long GetMax(int pintExchangeID, int pintMarketID, string pstrBaseColumnName, string pstrWhereClause = null)
{
string lstrQuery = "";
IDbCommand lobjCommand = default(IDbCommand);
List <string> lobjDistinctValues = new List <string>();
try
{
ExchangeColumnName_Map lobjExchangeColumnMap = ColumnNameFactory.GetExchangeColumnMap(pintExchangeID, pintMarketID);
if (!string.IsNullOrEmpty(lobjExchangeColumnMap.TableName) && TablesPresent.Contains(lobjExchangeColumnMap.TableName))
{
lstrQuery = "Select " + CurrentDBProvider.IsNull + "( Max (" + lobjExchangeColumnMap.ColumnName_Map.Where(x => x.Key == pstrBaseColumnName.ToUpper()).Select(x => x.Value) + "),0) From " + lobjExchangeColumnMap.TableName + " Where 1=1 ";
if (string.IsNullOrWhiteSpace(pstrWhereClause) == false)
{
lstrQuery += " And " + pstrWhereClause;
}
//HACK Introduced Locking only because the current version of SQLite dose not even supports concurrent select query.
//TODO This lock should be removed when we upgrade our SQLite dll.
lock (mobjLockObject)
{
if (OpenConnection())
{
lobjCommand = CurrentDBProvider.GetConnection.CreateCommand();
lobjCommand.CommandType = CommandType.Text;
lobjCommand.CommandTimeout = 90;
lobjCommand.CommandText = lstrQuery;
return(Convert.ToInt64(lobjCommand.ExecuteScalar()));
}
}
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " BaseColumn =" + pstrBaseColumnName + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct . Stack " + ex.StackTrace.ToString());
}
return(0);
}
/// <summary>
/// Collection of Properties supported by the instance of IScrip pertaining to the Exchange and Market passed in.
/// </summary>
/// <param name="pintExchangeID"></param>
/// <param name="pintMarketID"></param>
/// <returns>Dictionary of Properties in IScrip instance corresponding to the exchange and market passed in. Key = Name of the Property. Value = Instance of System.Reflection.PropertyInfo</returns>
/// <remarks></remarks>
private static Dictionary <string, System.Reflection.PropertyInfo> GetPropertyMap(int pintExchangeID, int pintMarketID)
{
return(Prototype_ExchangeColumnMap.Where(x => x.Key == ExchangeColumnName_Map.GenerateKey(pintExchangeID, pintMarketID)).Select(x => x.Value).FirstOrDefault());
}
/// <summary>
/// A new instance of Type IScrip, based on the Exchange and Market passed in
/// </summary>
/// <param name="pintExchangeID"></param>
/// <param name="pintMarketID"></param>
/// <returns>A new instance of Type IScrip</returns>
/// <remarks>Use this method to reduce creation time of instances of IScrip</remarks>
static internal IScript GetNewIScripObjectFor(int pintExchangeID, int pintMarketID)
{
return((IScript)Prototype_IScrips.Where(x => x.Key == ExchangeColumnName_Map.GenerateKey(pintExchangeID, pintMarketID)).Select(x => x.Value).FirstOrDefault().Clone());
}
public static string[] GetDistinct(int pintExchangeID, int pintMarketID, string pstrBaseColumnName, bool pblnAllowBlank = false, string pstrWhereClause = null, string pstrDivideBy = "")
{
string lstrQuery = "";
IDbCommand lobjCommand = default(IDbCommand);
List <string> lobjDistinctValues = new List <string>();
try
{
ExchangeColumnName_Map lobjExchangeColumnMap = ColumnNameFactory.GetExchangeColumnMap(pintExchangeID, pintMarketID);
if (!string.IsNullOrEmpty(lobjExchangeColumnMap.TableName) && TablesPresent.Contains(lobjExchangeColumnMap.TableName))
{
lstrQuery = "Select DISTINCT (" + lobjExchangeColumnMap.ColumnName_Map.Where(x => x.Value == pstrBaseColumnName.ToUpper()).Select(x => x.Value) + pstrDivideBy + ") From " + lobjExchangeColumnMap.TableName + " Where 1=1 ";
if (string.IsNullOrWhiteSpace(pstrWhereClause) == false)
{
lstrQuery += " And " + pstrWhereClause;
}
lstrQuery += " Order By " + lobjExchangeColumnMap.ColumnName_Map.Where(x => x.Value == pstrBaseColumnName.ToUpper()).Select(x => x.Value);
//HACK Introduced Locking only because the current version of SQLite dose not even supports concurrent select query.
//TODO This lock should be removed when we upgrade our SQLite dll.
lock (mobjLockObject)
{
if (OpenConnection())
{
lobjCommand = CurrentDBProvider.GetConnection.CreateCommand();
lobjCommand.CommandType = CommandType.Text;
lobjCommand.CommandTimeout = 90;
lobjCommand.CommandText = lstrQuery;
IDataReader lobjIDataReader = null;
try
{
lobjIDataReader = lobjCommand.ExecuteReader();
if (pblnAllowBlank)
{
lobjDistinctValues.Add("");
}
while (lobjIDataReader.Read())
{
lobjDistinctValues.Add(lobjIDataReader.GetString(0));
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct inner loop for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " BaseColumn =" + pstrBaseColumnName + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
}
finally
{
if ((lobjIDataReader != null))
{
lobjIDataReader.Close();
lobjIDataReader = null;
}
}
}
}
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " BaseColumn =" + pstrBaseColumnName + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct . Stack " + ex.StackTrace.ToString());
}
return(lobjDistinctValues.ToArray());
}
//public static ScriptCollection GetScrips(int pintExchangeID, int pintMarketID, string pstrWhereClause, ScriptCollection pobjScripCollection = null)
//{
// string lstrQuery = "";
// IDbCommand lobjCommand = default(IDbCommand);
// try
// {
// IScript lobjScrip = default(IScript);
// string lstrBaseFieldName = null;
// IEnumerator lEnum = default(IEnumerator);
// Dictionary<string, PropertyInfo> lobjPropertiesMap = GetPropertyMap(pintExchangeID, pintMarketID);
// ExchangeColumnName_Map lobjExchangeColumnMap = ColumnNameFactory.GetExchangeColumnMap(pintExchangeID, pintMarketID);
// if (!string.IsNullOrEmpty(lobjExchangeColumnMap.TableName) && TablesPresent.Contains(lobjExchangeColumnMap.TableName))
// {
// if (pobjScripCollection == null)
// {
// pobjScripCollection = new ScriptCollection();
// //: Reusing the same variable
// }
// lstrQuery = "Select * From " + lobjExchangeColumnMap.TableName + " Where 1=1 ";
// if (string.IsNullOrWhiteSpace(pstrWhereClause) == false)
// {
// lstrQuery += " And " + pstrWhereClause;
// }
// //HACK Introduced Locking only because the current version of SQLite dose not even supports concurrent select query.
// //TODO This lock should be removed when we upgrade our SQLite dll.
// lock (mobjLockObject)
// {
// if (OpenConnection())
// {
// lobjCommand = CurrentDBProvider.GetConnection.CreateCommand();
// lobjCommand.CommandType = CommandType.Text;
// lobjCommand.CommandTimeout = 90;
// lobjCommand.CommandText = lstrQuery;
// IDataReader lobjIDataReader = null;
// try
// {
// lobjIDataReader = lobjCommand.ExecuteReader();
// while (lobjIDataReader.Read())
// {
// lobjScrip = GetNewIScripObjectFor(pintExchangeID, pintMarketID);
// lEnum = lobjExchangeColumnMap.ColumnName_Map.Keys.GetEnumerator();
// while (lEnum.MoveNext())
// {
// lstrBaseFieldName = Convert.ToString(lEnum.Current).ToUpper();
// if (lobjPropertiesMap.ContainsKey(lstrBaseFieldName))
// {
// lobjPropertiesMap.Where(x=>x.Key==lstrBaseFieldName).Select(x=>x.Value).FirstOrDefault().SetValue(lobjScrip,
// Convert.ChangeType(lobjIDataReader[Convert.ToInt32(lobjExchangeColumnMap.ColumnName_Map.Where(x=>x.Key==lstrBaseFieldName).Select(x=>x.Value))],
// lobjPropertiesMap.Where(x => x.Key == lstrBaseFieldName).Select(x => x.Value).FirstOrDefault().PropertyType), null);
// }
// }
// lobjScrip.ExchangeId = pintExchangeID;
// lobjScrip.MarketId = pintMarketID;
// pobjScripCollection.Add(lobjScrip);
// }
// }
// catch (Exception ex)
// {
// Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetScrips Inner loop for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
// }
// finally
// {
// if ((lobjIDataReader != null))
// {
// lobjIDataReader.Close();
// lobjIDataReader = null;
// }
// }
// }
// }
// return pobjScripCollection;
// }
// }
// catch (Exception ex)
// {
// Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetScrips for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
// Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetScrips . Stack " + ex.StackTrace.ToString());
// }
// return null;
//}
public static string[] GetScrips(int pintExchangeID, int pintMarketID, string[] pstrBaseColumnName, string pstrWhereClause = null, string pstrQueryOpertaor = "")
{
System.Text.StringBuilder lobjQuery = new System.Text.StringBuilder();
IDbCommand lobjCommand = default(IDbCommand);
List <string> lobjDistinctValues = new List <string>();
try
{
ExchangeColumnName_Map lobjExchangeColumnMap = ColumnNameFactory.GetExchangeColumnMap(pintExchangeID, pintMarketID);
if (!string.IsNullOrEmpty(lobjExchangeColumnMap.TableName) && TablesPresent.Contains(lobjExchangeColumnMap.TableName))
{
lobjQuery.Append("Select ");
lobjQuery.Append(pstrQueryOpertaor);
if (pstrBaseColumnName.Count() > 1)
{
for (int lintTemp = 0; lintTemp <= pstrBaseColumnName.Count() - 1; lintTemp++)
{
lobjQuery.Append(lobjExchangeColumnMap.ColumnName_Map.Where(x => x.Key == pstrBaseColumnName[lintTemp]).Select(x => x.Value));
lobjQuery.Append(",");
}
}
else
{
lobjQuery.Append(lobjExchangeColumnMap.ColumnName_Map.Where(x => x.Key == pstrBaseColumnName[0]).Select(x => x.Value));
lobjQuery.Append(",");
}
lobjQuery.Remove(lobjQuery.Length - 1, 1);
lobjQuery.Append(" From ");
lobjQuery.Append(lobjExchangeColumnMap.TableName);
lobjQuery.Append(" Where 1=1 ");
if (string.IsNullOrWhiteSpace(pstrWhereClause) == false)
{
lobjQuery.Append(" And ");
lobjQuery.Append(pstrWhereClause);
}
lobjQuery.Append(" Order By 1");
//HACK Introduced Locking only because the current version of SQLite dose not even supports concurrent select query.
//TODO This lock should be removed when we upgrade our SQLite dll.
lock (mobjLockObject)
{
if (OpenConnection())
{
lobjCommand = CurrentDBProvider.GetConnection.CreateCommand();
lobjCommand.CommandType = CommandType.Text;
lobjCommand.CommandTimeout = 90;
lobjCommand.CommandText = lobjQuery.ToString();
IDataReader lobjIDataReader = null;
try
{
lobjIDataReader = lobjCommand.ExecuteReader();
System.Text.StringBuilder lstrValue = default(System.Text.StringBuilder);
while (lobjIDataReader.Read())
{
lstrValue = new System.Text.StringBuilder();
for (int lintTemp = 0; lintTemp <= pstrBaseColumnName.Count() - 1; lintTemp++)
{
lstrValue.Append(lobjIDataReader[lintTemp].ToString());
lstrValue.Append("|");
}
lobjDistinctValues.Add(lstrValue.ToString());
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct inner loop for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " Query =" + lobjQuery.ToString() + " Exception =" + ex.Message.ToString());
}
finally
{
if ((lobjIDataReader != null))
{
lobjIDataReader.Close();
lobjIDataReader = null;
}
}
}
}
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " Query =" + lobjQuery.ToString() + " Exception =" + ex.Message.ToString());
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetDistinct . Stack " + ex.StackTrace.ToString());
}
return(lobjDistinctValues.ToArray());
}
//public static Constants.ProductInfo GetProductInfo()
//{
// string lstrQuery = "Select Product from MasterInfo";
// IDbCommand lobjCommand = null;
// lock (mobjLockObject)
// {
// if (OpenConnection() && TablesPresent.Contains("MasterInfo"))
// {
// lobjCommand = CurrentDBProvider.GetConnection.CreateCommand();
// lobjCommand.CommandType = CommandType.Text;
// lobjCommand.CommandText = lstrQuery;
// IDataReader lobjIDataReader = null;
// try
// {
// lobjIDataReader = lobjCommand.ExecuteReader();
// if (lobjIDataReader.Read())
// {
// foreach (Array current_loopVariable in Enum.GetValues(typeof(Constants.ProductInfo)))
// {
// current = current_loopVariable;
// if (lobjIDataReader["Product"] == current)
// {
// return (current);
// }
// }
// }
// }
// catch (Exception ex)
// {
// Infrastructure.Logger.WriteLog("Error while getting Product Info" + ex.Message.ToString(), true);
// }
// finally
// {
// if ((lobjIDataReader != null))
// {
// lobjIDataReader.Close();
// lobjIDataReader = null;
// }
// }
// }
// }
// return Constants.ProductInfo.None;
//}
public static IScript GetScrip(int pintExchangeID, int pintMarketID, string pstrWhereClause)
{
string lstrQuery = "";
IDbCommand lobjCommand = null;
bool lblnScripFound = false;
try
{
IScript lobjScrip = GetNewIScripObjectFor(pintExchangeID, pintMarketID);
Dictionary <string, PropertyInfo> lobjPropertiesMap = GetPropertyMap(pintExchangeID, pintMarketID);
ExchangeColumnName_Map lobjExchangeColumnMap = ColumnNameFactory.GetExchangeColumnMap(pintExchangeID, pintMarketID);
if (!string.IsNullOrEmpty(lobjExchangeColumnMap.TableName) && TablesPresent.Contains(lobjExchangeColumnMap.TableName))
{
lstrQuery = "Select * From " + lobjExchangeColumnMap.TableName + " Where 1=1 ";
if (string.IsNullOrWhiteSpace(pstrWhereClause) == false)
{
lstrQuery += " And " + pstrWhereClause;
}
//HACK Introduced Locking only because the current version of SQLite dose not even supports concurrent select query.
//TODO This lock should be removed when we upgrade our SQLite dll.
lock (mobjLockObject)
{
if (OpenConnection())
{
lobjCommand = CurrentDBProvider.GetConnection.CreateCommand();
lobjCommand.CommandType = CommandType.Text;
lobjCommand.CommandTimeout = 90;
lobjCommand.CommandText = lstrQuery;
IDataReader lobjIDataReader = null;
try
{
lobjIDataReader = lobjCommand.ExecuteReader();
if (lobjIDataReader.Read())
{
lblnScripFound = true;
IEnumerator lEnum = lobjExchangeColumnMap.ColumnName_Map.Keys.GetEnumerator();
string lstrBaseFieldName = null;
while (lEnum.MoveNext())
{
lstrBaseFieldName = Convert.ToString(lEnum.Current).ToUpper();
if (lobjPropertiesMap.ContainsKey(lstrBaseFieldName))
{
lobjPropertiesMap.Where(x => x.Key == lstrBaseFieldName).Select(x => x.Value).FirstOrDefault().SetValue(lobjScrip,
Convert.ChangeType(lobjIDataReader[lobjExchangeColumnMap.ColumnName_Map.Where(x => x.Key == lstrBaseFieldName).Select(x => x.Value).FirstOrDefault()],
lobjPropertiesMap.Where(x => x.Key == lstrBaseFieldName).Select(x => x.Value).FirstOrDefault().PropertyType), null);
}
}
lobjScrip.ExchangeId = pintExchangeID;
lobjScrip.MarketId = pintMarketID;
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetScrip Inner Loop for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
}
finally
{
if ((lobjIDataReader != null))
{
lobjIDataReader.Close();
lobjIDataReader = null;
}
}
if ((lobjScrip) is UnknownScrip || lblnScripFound == false)
{
return(null);
}
else
{
return(lobjScrip);
}
}
}
}
}
catch (Exception ex)
{
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetScrip for Exchange=" + pintExchangeID.ToString() + " Market=" + pintMarketID.ToString() + " Query =" + lstrQuery + " Exception =" + ex.Message.ToString());
Infrastructure.Logger.WriteLog("Error in GetScripFactory.GetScrip . Stack " + ex.StackTrace.ToString());
}
return(null);
}
private static void InitializeFactory()
{
ExchangeColumnName_Map lobjExchangeColumnMap = default(ExchangeColumnName_Map);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 1, "BSESecurity", "Securities");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "SCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "SCSymbol");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "SCCompanyName");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "SCSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "BSCScripCode");
lobjExchangeColumnMap.ColumnName_Map.Add("ISIN".ToUpper(), "ISIN");
lobjExchangeColumnMap.ColumnName_Map.Add("Series".ToUpper(), "SCSeries");
lobjExchangeColumnMap.ColumnName_Map.Add("CompanyName".ToUpper(), "SCCompanyName");
lobjExchangeColumnMap.ColumnName_Map.Add("Group".ToUpper(), "BSCGroupName");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "BSCTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "BSCBoardLot");
lobjExchangeColumnMap.ColumnName_Map.Add("BSCFIELD4".ToUpper(), "BSCFIELD4");
//added by KiranS 15-MAR-17, ENH:BSE Securities GSM.
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 2, "BSEContract", "BSEContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "BCNID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "BCNTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "BCNINSTRUMENTTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "BCNASSETCODE");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "BCNEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "BCNSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "BCNOPTIONSTYLE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "BCNDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "BCNMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "BCNTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "BCNSeriesName");
lobjExchangeColumnMap.ColumnName_Map.Add("PQFactor".ToUpper(), "BCNPQFactor");
lobjExchangeColumnMap.ColumnName_Map.Add("TradingUnit".ToUpper(), "BCNTradingUnit");
lobjExchangeColumnMap.ColumnName_Map.Add("ProductType".ToUpper(), "BCNPRODUCTTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "BCNSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Group".ToUpper(), "BCNCapacityGroup");
lobjExchangeColumnMap.ColumnName_Map.Add("InBannedPeriod".ToUpper(), "BCNInBannedPeriod");
lobjExchangeColumnMap.ColumnName_Map.Add("Field3".ToUpper(), "BCNField3");
//added by KiranS 13-FEB-17
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 3, "BSECommodityContract", "BSECommodityContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "BCCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "BCCTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "BCCINSTRUMENTNAME");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "BCCCONTRACTCODE");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "BCCEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "BCCSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "BCCOPTIONTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "BCCDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "BCCBoardLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "BCCPriceTick");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "BCCContractCode");
lobjExchangeColumnMap.ColumnName_Map.Add("PQFactor".ToUpper(), "BCCPQFactor");
lobjExchangeColumnMap.ColumnName_Map.Add("TradingUnit".ToUpper(), "BCCTradingUnit");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "BCCSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Numerator".ToUpper(), "BCCGeneralNumerator");
lobjExchangeColumnMap.ColumnName_Map.Add("Denominator".ToUpper(), "BCCGeneralDenominator");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 4, "BSECurrencyContract", "NTACurrencyContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "NTACCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "NTACCTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("ScriptID".ToUpper(), "NTACCScriptID");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "NTACCINSTRUMENTTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "NTACCASSETCODE");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "NTACCEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "NTACCSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "NTACCOPTIONSTYLE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "NTACCDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "NTACCMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "NTACCTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "NTACCSeriesName");
lobjExchangeColumnMap.ColumnName_Map.Add("PQFactor".ToUpper(), "NTACCPQFactor");
lobjExchangeColumnMap.ColumnName_Map.Add("ProductType".ToUpper(), "NTACCProductType");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "NTACCSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Group".ToUpper(), "NTACCCapacityGroup");
lobjExchangeColumnMap.ColumnName_Map.Add("Multiplier".ToUpper(), "NTACCMultiplier");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 5, "MutualFund", "SCHEMEMASTER");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "UniqueNo");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "SchemeCode");
lobjExchangeColumnMap.ColumnName_Map.Add("RTASchemeCode".ToUpper(), "RTASchemeCode");
lobjExchangeColumnMap.ColumnName_Map.Add("AMCSchemeCode".ToUpper(), "AMCSchemeCode");
lobjExchangeColumnMap.ColumnName_Map.Add("ISIN".ToUpper(), "ISIN");
lobjExchangeColumnMap.ColumnName_Map.Add("AMCCode".ToUpper(), "AMCCode");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "SchemeName");
lobjExchangeColumnMap.ColumnName_Map.Add("PurchaseTransactionmode".ToUpper(), "PurchaseTransactionmode");
lobjExchangeColumnMap.ColumnName_Map.Add("MinimumPurchaseAmount".ToUpper(), "MinimumPurchaseAmount");
lobjExchangeColumnMap.ColumnName_Map.Add("AdditionalPurchaseAmountMultiple".ToUpper(), "AdditionalPurchaseAmountMultiple");
lobjExchangeColumnMap.ColumnName_Map.Add("MaximumPurchaseAmount".ToUpper(), "MaximumPurchaseAmount");
lobjExchangeColumnMap.ColumnName_Map.Add("PurchaseAllowed".ToUpper(), "PurchaseAllowed");
lobjExchangeColumnMap.ColumnName_Map.Add("PurchaseCutoffTime".ToUpper(), "PurchaseCutoffTime");
lobjExchangeColumnMap.ColumnName_Map.Add("RedemptionTransactionMode".ToUpper(), "RedemptionTransactionMode");
lobjExchangeColumnMap.ColumnName_Map.Add("MinimumRedemptionQty".ToUpper(), "MinimumRedemptionQty");
lobjExchangeColumnMap.ColumnName_Map.Add("RedemptionQtyMultiplier".ToUpper(), "RedemptionQtyMultiplier");
lobjExchangeColumnMap.ColumnName_Map.Add("MaximumRedemptionQty".ToUpper(), "MaximumRedemptionQty");
lobjExchangeColumnMap.ColumnName_Map.Add("RedemptionAllowed".ToUpper(), "RedemptionAllowed");
lobjExchangeColumnMap.ColumnName_Map.Add("RedemptionCutoffTime".ToUpper(), "RedemptionCutoffTime");
lobjExchangeColumnMap.ColumnName_Map.Add("RTAAgentCode".ToUpper(), "RTAAgentCode");
lobjExchangeColumnMap.ColumnName_Map.Add("AMCActiveFlag".ToUpper(), "AMCActiveFlag");
lobjExchangeColumnMap.ColumnName_Map.Add("DividendReinvestmentFlag".ToUpper(), "DividendReinvestmentFlag");
lobjExchangeColumnMap.ColumnName_Map.Add("SchemeType".ToUpper(), "SchemeType");
lobjExchangeColumnMap.ColumnName_Map.Add("SIPFLAG".ToUpper(), "SIPFLAG");
lobjExchangeColumnMap.ColumnName_Map.Add("STPFLAG".ToUpper(), "STPFLAG");
lobjExchangeColumnMap.ColumnName_Map.Add("SWPFLAG".ToUpper(), "SWPFLAG");
lobjExchangeColumnMap.ColumnName_Map.Add("SETTLEMENTTYPE".ToUpper(), "SETTLEMENTTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("PurchaseAmountMultiplier".ToUpper(), "PurchaseAmountMultiplier");
lobjExchangeColumnMap.ColumnName_Map.Add("NAV".ToUpper(), "NAV");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 6, "SLBContract", "SLBContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "SCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "SCScripCode");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "SCInstrumentName");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "SCScripId");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "SCLongExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "SCStrikePrice");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "SCOptionType");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "SCDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "SCMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "SCTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "SCProductCode");
lobjExchangeColumnMap.ColumnName_Map.Add("RollOver".ToUpper(), "SCRollOver");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "SCProductId");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 8, "BOND", "WDMContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "WDMID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "WDMScriptCode");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "WDMInstrumentName");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "WDMSymbol");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "WDMLongExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "WDMStrikePrice");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "WDMOptionType");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "WDMDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "WDMMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "WDMTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "WDMSymbol");
lobjExchangeColumnMap.ColumnName_Map.Add("Segment".ToUpper(), "WDMSegment");
lobjExchangeColumnMap.ColumnName_Map.Add("SettlementType".ToUpper(), "WDMSettlementType");
lobjExchangeColumnMap.ColumnName_Map.Add("ListingCategory".ToUpper(), "WDMListingCatagory");
lobjExchangeColumnMap.ColumnName_Map.Add("Standard".ToUpper(), "WDMInstrumentStandard");
lobjExchangeColumnMap.ColumnName_Map.Add("BondCategory".ToUpper(), "WDMBondCategory");
lobjExchangeColumnMap.ColumnName_Map.Add("GSecType".ToUpper(), "WDMGSecType");
lobjExchangeColumnMap.ColumnName_Map.Add("ISIN".ToUpper(), "WDMISIN");
lobjExchangeColumnMap.ColumnName_Map.Add("FaceValue".ToUpper(), "WDMFaceValue");
lobjExchangeColumnMap.ColumnName_Map.Add("IssueDate".ToUpper(), "WDMIssueDate");
lobjExchangeColumnMap.ColumnName_Map.Add("Coupon".ToUpper(), "WDMCoupon");
lobjExchangeColumnMap.ColumnName_Map.Add("IPPeriod".ToUpper(), "WDMIPPeriod");
lobjExchangeColumnMap.ColumnName_Map.Add("IPDuration".ToUpper(), "WDMIPDuration");
lobjExchangeColumnMap.ColumnName_Map.Add("IPPrevIPDate".ToUpper(), "WDMPrevIPDate");
lobjExchangeColumnMap.ColumnName_Map.Add("IPNextIPDate".ToUpper(), "WDMNextIPDate");
lobjExchangeColumnMap.ColumnName_Map.Add("AccruedIntrest".ToUpper(), "WDMAccruedIntrest");
lobjExchangeColumnMap.ColumnName_Map.Add("LastTradeingDate".ToUpper(), "WDMLastTradingDate");
lobjExchangeColumnMap.ColumnName_Map.Add("WDMExpiryDate".ToUpper(), "WDMExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("Status".ToUpper(), "WDMActiveSuspendFlag");
lobjExchangeColumnMap.ColumnName_Map.Add("ShutPeriodStartDate".ToUpper(), "WDMShutPeriodStartDate");
lobjExchangeColumnMap.ColumnName_Map.Add("ShutPeriodEndDate".ToUpper(), "WDMShutPeriodEndDate");
lobjExchangeColumnMap.ColumnName_Map.Add("RecordDate".ToUpper(), "WDMRecordDate");
lobjExchangeColumnMap.ColumnName_Map.Add("FirstCallDate".ToUpper(), "WDMFirstCallDate");
lobjExchangeColumnMap.ColumnName_Map.Add("FirstPutDate".ToUpper(), "WDMFirstPutDate");
lobjExchangeColumnMap.ColumnName_Map.Add("CrisilRating".ToUpper(), "WDMCrisilRating");
lobjExchangeColumnMap.ColumnName_Map.Add("CareRating".ToUpper(), "WDMCareRating");
lobjExchangeColumnMap.ColumnName_Map.Add("IcraRating".ToUpper(), "WDMIcraRating");
lobjExchangeColumnMap.ColumnName_Map.Add("FitchRating".ToUpper(), "WDMFitchRating");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 9, "BOND", "WDMContractsT0");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "WDMID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "WDMScriptCode");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "WDMInstrumentName");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "WDMSymbol");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "WDMLongExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "WDMStrikePrice");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "WDMOptionType");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "WDMDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "WDMMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "WDMTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "WDMSymbol");
lobjExchangeColumnMap.ColumnName_Map.Add("Segment".ToUpper(), "WDMSegment");
lobjExchangeColumnMap.ColumnName_Map.Add("SettlementType".ToUpper(), "WDMSettlementType");
lobjExchangeColumnMap.ColumnName_Map.Add("ListingCategory".ToUpper(), "WDMListingCatagory");
lobjExchangeColumnMap.ColumnName_Map.Add("Standard".ToUpper(), "WDMInstrumentStandard");
lobjExchangeColumnMap.ColumnName_Map.Add("BondCategory".ToUpper(), "WDMBondCategory");
lobjExchangeColumnMap.ColumnName_Map.Add("GSecType".ToUpper(), "WDMGSecType");
lobjExchangeColumnMap.ColumnName_Map.Add("ISIN".ToUpper(), "WDMISIN");
lobjExchangeColumnMap.ColumnName_Map.Add("FaceValue".ToUpper(), "WDMFaceValue");
lobjExchangeColumnMap.ColumnName_Map.Add("IssueDate".ToUpper(), "WDMIssueDate");
lobjExchangeColumnMap.ColumnName_Map.Add("Coupon".ToUpper(), "WDMCoupon");
lobjExchangeColumnMap.ColumnName_Map.Add("IPPeriod".ToUpper(), "WDMIPPeriod");
lobjExchangeColumnMap.ColumnName_Map.Add("IPDuration".ToUpper(), "WDMIPDuration");
lobjExchangeColumnMap.ColumnName_Map.Add("IPPrevIPDate".ToUpper(), "WDMPrevIPDate");
lobjExchangeColumnMap.ColumnName_Map.Add("IPNextIPDate".ToUpper(), "WDMNextIPDate");
lobjExchangeColumnMap.ColumnName_Map.Add("AccruedIntrest".ToUpper(), "WDMAccruedIntrest");
lobjExchangeColumnMap.ColumnName_Map.Add("LastTradeingDate".ToUpper(), "WDMLastTradingDate");
lobjExchangeColumnMap.ColumnName_Map.Add("WDMExpiryDate".ToUpper(), "WDMExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("Status".ToUpper(), "WDMActiveSuspendFlag");
lobjExchangeColumnMap.ColumnName_Map.Add("ShutPeriodStartDate".ToUpper(), "WDMShutPeriodStartDate");
lobjExchangeColumnMap.ColumnName_Map.Add("ShutPeriodEndDate".ToUpper(), "WDMShutPeriodEndDate");
lobjExchangeColumnMap.ColumnName_Map.Add("RecordDate".ToUpper(), "WDMRecordDate");
lobjExchangeColumnMap.ColumnName_Map.Add("FirstCallDate".ToUpper(), "WDMFirstCallDate");
lobjExchangeColumnMap.ColumnName_Map.Add("FirstPutDate".ToUpper(), "WDMFirstPutDate");
lobjExchangeColumnMap.ColumnName_Map.Add("CrisilRating".ToUpper(), "WDMCrisilRating");
lobjExchangeColumnMap.ColumnName_Map.Add("CareRating".ToUpper(), "WDMCareRating");
lobjExchangeColumnMap.ColumnName_Map.Add("IcraRating".ToUpper(), "WDMIcraRating");
lobjExchangeColumnMap.ColumnName_Map.Add("FitchRating".ToUpper(), "WDMFitchRating");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(1, 10, "ITPContract", "ITPContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "ITPID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "ITPScripCode");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "ITPInstrumenName");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "ITPScripID");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "ITPExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "ITPStrikePrice");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "ITPOptionType");
lobjExchangeColumnMap.ColumnName_Map.Add("Group".ToUpper(), "ITPGroupName");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "ITPDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "ITPMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "ITPTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "ITPScripName");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "ITPSequenceID");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(2, 1, "NSESecurity", "Securities");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "SCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "SCSymbol");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "SCCompanyName");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "SCSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "NSCToken");
lobjExchangeColumnMap.ColumnName_Map.Add("ISIN".ToUpper(), "ISIN");
lobjExchangeColumnMap.ColumnName_Map.Add("Series".ToUpper(), "SCSeries");
lobjExchangeColumnMap.ColumnName_Map.Add("CompanyName".ToUpper(), "SCCompanyName");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "NSCTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "NSCBoardLotQuantity");
lobjExchangeColumnMap.ColumnName_Map.Add("NSCIssueRate".ToUpper(), "BSCFIELD4");
//added by KiranS 12-APR-17, ENH:NSE Securities GSM.
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(2, 2, "NSEContract", "Contracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "NCNID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "NCNTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "NCNINSTRUMENTNAME");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "NCNSYMBOL");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "NCNEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "NCNSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "NCNOPTIONTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "DisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "NCNBoardLotQuantity");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "NCNTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "NCNName");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "NCNSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("ProductType".ToUpper(), "NCNPRODUCTTYPE");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(2, 4, "NSECurrencyContract", "NseCurrencyContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "NCCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "NCCCONTRACTTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "NCCINSTRUMENT");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "NCCSYMBOL");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "NCCEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "NCCSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "NCCOPTIONTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "NCCDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "NCCBoardLotQty");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "NCCTICKSIZE");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "NCCSYMBOL");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "NCCSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Multiplier".ToUpper(), "NCCMultiplier");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(3, 3, "NCDEXContract", "NCDEXContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "NCDID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "NCDTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "NCDINSTRUMENTNAME");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "NCDSYMBOL");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "NCDEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "NCDSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "NCDOPTIONTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "NCDDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "NCDBoardLotQuantity");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "NCDTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "NCDName");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "NCDSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Numerator".ToUpper(), "NCDPriceNumerator");
lobjExchangeColumnMap.ColumnName_Map.Add("Denominator".ToUpper(), "NCDPriceDenominator");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(4, 3, "NMCEContract", "NMCEContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "NMID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "NMTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "NMINSTRUMENTTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "NMASSETCODE");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "NMEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "NMSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "NMOPTIONSTYLE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "NMDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "NMMarketLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "NMTickSize");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "NMSeriesName");
lobjExchangeColumnMap.ColumnName_Map.Add("PQFactor".ToUpper(), "NMPQFactor");
lobjExchangeColumnMap.ColumnName_Map.Add("TradingUnit".ToUpper(), "NMTradingUnit");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "NMSequenceId");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(5, 3, "MCXContract", "MCXContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "MCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "MCTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "MCINSTRUMENTNAME");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "MCCONTRACTCODE");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "MCEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "MCSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "MCOPTIONTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "MCDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "MCBoardLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "MCPriceTick");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "MCContractCode");
lobjExchangeColumnMap.ColumnName_Map.Add("PQFactor".ToUpper(), "MCPQFactor");
lobjExchangeColumnMap.ColumnName_Map.Add("TradingUnit".ToUpper(), "MCTradingUnit");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "MCSequenceId");
lobjExchangeColumnMap.ColumnName_Map.Add("Numerator".ToUpper(), "MCGeneralNumerator");
lobjExchangeColumnMap.ColumnName_Map.Add("Denominator".ToUpper(), "MCGeneralDenominator");
lobjExchangeColumnMap.ColumnName_Map.Add("QuotationUnit".ToUpper(), "MCQuotationUnit");
//Vijayalakshmi - 29Sep2016 - MCX changes suggested by Anjul
lobjExchangeColumnMap.ColumnName_Map.Add("TradingUnitDisplay".ToUpper(), "MCField3");
//Vijayalakshmi - 07Oct2016 - MCX changes suggested by Avinash
lobjExchangeColumnMap.ColumnName_Map.Add("QuotationMetric".ToUpper(), "MCQuotationMetric");
//Vijayalakshmi - 07Oct2016 - MCX changes suggested by Avinash
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(5, 4, "MCXCurrencyContract", "MCXCurrencyContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "MCCID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "MCCTOKEN");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "MCCINSTRUMENTNAME");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "MCCCONTRACTCODE");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "MCCEXPIRYDATE");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "MCCSTRIKEPRICE");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "MCCOPTIONTYPE");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "MCCDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "MCCBoardLot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "MCCPriceTick");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "MCCContractCode");
lobjExchangeColumnMap.ColumnName_Map.Add("PQFactor".ToUpper(), "MCCPQFactor");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "MCCSequenceId");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(8, 3, "DGCXContract", "DGCXContracts");
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "DGCXID");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "DGCXOrderbookId");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "DGCXInstrument");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "DGCXContractIdentifire");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "DGCXIntExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "DGCXStrikePrice");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "DGCXOptionType");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "DGCXDisplayExpiryDate");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "DGCXTradablelot");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "DGCXPriceTick");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "DGCXSegmentName");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "DGCXSequenceId");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
lobjExchangeColumnMap = new ExchangeColumnName_Map(-1, -1, "", "");
//: NullObjectPattern
lobjExchangeColumnMap.ColumnName_Map.Add("ID".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("Token".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("InstrumentName".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("Symbol".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("Series".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("ExpiryDate".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("StrikePrice".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("OptionType".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("DisplayExpiryDate".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("BoardLotQuantity".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("TickSize".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("Name".ToUpper(), "");
lobjExchangeColumnMap.ColumnName_Map.Add("SequenceId".ToUpper(), "");
ExchangeColumnMapColl.Add(lobjExchangeColumnMap.Key, lobjExchangeColumnMap);
}
/// <summary>
/// Returns Exchange Column Map for the given Exchange and Market
/// </summary>
/// <param name="pintExchangeID">Exchange ID</param>
/// <param name="pintMarketID">Market ID</param>
/// <returns>An instance of ExchangeColumnName_Map</returns>
/// <remarks></remarks>
static internal ExchangeColumnName_Map GetExchangeColumnMap(int pintExchangeID, int pintMarketID)
{
return(GetExchangeColumnMap(ExchangeColumnName_Map.GenerateKey(pintExchangeID, pintMarketID)));
}
