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