private void JassWatcher_Created(object sender, System.IO.FileSystemEventArgs e) { try { P_ErrorLib.WriteErrorLog("File Dropped New"); GetProcess(e.FullPath, e.Name); } catch (Exception ex) { P_ErrorLib.WriteErrorLog(ex); } }
public void GetProcess(string filePath, string fileName) { try { P_ErrorLib.WriteErrorLog("Start Process"); P_ErrorLib.WriteErrorLog(filePath); string extension = fileName.Substring(fileName.LastIndexOf('.') + 1); P_ErrorLib.WriteErrorLog(extension); if (extension == "xls" || extension == "XLS") { DataTable dt = P_ErrorLib.Read(filePath, "Security"); if (fileName.Contains("eq")) { if (fileName.Contains("INSERT")) { SetEquity(dt, "INSERT"); P_ErrorLib.WriteErrorLog("INSERTED"); } else if (fileName.Contains("DELETE")) { SetEquity(dt, "DELETE"); P_ErrorLib.WriteErrorLog("DELETED"); } else if (fileName.Contains("UPDATE")) { SetEquity(dt, "UPDATE"); P_ErrorLib.WriteErrorLog("UPDATED"); } else { P_ErrorLib.WriteErrorLog("IN XLS ERROR FORMAT"); } } else if (fileName.Contains("cb")) { if (fileName.Contains("INSERT")) { SetBond(dt, "INSERT"); P_ErrorLib.WriteErrorLog("INSERTED"); } else if (fileName.Contains("DELETE")) { SetBond(dt, "DELETE"); P_ErrorLib.WriteErrorLog("DELETED"); } else if (fileName.Contains("UPDATE")) { SetBond(dt, "UPDATE"); P_ErrorLib.WriteErrorLog("UPDATED"); } else { P_ErrorLib.WriteErrorLog("IN XLS ERROR FORMAT"); } } } else { P_ErrorLib.WriteErrorLog("File Format Not Supported."); } } catch (Exception ex) { P_ErrorLib.WriteErrorLog("ex"); P_ErrorLib.WriteErrorLog(ex); } }
public bool SetBond(DataTable dt, string type) { try { P_ErrorLib.WriteErrorLog("SET BOND"); P_SP_Ivp_Polaris_CbFull objCls = new P_SP_Ivp_Polaris_CbFull(); foreach (DataRow dr in dt.Rows) { objCls._security_Id = dr["security_id"] == DBNull.Value ? 0 : Convert.ToInt64(dr["security_id"]); objCls._securiry_Name = dr["securiry_name"].ToString(); objCls._securiry_Description = dr["securiry_description"].ToString(); objCls._asset_Type = Convert.ToString(dr["asset_Type"]); objCls._investment_Type = Convert.ToString(dr["investment_Type"]); objCls._trading_Factor = Convert.ToString(dr["trading_factor"]); objCls._pricing_Factor = dr["pricing_factor"].ToString(); objCls._created_By = dr["created_by"].ToString(); objCls._created_On = Convert.ToDateTime(dr["created_on"]); objCls._last_Modified_By = dr["last_modified_by"].ToString(); objCls._last_Modified_On = Convert.ToDateTime(dr["last_modified_on"]); objCls._is_Active = Convert.ToBoolean(dr["is_active"]); objCls._first_Coupon_Date = Convert.ToDateTime(dr["first_coupon_date"]); objCls._coupon_Cap = dr["coupon_cap"].ToString(); objCls._coupon_Floor = dr["coupon_floor"].ToString(); objCls._coupon_Frequency = Convert.ToString(dr["coupon_frequency"]); objCls._coupon_Rate = dr["coupon_rate"].ToString(); objCls._coupon_Type = Convert.ToString(dr["coupon_type"]); objCls._float_Spread = dr["float_spread"].ToString(); objCls._is_Callable = Convert.ToBoolean(dr["is_callable"]); objCls._is_Fix_To_Float = Convert.ToBoolean(dr["is_fix_to_float"]); objCls._is_Putable = Convert.ToBoolean(dr["is_putable"]); objCls._issue_Date = Convert.ToDateTime(dr["issue_date"]); objCls._last_Reset_Date = Convert.ToDateTime(dr["last_reset_date"]); objCls._maturity_Date = Convert.ToDateTime(dr["maturity_date"]); objCls._maximum_Call_Notice_Days = Convert.ToInt64(dr["maximum_call_notice_days"]); objCls._maximum_Put_Notice_Days = Convert.ToInt64(dr["maximum_put_notice_days"]); objCls._penultimate_Coupon_Date = Convert.ToDateTime(dr["penultimate_coupon_date"]); objCls._reset_Frequency = dr["reset_frequency"].ToString(); objCls._has_Position = Convert.ToBoolean(dr["has_position"]); objCls._form_Pf_Asset_Class = dr["form_pf_asset_class"].ToString(); objCls._form_Pf_Country = dr["form_pf_country"].ToString(); objCls._form_Pf_Credit_Rating = dr["form_pf_credit_rating"].ToString(); objCls._form_Pf_Currency = dr["form_pf_currency"].ToString(); objCls._form_Pf_Instrument = dr["form_pf_instrument"].ToString(); objCls._form_Pf_Liquid_Profile = dr["form_pf_liquidity_profile"].ToString(); objCls._form_Pf_Maturity = dr["form_pf_maturity"].ToString(); objCls._form_Pf_Naics_Code = dr["form_pf_naics_code"].ToString(); objCls._form_Pf_Region = dr["form_pf_region"].ToString(); objCls._form_Pf_Sector = dr["form_pf_sector"].ToString(); objCls._form_Pf_Sub_Asset_Class = dr["form_pf_sub_asset_class"].ToString(); objCls._firstcouponcode = dr["firstcouponcode"].ToString(); objCls._duration = dr["duration"].ToString(); objCls._volatility_ThirtyD = dr["volatility_thirtyD"].ToString(); objCls._volatility_NintyD = dr["volatility_nintyD"].ToString(); objCls._convexity = dr["convexity"].ToString(); objCls._average_Volume_ThirtyD = dr["average_volume_thirtyD"].ToString(); objCls._issue_Country = dr["issue_country"].ToString(); objCls._exchange = dr["exchange"].ToString(); objCls._issuer = dr["issuer"].ToString(); objCls._issue_Currency = dr["issue_currency"].ToString(); objCls._trading_Currency = dr["trading_currency"].ToString(); objCls._bloomberg_Industry_Sub_Group = dr["bloomberg_industry_sub_group"].ToString(); objCls._bloomberg_Industry_Group = dr["bloomberg_industry_group"].ToString(); objCls._bloomberg_Industry_Sector = dr["bloomberg_industry_sector"].ToString(); objCls._country_Of_Incorporation = dr["country_of_incorporation"].ToString(); objCls._risk_Currency = dr["risk_currency"].ToString(); objCls._cusip = dr["cusip"].ToString(); objCls._isin = dr["isin"].ToString(); objCls._sedol = dr["sedol"].ToString(); objCls._bloomberg_Ticker = dr["bloomberg_ticker"].ToString(); objCls._bloomberg_Unique_Id = Convert.ToInt32(dr["bloomberg_unique_id"]); objCls._bloomberg_Global_Id = Convert.ToInt32(dr["bloomberg_global_id"]); objCls._call_Date = Convert.ToDateTime(dr["call_date"]); objCls._call_Price = Convert.ToDecimal(dr["call_price"]); objCls._put_Date = Convert.ToDateTime(dr["put_date"]); objCls._put_Price = Convert.ToDecimal(dr["put_price"]); objCls._ask_Price = Convert.ToDecimal(dr["ask_price"]); objCls._high_Price = Convert.ToDecimal(dr["high_price"]); objCls._low_Price = Convert.ToDecimal(dr["low_price"]); objCls._open_Price = Convert.ToDecimal(dr["open_price"]); objCls._volume = Convert.ToInt64(dr["volume"]); objCls._bid_Price = Convert.ToDecimal(dr["bid_price"]); objCls._last_Price = Convert.ToDecimal(dr["last_price"]); objCls.Insert_Update_Delete_CB(objCls, type); } return(true); } catch (Exception ex) { P_ErrorLib.WriteErrorLog("SP ERROR"); P_ErrorLib.WriteErrorLog(ex); throw ex; } }
protected override void OnStart(string[] args) { // TODO: Add code here to start your service. JassWatcher.Path = ConfigurationManager.AppSettings["FileWatch"]; P_ErrorLib.WriteErrorLog("Service Started"); }
public bool SetEquity(DataTable dt, string type) { try { P_ErrorLib.WriteErrorLog("SET EQUITY"); P_SP_Ivp_Polaris_EqFull objCls = new P_SP_Ivp_Polaris_EqFull(); foreach (DataRow dr in dt.Rows) { objCls._security_Id = dr["security_id"] == DBNull.Value ? 0 : Convert.ToInt64(dr["security_id"]); objCls._securiry_Name = dr["securiry_name"].ToString(); objCls._securiry_Description = dr["securiry_description"].ToString(); objCls._has_Position = Convert.ToBoolean(dr["has_position"]); objCls._is_Active = Convert.ToBoolean(dr["is_active"]); objCls._round_Lot_Size = Convert.ToInt32(dr["round_lot_size"]); objCls._bloomberg_Unique_Name = dr["bloomberg_unique_name"].ToString(); objCls._created_By = dr["created_by"].ToString(); objCls._created_On = Convert.ToDateTime(dr["created_on"]); objCls._last_Modified_By = dr["last_modified_by"].ToString(); objCls._last_Modified_On = Convert.ToDateTime(dr["last_modified_on"]); objCls._is_Adr = Convert.ToBoolean(dr["is_adr"]); objCls._adr_Underlying_Ticker = dr["adr_underlying_ticker"].ToString(); objCls._adr_Underlying_Currency = dr["adr_underlying_currency"].ToString(); objCls._shares_Per_Adr = dr["shares_per_adr"].ToString(); objCls._ipo_Date = Convert.ToDateTime(dr["ipo_date"]); objCls._price_Currency = dr["price_currency"].ToString(); objCls._settle_Days = Convert.ToInt32(dr["settle_days"]); objCls._shares_Outstanding = dr["shares_outstanding"].ToString(); objCls._voting_Rights_Per_Share = dr["voting_rights_per_share"].ToString(); objCls._form_Pf_Asset_Class = dr["form_pf_asset_class"].ToString(); objCls._form_Pf_Country = dr["form_pf_country"].ToString(); objCls._form_Pf_Credit_Rating = dr["form_pf_credit_rating"].ToString(); objCls._form_Pf_Currency = dr["form_pf_currency"].ToString(); objCls._form_Pf_Instrument = dr["form_pf_instrument"].ToString(); objCls._form_Pf_Liquid_Profile = dr["form_pf_liquid_profile"].ToString(); objCls._form_Pf_Maturity = dr["form_pf_maturity"].ToString(); objCls._form_Pf_Naics_Code = dr["form_pf_naics_code"].ToString(); objCls._form_Pf_Region = dr["form_pf_region"].ToString(); objCls._form_Pf_Sector = dr["form_pf_sector"].ToString(); objCls._form_Pf_Sub_Asset_Class = dr["form_pf_sub_asset_class"].ToString(); objCls._twenty_Day_Average_Volume = dr["twenty_day_average_volume"].ToString(); objCls._beta = dr["beta"].ToString(); objCls._short_Interest = dr["short_interest"].ToString(); objCls._ytd_Return = dr["ytd_return"].ToString(); objCls._ninty_Day_Price_Volatility = dr["ninty_day_price_volatility"].ToString(); objCls._issue_Country = dr["issue_country"].ToString(); objCls._exchange = dr["exchange"].ToString(); objCls._issuer = dr["issuer"].ToString(); objCls._issue_Currency = dr["issue_currency"].ToString(); objCls._trading_Currency = dr["trading_currency"].ToString(); objCls._bloomberg_Industry_Sub_Group = dr["bloomberg_industry_sub_group"].ToString(); objCls._bloomberg_Industry_Group = dr["bloomberg_industry_group"].ToString(); objCls._bloomberg_Industry_Sector = dr["bloomberg_industry_sector"].ToString(); objCls._country_Of_Incorporation = dr["country_of_incorporation"].ToString(); objCls._risk_Currency = dr["risk_currency"].ToString(); objCls._cusip = dr["cusip"].ToString(); objCls._isin = dr["isin"].ToString(); objCls._sedol = dr["sedol"].ToString(); objCls._bloomberg_Ticker = dr["bloomberg_ticker"].ToString(); objCls._bloomberg_Unique_Id = Convert.ToInt32(dr["bloomberg_unique_id"]); objCls._bloomberg_Global_Id = Convert.ToInt32(dr["bloomberg_global_id"]); objCls._open_Price = Convert.ToDecimal(dr["open_price"]); objCls._close_Price = Convert.ToDecimal(dr["close_price"]); objCls._volume = Convert.ToInt64(dr["volume"]); objCls._last_Price = Convert.ToDecimal(dr["last_price"]); objCls._ask_Price = Convert.ToDecimal(dr["ask_price"]); objCls._bid_Price = Convert.ToDecimal(dr["bid_price"]); objCls._pe_Ratio = float.Parse(dr["pe_ratio"].ToString()); objCls._declared_Date = Convert.ToDateTime(dr["declared_date"]); objCls._ex_Date = Convert.ToDateTime(dr["ex_date"]); objCls._record_Date = Convert.ToDateTime(dr["record_date"]); objCls._pay_Date = Convert.ToDateTime(dr["pay_date"]); objCls._amount = Convert.ToDecimal(dr["amount"]); objCls._frequency = dr["frequency"].ToString(); objCls._dividend_Type = dr["dividend_type"].ToString(); objCls.Insert_Update_Delete_EQ(objCls, type); } return(true); } catch (Exception ex) { P_ErrorLib.WriteErrorLog("SP ERROR"); P_ErrorLib.WriteErrorLog(ex); throw ex; } }