public int Post(Models.UserAlert value) { try { Data.TrnUserAlert newUserAlert = new Data.TrnUserAlert(); var userId = (from d in db.MstUsers where d.UserName.Equals(value.User) select d).FirstOrDefault().Id; DateTime dt = Convert.ToDateTime(value.EncodedDate); SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day)); newUserAlert.UserId = userId; newUserAlert.Description = value.Description; newUserAlert.IsActive = value.IsActive; newUserAlert.EncodedDate = EncodedDate.Value; newUserAlert.AlertVia = value.AlertVia; newUserAlert.SymbolFilter = value.SymbolFilter; newUserAlert.SymbolExchange = value.SymbolExchange; newUserAlert.SymbolUserFavoritesId = value.SymbolUserFavoritesId; newUserAlert.StrategyFilter = value.StrategyFilter; newUserAlert.Strategy = value.Strategy; newUserAlert.StrategyGrowthDecayRate = value.StrategyGrowthDecayRate; newUserAlert.StrategyGrowthDecayTime = value.StrategyGrowthDecayTime; newUserAlert.MACDFilter = value.MACDFilter; newUserAlert.MACDCrossover = value.MACDCrossover; newUserAlert.MACDEMA = value.MACDEMA; newUserAlert.MagentaChannelFilter = value.MagentaChannelFilter; newUserAlert.MagentaChannelBegins = value.MagentaChannelBegins; newUserAlert.MagentaChannelCorrelation30 = value.MagentaChannelCorrelation30; newUserAlert.MagentaChannelDays = value.MagentaChannelDays; newUserAlert.MagentaChannelAGRADR = value.MagentaChannelAGRADR; newUserAlert.SeasonalityFilter = value.SeasonalityFilter; newUserAlert.SeasonalityTrend = value.SeasonalityTrend == null ? "30" : value.SeasonalityTrend; newUserAlert.SeasonalityWinLossPercent = value.SeasonalityWinLossPercent; newUserAlert.SeasonalityGainLossPercent = value.SeasonalityGainLossPercent; newUserAlert.AdditionalFilter = value.AdditionalFilter; newUserAlert.AdditionalFilterPrice = value.AdditionalFilterPrice; newUserAlert.AdditionalFilterVolume = value.AdditionalFilterVolume; newUserAlert.AdditionalFilterNoOfYears = value.AdditionalFilterNoOfYears; db.TrnUserAlerts.InsertOnSubmit(newUserAlert); db.SubmitChanges(); GetResultSymbols(newUserAlert.Id); return(newUserAlert.Id); } catch { return(0); } }
public HttpResponseMessage Put(String Id, Models.UserAlert value) { Id = Id.Replace(",", ""); int id = Convert.ToInt32(Id); try { var userAlerts = from d in db.TrnUserAlerts where d.Id == id select d; if (userAlerts.Any()) { var updateUserAlert = userAlerts.FirstOrDefault(); DateTime dt = Convert.ToDateTime(value.EncodedDate); SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day)); updateUserAlert.Description = value.Description; updateUserAlert.Strategy = value.Strategy; updateUserAlert.Exchange = value.Exchange; updateUserAlert.Price = value.Price; updateUserAlert.Volume = value.Volume; updateUserAlert.GrowthDecayRate = value.GrowthDecayRate; updateUserAlert.GrowthDecayTime = value.GrowthDecayTime; updateUserAlert.NoOfYears = value.NoOfYears; updateUserAlert.Correlation30 = value.Correlation30; updateUserAlert.MACDOccurrence = value.MACDOccurrence; updateUserAlert.IsActive = value.IsActive; updateUserAlert.EncodedDate = EncodedDate.Value; updateUserAlert.AlertVia = value.AlertVia; db.SubmitChanges(); GetResultSymbols(updateUserAlert.Id); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (NullReferenceException) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public int Post(Models.UserAlert value) { try { Data.TrnUserAlert newUserAlert = new Data.TrnUserAlert(); var userId = (from d in db.MstUsers where d.UserName.Equals(value.User) select d).FirstOrDefault().Id; DateTime dt = Convert.ToDateTime(value.EncodedDate); SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day)); newUserAlert.UserId = userId; newUserAlert.Description = value.Description; newUserAlert.Strategy = value.Strategy; newUserAlert.Exchange = value.Exchange; newUserAlert.Price = value.Price; newUserAlert.Volume = value.Volume; newUserAlert.GrowthDecayRate = value.GrowthDecayRate; newUserAlert.GrowthDecayTime = value.GrowthDecayTime; newUserAlert.NoOfYears = value.NoOfYears; newUserAlert.Correlation30 = value.Correlation30; newUserAlert.MACDOccurrence = value.MACDOccurrence; newUserAlert.IsActive = value.IsActive; newUserAlert.EncodedDate = EncodedDate.Value; newUserAlert.AlertVia = value.AlertVia; db.TrnUserAlerts.InsertOnSubmit(newUserAlert); db.SubmitChanges(); GetResultSymbols(newUserAlert.Id); return(newUserAlert.Id); } catch { return(0); } }
public HttpResponseMessage Put(String Id, Models.UserAlert value) { Id = Id.Replace(",", ""); int id = Convert.ToInt32(Id); try { var userAlerts = from d in db.TrnUserAlerts where d.Id == id select d; if (userAlerts.Any()) { var updateUserAlert = userAlerts.FirstOrDefault(); DateTime dt = Convert.ToDateTime(value.EncodedDate); SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day)); updateUserAlert.Description = value.Description; updateUserAlert.Strategy = value.Strategy; updateUserAlert.IsActive = value.IsActive; updateUserAlert.EncodedDate = EncodedDate.Value; updateUserAlert.AlertVia = value.AlertVia; updateUserAlert.SymbolFilter = value.SymbolFilter; updateUserAlert.SymbolExchange = value.SymbolExchange; updateUserAlert.SymbolUserFavoritesId = value.SymbolUserFavoritesId; updateUserAlert.StrategyFilter = value.StrategyFilter; updateUserAlert.Strategy = value.Strategy; updateUserAlert.StrategyGrowthDecayRate = value.StrategyGrowthDecayRate; updateUserAlert.StrategyGrowthDecayTime = value.StrategyGrowthDecayTime; updateUserAlert.MACDFilter = value.MACDFilter; updateUserAlert.MACDCrossover = value.MACDCrossover; updateUserAlert.MACDEMA = value.MACDEMA; updateUserAlert.MagentaChannelFilter = value.MagentaChannelFilter; updateUserAlert.MagentaChannelBegins = value.MagentaChannelBegins; updateUserAlert.MagentaChannelCorrelation30 = value.MagentaChannelCorrelation30; updateUserAlert.MagentaChannelDays = value.MagentaChannelDays; updateUserAlert.MagentaChannelAGRADR = value.MagentaChannelAGRADR; updateUserAlert.SeasonalityFilter = value.SeasonalityFilter; updateUserAlert.SeasonalityTrend = value.SeasonalityTrend == null ? "30" : value.SeasonalityTrend; updateUserAlert.SeasonalityWinLossPercent = value.SeasonalityWinLossPercent; updateUserAlert.SeasonalityGainLossPercent = value.SeasonalityGainLossPercent; updateUserAlert.AdditionalFilter = value.AdditionalFilter; updateUserAlert.AdditionalFilterPrice = value.AdditionalFilterPrice; updateUserAlert.AdditionalFilterVolume = value.AdditionalFilterVolume; updateUserAlert.AdditionalFilterNoOfYears = value.AdditionalFilterNoOfYears; db.SubmitChanges(); GetResultSymbols(updateUserAlert.Id); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (NullReferenceException) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }